Lines Matching refs:execsql
25 set v [catch {execsql {SELECT * FROM test1}} msg]
29 execsql {CREATE TABLE test1(f1 int, f2 int)}
32 set v [catch {execsql {SELECT * FROM test1, test2}} msg]
36 set v [catch {execsql {SELECT * FROM test2, test1}} msg]
40 execsql {INSERT INTO test1(f1,f2) VALUES(11,22)}
46 execsql {SELECT f1 FROM test1}
49 execsql {SELECT f2 FROM test1}
52 execsql {SELECT f2, f1 FROM test1}
55 execsql {SELECT f1, f2 FROM test1}
58 execsql {SELECT * FROM test1}
61 execsql {SELECT *, * FROM test1}
64 execsql {SELECT *, min(f1,f2), max(f1,f2) FROM test1}
67 execsql {SELECT 'one', *, 'two', * FROM test1}
70 execsql {CREATE TABLE test2(r1 real, r2 real)}
71 execsql {INSERT INTO test2(r1,r2) VALUES(1.1,2.2)}
74 execsql {SELECT * FROM test1, test2}
77 execsql {SELECT *, 'hi' FROM test1, test2}
80 execsql {SELECT 'one', *, 'two', * FROM test1, test2}
83 execsql {SELECT test1.f1, test2.r1 FROM test1, test2}
86 execsql {SELECT test1.f1, test2.r1 FROM test2, test1}
89 execsql {SELECT * FROM test2, test1}
92 execsql {SELECT * FROM test1 AS a, test1 AS b}
95 execsql {SELECT max(test1.f1,test2.r1), min(test1.f2,test2.r2)
99 execsql {SELECT min(test1.f1,test2.r1), max(test1.f2,test2.r2)
105 execsql "
123 set v [catch {execsql {SELECT count(f1,f2) FROM test1}} msg]
127 set v [catch {execsql {SELECT count(f1) FROM test1}} msg]
131 set v [catch {execsql {SELECT Count() FROM test1}} msg]
135 set v [catch {execsql {SELECT COUNT(*) FROM test1}} msg]
139 set v [catch {execsql {SELECT COUNT(*)+1 FROM test1}} msg]
143 execsql {SELECT count(*),count(a),count(b) FROM t3}
146 execsql {SELECT count(*),count(a),count(b) FROM t4}
149 execsql {SELECT count(*),count(a),count(b) FROM t4 WHERE b=5}
152 set v [catch {execsql {SELECT min(*) FROM test1}} msg]
156 set v [catch {execsql {SELECT Min(f1) FROM test1}} msg]
160 set v [catch {execsql {SELECT MIN(f1,f2) FROM test1}} msg]
164 execsql {SELECT coalesce(min(a),'xyzzy') FROM t3}
167 execsql {SELECT min(coalesce(a,'xyzzy')) FROM t3}
170 execsql {SELECT min(b), min(b) FROM t4}
173 set v [catch {execsql {SELECT MAX(*) FROM test1}} msg]
177 set v [catch {execsql {SELECT Max(f1) FROM test1}} msg]
181 set v [catch {execsql {SELECT max(f1,f2) FROM test1}} msg]
185 set v [catch {execsql {SELECT MAX(f1,f2)+1 FROM test1}} msg]
189 set v [catch {execsql {SELECT MAX(f1)+1 FROM test1}} msg]
193 execsql {SELECT coalesce(max(a),'xyzzy') FROM t3}
196 execsql {SELECT max(coalesce(a,'xyzzy')) FROM t3}
199 set v [catch {execsql {SELECT SUM(*) FROM test1}} msg]
203 set v [catch {execsql {SELECT Sum(f1) FROM test1}} msg]
207 set v [catch {execsql {SELECT sum(f1,f2) FROM test1}} msg]
211 set v [catch {execsql {SELECT SUM(f1)+1 FROM test1}} msg]
215 execsql {SELECT sum(a) FROM t3}
218 set v [catch {execsql {SELECT XYZZY(f1) FROM test1}} msg]
222 set v [catch {execsql {SELECT SUM(min(f1,f2)) FROM test1}} msg]
226 set v [catch {execsql {SELECT SUM(min(f1)) FROM test1}} msg]
233 set v [catch {execsql {SELECT f1 FROM test1 WHERE f1<11}} msg]
237 set v [catch {execsql {SELECT f1 FROM test1 WHERE f1<=11}} msg]
241 set v [catch {execsql {SELECT f1 FROM test1 WHERE f1=11}} msg]
245 set v [catch {execsql {SELECT f1 FROM test1 WHERE f1>=11}} msg]
249 set v [catch {execsql {SELECT f1 FROM test1 WHERE f1>11}} msg]
253 set v [catch {execsql {SELECT f1 FROM test1 WHERE f1!=11}} msg]
257 set v [catch {execsql {SELECT f1 FROM test1 WHERE min(f1,f2)!=11}} msg]
261 set v [catch {execsql {SELECT f1 FROM test1 WHERE max(f1,f2)!=11}} msg]
265 set v [catch {execsql {SELECT f1 FROM test1 WHERE count(f1,f2)!=11}} msg]
272 set v [catch {execsql {SELECT f1 FROM test1 ORDER BY f1}} msg]
276 set v [catch {execsql {SELECT f1 FROM test1 ORDER BY -f1}} msg]
280 set v [catch {execsql {SELECT f1 FROM test1 ORDER BY min(f1,f2)}} msg]
284 set v [catch {execsql {SELECT f1 FROM test1 ORDER BY min(f1)}} msg]
303 execsql {
311 execsql {
321 execsql {
327 execsql {
332 execsql {
341 set v [catch {execsql {SELECT max(f1) FROM test1 ORDER BY f2}} msg]
345 execsql {CREATE TABLE test2(t1 test, t2 text)}
346 execsql {INSERT INTO test2 VALUES('abc','xyz')}
355 execsql {PRAGMA full_column_names=on}
369 execsql {PRAGMA full_column_names=off}
456 set v [catch {execsql {
462 set v [catch {execsql {
468 set v [catch {execsql {SELECT f1 FROM test1 as 'hi', test2 as}} msg]
472 set v [catch {execsql {
478 set v [catch {execsql {
484 set v [catch {execsql {
490 set v [catch {execsql {
496 set v [catch {execsql {
503 execsql {SELECT f1 FROM test1 WHERE 4.3+2.4 OR 1 ORDER BY f1}
506 execsql {
512 execsql {
518 execsql {
526 execsql {
542 execsql {PRAGMA empty_result_callbacks=on}
567 execsql {
572 execsql {
577 execsql {
582 execsql {
587 execsql {
592 execsql {
600 execsql {
619 execsql {
624 execsql {
639 execsql {
707 execsql {
714 execsql {
719 execsql {
724 execsql {