Debian Codegraph @

test/with2.test

raw
1 # 2014 January 11
2 #
3 # The author disclaims copyright to this source code. In place of
4 # a legal notice, here is a blessing:
5 #
6 # May you do good and not evil.
7 # May you find forgiveness for yourself and forgive others.
8 # May you share freely, never taking more than you give.
9 #
10 #***********************************************************************
11 # This file implements regression tests for SQLite library. The
12 # focus of this file is testing the WITH clause.
13 #
14
15 set testdir [file dirname $argv0]
16 source $testdir/tester.tcl
17 set ::testprefix with2
18
19 ifcapable {!cte} {
20 finish_test
21 return
22 }
23
24 do_execsql_test 1.0 {
25 CREATE TABLE t1(a);
26 INSERT INTO t1 VALUES(1);
27 INSERT INTO t1 VALUES(2);
28 }
29
30 do_execsql_test 1.1 {
31 WITH x1 AS (SELECT * FROM t1)
32 SELECT sum(a) FROM x1;
33 } {3}
34
35 do_execsql_test 1.2 {
36 WITH x1 AS (SELECT * FROM t1)
37 SELECT (SELECT sum(a) FROM x1);
38 } {3}
39
40 do_execsql_test 1.3 {
41 WITH x1 AS (SELECT * FROM t1)
42 SELECT (SELECT sum(a) FROM x1);
43 } {3}
44
45 do_execsql_test 1.4 {
46 CREATE TABLE t2(i);
47 INSERT INTO t2 VALUES(2);
48 INSERT INTO t2 VALUES(3);
49 INSERT INTO t2 VALUES(5);
50
51 WITH x1 AS (SELECT i FROM t2),
52 i(a) AS (
53 SELECT min(i)-1 FROM x1 UNION SELECT a+1 FROM i WHERE a<10
54 )
55 SELECT a FROM i WHERE a NOT IN x1
56 } {1 4 6 7 8 9 10}
57
58 do_execsql_test 1.5 {
59 WITH x1 AS (SELECT a FROM t1),
60 x2 AS (SELECT i FROM t2),
61 x3 AS (SELECT * FROM x1, x2 WHERE x1.a IN x2 AND x2.i IN x1)
62 SELECT * FROM x3
63 } {2 2}
64
65 do_execsql_test 1.6 {
66 CREATE TABLE t3 AS SELECT 3 AS x;
67 CREATE TABLE t4 AS SELECT 4 AS x;
68
69 WITH x1 AS (SELECT * FROM t3),
70 x2 AS (
71 WITH t3 AS (SELECT * FROM t4)
72 SELECT * FROM x1
73 )
74 SELECT * FROM x2;
75 } {3}
76
77 do_execsql_test 1.7 {
78 WITH x2 AS (
79 WITH t3 AS (SELECT * FROM t4)
80 SELECT * FROM t3
81 )
82 SELECT * FROM x2;
83 } {4}
84
85 do_execsql_test 1.8 {
86 WITH x2 AS (
87 WITH t3 AS (SELECT * FROM t4)
88 SELECT * FROM main.t3
89 )
90 SELECT * FROM x2;
91 } {3}
92
93 do_execsql_test 1.9 {
94 WITH x1 AS (SELECT * FROM t1)
95 SELECT (SELECT sum(a) FROM x1), (SELECT max(a) FROM x1);
96 } {3 2}
97
98 do_execsql_test 1.10 {
99 WITH x1 AS (SELECT * FROM t1)
100 SELECT (SELECT sum(a) FROM x1), (SELECT max(a) FROM x1), a FROM x1;
101 } {3 2 1 3 2 2}
102
103 do_execsql_test 1.11 {
104 WITH
105 i(x) AS (
106 WITH
107 j(x) AS ( SELECT * FROM i ),
108 i(x) AS ( SELECT * FROM t1 )
109 SELECT * FROM j
110 )
111 SELECT * FROM i;
112 } {1 2}
113
114 do_execsql_test 1.12 {
115 WITH r(i) AS (
116 VALUES('.')
117 UNION ALL
118 SELECT i || '.' FROM r, (
119 SELECT x FROM x INTERSECT SELECT y FROM y
120 ) WHERE length(i) < 10
121 ),
122 x(x) AS ( VALUES(1) UNION ALL VALUES(2) UNION ALL VALUES(3) ),
123 y(y) AS ( VALUES(2) UNION ALL VALUES(4) UNION ALL VALUES(6) )
124
125 SELECT * FROM r;
126 } {. .. ... .... ..... ...... ....... ........ ......... ..........}
127
128 do_execsql_test 1.13 {
129 WITH r(i) AS (
130 VALUES('.')
131 UNION ALL
132 SELECT i || '.' FROM r, ( SELECT x FROM x WHERE x=2 ) WHERE length(i) < 10
133 ),
134 x(x) AS ( VALUES(1) UNION ALL VALUES(2) UNION ALL VALUES(3) )
135
136 SELECT * FROM r ORDER BY length(i) DESC;
137 } {.......... ......... ........ ....... ...... ..... .... ... .. .}
138
139 do_execsql_test 1.14 {
140 WITH
141 t4(x) AS (
142 VALUES(4)
143 UNION ALL
144 SELECT x+1 FROM t4 WHERE x<10
145 )
146 SELECT * FROM t4;
147 } {4 5 6 7 8 9 10}
148
149 do_execsql_test 1.15 {
150 WITH
151 t4(x) AS (
152 VALUES(4)
153 UNION ALL
154 SELECT x+1 FROM main.t4 WHERE x<10
155 )
156 SELECT * FROM t4;
157 } {4 5}
158
159 do_execsql_test 1.15.2 {
160 WITH
161 t4(x) AS (
162 VALUES(4)
163 UNION ALL
164 SELECT x+1 FROM (SELECT * FROM main.t4) WHERE x<10
165 )
166 SELECT * FROM t4;
167 } {4 5}
168
169 do_catchsql_test 1.16 {
170 WITH
171 t4(x) AS (
172 VALUES(4)
173 UNION ALL
174 SELECT x+1 FROM t4, main.t4, t4 WHERE x<10
175 )
176 SELECT * FROM t4;
177 } {1 {multiple references to recursive table: t4}}
178
179
180 #---------------------------------------------------------------------------
181 # Check that variables can be used in CTEs.
182 #
183 set ::min [expr 3]
184 set ::max [expr 9]
185 do_execsql_test 2.1 {
186 WITH i(x) AS (
187 VALUES($min) UNION ALL SELECT x+1 FROM i WHERE x < $max
188 )
189 SELECT * FROM i;
190 } {3 4 5 6 7 8 9}
191
192 do_execsql_test 2.2 {
193 WITH i(x) AS (
194 VALUES($min) UNION ALL SELECT x+1 FROM i WHERE x < $max
195 )
196 SELECT x FROM i JOIN i AS j USING (x);
197 } {3 4 5 6 7 8 9}
198
199 #---------------------------------------------------------------------------
200 # Check that circular references are rejected.
201 #
202 do_catchsql_test 3.1 {
203 WITH i(x, y) AS ( VALUES(1, (SELECT x FROM i)) )
204 SELECT * FROM i;
205 } {1 {circular reference: i}}
206
207 do_catchsql_test 3.2 {
208 WITH
209 i(x) AS ( SELECT * FROM j ),
210 j(x) AS ( SELECT * FROM k ),
211 k(x) AS ( SELECT * FROM i )
212 SELECT * FROM i;
213 } {1 {circular reference: i}}
214
215 do_catchsql_test 3.3 {
216 WITH
217 i(x) AS ( SELECT * FROM (SELECT * FROM j) ),
218 j(x) AS ( SELECT * FROM (SELECT * FROM i) )
219 SELECT * FROM i;
220 } {1 {circular reference: i}}
221
222 do_catchsql_test 3.4 {
223 WITH
224 i(x) AS ( SELECT * FROM (SELECT * FROM j) ),
225 j(x) AS ( SELECT * FROM (SELECT * FROM i) )
226 SELECT * FROM j;
227 } {1 {circular reference: j}}
228
229 do_catchsql_test 3.5 {
230 WITH
231 i(x) AS (
232 WITH j(x) AS ( SELECT * FROM i )
233 SELECT * FROM j
234 )
235 SELECT * FROM i;
236 } {1 {circular reference: i}}
237
238 #---------------------------------------------------------------------------
239 # Try empty and very long column lists.
240 #
241 do_catchsql_test 4.1 {
242 WITH x() AS ( SELECT 1,2,3 )
243 SELECT * FROM x;
244 } {1 {near ")": syntax error}}
245
246 proc genstmt {n} {
247 for {set i 1} {$i<=$n} {incr i} {
248 lappend cols "c$i"
249 lappend vals $i
250 }
251 return "
252 WITH x([join $cols ,]) AS (SELECT [join $vals ,])
253 SELECT (c$n == $n) FROM x
254 "
255 }
256
257 do_execsql_test 4.2 [genstmt 10] 1
258 do_execsql_test 4.3 [genstmt 100] 1
259 do_execsql_test 4.4 [genstmt 255] 1
260 set nLimit [sqlite3_limit db SQLITE_LIMIT_COLUMN -1]
261 do_execsql_test 4.5 [genstmt [expr $nLimit-1]] 1
262 do_execsql_test 4.6 [genstmt $nLimit] 1
263 do_catchsql_test 4.7 [genstmt [expr $nLimit+1]] \
264 {1 {too many columns in result set}}
265
266 #---------------------------------------------------------------------------
267 # Check that adding a WITH clause to an INSERT disables the xfer
268 # optimization.
269 #
270 proc do_xfer_test {tn bXfer sql {res {}}} {
271 set ::sqlite3_xferopt_count 0
272 uplevel [list do_test $tn [subst -nocommands {
273 set dres [db eval {$sql}]
274 list [set ::sqlite3_xferopt_count] [set dres]
275 }] [list $bXfer $res]]
276 }
277
278 do_execsql_test 5.1 {
279 DROP TABLE IF EXISTS t1;
280 DROP TABLE IF EXISTS t2;
281 CREATE TABLE t1(a, b);
282 CREATE TABLE t2(a, b);
283 }
284
285 do_xfer_test 5.2 1 { INSERT INTO t1 SELECT * FROM t2 }
286 do_xfer_test 5.3 0 { INSERT INTO t1 SELECT a, b FROM t2 }
287 do_xfer_test 5.4 0 { INSERT INTO t1 SELECT b, a FROM t2 }
288 do_xfer_test 5.5 0 {
289 WITH x AS (SELECT a, b FROM t2) INSERT INTO t1 SELECT * FROM x
290 }
291 do_xfer_test 5.6 0 {
292 WITH x AS (SELECT a, b FROM t2) INSERT INTO t1 SELECT * FROM t2
293 }
294 do_xfer_test 5.7 0 {
295 INSERT INTO t1 WITH x AS ( SELECT * FROM t2 ) SELECT * FROM x
296 }
297 do_xfer_test 5.8 0 {
298 INSERT INTO t1 WITH x(a,b) AS ( SELECT * FROM t2 ) SELECT * FROM x
299 }
300
301 #---------------------------------------------------------------------------
302 # Check that syntax (and other) errors in statements with WITH clauses
303 # attached to them do not cause problems (e.g. memory leaks).
304 #
305 do_execsql_test 6.1 {
306 DROP TABLE IF EXISTS t1;
307 DROP TABLE IF EXISTS t2;
308 CREATE TABLE t1(a, b);
309 CREATE TABLE t2(a, b);
310 }
311
312 do_catchsql_test 6.2 {
313 WITH x AS (SELECT * FROM t1)
314 INSERT INTO t2 VALUES(1, 2,);
315 } {1 {near ")": syntax error}}
316
317 do_catchsql_test 6.3 {
318 WITH x AS (SELECT * FROM t1)
319 INSERT INTO t2 SELECT a, b, FROM t1;
320 } {1 {near "FROM": syntax error}}
321
322 do_catchsql_test 6.3 {
323 WITH x AS (SELECT * FROM t1)
324 INSERT INTO t2 SELECT a, b FROM abc;
325 } {1 {no such table: abc}}
326
327 do_catchsql_test 6.4 {
328 WITH x AS (SELECT * FROM t1)
329 INSERT INTO t2 SELECT a, b, FROM t1 a a a;
330 } {1 {near "FROM": syntax error}}
331
332 do_catchsql_test 6.5 {
333 WITH x AS (SELECT * FROM t1)
334 DELETE FROM t2 WHERE;
335 } {1 {near ";": syntax error}}
336
337 do_catchsql_test 6.6 {
338 WITH x AS (SELECT * FROM t1) DELETE FROM t2 WHERE
339 } {1 {incomplete input}}
340
341 do_catchsql_test 6.7 {
342 WITH x AS (SELECT * FROM t1) DELETE FROM t2 WHRE 1;
343 } {/1 {near .* syntax error}/}
344
345 do_catchsql_test 6.8 {
346 WITH x AS (SELECT * FROM t1) UPDATE t2 SET a = 10, b = ;
347 } {/1 {near .* syntax error}/}
348
349 do_catchsql_test 6.9 {
350 WITH x AS (SELECT * FROM t1) UPDATE t2 SET a = 10, b = 1 WHERE a===b;
351 } {/1 {near .* syntax error}/}
352
353 do_catchsql_test 6.10 {
354 WITH x(a,b) AS (
355 SELECT 1, 1
356 UNION ALL
357 SELECT a*b,a+b FROM x WHERE c=2
358 )
359 SELECT * FROM x
360 } {1 {no such column: c}}
361
362 #-------------------------------------------------------------------------
363 # Recursive queries in IN(...) expressions.
364 #
365 do_execsql_test 7.1 {
366 CREATE TABLE t5(x INTEGER);
367 CREATE TABLE t6(y INTEGER);
368
369 WITH s(x) AS ( VALUES(7) UNION ALL SELECT x+7 FROM s WHERE x<49 )
370 INSERT INTO t5
371 SELECT * FROM s;
372
373 INSERT INTO t6
374 WITH s(x) AS ( VALUES(2) UNION ALL SELECT x+2 FROM s WHERE x<49 )
375 SELECT * FROM s;
376 }
377
378 do_execsql_test 7.2 {
379 SELECT * FROM t6 WHERE y IN (SELECT x FROM t5)
380 } {14 28 42}
381
382 do_execsql_test 7.3 {
383 WITH ss AS (SELECT x FROM t5)
384 SELECT * FROM t6 WHERE y IN (SELECT x FROM ss)
385 } {14 28 42}
386
387 do_execsql_test 7.4 {
388 WITH ss(x) AS ( VALUES(7) UNION ALL SELECT x+7 FROM ss WHERE x<49 )
389 SELECT * FROM t6 WHERE y IN (SELECT x FROM ss)
390 } {14 28 42}
391
392 do_execsql_test 7.5 {
393 SELECT * FROM t6 WHERE y IN (
394 WITH ss(x) AS ( VALUES(7) UNION ALL SELECT x+7 FROM ss WHERE x<49 )
395 SELECT x FROM ss
396 )
397 } {14 28 42}
398
399 #-------------------------------------------------------------------------
400 # At one point the following was causing an assertion failure and a
401 # memory leak.
402 #
403 do_execsql_test 8.1 {
404 CREATE TABLE t7(y);
405 INSERT INTO t7 VALUES(NULL);
406 CREATE VIEW v AS SELECT * FROM t7 ORDER BY y;
407 }
408
409 do_execsql_test 8.2 {
410 WITH q(a) AS (
411 SELECT 1
412 UNION
413 SELECT a+1 FROM q, v WHERE a<5
414 )
415 SELECT * FROM q;
416 } {1 2 3 4 5}
417
418 do_execsql_test 8.3 {
419 WITH q(a) AS (
420 SELECT 1
421 UNION ALL
422 SELECT a+1 FROM q, v WHERE a<5
423 )
424 SELECT * FROM q;
425 } {1 2 3 4 5}
426
427 # 2021-03-18
428 # Ticket bb8a9fd4a9b7fce5
429 reset_db
430 do_execsql_test 9.1 {
431 WITH xyz(a) AS (
432 WITH abc AS ( SELECT 1234 ) SELECT * FROM abc
433 )
434 SELECT * FROM xyz AS one, xyz AS two, (
435 SELECT * FROM xyz UNION ALL SELECT * FROM xyz
436 );
437 } {1234 1234 1234 1234 1234 1234}
438 ifcapable vtab {
439 load_static_extension db series
440 do_execsql_test 9.2 {
441 WITH
442 cst(rsx, rsy) AS (
443 SELECT 100, 100
444 ),
445 cst2(minx, maxx, stepx, miny, maxy, stepy, qualitativex, qualitativey) AS (
446 SELECT NULL, NULL, NULL, NULL, NULL, NULL, 0, 0
447 ),
448 ds0(m, n, x, y, x2, y2, title, size, mark, label, markmode) AS (
449 SELECT 1, 2, 3, 4, 5, 6, 7 , 8, 9, 10, 11
450 ),
451 ds(m, n, x, y, x2, y2, title, size, mark, label, markmode) AS (
452 SELECT m, n, x,
453 y, x2,
454 y2,
455 title, size, mark, label, markmode
456 FROM ds0
457 WINDOW w AS (PARTITION BY m, x ORDER BY n)
458 ),
459 d(m, n, x, y, x2, y2, labelx,labely,title,size,mark,label,markmode) AS (
460 SELECT m, n, x, y, x2, y2, x, y, title, size, mark, label, markmode
461 FROM ds, cst2
462 ),
463 ylabels(y, label) AS (
464 SELECT y, MIN(labely) FROM d GROUP BY y
465 ),
466 yaxis(maxy, miny, stepy , minstepy) AS (
467 WITH
468 xt0(minx, maxx) AS (
469 SELECT coalesce(miny, min(min(y2),
470 min(y))), coalesce(maxy, max(max(y2),
471 max(y))) + qualitativey
472 FROM d, cst2
473 ),
474 xt1(mx, mn) AS (SELECT maxx, minx FROM xt0),
475 xt2(mx, mn, step) AS (SELECT mx, mn, (mx-mn) FROM xt1),
476
477 xt3(mx, mn, ms) AS (
478 SELECT mx, mn, first_value(rs) OVER (order by x desc) AS ms
479 FROM (SELECT mx, mn, step, f,(mx-mn) as rng,
480 1.0*step/f as rs, 1.0*(mx-mn)/(step/f) AS x
481 FROM xt2, (SELECT 1 AS f UNION ALL SELECT 2
482 UNION ALL SELECT 4
483 UNION ALL SELECT 5)) AS src
484 WHERE x < 10 limit 1),
485 xt4(minstepy) AS (
486 SELECT MIN(abs(y2-y)) FROM d WHERE y2 != y
487 )
488 SELECT (mx/ms)*ms, (mn/ms)*ms, coalesce(stepy, ms),
489 coalesce(minstepy, ms, stepy) FROM xt3, cst2,xt4
490 ),
491 distinct_mark_n_m(mark, ze, zem, title) AS (
492 SELECT DISTINCT mark, n AS ze, m AS zem, title FROM ds0
493 ),
494 facet0(m, mi, title, radial) AS (
495 SELECT md, row_number() OVER () - 1, title, 'radial'
496 IN (SELECT mark FROM distinct_mark_n_m WHERE zem = md)
497 FROM (SELECT DISTINCT zem AS md, title AS title
498 FROM distinct_mark_n_m ORDER BY 2, 1)
499 ),
500 facet(m, mi, xorigin, yorigin, title, radial) AS (
501 SELECT m, mi,
502 rsx * 1.2 * IFNULL(CASE WHEN (
503 0
504 ) > 0 THEN mi / (
505 0
506 ) ELSE mi % (
507 2
508 ) END, mi),
509 rsy * 1.2 * IFNULL(CASE WHEN (
510 2
511 ) > 0 THEN mi / (
512 2
513 ) ELSE mi / (
514 0
515 ) END, 0),
516 title, radial FROM facet0, cst
517 ),
518 radygrid(m, mi, tty, wty, ttx, ttx2, xorigin, yorigin) AS (
519 SELECT m, mi, rsy / 2 / ((maxy-miny)/stepy) * (value-1) AS tty,
520 coalesce(NULL, miny + stepy * (value-1)) AS wty,
521 xorigin, xorigin+rsx, xorigin + rsx / 2,
522 yorigin + rsy / 2
523 FROM generate_series(1), yaxis, cst,
524 facet LEFT JOIN ylabels ON ylabels.y = (miny + (value-1) * stepy)
525 WHERE radial AND stop = 1+1.0*(maxy-miny)/stepy
526 ),
527 ypos(m, mi, pcx, pcy, radial) AS (
528 SELECT m, mi, xorigin, yorigin + CASE
529 WHEN 0 BETWEEN miny AND maxy THEN
530 rsy - (0 - miny) * rsy / (maxy-miny)
531 WHEN 0 >= maxy THEN 0
532 ELSE rsy
533 END, radial FROM yaxis, cst, facet WHERE NOT radial
534 UNION ALL
535 SELECT m, mi, xorigin + rsx / 2, yorigin + (CASE
536 WHEN 0 BETWEEN miny AND maxy THEN
537 rsy - (0 - miny) * rsy / 2 / (maxy-miny)
538 WHEN 0 >= maxy THEN 0
539 ELSE rsy
540 END ) / 2, radial FROM yaxis, cst, facet WHERE radial
541 )
542 SELECT * FROM radygrid , ypos;
543 } {}
544 } ;# end ifcapable vtab
545
546 # 2021-03-19
547 # dbsqlfuzz 01b8355086998f0a452cb31208e80b9d29ca739a
548 #
549 # Correlated CTEs should not be materialized.
550 #
551 reset_db
552 do_execsql_test 10.1 {
553 SELECT 1 AS c WHERE (
554 SELECT (
555 WITH t1(a) AS (VALUES( c ))
556 SELECT ( SELECT t1a.a FROM t1 AS t1a, t1 AS t1x )
557 FROM t1 AS xyz GROUP BY 1
558 )
559 )
560 } {1}
561
562 # 2021-05-21
563 # Forum post https://sqlite.org/forum/forumpost/aa4a7a3980
564 #
565 ifcapable altertable {
566 reset_db
567 do_execsql_test 11.1 {
568 CREATE TABLE t1(a);
569 CREATE VIEW v2(c) AS
570 WITH x AS (
571 WITH y AS (
572 WITH z AS(SELECT * FROM t1)
573 SELECT * FROM v2
574 ) SELECT a
575 ) SELECT * from t1;
576 ALTER TABLE t1 RENAME COLUMN a TO b;
577 SELECT sql FROM sqlite_schema WHERE name='t1';
578 } {{CREATE TABLE t1(b)}}
579 do_catchsql_test 11.2 {
580 INSERT INTO t1 VALUES(55);
581 SELECT * FROM v2;
582 } {0 55}
583 do_catchsql_test 11.3 {
584 DROP VIEW v2;
585 CREATE VIEW v2(c) AS
586 WITH x AS (
587 WITH y AS (
588 WITH z AS(SELECT * FROM t1)
589 SELECT * FROM v2
590 ) SELECT a
591 ) SELECT * from t1, x;
592 SELECT * FROM v2;
593 } {1 {no such column: a}}
594 do_catchsql_test 11.4 {
595 DROP VIEW v2;
596 CREATE VIEW v2(c) AS
597 WITH x AS (
598 WITH y AS (
599 WITH z AS(SELECT * FROM t1)
600 SELECT * FROM v2
601 ) SELECT *
602 ) SELECT * from t1, x;
603 SELECT * FROM v2;
604 } {1 {no tables specified}}
605 do_catchsql_test 11.5 {
606 WITH x AS (
607 WITH y AS (
608 WITH z AS(SELECT * FROM t1)
609 SELECT * FROM no_such_table
610 ) SELECT a
611 ) SELECT * from t1;
612 } {0 55}
613 }
614
615 # 2021-05-23 dbsqlfuzz 6b7a144674e215f06ddfeb9042c873d9ee956ac0 */
616 reset_db
617 ifcapable altertable {
618 do_execsql_test 12.1 {
619 CREATE TABLE t1(a);
620 INSERT INTO t1 VALUES(1),('hello'),(4.25),(NULL),(x'3c626c6f623e');
621 CREATE VIEW v2(c) AS WITH x AS (WITH y AS (WITH z AS(SELECT * FROM t1) SELECT * FROM v2) SELECT a) SELECT * from t1;
622 CREATE VIEW v3(c) AS WITH x AS (WITH y AS (WITH z AS(SELECT * FROM v2) SELECT * FROM v3) SELECT a) SELECT * from t1;
623 ALTER TABLE t1 RENAME TO t1x;
624 SELECT quote(c) FROM v3;
625 } {1 'hello' 4.25 NULL X'3C626C6F623E'}
626 }
627
628 # 2021-08-11 https://sqlite.org/forum/forumpost/d496c3d29bc93736
629 reset_db
630 do_execsql_test 13.1 {
631 WITH
632 t1(x) AS (SELECT 111),
633 t2(y) AS (SELECT 222),
634 t3(z) AS (SELECT * FROM t2 WHERE false UNION ALL SELECT * FROM t2)
635 SELECT * FROM t1, t3;
636 } {111 222}
637
638 finish_test