Lines Matching refs:AS
92 execsql {SELECT * FROM test1 AS a, test1 AS b}
564 # Check for ORDER BY clauses that refer to an AS name in the column list
568 SELECT f1 AS x FROM test1 ORDER BY x
573 SELECT f1 AS x FROM test1 ORDER BY -x
578 SELECT f1-23 AS x FROM test1 ORDER BY abs(x)
583 SELECT f1-23 AS x FROM test1 ORDER BY -abs(x)
588 SELECT f1-22 AS x, f2-22 as y FROM test1
593 SELECT f1-22 AS x, f2-22 as y FROM test1 WHERE x>0 AND y<50
615 SELECT * FROM t3 AS x, t4 AS y;
635 SELECT x.*, y.b FROM t3 AS x, t4 AS y;
650 SELECT x.b, y.* FROM t3 AS x, t4 AS y;
660 SELECT t3.* FROM t3 AS x, t4;
675 SELECT * FROM t3, (SELECT max(a), max(b) FROM t4) AS 'tx'
680 SELECT y.*, t3.* FROM t3, (SELECT max(a), max(b) FROM t4) AS y
703 SELECT 1 AS 'a','hello' AS 'b',2 AS 'c'
710 SELECT * FROM t3 UNION SELECT 3 AS 'a', 4 ORDER BY a;
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
739 ) AS 'z' ORDER BY x;