Lines Matching refs:x

25   WITH c(x) AS (VALUES(0),(1))
26   SELECT c1.x||c2.x||c3.x FROM c c1, c c2, c c3;
29   WITH c(x) AS (VALUES(0),(1))
30   SELECT c1.x||c2.x||c3.x FROM c c1, c c2, c c3;
41   WITH c(x) AS MATERIALIZED (VALUES(0),(1))
42   SELECT c1.x||c2.x||c3.x FROM c c1, c c2, c c3;
45   WITH c(x) AS MATERIALIZED (VALUES(0),(1))
46   SELECT c1.x||c2.x||c3.x FROM c c1, c c2, c c3;
60   WITH c(x) AS NOT MATERIALIZED (VALUES(0),(1))
61   SELECT c1.x||c2.x||c3.x FROM c c1, c c2, c c3;
64   WITH c(x) AS NOT MATERIALIZED (VALUES(0),(1))
65   SELECT c1.x||c2.x||c3.x FROM c c1, c c2, c c3;
76   WITH c(x) AS NOT MATERIALIZED (VALUES(0),(1))
77   SELECT c1.x||c2.x||c3.x
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))
84   SELECT c1.x||c2.x||c3.x
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;
107 # The (SELECT x FROM c LIMIT N) subqueries get materialized once each.
112   WITH c(x) AS MATERIALIZED (VALUES(0),(1))
113   SELECT c1.x||c2.x||c3.x
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))
120   SELECT c1.x||c2.x||c3.x
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))
141   SELECT c1.x||c2.x||c3.x
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))
148   SELECT c1.x||c2.x||c3.x
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))
169   SELECT c2.x + 100*(SELECT sum(x+1) FROM c WHERE c.x<=c2.x)
170     FROM c AS c2 WHERE c2.x<10;
173   WITH c(x) AS (VALUES(0),(1))
174   SELECT c2.x + 100*(SELECT sum(x+1) FROM c WHERE c.x<=c2.x)
175     FROM c AS c2 WHERE c2.x<10;
186   WITH c(x) AS NOT MATERIALIZED (VALUES(0),(1))
187   SELECT c2.x + 100*(SELECT sum(x+1) FROM c WHERE c.x<=c2.x)
188     FROM c AS c2 WHERE c2.x<10;
191   WITH c(x) AS NOT MATERIALIZED (VALUES(0),(1))
192   SELECT c2.x + 100*(SELECT sum(x+1) FROM c WHERE c.x<=c2.x)
193     FROM c AS c2 WHERE c2.x<10;
207   CREATE TABLE t1(x);
208   INSERT INTO t1(x) VALUES(4);
211     SELECT c1.z+c2.z*100+t1.x*10000
221     SELECT c1.z+c2.z*100+t1.x*10000
248     SELECT c1.z+c2.z*100+t1.x*10000