Lines Matching refs:test2

32   set v [catch {execsql {SELECT * FROM test1, test2}} msg]
34 } {1 {no such table: test2}}
36   set v [catch {execsql {SELECT * FROM test2, test1}} msg]
38 } {1 {no such table: test2}}
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}
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}
106     DROP TABLE test2;
345 execsql {CREATE TABLE test2(t1 test, t2 text)}
346 execsql {INSERT INTO test2 VALUES('abc','xyz')}
411   set v [catch {execsql2 {SELECT test1.f1+F2, t1 FROM test1, test2 
416   set v [catch {execsql2 {SELECT A.f1, t1 FROM test1 as A, test2 
468   set v [catch {execsql {SELECT f1 FROM test1 as 'hi', test2 as}} msg]
549   db eval {SELECT * FROM test1 WHERE f1<(select count(*) from test2)} r {}