Debian Codegraph @

test/joinC.test

raw
1 # 2022-04-19
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 #
12 # This file implements tests for JOINs.
13 #
14 # The test case output is all generated by PostgreSQL 14. This test module
15 # was created as follows:
16 #
17 # 1. Run a TCL script (included at the bottom of this file) that
18 # generates an input script for "psql" that will run man
19 # diverse tests on joins.
20 #
21 # 2. Run the script from step (1) through psql and collect the
22 # output.
23 #
24 # 3. Make a few minor global search-and-replace operations to convert
25 # the psql output into a form suitable for this test module.
26 #
27 # 4. Add this header, and the script content at the footer.
28 #
29 set testdir [file dirname $argv0]
30 source $testdir/tester.tcl
31 db nullvalue -
32 db eval {
33 DROP TABLE IF EXISTS t1;
34 DROP TABLE IF EXISTS t2;
35 DROP TABLE IF EXISTS t3;
36 DROP TABLE IF EXISTS t4;
37 DROP TABLE IF EXISTS t5;
38 CREATE TABLE t1(a INT, b INT, c INT);
39 CREATE TABLE t2(a INT, b INT, d INT);
40 CREATE TABLE t3(a INT, b INT, e INT);
41 CREATE TABLE t4(a INT, b INT, f INT);
42 CREATE TABLE t5(a INT, b INT, g INT);
43 INSERT INTO t1 VALUES(11,21,31),(12,22,32),(15,25,35),(17,27,37);
44 INSERT INTO t2 VALUES(12,22,32),(13,23,33),(15,25,35),(18,28,38),
45 (NULL,NULL,36);
46 INSERT INTO t4 VALUES(11,21,31),(13,23,33),(15,25,35),(19,29,39);
47 INSERT INTO t3 SELECT * FROM t1 UNION SELECT * FROM t2 UNION SELECT * FROM t4;
48 INSERT INTO t5 SELECT * FROM t3 WHERE a>=15;
49 }
50 do_execsql_test joinC-1 {
51 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
52 FROM t1 INNER JOIN (
53 t2 INNER JOIN (
54 t3 INNER JOIN (
55 t4 INNER JOIN t5 USING(a)
56 ) USING(a)
57 ) USING(a)
58 ) USING(a)
59 ORDER BY 1 NULLS FIRST;
60 } {
61 15 15 15 15 15 15
62
63 }
64 do_execsql_test joinC-2 {
65 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
66 FROM t1 INNER JOIN (
67 t2 INNER JOIN (
68 t3 INNER JOIN (
69 t4 LEFT JOIN t5 USING(a)
70 ) USING(a)
71 ) USING(a)
72 ) USING(a)
73 ORDER BY 1 NULLS FIRST;
74 } {
75 15 15 15 15 15 15
76
77 }
78 do_execsql_test joinC-3 {
79 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
80 FROM t1 INNER JOIN (
81 t2 INNER JOIN (
82 t3 INNER JOIN (
83 t4 RIGHT JOIN t5 USING(a)
84 ) USING(a)
85 ) USING(a)
86 ) USING(a)
87 ORDER BY 1 NULLS FIRST;
88 } {
89 15 15 15 15 15 15
90
91 }
92 do_execsql_test joinC-4 {
93 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
94 FROM t1 INNER JOIN (
95 t2 INNER JOIN (
96 t3 INNER JOIN (
97 t4 FULL JOIN t5 USING(a)
98 ) USING(a)
99 ) USING(a)
100 ) USING(a)
101 ORDER BY 1 NULLS FIRST;
102 } {
103 15 15 15 15 15 15
104
105 }
106 do_execsql_test joinC-5 {
107 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
108 FROM t1 INNER JOIN (
109 t2 INNER JOIN (
110 t3 LEFT JOIN (
111 t4 INNER JOIN t5 USING(a)
112 ) USING(a)
113 ) USING(a)
114 ) USING(a)
115 ORDER BY 1 NULLS FIRST;
116 } {
117 12 12 12 12 - -
118 15 15 15 15 15 15
119
120 }
121 do_execsql_test joinC-6 {
122 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
123 FROM t1 INNER JOIN (
124 t2 INNER JOIN (
125 t3 LEFT JOIN (
126 t4 LEFT JOIN t5 USING(a)
127 ) USING(a)
128 ) USING(a)
129 ) USING(a)
130 ORDER BY 1 NULLS FIRST;
131 } {
132 12 12 12 12 - -
133 15 15 15 15 15 15
134
135 }
136 do_execsql_test joinC-7 {
137 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
138 FROM t1 INNER JOIN (
139 t2 INNER JOIN (
140 t3 LEFT JOIN (
141 t4 RIGHT JOIN t5 USING(a)
142 ) USING(a)
143 ) USING(a)
144 ) USING(a)
145 ORDER BY 1 NULLS FIRST;
146 } {
147 12 12 12 12 - -
148 15 15 15 15 15 15
149
150 }
151 do_execsql_test joinC-8 {
152 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
153 FROM t1 INNER JOIN (
154 t2 INNER JOIN (
155 t3 LEFT JOIN (
156 t4 FULL JOIN t5 USING(a)
157 ) USING(a)
158 ) USING(a)
159 ) USING(a)
160 ORDER BY 1 NULLS FIRST;
161 } {
162 12 12 12 12 - -
163 15 15 15 15 15 15
164
165 }
166 do_execsql_test joinC-9 {
167 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
168 FROM t1 INNER JOIN (
169 t2 INNER JOIN (
170 t3 RIGHT JOIN (
171 t4 INNER JOIN t5 USING(a)
172 ) USING(a)
173 ) USING(a)
174 ) USING(a)
175 ORDER BY 1 NULLS FIRST;
176 } {
177 15 15 15 15 15 15
178
179 }
180 do_execsql_test joinC-10 {
181 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
182 FROM t1 INNER JOIN (
183 t2 INNER JOIN (
184 t3 RIGHT JOIN (
185 t4 LEFT JOIN t5 USING(a)
186 ) USING(a)
187 ) USING(a)
188 ) USING(a)
189 ORDER BY 1 NULLS FIRST;
190 } {
191 15 15 15 15 15 15
192
193 }
194 do_execsql_test joinC-11 {
195 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
196 FROM t1 INNER JOIN (
197 t2 INNER JOIN (
198 t3 RIGHT JOIN (
199 t4 RIGHT JOIN t5 USING(a)
200 ) USING(a)
201 ) USING(a)
202 ) USING(a)
203 ORDER BY 1 NULLS FIRST;
204 } {
205 15 15 15 15 15 15
206
207 }
208 do_execsql_test joinC-12 {
209 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
210 FROM t1 INNER JOIN (
211 t2 INNER JOIN (
212 t3 RIGHT JOIN (
213 t4 FULL JOIN t5 USING(a)
214 ) USING(a)
215 ) USING(a)
216 ) USING(a)
217 ORDER BY 1 NULLS FIRST;
218 } {
219 15 15 15 15 15 15
220
221 }
222 do_execsql_test joinC-13 {
223 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
224 FROM t1 INNER JOIN (
225 t2 INNER JOIN (
226 t3 FULL JOIN (
227 t4 INNER JOIN t5 USING(a)
228 ) USING(a)
229 ) USING(a)
230 ) USING(a)
231 ORDER BY 1 NULLS FIRST;
232 } {
233 12 12 12 12 - -
234 15 15 15 15 15 15
235
236 }
237 do_execsql_test joinC-14 {
238 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
239 FROM t1 INNER JOIN (
240 t2 INNER JOIN (
241 t3 FULL JOIN (
242 t4 LEFT JOIN t5 USING(a)
243 ) USING(a)
244 ) USING(a)
245 ) USING(a)
246 ORDER BY 1 NULLS FIRST;
247 } {
248 12 12 12 12 - -
249 15 15 15 15 15 15
250
251 }
252 do_execsql_test joinC-15 {
253 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
254 FROM t1 INNER JOIN (
255 t2 INNER JOIN (
256 t3 FULL JOIN (
257 t4 RIGHT JOIN t5 USING(a)
258 ) USING(a)
259 ) USING(a)
260 ) USING(a)
261 ORDER BY 1 NULLS FIRST;
262 } {
263 12 12 12 12 - -
264 15 15 15 15 15 15
265
266 }
267 do_execsql_test joinC-16 {
268 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
269 FROM t1 INNER JOIN (
270 t2 INNER JOIN (
271 t3 FULL JOIN (
272 t4 FULL JOIN t5 USING(a)
273 ) USING(a)
274 ) USING(a)
275 ) USING(a)
276 ORDER BY 1 NULLS FIRST;
277 } {
278 12 12 12 12 - -
279 15 15 15 15 15 15
280
281 }
282 do_execsql_test joinC-17 {
283 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
284 FROM t1 INNER JOIN (
285 t2 LEFT JOIN (
286 t3 INNER JOIN (
287 t4 INNER JOIN t5 USING(a)
288 ) USING(a)
289 ) USING(a)
290 ) USING(a)
291 ORDER BY 1 NULLS FIRST;
292 } {
293 12 12 12 - - -
294 15 15 15 15 15 15
295
296 }
297 do_execsql_test joinC-18 {
298 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
299 FROM t1 INNER JOIN (
300 t2 LEFT JOIN (
301 t3 INNER JOIN (
302 t4 LEFT JOIN t5 USING(a)
303 ) USING(a)
304 ) USING(a)
305 ) USING(a)
306 ORDER BY 1 NULLS FIRST;
307 } {
308 12 12 12 - - -
309 15 15 15 15 15 15
310
311 }
312 do_execsql_test joinC-19 {
313 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
314 FROM t1 INNER JOIN (
315 t2 LEFT JOIN (
316 t3 INNER JOIN (
317 t4 RIGHT JOIN t5 USING(a)
318 ) USING(a)
319 ) USING(a)
320 ) USING(a)
321 ORDER BY 1 NULLS FIRST;
322 } {
323 12 12 12 - - -
324 15 15 15 15 15 15
325
326 }
327 do_execsql_test joinC-20 {
328 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
329 FROM t1 INNER JOIN (
330 t2 LEFT JOIN (
331 t3 INNER JOIN (
332 t4 FULL JOIN t5 USING(a)
333 ) USING(a)
334 ) USING(a)
335 ) USING(a)
336 ORDER BY 1 NULLS FIRST;
337 } {
338 12 12 12 - - -
339 15 15 15 15 15 15
340
341 }
342 do_execsql_test joinC-21 {
343 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
344 FROM t1 INNER JOIN (
345 t2 LEFT JOIN (
346 t3 LEFT JOIN (
347 t4 INNER JOIN t5 USING(a)
348 ) USING(a)
349 ) USING(a)
350 ) USING(a)
351 ORDER BY 1 NULLS FIRST;
352 } {
353 12 12 12 12 - -
354 15 15 15 15 15 15
355
356 }
357 do_execsql_test joinC-22 {
358 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
359 FROM t1 INNER JOIN (
360 t2 LEFT JOIN (
361 t3 LEFT JOIN (
362 t4 LEFT JOIN t5 USING(a)
363 ) USING(a)
364 ) USING(a)
365 ) USING(a)
366 ORDER BY 1 NULLS FIRST;
367 } {
368 12 12 12 12 - -
369 15 15 15 15 15 15
370
371 }
372 do_execsql_test joinC-23 {
373 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
374 FROM t1 INNER JOIN (
375 t2 LEFT JOIN (
376 t3 LEFT JOIN (
377 t4 RIGHT JOIN t5 USING(a)
378 ) USING(a)
379 ) USING(a)
380 ) USING(a)
381 ORDER BY 1 NULLS FIRST;
382 } {
383 12 12 12 12 - -
384 15 15 15 15 15 15
385
386 }
387 do_execsql_test joinC-24 {
388 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
389 FROM t1 INNER JOIN (
390 t2 LEFT JOIN (
391 t3 LEFT JOIN (
392 t4 FULL JOIN t5 USING(a)
393 ) USING(a)
394 ) USING(a)
395 ) USING(a)
396 ORDER BY 1 NULLS FIRST;
397 } {
398 12 12 12 12 - -
399 15 15 15 15 15 15
400
401 }
402 do_execsql_test joinC-25 {
403 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
404 FROM t1 INNER JOIN (
405 t2 LEFT JOIN (
406 t3 RIGHT JOIN (
407 t4 INNER JOIN t5 USING(a)
408 ) USING(a)
409 ) USING(a)
410 ) USING(a)
411 ORDER BY 1 NULLS FIRST;
412 } {
413 12 12 12 - - -
414 15 15 15 15 15 15
415
416 }
417 do_execsql_test joinC-26 {
418 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
419 FROM t1 INNER JOIN (
420 t2 LEFT JOIN (
421 t3 RIGHT JOIN (
422 t4 LEFT JOIN t5 USING(a)
423 ) USING(a)
424 ) USING(a)
425 ) USING(a)
426 ORDER BY 1 NULLS FIRST;
427 } {
428 12 12 12 - - -
429 15 15 15 15 15 15
430
431 }
432 do_execsql_test joinC-27 {
433 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
434 FROM t1 INNER JOIN (
435 t2 LEFT JOIN (
436 t3 RIGHT JOIN (
437 t4 RIGHT JOIN t5 USING(a)
438 ) USING(a)
439 ) USING(a)
440 ) USING(a)
441 ORDER BY 1 NULLS FIRST;
442 } {
443 12 12 12 - - -
444 15 15 15 15 15 15
445
446 }
447 do_execsql_test joinC-28 {
448 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
449 FROM t1 INNER JOIN (
450 t2 LEFT JOIN (
451 t3 RIGHT JOIN (
452 t4 FULL JOIN t5 USING(a)
453 ) USING(a)
454 ) USING(a)
455 ) USING(a)
456 ORDER BY 1 NULLS FIRST;
457 } {
458 12 12 12 - - -
459 15 15 15 15 15 15
460
461 }
462 do_execsql_test joinC-29 {
463 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
464 FROM t1 INNER JOIN (
465 t2 LEFT JOIN (
466 t3 FULL JOIN (
467 t4 INNER JOIN t5 USING(a)
468 ) USING(a)
469 ) USING(a)
470 ) USING(a)
471 ORDER BY 1 NULLS FIRST;
472 } {
473 12 12 12 12 - -
474 15 15 15 15 15 15
475
476 }
477 do_execsql_test joinC-30 {
478 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
479 FROM t1 INNER JOIN (
480 t2 LEFT JOIN (
481 t3 FULL JOIN (
482 t4 LEFT JOIN t5 USING(a)
483 ) USING(a)
484 ) USING(a)
485 ) USING(a)
486 ORDER BY 1 NULLS FIRST;
487 } {
488 12 12 12 12 - -
489 15 15 15 15 15 15
490
491 }
492 do_execsql_test joinC-31 {
493 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
494 FROM t1 INNER JOIN (
495 t2 LEFT JOIN (
496 t3 FULL JOIN (
497 t4 RIGHT JOIN t5 USING(a)
498 ) USING(a)
499 ) USING(a)
500 ) USING(a)
501 ORDER BY 1 NULLS FIRST;
502 } {
503 12 12 12 12 - -
504 15 15 15 15 15 15
505
506 }
507 do_execsql_test joinC-32 {
508 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
509 FROM t1 INNER JOIN (
510 t2 LEFT JOIN (
511 t3 FULL JOIN (
512 t4 FULL JOIN t5 USING(a)
513 ) USING(a)
514 ) USING(a)
515 ) USING(a)
516 ORDER BY 1 NULLS FIRST;
517 } {
518 12 12 12 12 - -
519 15 15 15 15 15 15
520
521 }
522 do_execsql_test joinC-33 {
523 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
524 FROM t1 INNER JOIN (
525 t2 RIGHT JOIN (
526 t3 INNER JOIN (
527 t4 INNER JOIN t5 USING(a)
528 ) USING(a)
529 ) USING(a)
530 ) USING(a)
531 ORDER BY 1 NULLS FIRST;
532 } {
533 15 15 15 15 15 15
534
535 }
536 do_execsql_test joinC-34 {
537 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
538 FROM t1 INNER JOIN (
539 t2 RIGHT JOIN (
540 t3 INNER JOIN (
541 t4 LEFT JOIN t5 USING(a)
542 ) USING(a)
543 ) USING(a)
544 ) USING(a)
545 ORDER BY 1 NULLS FIRST;
546 } {
547 11 11 - 11 11 -
548 15 15 15 15 15 15
549
550 }
551 do_execsql_test joinC-35 {
552 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
553 FROM t1 INNER JOIN (
554 t2 RIGHT JOIN (
555 t3 INNER JOIN (
556 t4 RIGHT JOIN t5 USING(a)
557 ) USING(a)
558 ) USING(a)
559 ) USING(a)
560 ORDER BY 1 NULLS FIRST;
561 } {
562 15 15 15 15 15 15
563 17 17 - 17 - 17
564
565 }
566 do_execsql_test joinC-36 {
567 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
568 FROM t1 INNER JOIN (
569 t2 RIGHT JOIN (
570 t3 INNER JOIN (
571 t4 FULL JOIN t5 USING(a)
572 ) USING(a)
573 ) USING(a)
574 ) USING(a)
575 ORDER BY 1 NULLS FIRST;
576 } {
577 11 11 - 11 11 -
578 15 15 15 15 15 15
579 17 17 - 17 - 17
580
581 }
582 do_execsql_test joinC-37 {
583 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
584 FROM t1 INNER JOIN (
585 t2 RIGHT JOIN (
586 t3 LEFT JOIN (
587 t4 INNER JOIN t5 USING(a)
588 ) USING(a)
589 ) USING(a)
590 ) USING(a)
591 ORDER BY 1 NULLS FIRST;
592 } {
593 11 11 - 11 - -
594 12 12 12 12 - -
595 15 15 15 15 15 15
596 17 17 - 17 - -
597
598 }
599 do_execsql_test joinC-38 {
600 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
601 FROM t1 INNER JOIN (
602 t2 RIGHT JOIN (
603 t3 LEFT JOIN (
604 t4 LEFT JOIN t5 USING(a)
605 ) USING(a)
606 ) USING(a)
607 ) USING(a)
608 ORDER BY 1 NULLS FIRST;
609 } {
610 11 11 - 11 11 -
611 12 12 12 12 - -
612 15 15 15 15 15 15
613 17 17 - 17 - -
614
615 }
616 do_execsql_test joinC-39 {
617 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
618 FROM t1 INNER JOIN (
619 t2 RIGHT JOIN (
620 t3 LEFT JOIN (
621 t4 RIGHT JOIN t5 USING(a)
622 ) USING(a)
623 ) USING(a)
624 ) USING(a)
625 ORDER BY 1 NULLS FIRST;
626 } {
627 11 11 - 11 - -
628 12 12 12 12 - -
629 15 15 15 15 15 15
630 17 17 - 17 - 17
631
632 }
633 do_execsql_test joinC-40 {
634 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
635 FROM t1 INNER JOIN (
636 t2 RIGHT JOIN (
637 t3 LEFT JOIN (
638 t4 FULL JOIN t5 USING(a)
639 ) USING(a)
640 ) USING(a)
641 ) USING(a)
642 ORDER BY 1 NULLS FIRST;
643 } {
644 11 11 - 11 11 -
645 12 12 12 12 - -
646 15 15 15 15 15 15
647 17 17 - 17 - 17
648
649 }
650 do_execsql_test joinC-41 {
651 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
652 FROM t1 INNER JOIN (
653 t2 RIGHT JOIN (
654 t3 RIGHT JOIN (
655 t4 INNER JOIN t5 USING(a)
656 ) USING(a)
657 ) USING(a)
658 ) USING(a)
659 ORDER BY 1 NULLS FIRST;
660 } {
661 15 15 15 15 15 15
662
663 }
664 do_execsql_test joinC-42 {
665 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
666 FROM t1 INNER JOIN (
667 t2 RIGHT JOIN (
668 t3 RIGHT JOIN (
669 t4 LEFT JOIN t5 USING(a)
670 ) USING(a)
671 ) USING(a)
672 ) USING(a)
673 ORDER BY 1 NULLS FIRST;
674 } {
675 11 11 - 11 11 -
676 15 15 15 15 15 15
677
678 }
679 do_execsql_test joinC-43 {
680 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
681 FROM t1 INNER JOIN (
682 t2 RIGHT JOIN (
683 t3 RIGHT JOIN (
684 t4 RIGHT JOIN t5 USING(a)
685 ) USING(a)
686 ) USING(a)
687 ) USING(a)
688 ORDER BY 1 NULLS FIRST;
689 } {
690 15 15 15 15 15 15
691 17 17 - 17 - 17
692
693 }
694 do_execsql_test joinC-44 {
695 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
696 FROM t1 INNER JOIN (
697 t2 RIGHT JOIN (
698 t3 RIGHT JOIN (
699 t4 FULL JOIN t5 USING(a)
700 ) USING(a)
701 ) USING(a)
702 ) USING(a)
703 ORDER BY 1 NULLS FIRST;
704 } {
705 11 11 - 11 11 -
706 15 15 15 15 15 15
707 17 17 - 17 - 17
708
709 }
710 do_execsql_test joinC-45 {
711 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
712 FROM t1 INNER JOIN (
713 t2 RIGHT JOIN (
714 t3 FULL JOIN (
715 t4 INNER JOIN t5 USING(a)
716 ) USING(a)
717 ) USING(a)
718 ) USING(a)
719 ORDER BY 1 NULLS FIRST;
720 } {
721 11 11 - 11 - -
722 12 12 12 12 - -
723 15 15 15 15 15 15
724 17 17 - 17 - -
725
726 }
727 do_execsql_test joinC-46 {
728 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
729 FROM t1 INNER JOIN (
730 t2 RIGHT JOIN (
731 t3 FULL JOIN (
732 t4 LEFT JOIN t5 USING(a)
733 ) USING(a)
734 ) USING(a)
735 ) USING(a)
736 ORDER BY 1 NULLS FIRST;
737 } {
738 11 11 - 11 11 -
739 12 12 12 12 - -
740 15 15 15 15 15 15
741 17 17 - 17 - -
742
743 }
744 do_execsql_test joinC-47 {
745 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
746 FROM t1 INNER JOIN (
747 t2 RIGHT JOIN (
748 t3 FULL JOIN (
749 t4 RIGHT JOIN t5 USING(a)
750 ) USING(a)
751 ) USING(a)
752 ) USING(a)
753 ORDER BY 1 NULLS FIRST;
754 } {
755 11 11 - 11 - -
756 12 12 12 12 - -
757 15 15 15 15 15 15
758 17 17 - 17 - 17
759
760 }
761 do_execsql_test joinC-48 {
762 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
763 FROM t1 INNER JOIN (
764 t2 RIGHT JOIN (
765 t3 FULL JOIN (
766 t4 FULL JOIN t5 USING(a)
767 ) USING(a)
768 ) USING(a)
769 ) USING(a)
770 ORDER BY 1 NULLS FIRST;
771 } {
772 11 11 - 11 11 -
773 12 12 12 12 - -
774 15 15 15 15 15 15
775 17 17 - 17 - 17
776
777 }
778 do_execsql_test joinC-49 {
779 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
780 FROM t1 INNER JOIN (
781 t2 FULL JOIN (
782 t3 INNER JOIN (
783 t4 INNER JOIN t5 USING(a)
784 ) USING(a)
785 ) USING(a)
786 ) USING(a)
787 ORDER BY 1 NULLS FIRST;
788 } {
789 12 12 12 - - -
790 15 15 15 15 15 15
791
792 }
793 do_execsql_test joinC-50 {
794 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
795 FROM t1 INNER JOIN (
796 t2 FULL JOIN (
797 t3 INNER JOIN (
798 t4 LEFT JOIN t5 USING(a)
799 ) USING(a)
800 ) USING(a)
801 ) USING(a)
802 ORDER BY 1 NULLS FIRST;
803 } {
804 11 11 - 11 11 -
805 12 12 12 - - -
806 15 15 15 15 15 15
807
808 }
809 do_execsql_test joinC-51 {
810 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
811 FROM t1 INNER JOIN (
812 t2 FULL JOIN (
813 t3 INNER JOIN (
814 t4 RIGHT JOIN t5 USING(a)
815 ) USING(a)
816 ) USING(a)
817 ) USING(a)
818 ORDER BY 1 NULLS FIRST;
819 } {
820 12 12 12 - - -
821 15 15 15 15 15 15
822 17 17 - 17 - 17
823
824 }
825 do_execsql_test joinC-52 {
826 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
827 FROM t1 INNER JOIN (
828 t2 FULL JOIN (
829 t3 INNER JOIN (
830 t4 FULL JOIN t5 USING(a)
831 ) USING(a)
832 ) USING(a)
833 ) USING(a)
834 ORDER BY 1 NULLS FIRST;
835 } {
836 11 11 - 11 11 -
837 12 12 12 - - -
838 15 15 15 15 15 15
839 17 17 - 17 - 17
840
841 }
842 do_execsql_test joinC-53 {
843 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
844 FROM t1 INNER JOIN (
845 t2 FULL JOIN (
846 t3 LEFT JOIN (
847 t4 INNER JOIN t5 USING(a)
848 ) USING(a)
849 ) USING(a)
850 ) USING(a)
851 ORDER BY 1 NULLS FIRST;
852 } {
853 11 11 - 11 - -
854 12 12 12 12 - -
855 15 15 15 15 15 15
856 17 17 - 17 - -
857
858 }
859 do_execsql_test joinC-54 {
860 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
861 FROM t1 INNER JOIN (
862 t2 FULL JOIN (
863 t3 LEFT JOIN (
864 t4 LEFT JOIN t5 USING(a)
865 ) USING(a)
866 ) USING(a)
867 ) USING(a)
868 ORDER BY 1 NULLS FIRST;
869 } {
870 11 11 - 11 11 -
871 12 12 12 12 - -
872 15 15 15 15 15 15
873 17 17 - 17 - -
874
875 }
876 do_execsql_test joinC-55 {
877 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
878 FROM t1 INNER JOIN (
879 t2 FULL JOIN (
880 t3 LEFT JOIN (
881 t4 RIGHT JOIN t5 USING(a)
882 ) USING(a)
883 ) USING(a)
884 ) USING(a)
885 ORDER BY 1 NULLS FIRST;
886 } {
887 11 11 - 11 - -
888 12 12 12 12 - -
889 15 15 15 15 15 15
890 17 17 - 17 - 17
891
892 }
893 do_execsql_test joinC-56 {
894 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
895 FROM t1 INNER JOIN (
896 t2 FULL JOIN (
897 t3 LEFT JOIN (
898 t4 FULL JOIN t5 USING(a)
899 ) USING(a)
900 ) USING(a)
901 ) USING(a)
902 ORDER BY 1 NULLS FIRST;
903 } {
904 11 11 - 11 11 -
905 12 12 12 12 - -
906 15 15 15 15 15 15
907 17 17 - 17 - 17
908
909 }
910 do_execsql_test joinC-57 {
911 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
912 FROM t1 INNER JOIN (
913 t2 FULL JOIN (
914 t3 RIGHT JOIN (
915 t4 INNER JOIN t5 USING(a)
916 ) USING(a)
917 ) USING(a)
918 ) USING(a)
919 ORDER BY 1 NULLS FIRST;
920 } {
921 12 12 12 - - -
922 15 15 15 15 15 15
923
924 }
925 do_execsql_test joinC-58 {
926 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
927 FROM t1 INNER JOIN (
928 t2 FULL JOIN (
929 t3 RIGHT JOIN (
930 t4 LEFT JOIN t5 USING(a)
931 ) USING(a)
932 ) USING(a)
933 ) USING(a)
934 ORDER BY 1 NULLS FIRST;
935 } {
936 11 11 - 11 11 -
937 12 12 12 - - -
938 15 15 15 15 15 15
939
940 }
941 do_execsql_test joinC-59 {
942 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
943 FROM t1 INNER JOIN (
944 t2 FULL JOIN (
945 t3 RIGHT JOIN (
946 t4 RIGHT JOIN t5 USING(a)
947 ) USING(a)
948 ) USING(a)
949 ) USING(a)
950 ORDER BY 1 NULLS FIRST;
951 } {
952 12 12 12 - - -
953 15 15 15 15 15 15
954 17 17 - 17 - 17
955
956 }
957 do_execsql_test joinC-60 {
958 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
959 FROM t1 INNER JOIN (
960 t2 FULL JOIN (
961 t3 RIGHT JOIN (
962 t4 FULL JOIN t5 USING(a)
963 ) USING(a)
964 ) USING(a)
965 ) USING(a)
966 ORDER BY 1 NULLS FIRST;
967 } {
968 11 11 - 11 11 -
969 12 12 12 - - -
970 15 15 15 15 15 15
971 17 17 - 17 - 17
972
973 }
974 do_execsql_test joinC-61 {
975 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
976 FROM t1 INNER JOIN (
977 t2 FULL JOIN (
978 t3 FULL JOIN (
979 t4 INNER JOIN t5 USING(a)
980 ) USING(a)
981 ) USING(a)
982 ) USING(a)
983 ORDER BY 1 NULLS FIRST;
984 } {
985 11 11 - 11 - -
986 12 12 12 12 - -
987 15 15 15 15 15 15
988 17 17 - 17 - -
989
990 }
991 do_execsql_test joinC-62 {
992 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
993 FROM t1 INNER JOIN (
994 t2 FULL JOIN (
995 t3 FULL JOIN (
996 t4 LEFT JOIN t5 USING(a)
997 ) USING(a)
998 ) USING(a)
999 ) USING(a)
1000 ORDER BY 1 NULLS FIRST;
1001 } {
1002 11 11 - 11 11 -
1003 12 12 12 12 - -
1004 15 15 15 15 15 15
1005 17 17 - 17 - -
1006
1007 }
1008 do_execsql_test joinC-63 {
1009 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
1010 FROM t1 INNER JOIN (
1011 t2 FULL JOIN (
1012 t3 FULL JOIN (
1013 t4 RIGHT JOIN t5 USING(a)
1014 ) USING(a)
1015 ) USING(a)
1016 ) USING(a)
1017 ORDER BY 1 NULLS FIRST;
1018 } {
1019 11 11 - 11 - -
1020 12 12 12 12 - -
1021 15 15 15 15 15 15
1022 17 17 - 17 - 17
1023
1024 }
1025 do_execsql_test joinC-64 {
1026 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
1027 FROM t1 INNER JOIN (
1028 t2 FULL JOIN (
1029 t3 FULL JOIN (
1030 t4 FULL JOIN t5 USING(a)
1031 ) USING(a)
1032 ) USING(a)
1033 ) USING(a)
1034 ORDER BY 1 NULLS FIRST;
1035 } {
1036 11 11 - 11 11 -
1037 12 12 12 12 - -
1038 15 15 15 15 15 15
1039 17 17 - 17 - 17
1040
1041 }
1042 do_execsql_test joinC-65 {
1043 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
1044 FROM t1 LEFT JOIN (
1045 t2 INNER JOIN (
1046 t3 INNER JOIN (
1047 t4 INNER JOIN t5 USING(a)
1048 ) USING(a)
1049 ) USING(a)
1050 ) USING(a)
1051 ORDER BY 1 NULLS FIRST;
1052 } {
1053 11 11 - - - -
1054 12 12 - - - -
1055 15 15 15 15 15 15
1056 17 17 - - - -
1057
1058 }
1059 do_execsql_test joinC-66 {
1060 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
1061 FROM t1 LEFT JOIN (
1062 t2 INNER JOIN (
1063 t3 INNER JOIN (
1064 t4 LEFT JOIN t5 USING(a)
1065 ) USING(a)
1066 ) USING(a)
1067 ) USING(a)
1068 ORDER BY 1 NULLS FIRST;
1069 } {
1070 11 11 - - - -
1071 12 12 - - - -
1072 15 15 15 15 15 15
1073 17 17 - - - -
1074
1075 }
1076 do_execsql_test joinC-67 {
1077 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
1078 FROM t1 LEFT JOIN (
1079 t2 INNER JOIN (
1080 t3 INNER JOIN (
1081 t4 RIGHT JOIN t5 USING(a)
1082 ) USING(a)
1083 ) USING(a)
1084 ) USING(a)
1085 ORDER BY 1 NULLS FIRST;
1086 } {
1087 11 11 - - - -
1088 12 12 - - - -
1089 15 15 15 15 15 15
1090 17 17 - - - -
1091
1092 }
1093 do_execsql_test joinC-68 {
1094 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
1095 FROM t1 LEFT JOIN (
1096 t2 INNER JOIN (
1097 t3 INNER JOIN (
1098 t4 FULL JOIN t5 USING(a)
1099 ) USING(a)
1100 ) USING(a)
1101 ) USING(a)
1102 ORDER BY 1 NULLS FIRST;
1103 } {
1104 11 11 - - - -
1105 12 12 - - - -
1106 15 15 15 15 15 15
1107 17 17 - - - -
1108
1109 }
1110 do_execsql_test joinC-69 {
1111 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
1112 FROM t1 LEFT JOIN (
1113 t2 INNER JOIN (
1114 t3 LEFT JOIN (
1115 t4 INNER JOIN t5 USING(a)
1116 ) USING(a)
1117 ) USING(a)
1118 ) USING(a)
1119 ORDER BY 1 NULLS FIRST;
1120 } {
1121 11 11 - - - -
1122 12 12 12 12 - -
1123 15 15 15 15 15 15
1124 17 17 - - - -
1125
1126 }
1127 do_execsql_test joinC-70 {
1128 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
1129 FROM t1 LEFT JOIN (
1130 t2 INNER JOIN (
1131 t3 LEFT JOIN (
1132 t4 LEFT JOIN t5 USING(a)
1133 ) USING(a)
1134 ) USING(a)
1135 ) USING(a)
1136 ORDER BY 1 NULLS FIRST;
1137 } {
1138 11 11 - - - -
1139 12 12 12 12 - -
1140 15 15 15 15 15 15
1141 17 17 - - - -
1142
1143 }
1144 do_execsql_test joinC-71 {
1145 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
1146 FROM t1 LEFT JOIN (
1147 t2 INNER JOIN (
1148 t3 LEFT JOIN (
1149 t4 RIGHT JOIN t5 USING(a)
1150 ) USING(a)
1151 ) USING(a)
1152 ) USING(a)
1153 ORDER BY 1 NULLS FIRST;
1154 } {
1155 11 11 - - - -
1156 12 12 12 12 - -
1157 15 15 15 15 15 15
1158 17 17 - - - -
1159
1160 }
1161 do_execsql_test joinC-72 {
1162 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
1163 FROM t1 LEFT JOIN (
1164 t2 INNER JOIN (
1165 t3 LEFT JOIN (
1166 t4 FULL JOIN t5 USING(a)
1167 ) USING(a)
1168 ) USING(a)
1169 ) USING(a)
1170 ORDER BY 1 NULLS FIRST;
1171 } {
1172 11 11 - - - -
1173 12 12 12 12 - -
1174 15 15 15 15 15 15
1175 17 17 - - - -
1176
1177 }
1178 do_execsql_test joinC-73 {
1179 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
1180 FROM t1 LEFT JOIN (
1181 t2 INNER JOIN (
1182 t3 RIGHT JOIN (
1183 t4 INNER JOIN t5 USING(a)
1184 ) USING(a)
1185 ) USING(a)
1186 ) USING(a)
1187 ORDER BY 1 NULLS FIRST;
1188 } {
1189 11 11 - - - -
1190 12 12 - - - -
1191 15 15 15 15 15 15
1192 17 17 - - - -
1193
1194 }
1195 do_execsql_test joinC-74 {
1196 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
1197 FROM t1 LEFT JOIN (
1198 t2 INNER JOIN (
1199 t3 RIGHT JOIN (
1200 t4 LEFT JOIN t5 USING(a)
1201 ) USING(a)
1202 ) USING(a)
1203 ) USING(a)
1204 ORDER BY 1 NULLS FIRST;
1205 } {
1206 11 11 - - - -
1207 12 12 - - - -
1208 15 15 15 15 15 15
1209 17 17 - - - -
1210
1211 }
1212 do_execsql_test joinC-75 {
1213 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
1214 FROM t1 LEFT JOIN (
1215 t2 INNER JOIN (
1216 t3 RIGHT JOIN (
1217 t4 RIGHT JOIN t5 USING(a)
1218 ) USING(a)
1219 ) USING(a)
1220 ) USING(a)
1221 ORDER BY 1 NULLS FIRST;
1222 } {
1223 11 11 - - - -
1224 12 12 - - - -
1225 15 15 15 15 15 15
1226 17 17 - - - -
1227
1228 }
1229 do_execsql_test joinC-76 {
1230 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
1231 FROM t1 LEFT JOIN (
1232 t2 INNER JOIN (
1233 t3 RIGHT JOIN (
1234 t4 FULL JOIN t5 USING(a)
1235 ) USING(a)
1236 ) USING(a)
1237 ) USING(a)
1238 ORDER BY 1 NULLS FIRST;
1239 } {
1240 11 11 - - - -
1241 12 12 - - - -
1242 15 15 15 15 15 15
1243 17 17 - - - -
1244
1245 }
1246 do_execsql_test joinC-77 {
1247 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
1248 FROM t1 LEFT JOIN (
1249 t2 INNER JOIN (
1250 t3 FULL JOIN (
1251 t4 INNER JOIN t5 USING(a)
1252 ) USING(a)
1253 ) USING(a)
1254 ) USING(a)
1255 ORDER BY 1 NULLS FIRST;
1256 } {
1257 11 11 - - - -
1258 12 12 12 12 - -
1259 15 15 15 15 15 15
1260 17 17 - - - -
1261
1262 }
1263 do_execsql_test joinC-78 {
1264 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
1265 FROM t1 LEFT JOIN (
1266 t2 INNER JOIN (
1267 t3 FULL JOIN (
1268 t4 LEFT JOIN t5 USING(a)
1269 ) USING(a)
1270 ) USING(a)
1271 ) USING(a)
1272 ORDER BY 1 NULLS FIRST;
1273 } {
1274 11 11 - - - -
1275 12 12 12 12 - -
1276 15 15 15 15 15 15
1277 17 17 - - - -
1278
1279 }
1280 do_execsql_test joinC-79 {
1281 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
1282 FROM t1 LEFT JOIN (
1283 t2 INNER JOIN (
1284 t3 FULL JOIN (
1285 t4 RIGHT JOIN t5 USING(a)
1286 ) USING(a)
1287 ) USING(a)
1288 ) USING(a)
1289 ORDER BY 1 NULLS FIRST;
1290 } {
1291 11 11 - - - -
1292 12 12 12 12 - -
1293 15 15 15 15 15 15
1294 17 17 - - - -
1295
1296 }
1297 do_execsql_test joinC-80 {
1298 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
1299 FROM t1 LEFT JOIN (
1300 t2 INNER JOIN (
1301 t3 FULL JOIN (
1302 t4 FULL JOIN t5 USING(a)
1303 ) USING(a)
1304 ) USING(a)
1305 ) USING(a)
1306 ORDER BY 1 NULLS FIRST;
1307 } {
1308 11 11 - - - -
1309 12 12 12 12 - -
1310 15 15 15 15 15 15
1311 17 17 - - - -
1312
1313 }
1314 do_execsql_test joinC-81 {
1315 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
1316 FROM t1 LEFT JOIN (
1317 t2 LEFT JOIN (
1318 t3 INNER JOIN (
1319 t4 INNER JOIN t5 USING(a)
1320 ) USING(a)
1321 ) USING(a)
1322 ) USING(a)
1323 ORDER BY 1 NULLS FIRST;
1324 } {
1325 11 11 - - - -
1326 12 12 12 - - -
1327 15 15 15 15 15 15
1328 17 17 - - - -
1329
1330 }
1331 do_execsql_test joinC-82 {
1332 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
1333 FROM t1 LEFT JOIN (
1334 t2 LEFT JOIN (
1335 t3 INNER JOIN (
1336 t4 LEFT JOIN t5 USING(a)
1337 ) USING(a)
1338 ) USING(a)
1339 ) USING(a)
1340 ORDER BY 1 NULLS FIRST;
1341 } {
1342 11 11 - - - -
1343 12 12 12 - - -
1344 15 15 15 15 15 15
1345 17 17 - - - -
1346
1347 }
1348 do_execsql_test joinC-83 {
1349 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
1350 FROM t1 LEFT JOIN (
1351 t2 LEFT JOIN (
1352 t3 INNER JOIN (
1353 t4 RIGHT JOIN t5 USING(a)
1354 ) USING(a)
1355 ) USING(a)
1356 ) USING(a)
1357 ORDER BY 1 NULLS FIRST;
1358 } {
1359 11 11 - - - -
1360 12 12 12 - - -
1361 15 15 15 15 15 15
1362 17 17 - - - -
1363
1364 }
1365 do_execsql_test joinC-84 {
1366 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
1367 FROM t1 LEFT JOIN (
1368 t2 LEFT JOIN (
1369 t3 INNER JOIN (
1370 t4 FULL JOIN t5 USING(a)
1371 ) USING(a)
1372 ) USING(a)
1373 ) USING(a)
1374 ORDER BY 1 NULLS FIRST;
1375 } {
1376 11 11 - - - -
1377 12 12 12 - - -
1378 15 15 15 15 15 15
1379 17 17 - - - -
1380
1381 }
1382 do_execsql_test joinC-85 {
1383 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
1384 FROM t1 LEFT JOIN (
1385 t2 LEFT JOIN (
1386 t3 LEFT JOIN (
1387 t4 INNER JOIN t5 USING(a)
1388 ) USING(a)
1389 ) USING(a)
1390 ) USING(a)
1391 ORDER BY 1 NULLS FIRST;
1392 } {
1393 11 11 - - - -
1394 12 12 12 12 - -
1395 15 15 15 15 15 15
1396 17 17 - - - -
1397
1398 }
1399 do_execsql_test joinC-86 {
1400 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
1401 FROM t1 LEFT JOIN (
1402 t2 LEFT JOIN (
1403 t3 LEFT JOIN (
1404 t4 LEFT JOIN t5 USING(a)
1405 ) USING(a)
1406 ) USING(a)
1407 ) USING(a)
1408 ORDER BY 1 NULLS FIRST;
1409 } {
1410 11 11 - - - -
1411 12 12 12 12 - -
1412 15 15 15 15 15 15
1413 17 17 - - - -
1414
1415 }
1416 do_execsql_test joinC-87 {
1417 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
1418 FROM t1 LEFT JOIN (
1419 t2 LEFT JOIN (
1420 t3 LEFT JOIN (
1421 t4 RIGHT JOIN t5 USING(a)
1422 ) USING(a)
1423 ) USING(a)
1424 ) USING(a)
1425 ORDER BY 1 NULLS FIRST;
1426 } {
1427 11 11 - - - -
1428 12 12 12 12 - -
1429 15 15 15 15 15 15
1430 17 17 - - - -
1431
1432 }
1433 do_execsql_test joinC-88 {
1434 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
1435 FROM t1 LEFT JOIN (
1436 t2 LEFT JOIN (
1437 t3 LEFT JOIN (
1438 t4 FULL JOIN t5 USING(a)
1439 ) USING(a)
1440 ) USING(a)
1441 ) USING(a)
1442 ORDER BY 1 NULLS FIRST;
1443 } {
1444 11 11 - - - -
1445 12 12 12 12 - -
1446 15 15 15 15 15 15
1447 17 17 - - - -
1448
1449 }
1450 do_execsql_test joinC-89 {
1451 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
1452 FROM t1 LEFT JOIN (
1453 t2 LEFT JOIN (
1454 t3 RIGHT JOIN (
1455 t4 INNER JOIN t5 USING(a)
1456 ) USING(a)
1457 ) USING(a)
1458 ) USING(a)
1459 ORDER BY 1 NULLS FIRST;
1460 } {
1461 11 11 - - - -
1462 12 12 12 - - -
1463 15 15 15 15 15 15
1464 17 17 - - - -
1465
1466 }
1467 do_execsql_test joinC-90 {
1468 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
1469 FROM t1 LEFT JOIN (
1470 t2 LEFT JOIN (
1471 t3 RIGHT JOIN (
1472 t4 LEFT JOIN t5 USING(a)
1473 ) USING(a)
1474 ) USING(a)
1475 ) USING(a)
1476 ORDER BY 1 NULLS FIRST;
1477 } {
1478 11 11 - - - -
1479 12 12 12 - - -
1480 15 15 15 15 15 15
1481 17 17 - - - -
1482
1483 }
1484 do_execsql_test joinC-91 {
1485 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
1486 FROM t1 LEFT JOIN (
1487 t2 LEFT JOIN (
1488 t3 RIGHT JOIN (
1489 t4 RIGHT JOIN t5 USING(a)
1490 ) USING(a)
1491 ) USING(a)
1492 ) USING(a)
1493 ORDER BY 1 NULLS FIRST;
1494 } {
1495 11 11 - - - -
1496 12 12 12 - - -
1497 15 15 15 15 15 15
1498 17 17 - - - -
1499
1500 }
1501 do_execsql_test joinC-92 {
1502 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
1503 FROM t1 LEFT JOIN (
1504 t2 LEFT JOIN (
1505 t3 RIGHT JOIN (
1506 t4 FULL JOIN t5 USING(a)
1507 ) USING(a)
1508 ) USING(a)
1509 ) USING(a)
1510 ORDER BY 1 NULLS FIRST;
1511 } {
1512 11 11 - - - -
1513 12 12 12 - - -
1514 15 15 15 15 15 15
1515 17 17 - - - -
1516
1517 }
1518 do_execsql_test joinC-93 {
1519 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
1520 FROM t1 LEFT JOIN (
1521 t2 LEFT JOIN (
1522 t3 FULL JOIN (
1523 t4 INNER JOIN t5 USING(a)
1524 ) USING(a)
1525 ) USING(a)
1526 ) USING(a)
1527 ORDER BY 1 NULLS FIRST;
1528 } {
1529 11 11 - - - -
1530 12 12 12 12 - -
1531 15 15 15 15 15 15
1532 17 17 - - - -
1533
1534 }
1535 do_execsql_test joinC-94 {
1536 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
1537 FROM t1 LEFT JOIN (
1538 t2 LEFT JOIN (
1539 t3 FULL JOIN (
1540 t4 LEFT JOIN t5 USING(a)
1541 ) USING(a)
1542 ) USING(a)
1543 ) USING(a)
1544 ORDER BY 1 NULLS FIRST;
1545 } {
1546 11 11 - - - -
1547 12 12 12 12 - -
1548 15 15 15 15 15 15
1549 17 17 - - - -
1550
1551 }
1552 do_execsql_test joinC-95 {
1553 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
1554 FROM t1 LEFT JOIN (
1555 t2 LEFT JOIN (
1556 t3 FULL JOIN (
1557 t4 RIGHT JOIN t5 USING(a)
1558 ) USING(a)
1559 ) USING(a)
1560 ) USING(a)
1561 ORDER BY 1 NULLS FIRST;
1562 } {
1563 11 11 - - - -
1564 12 12 12 12 - -
1565 15 15 15 15 15 15
1566 17 17 - - - -
1567
1568 }
1569 do_execsql_test joinC-96 {
1570 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
1571 FROM t1 LEFT JOIN (
1572 t2 LEFT JOIN (
1573 t3 FULL JOIN (
1574 t4 FULL JOIN t5 USING(a)
1575 ) USING(a)
1576 ) USING(a)
1577 ) USING(a)
1578 ORDER BY 1 NULLS FIRST;
1579 } {
1580 11 11 - - - -
1581 12 12 12 12 - -
1582 15 15 15 15 15 15
1583 17 17 - - - -
1584
1585 }
1586 do_execsql_test joinC-97 {
1587 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
1588 FROM t1 LEFT JOIN (
1589 t2 RIGHT JOIN (
1590 t3 INNER JOIN (
1591 t4 INNER JOIN t5 USING(a)
1592 ) USING(a)
1593 ) USING(a)
1594 ) USING(a)
1595 ORDER BY 1 NULLS FIRST;
1596 } {
1597 11 11 - - - -
1598 12 12 - - - -
1599 15 15 15 15 15 15
1600 17 17 - - - -
1601
1602 }
1603 do_execsql_test joinC-98 {
1604 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
1605 FROM t1 LEFT JOIN (
1606 t2 RIGHT JOIN (
1607 t3 INNER JOIN (
1608 t4 LEFT JOIN t5 USING(a)
1609 ) USING(a)
1610 ) USING(a)
1611 ) USING(a)
1612 ORDER BY 1 NULLS FIRST;
1613 } {
1614 11 11 - 11 11 -
1615 12 12 - - - -
1616 15 15 15 15 15 15
1617 17 17 - - - -
1618
1619 }
1620 do_execsql_test joinC-99 {
1621 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
1622 FROM t1 LEFT JOIN (
1623 t2 RIGHT JOIN (
1624 t3 INNER JOIN (
1625 t4 RIGHT JOIN t5 USING(a)
1626 ) USING(a)
1627 ) USING(a)
1628 ) USING(a)
1629 ORDER BY 1 NULLS FIRST;
1630 } {
1631 11 11 - - - -
1632 12 12 - - - -
1633 15 15 15 15 15 15
1634 17 17 - 17 - 17
1635
1636 }
1637 do_execsql_test joinC-100 {
1638 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
1639 FROM t1 LEFT JOIN (
1640 t2 RIGHT JOIN (
1641 t3 INNER JOIN (
1642 t4 FULL JOIN t5 USING(a)
1643 ) USING(a)
1644 ) USING(a)
1645 ) USING(a)
1646 ORDER BY 1 NULLS FIRST;
1647 } {
1648 11 11 - 11 11 -
1649 12 12 - - - -
1650 15 15 15 15 15 15
1651 17 17 - 17 - 17
1652
1653 }
1654 do_execsql_test joinC-101 {
1655 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
1656 FROM t1 LEFT JOIN (
1657 t2 RIGHT JOIN (
1658 t3 LEFT JOIN (
1659 t4 INNER JOIN t5 USING(a)
1660 ) USING(a)
1661 ) USING(a)
1662 ) USING(a)
1663 ORDER BY 1 NULLS FIRST;
1664 } {
1665 11 11 - 11 - -
1666 12 12 12 12 - -
1667 15 15 15 15 15 15
1668 17 17 - 17 - -
1669
1670 }
1671 do_execsql_test joinC-102 {
1672 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
1673 FROM t1 LEFT JOIN (
1674 t2 RIGHT JOIN (
1675 t3 LEFT JOIN (
1676 t4 LEFT JOIN t5 USING(a)
1677 ) USING(a)
1678 ) USING(a)
1679 ) USING(a)
1680 ORDER BY 1 NULLS FIRST;
1681 } {
1682 11 11 - 11 11 -
1683 12 12 12 12 - -
1684 15 15 15 15 15 15
1685 17 17 - 17 - -
1686
1687 }
1688 do_execsql_test joinC-103 {
1689 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
1690 FROM t1 LEFT JOIN (
1691 t2 RIGHT JOIN (
1692 t3 LEFT JOIN (
1693 t4 RIGHT JOIN t5 USING(a)
1694 ) USING(a)
1695 ) USING(a)
1696 ) USING(a)
1697 ORDER BY 1 NULLS FIRST;
1698 } {
1699 11 11 - 11 - -
1700 12 12 12 12 - -
1701 15 15 15 15 15 15
1702 17 17 - 17 - 17
1703
1704 }
1705 do_execsql_test joinC-104 {
1706 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
1707 FROM t1 LEFT JOIN (
1708 t2 RIGHT JOIN (
1709 t3 LEFT JOIN (
1710 t4 FULL JOIN t5 USING(a)
1711 ) USING(a)
1712 ) USING(a)
1713 ) USING(a)
1714 ORDER BY 1 NULLS FIRST;
1715 } {
1716 11 11 - 11 11 -
1717 12 12 12 12 - -
1718 15 15 15 15 15 15
1719 17 17 - 17 - 17
1720
1721 }
1722 do_execsql_test joinC-105 {
1723 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
1724 FROM t1 LEFT JOIN (
1725 t2 RIGHT JOIN (
1726 t3 RIGHT JOIN (
1727 t4 INNER JOIN t5 USING(a)
1728 ) USING(a)
1729 ) USING(a)
1730 ) USING(a)
1731 ORDER BY 1 NULLS FIRST;
1732 } {
1733 11 11 - - - -
1734 12 12 - - - -
1735 15 15 15 15 15 15
1736 17 17 - - - -
1737
1738 }
1739 do_execsql_test joinC-106 {
1740 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
1741 FROM t1 LEFT JOIN (
1742 t2 RIGHT JOIN (
1743 t3 RIGHT JOIN (
1744 t4 LEFT JOIN t5 USING(a)
1745 ) USING(a)
1746 ) USING(a)
1747 ) USING(a)
1748 ORDER BY 1 NULLS FIRST;
1749 } {
1750 11 11 - 11 11 -
1751 12 12 - - - -
1752 15 15 15 15 15 15
1753 17 17 - - - -
1754
1755 }
1756 do_execsql_test joinC-107 {
1757 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
1758 FROM t1 LEFT JOIN (
1759 t2 RIGHT JOIN (
1760 t3 RIGHT JOIN (
1761 t4 RIGHT JOIN t5 USING(a)
1762 ) USING(a)
1763 ) USING(a)
1764 ) USING(a)
1765 ORDER BY 1 NULLS FIRST;
1766 } {
1767 11 11 - - - -
1768 12 12 - - - -
1769 15 15 15 15 15 15
1770 17 17 - 17 - 17
1771
1772 }
1773 do_execsql_test joinC-108 {
1774 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
1775 FROM t1 LEFT JOIN (
1776 t2 RIGHT JOIN (
1777 t3 RIGHT JOIN (
1778 t4 FULL JOIN t5 USING(a)
1779 ) USING(a)
1780 ) USING(a)
1781 ) USING(a)
1782 ORDER BY 1 NULLS FIRST;
1783 } {
1784 11 11 - 11 11 -
1785 12 12 - - - -
1786 15 15 15 15 15 15
1787 17 17 - 17 - 17
1788
1789 }
1790 do_execsql_test joinC-109 {
1791 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
1792 FROM t1 LEFT JOIN (
1793 t2 RIGHT JOIN (
1794 t3 FULL JOIN (
1795 t4 INNER JOIN t5 USING(a)
1796 ) USING(a)
1797 ) USING(a)
1798 ) USING(a)
1799 ORDER BY 1 NULLS FIRST;
1800 } {
1801 11 11 - 11 - -
1802 12 12 12 12 - -
1803 15 15 15 15 15 15
1804 17 17 - 17 - -
1805
1806 }
1807 do_execsql_test joinC-110 {
1808 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
1809 FROM t1 LEFT JOIN (
1810 t2 RIGHT JOIN (
1811 t3 FULL JOIN (
1812 t4 LEFT JOIN t5 USING(a)
1813 ) USING(a)
1814 ) USING(a)
1815 ) USING(a)
1816 ORDER BY 1 NULLS FIRST;
1817 } {
1818 11 11 - 11 11 -
1819 12 12 12 12 - -
1820 15 15 15 15 15 15
1821 17 17 - 17 - -
1822
1823 }
1824 do_execsql_test joinC-111 {
1825 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
1826 FROM t1 LEFT JOIN (
1827 t2 RIGHT JOIN (
1828 t3 FULL JOIN (
1829 t4 RIGHT JOIN t5 USING(a)
1830 ) USING(a)
1831 ) USING(a)
1832 ) USING(a)
1833 ORDER BY 1 NULLS FIRST;
1834 } {
1835 11 11 - 11 - -
1836 12 12 12 12 - -
1837 15 15 15 15 15 15
1838 17 17 - 17 - 17
1839
1840 }
1841 do_execsql_test joinC-112 {
1842 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
1843 FROM t1 LEFT JOIN (
1844 t2 RIGHT JOIN (
1845 t3 FULL JOIN (
1846 t4 FULL JOIN t5 USING(a)
1847 ) USING(a)
1848 ) USING(a)
1849 ) USING(a)
1850 ORDER BY 1 NULLS FIRST;
1851 } {
1852 11 11 - 11 11 -
1853 12 12 12 12 - -
1854 15 15 15 15 15 15
1855 17 17 - 17 - 17
1856
1857 }
1858 do_execsql_test joinC-113 {
1859 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
1860 FROM t1 LEFT JOIN (
1861 t2 FULL JOIN (
1862 t3 INNER JOIN (
1863 t4 INNER JOIN t5 USING(a)
1864 ) USING(a)
1865 ) USING(a)
1866 ) USING(a)
1867 ORDER BY 1 NULLS FIRST;
1868 } {
1869 11 11 - - - -
1870 12 12 12 - - -
1871 15 15 15 15 15 15
1872 17 17 - - - -
1873
1874 }
1875 do_execsql_test joinC-114 {
1876 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
1877 FROM t1 LEFT JOIN (
1878 t2 FULL JOIN (
1879 t3 INNER JOIN (
1880 t4 LEFT JOIN t5 USING(a)
1881 ) USING(a)
1882 ) USING(a)
1883 ) USING(a)
1884 ORDER BY 1 NULLS FIRST;
1885 } {
1886 11 11 - 11 11 -
1887 12 12 12 - - -
1888 15 15 15 15 15 15
1889 17 17 - - - -
1890
1891 }
1892 do_execsql_test joinC-115 {
1893 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
1894 FROM t1 LEFT JOIN (
1895 t2 FULL JOIN (
1896 t3 INNER JOIN (
1897 t4 RIGHT JOIN t5 USING(a)
1898 ) USING(a)
1899 ) USING(a)
1900 ) USING(a)
1901 ORDER BY 1 NULLS FIRST;
1902 } {
1903 11 11 - - - -
1904 12 12 12 - - -
1905 15 15 15 15 15 15
1906 17 17 - 17 - 17
1907
1908 }
1909 do_execsql_test joinC-116 {
1910 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
1911 FROM t1 LEFT JOIN (
1912 t2 FULL JOIN (
1913 t3 INNER JOIN (
1914 t4 FULL JOIN t5 USING(a)
1915 ) USING(a)
1916 ) USING(a)
1917 ) USING(a)
1918 ORDER BY 1 NULLS FIRST;
1919 } {
1920 11 11 - 11 11 -
1921 12 12 12 - - -
1922 15 15 15 15 15 15
1923 17 17 - 17 - 17
1924
1925 }
1926 do_execsql_test joinC-117 {
1927 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
1928 FROM t1 LEFT JOIN (
1929 t2 FULL JOIN (
1930 t3 LEFT JOIN (
1931 t4 INNER JOIN t5 USING(a)
1932 ) USING(a)
1933 ) USING(a)
1934 ) USING(a)
1935 ORDER BY 1 NULLS FIRST;
1936 } {
1937 11 11 - 11 - -
1938 12 12 12 12 - -
1939 15 15 15 15 15 15
1940 17 17 - 17 - -
1941
1942 }
1943 do_execsql_test joinC-118 {
1944 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
1945 FROM t1 LEFT JOIN (
1946 t2 FULL JOIN (
1947 t3 LEFT JOIN (
1948 t4 LEFT JOIN t5 USING(a)
1949 ) USING(a)
1950 ) USING(a)
1951 ) USING(a)
1952 ORDER BY 1 NULLS FIRST;
1953 } {
1954 11 11 - 11 11 -
1955 12 12 12 12 - -
1956 15 15 15 15 15 15
1957 17 17 - 17 - -
1958
1959 }
1960 do_execsql_test joinC-119 {
1961 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
1962 FROM t1 LEFT JOIN (
1963 t2 FULL JOIN (
1964 t3 LEFT JOIN (
1965 t4 RIGHT JOIN t5 USING(a)
1966 ) USING(a)
1967 ) USING(a)
1968 ) USING(a)
1969 ORDER BY 1 NULLS FIRST;
1970 } {
1971 11 11 - 11 - -
1972 12 12 12 12 - -
1973 15 15 15 15 15 15
1974 17 17 - 17 - 17
1975
1976 }
1977 do_execsql_test joinC-120 {
1978 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
1979 FROM t1 LEFT JOIN (
1980 t2 FULL JOIN (
1981 t3 LEFT JOIN (
1982 t4 FULL JOIN t5 USING(a)
1983 ) USING(a)
1984 ) USING(a)
1985 ) USING(a)
1986 ORDER BY 1 NULLS FIRST;
1987 } {
1988 11 11 - 11 11 -
1989 12 12 12 12 - -
1990 15 15 15 15 15 15
1991 17 17 - 17 - 17
1992
1993 }
1994 do_execsql_test joinC-121 {
1995 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
1996 FROM t1 LEFT JOIN (
1997 t2 FULL JOIN (
1998 t3 RIGHT JOIN (
1999 t4 INNER JOIN t5 USING(a)
2000 ) USING(a)
2001 ) USING(a)
2002 ) USING(a)
2003 ORDER BY 1 NULLS FIRST;
2004 } {
2005 11 11 - - - -
2006 12 12 12 - - -
2007 15 15 15 15 15 15
2008 17 17 - - - -
2009
2010 }
2011 do_execsql_test joinC-122 {
2012 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
2013 FROM t1 LEFT JOIN (
2014 t2 FULL JOIN (
2015 t3 RIGHT JOIN (
2016 t4 LEFT JOIN t5 USING(a)
2017 ) USING(a)
2018 ) USING(a)
2019 ) USING(a)
2020 ORDER BY 1 NULLS FIRST;
2021 } {
2022 11 11 - 11 11 -
2023 12 12 12 - - -
2024 15 15 15 15 15 15
2025 17 17 - - - -
2026
2027 }
2028 do_execsql_test joinC-123 {
2029 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
2030 FROM t1 LEFT JOIN (
2031 t2 FULL JOIN (
2032 t3 RIGHT JOIN (
2033 t4 RIGHT JOIN t5 USING(a)
2034 ) USING(a)
2035 ) USING(a)
2036 ) USING(a)
2037 ORDER BY 1 NULLS FIRST;
2038 } {
2039 11 11 - - - -
2040 12 12 12 - - -
2041 15 15 15 15 15 15
2042 17 17 - 17 - 17
2043
2044 }
2045 do_execsql_test joinC-124 {
2046 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
2047 FROM t1 LEFT JOIN (
2048 t2 FULL JOIN (
2049 t3 RIGHT JOIN (
2050 t4 FULL JOIN t5 USING(a)
2051 ) USING(a)
2052 ) USING(a)
2053 ) USING(a)
2054 ORDER BY 1 NULLS FIRST;
2055 } {
2056 11 11 - 11 11 -
2057 12 12 12 - - -
2058 15 15 15 15 15 15
2059 17 17 - 17 - 17
2060
2061 }
2062 do_execsql_test joinC-125 {
2063 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
2064 FROM t1 LEFT JOIN (
2065 t2 FULL JOIN (
2066 t3 FULL JOIN (
2067 t4 INNER JOIN t5 USING(a)
2068 ) USING(a)
2069 ) USING(a)
2070 ) USING(a)
2071 ORDER BY 1 NULLS FIRST;
2072 } {
2073 11 11 - 11 - -
2074 12 12 12 12 - -
2075 15 15 15 15 15 15
2076 17 17 - 17 - -
2077
2078 }
2079 do_execsql_test joinC-126 {
2080 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
2081 FROM t1 LEFT JOIN (
2082 t2 FULL JOIN (
2083 t3 FULL JOIN (
2084 t4 LEFT JOIN t5 USING(a)
2085 ) USING(a)
2086 ) USING(a)
2087 ) USING(a)
2088 ORDER BY 1 NULLS FIRST;
2089 } {
2090 11 11 - 11 11 -
2091 12 12 12 12 - -
2092 15 15 15 15 15 15
2093 17 17 - 17 - -
2094
2095 }
2096 do_execsql_test joinC-127 {
2097 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
2098 FROM t1 LEFT JOIN (
2099 t2 FULL JOIN (
2100 t3 FULL JOIN (
2101 t4 RIGHT JOIN t5 USING(a)
2102 ) USING(a)
2103 ) USING(a)
2104 ) USING(a)
2105 ORDER BY 1 NULLS FIRST;
2106 } {
2107 11 11 - 11 - -
2108 12 12 12 12 - -
2109 15 15 15 15 15 15
2110 17 17 - 17 - 17
2111
2112 }
2113 do_execsql_test joinC-128 {
2114 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
2115 FROM t1 LEFT JOIN (
2116 t2 FULL JOIN (
2117 t3 FULL JOIN (
2118 t4 FULL JOIN t5 USING(a)
2119 ) USING(a)
2120 ) USING(a)
2121 ) USING(a)
2122 ORDER BY 1 NULLS FIRST;
2123 } {
2124 11 11 - 11 11 -
2125 12 12 12 12 - -
2126 15 15 15 15 15 15
2127 17 17 - 17 - 17
2128
2129 }
2130 do_execsql_test joinC-129 {
2131 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
2132 FROM t1 RIGHT JOIN (
2133 t2 INNER JOIN (
2134 t3 INNER JOIN (
2135 t4 INNER JOIN t5 USING(a)
2136 ) USING(a)
2137 ) USING(a)
2138 ) USING(a)
2139 ORDER BY 1 NULLS FIRST;
2140 } {
2141 15 15 15 15 15 15
2142
2143 }
2144 do_execsql_test joinC-130 {
2145 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
2146 FROM t1 RIGHT JOIN (
2147 t2 INNER JOIN (
2148 t3 INNER JOIN (
2149 t4 LEFT JOIN t5 USING(a)
2150 ) USING(a)
2151 ) USING(a)
2152 ) USING(a)
2153 ORDER BY 1 NULLS FIRST;
2154 } {
2155 13 - 13 13 13 -
2156 15 15 15 15 15 15
2157
2158 }
2159 do_execsql_test joinC-131 {
2160 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
2161 FROM t1 RIGHT JOIN (
2162 t2 INNER JOIN (
2163 t3 INNER JOIN (
2164 t4 RIGHT JOIN t5 USING(a)
2165 ) USING(a)
2166 ) USING(a)
2167 ) USING(a)
2168 ORDER BY 1 NULLS FIRST;
2169 } {
2170 15 15 15 15 15 15
2171 18 - 18 18 - 18
2172
2173 }
2174 do_execsql_test joinC-132 {
2175 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
2176 FROM t1 RIGHT JOIN (
2177 t2 INNER JOIN (
2178 t3 INNER JOIN (
2179 t4 FULL JOIN t5 USING(a)
2180 ) USING(a)
2181 ) USING(a)
2182 ) USING(a)
2183 ORDER BY 1 NULLS FIRST;
2184 } {
2185 13 - 13 13 13 -
2186 15 15 15 15 15 15
2187 18 - 18 18 - 18
2188
2189 }
2190 do_execsql_test joinC-133 {
2191 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
2192 FROM t1 RIGHT JOIN (
2193 t2 INNER JOIN (
2194 t3 LEFT JOIN (
2195 t4 INNER JOIN t5 USING(a)
2196 ) USING(a)
2197 ) USING(a)
2198 ) USING(a)
2199 ORDER BY 1 NULLS FIRST;
2200 } {
2201 12 12 12 12 - -
2202 13 - 13 13 - -
2203 15 15 15 15 15 15
2204 18 - 18 18 - -
2205
2206 }
2207 do_execsql_test joinC-134 {
2208 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
2209 FROM t1 RIGHT JOIN (
2210 t2 INNER JOIN (
2211 t3 LEFT JOIN (
2212 t4 LEFT JOIN t5 USING(a)
2213 ) USING(a)
2214 ) USING(a)
2215 ) USING(a)
2216 ORDER BY 1 NULLS FIRST;
2217 } {
2218 12 12 12 12 - -
2219 13 - 13 13 13 -
2220 15 15 15 15 15 15
2221 18 - 18 18 - -
2222
2223 }
2224 do_execsql_test joinC-135 {
2225 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
2226 FROM t1 RIGHT JOIN (
2227 t2 INNER JOIN (
2228 t3 LEFT JOIN (
2229 t4 RIGHT JOIN t5 USING(a)
2230 ) USING(a)
2231 ) USING(a)
2232 ) USING(a)
2233 ORDER BY 1 NULLS FIRST;
2234 } {
2235 12 12 12 12 - -
2236 13 - 13 13 - -
2237 15 15 15 15 15 15
2238 18 - 18 18 - 18
2239
2240 }
2241 do_execsql_test joinC-136 {
2242 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
2243 FROM t1 RIGHT JOIN (
2244 t2 INNER JOIN (
2245 t3 LEFT JOIN (
2246 t4 FULL JOIN t5 USING(a)
2247 ) USING(a)
2248 ) USING(a)
2249 ) USING(a)
2250 ORDER BY 1 NULLS FIRST;
2251 } {
2252 12 12 12 12 - -
2253 13 - 13 13 13 -
2254 15 15 15 15 15 15
2255 18 - 18 18 - 18
2256
2257 }
2258 do_execsql_test joinC-137 {
2259 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
2260 FROM t1 RIGHT JOIN (
2261 t2 INNER JOIN (
2262 t3 RIGHT JOIN (
2263 t4 INNER JOIN t5 USING(a)
2264 ) USING(a)
2265 ) USING(a)
2266 ) USING(a)
2267 ORDER BY 1 NULLS FIRST;
2268 } {
2269 15 15 15 15 15 15
2270
2271 }
2272 do_execsql_test joinC-138 {
2273 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
2274 FROM t1 RIGHT JOIN (
2275 t2 INNER JOIN (
2276 t3 RIGHT JOIN (
2277 t4 LEFT JOIN t5 USING(a)
2278 ) USING(a)
2279 ) USING(a)
2280 ) USING(a)
2281 ORDER BY 1 NULLS FIRST;
2282 } {
2283 13 - 13 13 13 -
2284 15 15 15 15 15 15
2285
2286 }
2287 do_execsql_test joinC-139 {
2288 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
2289 FROM t1 RIGHT JOIN (
2290 t2 INNER JOIN (
2291 t3 RIGHT JOIN (
2292 t4 RIGHT JOIN t5 USING(a)
2293 ) USING(a)
2294 ) USING(a)
2295 ) USING(a)
2296 ORDER BY 1 NULLS FIRST;
2297 } {
2298 15 15 15 15 15 15
2299 18 - 18 18 - 18
2300
2301 }
2302 do_execsql_test joinC-140 {
2303 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
2304 FROM t1 RIGHT JOIN (
2305 t2 INNER JOIN (
2306 t3 RIGHT JOIN (
2307 t4 FULL JOIN t5 USING(a)
2308 ) USING(a)
2309 ) USING(a)
2310 ) USING(a)
2311 ORDER BY 1 NULLS FIRST;
2312 } {
2313 13 - 13 13 13 -
2314 15 15 15 15 15 15
2315 18 - 18 18 - 18
2316
2317 }
2318 do_execsql_test joinC-141 {
2319 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
2320 FROM t1 RIGHT JOIN (
2321 t2 INNER JOIN (
2322 t3 FULL JOIN (
2323 t4 INNER JOIN t5 USING(a)
2324 ) USING(a)
2325 ) USING(a)
2326 ) USING(a)
2327 ORDER BY 1 NULLS FIRST;
2328 } {
2329 12 12 12 12 - -
2330 13 - 13 13 - -
2331 15 15 15 15 15 15
2332 18 - 18 18 - -
2333
2334 }
2335 do_execsql_test joinC-142 {
2336 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
2337 FROM t1 RIGHT JOIN (
2338 t2 INNER JOIN (
2339 t3 FULL JOIN (
2340 t4 LEFT JOIN t5 USING(a)
2341 ) USING(a)
2342 ) USING(a)
2343 ) USING(a)
2344 ORDER BY 1 NULLS FIRST;
2345 } {
2346 12 12 12 12 - -
2347 13 - 13 13 13 -
2348 15 15 15 15 15 15
2349 18 - 18 18 - -
2350
2351 }
2352 do_execsql_test joinC-143 {
2353 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
2354 FROM t1 RIGHT JOIN (
2355 t2 INNER JOIN (
2356 t3 FULL JOIN (
2357 t4 RIGHT JOIN t5 USING(a)
2358 ) USING(a)
2359 ) USING(a)
2360 ) USING(a)
2361 ORDER BY 1 NULLS FIRST;
2362 } {
2363 12 12 12 12 - -
2364 13 - 13 13 - -
2365 15 15 15 15 15 15
2366 18 - 18 18 - 18
2367
2368 }
2369 do_execsql_test joinC-144 {
2370 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
2371 FROM t1 RIGHT JOIN (
2372 t2 INNER JOIN (
2373 t3 FULL JOIN (
2374 t4 FULL JOIN t5 USING(a)
2375 ) USING(a)
2376 ) USING(a)
2377 ) USING(a)
2378 ORDER BY 1 NULLS FIRST;
2379 } {
2380 12 12 12 12 - -
2381 13 - 13 13 13 -
2382 15 15 15 15 15 15
2383 18 - 18 18 - 18
2384
2385 }
2386 do_execsql_test joinC-145 {
2387 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
2388 FROM t1 RIGHT JOIN (
2389 t2 LEFT JOIN (
2390 t3 INNER JOIN (
2391 t4 INNER JOIN t5 USING(a)
2392 ) USING(a)
2393 ) USING(a)
2394 ) USING(a)
2395 ORDER BY 1 NULLS FIRST;
2396 } {
2397 - - - - - -
2398 12 12 12 - - -
2399 13 - 13 - - -
2400 15 15 15 15 15 15
2401 18 - 18 - - -
2402
2403 }
2404 do_execsql_test joinC-146 {
2405 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
2406 FROM t1 RIGHT JOIN (
2407 t2 LEFT JOIN (
2408 t3 INNER JOIN (
2409 t4 LEFT JOIN t5 USING(a)
2410 ) USING(a)
2411 ) USING(a)
2412 ) USING(a)
2413 ORDER BY 1 NULLS FIRST;
2414 } {
2415 - - - - - -
2416 12 12 12 - - -
2417 13 - 13 13 13 -
2418 15 15 15 15 15 15
2419 18 - 18 - - -
2420
2421 }
2422 do_execsql_test joinC-147 {
2423 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
2424 FROM t1 RIGHT JOIN (
2425 t2 LEFT JOIN (
2426 t3 INNER JOIN (
2427 t4 RIGHT JOIN t5 USING(a)
2428 ) USING(a)
2429 ) USING(a)
2430 ) USING(a)
2431 ORDER BY 1 NULLS FIRST;
2432 } {
2433 - - - - - -
2434 12 12 12 - - -
2435 13 - 13 - - -
2436 15 15 15 15 15 15
2437 18 - 18 18 - 18
2438
2439 }
2440 do_execsql_test joinC-148 {
2441 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
2442 FROM t1 RIGHT JOIN (
2443 t2 LEFT JOIN (
2444 t3 INNER JOIN (
2445 t4 FULL JOIN t5 USING(a)
2446 ) USING(a)
2447 ) USING(a)
2448 ) USING(a)
2449 ORDER BY 1 NULLS FIRST;
2450 } {
2451 - - - - - -
2452 12 12 12 - - -
2453 13 - 13 13 13 -
2454 15 15 15 15 15 15
2455 18 - 18 18 - 18
2456
2457 }
2458 do_execsql_test joinC-149 {
2459 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
2460 FROM t1 RIGHT JOIN (
2461 t2 LEFT JOIN (
2462 t3 LEFT JOIN (
2463 t4 INNER JOIN t5 USING(a)
2464 ) USING(a)
2465 ) USING(a)
2466 ) USING(a)
2467 ORDER BY 1 NULLS FIRST;
2468 } {
2469 - - - - - -
2470 12 12 12 12 - -
2471 13 - 13 13 - -
2472 15 15 15 15 15 15
2473 18 - 18 18 - -
2474
2475 }
2476 do_execsql_test joinC-150 {
2477 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
2478 FROM t1 RIGHT JOIN (
2479 t2 LEFT JOIN (
2480 t3 LEFT JOIN (
2481 t4 LEFT JOIN t5 USING(a)
2482 ) USING(a)
2483 ) USING(a)
2484 ) USING(a)
2485 ORDER BY 1 NULLS FIRST;
2486 } {
2487 - - - - - -
2488 12 12 12 12 - -
2489 13 - 13 13 13 -
2490 15 15 15 15 15 15
2491 18 - 18 18 - -
2492
2493 }
2494 do_execsql_test joinC-151 {
2495 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
2496 FROM t1 RIGHT JOIN (
2497 t2 LEFT JOIN (
2498 t3 LEFT JOIN (
2499 t4 RIGHT JOIN t5 USING(a)
2500 ) USING(a)
2501 ) USING(a)
2502 ) USING(a)
2503 ORDER BY 1 NULLS FIRST;
2504 } {
2505 - - - - - -
2506 12 12 12 12 - -
2507 13 - 13 13 - -
2508 15 15 15 15 15 15
2509 18 - 18 18 - 18
2510
2511 }
2512 do_execsql_test joinC-152 {
2513 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
2514 FROM t1 RIGHT JOIN (
2515 t2 LEFT JOIN (
2516 t3 LEFT JOIN (
2517 t4 FULL JOIN t5 USING(a)
2518 ) USING(a)
2519 ) USING(a)
2520 ) USING(a)
2521 ORDER BY 1 NULLS FIRST;
2522 } {
2523 - - - - - -
2524 12 12 12 12 - -
2525 13 - 13 13 13 -
2526 15 15 15 15 15 15
2527 18 - 18 18 - 18
2528
2529 }
2530 do_execsql_test joinC-153 {
2531 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
2532 FROM t1 RIGHT JOIN (
2533 t2 LEFT JOIN (
2534 t3 RIGHT JOIN (
2535 t4 INNER JOIN t5 USING(a)
2536 ) USING(a)
2537 ) USING(a)
2538 ) USING(a)
2539 ORDER BY 1 NULLS FIRST;
2540 } {
2541 - - - - - -
2542 12 12 12 - - -
2543 13 - 13 - - -
2544 15 15 15 15 15 15
2545 18 - 18 - - -
2546
2547 }
2548 do_execsql_test joinC-154 {
2549 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
2550 FROM t1 RIGHT JOIN (
2551 t2 LEFT JOIN (
2552 t3 RIGHT JOIN (
2553 t4 LEFT JOIN t5 USING(a)
2554 ) USING(a)
2555 ) USING(a)
2556 ) USING(a)
2557 ORDER BY 1 NULLS FIRST;
2558 } {
2559 - - - - - -
2560 12 12 12 - - -
2561 13 - 13 13 13 -
2562 15 15 15 15 15 15
2563 18 - 18 - - -
2564
2565 }
2566 do_execsql_test joinC-155 {
2567 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
2568 FROM t1 RIGHT JOIN (
2569 t2 LEFT JOIN (
2570 t3 RIGHT JOIN (
2571 t4 RIGHT JOIN t5 USING(a)
2572 ) USING(a)
2573 ) USING(a)
2574 ) USING(a)
2575 ORDER BY 1 NULLS FIRST;
2576 } {
2577 - - - - - -
2578 12 12 12 - - -
2579 13 - 13 - - -
2580 15 15 15 15 15 15
2581 18 - 18 18 - 18
2582
2583 }
2584 do_execsql_test joinC-156 {
2585 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
2586 FROM t1 RIGHT JOIN (
2587 t2 LEFT JOIN (
2588 t3 RIGHT JOIN (
2589 t4 FULL JOIN t5 USING(a)
2590 ) USING(a)
2591 ) USING(a)
2592 ) USING(a)
2593 ORDER BY 1 NULLS FIRST;
2594 } {
2595 - - - - - -
2596 12 12 12 - - -
2597 13 - 13 13 13 -
2598 15 15 15 15 15 15
2599 18 - 18 18 - 18
2600
2601 }
2602 do_execsql_test joinC-157 {
2603 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
2604 FROM t1 RIGHT JOIN (
2605 t2 LEFT JOIN (
2606 t3 FULL JOIN (
2607 t4 INNER JOIN t5 USING(a)
2608 ) USING(a)
2609 ) USING(a)
2610 ) USING(a)
2611 ORDER BY 1 NULLS FIRST;
2612 } {
2613 - - - - - -
2614 12 12 12 12 - -
2615 13 - 13 13 - -
2616 15 15 15 15 15 15
2617 18 - 18 18 - -
2618
2619 }
2620 do_execsql_test joinC-158 {
2621 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
2622 FROM t1 RIGHT JOIN (
2623 t2 LEFT JOIN (
2624 t3 FULL JOIN (
2625 t4 LEFT JOIN t5 USING(a)
2626 ) USING(a)
2627 ) USING(a)
2628 ) USING(a)
2629 ORDER BY 1 NULLS FIRST;
2630 } {
2631 - - - - - -
2632 12 12 12 12 - -
2633 13 - 13 13 13 -
2634 15 15 15 15 15 15
2635 18 - 18 18 - -
2636
2637 }
2638 do_execsql_test joinC-159 {
2639 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
2640 FROM t1 RIGHT JOIN (
2641 t2 LEFT JOIN (
2642 t3 FULL JOIN (
2643 t4 RIGHT JOIN t5 USING(a)
2644 ) USING(a)
2645 ) USING(a)
2646 ) USING(a)
2647 ORDER BY 1 NULLS FIRST;
2648 } {
2649 - - - - - -
2650 12 12 12 12 - -
2651 13 - 13 13 - -
2652 15 15 15 15 15 15
2653 18 - 18 18 - 18
2654
2655 }
2656 do_execsql_test joinC-160 {
2657 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
2658 FROM t1 RIGHT JOIN (
2659 t2 LEFT JOIN (
2660 t3 FULL JOIN (
2661 t4 FULL JOIN t5 USING(a)
2662 ) USING(a)
2663 ) USING(a)
2664 ) USING(a)
2665 ORDER BY 1 NULLS FIRST;
2666 } {
2667 - - - - - -
2668 12 12 12 12 - -
2669 13 - 13 13 13 -
2670 15 15 15 15 15 15
2671 18 - 18 18 - 18
2672
2673 }
2674 do_execsql_test joinC-161 {
2675 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
2676 FROM t1 RIGHT JOIN (
2677 t2 RIGHT JOIN (
2678 t3 INNER JOIN (
2679 t4 INNER JOIN t5 USING(a)
2680 ) USING(a)
2681 ) USING(a)
2682 ) USING(a)
2683 ORDER BY 1 NULLS FIRST;
2684 } {
2685 15 15 15 15 15 15
2686 19 - - 19 19 19
2687
2688 }
2689 do_execsql_test joinC-162 {
2690 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
2691 FROM t1 RIGHT JOIN (
2692 t2 RIGHT JOIN (
2693 t3 INNER JOIN (
2694 t4 LEFT JOIN t5 USING(a)
2695 ) USING(a)
2696 ) USING(a)
2697 ) USING(a)
2698 ORDER BY 1 NULLS FIRST;
2699 } {
2700 11 11 - 11 11 -
2701 13 - 13 13 13 -
2702 15 15 15 15 15 15
2703 19 - - 19 19 19
2704
2705 }
2706 do_execsql_test joinC-163 {
2707 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
2708 FROM t1 RIGHT JOIN (
2709 t2 RIGHT JOIN (
2710 t3 INNER JOIN (
2711 t4 RIGHT JOIN t5 USING(a)
2712 ) USING(a)
2713 ) USING(a)
2714 ) USING(a)
2715 ORDER BY 1 NULLS FIRST;
2716 } {
2717 15 15 15 15 15 15
2718 17 17 - 17 - 17
2719 18 - 18 18 - 18
2720 19 - - 19 19 19
2721
2722 }
2723 do_execsql_test joinC-164 {
2724 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
2725 FROM t1 RIGHT JOIN (
2726 t2 RIGHT JOIN (
2727 t3 INNER JOIN (
2728 t4 FULL JOIN t5 USING(a)
2729 ) USING(a)
2730 ) USING(a)
2731 ) USING(a)
2732 ORDER BY 1 NULLS FIRST;
2733 } {
2734 11 11 - 11 11 -
2735 13 - 13 13 13 -
2736 15 15 15 15 15 15
2737 17 17 - 17 - 17
2738 18 - 18 18 - 18
2739 19 - - 19 19 19
2740
2741 }
2742 do_execsql_test joinC-165 {
2743 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
2744 FROM t1 RIGHT JOIN (
2745 t2 RIGHT JOIN (
2746 t3 LEFT JOIN (
2747 t4 INNER JOIN t5 USING(a)
2748 ) USING(a)
2749 ) USING(a)
2750 ) USING(a)
2751 ORDER BY 1 NULLS FIRST;
2752 } {
2753 - - - - - -
2754 11 11 - 11 - -
2755 12 12 12 12 - -
2756 13 - 13 13 - -
2757 15 15 15 15 15 15
2758 17 17 - 17 - -
2759 18 - 18 18 - -
2760 19 - - 19 19 19
2761
2762 }
2763 do_execsql_test joinC-166 {
2764 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
2765 FROM t1 RIGHT JOIN (
2766 t2 RIGHT JOIN (
2767 t3 LEFT JOIN (
2768 t4 LEFT JOIN t5 USING(a)
2769 ) USING(a)
2770 ) USING(a)
2771 ) USING(a)
2772 ORDER BY 1 NULLS FIRST;
2773 } {
2774 - - - - - -
2775 11 11 - 11 11 -
2776 12 12 12 12 - -
2777 13 - 13 13 13 -
2778 15 15 15 15 15 15
2779 17 17 - 17 - -
2780 18 - 18 18 - -
2781 19 - - 19 19 19
2782
2783 }
2784 do_execsql_test joinC-167 {
2785 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
2786 FROM t1 RIGHT JOIN (
2787 t2 RIGHT JOIN (
2788 t3 LEFT JOIN (
2789 t4 RIGHT JOIN t5 USING(a)
2790 ) USING(a)
2791 ) USING(a)
2792 ) USING(a)
2793 ORDER BY 1 NULLS FIRST;
2794 } {
2795 - - - - - -
2796 11 11 - 11 - -
2797 12 12 12 12 - -
2798 13 - 13 13 - -
2799 15 15 15 15 15 15
2800 17 17 - 17 - 17
2801 18 - 18 18 - 18
2802 19 - - 19 19 19
2803
2804 }
2805 do_execsql_test joinC-168 {
2806 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
2807 FROM t1 RIGHT JOIN (
2808 t2 RIGHT JOIN (
2809 t3 LEFT JOIN (
2810 t4 FULL JOIN t5 USING(a)
2811 ) USING(a)
2812 ) USING(a)
2813 ) USING(a)
2814 ORDER BY 1 NULLS FIRST;
2815 } {
2816 - - - - - -
2817 11 11 - 11 11 -
2818 12 12 12 12 - -
2819 13 - 13 13 13 -
2820 15 15 15 15 15 15
2821 17 17 - 17 - 17
2822 18 - 18 18 - 18
2823 19 - - 19 19 19
2824
2825 }
2826 do_execsql_test joinC-169 {
2827 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
2828 FROM t1 RIGHT JOIN (
2829 t2 RIGHT JOIN (
2830 t3 RIGHT JOIN (
2831 t4 INNER JOIN t5 USING(a)
2832 ) USING(a)
2833 ) USING(a)
2834 ) USING(a)
2835 ORDER BY 1 NULLS FIRST;
2836 } {
2837 15 15 15 15 15 15
2838 19 - - 19 19 19
2839
2840 }
2841 do_execsql_test joinC-170 {
2842 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
2843 FROM t1 RIGHT JOIN (
2844 t2 RIGHT JOIN (
2845 t3 RIGHT JOIN (
2846 t4 LEFT JOIN t5 USING(a)
2847 ) USING(a)
2848 ) USING(a)
2849 ) USING(a)
2850 ORDER BY 1 NULLS FIRST;
2851 } {
2852 11 11 - 11 11 -
2853 13 - 13 13 13 -
2854 15 15 15 15 15 15
2855 19 - - 19 19 19
2856
2857 }
2858 do_execsql_test joinC-171 {
2859 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
2860 FROM t1 RIGHT JOIN (
2861 t2 RIGHT JOIN (
2862 t3 RIGHT JOIN (
2863 t4 RIGHT JOIN t5 USING(a)
2864 ) USING(a)
2865 ) USING(a)
2866 ) USING(a)
2867 ORDER BY 1 NULLS FIRST;
2868 } {
2869 15 15 15 15 15 15
2870 17 17 - 17 - 17
2871 18 - 18 18 - 18
2872 19 - - 19 19 19
2873
2874 }
2875 do_execsql_test joinC-172 {
2876 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
2877 FROM t1 RIGHT JOIN (
2878 t2 RIGHT JOIN (
2879 t3 RIGHT JOIN (
2880 t4 FULL JOIN t5 USING(a)
2881 ) USING(a)
2882 ) USING(a)
2883 ) USING(a)
2884 ORDER BY 1 NULLS FIRST;
2885 } {
2886 11 11 - 11 11 -
2887 13 - 13 13 13 -
2888 15 15 15 15 15 15
2889 17 17 - 17 - 17
2890 18 - 18 18 - 18
2891 19 - - 19 19 19
2892
2893 }
2894 do_execsql_test joinC-173 {
2895 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
2896 FROM t1 RIGHT JOIN (
2897 t2 RIGHT JOIN (
2898 t3 FULL JOIN (
2899 t4 INNER JOIN t5 USING(a)
2900 ) USING(a)
2901 ) USING(a)
2902 ) USING(a)
2903 ORDER BY 1 NULLS FIRST;
2904 } {
2905 - - - - - -
2906 11 11 - 11 - -
2907 12 12 12 12 - -
2908 13 - 13 13 - -
2909 15 15 15 15 15 15
2910 17 17 - 17 - -
2911 18 - 18 18 - -
2912 19 - - 19 19 19
2913
2914 }
2915 do_execsql_test joinC-174 {
2916 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
2917 FROM t1 RIGHT JOIN (
2918 t2 RIGHT JOIN (
2919 t3 FULL JOIN (
2920 t4 LEFT JOIN t5 USING(a)
2921 ) USING(a)
2922 ) USING(a)
2923 ) USING(a)
2924 ORDER BY 1 NULLS FIRST;
2925 } {
2926 - - - - - -
2927 11 11 - 11 11 -
2928 12 12 12 12 - -
2929 13 - 13 13 13 -
2930 15 15 15 15 15 15
2931 17 17 - 17 - -
2932 18 - 18 18 - -
2933 19 - - 19 19 19
2934
2935 }
2936 do_execsql_test joinC-175 {
2937 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
2938 FROM t1 RIGHT JOIN (
2939 t2 RIGHT JOIN (
2940 t3 FULL JOIN (
2941 t4 RIGHT JOIN t5 USING(a)
2942 ) USING(a)
2943 ) USING(a)
2944 ) USING(a)
2945 ORDER BY 1 NULLS FIRST;
2946 } {
2947 - - - - - -
2948 11 11 - 11 - -
2949 12 12 12 12 - -
2950 13 - 13 13 - -
2951 15 15 15 15 15 15
2952 17 17 - 17 - 17
2953 18 - 18 18 - 18
2954 19 - - 19 19 19
2955
2956 }
2957 do_execsql_test joinC-176 {
2958 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
2959 FROM t1 RIGHT JOIN (
2960 t2 RIGHT JOIN (
2961 t3 FULL JOIN (
2962 t4 FULL JOIN t5 USING(a)
2963 ) USING(a)
2964 ) USING(a)
2965 ) USING(a)
2966 ORDER BY 1 NULLS FIRST;
2967 } {
2968 - - - - - -
2969 11 11 - 11 11 -
2970 12 12 12 12 - -
2971 13 - 13 13 13 -
2972 15 15 15 15 15 15
2973 17 17 - 17 - 17
2974 18 - 18 18 - 18
2975 19 - - 19 19 19
2976
2977 }
2978 do_execsql_test joinC-177 {
2979 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
2980 FROM t1 RIGHT JOIN (
2981 t2 FULL JOIN (
2982 t3 INNER JOIN (
2983 t4 INNER JOIN t5 USING(a)
2984 ) USING(a)
2985 ) USING(a)
2986 ) USING(a)
2987 ORDER BY 1 NULLS FIRST;
2988 } {
2989 - - - - - -
2990 12 12 12 - - -
2991 13 - 13 - - -
2992 15 15 15 15 15 15
2993 18 - 18 - - -
2994 19 - - 19 19 19
2995
2996 }
2997 do_execsql_test joinC-178 {
2998 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
2999 FROM t1 RIGHT JOIN (
3000 t2 FULL JOIN (
3001 t3 INNER JOIN (
3002 t4 LEFT JOIN t5 USING(a)
3003 ) USING(a)
3004 ) USING(a)
3005 ) USING(a)
3006 ORDER BY 1 NULLS FIRST;
3007 } {
3008 - - - - - -
3009 11 11 - 11 11 -
3010 12 12 12 - - -
3011 13 - 13 13 13 -
3012 15 15 15 15 15 15
3013 18 - 18 - - -
3014 19 - - 19 19 19
3015
3016 }
3017 do_execsql_test joinC-179 {
3018 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
3019 FROM t1 RIGHT JOIN (
3020 t2 FULL JOIN (
3021 t3 INNER JOIN (
3022 t4 RIGHT JOIN t5 USING(a)
3023 ) USING(a)
3024 ) USING(a)
3025 ) USING(a)
3026 ORDER BY 1 NULLS FIRST;
3027 } {
3028 - - - - - -
3029 12 12 12 - - -
3030 13 - 13 - - -
3031 15 15 15 15 15 15
3032 17 17 - 17 - 17
3033 18 - 18 18 - 18
3034 19 - - 19 19 19
3035
3036 }
3037 do_execsql_test joinC-180 {
3038 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
3039 FROM t1 RIGHT JOIN (
3040 t2 FULL JOIN (
3041 t3 INNER JOIN (
3042 t4 FULL JOIN t5 USING(a)
3043 ) USING(a)
3044 ) USING(a)
3045 ) USING(a)
3046 ORDER BY 1 NULLS FIRST;
3047 } {
3048 - - - - - -
3049 11 11 - 11 11 -
3050 12 12 12 - - -
3051 13 - 13 13 13 -
3052 15 15 15 15 15 15
3053 17 17 - 17 - 17
3054 18 - 18 18 - 18
3055 19 - - 19 19 19
3056
3057 }
3058 do_execsql_test joinC-181 {
3059 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
3060 FROM t1 RIGHT JOIN (
3061 t2 FULL JOIN (
3062 t3 LEFT JOIN (
3063 t4 INNER JOIN t5 USING(a)
3064 ) USING(a)
3065 ) USING(a)
3066 ) USING(a)
3067 ORDER BY 1 NULLS FIRST;
3068 } {
3069 - - - - - -
3070 - - - - - -
3071 11 11 - 11 - -
3072 12 12 12 12 - -
3073 13 - 13 13 - -
3074 15 15 15 15 15 15
3075 17 17 - 17 - -
3076 18 - 18 18 - -
3077 19 - - 19 19 19
3078
3079 }
3080 do_execsql_test joinC-182 {
3081 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
3082 FROM t1 RIGHT JOIN (
3083 t2 FULL JOIN (
3084 t3 LEFT JOIN (
3085 t4 LEFT JOIN t5 USING(a)
3086 ) USING(a)
3087 ) USING(a)
3088 ) USING(a)
3089 ORDER BY 1 NULLS FIRST;
3090 } {
3091 - - - - - -
3092 - - - - - -
3093 11 11 - 11 11 -
3094 12 12 12 12 - -
3095 13 - 13 13 13 -
3096 15 15 15 15 15 15
3097 17 17 - 17 - -
3098 18 - 18 18 - -
3099 19 - - 19 19 19
3100
3101 }
3102 do_execsql_test joinC-183 {
3103 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
3104 FROM t1 RIGHT JOIN (
3105 t2 FULL JOIN (
3106 t3 LEFT JOIN (
3107 t4 RIGHT JOIN t5 USING(a)
3108 ) USING(a)
3109 ) USING(a)
3110 ) USING(a)
3111 ORDER BY 1 NULLS FIRST;
3112 } {
3113 - - - - - -
3114 - - - - - -
3115 11 11 - 11 - -
3116 12 12 12 12 - -
3117 13 - 13 13 - -
3118 15 15 15 15 15 15
3119 17 17 - 17 - 17
3120 18 - 18 18 - 18
3121 19 - - 19 19 19
3122
3123 }
3124 do_execsql_test joinC-184 {
3125 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
3126 FROM t1 RIGHT JOIN (
3127 t2 FULL JOIN (
3128 t3 LEFT JOIN (
3129 t4 FULL JOIN t5 USING(a)
3130 ) USING(a)
3131 ) USING(a)
3132 ) USING(a)
3133 ORDER BY 1 NULLS FIRST;
3134 } {
3135 - - - - - -
3136 - - - - - -
3137 11 11 - 11 11 -
3138 12 12 12 12 - -
3139 13 - 13 13 13 -
3140 15 15 15 15 15 15
3141 17 17 - 17 - 17
3142 18 - 18 18 - 18
3143 19 - - 19 19 19
3144
3145 }
3146 do_execsql_test joinC-185 {
3147 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
3148 FROM t1 RIGHT JOIN (
3149 t2 FULL JOIN (
3150 t3 RIGHT JOIN (
3151 t4 INNER JOIN t5 USING(a)
3152 ) USING(a)
3153 ) USING(a)
3154 ) USING(a)
3155 ORDER BY 1 NULLS FIRST;
3156 } {
3157 - - - - - -
3158 12 12 12 - - -
3159 13 - 13 - - -
3160 15 15 15 15 15 15
3161 18 - 18 - - -
3162 19 - - 19 19 19
3163
3164 }
3165 do_execsql_test joinC-186 {
3166 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
3167 FROM t1 RIGHT JOIN (
3168 t2 FULL JOIN (
3169 t3 RIGHT JOIN (
3170 t4 LEFT JOIN t5 USING(a)
3171 ) USING(a)
3172 ) USING(a)
3173 ) USING(a)
3174 ORDER BY 1 NULLS FIRST;
3175 } {
3176 - - - - - -
3177 11 11 - 11 11 -
3178 12 12 12 - - -
3179 13 - 13 13 13 -
3180 15 15 15 15 15 15
3181 18 - 18 - - -
3182 19 - - 19 19 19
3183
3184 }
3185 do_execsql_test joinC-187 {
3186 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
3187 FROM t1 RIGHT JOIN (
3188 t2 FULL JOIN (
3189 t3 RIGHT JOIN (
3190 t4 RIGHT JOIN t5 USING(a)
3191 ) USING(a)
3192 ) USING(a)
3193 ) USING(a)
3194 ORDER BY 1 NULLS FIRST;
3195 } {
3196 - - - - - -
3197 12 12 12 - - -
3198 13 - 13 - - -
3199 15 15 15 15 15 15
3200 17 17 - 17 - 17
3201 18 - 18 18 - 18
3202 19 - - 19 19 19
3203
3204 }
3205 do_execsql_test joinC-188 {
3206 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
3207 FROM t1 RIGHT JOIN (
3208 t2 FULL JOIN (
3209 t3 RIGHT JOIN (
3210 t4 FULL JOIN t5 USING(a)
3211 ) USING(a)
3212 ) USING(a)
3213 ) USING(a)
3214 ORDER BY 1 NULLS FIRST;
3215 } {
3216 - - - - - -
3217 11 11 - 11 11 -
3218 12 12 12 - - -
3219 13 - 13 13 13 -
3220 15 15 15 15 15 15
3221 17 17 - 17 - 17
3222 18 - 18 18 - 18
3223 19 - - 19 19 19
3224
3225 }
3226 do_execsql_test joinC-189 {
3227 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
3228 FROM t1 RIGHT JOIN (
3229 t2 FULL JOIN (
3230 t3 FULL JOIN (
3231 t4 INNER JOIN t5 USING(a)
3232 ) USING(a)
3233 ) USING(a)
3234 ) USING(a)
3235 ORDER BY 1 NULLS FIRST;
3236 } {
3237 - - - - - -
3238 - - - - - -
3239 11 11 - 11 - -
3240 12 12 12 12 - -
3241 13 - 13 13 - -
3242 15 15 15 15 15 15
3243 17 17 - 17 - -
3244 18 - 18 18 - -
3245 19 - - 19 19 19
3246
3247 }
3248 do_execsql_test joinC-190 {
3249 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
3250 FROM t1 RIGHT JOIN (
3251 t2 FULL JOIN (
3252 t3 FULL JOIN (
3253 t4 LEFT JOIN t5 USING(a)
3254 ) USING(a)
3255 ) USING(a)
3256 ) USING(a)
3257 ORDER BY 1 NULLS FIRST;
3258 } {
3259 - - - - - -
3260 - - - - - -
3261 11 11 - 11 11 -
3262 12 12 12 12 - -
3263 13 - 13 13 13 -
3264 15 15 15 15 15 15
3265 17 17 - 17 - -
3266 18 - 18 18 - -
3267 19 - - 19 19 19
3268
3269 }
3270 do_execsql_test joinC-191 {
3271 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
3272 FROM t1 RIGHT JOIN (
3273 t2 FULL JOIN (
3274 t3 FULL JOIN (
3275 t4 RIGHT JOIN t5 USING(a)
3276 ) USING(a)
3277 ) USING(a)
3278 ) USING(a)
3279 ORDER BY 1 NULLS FIRST;
3280 } {
3281 - - - - - -
3282 - - - - - -
3283 11 11 - 11 - -
3284 12 12 12 12 - -
3285 13 - 13 13 - -
3286 15 15 15 15 15 15
3287 17 17 - 17 - 17
3288 18 - 18 18 - 18
3289 19 - - 19 19 19
3290
3291 }
3292 do_execsql_test joinC-192 {
3293 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
3294 FROM t1 RIGHT JOIN (
3295 t2 FULL JOIN (
3296 t3 FULL JOIN (
3297 t4 FULL JOIN t5 USING(a)
3298 ) USING(a)
3299 ) USING(a)
3300 ) USING(a)
3301 ORDER BY 1 NULLS FIRST;
3302 } {
3303 - - - - - -
3304 - - - - - -
3305 11 11 - 11 11 -
3306 12 12 12 12 - -
3307 13 - 13 13 13 -
3308 15 15 15 15 15 15
3309 17 17 - 17 - 17
3310 18 - 18 18 - 18
3311 19 - - 19 19 19
3312
3313 }
3314 do_execsql_test joinC-193 {
3315 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
3316 FROM t1 FULL JOIN (
3317 t2 INNER JOIN (
3318 t3 INNER JOIN (
3319 t4 INNER JOIN t5 USING(a)
3320 ) USING(a)
3321 ) USING(a)
3322 ) USING(a)
3323 ORDER BY 1 NULLS FIRST;
3324 } {
3325 11 11 - - - -
3326 12 12 - - - -
3327 15 15 15 15 15 15
3328 17 17 - - - -
3329
3330 }
3331 do_execsql_test joinC-194 {
3332 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
3333 FROM t1 FULL JOIN (
3334 t2 INNER JOIN (
3335 t3 INNER JOIN (
3336 t4 LEFT JOIN t5 USING(a)
3337 ) USING(a)
3338 ) USING(a)
3339 ) USING(a)
3340 ORDER BY 1 NULLS FIRST;
3341 } {
3342 11 11 - - - -
3343 12 12 - - - -
3344 13 - 13 13 13 -
3345 15 15 15 15 15 15
3346 17 17 - - - -
3347
3348 }
3349 do_execsql_test joinC-195 {
3350 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
3351 FROM t1 FULL JOIN (
3352 t2 INNER JOIN (
3353 t3 INNER JOIN (
3354 t4 RIGHT JOIN t5 USING(a)
3355 ) USING(a)
3356 ) USING(a)
3357 ) USING(a)
3358 ORDER BY 1 NULLS FIRST;
3359 } {
3360 11 11 - - - -
3361 12 12 - - - -
3362 15 15 15 15 15 15
3363 17 17 - - - -
3364 18 - 18 18 - 18
3365
3366 }
3367 do_execsql_test joinC-196 {
3368 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
3369 FROM t1 FULL JOIN (
3370 t2 INNER JOIN (
3371 t3 INNER JOIN (
3372 t4 FULL JOIN t5 USING(a)
3373 ) USING(a)
3374 ) USING(a)
3375 ) USING(a)
3376 ORDER BY 1 NULLS FIRST;
3377 } {
3378 11 11 - - - -
3379 12 12 - - - -
3380 13 - 13 13 13 -
3381 15 15 15 15 15 15
3382 17 17 - - - -
3383 18 - 18 18 - 18
3384
3385 }
3386 do_execsql_test joinC-197 {
3387 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
3388 FROM t1 FULL JOIN (
3389 t2 INNER JOIN (
3390 t3 LEFT JOIN (
3391 t4 INNER JOIN t5 USING(a)
3392 ) USING(a)
3393 ) USING(a)
3394 ) USING(a)
3395 ORDER BY 1 NULLS FIRST;
3396 } {
3397 11 11 - - - -
3398 12 12 12 12 - -
3399 13 - 13 13 - -
3400 15 15 15 15 15 15
3401 17 17 - - - -
3402 18 - 18 18 - -
3403
3404 }
3405 do_execsql_test joinC-198 {
3406 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
3407 FROM t1 FULL JOIN (
3408 t2 INNER JOIN (
3409 t3 LEFT JOIN (
3410 t4 LEFT JOIN t5 USING(a)
3411 ) USING(a)
3412 ) USING(a)
3413 ) USING(a)
3414 ORDER BY 1 NULLS FIRST;
3415 } {
3416 11 11 - - - -
3417 12 12 12 12 - -
3418 13 - 13 13 13 -
3419 15 15 15 15 15 15
3420 17 17 - - - -
3421 18 - 18 18 - -
3422
3423 }
3424 do_execsql_test joinC-199 {
3425 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
3426 FROM t1 FULL JOIN (
3427 t2 INNER JOIN (
3428 t3 LEFT JOIN (
3429 t4 RIGHT JOIN t5 USING(a)
3430 ) USING(a)
3431 ) USING(a)
3432 ) USING(a)
3433 ORDER BY 1 NULLS FIRST;
3434 } {
3435 11 11 - - - -
3436 12 12 12 12 - -
3437 13 - 13 13 - -
3438 15 15 15 15 15 15
3439 17 17 - - - -
3440 18 - 18 18 - 18
3441
3442 }
3443 do_execsql_test joinC-200 {
3444 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
3445 FROM t1 FULL JOIN (
3446 t2 INNER JOIN (
3447 t3 LEFT JOIN (
3448 t4 FULL JOIN t5 USING(a)
3449 ) USING(a)
3450 ) USING(a)
3451 ) USING(a)
3452 ORDER BY 1 NULLS FIRST;
3453 } {
3454 11 11 - - - -
3455 12 12 12 12 - -
3456 13 - 13 13 13 -
3457 15 15 15 15 15 15
3458 17 17 - - - -
3459 18 - 18 18 - 18
3460
3461 }
3462 do_execsql_test joinC-201 {
3463 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
3464 FROM t1 FULL JOIN (
3465 t2 INNER JOIN (
3466 t3 RIGHT JOIN (
3467 t4 INNER JOIN t5 USING(a)
3468 ) USING(a)
3469 ) USING(a)
3470 ) USING(a)
3471 ORDER BY 1 NULLS FIRST;
3472 } {
3473 11 11 - - - -
3474 12 12 - - - -
3475 15 15 15 15 15 15
3476 17 17 - - - -
3477
3478 }
3479 do_execsql_test joinC-202 {
3480 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
3481 FROM t1 FULL JOIN (
3482 t2 INNER JOIN (
3483 t3 RIGHT JOIN (
3484 t4 LEFT JOIN t5 USING(a)
3485 ) USING(a)
3486 ) USING(a)
3487 ) USING(a)
3488 ORDER BY 1 NULLS FIRST;
3489 } {
3490 11 11 - - - -
3491 12 12 - - - -
3492 13 - 13 13 13 -
3493 15 15 15 15 15 15
3494 17 17 - - - -
3495
3496 }
3497 do_execsql_test joinC-203 {
3498 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
3499 FROM t1 FULL JOIN (
3500 t2 INNER JOIN (
3501 t3 RIGHT JOIN (
3502 t4 RIGHT JOIN t5 USING(a)
3503 ) USING(a)
3504 ) USING(a)
3505 ) USING(a)
3506 ORDER BY 1 NULLS FIRST;
3507 } {
3508 11 11 - - - -
3509 12 12 - - - -
3510 15 15 15 15 15 15
3511 17 17 - - - -
3512 18 - 18 18 - 18
3513
3514 }
3515 do_execsql_test joinC-204 {
3516 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
3517 FROM t1 FULL JOIN (
3518 t2 INNER JOIN (
3519 t3 RIGHT JOIN (
3520 t4 FULL JOIN t5 USING(a)
3521 ) USING(a)
3522 ) USING(a)
3523 ) USING(a)
3524 ORDER BY 1 NULLS FIRST;
3525 } {
3526 11 11 - - - -
3527 12 12 - - - -
3528 13 - 13 13 13 -
3529 15 15 15 15 15 15
3530 17 17 - - - -
3531 18 - 18 18 - 18
3532
3533 }
3534 do_execsql_test joinC-205 {
3535 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
3536 FROM t1 FULL JOIN (
3537 t2 INNER JOIN (
3538 t3 FULL JOIN (
3539 t4 INNER JOIN t5 USING(a)
3540 ) USING(a)
3541 ) USING(a)
3542 ) USING(a)
3543 ORDER BY 1 NULLS FIRST;
3544 } {
3545 11 11 - - - -
3546 12 12 12 12 - -
3547 13 - 13 13 - -
3548 15 15 15 15 15 15
3549 17 17 - - - -
3550 18 - 18 18 - -
3551
3552 }
3553 do_execsql_test joinC-206 {
3554 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
3555 FROM t1 FULL JOIN (
3556 t2 INNER JOIN (
3557 t3 FULL JOIN (
3558 t4 LEFT JOIN t5 USING(a)
3559 ) USING(a)
3560 ) USING(a)
3561 ) USING(a)
3562 ORDER BY 1 NULLS FIRST;
3563 } {
3564 11 11 - - - -
3565 12 12 12 12 - -
3566 13 - 13 13 13 -
3567 15 15 15 15 15 15
3568 17 17 - - - -
3569 18 - 18 18 - -
3570
3571 }
3572 do_execsql_test joinC-207 {
3573 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
3574 FROM t1 FULL JOIN (
3575 t2 INNER JOIN (
3576 t3 FULL JOIN (
3577 t4 RIGHT JOIN t5 USING(a)
3578 ) USING(a)
3579 ) USING(a)
3580 ) USING(a)
3581 ORDER BY 1 NULLS FIRST;
3582 } {
3583 11 11 - - - -
3584 12 12 12 12 - -
3585 13 - 13 13 - -
3586 15 15 15 15 15 15
3587 17 17 - - - -
3588 18 - 18 18 - 18
3589
3590 }
3591 do_execsql_test joinC-208 {
3592 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
3593 FROM t1 FULL JOIN (
3594 t2 INNER JOIN (
3595 t3 FULL JOIN (
3596 t4 FULL JOIN t5 USING(a)
3597 ) USING(a)
3598 ) USING(a)
3599 ) USING(a)
3600 ORDER BY 1 NULLS FIRST;
3601 } {
3602 11 11 - - - -
3603 12 12 12 12 - -
3604 13 - 13 13 13 -
3605 15 15 15 15 15 15
3606 17 17 - - - -
3607 18 - 18 18 - 18
3608
3609 }
3610 do_execsql_test joinC-209 {
3611 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
3612 FROM t1 FULL JOIN (
3613 t2 LEFT JOIN (
3614 t3 INNER JOIN (
3615 t4 INNER JOIN t5 USING(a)
3616 ) USING(a)
3617 ) USING(a)
3618 ) USING(a)
3619 ORDER BY 1 NULLS FIRST;
3620 } {
3621 - - - - - -
3622 11 11 - - - -
3623 12 12 12 - - -
3624 13 - 13 - - -
3625 15 15 15 15 15 15
3626 17 17 - - - -
3627 18 - 18 - - -
3628
3629 }
3630 do_execsql_test joinC-210 {
3631 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
3632 FROM t1 FULL JOIN (
3633 t2 LEFT JOIN (
3634 t3 INNER JOIN (
3635 t4 LEFT JOIN t5 USING(a)
3636 ) USING(a)
3637 ) USING(a)
3638 ) USING(a)
3639 ORDER BY 1 NULLS FIRST;
3640 } {
3641 - - - - - -
3642 11 11 - - - -
3643 12 12 12 - - -
3644 13 - 13 13 13 -
3645 15 15 15 15 15 15
3646 17 17 - - - -
3647 18 - 18 - - -
3648
3649 }
3650 do_execsql_test joinC-211 {
3651 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
3652 FROM t1 FULL JOIN (
3653 t2 LEFT JOIN (
3654 t3 INNER JOIN (
3655 t4 RIGHT JOIN t5 USING(a)
3656 ) USING(a)
3657 ) USING(a)
3658 ) USING(a)
3659 ORDER BY 1 NULLS FIRST;
3660 } {
3661 - - - - - -
3662 11 11 - - - -
3663 12 12 12 - - -
3664 13 - 13 - - -
3665 15 15 15 15 15 15
3666 17 17 - - - -
3667 18 - 18 18 - 18
3668
3669 }
3670 do_execsql_test joinC-212 {
3671 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
3672 FROM t1 FULL JOIN (
3673 t2 LEFT JOIN (
3674 t3 INNER JOIN (
3675 t4 FULL JOIN t5 USING(a)
3676 ) USING(a)
3677 ) USING(a)
3678 ) USING(a)
3679 ORDER BY 1 NULLS FIRST;
3680 } {
3681 - - - - - -
3682 11 11 - - - -
3683 12 12 12 - - -
3684 13 - 13 13 13 -
3685 15 15 15 15 15 15
3686 17 17 - - - -
3687 18 - 18 18 - 18
3688
3689 }
3690 do_execsql_test joinC-213 {
3691 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
3692 FROM t1 FULL JOIN (
3693 t2 LEFT JOIN (
3694 t3 LEFT JOIN (
3695 t4 INNER JOIN t5 USING(a)
3696 ) USING(a)
3697 ) USING(a)
3698 ) USING(a)
3699 ORDER BY 1 NULLS FIRST;
3700 } {
3701 - - - - - -
3702 11 11 - - - -
3703 12 12 12 12 - -
3704 13 - 13 13 - -
3705 15 15 15 15 15 15
3706 17 17 - - - -
3707 18 - 18 18 - -
3708
3709 }
3710 do_execsql_test joinC-214 {
3711 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
3712 FROM t1 FULL JOIN (
3713 t2 LEFT JOIN (
3714 t3 LEFT JOIN (
3715 t4 LEFT JOIN t5 USING(a)
3716 ) USING(a)
3717 ) USING(a)
3718 ) USING(a)
3719 ORDER BY 1 NULLS FIRST;
3720 } {
3721 - - - - - -
3722 11 11 - - - -
3723 12 12 12 12 - -
3724 13 - 13 13 13 -
3725 15 15 15 15 15 15
3726 17 17 - - - -
3727 18 - 18 18 - -
3728
3729 }
3730 do_execsql_test joinC-215 {
3731 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
3732 FROM t1 FULL JOIN (
3733 t2 LEFT JOIN (
3734 t3 LEFT JOIN (
3735 t4 RIGHT JOIN t5 USING(a)
3736 ) USING(a)
3737 ) USING(a)
3738 ) USING(a)
3739 ORDER BY 1 NULLS FIRST;
3740 } {
3741 - - - - - -
3742 11 11 - - - -
3743 12 12 12 12 - -
3744 13 - 13 13 - -
3745 15 15 15 15 15 15
3746 17 17 - - - -
3747 18 - 18 18 - 18
3748
3749 }
3750 do_execsql_test joinC-216 {
3751 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
3752 FROM t1 FULL JOIN (
3753 t2 LEFT JOIN (
3754 t3 LEFT JOIN (
3755 t4 FULL JOIN t5 USING(a)
3756 ) USING(a)
3757 ) USING(a)
3758 ) USING(a)
3759 ORDER BY 1 NULLS FIRST;
3760 } {
3761 - - - - - -
3762 11 11 - - - -
3763 12 12 12 12 - -
3764 13 - 13 13 13 -
3765 15 15 15 15 15 15
3766 17 17 - - - -
3767 18 - 18 18 - 18
3768
3769 }
3770 do_execsql_test joinC-217 {
3771 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
3772 FROM t1 FULL JOIN (
3773 t2 LEFT JOIN (
3774 t3 RIGHT JOIN (
3775 t4 INNER JOIN t5 USING(a)
3776 ) USING(a)
3777 ) USING(a)
3778 ) USING(a)
3779 ORDER BY 1 NULLS FIRST;
3780 } {
3781 - - - - - -
3782 11 11 - - - -
3783 12 12 12 - - -
3784 13 - 13 - - -
3785 15 15 15 15 15 15
3786 17 17 - - - -
3787 18 - 18 - - -
3788
3789 }
3790 do_execsql_test joinC-218 {
3791 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
3792 FROM t1 FULL JOIN (
3793 t2 LEFT JOIN (
3794 t3 RIGHT JOIN (
3795 t4 LEFT JOIN t5 USING(a)
3796 ) USING(a)
3797 ) USING(a)
3798 ) USING(a)
3799 ORDER BY 1 NULLS FIRST;
3800 } {
3801 - - - - - -
3802 11 11 - - - -
3803 12 12 12 - - -
3804 13 - 13 13 13 -
3805 15 15 15 15 15 15
3806 17 17 - - - -
3807 18 - 18 - - -
3808
3809 }
3810 do_execsql_test joinC-219 {
3811 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
3812 FROM t1 FULL JOIN (
3813 t2 LEFT JOIN (
3814 t3 RIGHT JOIN (
3815 t4 RIGHT JOIN t5 USING(a)
3816 ) USING(a)
3817 ) USING(a)
3818 ) USING(a)
3819 ORDER BY 1 NULLS FIRST;
3820 } {
3821 - - - - - -
3822 11 11 - - - -
3823 12 12 12 - - -
3824 13 - 13 - - -
3825 15 15 15 15 15 15
3826 17 17 - - - -
3827 18 - 18 18 - 18
3828
3829 }
3830 do_execsql_test joinC-220 {
3831 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
3832 FROM t1 FULL JOIN (
3833 t2 LEFT JOIN (
3834 t3 RIGHT JOIN (
3835 t4 FULL JOIN t5 USING(a)
3836 ) USING(a)
3837 ) USING(a)
3838 ) USING(a)
3839 ORDER BY 1 NULLS FIRST;
3840 } {
3841 - - - - - -
3842 11 11 - - - -
3843 12 12 12 - - -
3844 13 - 13 13 13 -
3845 15 15 15 15 15 15
3846 17 17 - - - -
3847 18 - 18 18 - 18
3848
3849 }
3850 do_execsql_test joinC-221 {
3851 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
3852 FROM t1 FULL JOIN (
3853 t2 LEFT JOIN (
3854 t3 FULL JOIN (
3855 t4 INNER JOIN t5 USING(a)
3856 ) USING(a)
3857 ) USING(a)
3858 ) USING(a)
3859 ORDER BY 1 NULLS FIRST;
3860 } {
3861 - - - - - -
3862 11 11 - - - -
3863 12 12 12 12 - -
3864 13 - 13 13 - -
3865 15 15 15 15 15 15
3866 17 17 - - - -
3867 18 - 18 18 - -
3868
3869 }
3870 do_execsql_test joinC-222 {
3871 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
3872 FROM t1 FULL JOIN (
3873 t2 LEFT JOIN (
3874 t3 FULL JOIN (
3875 t4 LEFT JOIN t5 USING(a)
3876 ) USING(a)
3877 ) USING(a)
3878 ) USING(a)
3879 ORDER BY 1 NULLS FIRST;
3880 } {
3881 - - - - - -
3882 11 11 - - - -
3883 12 12 12 12 - -
3884 13 - 13 13 13 -
3885 15 15 15 15 15 15
3886 17 17 - - - -
3887 18 - 18 18 - -
3888
3889 }
3890 do_execsql_test joinC-223 {
3891 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
3892 FROM t1 FULL JOIN (
3893 t2 LEFT JOIN (
3894 t3 FULL JOIN (
3895 t4 RIGHT JOIN t5 USING(a)
3896 ) USING(a)
3897 ) USING(a)
3898 ) USING(a)
3899 ORDER BY 1 NULLS FIRST;
3900 } {
3901 - - - - - -
3902 11 11 - - - -
3903 12 12 12 12 - -
3904 13 - 13 13 - -
3905 15 15 15 15 15 15
3906 17 17 - - - -
3907 18 - 18 18 - 18
3908
3909 }
3910 do_execsql_test joinC-224 {
3911 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
3912 FROM t1 FULL JOIN (
3913 t2 LEFT JOIN (
3914 t3 FULL JOIN (
3915 t4 FULL JOIN t5 USING(a)
3916 ) USING(a)
3917 ) USING(a)
3918 ) USING(a)
3919 ORDER BY 1 NULLS FIRST;
3920 } {
3921 - - - - - -
3922 11 11 - - - -
3923 12 12 12 12 - -
3924 13 - 13 13 13 -
3925 15 15 15 15 15 15
3926 17 17 - - - -
3927 18 - 18 18 - 18
3928
3929 }
3930 do_execsql_test joinC-225 {
3931 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
3932 FROM t1 FULL JOIN (
3933 t2 RIGHT JOIN (
3934 t3 INNER JOIN (
3935 t4 INNER JOIN t5 USING(a)
3936 ) USING(a)
3937 ) USING(a)
3938 ) USING(a)
3939 ORDER BY 1 NULLS FIRST;
3940 } {
3941 11 11 - - - -
3942 12 12 - - - -
3943 15 15 15 15 15 15
3944 17 17 - - - -
3945 19 - - 19 19 19
3946
3947 }
3948 do_execsql_test joinC-226 {
3949 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
3950 FROM t1 FULL JOIN (
3951 t2 RIGHT JOIN (
3952 t3 INNER JOIN (
3953 t4 LEFT JOIN t5 USING(a)
3954 ) USING(a)
3955 ) USING(a)
3956 ) USING(a)
3957 ORDER BY 1 NULLS FIRST;
3958 } {
3959 11 11 - 11 11 -
3960 12 12 - - - -
3961 13 - 13 13 13 -
3962 15 15 15 15 15 15
3963 17 17 - - - -
3964 19 - - 19 19 19
3965
3966 }
3967 do_execsql_test joinC-227 {
3968 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
3969 FROM t1 FULL JOIN (
3970 t2 RIGHT JOIN (
3971 t3 INNER JOIN (
3972 t4 RIGHT JOIN t5 USING(a)
3973 ) USING(a)
3974 ) USING(a)
3975 ) USING(a)
3976 ORDER BY 1 NULLS FIRST;
3977 } {
3978 11 11 - - - -
3979 12 12 - - - -
3980 15 15 15 15 15 15
3981 17 17 - 17 - 17
3982 18 - 18 18 - 18
3983 19 - - 19 19 19
3984
3985 }
3986 do_execsql_test joinC-228 {
3987 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
3988 FROM t1 FULL JOIN (
3989 t2 RIGHT JOIN (
3990 t3 INNER JOIN (
3991 t4 FULL JOIN t5 USING(a)
3992 ) USING(a)
3993 ) USING(a)
3994 ) USING(a)
3995 ORDER BY 1 NULLS FIRST;
3996 } {
3997 11 11 - 11 11 -
3998 12 12 - - - -
3999 13 - 13 13 13 -
4000 15 15 15 15 15 15
4001 17 17 - 17 - 17
4002 18 - 18 18 - 18
4003 19 - - 19 19 19
4004
4005 }
4006 do_execsql_test joinC-229 {
4007 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
4008 FROM t1 FULL JOIN (
4009 t2 RIGHT JOIN (
4010 t3 LEFT JOIN (
4011 t4 INNER JOIN t5 USING(a)
4012 ) USING(a)
4013 ) USING(a)
4014 ) USING(a)
4015 ORDER BY 1 NULLS FIRST;
4016 } {
4017 - - - - - -
4018 11 11 - 11 - -
4019 12 12 12 12 - -
4020 13 - 13 13 - -
4021 15 15 15 15 15 15
4022 17 17 - 17 - -
4023 18 - 18 18 - -
4024 19 - - 19 19 19
4025
4026 }
4027 do_execsql_test joinC-230 {
4028 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
4029 FROM t1 FULL JOIN (
4030 t2 RIGHT JOIN (
4031 t3 LEFT JOIN (
4032 t4 LEFT JOIN t5 USING(a)
4033 ) USING(a)
4034 ) USING(a)
4035 ) USING(a)
4036 ORDER BY 1 NULLS FIRST;
4037 } {
4038 - - - - - -
4039 11 11 - 11 11 -
4040 12 12 12 12 - -
4041 13 - 13 13 13 -
4042 15 15 15 15 15 15
4043 17 17 - 17 - -
4044 18 - 18 18 - -
4045 19 - - 19 19 19
4046
4047 }
4048 do_execsql_test joinC-231 {
4049 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
4050 FROM t1 FULL JOIN (
4051 t2 RIGHT JOIN (
4052 t3 LEFT JOIN (
4053 t4 RIGHT JOIN t5 USING(a)
4054 ) USING(a)
4055 ) USING(a)
4056 ) USING(a)
4057 ORDER BY 1 NULLS FIRST;
4058 } {
4059 - - - - - -
4060 11 11 - 11 - -
4061 12 12 12 12 - -
4062 13 - 13 13 - -
4063 15 15 15 15 15 15
4064 17 17 - 17 - 17
4065 18 - 18 18 - 18
4066 19 - - 19 19 19
4067
4068 }
4069 do_execsql_test joinC-232 {
4070 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
4071 FROM t1 FULL JOIN (
4072 t2 RIGHT JOIN (
4073 t3 LEFT JOIN (
4074 t4 FULL JOIN t5 USING(a)
4075 ) USING(a)
4076 ) USING(a)
4077 ) USING(a)
4078 ORDER BY 1 NULLS FIRST;
4079 } {
4080 - - - - - -
4081 11 11 - 11 11 -
4082 12 12 12 12 - -
4083 13 - 13 13 13 -
4084 15 15 15 15 15 15
4085 17 17 - 17 - 17
4086 18 - 18 18 - 18
4087 19 - - 19 19 19
4088
4089 }
4090 do_execsql_test joinC-233 {
4091 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
4092 FROM t1 FULL JOIN (
4093 t2 RIGHT JOIN (
4094 t3 RIGHT JOIN (
4095 t4 INNER JOIN t5 USING(a)
4096 ) USING(a)
4097 ) USING(a)
4098 ) USING(a)
4099 ORDER BY 1 NULLS FIRST;
4100 } {
4101 11 11 - - - -
4102 12 12 - - - -
4103 15 15 15 15 15 15
4104 17 17 - - - -
4105 19 - - 19 19 19
4106
4107 }
4108 do_execsql_test joinC-234 {
4109 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
4110 FROM t1 FULL JOIN (
4111 t2 RIGHT JOIN (
4112 t3 RIGHT JOIN (
4113 t4 LEFT JOIN t5 USING(a)
4114 ) USING(a)
4115 ) USING(a)
4116 ) USING(a)
4117 ORDER BY 1 NULLS FIRST;
4118 } {
4119 11 11 - 11 11 -
4120 12 12 - - - -
4121 13 - 13 13 13 -
4122 15 15 15 15 15 15
4123 17 17 - - - -
4124 19 - - 19 19 19
4125
4126 }
4127 do_execsql_test joinC-235 {
4128 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
4129 FROM t1 FULL JOIN (
4130 t2 RIGHT JOIN (
4131 t3 RIGHT JOIN (
4132 t4 RIGHT JOIN t5 USING(a)
4133 ) USING(a)
4134 ) USING(a)
4135 ) USING(a)
4136 ORDER BY 1 NULLS FIRST;
4137 } {
4138 11 11 - - - -
4139 12 12 - - - -
4140 15 15 15 15 15 15
4141 17 17 - 17 - 17
4142 18 - 18 18 - 18
4143 19 - - 19 19 19
4144
4145 }
4146 do_execsql_test joinC-236 {
4147 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
4148 FROM t1 FULL JOIN (
4149 t2 RIGHT JOIN (
4150 t3 RIGHT JOIN (
4151 t4 FULL JOIN t5 USING(a)
4152 ) USING(a)
4153 ) USING(a)
4154 ) USING(a)
4155 ORDER BY 1 NULLS FIRST;
4156 } {
4157 11 11 - 11 11 -
4158 12 12 - - - -
4159 13 - 13 13 13 -
4160 15 15 15 15 15 15
4161 17 17 - 17 - 17
4162 18 - 18 18 - 18
4163 19 - - 19 19 19
4164
4165 }
4166 do_execsql_test joinC-237 {
4167 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
4168 FROM t1 FULL JOIN (
4169 t2 RIGHT JOIN (
4170 t3 FULL JOIN (
4171 t4 INNER JOIN t5 USING(a)
4172 ) USING(a)
4173 ) USING(a)
4174 ) USING(a)
4175 ORDER BY 1 NULLS FIRST;
4176 } {
4177 - - - - - -
4178 11 11 - 11 - -
4179 12 12 12 12 - -
4180 13 - 13 13 - -
4181 15 15 15 15 15 15
4182 17 17 - 17 - -
4183 18 - 18 18 - -
4184 19 - - 19 19 19
4185
4186 }
4187 do_execsql_test joinC-238 {
4188 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
4189 FROM t1 FULL JOIN (
4190 t2 RIGHT JOIN (
4191 t3 FULL JOIN (
4192 t4 LEFT JOIN t5 USING(a)
4193 ) USING(a)
4194 ) USING(a)
4195 ) USING(a)
4196 ORDER BY 1 NULLS FIRST;
4197 } {
4198 - - - - - -
4199 11 11 - 11 11 -
4200 12 12 12 12 - -
4201 13 - 13 13 13 -
4202 15 15 15 15 15 15
4203 17 17 - 17 - -
4204 18 - 18 18 - -
4205 19 - - 19 19 19
4206
4207 }
4208 do_execsql_test joinC-239 {
4209 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
4210 FROM t1 FULL JOIN (
4211 t2 RIGHT JOIN (
4212 t3 FULL JOIN (
4213 t4 RIGHT JOIN t5 USING(a)
4214 ) USING(a)
4215 ) USING(a)
4216 ) USING(a)
4217 ORDER BY 1 NULLS FIRST;
4218 } {
4219 - - - - - -
4220 11 11 - 11 - -
4221 12 12 12 12 - -
4222 13 - 13 13 - -
4223 15 15 15 15 15 15
4224 17 17 - 17 - 17
4225 18 - 18 18 - 18
4226 19 - - 19 19 19
4227
4228 }
4229 do_execsql_test joinC-240 {
4230 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
4231 FROM t1 FULL JOIN (
4232 t2 RIGHT JOIN (
4233 t3 FULL JOIN (
4234 t4 FULL JOIN t5 USING(a)
4235 ) USING(a)
4236 ) USING(a)
4237 ) USING(a)
4238 ORDER BY 1 NULLS FIRST;
4239 } {
4240 - - - - - -
4241 11 11 - 11 11 -
4242 12 12 12 12 - -
4243 13 - 13 13 13 -
4244 15 15 15 15 15 15
4245 17 17 - 17 - 17
4246 18 - 18 18 - 18
4247 19 - - 19 19 19
4248
4249 }
4250 do_execsql_test joinC-241 {
4251 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
4252 FROM t1 FULL JOIN (
4253 t2 FULL JOIN (
4254 t3 INNER JOIN (
4255 t4 INNER JOIN t5 USING(a)
4256 ) USING(a)
4257 ) USING(a)
4258 ) USING(a)
4259 ORDER BY 1 NULLS FIRST;
4260 } {
4261 - - - - - -
4262 11 11 - - - -
4263 12 12 12 - - -
4264 13 - 13 - - -
4265 15 15 15 15 15 15
4266 17 17 - - - -
4267 18 - 18 - - -
4268 19 - - 19 19 19
4269
4270 }
4271 do_execsql_test joinC-242 {
4272 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
4273 FROM t1 FULL JOIN (
4274 t2 FULL JOIN (
4275 t3 INNER JOIN (
4276 t4 LEFT JOIN t5 USING(a)
4277 ) USING(a)
4278 ) USING(a)
4279 ) USING(a)
4280 ORDER BY 1 NULLS FIRST;
4281 } {
4282 - - - - - -
4283 11 11 - 11 11 -
4284 12 12 12 - - -
4285 13 - 13 13 13 -
4286 15 15 15 15 15 15
4287 17 17 - - - -
4288 18 - 18 - - -
4289 19 - - 19 19 19
4290
4291 }
4292 do_execsql_test joinC-243 {
4293 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
4294 FROM t1 FULL JOIN (
4295 t2 FULL JOIN (
4296 t3 INNER JOIN (
4297 t4 RIGHT JOIN t5 USING(a)
4298 ) USING(a)
4299 ) USING(a)
4300 ) USING(a)
4301 ORDER BY 1 NULLS FIRST;
4302 } {
4303 - - - - - -
4304 11 11 - - - -
4305 12 12 12 - - -
4306 13 - 13 - - -
4307 15 15 15 15 15 15
4308 17 17 - 17 - 17
4309 18 - 18 18 - 18
4310 19 - - 19 19 19
4311
4312 }
4313 do_execsql_test joinC-244 {
4314 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
4315 FROM t1 FULL JOIN (
4316 t2 FULL JOIN (
4317 t3 INNER JOIN (
4318 t4 FULL JOIN t5 USING(a)
4319 ) USING(a)
4320 ) USING(a)
4321 ) USING(a)
4322 ORDER BY 1 NULLS FIRST;
4323 } {
4324 - - - - - -
4325 11 11 - 11 11 -
4326 12 12 12 - - -
4327 13 - 13 13 13 -
4328 15 15 15 15 15 15
4329 17 17 - 17 - 17
4330 18 - 18 18 - 18
4331 19 - - 19 19 19
4332
4333 }
4334 do_execsql_test joinC-245 {
4335 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
4336 FROM t1 FULL JOIN (
4337 t2 FULL JOIN (
4338 t3 LEFT JOIN (
4339 t4 INNER JOIN t5 USING(a)
4340 ) USING(a)
4341 ) USING(a)
4342 ) USING(a)
4343 ORDER BY 1 NULLS FIRST;
4344 } {
4345 - - - - - -
4346 - - - - - -
4347 11 11 - 11 - -
4348 12 12 12 12 - -
4349 13 - 13 13 - -
4350 15 15 15 15 15 15
4351 17 17 - 17 - -
4352 18 - 18 18 - -
4353 19 - - 19 19 19
4354
4355 }
4356 do_execsql_test joinC-246 {
4357 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
4358 FROM t1 FULL JOIN (
4359 t2 FULL JOIN (
4360 t3 LEFT JOIN (
4361 t4 LEFT JOIN t5 USING(a)
4362 ) USING(a)
4363 ) USING(a)
4364 ) USING(a)
4365 ORDER BY 1 NULLS FIRST;
4366 } {
4367 - - - - - -
4368 - - - - - -
4369 11 11 - 11 11 -
4370 12 12 12 12 - -
4371 13 - 13 13 13 -
4372 15 15 15 15 15 15
4373 17 17 - 17 - -
4374 18 - 18 18 - -
4375 19 - - 19 19 19
4376
4377 }
4378 do_execsql_test joinC-247 {
4379 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
4380 FROM t1 FULL JOIN (
4381 t2 FULL JOIN (
4382 t3 LEFT JOIN (
4383 t4 RIGHT JOIN t5 USING(a)
4384 ) USING(a)
4385 ) USING(a)
4386 ) USING(a)
4387 ORDER BY 1 NULLS FIRST;
4388 } {
4389 - - - - - -
4390 - - - - - -
4391 11 11 - 11 - -
4392 12 12 12 12 - -
4393 13 - 13 13 - -
4394 15 15 15 15 15 15
4395 17 17 - 17 - 17
4396 18 - 18 18 - 18
4397 19 - - 19 19 19
4398
4399 }
4400 do_execsql_test joinC-248 {
4401 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
4402 FROM t1 FULL JOIN (
4403 t2 FULL JOIN (
4404 t3 LEFT JOIN (
4405 t4 FULL JOIN t5 USING(a)
4406 ) USING(a)
4407 ) USING(a)
4408 ) USING(a)
4409 ORDER BY 1 NULLS FIRST;
4410 } {
4411 - - - - - -
4412 - - - - - -
4413 11 11 - 11 11 -
4414 12 12 12 12 - -
4415 13 - 13 13 13 -
4416 15 15 15 15 15 15
4417 17 17 - 17 - 17
4418 18 - 18 18 - 18
4419 19 - - 19 19 19
4420
4421 }
4422 do_execsql_test joinC-249 {
4423 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
4424 FROM t1 FULL JOIN (
4425 t2 FULL JOIN (
4426 t3 RIGHT JOIN (
4427 t4 INNER JOIN t5 USING(a)
4428 ) USING(a)
4429 ) USING(a)
4430 ) USING(a)
4431 ORDER BY 1 NULLS FIRST;
4432 } {
4433 - - - - - -
4434 11 11 - - - -
4435 12 12 12 - - -
4436 13 - 13 - - -
4437 15 15 15 15 15 15
4438 17 17 - - - -
4439 18 - 18 - - -
4440 19 - - 19 19 19
4441
4442 }
4443 do_execsql_test joinC-250 {
4444 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
4445 FROM t1 FULL JOIN (
4446 t2 FULL JOIN (
4447 t3 RIGHT JOIN (
4448 t4 LEFT JOIN t5 USING(a)
4449 ) USING(a)
4450 ) USING(a)
4451 ) USING(a)
4452 ORDER BY 1 NULLS FIRST;
4453 } {
4454 - - - - - -
4455 11 11 - 11 11 -
4456 12 12 12 - - -
4457 13 - 13 13 13 -
4458 15 15 15 15 15 15
4459 17 17 - - - -
4460 18 - 18 - - -
4461 19 - - 19 19 19
4462
4463 }
4464 do_execsql_test joinC-251 {
4465 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
4466 FROM t1 FULL JOIN (
4467 t2 FULL JOIN (
4468 t3 RIGHT JOIN (
4469 t4 RIGHT JOIN t5 USING(a)
4470 ) USING(a)
4471 ) USING(a)
4472 ) USING(a)
4473 ORDER BY 1 NULLS FIRST;
4474 } {
4475 - - - - - -
4476 11 11 - - - -
4477 12 12 12 - - -
4478 13 - 13 - - -
4479 15 15 15 15 15 15
4480 17 17 - 17 - 17
4481 18 - 18 18 - 18
4482 19 - - 19 19 19
4483
4484 }
4485 do_execsql_test joinC-252 {
4486 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
4487 FROM t1 FULL JOIN (
4488 t2 FULL JOIN (
4489 t3 RIGHT JOIN (
4490 t4 FULL JOIN t5 USING(a)
4491 ) USING(a)
4492 ) USING(a)
4493 ) USING(a)
4494 ORDER BY 1 NULLS FIRST;
4495 } {
4496 - - - - - -
4497 11 11 - 11 11 -
4498 12 12 12 - - -
4499 13 - 13 13 13 -
4500 15 15 15 15 15 15
4501 17 17 - 17 - 17
4502 18 - 18 18 - 18
4503 19 - - 19 19 19
4504
4505 }
4506 do_execsql_test joinC-253 {
4507 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
4508 FROM t1 FULL JOIN (
4509 t2 FULL JOIN (
4510 t3 FULL JOIN (
4511 t4 INNER JOIN t5 USING(a)
4512 ) USING(a)
4513 ) USING(a)
4514 ) USING(a)
4515 ORDER BY 1 NULLS FIRST;
4516 } {
4517 - - - - - -
4518 - - - - - -
4519 11 11 - 11 - -
4520 12 12 12 12 - -
4521 13 - 13 13 - -
4522 15 15 15 15 15 15
4523 17 17 - 17 - -
4524 18 - 18 18 - -
4525 19 - - 19 19 19
4526
4527 }
4528 do_execsql_test joinC-254 {
4529 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
4530 FROM t1 FULL JOIN (
4531 t2 FULL JOIN (
4532 t3 FULL JOIN (
4533 t4 LEFT JOIN t5 USING(a)
4534 ) USING(a)
4535 ) USING(a)
4536 ) USING(a)
4537 ORDER BY 1 NULLS FIRST;
4538 } {
4539 - - - - - -
4540 - - - - - -
4541 11 11 - 11 11 -
4542 12 12 12 12 - -
4543 13 - 13 13 13 -
4544 15 15 15 15 15 15
4545 17 17 - 17 - -
4546 18 - 18 18 - -
4547 19 - - 19 19 19
4548
4549 }
4550 do_execsql_test joinC-255 {
4551 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
4552 FROM t1 FULL JOIN (
4553 t2 FULL JOIN (
4554 t3 FULL JOIN (
4555 t4 RIGHT JOIN t5 USING(a)
4556 ) USING(a)
4557 ) USING(a)
4558 ) USING(a)
4559 ORDER BY 1 NULLS FIRST;
4560 } {
4561 - - - - - -
4562 - - - - - -
4563 11 11 - 11 - -
4564 12 12 12 12 - -
4565 13 - 13 13 - -
4566 15 15 15 15 15 15
4567 17 17 - 17 - 17
4568 18 - 18 18 - 18
4569 19 - - 19 19 19
4570
4571 }
4572 do_execsql_test joinC-256 {
4573 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
4574 FROM t1 FULL JOIN (
4575 t2 FULL JOIN (
4576 t3 FULL JOIN (
4577 t4 FULL JOIN t5 USING(a)
4578 ) USING(a)
4579 ) USING(a)
4580 ) USING(a)
4581 ORDER BY 1 NULLS FIRST;
4582 } {
4583 - - - - - -
4584 - - - - - -
4585 11 11 - 11 11 -
4586 12 12 12 12 - -
4587 13 - 13 13 13 -
4588 15 15 15 15 15 15
4589 17 17 - 17 - 17
4590 18 - 18 18 - 18
4591 19 - - 19 19 19
4592
4593 }
4594 finish_test