Lines Matching refs:execsql
22 execsql {CREATE TABLE test1(f1 int, f2 int, f3 int)}
23 execsql {CREATE INDEX index1 ON test1(f1)}
24 execsql {SELECT name FROM sqlite_master WHERE type!='meta' ORDER BY name}
27 execsql {SELECT name, sql, tbl_name, type FROM sqlite_master
33 execsql {SELECT name, sql, tbl_name, type FROM sqlite_master
39 execsql {SELECT name FROM sqlite_master WHERE type!='meta' ORDER BY name}
45 execsql {DROP TABLE test1}
46 execsql {SELECT name FROM sqlite_master WHERE type!='meta' ORDER BY name}
52 set v [catch {execsql {CREATE INDEX index1 ON test1(f1)}} msg]
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)}
83 execsql $sql
85 execsql {SELECT name FROM sqlite_master
92 execsql REINDEX
101 execsql {DROP TABLE test1}
102 execsql {SELECT name FROM sqlite_master
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)}
121 execsql {SELECT name FROM sqlite_master WHERE type!='meta' ORDER BY name}
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}
133 execsql {DROP INDEX indext}
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}
147 execsql {DROP INDEX index9}
148 execsql {SELECT power FROM test1 WHERE cnt=6}
151 execsql {SELECT cnt FROM test1 WHERE power=1024}
154 execsql {DROP INDEX indext}
155 execsql {SELECT power FROM test1 WHERE cnt=6}
158 execsql {SELECT cnt FROM test1 WHERE power=1024}
161 execsql {DROP TABLE test1}
162 execsql {SELECT name FROM sqlite_master WHERE type!='meta' ORDER BY name}
169 set v [catch {execsql {CREATE INDEX index1 ON sqlite_master(name)}} msg]
173 execsql {SELECT name FROM sqlite_master WHERE type!='meta'}
179 execsql {CREATE TABLE test1(f1 int, f2 int)}
180 execsql {CREATE TABLE test2(g1 real, g2 real)}
181 execsql {CREATE INDEX index1 ON test1(f1)}
182 set v [catch {execsql {CREATE INDEX index1 ON test2(g1)}} msg]
189 execsql {SELECT name FROM sqlite_master WHERE type!='meta' ORDER BY name}
195 set v [catch {execsql {CREATE INDEX test1 ON test2(g1)}} msg]
199 execsql {SELECT name FROM sqlite_master WHERE type!='meta' ORDER BY name}
202 execsql {DROP TABLE test1}
203 execsql {DROP TABLE test2}
204 execsql {SELECT name FROM sqlite_master WHERE type!='meta' ORDER BY name}
207 execsql {
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}
232 execsql {
238 execsql {DROP table test1}
239 execsql {SELECT name FROM sqlite_master WHERE type!='meta'}
246 set v [catch {execsql {DROP INDEX index1}} msg]
254 execsql {CREATE TABLE tab1(a int)}
256 execsql {EXPLAIN CREATE INDEX idx1 ON tab1(a)}
258 execsql {SELECT name FROM sqlite_master WHERE tbl_name='tab1'}
261 execsql {CREATE INDEX idx1 ON tab1(a)}
262 execsql {SELECT name FROM sqlite_master WHERE tbl_name='tab1' ORDER BY name}
269 execsql {
280 execsql {
285 execsql {
291 execsql {
297 execsql {
314 execsql { DELETE FROM t1 WHERE b IN (2, 4, 6, 8); }
316 execsql { DELETE FROM t1 WHERE b = 2 OR b = 4 OR b = 6 OR b = 8; }
318 execsql {
323 execsql {
329 execsql {
335 execsql {
344 execsql {
353 execsql "INSERT INTO t3 VALUES('x${i}x',$i,0.$i)"
356 concat [execsql {SELECT c FROM t3 WHERE b==10}] $sqlite_search_count
370 execsql {
383 execsql {
388 execsql {
393 execsql {
398 execsql {
404 execsql {
409 execsql {
418 execsql {
430 set ::idxlist [execsql {
443 execsql {
453 execsql {
465 execsql {
470 execsql {
475 execsql {
480 execsql {
485 execsql {
490 execsql {
495 execsql {
500 execsql {
505 execsql {
510 execsql {
517 execsql {
523 execsql {
543 execsql {
556 execsql {
562 execsql {
569 execsql {
576 execsql {
583 execsql {
596 execsql {
654 execsql {
663 execsql {
706 execsql REINDEX
714 execsql {
720 execsql {