Lines Matching refs:AS

22 # (1) If there is an AS clause, use it.
57     CREATE VIEW v1 AS SELECT tabC.a, txyZ.x, * 
59     CREATE VIEW v2 AS SELECT tabC.a, txyZ.x, tboTh.a, tbotH.x, *
78     SELECT +tabc.a AS AAA, -tabc.b AS BBB, tabc.c CCC, * FROM tabc
114     CREATE VIEW v3 AS SELECT tabC.a, txyZ.x, *
116     CREATE VIEW v4 AS SELECT tabC.a, txyZ.x, tboTh.a, tbotH.x, * 
135     SELECT +tabc.a AS AAA, -tabc.b AS BBB, tabc.c CCC FROM tabc
180     CREATE VIEW v5 AS SELECT tabC.a, txyZ.x, *
182     CREATE VIEW v6 AS SELECT tabC.a, txyZ.x, tboTh.a, tbotH.x, * 
201     SELECT +tabc.a AS AAA, -tabc.b AS BBB, tabc.c CCC FROM tabc
278   execsql2 {SELECT a, max(a) AS m FROM t6}
281   execsql2 {SELECT `a`, max(a) AS m FROM t6}
284   execsql2 {SELECT "a", max(a) AS m FROM t6}
287   execsql2 {SELECT [a], max(a) AS m FROM t6}
290   execsql2 {SELECT t6.a, max(a) AS m FROM t6}
293   execsql2 {SELECT ['a'], max(['a']) AS m FROM t6}
296   execsql2 {SELECT ["a"], max(["a"]) AS m FROM t6}
299   execsql2 {SELECT "[a]", max("[a]") AS m FROM t6}
302   execsql2 {SELECT "`a`", max([`a`]) AS m FROM t6}
324     SELECT "y"."x" FROM (SELECT "x" FROM "t3893") AS "y";
329 # For years now, the query flattener has inserted AS clauses on the
345     CREATE VIEW v1(x,y) AS SELECT a,b FROM t1;
355     CREATE VIEW v2(x,y) AS SELECT a,b FROM t1 LIMIT 10;
370     CREATE VIEW v3 AS SELECT c AS a, d AS b FROM t2;
372   execsql2 {SELECT t1.a, v3.a AS n FROM t1 LEFT JOIN v3}
375   execsql2 {SELECT t1.a AS n, v3.a FROM t1 JOIN v3}
378   execsql2 {SELECT t1.a, v3.a AS n FROM t1 JOIN v3}
382 # Inconsistent column names in CREATE TABLE AS
384 # Verify that the names of columns in the created table of a CREATE TABLE AS
394   execsql2 {SELECT BBb FROM (SELECT aaa AS Bbb FROM t1)}
398     CREATE TABLE t2 AS SELECT BBb FROM (SELECT aaa AS Bbb FROM t1);
416   CREATE TABLE t4 AS SELECT #0;
426   CREATE TABLE t5 AS SELECT RAISE(abort,a);
437   CREATE TABLE t2 AS SELECT "with space" FROM t1;
442   CREATE TABLE t3 AS SELECT "with space" FROM t1 GROUP BY 1;