hash-threshold 8
statement ok
CREATE TABLE t1( x INTEGER, y VARCHAR(8) )
statement ok
INSERT INTO t1 VALUES(1,'true')
statement ok
INSERT INTO t1 VALUES(0,'false')
statement ok
INSERT INTO t1 VALUES(NULL,'NULL')
statement ok
CREATE INDEX t1i1 ON t1(x)
# EVIDENCE-OF: R-42037-15614 The DROP INDEX statement removes an index
# added with the CREATE INDEX statement.
skipif mssql
statement ok
DROP INDEX t1i1;
# this should error, as already dropped
skipif mssql
statement error
DROP INDEX t1i1;
# this should error, as never existed
skipif mssql
statement error
DROP INDEX tXiX;