Lines Matching refs:CREATE

15 # focus of this file is testing the CREATE INDEX statement.
25   execsql {CREATE TABLE test1(f1 int, f2 int, f3 int)}
26   execsql {CREATE INDEX index1 ON test1(f1)}
32 } {index1 {CREATE INDEX index1 ON test1(f1)} test1 index}
38 } {index1 {CREATE INDEX index1 ON test1(f1)} test1 index}
55   set v [catch {execsql {CREATE INDEX index1 ON test1(f1)}} msg]
63   execsql {CREATE TABLE test1(f1 int, f2 int, f3 int)}
64   set v [catch {execsql {CREATE INDEX index1 ON test1(f4)}} msg]
71   set v [catch {execsql {CREATE INDEX index1 ON test1(f1, f2, f4, f3)}} msg]
83   execsql {CREATE TABLE test1(f1 int, f2 int, f3 int, f4 int, f5 int)}
85     set sql "CREATE INDEX [format index%02d $i] ON test1(f[expr {($i%5)+1}])"
111   execsql {CREATE TABLE test1(cnt int, power int)}
115   execsql {CREATE INDEX index9 ON test1(cnt)}
116   execsql {CREATE INDEX indext ON test1(power)}
136   execsql {CREATE INDEX indext ON test1(cnt)}
165   set v [catch {execsql {CREATE INDEX index1 ON sqlite_master(name)}} msg]
175   execsql {CREATE TABLE test1(f1 int, f2 int)}
176   execsql {CREATE TABLE test2(g1 real, g2 real)}
177   execsql {CREATE INDEX index1 ON test1(f1)}
178   set v [catch {execsql {CREATE INDEX index1 ON test2(g1)}} msg]
185   set v [catch {execsql {CREATE INDEX test1 ON test2(g1)}} msg]
198     CREATE TABLE test1(a,b);
199     CREATE INDEX index1 ON test1(a);
200     CREATE INDEX index2 ON test1(b);
201     CREATE INDEX index3 ON test1(a,b);
212   execsql {CREATE TABLE test1(f1 int, f2 int primary key)}
244   execsql {CREATE TABLE tab1(a int)}
245   execsql {EXPLAIN CREATE INDEX idx1 ON tab1(a)}
249   execsql {CREATE INDEX idx1 ON tab1(a)}
258     CREATE TABLE t1(a int, b int);
259     CREATE INDEX i1 ON t1(a);
329     CREATE TABLE t3(
352     CREATE TABLE t4(a,b);
380     CREATE INDEX t4i1 ON t4(a);
400    CREATE TABLE t5(
435     CREATE TABLE t6(a,b,c);
436     CREATE INDEX t6i1 ON t6(a,b);
525     CREATE INDEX "t6i2" ON t6(c);