Lines Matching refs:t3
110 CREATE TABLE t3(a,b);
111 INSERT INTO t3 VALUES('abc',NULL);
112 INSERT INTO t3 VALUES(NULL,'xyz');
113 INSERT INTO t3 SELECT * FROM test1;
116 SELECT * FROM t3;
143 execsql {SELECT count(*),count(a),count(b) FROM t3}
164 execsql {SELECT coalesce(min(a),'xyzzy') FROM t3}
167 execsql {SELECT min(coalesce(a,'xyzzy')) FROM t3}
193 execsql {SELECT coalesce(max(a),'xyzzy') FROM t3}
196 execsql {SELECT max(coalesce(a,'xyzzy')) FROM t3}
215 execsql {SELECT sum(a) FROM t3}
601 DELETE FROM t3;
603 INSERT INTO t3 VALUES(1,2);
605 SELECT * FROM t3, t4;
610 SELECT * FROM t3, t4;
612 } {t3.a 1 t3.b 2 t4.a 3 t4.b 4}
615 SELECT * FROM t3 AS x, t4 AS y;
620 SELECT t3.*, t4.b FROM t3, t4;
625 SELECT "t3".*, t4.b FROM t3, t4;
630 SELECT t3.*, t4.b FROM t3, t4;
632 } {t3.a 1 t3.b 2 t4.b 4}
635 SELECT x.*, y.b FROM t3 AS x, t4 AS y;
640 SELECT t3.b, t4.* FROM t3, t4;
645 SELECT t3.b, t4.* FROM t3, t4;
647 } {t3.b 2 t4.a 3 t4.b 4}
650 SELECT x.b, y.* FROM t3 AS x, t4 AS y;
655 SELECT t5.* FROM t3, t4;
660 SELECT t3.* FROM t3 AS x, t4;
662 } {1 {no such table: t3}}
665 SELECT t3.* FROM t3, (SELECT max(a), max(b) FROM t4)
667 } {t3.a 1 t3.b 2}
670 SELECT t3.* FROM (SELECT max(a), max(b) FROM t4), t3
672 } {t3.a 1 t3.b 2}
675 SELECT * FROM t3, (SELECT max(a), max(b) FROM t4) AS 'tx'
677 } {t3.a 1 t3.b 2 tx.max(a) 3 tx.max(b) 4}
680 SELECT y.*, t3.* FROM t3, (SELECT max(a), max(b) FROM t4) AS y
682 } {y.max(a) 3 y.max(b) 4 t3.a 1 t3.b 2}
685 SELECT y.* FROM t3 as y, t4 as z
708 DELETE FROM t3;
709 INSERT INTO t3 VALUES(1,2);
710 SELECT * FROM t3 UNION SELECT 3 AS 'a', 4 ORDER BY a;
715 SELECT 3, 4 UNION SELECT * FROM t3;
720 SELECT * FROM t3 WHERE a=(SELECT 1);
725 SELECT * FROM t3 WHERE a=(SELECT 2);
731 SELECT a,b FROM t3 UNION SELECT a AS 'x', b AS 'y' FROM t4 ORDER BY a,b
738 SELECT a,b FROM t3 UNION SELECT a AS 'x', b AS 'y' FROM t4 ORDER BY a,b