Lines Matching refs:VIEW
12 # focus of this file is testing VIEW statements.
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;
84 DROP VIEW IF EXISTS v1;
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
186 DROP VIEW v1;
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;
207 DROP VIEW IF EXISTS v1err;
208 CREATE VIEW v1err(x,y) AS SELECT a, b+c, c-b FROM t1;
212 DROP VIEW IF EXISTS v1err;
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
239 DROP VIEW t1;
251 } {1 {use DROP VIEW to delete view v1}}
275 CREATE VIEW v5 AS
340 CREATE VIEW test AS
355 DROP VIEW test;
356 CREATE VIEW test AS
371 DROP VIEW test;
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
431 # Tests for a bug found by Michiel de Wit involving ORDER BY in a VIEW.
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=?
531 CREATE VIEW v13 AS SELECT y FROM two.t2;
540 CREATE TEMP VIEW t1 AS SELECT a,b FROM t1;
546 DROP VIEW IF EXISTS temp.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}}
578 DROP VIEW IF EXISTS nosuchview
587 DROP VIEW nosuchview
592 DROP VIEW main.nosuchview
598 DROP VIEW 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;
646 DROP VIEW IF EXISTS v1;
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 '';
679 db eval {DROP VIEW x1;}
697 CREATE VIEW v16 AS SELECT max(a) AS mx, min(b) AS mn FROM t16 GROUP BY c;
719 CREATE VIEW v0(c0, c1) AS SELECT t0.c0, AVG(t0.c1) FROM t0;
755 CREATE VIEW v0(c0) AS SELECT t0.c0 FROM t0;
771 CREATE VIEW IF NOT EXISTS IF AS SELECT null;