Lines Matching refs:test1
25 set v [catch {execsql {SELECT * FROM test1}} msg]
27 } {1 {no such table: test1}}
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}
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)
96 FROM test2, test1}
99 execsql {SELECT min(test1.f1,test2.r1), max(test1.f2,test2.r2)
100 FROM test1, test2}
107 DELETE FROM test1;
108 INSERT INTO test1 VALUES(11,22);
109 INSERT INTO test1 VALUES(33,44);
113 INSERT INTO t3 SELECT * FROM test1;
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]
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]
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]
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]
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]
289 SELECT f1 FROM test1 ORDER BY 8.4;
294 SELECT f1 FROM test1 ORDER BY '8.4';
299 SELECT f1 FROM test1 ORDER BY 'xyz';
341 set v [catch {execsql {SELECT max(f1) FROM test1 ORDER BY f2}} msg]
351 set v [catch {execsql2 {SELECT f1 FROM test1 ORDER BY f2}} msg]
356 set v [catch {execsql2 {SELECT f1 FROM test1 ORDER BY f2}} msg]
358 } {0 {test1.f1 11 test1.f1 33}}
360 set v [catch {execsql2 {SELECT f1 as 'f1' FROM test1 ORDER BY f2}} msg]
364 set v [catch {execsql2 {SELECT * FROM test1 WHERE f1==11}} msg]
366 } {0 {test1.f1 11 test1.f2 22}}
368 set v [catch {execsql2 {SELECT DISTINCT * FROM test1 WHERE f1==11}} msg]
371 } {0 {test1.f1 11 test1.f2 22}}
373 set v [catch {execsql2 {SELECT * FROM test1 WHERE f1==11}} msg]
377 set v [catch {execsql2 {SELECT DISTINCT * FROM test1 WHERE f1==11}} msg]
381 set v [catch {execsql2 {SELECT f1 as xyzzy FROM test1 ORDER BY f2}} msg]
385 set v [catch {execsql2 {SELECT f1 as "xyzzy" FROM test1 ORDER BY f2}} msg]
389 set v [catch {execsql2 {SELECT f1 as 'xyzzy ' FROM test1 ORDER BY f2}} msg]
393 set v [catch {execsql2 {SELECT f1+F2 as xyzzy FROM test1 ORDER BY f2}} msg]
397 set v [catch {execsql2 {SELECT f1+F2 FROM test1 ORDER BY f2}} msg]
401 set v [catch {execsql2 {SELECT test1.f1+F2 FROM test1 ORDER BY f2}} msg]
403 } {0 {test1.f1+F2 33 test1.f1+F2 77}}
406 set v [catch {execsql2 {SELECT test1.f1+F2 FROM test1 ORDER BY f2}} msg]
409 } {0 {test1.f1+F2 33 test1.f1+F2 77}}
411 set v [catch {execsql2 {SELECT test1.f1+F2, t1 FROM test1, test2
414 } {0 {test1.f1+F2 33 t1 abc test1.f1+F2 77 t1 abc}}
416 set v [catch {execsql2 {SELECT A.f1, t1 FROM test1 as A, test2
421 set v [catch {execsql2 {SELECT A.f1, f1 FROM test1 as A, test1 as B
426 set v [catch {execsql2 {SELECT A.f1, B.f1 FROM test1 as A, test1 as B
431 set v [catch {execsql2 {SELECT A.f1, f1 FROM test1 as A, test1 as A
436 set v [catch {execsql2 {SELECT A.f1, B.f1 FROM test1 as A, test1 as B
442 SELECT f1 FROM test1 UNION SELECT f2 FROM test1
449 SELECT f1 FROM test1 UNION SELECT f2+100 FROM test1
457 SELECT f1 FROM test1 WHERE f2=;
463 SELECT f1 FROM test1 UNION SELECT WHERE;
468 set v [catch {execsql {SELECT f1 FROM test1 as 'hi', test2 as}} msg]
473 SELECT f1 FROM test1 ORDER BY;
479 SELECT f1 FROM test1 ORDER BY f1 desc, f2 where;
485 SELECT count(f1,f2 FROM test1;
491 SELECT count(f1,f2+) FROM test1;
497 SELECT f1 FROM test1 ORDER BY f2, f1+;
503 execsql {SELECT f1 FROM test1 WHERE 4.3+2.4 OR 1 ORDER BY f1}
507 SELECT f1 FROM test1 WHERE ('x' || f1) BETWEEN 'x10' AND 'x20'
513 SELECT f1 FROM test1 WHERE 5-3==2
522 FROM test1 ORDER BY f1
528 FROM test1 ORDER BY f1
538 db eval {SELECT * FROM test1 WHERE f1<0} r {}
544 db eval {SELECT * FROM test1 WHERE f1<0} r {}
549 db eval {SELECT * FROM test1 WHERE f1<(select count(*) from test2)} r {}
554 db eval {SELECT * FROM test1 ORDER BY f1} r {}
559 db eval {SELECT * FROM test1 WHERE f1<0 ORDER BY f1} r {}
568 SELECT f1 AS x FROM test1 ORDER BY x
573 SELECT f1 AS x FROM test1 ORDER BY -x
578 SELECT f1-23 AS x FROM test1 ORDER BY abs(x)
583 SELECT f1-23 AS x FROM test1 ORDER BY -abs(x)
588 SELECT f1-22 AS x, f2-22 as y FROM test1
593 SELECT f1-22 AS x, f2-22 as y FROM test1 WHERE x>0 AND y<50