Lines Matching refs:AS
37 CREATE VIEW IF NOT EXISTS v1 AS SELECT a,b FROM t1;
48 CREATE TEMP VIEW v1temp AS SELECT a, b FROM t1;
71 CREATE VIEW v1 AS SELECT a,b FROM t1;
90 CREATE VIEW v1 AS SELECT a,b FROM t1;
119 CREATE VIEW v9a AS SELECT x FROM t9;
120 CREATE VIEW v9b AS SELECT * FROM t9;
121 CREATE VIEW v9c(x) AS SELECT x FROM t9;
122 CREATE VIEW v9d(x) AS SELECT * FROM t9;
139 CREATE VIEW v2 AS SELECT * FROM t1 WHERE a>5
187 CREATE VIEW v1 AS SELECT a AS 'xyz', b+c AS 'pqr', c-b FROM t1;
193 CREATE VIEW v1b AS SELECT t1.a, b+c, t1.c FROM t1;
199 CREATE VIEW v1c(x,y,z) AS SELECT a, b+c, c-b FROM t1;
204 CREATE VIEW v1err(x,y DESC,z) AS SELECT a, b+c, c-b FROM t1;
208 CREATE VIEW v1err(x,y) AS SELECT a, b+c, c-b FROM t1;
213 CREATE VIEW v1err(w,x,y,z) AS SELECT a, b+c, c-b FROM t1;
220 CREATE VIEW v3 AS SELECT a FROM t1 UNION SELECT b FROM t1 ORDER BY b;
226 CREATE VIEW v4 AS
229 SELECT b AS 'x', a AS 'y' FROM t1
275 CREATE VIEW v5 AS
276 SELECT t1.x AS v, t2.y AS w FROM t1 JOIN t2 USING(a);
293 SELECT * FROM v5 AS a, t2 AS b WHERE a.w=b.y;
298 EXPLAIN SELECT * FROM v5 AS a, t2 AS b WHERE a.w=b.y;
303 SELECT * FROM t2 AS b, v5 AS a WHERE a.w=b.y;
308 EXPLAIN SELECT * FROM t2 AS b, v5 AS a WHERE a.w=b.y;
313 SELECT * FROM t1 AS a, v5 AS b, t2 AS c WHERE a.x=b.v AND b.w=c.y;
318 EXPLAIN SELECT * FROM t1 AS a, v5 AS b, t2 AS c WHERE a.x=b.v AND b.w=c.y;
340 CREATE VIEW test AS
356 CREATE VIEW test AS
372 CREATE VIEW test AS
388 CREATE VIEW v6 AS SELECT pqr, xyz FROM v1;
401 CREATE VIEW v7(a) AS SELECT pqr+xyz FROM v6;
409 CREATE VIEW v8 AS SELECT max(cnt) AS mx FROM
410 (SELECT a%2 AS eo, count(*) AS cnt FROM t1 GROUP BY eo);
448 CREATE VIEW v9 AS
460 CREATE VIEW v10 AS
478 CREATE VIEW v_t3_a AS SELECT a.[9] FROM t3 AS a;
479 CREATE VIEW v_t3_b AS SELECT "4" FROM t3;
507 CREATE VIEW v11 AS SELECT * FROM t4;
516 CREATE VIEW v12 AS SELECT a FROM t1 WHERE b=?
521 CREATE VIEW v12(x) AS SELECT a FROM t1 WHERE b=?
529 ATTACH 'test2.db' AS two;
531 CREATE VIEW v13 AS SELECT y FROM two.t2;
540 CREATE TEMP VIEW t1 AS SELECT a,b FROM t1;
547 CREATE TEMP VIEW t1(a,b) AS SELECT a,b FROM t1;
556 CREATE VIEW v15 AS SELECT a AS x, b AS y FROM t1;
568 CREATE VIEW IF NOT EXISTS v1 AS SELECT * FROM t1;
575 } {{CREATE VIEW v1 AS SELECT a AS 'xyz', b+c AS 'pqr', c-b FROM t1}}
604 CREATE VIEW vv1 AS SELECT * FROM t1;
605 CREATE VIEW vv2 AS SELECT * FROM vv1;
606 CREATE VIEW vv3 AS SELECT * FROM vv2;
607 CREATE VIEW vv4 AS SELECT * FROM vv3;
608 CREATE VIEW vv5 AS SELECT * FROM vv4;
619 CREATE VIEW v3308a AS SELECT rowid, * FROM t1;
627 CREATE VIEW v3308b AS SELECT t1.rowid, t1.a, t1.b+t1.c FROM t1;
635 CREATE VIEW v3308c AS SELECT t1.oid, A, t1.b+t1.c AS x FROM t1;
648 CREATE VIEW v1 AS SELECT c1 FROM (SELECT t1.c1 FROM t1);
655 CREATE VIEW x1 AS SELECT 123 AS '', 234 AS '', 345 AS '';
697 CREATE VIEW v16 AS SELECT max(a) AS mx, min(b) AS mn FROM t16 GROUP BY c;
699 SELECT * FROM v16 AS one, v16 AS two WHERE one.mx=1;
706 WITH v17(x,y) AS (SELECT max(a), min(b) FROM t16 GROUP BY c)
707 SELECT * FROM v17 AS one, v17 AS two WHERE one.x=1;
719 CREATE VIEW v0(c0, c1) AS SELECT t0.c0, AVG(t0.c1) FROM t0;
739 SELECT c0<c1 FROM (SELECT t0.c0 AS c0, AVG(t0.c1) AS c1 FROM t0)
742 SELECT c1<c0 FROM (SELECT t0.c0 AS c0, AVG(t0.c1) AS c1 FROM t0)
745 SELECT 1 FROM (SELECT t0.c0 AS c0, AVG(t0.c1) AS c1 FROM t0) WHERE c1<c0
748 SELECT 1 FROM (SELECT t0.c0 AS c0, AVG(t0.c1) AS c1 FROM t0) WHERE c0<c1
755 CREATE VIEW v0(c0) AS SELECT t0.c0 FROM t0;
771 CREATE VIEW IF NOT EXISTS IF AS SELECT null;
772 } {1 {malformed database schema (IF) - near "AS": syntax error}}