Lines Matching refs:test1
23 set v [catch {execsql {SELECT * FROM test1}} msg]
25 } {1 {no such table: test1}}
27 execsql {CREATE TABLE test1(f1 int, f2 int)}
30 set v [catch {execsql {SELECT * FROM test1, test2}} msg]
34 set v [catch {execsql {SELECT * FROM test2, test1}} msg]
38 execsql {INSERT INTO test1(f1,f2) VALUES(11,22)}
44 execsql {SELECT f1 FROM test1}
47 execsql {SELECT f2 FROM test1}
50 execsql {SELECT f2, f1 FROM test1}
53 execsql {SELECT f1, f2 FROM test1}
56 execsql {SELECT * FROM test1}
59 execsql {SELECT *, * FROM test1}
62 execsql {SELECT *, min(f1,f2), max(f1,f2) FROM test1}
65 execsql {SELECT 'one', *, 'two', * FROM test1}
72 execsql {SELECT * FROM test1, test2}
75 execsql {SELECT *, 'hi' FROM test1, test2}
78 execsql {SELECT 'one', *, 'two', * FROM test1, test2}
81 execsql {SELECT test1.f1, test2.r1 FROM test1, test2}
84 execsql {SELECT test1.f1, test2.r1 FROM test2, test1}
87 execsql {SELECT * FROM test2, test1}
90 execsql {SELECT * FROM test1 AS a, test1 AS b}
93 execsql {SELECT max(test1.f1,test2.r1), min(test1.f2,test2.r2)
94 FROM test2, test1}
97 execsql {SELECT min(test1.f1,test2.r1), max(test1.f2,test2.r2)
98 FROM test1, test2}
105 DELETE FROM test1;
106 INSERT INTO test1 VALUES(11,22);
107 INSERT INTO test1 VALUES(33,44);
111 INSERT INTO t3 SELECT * FROM test1;
121 set v [catch {execsql {SELECT count(f1,f2) FROM test1}} msg]
125 set v [catch {execsql {SELECT count(f1) FROM test1}} msg]
129 set v [catch {execsql {SELECT Count() FROM test1}} msg]
133 set v [catch {execsql {SELECT COUNT(*) FROM test1}} msg]
137 set v [catch {execsql {SELECT COUNT(*)+1 FROM test1}} msg]
150 set v [catch {execsql {SELECT min(*) FROM test1}} msg]
154 set v [catch {execsql {SELECT Min(f1) FROM test1}} msg]
158 set v [catch {execsql {SELECT MIN(f1,f2) FROM test1}} msg]
171 set v [catch {execsql {SELECT MAX(*) FROM test1}} msg]
175 set v [catch {execsql {SELECT Max(f1) FROM test1}} msg]
179 set v [catch {execsql {SELECT max(f1,f2) FROM test1}} msg]
183 set v [catch {execsql {SELECT MAX(f1,f2)+1 FROM test1}} msg]
187 set v [catch {execsql {SELECT MAX(f1)+1 FROM test1}} msg]
197 set v [catch {execsql {SELECT SUM(*) FROM test1}} msg]
201 set v [catch {execsql {SELECT Sum(f1) FROM test1}} msg]
205 set v [catch {execsql {SELECT sum(f1,f2) FROM test1}} msg]
209 set v [catch {execsql {SELECT SUM(f1)+1 FROM test1}} msg]
216 set v [catch {execsql {SELECT XYZZY(f1) FROM test1}} msg]
220 set v [catch {execsql {SELECT SUM(min(f1,f2)) FROM test1}} msg]
224 set v [catch {execsql {SELECT SUM(min(f1)) FROM test1}} msg]
231 set v [catch {execsql {SELECT f1 FROM test1 WHERE f1<11}} msg]
235 set v [catch {execsql {SELECT f1 FROM test1 WHERE f1<=11}} msg]
239 set v [catch {execsql {SELECT f1 FROM test1 WHERE f1=11}} msg]
243 set v [catch {execsql {SELECT f1 FROM test1 WHERE f1>=11}} msg]
247 set v [catch {execsql {SELECT f1 FROM test1 WHERE f1>11}} msg]
251 set v [catch {execsql {SELECT f1 FROM test1 WHERE f1!=11}} msg]
255 set v [catch {execsql {SELECT f1 FROM test1 WHERE min(f1,f2)!=11}} msg]
259 set v [catch {execsql {SELECT f1 FROM test1 WHERE max(f1,f2)!=11}} msg]
263 set v [catch {execsql {SELECT f1 FROM test1 WHERE count(f1,f2)!=11}} msg]
270 set v [catch {execsql {SELECT f1 FROM test1 ORDER BY f1}} msg]
274 set v [catch {execsql {SELECT f1 FROM test1 ORDER BY -f1}} msg]
278 set v [catch {execsql {SELECT f1 FROM test1 ORDER BY min(f1,f2)}} msg]
282 set v [catch {execsql {SELECT f1 FROM test1 ORDER BY min(f1)}} msg]
287 SELECT f1 FROM test1 ORDER BY 8.4;
292 SELECT f1 FROM test1 ORDER BY '8.4';
297 SELECT f1 FROM test1 ORDER BY 'xyz';
339 set v [catch {execsql {SELECT max(f1) FROM test1 ORDER BY f2}} msg]
349 set v [catch {execsql2 {SELECT f1 FROM test1 ORDER BY f2}} msg]
354 set v [catch {execsql2 {SELECT f1 FROM test1 ORDER BY f2}} msg]
356 } {0 {test1.f1 11 test1.f1 33}}
358 set v [catch {execsql2 {SELECT f1 as 'f1' FROM test1 ORDER BY f2}} msg]
362 set v [catch {execsql2 {SELECT * FROM test1 WHERE f1==11}} msg]
364 } {0 {test1.f1 11 test1.f2 22}}
366 set v [catch {execsql2 {SELECT DISTINCT * FROM test1 WHERE f1==11}} msg]
369 } {0 {test1.f1 11 test1.f2 22}}
371 set v [catch {execsql2 {SELECT * FROM test1 WHERE f1==11}} msg]
375 set v [catch {execsql2 {SELECT DISTINCT * FROM test1 WHERE f1==11}} msg]
379 set v [catch {execsql2 {SELECT f1 as xyzzy FROM test1 ORDER BY f2}} msg]
383 set v [catch {execsql2 {SELECT f1 as "xyzzy" FROM test1 ORDER BY f2}} msg]
387 set v [catch {execsql2 {SELECT f1 as 'xyzzy ' FROM test1 ORDER BY f2}} msg]
391 set v [catch {execsql2 {SELECT f1+F2 as xyzzy FROM test1 ORDER BY f2}} msg]
395 set v [catch {execsql2 {SELECT f1+F2 FROM test1 ORDER BY f2}} msg]
399 set v [catch {execsql2 {SELECT test1.f1+F2 FROM test1 ORDER BY f2}} msg]
401 } {0 {test1.f1+F2 33 test1.f1+F2 77}}
404 set v [catch {execsql2 {SELECT test1.f1+F2 FROM test1 ORDER BY f2}} msg]
407 } {0 {test1.f1+F2 33 test1.f1+F2 77}}
409 set v [catch {execsql2 {SELECT test1.f1+F2, t1 FROM test1, test2
412 } {0 {test1.f1+F2 33 t1 abc test1.f1+F2 77 t1 abc}}
414 set v [catch {execsql2 {SELECT A.f1, t1 FROM test1 as A, test2
419 set v [catch {execsql2 {SELECT A.f1, f1 FROM test1 as A, test1 as B
424 set v [catch {execsql2 {SELECT A.f1, B.f1 FROM test1 as A, test1 as B
429 set v [catch {execsql2 {SELECT A.f1, f1 FROM test1 as A, test1 as A
434 set v [catch {execsql2 {SELECT A.f1, B.f1 FROM test1 as A, test1 as B
440 SELECT f1 FROM test1 UNION SELECT f2 FROM test1
447 SELECT f1 FROM test1 UNION SELECT f2+100 FROM test1
455 SELECT f1 FROM test1 WHERE f2=;
461 SELECT f1 FROM test1 UNION SELECT WHERE;
466 set v [catch {execsql {SELECT f1 FROM test1 as 'hi', test2 as}} msg]
471 SELECT f1 FROM test1 ORDER BY;
477 SELECT f1 FROM test1 ORDER BY f1 desc, f2 where;
483 SELECT count(f1,f2 FROM test1;
489 SELECT count(f1,f2+) FROM test1;
495 SELECT f1 FROM test1 ORDER BY f2, f1+;
501 execsql {SELECT f1 FROM test1 WHERE 4.3+2.4 OR 1 ORDER BY f1}
505 SELECT f1 FROM test1 WHERE ('x' || f1) BETWEEN 'x10' AND 'x20'
511 SELECT f1 FROM test1 WHERE 5-3==2
520 FROM test1 ORDER BY f1
526 FROM test1 ORDER BY f1
536 db eval {SELECT * FROM test1 WHERE f1<0} r {}
542 db eval {SELECT * FROM test1 WHERE f1<0} r {}
547 db eval {SELECT * FROM test1 WHERE f1<(select count(*) from test2)} r {}
552 db eval {SELECT * FROM test1 ORDER BY f1} r {}
557 db eval {SELECT * FROM test1 WHERE f1<0 ORDER BY f1} r {}
566 SELECT f1 AS x FROM test1 ORDER BY x
571 SELECT f1 AS x FROM test1 ORDER BY -x
576 SELECT f1-23 AS x FROM test1 ORDER BY abs(x)
581 SELECT f1-23 AS x FROM test1 ORDER BY -abs(x)
586 SELECT f1-22 AS x, f2-22 as y FROM test1
591 SELECT f1-22 AS x, f2-22 as y FROM test1 WHERE x>0 AND y<50