Lines Matching refs:VIEW

100   CREATE VIEW vvv AS SELECT main.txx.a, txx.b, c FROM txx;
101   CREATE VIEW uuu AS SELECT main.one.a, one.b, c FROM txx AS one;
102   CREATE VIEW temp.ttt AS SELECT main.txx.a, txx.b, one.b, main.one.a FROM txx AS one, txx;
114 } {{CREATE VIEW vvv AS SELECT main."t xx".a, "t xx".b, c FROM "t xx"}}
122 } {{CREATE VIEW uuu AS SELECT main.one.a, one.b, c FROM "t xx" AS one}}
129 } {{CREATE VIEW ttt AS SELECT main."t xx".a, "t xx".b, one.b, main.one.a FROM "t xx" AS one, "t xx"…
188   CREATE VIEW v AS SELECT one.a, one.b, t2.a, t2.b FROM t1 AS one, t2;
201   DROP VIEW v;
202   CREATE VIEW temp.vv AS SELECT one.a, one.b, t2.a, t2.b FROM t1 AS one, t2;
279   CREATE VIEW v1 AS SELECT * FROM t2;
285   DROP VIEW v1;
455   CREATE VIEW v1 AS SELECT * FROM t1;
468   CREATE VIEW v1 AS SELECT a FROM t1;
485   CREATE VIEW y AS SELECT f1 AS f1 FROM x;
506 } {{CREATE VIEW y AS SELECT f2 AS f1 FROM x}}
566     CREATE VIEW y1_segments AS SELECT * FROM abc;
620   CREATE VIEW t2 AS SELECT 1 FROM t1, (t1 AS a0, t1);
623 } {{CREATE TABLE "t3"(x)} {CREATE VIEW t2 AS SELECT 1 FROM "t3", ("t3" AS a0, "t3")}}
637   CREATE VIEW b AS SELECT(SELECT *FROM c JOIN a USING(d, a, a, a) JOIN a) IN();
646   CREATE VIEW c AS 
688   CREATE VIEW v1 AS SELECT * FROM idx WHERE x='abc';
703   {CREATE VIEW v1 AS SELECT * FROM "idx2" WHERE x='abc'}
712   {CREATE VIEW v1 AS SELECT * FROM "idx2" WHERE y='abc'}
734   CREATE VIEW v1 AS SELECT * FROM nosuchtable;
745   CREATE VIEW v3(b) AS WITH b AS (SELECT b FROM (SELECT * FROM t2)) VALUES(1);
761   CREATE VIEW t2 AS SELECT * FROM t2_a;
803   CREATE VIEW v0 AS
819 } {{CREATE VIEW v0 AS
825   CREATE VIEW v2 AS
845 } {{CREATE VIEW v2 AS
864   CREATE VIEW v3 AS 
889 } {{CREATE VIEW v3 AS 
903   CREATE VIEW v1(x,y) AS 
933   {CREATE VIEW v1(x,y) AS 
957   CREATE VIEW vvv AS WITH x AS (WITH y AS (SELECT * FROM x) SELECT 1) SELECT 1;