sqllogictest
Artifact Content
Not logged in

Artifact 651c06bad9dbdde098adf6cb67ab73b9502aeea6:


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-01463-03846 The DROP TABLE statement removes a table
# added with the CREATE TABLE statement.

statement ok
DROP TABLE t1

# already dropped
statement error
DROP TABLE t1

# never existed
statement error
DROP TABLE tX

# TBD-EVIDENCE-OF: R-40197-14811 The dropped table is completely removed
# from the database schema and the disk file.

# EVIDENCE-OF: R-33950-57093 All indices and triggers associated with
# the table are also deleted.

# this should error, as was dropped with table
statement error
DROP INDEX t1i1;

# PARTIAL-EVIDENCE-OF: R-57089-01510 The optional IF EXISTS clause suppresses
# the error that would normally result if the table does not exist.

statement ok
CREATE TABLE t1( x INTEGER, y VARCHAR(8) )

skipif mssql
statement ok
DROP TABLE IF EXISTS t1

skipif mssql
statement ok
DROP TABLE IF EXISTS t1