Lines Matching refs:AS

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;
202   CREATE VIEW temp.vv AS SELECT one.a, one.b, t2.a, t2.b FROM t1 AS one, t2;
257   ATTACH 'test.db2' AS aux;
279   CREATE VIEW v1 AS SELECT * FROM t2;
298   ATTACH 'test.db2' AS aux;
343   ATTACH 'test.db2' AS aux;
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}}
563     CREATE TABLE y1_segments AS SELECT * FROM abc;
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;
764        SET (k,v)=((WITH cte1(a) AS (SELECT 1 FROM t2) SELECT t2.k FROM t2, cte1),1);
788        WINDOW oamat7fzf AS ( PARTITION BY t_sa.c_d4u )
803   CREATE VIEW v0 AS
804     WITH p AS ( SELECT 1 FROM t1 ),
805          g AS ( SELECT 1 FROM p, t1 )
819 } {{CREATE VIEW v0 AS
820     WITH p AS ( SELECT 1 FROM "t2" ),
821          g AS ( SELECT 1 FROM p, "t2" )
825   CREATE VIEW v2 AS
826     WITH p AS ( SELECT 1 FROM t2 ),
827          g AS ( SELECT 1 FROM (
828            WITH i AS (SELECT 1 FROM p, t2)
845 } {{CREATE VIEW v2 AS
846     WITH p AS ( SELECT 1 FROM "t3" ),
847          g AS ( SELECT 1 FROM (
848            WITH i AS (SELECT 1 FROM p, "t3")
864   CREATE VIEW v3 AS 
865     WITH RECURSIVE t3(x,y,z) AS (
870   SELECT * FROM t3 AS xyz;
889 } {{CREATE VIEW v3 AS 
890     WITH RECURSIVE t3(x,y,z) AS (
895   SELECT * FROM t3 AS xyz}}
903   CREATE VIEW v1(x,y) AS 
908     WITH c1(x) AS (
914     ), c2(x) AS (VALUES(0),(1))
915     SELECT * FROM c1 AS x1, c2 AS x2, (
919     ) AS x3, c2 x5;
933   {CREATE VIEW v1(x,y) AS 
938     WITH c1(x) AS (
944     ), c2(x) AS (VALUES(0),(1))
945     SELECT * FROM c1 AS x1, c2 AS x2, (
949     ) AS x3, c2 x5;
957   CREATE VIEW vvv AS WITH x AS (WITH y AS (SELECT * FROM x) SELECT 1) SELECT 1;