Artifact 78b86ef3371e0d4c025cb274366cf79e24c7cdb0:

• File test/evidence/slt_lang_dropindex.test — part of check-in [bf3dafd972] at 2014-02-11 07:54:58 on branch trunk — Skip MSSQL for several tests that are incompatible with it. (user: mistachkin size: 621)

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;