sqllogictest
Artifact Content
Not logged in

Artifact 91f08b61776b2bd7e637cd9d683930dea587abec:


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)

# There is no REINDEX in the SQL92 standard.
# So far, this only runs well on SQLite and Postgres.
# I believe MySQL uses the form REPAIR TABLE [tbl_name].

# skip this entire file if ms sql server
onlyif mssql
halt

# skip this entire file if oracle
onlyif oracle
halt

# skip this entire file if oracle
onlyif mysql
halt

# EVIDENCE-OF: R-52173-44778 The REINDEX command is used to delete and
# recreate indices from scratch.

statement ok
REINDEX t1i1

statement error
REINDEX tXiX

# TBD-EVIDENCE-OF: R-38396-20088 In the first form, all indices in all
# attached databases that use the named collation sequence are
# recreated.

# TBD-EVIDENCE-OF: R-46980-03026 In the second form, if
# [database-name.]table/index-name identifies a table, then all indices
# associated with the table are rebuilt.

# TBD-EVIDENCE-OF: R-50401-40957 If an index is identified, then only this
# specific index is deleted and recreated.

# TBD-EVIDENCE-OF: R-59524-35239 If no database-name is specified and there
# exists both a table or index and a collation sequence of the specified
# name, then indices associated with the collation sequence only are
# reconstructed.