Lines Matching refs:c2
26 SELECT c1.x||c2.x||c3.x FROM c c1, c c2, c c3;
30 SELECT c1.x||c2.x||c3.x FROM c c1, c c2, c c3;
36 |--SCAN c2
42 SELECT c1.x||c2.x||c3.x FROM c c1, c c2, c c3;
46 SELECT c1.x||c2.x||c3.x FROM c c1, c c2, c c3;
52 |--SCAN c2
61 SELECT c1.x||c2.x||c3.x FROM c c1, c c2, c c3;
65 SELECT c1.x||c2.x||c3.x FROM c c1, c c2, c c3;
71 |--SCAN c2
77 SELECT c1.x||c2.x||c3.x
79 (SELECT x FROM c LIMIT 5) AS c2,
84 SELECT c1.x||c2.x||c3.x
86 (SELECT x FROM c LIMIT 5) AS c2,
94 |--MATERIALIZE c2
103 |--SCAN c2
113 SELECT c1.x||c2.x||c3.x
115 (SELECT x FROM c LIMIT 6) AS c2,
120 SELECT c1.x||c2.x||c3.x
122 (SELECT x FROM c LIMIT 6) AS c2,
130 |--MATERIALIZE c2
135 |--SCAN c2
141 SELECT c1.x||c2.x||c3.x
143 (SELECT x FROM c LIMIT 6) AS c2,
148 SELECT c1.x||c2.x||c3.x
150 (SELECT x FROM c LIMIT 6) AS c2,
158 |--MATERIALIZE c2
163 |--SCAN c2
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;
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;
180 |--SCAN c2
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;
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;
198 |--SCAN c2
211 SELECT c1.z+c2.z*100+t1.x*10000
214 (SELECT z FROM c LIMIT 5) AS c2;
221 SELECT c1.z+c2.z*100+t1.x*10000
224 (SELECT z FROM c LIMIT 5) AS c2;
235 |--MATERIALIZE c2
240 |--SCAN c2
248 SELECT c1.z+c2.z*100+t1.x*10000
251 (SELECT z FROM c LIMIT 5) AS c2;