Lines Matching refs:test1

25   execsql {CREATE TABLE test1(f1 int, f2 int, f3 int)}
26   execsql {CREATE INDEX index1 ON test1(f1)}
28 } {index1 test1}
32 } {index1 {CREATE INDEX index1 ON test1(f1)} test1 index}
38 } {index1 {CREATE INDEX index1 ON test1(f1)} test1 index}
43 } {index1 test1}
48   execsql {DROP TABLE test1}
55   set v [catch {execsql {CREATE INDEX index1 ON test1(f1)}} msg]
57 } {1 {no such table: test1}}
63   execsql {CREATE TABLE test1(f1 int, f2 int, f3 int)}
64   set v [catch {execsql {CREATE INDEX index1 ON test1(f4)}} msg]
66 } {1 {table test1 has no column named f4}}
71   set v [catch {execsql {CREATE INDEX index1 ON test1(f1, f2, f4, f3)}} msg]
72   execsql {DROP TABLE test1}
74 } {1 {table test1 has no column named f4}}
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}])"
89            WHERE type='index' AND tbl_name='test1'
97   execsql {DROP TABLE test1}
99            WHERE type='index' AND tbl_name='test1'
111   execsql {CREATE TABLE test1(cnt int, power int)}
113     execsql "INSERT INTO test1 VALUES($i,[expr {int(pow(2,$i))}])"
115   execsql {CREATE INDEX index9 ON test1(cnt)}
116   execsql {CREATE INDEX indext ON test1(power)}
118 } {index9 indext test1}
120   execsql {SELECT cnt FROM test1 WHERE power=4}
123   execsql {SELECT cnt FROM test1 WHERE power=1024}
126   execsql {SELECT power FROM test1 WHERE cnt=6}
130   execsql {SELECT power FROM test1 WHERE cnt=6}
133   execsql {SELECT cnt FROM test1 WHERE power=1024}
136   execsql {CREATE INDEX indext ON test1(cnt)}
137   execsql {SELECT power FROM test1 WHERE cnt=6}
140   execsql {SELECT cnt FROM test1 WHERE power=1024}
144   execsql {SELECT power FROM test1 WHERE cnt=6}
147   execsql {SELECT cnt FROM test1 WHERE power=1024}
151   execsql {SELECT power FROM test1 WHERE cnt=6}
154   execsql {SELECT cnt FROM test1 WHERE power=1024}
157   execsql {DROP TABLE test1}
175   execsql {CREATE TABLE test1(f1 int, f2 int)}
177   execsql {CREATE INDEX index1 ON test1(f1)}
183 } {index1 test1 test2}
185   set v [catch {execsql {CREATE INDEX test1 ON test2(g1)}} msg]
187 } {1 {there is already a table named test1}}
190 } {index1 test1 test2}
192   execsql {DROP TABLE test1}
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);
202     DROP TABLE test1;
212   execsql {CREATE TABLE test1(f1 int, f2 int primary key)}
214     execsql "INSERT INTO test1 VALUES($i,[expr {int(pow(2,$i))}])"
216   execsql {SELECT count(*) FROM test1}
219   execsql {SELECT f1 FROM test1 WHERE f2=65536}
224     WHERE type='index' AND tbl_name='test1'
226 } {{(test1 autoindex 1)}}
228   execsql {DROP table test1}