Lines Matching refs:INDEX
13 # focus of this file is testing the CREATE INDEX statement.
24 execsql {CREATE INDEX index1 ON test1(f1)}
30 } {index1 {CREATE INDEX index1 ON test1(f1)} test1 index}
36 } {index1 {CREATE INDEX index1 ON test1(f1)} test1 index}
53 set v [catch {execsql {CREATE INDEX index1 ON test1(f1)}} msg]
62 set v [catch {execsql {CREATE INDEX index1 ON test1(f4)}} msg]
69 set v [catch {execsql {CREATE INDEX index1 ON test1(f1, f2, f4, f3)}} msg]
83 set sql "CREATE INDEX [format index%02d $i] ON test1(f[expr {($i%5)+1}])"
113 execsql {CREATE INDEX index9 ON test1(cnt)}
114 execsql {CREATE INDEX indext ON test1(power)}
127 execsql {DROP INDEX indext}
134 execsql {CREATE INDEX indext ON test1(cnt)}
141 execsql {DROP INDEX index9}
148 execsql {DROP INDEX indext}
163 set v [catch {execsql {CREATE INDEX index1 ON sqlite_master(name)}} msg]
175 execsql {CREATE INDEX index1 ON test1(f1)}
176 set v [catch {execsql {CREATE INDEX index1 ON test2(g1)}} msg]
183 set v [catch {execsql {CREATE INDEX test1 ON test2(g1)}} msg]
197 CREATE INDEX index1 ON test1(a);
198 CREATE INDEX index2 ON test1(b);
199 CREATE INDEX index3 ON test1(a,b);
234 set v [catch {execsql {DROP INDEX index1}} msg]
243 execsql {EXPLAIN CREATE INDEX idx1 ON tab1(a)}
247 execsql {CREATE INDEX idx1 ON tab1(a)}
257 CREATE INDEX i1 ON t1(a);
378 CREATE INDEX t4i1 ON t4(a);
417 DROP INDEX '[lindex $::idxlist $i]';
434 CREATE INDEX t6i1 ON t6(a,b);
523 CREATE INDEX "t6i2" ON t6(c);
524 DROP INDEX "t6i2";
529 DROP INDEX "t6i1";