Lines Matching refs:AS
90 execsql {SELECT * FROM test1 AS a, test1 AS b}
562 # Check for ORDER BY clauses that refer to an AS name in the column list
566 SELECT f1 AS x FROM test1 ORDER BY x
571 SELECT f1 AS x FROM test1 ORDER BY -x
576 SELECT f1-23 AS x FROM test1 ORDER BY abs(x)
581 SELECT f1-23 AS x FROM test1 ORDER BY -abs(x)
586 SELECT f1-22 AS x, f2-22 as y FROM test1
591 SELECT f1-22 AS x, f2-22 as y FROM test1 WHERE x>0 AND y<50
613 SELECT * FROM t3 AS x, t4 AS y;
633 SELECT x.*, y.b FROM t3 AS x, t4 AS y;
648 SELECT x.b, y.* FROM t3 AS x, t4 AS y;
658 SELECT t3.* FROM t3 AS x, t4;
673 SELECT * FROM t3, (SELECT max(a), max(b) FROM t4) AS 'tx'
678 SELECT y.*, t3.* FROM t3, (SELECT max(a), max(b) FROM t4) AS y
701 SELECT 1 AS 'a','hello' AS 'b',2 AS 'c'
708 SELECT * FROM t3 UNION SELECT 3 AS 'a', 4 ORDER BY a;
729 SELECT a,b FROM t3 UNION SELECT a AS 'x', b AS 'y' FROM t4 ORDER BY a,b
736 SELECT a,b FROM t3 UNION SELECT a AS 'x', b AS 'y' FROM t4 ORDER BY a,b
737 ) AS 'z' ORDER BY x;