Lines Matching refs:execsql
25 execsql {CREATE TABLE test1(f1 int, f2 int, f3 int)}
26 execsql {CREATE INDEX index1 ON test1(f1)}
27 execsql {SELECT name FROM sqlite_master WHERE type!='meta' ORDER BY name}
30 execsql {SELECT name, sql, tbl_name, type FROM sqlite_master
36 execsql {SELECT name, sql, tbl_name, type FROM sqlite_master
42 execsql {SELECT name FROM sqlite_master WHERE type!='meta' ORDER BY name}
48 execsql {DROP TABLE test1}
49 execsql {SELECT name FROM sqlite_master WHERE type!='meta' ORDER BY name}
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]
72 execsql {DROP TABLE test1}
83 execsql {CREATE TABLE test1(f1 int, f2 int, f3 int, f4 int, f5 int)}
86 execsql $sql
88 execsql {SELECT name FROM sqlite_master
97 execsql {DROP TABLE test1}
98 execsql {SELECT name FROM sqlite_master
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)}
117 execsql {SELECT name FROM sqlite_master WHERE type!='meta' ORDER BY name}
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}
129 execsql {DROP INDEX indext}
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}
143 execsql {DROP INDEX index9}
144 execsql {SELECT power FROM test1 WHERE cnt=6}
147 execsql {SELECT cnt FROM test1 WHERE power=1024}
150 execsql {DROP INDEX indext}
151 execsql {SELECT power FROM test1 WHERE cnt=6}
154 execsql {SELECT cnt FROM test1 WHERE power=1024}
157 execsql {DROP TABLE test1}
158 execsql {SELECT name FROM sqlite_master WHERE type!='meta' ORDER BY name}
165 set v [catch {execsql {CREATE INDEX index1 ON sqlite_master(name)}} msg]
169 execsql {SELECT name FROM sqlite_master WHERE type!='meta'}
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]
182 execsql {SELECT name FROM sqlite_master WHERE type!='meta' ORDER BY name}
185 set v [catch {execsql {CREATE INDEX test1 ON test2(g1)}} msg]
189 execsql {SELECT name FROM sqlite_master WHERE type!='meta' ORDER BY name}
192 execsql {DROP TABLE test1}
193 execsql {DROP TABLE test2}
194 execsql {SELECT name FROM sqlite_master WHERE type!='meta' ORDER BY name}
197 execsql {
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}
222 execsql {
228 execsql {DROP table test1}
229 execsql {SELECT name FROM sqlite_master WHERE type!='meta'}
236 set v [catch {execsql {DROP INDEX index1}} msg]
244 execsql {CREATE TABLE tab1(a int)}
245 execsql {EXPLAIN CREATE INDEX idx1 ON tab1(a)}
246 execsql {SELECT name FROM sqlite_master WHERE tbl_name='tab1'}
249 execsql {CREATE INDEX idx1 ON tab1(a)}
250 execsql {SELECT name FROM sqlite_master WHERE tbl_name='tab1' ORDER BY name}
257 execsql {
268 execsql {
273 execsql {
279 execsql {
285 execsql {
301 execsql {
307 execsql {
313 execsql {
319 execsql {
328 execsql {
337 execsql "INSERT INTO t3 VALUES('x${i}x',$i,0.$i)"
340 concat [execsql {SELECT c FROM t3 WHERE b==10}] $sqlite_search_count
351 execsql {
364 execsql {
369 execsql {
374 execsql {
379 execsql {
385 execsql {
390 execsql {
399 execsql {
411 set ::idxlist [execsql {
424 execsql {
434 execsql {
446 execsql {
451 execsql {
456 execsql {
461 execsql {
466 execsql {
471 execsql {
476 execsql {
481 execsql {
486 execsql {
491 execsql {
498 execsql {
504 execsql {
524 execsql {
530 execsql {