Lines Matching full:create
13 # focus of this file is testing the CREATE INDEX statement.
20 # Create a basic index and verify it is added to sqlite_master
23 execsql {CREATE TABLE test1(f1 int, f2 int, f3 int)}
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]
61 execsql {CREATE TABLE test1(f1 int, f2 int, f3 int)}
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]
81 execsql {CREATE TABLE test1(f1 int, f2 int, f3 int, f4 int, f5 int)}
83 set sql "CREATE INDEX [format index%02d $i] ON test1(f[expr {($i%5)+1}])"
101 # Create a table and insert values into that table. Then create
109 execsql {CREATE TABLE test1(cnt int, power int)}
113 execsql {CREATE INDEX index9 ON test1(cnt)}
114 execsql {CREATE INDEX indext ON test1(power)}
134 execsql {CREATE INDEX indext ON test1(cnt)}
163 set v [catch {execsql {CREATE INDEX index1 ON sqlite_master(name)}} msg]
173 execsql {CREATE TABLE test1(f1 int, f2 int)}
174 execsql {CREATE TABLE test2(g1 real, g2 real)}
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]
196 CREATE TABLE test1(a,b);
197 CREATE INDEX index1 ON test1(a);
198 CREATE INDEX index2 ON test1(b);
199 CREATE INDEX index3 ON test1(a,b);
207 # Create a primary key
210 execsql {CREATE TABLE test1(f1 int, f2 int primary key)}
238 # Make sure we don't actually create an index when the EXPLAIN keyword
242 execsql {CREATE TABLE tab1(a int)}
243 execsql {EXPLAIN CREATE INDEX idx1 ON tab1(a)}
247 execsql {CREATE INDEX idx1 ON tab1(a)}
256 CREATE TABLE t1(a int, b int);
257 CREATE INDEX i1 ON t1(a);
323 # Automatically create an index when we specify a primary key.
327 CREATE TABLE t3(
350 CREATE TABLE t4(a,b);
378 CREATE INDEX t4i1 ON t4(a);
398 CREATE TABLE t5(
433 CREATE TABLE t6(a,b,c);
434 CREATE INDEX t6i1 ON t6(a,b);
523 CREATE INDEX "t6i2" ON t6(c);