Lines Matching refs:execsql
23 execsql {CREATE TABLE test1(f1 int, f2 int, f3 int)}
24 execsql {CREATE INDEX index1 ON test1(f1)}
25 execsql {SELECT name FROM sqlite_master WHERE type!='meta' ORDER BY name}
28 execsql {SELECT name, sql, tbl_name, type FROM sqlite_master
34 execsql {SELECT name, sql, tbl_name, type FROM sqlite_master
40 execsql {SELECT name FROM sqlite_master WHERE type!='meta' ORDER BY name}
46 execsql {DROP TABLE test1}
47 execsql {SELECT name FROM sqlite_master WHERE type!='meta' ORDER BY name}
53 set v [catch {execsql {CREATE INDEX index1 ON test1(f1)}} msg]
61 execsql {CREATE TABLE test1(f1 int, f2 int, f3 int)}
62 set v [catch {execsql {CREATE INDEX index1 ON test1(f4)}} msg]
69 set v [catch {execsql {CREATE INDEX index1 ON test1(f1, f2, f4, f3)}} msg]
70 execsql {DROP TABLE test1}
81 execsql {CREATE TABLE test1(f1 int, f2 int, f3 int, f4 int, f5 int)}
84 execsql $sql
86 execsql {SELECT name FROM sqlite_master
95 execsql {DROP TABLE test1}
96 execsql {SELECT name FROM sqlite_master
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)}
115 execsql {SELECT name FROM sqlite_master WHERE type!='meta' ORDER BY name}
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}
127 execsql {DROP INDEX indext}
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}
141 execsql {DROP INDEX index9}
142 execsql {SELECT power FROM test1 WHERE cnt=6}
145 execsql {SELECT cnt FROM test1 WHERE power=1024}
148 execsql {DROP INDEX indext}
149 execsql {SELECT power FROM test1 WHERE cnt=6}
152 execsql {SELECT cnt FROM test1 WHERE power=1024}
155 execsql {DROP TABLE test1}
156 execsql {SELECT name FROM sqlite_master WHERE type!='meta' ORDER BY name}
163 set v [catch {execsql {CREATE INDEX index1 ON sqlite_master(name)}} msg]
167 execsql {SELECT name FROM sqlite_master WHERE type!='meta'}
173 execsql {CREATE TABLE test1(f1 int, f2 int)}
174 execsql {CREATE TABLE test2(g1 real, g2 real)}
175 execsql {CREATE INDEX index1 ON test1(f1)}
176 set v [catch {execsql {CREATE INDEX index1 ON test2(g1)}} msg]
180 execsql {SELECT name FROM sqlite_master WHERE type!='meta' ORDER BY name}
183 set v [catch {execsql {CREATE INDEX test1 ON test2(g1)}} msg]
187 execsql {SELECT name FROM sqlite_master WHERE type!='meta' ORDER BY name}
190 execsql {DROP TABLE test1}
191 execsql {DROP TABLE test2}
192 execsql {SELECT name FROM sqlite_master WHERE type!='meta' ORDER BY name}
195 execsql {
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}
220 execsql {
226 execsql {DROP table test1}
227 execsql {SELECT name FROM sqlite_master WHERE type!='meta'}
234 set v [catch {execsql {DROP INDEX index1}} msg]
242 execsql {CREATE TABLE tab1(a int)}
243 execsql {EXPLAIN CREATE INDEX idx1 ON tab1(a)}
244 execsql {SELECT name FROM sqlite_master WHERE tbl_name='tab1'}
247 execsql {CREATE INDEX idx1 ON tab1(a)}
248 execsql {SELECT name FROM sqlite_master WHERE tbl_name='tab1' ORDER BY name}
255 execsql {
266 execsql {
271 execsql {
277 execsql {
283 execsql {
299 execsql {
305 execsql {
311 execsql {
317 execsql {
326 execsql {
335 execsql "INSERT INTO t3 VALUES('x${i}x',$i,0.$i)"
338 concat [execsql {SELECT c FROM t3 WHERE b==10}] $sqlite_search_count
349 execsql {
362 execsql {
367 execsql {
372 execsql {
377 execsql {
383 execsql {
388 execsql {
397 execsql {
409 set ::idxlist [execsql {
422 execsql {
432 execsql {
444 execsql {
449 execsql {
454 execsql {
459 execsql {
464 execsql {
469 execsql {
474 execsql {
479 execsql {
484 execsql {
489 execsql {
496 execsql {
502 execsql {
522 execsql {
528 execsql {