Spracherkennung für: .test vermutete Sprache: SQL {SQL[253] R[105] VDM[69]} [Methode: maximale Elemente, drei Dimensionen]
CREATE TABLE t1(a INT, b INT);
CREATE INDEX IF NOT EXISTS i1 ON t1(a);
SHOW CREATE TABLE t1;
DROP INDEX IF EXISTS i1 ON t1;
SHOW CREATE TABLE t1;
DROP INDEX IF EXISTS i1 ON t1;
SHOW CREATE TABLE t1;
CREATE OR REPLACE INDEX i1 ON t1(a);
SHOW CREATE TABLE t1;
CREATE OR REPLACE INDEX i1 ON t1(a,b);
SHOW CREATE TABLE t1;
DROP TABLE t1;
--error ER_WRONG_USAGE
CREATE OR REPLACE INDEX IF NOT EXISTS i1 ON t1(b,a);
--echo #
--echo # MDEV-35021 Behavior for RTREE indexes changed, assertion fails
--echo #
create table t (f int not null);
--error ER_WRONG_ARGUMENTS
create index ind using rtree on t (f);
drop table t;
--echo # End of 11.7 tests
[Dauer der Verarbeitung: 0.14 Sekunden, vorverarbeitet 2026-10-08]
