Lines Matching refs:c
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;
33 |--MATERIALIZE c
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;
49 |--MATERIALIZE c
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;
68 |--MATERIALIZE c
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;
91 | |--CO-ROUTINE c
93 | `--SCAN c
95 | |--CO-ROUTINE c
97 | `--SCAN c
99 | |--CO-ROUTINE c
101 | `--SCAN c
107 # The (SELECT x FROM c LIMIT N) subqueries get materialized once each.
109 # materialization for c, shown by the "SCAN 2 CONSTANT ROWS" line.
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;
127 | |--MATERIALIZE c
129 | `--SCAN c
131 | `--SCAN c
133 | `--SCAN c
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;
155 | |--MATERIALIZE c
157 | `--SCAN c
159 | `--SCAN c
161 | `--SCAN c
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;
178 |--MATERIALIZE c
182 `--SCAN c
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;
196 |--CO-ROUTINE c
200 |--CO-ROUTINE c
202 `--SCAN c
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;
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;
232 | |--CO-ROUTINE c
234 | `--SCAN c
236 | |--CO-ROUTINE c
238 | `--SCAN c
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;