Lines Matching refs:test2
30 set v [catch {execsql {SELECT * FROM test1, test2}} msg]
32 } {1 {no such table: test2}}
34 set v [catch {execsql {SELECT * FROM test2, test1}} msg]
36 } {1 {no such table: test2}}
68 execsql {CREATE TABLE test2(r1 real, r2 real)}
69 execsql {INSERT INTO test2(r1,r2) VALUES(1.1,2.2)}
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}
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}
104 DROP TABLE test2;
343 execsql {CREATE TABLE test2(t1 test, t2 text)}
344 execsql {INSERT INTO test2 VALUES('abc','xyz')}
409 set v [catch {execsql2 {SELECT test1.f1+F2, t1 FROM test1, test2
414 set v [catch {execsql2 {SELECT A.f1, t1 FROM test1 as A, test2
466 set v [catch {execsql {SELECT f1 FROM test1 as 'hi', test2 as}} msg]
547 db eval {SELECT * FROM test1 WHERE f1<(select count(*) from test2)} r {}