Lines Matching refs:test1
22 execsql {CREATE TABLE test1(f1 int, f2 int, f3 int)}
23 execsql {CREATE INDEX index1 ON test1(f1)}
25 } {index1 test1}
29 } {index1 {CREATE INDEX index1 ON test1(f1)} test1 index}
35 } {index1 {CREATE INDEX index1 ON test1(f1)} test1 index}
40 } {index1 test1}
45 execsql {DROP TABLE test1}
52 set v [catch {execsql {CREATE INDEX index1 ON test1(f1)}} msg]
54 } {1 {no such table: main.test1}}
60 execsql {CREATE TABLE test1(f1 int, f2 int, f3 int)}
61 set v [catch {execsql {CREATE INDEX index1 ON test1(f4)}} msg]
68 set v [catch {execsql {CREATE INDEX index1 ON test1(f1, f2, f4, f3)}} msg]
69 execsql {DROP TABLE test1}
80 execsql {CREATE TABLE test1(f1 int, f2 int, f3 int, f4 int, f5 int)}
82 set sql "CREATE INDEX [format index%02d $i] ON test1(f[expr {($i%5)+1}])"
86 WHERE type='index' AND tbl_name='test1'
101 execsql {DROP TABLE test1}
103 WHERE type='index' AND tbl_name='test1'
115 execsql {CREATE TABLE test1(cnt int, power int)}
117 execsql "INSERT INTO test1 VALUES($i,[expr {1<<$i}])"
119 execsql {CREATE INDEX index9 ON test1(cnt)}
120 execsql {CREATE INDEX indext ON test1(power)}
122 } {index9 indext test1}
124 execsql {SELECT cnt FROM test1 WHERE power=4}
127 execsql {SELECT cnt FROM test1 WHERE power=1024}
130 execsql {SELECT power FROM test1 WHERE cnt=6}
134 execsql {SELECT power FROM test1 WHERE cnt=6}
137 execsql {SELECT cnt FROM test1 WHERE power=1024}
140 execsql {CREATE INDEX indext ON test1(cnt)}
141 execsql {SELECT power FROM test1 WHERE cnt=6}
144 execsql {SELECT cnt FROM test1 WHERE power=1024}
148 execsql {SELECT power FROM test1 WHERE cnt=6}
151 execsql {SELECT cnt FROM test1 WHERE power=1024}
155 execsql {SELECT power FROM test1 WHERE cnt=6}
158 execsql {SELECT cnt FROM test1 WHERE power=1024}
161 execsql {DROP TABLE test1}
179 execsql {CREATE TABLE test1(f1 int, f2 int)}
181 execsql {CREATE INDEX index1 ON test1(f1)}
190 } {index1 test1 test2}
192 catchsql {CREATE INDEX IF NOT EXISTS index1 ON test1(f1)}
195 set v [catch {execsql {CREATE INDEX test1 ON test2(g1)}} msg]
197 } {1 {there is already a table named test1}}
200 } {index1 test1 test2}
202 execsql {DROP TABLE test1}
208 CREATE TABLE test1(a,b);
209 CREATE INDEX index1 ON test1(a);
210 CREATE INDEX index2 ON test1(b);
211 CREATE INDEX index3 ON test1(a,b);
212 DROP TABLE test1;
222 execsql {CREATE TABLE test1(f1 int, f2 int primary key)}
224 execsql "INSERT INTO test1 VALUES($i,[expr {1<<$i}])"
226 execsql {SELECT count(*) FROM test1}
229 execsql {SELECT f1 FROM test1 WHERE f2=65536}
234 WHERE type='index' AND tbl_name='test1'
238 execsql {DROP table test1}