000001  hash-threshold 8
000002  
000003  statement ok
000004  CREATE TABLE t1( x INTEGER, y VARCHAR(8) )
000005  
000006  statement ok
000007  INSERT INTO t1 VALUES(1,'true')
000008  
000009  statement ok
000010  INSERT INTO t1 VALUES(0,'false')
000011  
000012  statement ok
000013  INSERT INTO t1 VALUES(NULL,'NULL')
000014  
000015  statement ok
000016  CREATE INDEX t1i1 ON t1(x)
000017  
000018  
000019  # EVIDENCE-OF: R-42037-15614 The DROP INDEX statement removes an index
000020  # added with the CREATE INDEX statement.
000021  
000022  skipif mssql
000023  statement ok
000024  DROP INDEX t1i1;
000025  
000026  # this should error, as already dropped
000027  skipif mssql
000028  statement error
000029  DROP INDEX t1i1;
000030  
000031  # this should error, as never existed
000032  skipif mssql
000033  statement error
000034  DROP INDEX tXiX;