Lines Matching refs:test1

23   execsql {CREATE TABLE test1(f1 int, f2 int, f3 int)}
24   execsql {CREATE INDEX index1 ON test1(f1)}
26 } {index1 test1}
30 } {index1 {CREATE INDEX index1 ON test1(f1)} test1 index}
36 } {index1 {CREATE INDEX index1 ON test1(f1)} test1 index}
41 } {index1 test1}
46   execsql {DROP TABLE test1}
53   set v [catch {execsql {CREATE INDEX index1 ON test1(f1)}} msg]
55 } {1 {no such table: test1}}
61   execsql {CREATE TABLE test1(f1 int, f2 int, f3 int)}
62   set v [catch {execsql {CREATE INDEX index1 ON test1(f4)}} msg]
64 } {1 {table test1 has no column named f4}}
69   set v [catch {execsql {CREATE INDEX index1 ON test1(f1, f2, f4, f3)}} msg]
70   execsql {DROP TABLE test1}
72 } {1 {table test1 has no column named f4}}
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}])"
87            WHERE type='index' AND tbl_name='test1'
95   execsql {DROP TABLE test1}
97            WHERE type='index' AND tbl_name='test1'
109   execsql {CREATE TABLE test1(cnt int, power int)}
111     execsql "INSERT INTO test1 VALUES($i,[expr {int(pow(2,$i))}])"
113   execsql {CREATE INDEX index9 ON test1(cnt)}
114   execsql {CREATE INDEX indext ON test1(power)}
116 } {index9 indext test1}
118   execsql {SELECT cnt FROM test1 WHERE power=4}
121   execsql {SELECT cnt FROM test1 WHERE power=1024}
124   execsql {SELECT power FROM test1 WHERE cnt=6}
128   execsql {SELECT power FROM test1 WHERE cnt=6}
131   execsql {SELECT cnt FROM test1 WHERE power=1024}
134   execsql {CREATE INDEX indext ON test1(cnt)}
135   execsql {SELECT power FROM test1 WHERE cnt=6}
138   execsql {SELECT cnt FROM test1 WHERE power=1024}
142   execsql {SELECT power FROM test1 WHERE cnt=6}
145   execsql {SELECT cnt FROM test1 WHERE power=1024}
149   execsql {SELECT power FROM test1 WHERE cnt=6}
152   execsql {SELECT cnt FROM test1 WHERE power=1024}
155   execsql {DROP TABLE test1}
173   execsql {CREATE TABLE test1(f1 int, f2 int)}
175   execsql {CREATE INDEX index1 ON test1(f1)}
181 } {index1 test1 test2}
183   set v [catch {execsql {CREATE INDEX test1 ON test2(g1)}} msg]
185 } {1 {there is already a table named test1}}
188 } {index1 test1 test2}
190   execsql {DROP TABLE test1}
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);
200     DROP TABLE test1;
210   execsql {CREATE TABLE test1(f1 int, f2 int primary key)}
212     execsql "INSERT INTO test1 VALUES($i,[expr {int(pow(2,$i))}])"
214   execsql {SELECT count(*) FROM test1}
217   execsql {SELECT f1 FROM test1 WHERE f2=65536}
222     WHERE type='index' AND tbl_name='test1'
224 } {{(test1 autoindex 1)}}
226   execsql {DROP table test1}