Lines Matching refs:AS

25   WITH c(x) AS (VALUES(0),(1))
29   WITH c(x) AS (VALUES(0),(1))
41   WITH c(x) AS MATERIALIZED (VALUES(0),(1))
45   WITH c(x) AS MATERIALIZED (VALUES(0),(1))
60   WITH c(x) AS NOT MATERIALIZED (VALUES(0),(1))
64   WITH c(x) AS NOT MATERIALIZED (VALUES(0),(1))
76   WITH c(x) AS NOT MATERIALIZED (VALUES(0),(1))
78     FROM (SELECT x FROM c LIMIT 5) AS c1,
79          (SELECT x FROM c LIMIT 5) AS c2,
80          (SELECT x FROM c LIMIT 5) AS c3;
83   WITH c(x) AS NOT MATERIALIZED (VALUES(0),(1))
85     FROM (SELECT x FROM c LIMIT 5) AS c1,
86          (SELECT x FROM c LIMIT 5) AS c2,
87          (SELECT x FROM c LIMIT 5) AS c3;
112   WITH c(x) AS MATERIALIZED (VALUES(0),(1))
114     FROM (SELECT x FROM c LIMIT 5) AS c1,
115          (SELECT x FROM c LIMIT 6) AS c2,
116          (SELECT x FROM c LIMIT 7) AS c3;
119   WITH c(x) AS MATERIALIZED (VALUES(0),(1))
121     FROM (SELECT x FROM c LIMIT 5) AS c1,
122          (SELECT x FROM c LIMIT 6) AS c2,
123          (SELECT x FROM c LIMIT 7) AS c3;
140   WITH c(x) AS (VALUES(0),(1))
142     FROM (SELECT x FROM c LIMIT 5) AS c1,
143          (SELECT x FROM c LIMIT 6) AS c2,
144          (SELECT x FROM c LIMIT 7) AS c3;
147   WITH c(x) AS (VALUES(0),(1))
149     FROM (SELECT x FROM c LIMIT 5) AS c1,
150          (SELECT x FROM c LIMIT 6) AS c2,
151          (SELECT x FROM c LIMIT 7) AS c3;
168   WITH c(x) AS (VALUES(0),(1))
170     FROM c AS c2 WHERE c2.x<10;
173   WITH c(x) AS (VALUES(0),(1))
175     FROM c AS c2 WHERE c2.x<10;
186   WITH c(x) AS NOT MATERIALIZED (VALUES(0),(1))
188     FROM c AS c2 WHERE c2.x<10;
191   WITH c(x) AS NOT MATERIALIZED (VALUES(0),(1))
193     FROM c AS c2 WHERE c2.x<10;
209   CREATE VIEW t2(y) AS
210     WITH c(z) AS (VALUES(4),(5),(6))
213            (SELECT z FROM c LIMIT 5) AS c1,
214            (SELECT z FROM c LIMIT 5) AS c2;
219   CREATE VIEW t2(y) AS
220     WITH c(z) AS NOT MATERIALIZED (VALUES(4),(5),(6))
223            (SELECT z FROM c LIMIT 5) AS c1,
224            (SELECT z FROM c LIMIT 5) AS c2;
246   CREATE VIEW t2(y) AS
247     WITH c(z) AS MATERIALIZED (VALUES(4),(5),(6))
250            (SELECT z FROM c LIMIT 5) AS c1,
251            (SELECT z FROM c LIMIT 5) AS c2;
265   WITH t23 AS MATERIALIZED (SELECT * FROM t2 FULL JOIN t3 USING(b))
273   WITH t23 AS MATERIALIZED (SELECT * FROM t2 FULL JOIN t3 USING(b))
285   WITH t23 AS NOT MATERIALIZED (SELECT * FROM t2 FULL JOIN t3 USING(b))
293   WITH t23 AS NOT MATERIALIZED (SELECT * FROM t2 FULL JOIN t3 USING(b))
303   WITH t23 AS (SELECT * FROM t2 FULL JOIN t3 USING(b))
311   WITH t23 AS (SELECT * FROM t2 FULL JOIN t3 USING(b))