Lines Matching refs:t1
27 CREATE TABLE t1(a int, b int);
28 INSERT INTO t1 VALUES(1,2);
29 INSERT INTO t1 VALUES(3,4);
30 INSERT INTO t1 VALUES(5,6);
32 execsql {SELECT * FROM t1 WHERE a = (SELECT count(*) FROM t1)}
38 set v [catch {execsql {SELECT * FROM t1 WHERE a = (SELECT * FROM t1)}} msg]
45 execsql {SELECT b from t1 where a = (SELECT a FROM t1 WHERE b=2)}
48 execsql {SELECT b from t1 where a = (SELECT a FROM t1 WHERE b=4)}
51 execsql {SELECT b from t1 where a = (SELECT a FROM t1 WHERE b=6)}
54 execsql {SELECT b from t1 where a = (SELECT a FROM t1 WHERE b=8)}
61 execsql {SELECT b from t1 where a = coalesce((SELECT a FROM t1 WHERE b=5),1)}
76 WHERE x = (SELECT sum(b) FROM t1 where a notnull) - (SELECT sum(a) FROM t1)
92 SELECT (SELECT a FROM t1 ORDER BY a), (SELECT a FROM t1 ORDER BY a DESC)
97 SELECT 1 IN (SELECT a FROM t1 ORDER BY a);
102 SELECT 2 IN (SELECT a FROM t1 ORDER BY a DESC);
111 INSERT INTO t3 SELECT a FROM t1 UNION ALL SELECT b FROM t1;