1 DROP TABLE IF EXISTS t1,t2,t3,t4,t5,t6;
2 CREATE TABLE t1 (c1 TINYINT NOT NULL);
3 CREATE TABLE t2 (c1 TINYINT NOT NULL);
4 CREATE TABLE t3 (c1 TINYINT NOT NULL);
5 CREATE TABLE t4 (c1 TINYINT NOT NULL);
6 CREATE TABLE t5 (c1 TINYINT NOT NULL);
7 CREATE TABLE t6 (c1 TINYINT NOT NULL);
8 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
9 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
10 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
11 INSERT INTO t4 (c1) VALUES(10);
12 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
13 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 USING (c1);
25 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1;
37 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 < 5;
44 DROP TABLE t1,t2,t3,t4,t5,t6;
45 CREATE TABLE t1 (c1 SMALLINT NOT NULL);
46 CREATE TABLE t2 (c1 SMALLINT NOT NULL);
47 CREATE TABLE t3 (c1 SMALLINT NOT NULL);
48 CREATE TABLE t4 (c1 SMALLINT NOT NULL);
49 CREATE TABLE t5 (c1 SMALLINT NOT NULL);
50 CREATE TABLE t6 (c1 SMALLINT NOT NULL);
51 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
52 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
53 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
54 INSERT INTO t4 (c1) VALUES(10);
55 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
56 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 USING (c1);
68 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1;
80 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 < 5;
87 DROP TABLE t1,t2,t3,t4,t5,t6;
88 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
89 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
90 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
91 CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
92 CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
93 CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
94 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
95 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
96 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
97 INSERT INTO t4 (c1) VALUES(10);
98 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
99 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 USING (c1);
111 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1;
123 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 < 5;
130 DROP TABLE t1,t2,t3,t4,t5,t6;
131 CREATE TABLE t1 (c1 INT NOT NULL);
132 CREATE TABLE t2 (c1 INT NOT NULL);
133 CREATE TABLE t3 (c1 INT NOT NULL);
134 CREATE TABLE t4 (c1 INT NOT NULL);
135 CREATE TABLE t5 (c1 INT NOT NULL);
136 CREATE TABLE t6 (c1 INT NOT NULL);
137 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
138 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
139 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
140 INSERT INTO t4 (c1) VALUES(10);
141 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
142 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 USING (c1);
154 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1;
166 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 < 5;
173 DROP TABLE t1,t2,t3,t4,t5,t6;
174 CREATE TABLE t1 (c1 INTEGER NOT NULL);
175 CREATE TABLE t2 (c1 INTEGER NOT NULL);
176 CREATE TABLE t3 (c1 INTEGER NOT NULL);
177 CREATE TABLE t4 (c1 INTEGER NOT NULL);
178 CREATE TABLE t5 (c1 INTEGER NOT NULL);
179 CREATE TABLE t6 (c1 INTEGER NOT NULL);
180 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
181 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
182 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
183 INSERT INTO t4 (c1) VALUES(10);
184 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
185 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 USING (c1);
197 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1;
209 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 < 5;
216 DROP TABLE t1,t2,t3,t4,t5,t6;
217 CREATE TABLE t1 (c1 BIGINT NOT NULL);
218 CREATE TABLE t2 (c1 BIGINT NOT NULL);
219 CREATE TABLE t3 (c1 BIGINT NOT NULL);
220 CREATE TABLE t4 (c1 BIGINT NOT NULL);
221 CREATE TABLE t5 (c1 BIGINT NOT NULL);
222 CREATE TABLE t6 (c1 BIGINT NOT NULL);
223 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
224 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
225 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
226 INSERT INTO t4 (c1) VALUES(10);
227 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
228 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 USING (c1);
240 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1;
252 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 < 5;
259 DROP TABLE t1,t2,t3,t4,t5,t6;
260 CREATE TABLE t1 (c1 TINYINT NOT NULL);
261 CREATE TABLE t2 (c1 TINYINT NOT NULL);
262 CREATE TABLE t3 (c1 TINYINT NOT NULL);
263 CREATE TABLE t4 (c1 TINYINT NOT NULL);
264 CREATE TABLE t5 (c1 TINYINT NOT NULL);
265 CREATE TABLE t6 (c1 TINYINT NOT NULL);
266 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
267 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
268 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
269 INSERT INTO t4 (c1) VALUES(10);
270 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
271 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 USING (c1);
283 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1;
295 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 < 5;
302 DROP TABLE t1,t2,t3,t4,t5,t6;
303 CREATE TABLE t1 (c1 SMALLINT NOT NULL);
304 CREATE TABLE t2 (c1 SMALLINT NOT NULL);
305 CREATE TABLE t3 (c1 SMALLINT NOT NULL);
306 CREATE TABLE t4 (c1 SMALLINT NOT NULL);
307 CREATE TABLE t5 (c1 SMALLINT NOT NULL);
308 CREATE TABLE t6 (c1 SMALLINT NOT NULL);
309 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
310 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
311 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
312 INSERT INTO t4 (c1) VALUES(10);
313 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
314 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 USING (c1);
326 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1;
338 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 < 5;
345 DROP TABLE t1,t2,t3,t4,t5,t6;
346 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
347 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
348 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
349 CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
350 CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
351 CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
352 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
353 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
354 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
355 INSERT INTO t4 (c1) VALUES(10);
356 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
357 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 USING (c1);
369 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1;
381 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 < 5;
388 DROP TABLE t1,t2,t3,t4,t5,t6;
389 CREATE TABLE t1 (c1 INT NOT NULL);
390 CREATE TABLE t2 (c1 INT NOT NULL);
391 CREATE TABLE t3 (c1 INT NOT NULL);
392 CREATE TABLE t4 (c1 INT NOT NULL);
393 CREATE TABLE t5 (c1 INT NOT NULL);
394 CREATE TABLE t6 (c1 INT NOT NULL);
395 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
396 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
397 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
398 INSERT INTO t4 (c1) VALUES(10);
399 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
400 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 USING (c1);
412 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1;
424 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 < 5;
431 DROP TABLE t1,t2,t3,t4,t5,t6;
432 CREATE TABLE t1 (c1 INTEGER NOT NULL);
433 CREATE TABLE t2 (c1 INTEGER NOT NULL);
434 CREATE TABLE t3 (c1 INTEGER NOT NULL);
435 CREATE TABLE t4 (c1 INTEGER NOT NULL);
436 CREATE TABLE t5 (c1 INTEGER NOT NULL);
437 CREATE TABLE t6 (c1 INTEGER NOT NULL);
438 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
439 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
440 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
441 INSERT INTO t4 (c1) VALUES(10);
442 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
443 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 USING (c1);
455 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1;
467 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 < 5;
474 DROP TABLE t1,t2,t3,t4,t5,t6;
475 CREATE TABLE t1 (c1 BIGINT NOT NULL);
476 CREATE TABLE t2 (c1 BIGINT NOT NULL);
477 CREATE TABLE t3 (c1 BIGINT NOT NULL);
478 CREATE TABLE t4 (c1 BIGINT NOT NULL);
479 CREATE TABLE t5 (c1 BIGINT NOT NULL);
480 CREATE TABLE t6 (c1 BIGINT NOT NULL);
481 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
482 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
483 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
484 INSERT INTO t4 (c1) VALUES(10);
485 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
486 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 USING (c1);
498 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1;
510 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 < 5;
517 DROP TABLE t1,t2,t3,t4,t5,t6;
518 CREATE TABLE t1 (c1 TINYINT NOT NULL);
519 CREATE TABLE t2 (c1 TINYINT NOT NULL);
520 CREATE TABLE t3 (c1 TINYINT NOT NULL);
521 CREATE TABLE t4 (c1 TINYINT NOT NULL);
522 CREATE TABLE t5 (c1 TINYINT NOT NULL);
523 CREATE TABLE t6 (c1 TINYINT NOT NULL);
524 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
525 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
526 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
527 INSERT INTO t4 (c1) VALUES(10);
528 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
529 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 USING (c1);
541 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1;
553 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 < 5;
560 DROP TABLE t1,t2,t3,t4,t5,t6;
561 CREATE TABLE t1 (c1 SMALLINT NOT NULL);
562 CREATE TABLE t2 (c1 SMALLINT NOT NULL);
563 CREATE TABLE t3 (c1 SMALLINT NOT NULL);
564 CREATE TABLE t4 (c1 SMALLINT NOT NULL);
565 CREATE TABLE t5 (c1 SMALLINT NOT NULL);
566 CREATE TABLE t6 (c1 SMALLINT NOT NULL);
567 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
568 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
569 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
570 INSERT INTO t4 (c1) VALUES(10);
571 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
572 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 USING (c1);
584 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1;
596 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 < 5;
603 DROP TABLE t1,t2,t3,t4,t5,t6;
604 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
605 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
606 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
607 CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
608 CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
609 CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
610 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
611 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
612 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
613 INSERT INTO t4 (c1) VALUES(10);
614 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
615 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 USING (c1);
627 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1;
639 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 < 5;
646 DROP TABLE t1,t2,t3,t4,t5,t6;
647 CREATE TABLE t1 (c1 INT NOT NULL);
648 CREATE TABLE t2 (c1 INT NOT NULL);
649 CREATE TABLE t3 (c1 INT NOT NULL);
650 CREATE TABLE t4 (c1 INT NOT NULL);
651 CREATE TABLE t5 (c1 INT NOT NULL);
652 CREATE TABLE t6 (c1 INT NOT NULL);
653 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
654 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
655 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
656 INSERT INTO t4 (c1) VALUES(10);
657 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
658 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 USING (c1);
670 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1;
682 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 < 5;
689 DROP TABLE t1,t2,t3,t4,t5,t6;
690 CREATE TABLE t1 (c1 INTEGER NOT NULL);
691 CREATE TABLE t2 (c1 INTEGER NOT NULL);
692 CREATE TABLE t3 (c1 INTEGER NOT NULL);
693 CREATE TABLE t4 (c1 INTEGER NOT NULL);
694 CREATE TABLE t5 (c1 INTEGER NOT NULL);
695 CREATE TABLE t6 (c1 INTEGER NOT NULL);
696 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
697 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
698 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
699 INSERT INTO t4 (c1) VALUES(10);
700 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
701 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 USING (c1);
713 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1;
725 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 < 5;
732 DROP TABLE t1,t2,t3,t4,t5,t6;
733 CREATE TABLE t1 (c1 BIGINT NOT NULL);
734 CREATE TABLE t2 (c1 BIGINT NOT NULL);
735 CREATE TABLE t3 (c1 BIGINT NOT NULL);
736 CREATE TABLE t4 (c1 BIGINT NOT NULL);
737 CREATE TABLE t5 (c1 BIGINT NOT NULL);
738 CREATE TABLE t6 (c1 BIGINT NOT NULL);
739 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
740 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
741 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
742 INSERT INTO t4 (c1) VALUES(10);
743 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
744 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 USING (c1);
756 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1;
768 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 < 5;
775 DROP TABLE t1,t2,t3,t4,t5,t6;
776 CREATE TABLE t1 (c1 TINYINT NOT NULL);
777 CREATE TABLE t2 (c1 TINYINT NOT NULL);
778 CREATE TABLE t3 (c1 TINYINT NOT NULL);
779 CREATE TABLE t4 (c1 TINYINT NOT NULL);
780 CREATE TABLE t5 (c1 TINYINT NOT NULL);
781 CREATE TABLE t6 (c1 TINYINT NOT NULL);
782 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
783 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
784 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
785 INSERT INTO t4 (c1) VALUES(10);
786 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
787 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 USING (c1);
799 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1;
811 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 < 5;
818 DROP TABLE t1,t2,t3,t4,t5,t6;
819 CREATE TABLE t1 (c1 SMALLINT NOT NULL);
820 CREATE TABLE t2 (c1 SMALLINT NOT NULL);
821 CREATE TABLE t3 (c1 SMALLINT NOT NULL);
822 CREATE TABLE t4 (c1 SMALLINT NOT NULL);
823 CREATE TABLE t5 (c1 SMALLINT NOT NULL);
824 CREATE TABLE t6 (c1 SMALLINT NOT NULL);
825 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
826 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
827 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
828 INSERT INTO t4 (c1) VALUES(10);
829 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
830 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 USING (c1);
842 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1;
854 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 < 5;
861 DROP TABLE t1,t2,t3,t4,t5,t6;
862 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
863 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
864 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
865 CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
866 CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
867 CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
868 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
869 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
870 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
871 INSERT INTO t4 (c1) VALUES(10);
872 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
873 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 USING (c1);
885 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1;
897 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 < 5;
904 DROP TABLE t1,t2,t3,t4,t5,t6;
905 CREATE TABLE t1 (c1 INT NOT NULL);
906 CREATE TABLE t2 (c1 INT NOT NULL);
907 CREATE TABLE t3 (c1 INT NOT NULL);
908 CREATE TABLE t4 (c1 INT NOT NULL);
909 CREATE TABLE t5 (c1 INT NOT NULL);
910 CREATE TABLE t6 (c1 INT NOT NULL);
911 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
912 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
913 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
914 INSERT INTO t4 (c1) VALUES(10);
915 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
916 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 USING (c1);
928 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1;
940 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 < 5;
947 DROP TABLE t1,t2,t3,t4,t5,t6;
948 CREATE TABLE t1 (c1 INTEGER NOT NULL);
949 CREATE TABLE t2 (c1 INTEGER NOT NULL);
950 CREATE TABLE t3 (c1 INTEGER NOT NULL);
951 CREATE TABLE t4 (c1 INTEGER NOT NULL);
952 CREATE TABLE t5 (c1 INTEGER NOT NULL);
953 CREATE TABLE t6 (c1 INTEGER NOT NULL);
954 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
955 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
956 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
957 INSERT INTO t4 (c1) VALUES(10);
958 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
959 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 USING (c1);
971 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1;
983 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 < 5;
990 DROP TABLE t1,t2,t3,t4,t5,t6;
991 CREATE TABLE t1 (c1 BIGINT NOT NULL);
992 CREATE TABLE t2 (c1 BIGINT NOT NULL);
993 CREATE TABLE t3 (c1 BIGINT NOT NULL);
994 CREATE TABLE t4 (c1 BIGINT NOT NULL);
995 CREATE TABLE t5 (c1 BIGINT NOT NULL);
996 CREATE TABLE t6 (c1 BIGINT NOT NULL);
997 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
998 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
999 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1000 INSERT INTO t4 (c1) VALUES(10);
1001 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1002 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 USING (c1);
1014 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1;
1026 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 < 5;
1033 DROP TABLE t1,t2,t3,t4,t5,t6;
1034 CREATE TABLE t1 (c1 TINYINT NOT NULL);
1035 CREATE TABLE t2 (c1 TINYINT NOT NULL);
1036 CREATE TABLE t3 (c1 TINYINT NOT NULL);
1037 CREATE TABLE t4 (c1 TINYINT NOT NULL);
1038 CREATE TABLE t5 (c1 TINYINT NOT NULL);
1039 CREATE TABLE t6 (c1 TINYINT NOT NULL);
1040 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1041 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1042 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1043 INSERT INTO t4 (c1) VALUES(10);
1044 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1045 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 USING (c1);
1057 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1;
1069 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 < 5;
1076 DROP TABLE t1,t2,t3,t4,t5,t6;
1077 CREATE TABLE t1 (c1 SMALLINT NOT NULL);
1078 CREATE TABLE t2 (c1 SMALLINT NOT NULL);
1079 CREATE TABLE t3 (c1 SMALLINT NOT NULL);
1080 CREATE TABLE t4 (c1 SMALLINT NOT NULL);
1081 CREATE TABLE t5 (c1 SMALLINT NOT NULL);
1082 CREATE TABLE t6 (c1 SMALLINT NOT NULL);
1083 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1084 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1085 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1086 INSERT INTO t4 (c1) VALUES(10);
1087 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1088 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 USING (c1);
1100 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1;
1112 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 < 5;
1119 DROP TABLE t1,t2,t3,t4,t5,t6;
1120 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
1121 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
1122 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
1123 CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
1124 CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
1125 CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
1126 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1127 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1128 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1129 INSERT INTO t4 (c1) VALUES(10);
1130 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1131 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 USING (c1);
1143 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1;
1155 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 < 5;
1162 DROP TABLE t1,t2,t3,t4,t5,t6;
1163 CREATE TABLE t1 (c1 INT NOT NULL);
1164 CREATE TABLE t2 (c1 INT NOT NULL);
1165 CREATE TABLE t3 (c1 INT NOT NULL);
1166 CREATE TABLE t4 (c1 INT NOT NULL);
1167 CREATE TABLE t5 (c1 INT NOT NULL);
1168 CREATE TABLE t6 (c1 INT NOT NULL);
1169 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1170 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1171 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1172 INSERT INTO t4 (c1) VALUES(10);
1173 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1174 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 USING (c1);
1186 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1;
1198 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 < 5;
1205 DROP TABLE t1,t2,t3,t4,t5,t6;
1206 CREATE TABLE t1 (c1 INTEGER NOT NULL);
1207 CREATE TABLE t2 (c1 INTEGER NOT NULL);
1208 CREATE TABLE t3 (c1 INTEGER NOT NULL);
1209 CREATE TABLE t4 (c1 INTEGER NOT NULL);
1210 CREATE TABLE t5 (c1 INTEGER NOT NULL);
1211 CREATE TABLE t6 (c1 INTEGER NOT NULL);
1212 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1213 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1214 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1215 INSERT INTO t4 (c1) VALUES(10);
1216 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1217 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 USING (c1);
1229 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1;
1241 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 < 5;
1248 DROP TABLE t1,t2,t3,t4,t5,t6;
1249 CREATE TABLE t1 (c1 BIGINT NOT NULL);
1250 CREATE TABLE t2 (c1 BIGINT NOT NULL);
1251 CREATE TABLE t3 (c1 BIGINT NOT NULL);
1252 CREATE TABLE t4 (c1 BIGINT NOT NULL);
1253 CREATE TABLE t5 (c1 BIGINT NOT NULL);
1254 CREATE TABLE t6 (c1 BIGINT NOT NULL);
1255 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1256 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1257 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1258 INSERT INTO t4 (c1) VALUES(10);
1259 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1260 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 USING (c1);
1272 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1;
1284 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 < 5;
1291 DROP TABLE t1,t2,t3,t4,t5,t6;
1292 CREATE TABLE t1 (c1 TINYINT NOT NULL);
1293 CREATE TABLE t2 (c1 TINYINT NOT NULL);
1294 CREATE TABLE t3 (c1 TINYINT NOT NULL);
1295 CREATE TABLE t4 (c1 TINYINT NOT NULL);
1296 CREATE TABLE t5 (c1 TINYINT NOT NULL);
1297 CREATE TABLE t6 (c1 TINYINT NOT NULL);
1298 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1299 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1300 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1301 INSERT INTO t4 (c1) VALUES(10);
1302 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1303 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 USING (c1);
1315 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1;
1327 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 <= 5;
1335 DROP TABLE t1,t2,t3,t4,t5,t6;
1336 CREATE TABLE t1 (c1 SMALLINT NOT NULL);
1337 CREATE TABLE t2 (c1 SMALLINT NOT NULL);
1338 CREATE TABLE t3 (c1 SMALLINT NOT NULL);
1339 CREATE TABLE t4 (c1 SMALLINT NOT NULL);
1340 CREATE TABLE t5 (c1 SMALLINT NOT NULL);
1341 CREATE TABLE t6 (c1 SMALLINT NOT NULL);
1342 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1343 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1344 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1345 INSERT INTO t4 (c1) VALUES(10);
1346 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1347 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 USING (c1);
1359 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1;
1371 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 <= 5;
1379 DROP TABLE t1,t2,t3,t4,t5,t6;
1380 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
1381 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
1382 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
1383 CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
1384 CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
1385 CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
1386 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1387 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1388 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1389 INSERT INTO t4 (c1) VALUES(10);
1390 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1391 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 USING (c1);
1403 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1;
1415 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 <= 5;
1423 DROP TABLE t1,t2,t3,t4,t5,t6;
1424 CREATE TABLE t1 (c1 INT NOT NULL);
1425 CREATE TABLE t2 (c1 INT NOT NULL);
1426 CREATE TABLE t3 (c1 INT NOT NULL);
1427 CREATE TABLE t4 (c1 INT NOT NULL);
1428 CREATE TABLE t5 (c1 INT NOT NULL);
1429 CREATE TABLE t6 (c1 INT NOT NULL);
1430 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1431 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1432 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1433 INSERT INTO t4 (c1) VALUES(10);
1434 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1435 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 USING (c1);
1447 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1;
1459 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 <= 5;
1467 DROP TABLE t1,t2,t3,t4,t5,t6;
1468 CREATE TABLE t1 (c1 INTEGER NOT NULL);
1469 CREATE TABLE t2 (c1 INTEGER NOT NULL);
1470 CREATE TABLE t3 (c1 INTEGER NOT NULL);
1471 CREATE TABLE t4 (c1 INTEGER NOT NULL);
1472 CREATE TABLE t5 (c1 INTEGER NOT NULL);
1473 CREATE TABLE t6 (c1 INTEGER NOT NULL);
1474 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1475 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1476 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1477 INSERT INTO t4 (c1) VALUES(10);
1478 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1479 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 USING (c1);
1491 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1;
1503 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 <= 5;
1511 DROP TABLE t1,t2,t3,t4,t5,t6;
1512 CREATE TABLE t1 (c1 BIGINT NOT NULL);
1513 CREATE TABLE t2 (c1 BIGINT NOT NULL);
1514 CREATE TABLE t3 (c1 BIGINT NOT NULL);
1515 CREATE TABLE t4 (c1 BIGINT NOT NULL);
1516 CREATE TABLE t5 (c1 BIGINT NOT NULL);
1517 CREATE TABLE t6 (c1 BIGINT NOT NULL);
1518 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1519 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1520 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1521 INSERT INTO t4 (c1) VALUES(10);
1522 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1523 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 USING (c1);
1535 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1;
1547 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 <= 5;
1555 DROP TABLE t1,t2,t3,t4,t5,t6;
1556 CREATE TABLE t1 (c1 TINYINT NOT NULL);
1557 CREATE TABLE t2 (c1 TINYINT NOT NULL);
1558 CREATE TABLE t3 (c1 TINYINT NOT NULL);
1559 CREATE TABLE t4 (c1 TINYINT NOT NULL);
1560 CREATE TABLE t5 (c1 TINYINT NOT NULL);
1561 CREATE TABLE t6 (c1 TINYINT NOT NULL);
1562 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1563 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1564 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1565 INSERT INTO t4 (c1) VALUES(10);
1566 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1567 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 USING (c1);
1579 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1;
1591 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 <= 5;
1599 DROP TABLE t1,t2,t3,t4,t5,t6;
1600 CREATE TABLE t1 (c1 SMALLINT NOT NULL);
1601 CREATE TABLE t2 (c1 SMALLINT NOT NULL);
1602 CREATE TABLE t3 (c1 SMALLINT NOT NULL);
1603 CREATE TABLE t4 (c1 SMALLINT NOT NULL);
1604 CREATE TABLE t5 (c1 SMALLINT NOT NULL);
1605 CREATE TABLE t6 (c1 SMALLINT NOT NULL);
1606 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1607 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1608 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1609 INSERT INTO t4 (c1) VALUES(10);
1610 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1611 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 USING (c1);
1623 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1;
1635 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 <= 5;
1643 DROP TABLE t1,t2,t3,t4,t5,t6;
1644 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
1645 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
1646 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
1647 CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
1648 CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
1649 CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
1650 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1651 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1652 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1653 INSERT INTO t4 (c1) VALUES(10);
1654 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1655 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 USING (c1);
1667 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1;
1679 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 <= 5;
1687 DROP TABLE t1,t2,t3,t4,t5,t6;
1688 CREATE TABLE t1 (c1 INT NOT NULL);
1689 CREATE TABLE t2 (c1 INT NOT NULL);
1690 CREATE TABLE t3 (c1 INT NOT NULL);
1691 CREATE TABLE t4 (c1 INT NOT NULL);
1692 CREATE TABLE t5 (c1 INT NOT NULL);
1693 CREATE TABLE t6 (c1 INT NOT NULL);
1694 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1695 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1696 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1697 INSERT INTO t4 (c1) VALUES(10);
1698 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1699 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 USING (c1);
1711 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1;
1723 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 <= 5;
1731 DROP TABLE t1,t2,t3,t4,t5,t6;
1732 CREATE TABLE t1 (c1 INTEGER NOT NULL);
1733 CREATE TABLE t2 (c1 INTEGER NOT NULL);
1734 CREATE TABLE t3 (c1 INTEGER NOT NULL);
1735 CREATE TABLE t4 (c1 INTEGER NOT NULL);
1736 CREATE TABLE t5 (c1 INTEGER NOT NULL);
1737 CREATE TABLE t6 (c1 INTEGER NOT NULL);
1738 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1739 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1740 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1741 INSERT INTO t4 (c1) VALUES(10);
1742 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1743 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 USING (c1);
1755 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1;
1767 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 <= 5;
1775 DROP TABLE t1,t2,t3,t4,t5,t6;
1776 CREATE TABLE t1 (c1 BIGINT NOT NULL);
1777 CREATE TABLE t2 (c1 BIGINT NOT NULL);
1778 CREATE TABLE t3 (c1 BIGINT NOT NULL);
1779 CREATE TABLE t4 (c1 BIGINT NOT NULL);
1780 CREATE TABLE t5 (c1 BIGINT NOT NULL);
1781 CREATE TABLE t6 (c1 BIGINT NOT NULL);
1782 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1783 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1784 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1785 INSERT INTO t4 (c1) VALUES(10);
1786 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1787 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 USING (c1);
1799 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1;
1811 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 <= 5;
1819 DROP TABLE t1,t2,t3,t4,t5,t6;
1820 CREATE TABLE t1 (c1 TINYINT NOT NULL);
1821 CREATE TABLE t2 (c1 TINYINT NOT NULL);
1822 CREATE TABLE t3 (c1 TINYINT NOT NULL);
1823 CREATE TABLE t4 (c1 TINYINT NOT NULL);
1824 CREATE TABLE t5 (c1 TINYINT NOT NULL);
1825 CREATE TABLE t6 (c1 TINYINT NOT NULL);
1826 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1827 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1828 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1829 INSERT INTO t4 (c1) VALUES(10);
1830 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1831 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 USING (c1);
1843 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1;
1855 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 <= 5;
1863 DROP TABLE t1,t2,t3,t4,t5,t6;
1864 CREATE TABLE t1 (c1 SMALLINT NOT NULL);
1865 CREATE TABLE t2 (c1 SMALLINT NOT NULL);
1866 CREATE TABLE t3 (c1 SMALLINT NOT NULL);
1867 CREATE TABLE t4 (c1 SMALLINT NOT NULL);
1868 CREATE TABLE t5 (c1 SMALLINT NOT NULL);
1869 CREATE TABLE t6 (c1 SMALLINT NOT NULL);
1870 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1871 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1872 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1873 INSERT INTO t4 (c1) VALUES(10);
1874 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1875 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 USING (c1);
1887 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1;
1899 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 <= 5;
1907 DROP TABLE t1,t2,t3,t4,t5,t6;
1908 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
1909 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
1910 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
1911 CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
1912 CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
1913 CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
1914 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1915 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1916 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1917 INSERT INTO t4 (c1) VALUES(10);
1918 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1919 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 USING (c1);
1931 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1;
1943 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 <= 5;
1951 DROP TABLE t1,t2,t3,t4,t5,t6;
1952 CREATE TABLE t1 (c1 INT NOT NULL);
1953 CREATE TABLE t2 (c1 INT NOT NULL);
1954 CREATE TABLE t3 (c1 INT NOT NULL);
1955 CREATE TABLE t4 (c1 INT NOT NULL);
1956 CREATE TABLE t5 (c1 INT NOT NULL);
1957 CREATE TABLE t6 (c1 INT NOT NULL);
1958 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1959 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1960 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1961 INSERT INTO t4 (c1) VALUES(10);
1962 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1963 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 USING (c1);
1975 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1;
1987 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 <= 5;
1995 DROP TABLE t1,t2,t3,t4,t5,t6;
1996 CREATE TABLE t1 (c1 INTEGER NOT NULL);
1997 CREATE TABLE t2 (c1 INTEGER NOT NULL);
1998 CREATE TABLE t3 (c1 INTEGER NOT NULL);
1999 CREATE TABLE t4 (c1 INTEGER NOT NULL);
2000 CREATE TABLE t5 (c1 INTEGER NOT NULL);
2001 CREATE TABLE t6 (c1 INTEGER NOT NULL);
2002 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2003 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2004 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2005 INSERT INTO t4 (c1) VALUES(10);
2006 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2007 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 USING (c1);
2019 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1;
2031 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 <= 5;
2039 DROP TABLE t1,t2,t3,t4,t5,t6;
2040 CREATE TABLE t1 (c1 BIGINT NOT NULL);
2041 CREATE TABLE t2 (c1 BIGINT NOT NULL);
2042 CREATE TABLE t3 (c1 BIGINT NOT NULL);
2043 CREATE TABLE t4 (c1 BIGINT NOT NULL);
2044 CREATE TABLE t5 (c1 BIGINT NOT NULL);
2045 CREATE TABLE t6 (c1 BIGINT NOT NULL);
2046 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2047 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2048 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2049 INSERT INTO t4 (c1) VALUES(10);
2050 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2051 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 USING (c1);
2063 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1;
2075 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 <= 5;
2083 DROP TABLE t1,t2,t3,t4,t5,t6;
2084 CREATE TABLE t1 (c1 TINYINT NOT NULL);
2085 CREATE TABLE t2 (c1 TINYINT NOT NULL);
2086 CREATE TABLE t3 (c1 TINYINT NOT NULL);
2087 CREATE TABLE t4 (c1 TINYINT NOT NULL);
2088 CREATE TABLE t5 (c1 TINYINT NOT NULL);
2089 CREATE TABLE t6 (c1 TINYINT NOT NULL);
2090 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2091 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2092 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2093 INSERT INTO t4 (c1) VALUES(10);
2094 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2095 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 USING (c1);
2107 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1;
2119 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 <= 5;
2127 DROP TABLE t1,t2,t3,t4,t5,t6;
2128 CREATE TABLE t1 (c1 SMALLINT NOT NULL);
2129 CREATE TABLE t2 (c1 SMALLINT NOT NULL);
2130 CREATE TABLE t3 (c1 SMALLINT NOT NULL);
2131 CREATE TABLE t4 (c1 SMALLINT NOT NULL);
2132 CREATE TABLE t5 (c1 SMALLINT NOT NULL);
2133 CREATE TABLE t6 (c1 SMALLINT NOT NULL);
2134 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2135 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2136 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2137 INSERT INTO t4 (c1) VALUES(10);
2138 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2139 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 USING (c1);
2151 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1;
2163 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 <= 5;
2171 DROP TABLE t1,t2,t3,t4,t5,t6;
2172 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
2173 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
2174 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
2175 CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
2176 CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
2177 CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
2178 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2179 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2180 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2181 INSERT INTO t4 (c1) VALUES(10);
2182 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2183 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 USING (c1);
2195 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1;
2207 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 <= 5;
2215 DROP TABLE t1,t2,t3,t4,t5,t6;
2216 CREATE TABLE t1 (c1 INT NOT NULL);
2217 CREATE TABLE t2 (c1 INT NOT NULL);
2218 CREATE TABLE t3 (c1 INT NOT NULL);
2219 CREATE TABLE t4 (c1 INT NOT NULL);
2220 CREATE TABLE t5 (c1 INT NOT NULL);
2221 CREATE TABLE t6 (c1 INT NOT NULL);
2222 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2223 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2224 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2225 INSERT INTO t4 (c1) VALUES(10);
2226 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2227 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 USING (c1);
2239 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1;
2251 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 <= 5;
2259 DROP TABLE t1,t2,t3,t4,t5,t6;
2260 CREATE TABLE t1 (c1 INTEGER NOT NULL);
2261 CREATE TABLE t2 (c1 INTEGER NOT NULL);
2262 CREATE TABLE t3 (c1 INTEGER NOT NULL);
2263 CREATE TABLE t4 (c1 INTEGER NOT NULL);
2264 CREATE TABLE t5 (c1 INTEGER NOT NULL);
2265 CREATE TABLE t6 (c1 INTEGER NOT NULL);
2266 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2267 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2268 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2269 INSERT INTO t4 (c1) VALUES(10);
2270 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2271 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 USING (c1);
2283 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1;
2295 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 <= 5;
2303 DROP TABLE t1,t2,t3,t4,t5,t6;
2304 CREATE TABLE t1 (c1 BIGINT NOT NULL);
2305 CREATE TABLE t2 (c1 BIGINT NOT NULL);
2306 CREATE TABLE t3 (c1 BIGINT NOT NULL);
2307 CREATE TABLE t4 (c1 BIGINT NOT NULL);
2308 CREATE TABLE t5 (c1 BIGINT NOT NULL);
2309 CREATE TABLE t6 (c1 BIGINT NOT NULL);
2310 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2311 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2312 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2313 INSERT INTO t4 (c1) VALUES(10);
2314 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2315 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 USING (c1);
2327 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1;
2339 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 <= 5;
2347 DROP TABLE t1,t2,t3,t4,t5,t6;
2348 CREATE TABLE t1 (c1 TINYINT NOT NULL);
2349 CREATE TABLE t2 (c1 TINYINT NOT NULL);
2350 CREATE TABLE t3 (c1 TINYINT NOT NULL);
2351 CREATE TABLE t4 (c1 TINYINT NOT NULL);
2352 CREATE TABLE t5 (c1 TINYINT NOT NULL);
2353 CREATE TABLE t6 (c1 TINYINT NOT NULL);
2354 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2355 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2356 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2357 INSERT INTO t4 (c1) VALUES(10);
2358 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2359 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 USING (c1);
2371 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1;
2383 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 <= 5;
2391 DROP TABLE t1,t2,t3,t4,t5,t6;
2392 CREATE TABLE t1 (c1 SMALLINT NOT NULL);
2393 CREATE TABLE t2 (c1 SMALLINT NOT NULL);
2394 CREATE TABLE t3 (c1 SMALLINT NOT NULL);
2395 CREATE TABLE t4 (c1 SMALLINT NOT NULL);
2396 CREATE TABLE t5 (c1 SMALLINT NOT NULL);
2397 CREATE TABLE t6 (c1 SMALLINT NOT NULL);
2398 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2399 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2400 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2401 INSERT INTO t4 (c1) VALUES(10);
2402 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2403 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 USING (c1);
2415 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1;
2427 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 <= 5;
2435 DROP TABLE t1,t2,t3,t4,t5,t6;
2436 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
2437 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
2438 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
2439 CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
2440 CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
2441 CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
2442 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2443 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2444 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2445 INSERT INTO t4 (c1) VALUES(10);
2446 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2447 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 USING (c1);
2459 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1;
2471 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 <= 5;
2479 DROP TABLE t1,t2,t3,t4,t5,t6;
2480 CREATE TABLE t1 (c1 INT NOT NULL);
2481 CREATE TABLE t2 (c1 INT NOT NULL);
2482 CREATE TABLE t3 (c1 INT NOT NULL);
2483 CREATE TABLE t4 (c1 INT NOT NULL);
2484 CREATE TABLE t5 (c1 INT NOT NULL);
2485 CREATE TABLE t6 (c1 INT NOT NULL);
2486 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2487 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2488 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2489 INSERT INTO t4 (c1) VALUES(10);
2490 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2491 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 USING (c1);
2503 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1;
2515 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 <= 5;
2523 DROP TABLE t1,t2,t3,t4,t5,t6;
2524 CREATE TABLE t1 (c1 INTEGER NOT NULL);
2525 CREATE TABLE t2 (c1 INTEGER NOT NULL);
2526 CREATE TABLE t3 (c1 INTEGER NOT NULL);
2527 CREATE TABLE t4 (c1 INTEGER NOT NULL);
2528 CREATE TABLE t5 (c1 INTEGER NOT NULL);
2529 CREATE TABLE t6 (c1 INTEGER NOT NULL);
2530 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2531 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2532 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2533 INSERT INTO t4 (c1) VALUES(10);
2534 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2535 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 USING (c1);
2547 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1;
2559 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 <= 5;
2567 DROP TABLE t1,t2,t3,t4,t5,t6;
2568 CREATE TABLE t1 (c1 BIGINT NOT NULL);
2569 CREATE TABLE t2 (c1 BIGINT NOT NULL);
2570 CREATE TABLE t3 (c1 BIGINT NOT NULL);
2571 CREATE TABLE t4 (c1 BIGINT NOT NULL);
2572 CREATE TABLE t5 (c1 BIGINT NOT NULL);
2573 CREATE TABLE t6 (c1 BIGINT NOT NULL);
2574 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2575 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2576 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2577 INSERT INTO t4 (c1) VALUES(10);
2578 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2579 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 USING (c1);
2591 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1;
2603 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 <= 5;
2611 DROP TABLE t1,t2,t3,t4,t5,t6;
2612 CREATE TABLE t1 (c1 TINYINT NOT NULL);
2613 CREATE TABLE t2 (c1 TINYINT NOT NULL);
2614 CREATE TABLE t3 (c1 TINYINT NOT NULL);
2615 CREATE TABLE t4 (c1 TINYINT NOT NULL);
2616 CREATE TABLE t5 (c1 TINYINT NOT NULL);
2617 CREATE TABLE t6 (c1 TINYINT NOT NULL);
2618 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2619 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2620 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2621 INSERT INTO t4 (c1) VALUES(10);
2622 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2623 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 USING (c1);
2635 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1;
2647 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 = 5;
2650 DROP TABLE t1,t2,t3,t4,t5,t6;
2651 CREATE TABLE t1 (c1 SMALLINT NOT NULL);
2652 CREATE TABLE t2 (c1 SMALLINT NOT NULL);
2653 CREATE TABLE t3 (c1 SMALLINT NOT NULL);
2654 CREATE TABLE t4 (c1 SMALLINT NOT NULL);
2655 CREATE TABLE t5 (c1 SMALLINT NOT NULL);
2656 CREATE TABLE t6 (c1 SMALLINT NOT NULL);
2657 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2658 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2659 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2660 INSERT INTO t4 (c1) VALUES(10);
2661 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2662 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 USING (c1);
2674 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1;
2686 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 = 5;
2689 DROP TABLE t1,t2,t3,t4,t5,t6;
2690 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
2691 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
2692 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
2693 CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
2694 CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
2695 CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
2696 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2697 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2698 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2699 INSERT INTO t4 (c1) VALUES(10);
2700 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2701 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 USING (c1);
2713 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1;
2725 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 = 5;
2728 DROP TABLE t1,t2,t3,t4,t5,t6;
2729 CREATE TABLE t1 (c1 INT NOT NULL);
2730 CREATE TABLE t2 (c1 INT NOT NULL);
2731 CREATE TABLE t3 (c1 INT NOT NULL);
2732 CREATE TABLE t4 (c1 INT NOT NULL);
2733 CREATE TABLE t5 (c1 INT NOT NULL);
2734 CREATE TABLE t6 (c1 INT NOT NULL);
2735 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2736 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2737 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2738 INSERT INTO t4 (c1) VALUES(10);
2739 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2740 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 USING (c1);
2752 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1;
2764 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 = 5;
2767 DROP TABLE t1,t2,t3,t4,t5,t6;
2768 CREATE TABLE t1 (c1 INTEGER NOT NULL);
2769 CREATE TABLE t2 (c1 INTEGER NOT NULL);
2770 CREATE TABLE t3 (c1 INTEGER NOT NULL);
2771 CREATE TABLE t4 (c1 INTEGER NOT NULL);
2772 CREATE TABLE t5 (c1 INTEGER NOT NULL);
2773 CREATE TABLE t6 (c1 INTEGER NOT NULL);
2774 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2775 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2776 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2777 INSERT INTO t4 (c1) VALUES(10);
2778 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2779 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 USING (c1);
2791 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1;
2803 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 = 5;
2806 DROP TABLE t1,t2,t3,t4,t5,t6;
2807 CREATE TABLE t1 (c1 BIGINT NOT NULL);
2808 CREATE TABLE t2 (c1 BIGINT NOT NULL);
2809 CREATE TABLE t3 (c1 BIGINT NOT NULL);
2810 CREATE TABLE t4 (c1 BIGINT NOT NULL);
2811 CREATE TABLE t5 (c1 BIGINT NOT NULL);
2812 CREATE TABLE t6 (c1 BIGINT NOT NULL);
2813 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2814 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2815 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2816 INSERT INTO t4 (c1) VALUES(10);
2817 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2818 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 USING (c1);
2830 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1;
2842 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 = 5;
2845 DROP TABLE t1,t2,t3,t4,t5,t6;
2846 CREATE TABLE t1 (c1 TINYINT NOT NULL);
2847 CREATE TABLE t2 (c1 TINYINT NOT NULL);
2848 CREATE TABLE t3 (c1 TINYINT NOT NULL);
2849 CREATE TABLE t4 (c1 TINYINT NOT NULL);
2850 CREATE TABLE t5 (c1 TINYINT NOT NULL);
2851 CREATE TABLE t6 (c1 TINYINT NOT NULL);
2852 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2853 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2854 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2855 INSERT INTO t4 (c1) VALUES(10);
2856 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2857 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 USING (c1);
2869 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1;
2881 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 = 5;
2884 DROP TABLE t1,t2,t3,t4,t5,t6;
2885 CREATE TABLE t1 (c1 SMALLINT NOT NULL);
2886 CREATE TABLE t2 (c1 SMALLINT NOT NULL);
2887 CREATE TABLE t3 (c1 SMALLINT NOT NULL);
2888 CREATE TABLE t4 (c1 SMALLINT NOT NULL);
2889 CREATE TABLE t5 (c1 SMALLINT NOT NULL);
2890 CREATE TABLE t6 (c1 SMALLINT NOT NULL);
2891 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2892 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2893 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2894 INSERT INTO t4 (c1) VALUES(10);
2895 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2896 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 USING (c1);
2908 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1;
2920 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 = 5;
2923 DROP TABLE t1,t2,t3,t4,t5,t6;
2924 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
2925 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
2926 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
2927 CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
2928 CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
2929 CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
2930 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2931 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2932 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2933 INSERT INTO t4 (c1) VALUES(10);
2934 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2935 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 USING (c1);
2947 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1;
2959 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 = 5;
2962 DROP TABLE t1,t2,t3,t4,t5,t6;
2963 CREATE TABLE t1 (c1 INT NOT NULL);
2964 CREATE TABLE t2 (c1 INT NOT NULL);
2965 CREATE TABLE t3 (c1 INT NOT NULL);
2966 CREATE TABLE t4 (c1 INT NOT NULL);
2967 CREATE TABLE t5 (c1 INT NOT NULL);
2968 CREATE TABLE t6 (c1 INT NOT NULL);
2969 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2970 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2971 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2972 INSERT INTO t4 (c1) VALUES(10);
2973 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2974 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 USING (c1);
2986 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1;
2998 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 = 5;
3001 DROP TABLE t1,t2,t3,t4,t5,t6;
3002 CREATE TABLE t1 (c1 INTEGER NOT NULL);
3003 CREATE TABLE t2 (c1 INTEGER NOT NULL);
3004 CREATE TABLE t3 (c1 INTEGER NOT NULL);
3005 CREATE TABLE t4 (c1 INTEGER NOT NULL);
3006 CREATE TABLE t5 (c1 INTEGER NOT NULL);
3007 CREATE TABLE t6 (c1 INTEGER NOT NULL);
3008 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3009 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3010 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3011 INSERT INTO t4 (c1) VALUES(10);
3012 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3013 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 USING (c1);
3025 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1;
3037 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 = 5;
3040 DROP TABLE t1,t2,t3,t4,t5,t6;
3041 CREATE TABLE t1 (c1 BIGINT NOT NULL);
3042 CREATE TABLE t2 (c1 BIGINT NOT NULL);
3043 CREATE TABLE t3 (c1 BIGINT NOT NULL);
3044 CREATE TABLE t4 (c1 BIGINT NOT NULL);
3045 CREATE TABLE t5 (c1 BIGINT NOT NULL);
3046 CREATE TABLE t6 (c1 BIGINT NOT NULL);
3047 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3048 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3049 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3050 INSERT INTO t4 (c1) VALUES(10);
3051 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3052 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 USING (c1);
3064 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1;
3076 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 = 5;
3079 DROP TABLE t1,t2,t3,t4,t5,t6;
3080 CREATE TABLE t1 (c1 TINYINT NOT NULL);
3081 CREATE TABLE t2 (c1 TINYINT NOT NULL);
3082 CREATE TABLE t3 (c1 TINYINT NOT NULL);
3083 CREATE TABLE t4 (c1 TINYINT NOT NULL);
3084 CREATE TABLE t5 (c1 TINYINT NOT NULL);
3085 CREATE TABLE t6 (c1 TINYINT NOT NULL);
3086 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3087 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3088 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3089 INSERT INTO t4 (c1) VALUES(10);
3090 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3091 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 USING (c1);
3103 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1;
3115 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 = 5;
3118 DROP TABLE t1,t2,t3,t4,t5,t6;
3119 CREATE TABLE t1 (c1 SMALLINT NOT NULL);
3120 CREATE TABLE t2 (c1 SMALLINT NOT NULL);
3121 CREATE TABLE t3 (c1 SMALLINT NOT NULL);
3122 CREATE TABLE t4 (c1 SMALLINT NOT NULL);
3123 CREATE TABLE t5 (c1 SMALLINT NOT NULL);
3124 CREATE TABLE t6 (c1 SMALLINT NOT NULL);
3125 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3126 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3127 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3128 INSERT INTO t4 (c1) VALUES(10);
3129 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3130 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 USING (c1);
3142 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1;
3154 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 = 5;
3157 DROP TABLE t1,t2,t3,t4,t5,t6;
3158 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
3159 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
3160 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
3161 CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
3162 CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
3163 CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
3164 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3165 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3166 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3167 INSERT INTO t4 (c1) VALUES(10);
3168 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3169 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 USING (c1);
3181 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1;
3193 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 = 5;
3196 DROP TABLE t1,t2,t3,t4,t5,t6;
3197 CREATE TABLE t1 (c1 INT NOT NULL);
3198 CREATE TABLE t2 (c1 INT NOT NULL);
3199 CREATE TABLE t3 (c1 INT NOT NULL);
3200 CREATE TABLE t4 (c1 INT NOT NULL);
3201 CREATE TABLE t5 (c1 INT NOT NULL);
3202 CREATE TABLE t6 (c1 INT NOT NULL);
3203 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3204 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3205 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3206 INSERT INTO t4 (c1) VALUES(10);
3207 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3208 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 USING (c1);
3220 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1;
3232 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 = 5;
3235 DROP TABLE t1,t2,t3,t4,t5,t6;
3236 CREATE TABLE t1 (c1 INTEGER NOT NULL);
3237 CREATE TABLE t2 (c1 INTEGER NOT NULL);
3238 CREATE TABLE t3 (c1 INTEGER NOT NULL);
3239 CREATE TABLE t4 (c1 INTEGER NOT NULL);
3240 CREATE TABLE t5 (c1 INTEGER NOT NULL);
3241 CREATE TABLE t6 (c1 INTEGER NOT NULL);
3242 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3243 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3244 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3245 INSERT INTO t4 (c1) VALUES(10);
3246 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3247 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 USING (c1);
3259 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1;
3271 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 = 5;
3274 DROP TABLE t1,t2,t3,t4,t5,t6;
3275 CREATE TABLE t1 (c1 BIGINT NOT NULL);
3276 CREATE TABLE t2 (c1 BIGINT NOT NULL);
3277 CREATE TABLE t3 (c1 BIGINT NOT NULL);
3278 CREATE TABLE t4 (c1 BIGINT NOT NULL);
3279 CREATE TABLE t5 (c1 BIGINT NOT NULL);
3280 CREATE TABLE t6 (c1 BIGINT NOT NULL);
3281 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3282 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3283 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3284 INSERT INTO t4 (c1) VALUES(10);
3285 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3286 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 USING (c1);
3298 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1;
3310 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 = 5;
3313 DROP TABLE t1,t2,t3,t4,t5,t6;
3314 CREATE TABLE t1 (c1 TINYINT NOT NULL);
3315 CREATE TABLE t2 (c1 TINYINT NOT NULL);
3316 CREATE TABLE t3 (c1 TINYINT NOT NULL);
3317 CREATE TABLE t4 (c1 TINYINT NOT NULL);
3318 CREATE TABLE t5 (c1 TINYINT NOT NULL);
3319 CREATE TABLE t6 (c1 TINYINT NOT NULL);
3320 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3321 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3322 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3323 INSERT INTO t4 (c1) VALUES(10);
3324 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3325 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 USING (c1);
3337 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1;
3349 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 = 5;
3352 DROP TABLE t1,t2,t3,t4,t5,t6;
3353 CREATE TABLE t1 (c1 SMALLINT NOT NULL);
3354 CREATE TABLE t2 (c1 SMALLINT NOT NULL);
3355 CREATE TABLE t3 (c1 SMALLINT NOT NULL);
3356 CREATE TABLE t4 (c1 SMALLINT NOT NULL);
3357 CREATE TABLE t5 (c1 SMALLINT NOT NULL);
3358 CREATE TABLE t6 (c1 SMALLINT NOT NULL);
3359 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3360 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3361 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3362 INSERT INTO t4 (c1) VALUES(10);
3363 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3364 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 USING (c1);
3376 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1;
3388 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 = 5;
3391 DROP TABLE t1,t2,t3,t4,t5,t6;
3392 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
3393 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
3394 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
3395 CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
3396 CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
3397 CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
3398 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3399 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3400 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3401 INSERT INTO t4 (c1) VALUES(10);
3402 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3403 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 USING (c1);
3415 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1;
3427 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 = 5;
3430 DROP TABLE t1,t2,t3,t4,t5,t6;
3431 CREATE TABLE t1 (c1 INT NOT NULL);
3432 CREATE TABLE t2 (c1 INT NOT NULL);
3433 CREATE TABLE t3 (c1 INT NOT NULL);
3434 CREATE TABLE t4 (c1 INT NOT NULL);
3435 CREATE TABLE t5 (c1 INT NOT NULL);
3436 CREATE TABLE t6 (c1 INT NOT NULL);
3437 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3438 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3439 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3440 INSERT INTO t4 (c1) VALUES(10);
3441 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3442 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 USING (c1);
3454 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1;
3466 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 = 5;
3469 DROP TABLE t1,t2,t3,t4,t5,t6;
3470 CREATE TABLE t1 (c1 INTEGER NOT NULL);
3471 CREATE TABLE t2 (c1 INTEGER NOT NULL);
3472 CREATE TABLE t3 (c1 INTEGER NOT NULL);
3473 CREATE TABLE t4 (c1 INTEGER NOT NULL);
3474 CREATE TABLE t5 (c1 INTEGER NOT NULL);
3475 CREATE TABLE t6 (c1 INTEGER NOT NULL);
3476 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3477 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3478 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3479 INSERT INTO t4 (c1) VALUES(10);
3480 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3481 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 USING (c1);
3493 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1;
3505 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 = 5;
3508 DROP TABLE t1,t2,t3,t4,t5,t6;
3509 CREATE TABLE t1 (c1 BIGINT NOT NULL);
3510 CREATE TABLE t2 (c1 BIGINT NOT NULL);
3511 CREATE TABLE t3 (c1 BIGINT NOT NULL);
3512 CREATE TABLE t4 (c1 BIGINT NOT NULL);
3513 CREATE TABLE t5 (c1 BIGINT NOT NULL);
3514 CREATE TABLE t6 (c1 BIGINT NOT NULL);
3515 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3516 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3517 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3518 INSERT INTO t4 (c1) VALUES(10);
3519 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3520 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 USING (c1);
3532 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1;
3544 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 = 5;
3547 DROP TABLE t1,t2,t3,t4,t5,t6;
3548 CREATE TABLE t1 (c1 TINYINT NOT NULL);
3549 CREATE TABLE t2 (c1 TINYINT NOT NULL);
3550 CREATE TABLE t3 (c1 TINYINT NOT NULL);
3551 CREATE TABLE t4 (c1 TINYINT NOT NULL);
3552 CREATE TABLE t5 (c1 TINYINT NOT NULL);
3553 CREATE TABLE t6 (c1 TINYINT NOT NULL);
3554 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3555 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3556 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3557 INSERT INTO t4 (c1) VALUES(10);
3558 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3559 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 USING (c1);
3571 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1;
3583 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 = 5;
3586 DROP TABLE t1,t2,t3,t4,t5,t6;
3587 CREATE TABLE t1 (c1 SMALLINT NOT NULL);
3588 CREATE TABLE t2 (c1 SMALLINT NOT NULL);
3589 CREATE TABLE t3 (c1 SMALLINT NOT NULL);
3590 CREATE TABLE t4 (c1 SMALLINT NOT NULL);
3591 CREATE TABLE t5 (c1 SMALLINT NOT NULL);
3592 CREATE TABLE t6 (c1 SMALLINT NOT NULL);
3593 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3594 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3595 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3596 INSERT INTO t4 (c1) VALUES(10);
3597 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3598 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 USING (c1);
3610 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1;
3622 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 = 5;
3625 DROP TABLE t1,t2,t3,t4,t5,t6;
3626 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
3627 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
3628 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
3629 CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
3630 CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
3631 CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
3632 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3633 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3634 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3635 INSERT INTO t4 (c1) VALUES(10);
3636 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3637 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 USING (c1);
3649 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1;
3661 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 = 5;
3664 DROP TABLE t1,t2,t3,t4,t5,t6;
3665 CREATE TABLE t1 (c1 INT NOT NULL);
3666 CREATE TABLE t2 (c1 INT NOT NULL);
3667 CREATE TABLE t3 (c1 INT NOT NULL);
3668 CREATE TABLE t4 (c1 INT NOT NULL);
3669 CREATE TABLE t5 (c1 INT NOT NULL);
3670 CREATE TABLE t6 (c1 INT NOT NULL);
3671 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3672 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3673 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3674 INSERT INTO t4 (c1) VALUES(10);
3675 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3676 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 USING (c1);
3688 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1;
3700 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 = 5;
3703 DROP TABLE t1,t2,t3,t4,t5,t6;
3704 CREATE TABLE t1 (c1 INTEGER NOT NULL);
3705 CREATE TABLE t2 (c1 INTEGER NOT NULL);
3706 CREATE TABLE t3 (c1 INTEGER NOT NULL);
3707 CREATE TABLE t4 (c1 INTEGER NOT NULL);
3708 CREATE TABLE t5 (c1 INTEGER NOT NULL);
3709 CREATE TABLE t6 (c1 INTEGER NOT NULL);
3710 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3711 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3712 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3713 INSERT INTO t4 (c1) VALUES(10);
3714 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3715 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 USING (c1);
3727 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1;
3739 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 = 5;
3742 DROP TABLE t1,t2,t3,t4,t5,t6;
3743 CREATE TABLE t1 (c1 BIGINT NOT NULL);
3744 CREATE TABLE t2 (c1 BIGINT NOT NULL);
3745 CREATE TABLE t3 (c1 BIGINT NOT NULL);
3746 CREATE TABLE t4 (c1 BIGINT NOT NULL);
3747 CREATE TABLE t5 (c1 BIGINT NOT NULL);
3748 CREATE TABLE t6 (c1 BIGINT NOT NULL);
3749 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3750 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3751 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3752 INSERT INTO t4 (c1) VALUES(10);
3753 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3754 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 USING (c1);
3766 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1;
3778 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 = 5;
3781 DROP TABLE t1,t2,t3,t4,t5,t6;
3782 CREATE TABLE t1 (c1 TINYINT NOT NULL);
3783 CREATE TABLE t2 (c1 TINYINT NOT NULL);
3784 CREATE TABLE t3 (c1 TINYINT NOT NULL);
3785 CREATE TABLE t4 (c1 TINYINT NOT NULL);
3786 CREATE TABLE t5 (c1 TINYINT NOT NULL);
3787 CREATE TABLE t6 (c1 TINYINT NOT NULL);
3788 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3789 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3790 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3791 INSERT INTO t4 (c1) VALUES(10);
3792 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3793 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 USING (c1);
3805 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1;
3817 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 >= 5;
3824 DROP TABLE t1,t2,t3,t4,t5,t6;
3825 CREATE TABLE t1 (c1 SMALLINT NOT NULL);
3826 CREATE TABLE t2 (c1 SMALLINT NOT NULL);
3827 CREATE TABLE t3 (c1 SMALLINT NOT NULL);
3828 CREATE TABLE t4 (c1 SMALLINT NOT NULL);
3829 CREATE TABLE t5 (c1 SMALLINT NOT NULL);
3830 CREATE TABLE t6 (c1 SMALLINT NOT NULL);
3831 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3832 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3833 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3834 INSERT INTO t4 (c1) VALUES(10);
3835 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3836 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 USING (c1);
3848 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1;
3860 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 >= 5;
3867 DROP TABLE t1,t2,t3,t4,t5,t6;
3868 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
3869 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
3870 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
3871 CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
3872 CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
3873 CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
3874 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3875 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3876 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3877 INSERT INTO t4 (c1) VALUES(10);
3878 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3879 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 USING (c1);
3891 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1;
3903 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 >= 5;
3910 DROP TABLE t1,t2,t3,t4,t5,t6;
3911 CREATE TABLE t1 (c1 INT NOT NULL);
3912 CREATE TABLE t2 (c1 INT NOT NULL);
3913 CREATE TABLE t3 (c1 INT NOT NULL);
3914 CREATE TABLE t4 (c1 INT NOT NULL);
3915 CREATE TABLE t5 (c1 INT NOT NULL);
3916 CREATE TABLE t6 (c1 INT NOT NULL);
3917 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3918 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3919 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3920 INSERT INTO t4 (c1) VALUES(10);
3921 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3922 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 USING (c1);
3934 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1;
3946 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 >= 5;
3953 DROP TABLE t1,t2,t3,t4,t5,t6;
3954 CREATE TABLE t1 (c1 INTEGER NOT NULL);
3955 CREATE TABLE t2 (c1 INTEGER NOT NULL);
3956 CREATE TABLE t3 (c1 INTEGER NOT NULL);
3957 CREATE TABLE t4 (c1 INTEGER NOT NULL);
3958 CREATE TABLE t5 (c1 INTEGER NOT NULL);
3959 CREATE TABLE t6 (c1 INTEGER NOT NULL);
3960 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3961 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3962 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3963 INSERT INTO t4 (c1) VALUES(10);
3964 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3965 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 USING (c1);
3977 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1;
3989 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 >= 5;
3996 DROP TABLE t1,t2,t3,t4,t5,t6;
3997 CREATE TABLE t1 (c1 BIGINT NOT NULL);
3998 CREATE TABLE t2 (c1 BIGINT NOT NULL);
3999 CREATE TABLE t3 (c1 BIGINT NOT NULL);
4000 CREATE TABLE t4 (c1 BIGINT NOT NULL);
4001 CREATE TABLE t5 (c1 BIGINT NOT NULL);
4002 CREATE TABLE t6 (c1 BIGINT NOT NULL);
4003 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4004 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4005 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
4006 INSERT INTO t4 (c1) VALUES(10);
4007 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
4008 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 USING (c1);
4020 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1;
4032 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 >= 5;
4039 DROP TABLE t1,t2,t3,t4,t5,t6;
4040 CREATE TABLE t1 (c1 TINYINT NOT NULL);
4041 CREATE TABLE t2 (c1 TINYINT NOT NULL);
4042 CREATE TABLE t3 (c1 TINYINT NOT NULL);
4043 CREATE TABLE t4 (c1 TINYINT NOT NULL);
4044 CREATE TABLE t5 (c1 TINYINT NOT NULL);
4045 CREATE TABLE t6 (c1 TINYINT NOT NULL);
4046 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4047 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4048 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
4049 INSERT INTO t4 (c1) VALUES(10);
4050 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
4051 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 USING (c1);
4063 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1;
4075 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 >= 5;
4082 DROP TABLE t1,t2,t3,t4,t5,t6;
4083 CREATE TABLE t1 (c1 SMALLINT NOT NULL);
4084 CREATE TABLE t2 (c1 SMALLINT NOT NULL);
4085 CREATE TABLE t3 (c1 SMALLINT NOT NULL);
4086 CREATE TABLE t4 (c1 SMALLINT NOT NULL);
4087 CREATE TABLE t5 (c1 SMALLINT NOT NULL);
4088 CREATE TABLE t6 (c1 SMALLINT NOT NULL);
4089 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4090 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4091 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
4092 INSERT INTO t4 (c1) VALUES(10);
4093 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
4094 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 USING (c1);
4106 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1;
4118 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 >= 5;
4125 DROP TABLE t1,t2,t3,t4,t5,t6;
4126 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
4127 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
4128 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
4129 CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
4130 CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
4131 CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
4132 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4133 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4134 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
4135 INSERT INTO t4 (c1) VALUES(10);
4136 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
4137 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 USING (c1);
4149 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1;
4161 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 >= 5;
4168 DROP TABLE t1,t2,t3,t4,t5,t6;
4169 CREATE TABLE t1 (c1 INT NOT NULL);
4170 CREATE TABLE t2 (c1 INT NOT NULL);
4171 CREATE TABLE t3 (c1 INT NOT NULL);
4172 CREATE TABLE t4 (c1 INT NOT NULL);
4173 CREATE TABLE t5 (c1 INT NOT NULL);
4174 CREATE TABLE t6 (c1 INT NOT NULL);
4175 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4176 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4177 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
4178 INSERT INTO t4 (c1) VALUES(10);
4179 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
4180 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 USING (c1);
4192 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1;
4204 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 >= 5;
4211 DROP TABLE t1,t2,t3,t4,t5,t6;
4212 CREATE TABLE t1 (c1 INTEGER NOT NULL);
4213 CREATE TABLE t2 (c1 INTEGER NOT NULL);
4214 CREATE TABLE t3 (c1 INTEGER NOT NULL);
4215 CREATE TABLE t4 (c1 INTEGER NOT NULL);
4216 CREATE TABLE t5 (c1 INTEGER NOT NULL);
4217 CREATE TABLE t6 (c1 INTEGER NOT NULL);
4218 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4219 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4220 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
4221 INSERT INTO t4 (c1) VALUES(10);
4222 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
4223 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 USING (c1);
4235 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1;
4247 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 >= 5;
4254 DROP TABLE t1,t2,t3,t4,t5,t6;
4255 CREATE TABLE t1 (c1 BIGINT NOT NULL);
4256 CREATE TABLE t2 (c1 BIGINT NOT NULL);
4257 CREATE TABLE t3 (c1 BIGINT NOT NULL);
4258 CREATE TABLE t4 (c1 BIGINT NOT NULL);
4259 CREATE TABLE t5 (c1 BIGINT NOT NULL);
4260 CREATE TABLE t6 (c1 BIGINT NOT NULL);
4261 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4262 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4263 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
4264 INSERT INTO t4 (c1) VALUES(10);
4265 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
4266 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 USING (c1);
4278 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1;
4290 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 >= 5;
4297 DROP TABLE t1,t2,t3,t4,t5,t6;
4298 CREATE TABLE t1 (c1 TINYINT NOT NULL);
4299 CREATE TABLE t2 (c1 TINYINT NOT NULL);
4300 CREATE TABLE t3 (c1 TINYINT NOT NULL);
4301 CREATE TABLE t4 (c1 TINYINT NOT NULL);
4302 CREATE TABLE t5 (c1 TINYINT NOT NULL);
4303 CREATE TABLE t6 (c1 TINYINT NOT NULL);
4304 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4305 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4306 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
4307 INSERT INTO t4 (c1) VALUES(10);
4308 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
4309 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 USING (c1);
4321 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1;
4333 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 >= 5;
4340 DROP TABLE t1,t2,t3,t4,t5,t6;
4341 CREATE TABLE t1 (c1 SMALLINT NOT NULL);
4342 CREATE TABLE t2 (c1 SMALLINT NOT NULL);
4343 CREATE TABLE t3 (c1 SMALLINT NOT NULL);
4344 CREATE TABLE t4 (c1 SMALLINT NOT NULL);
4345 CREATE TABLE t5 (c1 SMALLINT NOT NULL);
4346 CREATE TABLE t6 (c1 SMALLINT NOT NULL);
4347 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4348 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4349 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
4350 INSERT INTO t4 (c1) VALUES(10);
4351 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
4352 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 USING (c1);
4364 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1;
4376 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 >= 5;
4383 DROP TABLE t1,t2,t3,t4,t5,t6;
4384 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
4385 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
4386 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
4387 CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
4388 CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
4389 CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
4390 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4391 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4392 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
4393 INSERT INTO t4 (c1) VALUES(10);
4394 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
4395 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 USING (c1);
4407 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1;
4419 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 >= 5;
4426 DROP TABLE t1,t2,t3,t4,t5,t6;
4427 CREATE TABLE t1 (c1 INT NOT NULL);
4428 CREATE TABLE t2 (c1 INT NOT NULL);
4429 CREATE TABLE t3 (c1 INT NOT NULL);
4430 CREATE TABLE t4 (c1 INT NOT NULL);
4431 CREATE TABLE t5 (c1 INT NOT NULL);
4432 CREATE TABLE t6 (c1 INT NOT NULL);
4433 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4434 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4435 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
4436 INSERT INTO t4 (c1) VALUES(10);
4437 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
4438 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 USING (c1);
4450 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1;
4462 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 >= 5;
4469 DROP TABLE t1,t2,t3,t4,t5,t6;
4470 CREATE TABLE t1 (c1 INTEGER NOT NULL);
4471 CREATE TABLE t2 (c1 INTEGER NOT NULL);
4472 CREATE TABLE t3 (c1 INTEGER NOT NULL);
4473 CREATE TABLE t4 (c1 INTEGER NOT NULL);
4474 CREATE TABLE t5 (c1 INTEGER NOT NULL);
4475 CREATE TABLE t6 (c1 INTEGER NOT NULL);
4476 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4477 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4478 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
4479 INSERT INTO t4 (c1) VALUES(10);
4480 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
4481 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 USING (c1);
4493 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1;
4505 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 >= 5;
4512 DROP TABLE t1,t2,t3,t4,t5,t6;
4513 CREATE TABLE t1 (c1 BIGINT NOT NULL);
4514 CREATE TABLE t2 (c1 BIGINT NOT NULL);
4515 CREATE TABLE t3 (c1 BIGINT NOT NULL);
4516 CREATE TABLE t4 (c1 BIGINT NOT NULL);
4517 CREATE TABLE t5 (c1 BIGINT NOT NULL);
4518 CREATE TABLE t6 (c1 BIGINT NOT NULL);
4519 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4520 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4521 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
4522 INSERT INTO t4 (c1) VALUES(10);
4523 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
4524 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 USING (c1);
4536 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1;
4548 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 >= 5;
4555 DROP TABLE t1,t2,t3,t4,t5,t6;
4556 CREATE TABLE t1 (c1 TINYINT NOT NULL);
4557 CREATE TABLE t2 (c1 TINYINT NOT NULL);
4558 CREATE TABLE t3 (c1 TINYINT NOT NULL);
4559 CREATE TABLE t4 (c1 TINYINT NOT NULL);
4560 CREATE TABLE t5 (c1 TINYINT NOT NULL);
4561 CREATE TABLE t6 (c1 TINYINT NOT NULL);
4562 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4563 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4564 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
4565 INSERT INTO t4 (c1) VALUES(10);
4566 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
4567 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 USING (c1);
4579 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1;
4591 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 >= 5;
4598 DROP TABLE t1,t2,t3,t4,t5,t6;
4599 CREATE TABLE t1 (c1 SMALLINT NOT NULL);
4600 CREATE TABLE t2 (c1 SMALLINT NOT NULL);
4601 CREATE TABLE t3 (c1 SMALLINT NOT NULL);
4602 CREATE TABLE t4 (c1 SMALLINT NOT NULL);
4603 CREATE TABLE t5 (c1 SMALLINT NOT NULL);
4604 CREATE TABLE t6 (c1 SMALLINT NOT NULL);
4605 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4606 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4607 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
4608 INSERT INTO t4 (c1) VALUES(10);
4609 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
4610 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 USING (c1);
4622 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1;
4634 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 >= 5;
4641 DROP TABLE t1,t2,t3,t4,t5,t6;
4642 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
4643 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
4644 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
4645 CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
4646 CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
4647 CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
4648 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4649 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4650 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
4651 INSERT INTO t4 (c1) VALUES(10);
4652 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
4653 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 USING (c1);
4665 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1;
4677 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 >= 5;
4684 DROP TABLE t1,t2,t3,t4,t5,t6;
4685 CREATE TABLE t1 (c1 INT NOT NULL);
4686 CREATE TABLE t2 (c1 INT NOT NULL);
4687 CREATE TABLE t3 (c1 INT NOT NULL);
4688 CREATE TABLE t4 (c1 INT NOT NULL);
4689 CREATE TABLE t5 (c1 INT NOT NULL);
4690 CREATE TABLE t6 (c1 INT NOT NULL);
4691 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4692 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4693 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
4694 INSERT INTO t4 (c1) VALUES(10);
4695 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
4696 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 USING (c1);
4708 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1;
4720 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 >= 5;
4727 DROP TABLE t1,t2,t3,t4,t5,t6;
4728 CREATE TABLE t1 (c1 INTEGER NOT NULL);
4729 CREATE TABLE t2 (c1 INTEGER NOT NULL);
4730 CREATE TABLE t3 (c1 INTEGER NOT NULL);
4731 CREATE TABLE t4 (c1 INTEGER NOT NULL);
4732 CREATE TABLE t5 (c1 INTEGER NOT NULL);
4733 CREATE TABLE t6 (c1 INTEGER NOT NULL);
4734 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4735 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4736 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
4737 INSERT INTO t4 (c1) VALUES(10);
4738 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
4739 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 USING (c1);
4751 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1;
4763 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 >= 5;
4770 DROP TABLE t1,t2,t3,t4,t5,t6;
4771 CREATE TABLE t1 (c1 BIGINT NOT NULL);
4772 CREATE TABLE t2 (c1 BIGINT NOT NULL);
4773 CREATE TABLE t3 (c1 BIGINT NOT NULL);
4774 CREATE TABLE t4 (c1 BIGINT NOT NULL);
4775 CREATE TABLE t5 (c1 BIGINT NOT NULL);
4776 CREATE TABLE t6 (c1 BIGINT NOT NULL);
4777 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4778 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4779 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
4780 INSERT INTO t4 (c1) VALUES(10);
4781 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
4782 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 USING (c1);
4794 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1;
4806 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 >= 5;
4813 DROP TABLE t1,t2,t3,t4,t5,t6;
4814 CREATE TABLE t1 (c1 TINYINT NOT NULL);
4815 CREATE TABLE t2 (c1 TINYINT NOT NULL);
4816 CREATE TABLE t3 (c1 TINYINT NOT NULL);
4817 CREATE TABLE t4 (c1 TINYINT NOT NULL);
4818 CREATE TABLE t5 (c1 TINYINT NOT NULL);
4819 CREATE TABLE t6 (c1 TINYINT NOT NULL);
4820 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4821 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4822 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
4823 INSERT INTO t4 (c1) VALUES(10);
4824 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
4825 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 USING (c1);
4837 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1;
4849 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 >= 5;
4856 DROP TABLE t1,t2,t3,t4,t5,t6;
4857 CREATE TABLE t1 (c1 SMALLINT NOT NULL);
4858 CREATE TABLE t2 (c1 SMALLINT NOT NULL);
4859 CREATE TABLE t3 (c1 SMALLINT NOT NULL);
4860 CREATE TABLE t4 (c1 SMALLINT NOT NULL);
4861 CREATE TABLE t5 (c1 SMALLINT NOT NULL);
4862 CREATE TABLE t6 (c1 SMALLINT NOT NULL);
4863 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4864 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4865 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
4866 INSERT INTO t4 (c1) VALUES(10);
4867 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
4868 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 USING (c1);
4880 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1;
4892 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 >= 5;
4899 DROP TABLE t1,t2,t3,t4,t5,t6;
4900 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
4901 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
4902 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
4903 CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
4904 CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
4905 CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
4906 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4907 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4908 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
4909 INSERT INTO t4 (c1) VALUES(10);
4910 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
4911 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 USING (c1);
4923 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1;
4935 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 >= 5;
4942 DROP TABLE t1,t2,t3,t4,t5,t6;
4943 CREATE TABLE t1 (c1 INT NOT NULL);
4944 CREATE TABLE t2 (c1 INT NOT NULL);
4945 CREATE TABLE t3 (c1 INT NOT NULL);
4946 CREATE TABLE t4 (c1 INT NOT NULL);
4947 CREATE TABLE t5 (c1 INT NOT NULL);
4948 CREATE TABLE t6 (c1 INT NOT NULL);
4949 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4950 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4951 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
4952 INSERT INTO t4 (c1) VALUES(10);
4953 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
4954 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 USING (c1);
4966 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1;
4978 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 >= 5;
4985 DROP TABLE t1,t2,t3,t4,t5,t6;
4986 CREATE TABLE t1 (c1 INTEGER NOT NULL);
4987 CREATE TABLE t2 (c1 INTEGER NOT NULL);
4988 CREATE TABLE t3 (c1 INTEGER NOT NULL);
4989 CREATE TABLE t4 (c1 INTEGER NOT NULL);
4990 CREATE TABLE t5 (c1 INTEGER NOT NULL);
4991 CREATE TABLE t6 (c1 INTEGER NOT NULL);
4992 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4993 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4994 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
4995 INSERT INTO t4 (c1) VALUES(10);
4996 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
4997 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 USING (c1);
5009 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1;
5021 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 >= 5;
5028 DROP TABLE t1,t2,t3,t4,t5,t6;
5029 CREATE TABLE t1 (c1 BIGINT NOT NULL);
5030 CREATE TABLE t2 (c1 BIGINT NOT NULL);
5031 CREATE TABLE t3 (c1 BIGINT NOT NULL);
5032 CREATE TABLE t4 (c1 BIGINT NOT NULL);
5033 CREATE TABLE t5 (c1 BIGINT NOT NULL);
5034 CREATE TABLE t6 (c1 BIGINT NOT NULL);
5035 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5036 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5037 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
5038 INSERT INTO t4 (c1) VALUES(10);
5039 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
5040 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 USING (c1);
5052 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1;
5064 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 >= 5;
5071 DROP TABLE t1,t2,t3,t4,t5,t6;
5072 CREATE TABLE t1 (c1 TINYINT NOT NULL);
5073 CREATE TABLE t2 (c1 TINYINT NOT NULL);
5074 CREATE TABLE t3 (c1 TINYINT NOT NULL);
5075 CREATE TABLE t4 (c1 TINYINT NOT NULL);
5076 CREATE TABLE t5 (c1 TINYINT NOT NULL);
5077 CREATE TABLE t6 (c1 TINYINT NOT NULL);
5078 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5079 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5080 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
5081 INSERT INTO t4 (c1) VALUES(10);
5082 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
5083 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 USING (c1);
5095 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1;
5107 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 != 5;
5118 DROP TABLE t1,t2,t3,t4,t5,t6;
5119 CREATE TABLE t1 (c1 SMALLINT NOT NULL);
5120 CREATE TABLE t2 (c1 SMALLINT NOT NULL);
5121 CREATE TABLE t3 (c1 SMALLINT NOT NULL);
5122 CREATE TABLE t4 (c1 SMALLINT NOT NULL);
5123 CREATE TABLE t5 (c1 SMALLINT NOT NULL);
5124 CREATE TABLE t6 (c1 SMALLINT NOT NULL);
5125 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5126 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5127 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
5128 INSERT INTO t4 (c1) VALUES(10);
5129 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
5130 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 USING (c1);
5142 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1;
5154 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 != 5;
5165 DROP TABLE t1,t2,t3,t4,t5,t6;
5166 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
5167 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
5168 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
5169 CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
5170 CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
5171 CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
5172 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5173 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5174 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
5175 INSERT INTO t4 (c1) VALUES(10);
5176 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
5177 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 USING (c1);
5189 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1;
5201 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 != 5;
5212 DROP TABLE t1,t2,t3,t4,t5,t6;
5213 CREATE TABLE t1 (c1 INT NOT NULL);
5214 CREATE TABLE t2 (c1 INT NOT NULL);
5215 CREATE TABLE t3 (c1 INT NOT NULL);
5216 CREATE TABLE t4 (c1 INT NOT NULL);
5217 CREATE TABLE t5 (c1 INT NOT NULL);
5218 CREATE TABLE t6 (c1 INT NOT NULL);
5219 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5220 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5221 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
5222 INSERT INTO t4 (c1) VALUES(10);
5223 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
5224 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 USING (c1);
5236 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1;
5248 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 != 5;
5259 DROP TABLE t1,t2,t3,t4,t5,t6;
5260 CREATE TABLE t1 (c1 INTEGER NOT NULL);
5261 CREATE TABLE t2 (c1 INTEGER NOT NULL);
5262 CREATE TABLE t3 (c1 INTEGER NOT NULL);
5263 CREATE TABLE t4 (c1 INTEGER NOT NULL);
5264 CREATE TABLE t5 (c1 INTEGER NOT NULL);
5265 CREATE TABLE t6 (c1 INTEGER NOT NULL);
5266 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5267 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5268 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
5269 INSERT INTO t4 (c1) VALUES(10);
5270 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
5271 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 USING (c1);
5283 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1;
5295 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 != 5;
5306 DROP TABLE t1,t2,t3,t4,t5,t6;
5307 CREATE TABLE t1 (c1 BIGINT NOT NULL);
5308 CREATE TABLE t2 (c1 BIGINT NOT NULL);
5309 CREATE TABLE t3 (c1 BIGINT NOT NULL);
5310 CREATE TABLE t4 (c1 BIGINT NOT NULL);
5311 CREATE TABLE t5 (c1 BIGINT NOT NULL);
5312 CREATE TABLE t6 (c1 BIGINT NOT NULL);
5313 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5314 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5315 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
5316 INSERT INTO t4 (c1) VALUES(10);
5317 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
5318 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 USING (c1);
5330 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1;
5342 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 != 5;
5353 DROP TABLE t1,t2,t3,t4,t5,t6;
5354 CREATE TABLE t1 (c1 TINYINT NOT NULL);
5355 CREATE TABLE t2 (c1 TINYINT NOT NULL);
5356 CREATE TABLE t3 (c1 TINYINT NOT NULL);
5357 CREATE TABLE t4 (c1 TINYINT NOT NULL);
5358 CREATE TABLE t5 (c1 TINYINT NOT NULL);
5359 CREATE TABLE t6 (c1 TINYINT NOT NULL);
5360 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5361 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5362 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
5363 INSERT INTO t4 (c1) VALUES(10);
5364 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
5365 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 USING (c1);
5377 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1;
5389 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 != 5;
5400 DROP TABLE t1,t2,t3,t4,t5,t6;
5401 CREATE TABLE t1 (c1 SMALLINT NOT NULL);
5402 CREATE TABLE t2 (c1 SMALLINT NOT NULL);
5403 CREATE TABLE t3 (c1 SMALLINT NOT NULL);
5404 CREATE TABLE t4 (c1 SMALLINT NOT NULL);
5405 CREATE TABLE t5 (c1 SMALLINT NOT NULL);
5406 CREATE TABLE t6 (c1 SMALLINT NOT NULL);
5407 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5408 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5409 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
5410 INSERT INTO t4 (c1) VALUES(10);
5411 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
5412 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 USING (c1);
5424 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1;
5436 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 != 5;
5447 DROP TABLE t1,t2,t3,t4,t5,t6;
5448 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
5449 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
5450 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
5451 CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
5452 CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
5453 CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
5454 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5455 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5456 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
5457 INSERT INTO t4 (c1) VALUES(10);
5458 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
5459 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 USING (c1);
5471 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1;
5483 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 != 5;
5494 DROP TABLE t1,t2,t3,t4,t5,t6;
5495 CREATE TABLE t1 (c1 INT NOT NULL);
5496 CREATE TABLE t2 (c1 INT NOT NULL);
5497 CREATE TABLE t3 (c1 INT NOT NULL);
5498 CREATE TABLE t4 (c1 INT NOT NULL);
5499 CREATE TABLE t5 (c1 INT NOT NULL);
5500 CREATE TABLE t6 (c1 INT NOT NULL);
5501 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5502 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5503 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
5504 INSERT INTO t4 (c1) VALUES(10);
5505 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
5506 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 USING (c1);
5518 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1;
5530 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 != 5;
5541 DROP TABLE t1,t2,t3,t4,t5,t6;
5542 CREATE TABLE t1 (c1 INTEGER NOT NULL);
5543 CREATE TABLE t2 (c1 INTEGER NOT NULL);
5544 CREATE TABLE t3 (c1 INTEGER NOT NULL);
5545 CREATE TABLE t4 (c1 INTEGER NOT NULL);
5546 CREATE TABLE t5 (c1 INTEGER NOT NULL);
5547 CREATE TABLE t6 (c1 INTEGER NOT NULL);
5548 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5549 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5550 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
5551 INSERT INTO t4 (c1) VALUES(10);
5552 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
5553 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 USING (c1);
5565 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1;
5577 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 != 5;
5588 DROP TABLE t1,t2,t3,t4,t5,t6;
5589 CREATE TABLE t1 (c1 BIGINT NOT NULL);
5590 CREATE TABLE t2 (c1 BIGINT NOT NULL);
5591 CREATE TABLE t3 (c1 BIGINT NOT NULL);
5592 CREATE TABLE t4 (c1 BIGINT NOT NULL);
5593 CREATE TABLE t5 (c1 BIGINT NOT NULL);
5594 CREATE TABLE t6 (c1 BIGINT NOT NULL);
5595 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5596 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5597 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
5598 INSERT INTO t4 (c1) VALUES(10);
5599 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
5600 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 USING (c1);
5612 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1;
5624 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 != 5;
5635 DROP TABLE t1,t2,t3,t4,t5,t6;
5636 CREATE TABLE t1 (c1 TINYINT NOT NULL);
5637 CREATE TABLE t2 (c1 TINYINT NOT NULL);
5638 CREATE TABLE t3 (c1 TINYINT NOT NULL);
5639 CREATE TABLE t4 (c1 TINYINT NOT NULL);
5640 CREATE TABLE t5 (c1 TINYINT NOT NULL);
5641 CREATE TABLE t6 (c1 TINYINT NOT NULL);
5642 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5643 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5644 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
5645 INSERT INTO t4 (c1) VALUES(10);
5646 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
5647 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 USING (c1);
5659 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1;
5671 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 != 5;
5682 DROP TABLE t1,t2,t3,t4,t5,t6;
5683 CREATE TABLE t1 (c1 SMALLINT NOT NULL);
5684 CREATE TABLE t2 (c1 SMALLINT NOT NULL);
5685 CREATE TABLE t3 (c1 SMALLINT NOT NULL);
5686 CREATE TABLE t4 (c1 SMALLINT NOT NULL);
5687 CREATE TABLE t5 (c1 SMALLINT NOT NULL);
5688 CREATE TABLE t6 (c1 SMALLINT NOT NULL);
5689 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5690 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5691 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
5692 INSERT INTO t4 (c1) VALUES(10);
5693 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
5694 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 USING (c1);
5706 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1;
5718 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 != 5;
5729 DROP TABLE t1,t2,t3,t4,t5,t6;
5730 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
5731 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
5732 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
5733 CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
5734 CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
5735 CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
5736 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5737 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5738 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
5739 INSERT INTO t4 (c1) VALUES(10);
5740 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
5741 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 USING (c1);
5753 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1;
5765 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 != 5;
5776 DROP TABLE t1,t2,t3,t4,t5,t6;
5777 CREATE TABLE t1 (c1 INT NOT NULL);
5778 CREATE TABLE t2 (c1 INT NOT NULL);
5779 CREATE TABLE t3 (c1 INT NOT NULL);
5780 CREATE TABLE t4 (c1 INT NOT NULL);
5781 CREATE TABLE t5 (c1 INT NOT NULL);
5782 CREATE TABLE t6 (c1 INT NOT NULL);
5783 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5784 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5785 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
5786 INSERT INTO t4 (c1) VALUES(10);
5787 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
5788 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 USING (c1);
5800 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1;
5812 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 != 5;
5823 DROP TABLE t1,t2,t3,t4,t5,t6;
5824 CREATE TABLE t1 (c1 INTEGER NOT NULL);
5825 CREATE TABLE t2 (c1 INTEGER NOT NULL);
5826 CREATE TABLE t3 (c1 INTEGER NOT NULL);
5827 CREATE TABLE t4 (c1 INTEGER NOT NULL);
5828 CREATE TABLE t5 (c1 INTEGER NOT NULL);
5829 CREATE TABLE t6 (c1 INTEGER NOT NULL);
5830 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5831 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5832 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
5833 INSERT INTO t4 (c1) VALUES(10);
5834 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
5835 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 USING (c1);
5847 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1;
5859 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 != 5;
5870 DROP TABLE t1,t2,t3,t4,t5,t6;
5871 CREATE TABLE t1 (c1 BIGINT NOT NULL);
5872 CREATE TABLE t2 (c1 BIGINT NOT NULL);
5873 CREATE TABLE t3 (c1 BIGINT NOT NULL);
5874 CREATE TABLE t4 (c1 BIGINT NOT NULL);
5875 CREATE TABLE t5 (c1 BIGINT NOT NULL);
5876 CREATE TABLE t6 (c1 BIGINT NOT NULL);
5877 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5878 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5879 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
5880 INSERT INTO t4 (c1) VALUES(10);
5881 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
5882 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 USING (c1);
5894 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1;
5906 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 != 5;
5917 DROP TABLE t1,t2,t3,t4,t5,t6;
5918 CREATE TABLE t1 (c1 TINYINT NOT NULL);
5919 CREATE TABLE t2 (c1 TINYINT NOT NULL);
5920 CREATE TABLE t3 (c1 TINYINT NOT NULL);
5921 CREATE TABLE t4 (c1 TINYINT NOT NULL);
5922 CREATE TABLE t5 (c1 TINYINT NOT NULL);
5923 CREATE TABLE t6 (c1 TINYINT NOT NULL);
5924 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5925 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5926 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
5927 INSERT INTO t4 (c1) VALUES(10);
5928 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
5929 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 USING (c1);
5941 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1;
5953 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 != 5;
5964 DROP TABLE t1,t2,t3,t4,t5,t6;
5965 CREATE TABLE t1 (c1 SMALLINT NOT NULL);
5966 CREATE TABLE t2 (c1 SMALLINT NOT NULL);
5967 CREATE TABLE t3 (c1 SMALLINT NOT NULL);
5968 CREATE TABLE t4 (c1 SMALLINT NOT NULL);
5969 CREATE TABLE t5 (c1 SMALLINT NOT NULL);
5970 CREATE TABLE t6 (c1 SMALLINT NOT NULL);
5971 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5972 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5973 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
5974 INSERT INTO t4 (c1) VALUES(10);
5975 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
5976 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 USING (c1);
5988 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1;
6000 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 != 5;
6011 DROP TABLE t1,t2,t3,t4,t5,t6;
6012 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
6013 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
6014 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
6015 CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
6016 CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
6017 CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
6018 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
6019 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
6020 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
6021 INSERT INTO t4 (c1) VALUES(10);
6022 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
6023 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 USING (c1);
6035 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1;
6047 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 != 5;
6058 DROP TABLE t1,t2,t3,t4,t5,t6;
6059 CREATE TABLE t1 (c1 INT NOT NULL);
6060 CREATE TABLE t2 (c1 INT NOT NULL);
6061 CREATE TABLE t3 (c1 INT NOT NULL);
6062 CREATE TABLE t4 (c1 INT NOT NULL);
6063 CREATE TABLE t5 (c1 INT NOT NULL);
6064 CREATE TABLE t6 (c1 INT NOT NULL);
6065 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
6066 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
6067 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
6068 INSERT INTO t4 (c1) VALUES(10);
6069 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
6070 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 USING (c1);
6082 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1;
6094 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 != 5;
6105 DROP TABLE t1,t2,t3,t4,t5,t6;
6106 CREATE TABLE t1 (c1 INTEGER NOT NULL);
6107 CREATE TABLE t2 (c1 INTEGER NOT NULL);
6108 CREATE TABLE t3 (c1 INTEGER NOT NULL);
6109 CREATE TABLE t4 (c1 INTEGER NOT NULL);
6110 CREATE TABLE t5 (c1 INTEGER NOT NULL);
6111 CREATE TABLE t6 (c1 INTEGER NOT NULL);
6112 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
6113 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
6114 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
6115 INSERT INTO t4 (c1) VALUES(10);
6116 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
6117 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 USING (c1);
6129 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1;
6141 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 != 5;
6152 DROP TABLE t1,t2,t3,t4,t5,t6;
6153 CREATE TABLE t1 (c1 BIGINT NOT NULL);
6154 CREATE TABLE t2 (c1 BIGINT NOT NULL);
6155 CREATE TABLE t3 (c1 BIGINT NOT NULL);
6156 CREATE TABLE t4 (c1 BIGINT NOT NULL);
6157 CREATE TABLE t5 (c1 BIGINT NOT NULL);
6158 CREATE TABLE t6 (c1 BIGINT NOT NULL);
6159 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
6160 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
6161 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
6162 INSERT INTO t4 (c1) VALUES(10);
6163 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
6164 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 USING (c1);
6176 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1;
6188 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 != 5;
6199 DROP TABLE t1,t2,t3,t4,t5,t6;
6200 CREATE TABLE t1 (c1 TINYINT NOT NULL);
6201 CREATE TABLE t2 (c1 TINYINT NOT NULL);
6202 CREATE TABLE t3 (c1 TINYINT NOT NULL);
6203 CREATE TABLE t4 (c1 TINYINT NOT NULL);
6204 CREATE TABLE t5 (c1 TINYINT NOT NULL);
6205 CREATE TABLE t6 (c1 TINYINT NOT NULL);
6206 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
6207 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
6208 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
6209 INSERT INTO t4 (c1) VALUES(10);
6210 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
6211 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 USING (c1);
6223 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1;
6235 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 != 5;
6246 DROP TABLE t1,t2,t3,t4,t5,t6;
6247 CREATE TABLE t1 (c1 SMALLINT NOT NULL);
6248 CREATE TABLE t2 (c1 SMALLINT NOT NULL);
6249 CREATE TABLE t3 (c1 SMALLINT NOT NULL);
6250 CREATE TABLE t4 (c1 SMALLINT NOT NULL);
6251 CREATE TABLE t5 (c1 SMALLINT NOT NULL);
6252 CREATE TABLE t6 (c1 SMALLINT NOT NULL);
6253 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
6254 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
6255 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
6256 INSERT INTO t4 (c1) VALUES(10);
6257 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
6258 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 USING (c1);
6270 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1;
6282 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 != 5;
6293 DROP TABLE t1,t2,t3,t4,t5,t6;
6294 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
6295 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
6296 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
6297 CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
6298 CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
6299 CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
6300 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
6301 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
6302 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
6303 INSERT INTO t4 (c1) VALUES(10);
6304 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
6305 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 USING (c1);
6317 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1;
6329 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 != 5;
6340 DROP TABLE t1,t2,t3,t4,t5,t6;
6341 CREATE TABLE t1 (c1 INT NOT NULL);
6342 CREATE TABLE t2 (c1 INT NOT NULL);
6343 CREATE TABLE t3 (c1 INT NOT NULL);
6344 CREATE TABLE t4 (c1 INT NOT NULL);
6345 CREATE TABLE t5 (c1 INT NOT NULL);
6346 CREATE TABLE t6 (c1 INT NOT NULL);
6347 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
6348 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
6349 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
6350 INSERT INTO t4 (c1) VALUES(10);
6351 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
6352 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 USING (c1);
6364 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1;
6376 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 != 5;
6387 DROP TABLE t1,t2,t3,t4,t5,t6;
6388 CREATE TABLE t1 (c1 INTEGER NOT NULL);
6389 CREATE TABLE t2 (c1 INTEGER NOT NULL);
6390 CREATE TABLE t3 (c1 INTEGER NOT NULL);
6391 CREATE TABLE t4 (c1 INTEGER NOT NULL);
6392 CREATE TABLE t5 (c1 INTEGER NOT NULL);
6393 CREATE TABLE t6 (c1 INTEGER NOT NULL);
6394 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
6395 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
6396 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
6397 INSERT INTO t4 (c1) VALUES(10);
6398 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
6399 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 USING (c1);
6411 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1;
6423 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 != 5;
6434 DROP TABLE t1,t2,t3,t4,t5,t6;
6435 CREATE TABLE t1 (c1 BIGINT NOT NULL);
6436 CREATE TABLE t2 (c1 BIGINT NOT NULL);
6437 CREATE TABLE t3 (c1 BIGINT NOT NULL);
6438 CREATE TABLE t4 (c1 BIGINT NOT NULL);
6439 CREATE TABLE t5 (c1 BIGINT NOT NULL);
6440 CREATE TABLE t6 (c1 BIGINT NOT NULL);
6441 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
6442 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
6443 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
6444 INSERT INTO t4 (c1) VALUES(10);
6445 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
6446 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 USING (c1);
6458 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1;
6470 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 != 5;
6481 DROP TABLE t1,t2,t3,t4,t5,t6;
6482 CREATE TABLE t1 (c1 TINYINT NOT NULL);
6483 CREATE TABLE t2 (c1 TINYINT NOT NULL);
6484 CREATE TABLE t3 (c1 TINYINT NOT NULL);
6485 CREATE TABLE t4 (c1 TINYINT NOT NULL);
6486 CREATE TABLE t5 (c1 TINYINT NOT NULL);
6487 CREATE TABLE t6 (c1 TINYINT NOT NULL);
6488 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
6489 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
6490 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
6491 INSERT INTO t4 (c1) VALUES(10);
6492 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
6493 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 USING (c1);
6505 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1;
6517 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 <> 5;
6528 DROP TABLE t1,t2,t3,t4,t5,t6;
6529 CREATE TABLE t1 (c1 SMALLINT NOT NULL);
6530 CREATE TABLE t2 (c1 SMALLINT NOT NULL);
6531 CREATE TABLE t3 (c1 SMALLINT NOT NULL);
6532 CREATE TABLE t4 (c1 SMALLINT NOT NULL);
6533 CREATE TABLE t5 (c1 SMALLINT NOT NULL);
6534 CREATE TABLE t6 (c1 SMALLINT NOT NULL);
6535 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
6536 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
6537 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
6538 INSERT INTO t4 (c1) VALUES(10);
6539 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
6540 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 USING (c1);
6552 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1;
6564 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 <> 5;
6575 DROP TABLE t1,t2,t3,t4,t5,t6;
6576 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
6577 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
6578 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
6579 CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
6580 CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
6581 CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
6582 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
6583 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
6584 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
6585 INSERT INTO t4 (c1) VALUES(10);
6586 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
6587 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 USING (c1);
6599 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1;
6611 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 <> 5;
6622 DROP TABLE t1,t2,t3,t4,t5,t6;
6623 CREATE TABLE t1 (c1 INT NOT NULL);
6624 CREATE TABLE t2 (c1 INT NOT NULL);
6625 CREATE TABLE t3 (c1 INT NOT NULL);
6626 CREATE TABLE t4 (c1 INT NOT NULL);
6627 CREATE TABLE t5 (c1 INT NOT NULL);
6628 CREATE TABLE t6 (c1 INT NOT NULL);
6629 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
6630 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
6631 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
6632 INSERT INTO t4 (c1) VALUES(10);
6633 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
6634 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 USING (c1);
6646 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1;
6658 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 <> 5;
6669 DROP TABLE t1,t2,t3,t4,t5,t6;
6670 CREATE TABLE t1 (c1 INTEGER NOT NULL);
6671 CREATE TABLE t2 (c1 INTEGER NOT NULL);
6672 CREATE TABLE t3 (c1 INTEGER NOT NULL);
6673 CREATE TABLE t4 (c1 INTEGER NOT NULL);
6674 CREATE TABLE t5 (c1 INTEGER NOT NULL);
6675 CREATE TABLE t6 (c1 INTEGER NOT NULL);
6676 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
6677 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
6678 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
6679 INSERT INTO t4 (c1) VALUES(10);
6680 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
6681 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 USING (c1);
6693 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1;
6705 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 <> 5;
6716 DROP TABLE t1,t2,t3,t4,t5,t6;
6717 CREATE TABLE t1 (c1 BIGINT NOT NULL);
6718 CREATE TABLE t2 (c1 BIGINT NOT NULL);
6719 CREATE TABLE t3 (c1 BIGINT NOT NULL);
6720 CREATE TABLE t4 (c1 BIGINT NOT NULL);
6721 CREATE TABLE t5 (c1 BIGINT NOT NULL);
6722 CREATE TABLE t6 (c1 BIGINT NOT NULL);
6723 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
6724 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
6725 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
6726 INSERT INTO t4 (c1) VALUES(10);
6727 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
6728 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 USING (c1);
6740 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1;
6752 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 <> 5;
6763 DROP TABLE t1,t2,t3,t4,t5,t6;
6764 CREATE TABLE t1 (c1 TINYINT NOT NULL);
6765 CREATE TABLE t2 (c1 TINYINT NOT NULL);
6766 CREATE TABLE t3 (c1 TINYINT NOT NULL);
6767 CREATE TABLE t4 (c1 TINYINT NOT NULL);
6768 CREATE TABLE t5 (c1 TINYINT NOT NULL);
6769 CREATE TABLE t6 (c1 TINYINT NOT NULL);
6770 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
6771 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
6772 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
6773 INSERT INTO t4 (c1) VALUES(10);
6774 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
6775 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 USING (c1);
6787 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1;
6799 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 <> 5;
6810 DROP TABLE t1,t2,t3,t4,t5,t6;
6811 CREATE TABLE t1 (c1 SMALLINT NOT NULL);
6812 CREATE TABLE t2 (c1 SMALLINT NOT NULL);
6813 CREATE TABLE t3 (c1 SMALLINT NOT NULL);
6814 CREATE TABLE t4 (c1 SMALLINT NOT NULL);
6815 CREATE TABLE t5 (c1 SMALLINT NOT NULL);
6816 CREATE TABLE t6 (c1 SMALLINT NOT NULL);
6817 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
6818 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
6819 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
6820 INSERT INTO t4 (c1) VALUES(10);
6821 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
6822 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 USING (c1);
6834 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1;
6846 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 <> 5;
6857 DROP TABLE t1,t2,t3,t4,t5,t6;
6858 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
6859 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
6860 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
6861 CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
6862 CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
6863 CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
6864 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
6865 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
6866 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
6867 INSERT INTO t4 (c1) VALUES(10);
6868 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
6869 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 USING (c1);
6881 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1;
6893 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 <> 5;
6904 DROP TABLE t1,t2,t3,t4,t5,t6;
6905 CREATE TABLE t1 (c1 INT NOT NULL);
6906 CREATE TABLE t2 (c1 INT NOT NULL);
6907 CREATE TABLE t3 (c1 INT NOT NULL);
6908 CREATE TABLE t4 (c1 INT NOT NULL);
6909 CREATE TABLE t5 (c1 INT NOT NULL);
6910 CREATE TABLE t6 (c1 INT NOT NULL);
6911 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
6912 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
6913 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
6914 INSERT INTO t4 (c1) VALUES(10);
6915 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
6916 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 USING (c1);
6928 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1;
6940 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 <> 5;
6951 DROP TABLE t1,t2,t3,t4,t5,t6;
6952 CREATE TABLE t1 (c1 INTEGER NOT NULL);
6953 CREATE TABLE t2 (c1 INTEGER NOT NULL);
6954 CREATE TABLE t3 (c1 INTEGER NOT NULL);
6955 CREATE TABLE t4 (c1 INTEGER NOT NULL);
6956 CREATE TABLE t5 (c1 INTEGER NOT NULL);
6957 CREATE TABLE t6 (c1 INTEGER NOT NULL);
6958 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
6959 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
6960 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
6961 INSERT INTO t4 (c1) VALUES(10);
6962 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
6963 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 USING (c1);
6975 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1;
6987 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 <> 5;
6998 DROP TABLE t1,t2,t3,t4,t5,t6;
6999 CREATE TABLE t1 (c1 BIGINT NOT NULL);
7000 CREATE TABLE t2 (c1 BIGINT NOT NULL);
7001 CREATE TABLE t3 (c1 BIGINT NOT NULL);
7002 CREATE TABLE t4 (c1 BIGINT NOT NULL);
7003 CREATE TABLE t5 (c1 BIGINT NOT NULL);
7004 CREATE TABLE t6 (c1 BIGINT NOT NULL);
7005 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
7006 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
7007 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
7008 INSERT INTO t4 (c1) VALUES(10);
7009 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
7010 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 USING (c1);
7022 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1;
7034 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 <> 5;
7045 DROP TABLE t1,t2,t3,t4,t5,t6;
7046 CREATE TABLE t1 (c1 TINYINT NOT NULL);
7047 CREATE TABLE t2 (c1 TINYINT NOT NULL);
7048 CREATE TABLE t3 (c1 TINYINT NOT NULL);
7049 CREATE TABLE t4 (c1 TINYINT NOT NULL);
7050 CREATE TABLE t5 (c1 TINYINT NOT NULL);
7051 CREATE TABLE t6 (c1 TINYINT NOT NULL);
7052 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
7053 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
7054 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
7055 INSERT INTO t4 (c1) VALUES(10);
7056 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
7057 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 USING (c1);
7069 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1;
7081 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 <> 5;
7092 DROP TABLE t1,t2,t3,t4,t5,t6;
7093 CREATE TABLE t1 (c1 SMALLINT NOT NULL);
7094 CREATE TABLE t2 (c1 SMALLINT NOT NULL);
7095 CREATE TABLE t3 (c1 SMALLINT NOT NULL);
7096 CREATE TABLE t4 (c1 SMALLINT NOT NULL);
7097 CREATE TABLE t5 (c1 SMALLINT NOT NULL);
7098 CREATE TABLE t6 (c1 SMALLINT NOT NULL);
7099 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
7100 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
7101 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
7102 INSERT INTO t4 (c1) VALUES(10);
7103 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
7104 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 USING (c1);
7116 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1;
7128 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 <> 5;
7139 DROP TABLE t1,t2,t3,t4,t5,t6;
7140 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
7141 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
7142 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
7143 CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
7144 CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
7145 CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
7146 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
7147 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
7148 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
7149 INSERT INTO t4 (c1) VALUES(10);
7150 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
7151 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 USING (c1);
7163 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1;
7175 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 <> 5;
7186 DROP TABLE t1,t2,t3,t4,t5,t6;
7187 CREATE TABLE t1 (c1 INT NOT NULL);
7188 CREATE TABLE t2 (c1 INT NOT NULL);
7189 CREATE TABLE t3 (c1 INT NOT NULL);
7190 CREATE TABLE t4 (c1 INT NOT NULL);
7191 CREATE TABLE t5 (c1 INT NOT NULL);
7192 CREATE TABLE t6 (c1 INT NOT NULL);
7193 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
7194 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
7195 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
7196 INSERT INTO t4 (c1) VALUES(10);
7197 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
7198 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 USING (c1);
7210 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1;
7222 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 <> 5;
7233 DROP TABLE t1,t2,t3,t4,t5,t6;
7234 CREATE TABLE t1 (c1 INTEGER NOT NULL);
7235 CREATE TABLE t2 (c1 INTEGER NOT NULL);
7236 CREATE TABLE t3 (c1 INTEGER NOT NULL);
7237 CREATE TABLE t4 (c1 INTEGER NOT NULL);
7238 CREATE TABLE t5 (c1 INTEGER NOT NULL);
7239 CREATE TABLE t6 (c1 INTEGER NOT NULL);
7240 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
7241 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
7242 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
7243 INSERT INTO t4 (c1) VALUES(10);
7244 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
7245 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 USING (c1);
7257 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1;
7269 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 <> 5;
7280 DROP TABLE t1,t2,t3,t4,t5,t6;
7281 CREATE TABLE t1 (c1 BIGINT NOT NULL);
7282 CREATE TABLE t2 (c1 BIGINT NOT NULL);
7283 CREATE TABLE t3 (c1 BIGINT NOT NULL);
7284 CREATE TABLE t4 (c1 BIGINT NOT NULL);
7285 CREATE TABLE t5 (c1 BIGINT NOT NULL);
7286 CREATE TABLE t6 (c1 BIGINT NOT NULL);
7287 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
7288 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
7289 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
7290 INSERT INTO t4 (c1) VALUES(10);
7291 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
7292 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 USING (c1);
7304 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1;
7316 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 <> 5;
7327 DROP TABLE t1,t2,t3,t4,t5,t6;
7328 CREATE TABLE t1 (c1 TINYINT NOT NULL);
7329 CREATE TABLE t2 (c1 TINYINT NOT NULL);
7330 CREATE TABLE t3 (c1 TINYINT NOT NULL);
7331 CREATE TABLE t4 (c1 TINYINT NOT NULL);
7332 CREATE TABLE t5 (c1 TINYINT NOT NULL);
7333 CREATE TABLE t6 (c1 TINYINT NOT NULL);
7334 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
7335 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
7336 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
7337 INSERT INTO t4 (c1) VALUES(10);
7338 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
7339 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 USING (c1);
7351 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1;
7363 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 <> 5;
7374 DROP TABLE t1,t2,t3,t4,t5,t6;
7375 CREATE TABLE t1 (c1 SMALLINT NOT NULL);
7376 CREATE TABLE t2 (c1 SMALLINT NOT NULL);
7377 CREATE TABLE t3 (c1 SMALLINT NOT NULL);
7378 CREATE TABLE t4 (c1 SMALLINT NOT NULL);
7379 CREATE TABLE t5 (c1 SMALLINT NOT NULL);
7380 CREATE TABLE t6 (c1 SMALLINT NOT NULL);
7381 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
7382 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
7383 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
7384 INSERT INTO t4 (c1) VALUES(10);
7385 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
7386 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 USING (c1);
7398 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1;
7410 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 <> 5;
7421 DROP TABLE t1,t2,t3,t4,t5,t6;
7422 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
7423 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
7424 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
7425 CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
7426 CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
7427 CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
7428 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
7429 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
7430 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
7431 INSERT INTO t4 (c1) VALUES(10);
7432 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
7433 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 USING (c1);
7445 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1;
7457 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 <> 5;
7468 DROP TABLE t1,t2,t3,t4,t5,t6;
7469 CREATE TABLE t1 (c1 INT NOT NULL);
7470 CREATE TABLE t2 (c1 INT NOT NULL);
7471 CREATE TABLE t3 (c1 INT NOT NULL);
7472 CREATE TABLE t4 (c1 INT NOT NULL);
7473 CREATE TABLE t5 (c1 INT NOT NULL);
7474 CREATE TABLE t6 (c1 INT NOT NULL);
7475 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
7476 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
7477 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
7478 INSERT INTO t4 (c1) VALUES(10);
7479 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
7480 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 USING (c1);
7492 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1;
7504 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 <> 5;
7515 DROP TABLE t1,t2,t3,t4,t5,t6;
7516 CREATE TABLE t1 (c1 INTEGER NOT NULL);
7517 CREATE TABLE t2 (c1 INTEGER NOT NULL);
7518 CREATE TABLE t3 (c1 INTEGER NOT NULL);
7519 CREATE TABLE t4 (c1 INTEGER NOT NULL);
7520 CREATE TABLE t5 (c1 INTEGER NOT NULL);
7521 CREATE TABLE t6 (c1 INTEGER NOT NULL);
7522 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
7523 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
7524 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
7525 INSERT INTO t4 (c1) VALUES(10);
7526 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
7527 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 USING (c1);
7539 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1;
7551 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 <> 5;
7562 DROP TABLE t1,t2,t3,t4,t5,t6;
7563 CREATE TABLE t1 (c1 BIGINT NOT NULL);
7564 CREATE TABLE t2 (c1 BIGINT NOT NULL);
7565 CREATE TABLE t3 (c1 BIGINT NOT NULL);
7566 CREATE TABLE t4 (c1 BIGINT NOT NULL);
7567 CREATE TABLE t5 (c1 BIGINT NOT NULL);
7568 CREATE TABLE t6 (c1 BIGINT NOT NULL);
7569 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
7570 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
7571 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
7572 INSERT INTO t4 (c1) VALUES(10);
7573 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
7574 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 USING (c1);
7586 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1;
7598 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 <> 5;
7609 DROP TABLE t1,t2,t3,t4,t5,t6;
7610 CREATE TABLE t1 (c1 TINYINT NOT NULL);
7611 CREATE TABLE t2 (c1 TINYINT NOT NULL);
7612 CREATE TABLE t3 (c1 TINYINT NOT NULL);
7613 CREATE TABLE t4 (c1 TINYINT NOT NULL);
7614 CREATE TABLE t5 (c1 TINYINT NOT NULL);
7615 CREATE TABLE t6 (c1 TINYINT NOT NULL);
7616 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
7617 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
7618 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
7619 INSERT INTO t4 (c1) VALUES(10);
7620 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
7621 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 USING (c1);
7633 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1;
7645 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 <> 5;
7656 DROP TABLE t1,t2,t3,t4,t5,t6;
7657 CREATE TABLE t1 (c1 SMALLINT NOT NULL);
7658 CREATE TABLE t2 (c1 SMALLINT NOT NULL);
7659 CREATE TABLE t3 (c1 SMALLINT NOT NULL);
7660 CREATE TABLE t4 (c1 SMALLINT NOT NULL);
7661 CREATE TABLE t5 (c1 SMALLINT NOT NULL);
7662 CREATE TABLE t6 (c1 SMALLINT NOT NULL);
7663 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
7664 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
7665 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
7666 INSERT INTO t4 (c1) VALUES(10);
7667 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
7668 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 USING (c1);
7680 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1;
7692 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 <> 5;
7703 DROP TABLE t1,t2,t3,t4,t5,t6;
7704 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
7705 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
7706 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
7707 CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
7708 CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
7709 CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
7710 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
7711 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
7712 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
7713 INSERT INTO t4 (c1) VALUES(10);
7714 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
7715 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 USING (c1);
7727 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1;
7739 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 <> 5;
7750 DROP TABLE t1,t2,t3,t4,t5,t6;
7751 CREATE TABLE t1 (c1 INT NOT NULL);
7752 CREATE TABLE t2 (c1 INT NOT NULL);
7753 CREATE TABLE t3 (c1 INT NOT NULL);
7754 CREATE TABLE t4 (c1 INT NOT NULL);
7755 CREATE TABLE t5 (c1 INT NOT NULL);
7756 CREATE TABLE t6 (c1 INT NOT NULL);
7757 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
7758 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
7759 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
7760 INSERT INTO t4 (c1) VALUES(10);
7761 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
7762 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 USING (c1);
7774 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1;
7786 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 <> 5;
7797 DROP TABLE t1,t2,t3,t4,t5,t6;
7798 CREATE TABLE t1 (c1 INTEGER NOT NULL);
7799 CREATE TABLE t2 (c1 INTEGER NOT NULL);
7800 CREATE TABLE t3 (c1 INTEGER NOT NULL);
7801 CREATE TABLE t4 (c1 INTEGER NOT NULL);
7802 CREATE TABLE t5 (c1 INTEGER NOT NULL);
7803 CREATE TABLE t6 (c1 INTEGER NOT NULL);
7804 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
7805 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
7806 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
7807 INSERT INTO t4 (c1) VALUES(10);
7808 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
7809 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 USING (c1);
7821 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1;
7833 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 <> 5;
7844 DROP TABLE t1,t2,t3,t4,t5,t6;
7845 CREATE TABLE t1 (c1 BIGINT NOT NULL);
7846 CREATE TABLE t2 (c1 BIGINT NOT NULL);
7847 CREATE TABLE t3 (c1 BIGINT NOT NULL);
7848 CREATE TABLE t4 (c1 BIGINT NOT NULL);
7849 CREATE TABLE t5 (c1 BIGINT NOT NULL);
7850 CREATE TABLE t6 (c1 BIGINT NOT NULL);
7851 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
7852 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
7853 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
7854 INSERT INTO t4 (c1) VALUES(10);
7855 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
7856 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 USING (c1);
7868 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1;
7880 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 <> 5;
7891 DROP TABLE t1,t2,t3,t4,t5,t6;
7892 CREATE TABLE t1 (c1 TINYINT NOT NULL);
7893 CREATE TABLE t2 (c1 TINYINT NOT NULL);
7894 CREATE TABLE t3 (c1 TINYINT NOT NULL);
7895 CREATE TABLE t4 (c1 TINYINT NOT NULL);
7896 CREATE TABLE t5 (c1 TINYINT NOT NULL);
7897 CREATE TABLE t6 (c1 TINYINT NOT NULL);
7898 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
7899 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
7900 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
7901 INSERT INTO t4 (c1) VALUES(10);
7902 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
7903 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 USING (c1);
7915 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1;
7927 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 <=> 5;
7930 DROP TABLE t1,t2,t3,t4,t5,t6;
7931 CREATE TABLE t1 (c1 SMALLINT NOT NULL);
7932 CREATE TABLE t2 (c1 SMALLINT NOT NULL);
7933 CREATE TABLE t3 (c1 SMALLINT NOT NULL);
7934 CREATE TABLE t4 (c1 SMALLINT NOT NULL);
7935 CREATE TABLE t5 (c1 SMALLINT NOT NULL);
7936 CREATE TABLE t6 (c1 SMALLINT NOT NULL);
7937 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
7938 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
7939 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
7940 INSERT INTO t4 (c1) VALUES(10);
7941 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
7942 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 USING (c1);
7954 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1;
7966 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 <=> 5;
7969 DROP TABLE t1,t2,t3,t4,t5,t6;
7970 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
7971 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
7972 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
7973 CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
7974 CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
7975 CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
7976 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
7977 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
7978 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
7979 INSERT INTO t4 (c1) VALUES(10);
7980 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
7981 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 USING (c1);
7993 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1;
8005 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 <=> 5;
8008 DROP TABLE t1,t2,t3,t4,t5,t6;
8009 CREATE TABLE t1 (c1 INT NOT NULL);
8010 CREATE TABLE t2 (c1 INT NOT NULL);
8011 CREATE TABLE t3 (c1 INT NOT NULL);
8012 CREATE TABLE t4 (c1 INT NOT NULL);
8013 CREATE TABLE t5 (c1 INT NOT NULL);
8014 CREATE TABLE t6 (c1 INT NOT NULL);
8015 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
8016 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
8017 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
8018 INSERT INTO t4 (c1) VALUES(10);
8019 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
8020 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 USING (c1);
8032 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1;
8044 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 <=> 5;
8047 DROP TABLE t1,t2,t3,t4,t5,t6;
8048 CREATE TABLE t1 (c1 INTEGER NOT NULL);
8049 CREATE TABLE t2 (c1 INTEGER NOT NULL);
8050 CREATE TABLE t3 (c1 INTEGER NOT NULL);
8051 CREATE TABLE t4 (c1 INTEGER NOT NULL);
8052 CREATE TABLE t5 (c1 INTEGER NOT NULL);
8053 CREATE TABLE t6 (c1 INTEGER NOT NULL);
8054 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
8055 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
8056 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
8057 INSERT INTO t4 (c1) VALUES(10);
8058 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
8059 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 USING (c1);
8071 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1;
8083 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 <=> 5;
8086 DROP TABLE t1,t2,t3,t4,t5,t6;
8087 CREATE TABLE t1 (c1 BIGINT NOT NULL);
8088 CREATE TABLE t2 (c1 BIGINT NOT NULL);
8089 CREATE TABLE t3 (c1 BIGINT NOT NULL);
8090 CREATE TABLE t4 (c1 BIGINT NOT NULL);
8091 CREATE TABLE t5 (c1 BIGINT NOT NULL);
8092 CREATE TABLE t6 (c1 BIGINT NOT NULL);
8093 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
8094 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
8095 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
8096 INSERT INTO t4 (c1) VALUES(10);
8097 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
8098 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 USING (c1);
8110 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1;
8122 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 <=> 5;
8125 DROP TABLE t1,t2,t3,t4,t5,t6;
8126 CREATE TABLE t1 (c1 TINYINT NOT NULL);
8127 CREATE TABLE t2 (c1 TINYINT NOT NULL);
8128 CREATE TABLE t3 (c1 TINYINT NOT NULL);
8129 CREATE TABLE t4 (c1 TINYINT NOT NULL);
8130 CREATE TABLE t5 (c1 TINYINT NOT NULL);
8131 CREATE TABLE t6 (c1 TINYINT NOT NULL);
8132 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
8133 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
8134 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
8135 INSERT INTO t4 (c1) VALUES(10);
8136 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
8137 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 USING (c1);
8149 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1;
8161 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 <=> 5;
8164 DROP TABLE t1,t2,t3,t4,t5,t6;
8165 CREATE TABLE t1 (c1 SMALLINT NOT NULL);
8166 CREATE TABLE t2 (c1 SMALLINT NOT NULL);
8167 CREATE TABLE t3 (c1 SMALLINT NOT NULL);
8168 CREATE TABLE t4 (c1 SMALLINT NOT NULL);
8169 CREATE TABLE t5 (c1 SMALLINT NOT NULL);
8170 CREATE TABLE t6 (c1 SMALLINT NOT NULL);
8171 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
8172 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
8173 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
8174 INSERT INTO t4 (c1) VALUES(10);
8175 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
8176 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 USING (c1);
8188 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1;
8200 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 <=> 5;
8203 DROP TABLE t1,t2,t3,t4,t5,t6;
8204 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
8205 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
8206 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
8207 CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
8208 CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
8209 CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
8210 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
8211 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
8212 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
8213 INSERT INTO t4 (c1) VALUES(10);
8214 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
8215 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 USING (c1);
8227 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1;
8239 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 <=> 5;
8242 DROP TABLE t1,t2,t3,t4,t5,t6;
8243 CREATE TABLE t1 (c1 INT NOT NULL);
8244 CREATE TABLE t2 (c1 INT NOT NULL);
8245 CREATE TABLE t3 (c1 INT NOT NULL);
8246 CREATE TABLE t4 (c1 INT NOT NULL);
8247 CREATE TABLE t5 (c1 INT NOT NULL);
8248 CREATE TABLE t6 (c1 INT NOT NULL);
8249 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
8250 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
8251 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
8252 INSERT INTO t4 (c1) VALUES(10);
8253 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
8254 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 USING (c1);
8266 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1;
8278 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 <=> 5;
8281 DROP TABLE t1,t2,t3,t4,t5,t6;
8282 CREATE TABLE t1 (c1 INTEGER NOT NULL);
8283 CREATE TABLE t2 (c1 INTEGER NOT NULL);
8284 CREATE TABLE t3 (c1 INTEGER NOT NULL);
8285 CREATE TABLE t4 (c1 INTEGER NOT NULL);
8286 CREATE TABLE t5 (c1 INTEGER NOT NULL);
8287 CREATE TABLE t6 (c1 INTEGER NOT NULL);
8288 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
8289 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
8290 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
8291 INSERT INTO t4 (c1) VALUES(10);
8292 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
8293 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 USING (c1);
8305 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1;
8317 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 <=> 5;
8320 DROP TABLE t1,t2,t3,t4,t5,t6;
8321 CREATE TABLE t1 (c1 BIGINT NOT NULL);
8322 CREATE TABLE t2 (c1 BIGINT NOT NULL);
8323 CREATE TABLE t3 (c1 BIGINT NOT NULL);
8324 CREATE TABLE t4 (c1 BIGINT NOT NULL);
8325 CREATE TABLE t5 (c1 BIGINT NOT NULL);
8326 CREATE TABLE t6 (c1 BIGINT NOT NULL);
8327 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
8328 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
8329 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
8330 INSERT INTO t4 (c1) VALUES(10);
8331 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
8332 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 USING (c1);
8344 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1;
8356 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 <=> 5;
8359 DROP TABLE t1,t2,t3,t4,t5,t6;
8360 CREATE TABLE t1 (c1 TINYINT NOT NULL);
8361 CREATE TABLE t2 (c1 TINYINT NOT NULL);
8362 CREATE TABLE t3 (c1 TINYINT NOT NULL);
8363 CREATE TABLE t4 (c1 TINYINT NOT NULL);
8364 CREATE TABLE t5 (c1 TINYINT NOT NULL);
8365 CREATE TABLE t6 (c1 TINYINT NOT NULL);
8366 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
8367 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
8368 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
8369 INSERT INTO t4 (c1) VALUES(10);
8370 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
8371 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 USING (c1);
8383 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1;
8395 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 <=> 5;
8398 DROP TABLE t1,t2,t3,t4,t5,t6;
8399 CREATE TABLE t1 (c1 SMALLINT NOT NULL);
8400 CREATE TABLE t2 (c1 SMALLINT NOT NULL);
8401 CREATE TABLE t3 (c1 SMALLINT NOT NULL);
8402 CREATE TABLE t4 (c1 SMALLINT NOT NULL);
8403 CREATE TABLE t5 (c1 SMALLINT NOT NULL);
8404 CREATE TABLE t6 (c1 SMALLINT NOT NULL);
8405 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
8406 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
8407 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
8408 INSERT INTO t4 (c1) VALUES(10);
8409 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
8410 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 USING (c1);
8422 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1;
8434 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 <=> 5;
8437 DROP TABLE t1,t2,t3,t4,t5,t6;
8438 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
8439 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
8440 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
8441 CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
8442 CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
8443 CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
8444 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
8445 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
8446 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
8447 INSERT INTO t4 (c1) VALUES(10);
8448 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
8449 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 USING (c1);
8461 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1;
8473 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 <=> 5;
8476 DROP TABLE t1,t2,t3,t4,t5,t6;
8477 CREATE TABLE t1 (c1 INT NOT NULL);
8478 CREATE TABLE t2 (c1 INT NOT NULL);
8479 CREATE TABLE t3 (c1 INT NOT NULL);
8480 CREATE TABLE t4 (c1 INT NOT NULL);
8481 CREATE TABLE t5 (c1 INT NOT NULL);
8482 CREATE TABLE t6 (c1 INT NOT NULL);
8483 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
8484 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
8485 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
8486 INSERT INTO t4 (c1) VALUES(10);
8487 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
8488 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 USING (c1);
8500 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1;
8512 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 <=> 5;
8515 DROP TABLE t1,t2,t3,t4,t5,t6;
8516 CREATE TABLE t1 (c1 INTEGER NOT NULL);
8517 CREATE TABLE t2 (c1 INTEGER NOT NULL);
8518 CREATE TABLE t3 (c1 INTEGER NOT NULL);
8519 CREATE TABLE t4 (c1 INTEGER NOT NULL);
8520 CREATE TABLE t5 (c1 INTEGER NOT NULL);
8521 CREATE TABLE t6 (c1 INTEGER NOT NULL);
8522 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
8523 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
8524 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
8525 INSERT INTO t4 (c1) VALUES(10);
8526 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
8527 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 USING (c1);
8539 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1;
8551 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 <=> 5;
8554 DROP TABLE t1,t2,t3,t4,t5,t6;
8555 CREATE TABLE t1 (c1 BIGINT NOT NULL);
8556 CREATE TABLE t2 (c1 BIGINT NOT NULL);
8557 CREATE TABLE t3 (c1 BIGINT NOT NULL);
8558 CREATE TABLE t4 (c1 BIGINT NOT NULL);
8559 CREATE TABLE t5 (c1 BIGINT NOT NULL);
8560 CREATE TABLE t6 (c1 BIGINT NOT NULL);
8561 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
8562 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
8563 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
8564 INSERT INTO t4 (c1) VALUES(10);
8565 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
8566 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 USING (c1);
8578 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1;
8590 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 <=> 5;
8593 DROP TABLE t1,t2,t3,t4,t5,t6;
8594 CREATE TABLE t1 (c1 TINYINT NOT NULL);
8595 CREATE TABLE t2 (c1 TINYINT NOT NULL);
8596 CREATE TABLE t3 (c1 TINYINT NOT NULL);
8597 CREATE TABLE t4 (c1 TINYINT NOT NULL);
8598 CREATE TABLE t5 (c1 TINYINT NOT NULL);
8599 CREATE TABLE t6 (c1 TINYINT NOT NULL);
8600 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
8601 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
8602 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
8603 INSERT INTO t4 (c1) VALUES(10);
8604 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
8605 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 USING (c1);
8617 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1;
8629 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 <=> 5;
8632 DROP TABLE t1,t2,t3,t4,t5,t6;
8633 CREATE TABLE t1 (c1 SMALLINT NOT NULL);
8634 CREATE TABLE t2 (c1 SMALLINT NOT NULL);
8635 CREATE TABLE t3 (c1 SMALLINT NOT NULL);
8636 CREATE TABLE t4 (c1 SMALLINT NOT NULL);
8637 CREATE TABLE t5 (c1 SMALLINT NOT NULL);
8638 CREATE TABLE t6 (c1 SMALLINT NOT NULL);
8639 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
8640 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
8641 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
8642 INSERT INTO t4 (c1) VALUES(10);
8643 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
8644 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 USING (c1);
8656 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1;
8668 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 <=> 5;
8671 DROP TABLE t1,t2,t3,t4,t5,t6;
8672 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
8673 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
8674 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
8675 CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
8676 CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
8677 CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
8678 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
8679 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
8680 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
8681 INSERT INTO t4 (c1) VALUES(10);
8682 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
8683 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 USING (c1);
8695 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1;
8707 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 <=> 5;
8710 DROP TABLE t1,t2,t3,t4,t5,t6;
8711 CREATE TABLE t1 (c1 INT NOT NULL);
8712 CREATE TABLE t2 (c1 INT NOT NULL);
8713 CREATE TABLE t3 (c1 INT NOT NULL);
8714 CREATE TABLE t4 (c1 INT NOT NULL);
8715 CREATE TABLE t5 (c1 INT NOT NULL);
8716 CREATE TABLE t6 (c1 INT NOT NULL);
8717 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
8718 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
8719 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
8720 INSERT INTO t4 (c1) VALUES(10);
8721 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
8722 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 USING (c1);
8734 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1;
8746 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 <=> 5;
8749 DROP TABLE t1,t2,t3,t4,t5,t6;
8750 CREATE TABLE t1 (c1 INTEGER NOT NULL);
8751 CREATE TABLE t2 (c1 INTEGER NOT NULL);
8752 CREATE TABLE t3 (c1 INTEGER NOT NULL);
8753 CREATE TABLE t4 (c1 INTEGER NOT NULL);
8754 CREATE TABLE t5 (c1 INTEGER NOT NULL);
8755 CREATE TABLE t6 (c1 INTEGER NOT NULL);
8756 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
8757 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
8758 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
8759 INSERT INTO t4 (c1) VALUES(10);
8760 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
8761 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 USING (c1);
8773 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1;
8785 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 <=> 5;
8788 DROP TABLE t1,t2,t3,t4,t5,t6;
8789 CREATE TABLE t1 (c1 BIGINT NOT NULL);
8790 CREATE TABLE t2 (c1 BIGINT NOT NULL);
8791 CREATE TABLE t3 (c1 BIGINT NOT NULL);
8792 CREATE TABLE t4 (c1 BIGINT NOT NULL);
8793 CREATE TABLE t5 (c1 BIGINT NOT NULL);
8794 CREATE TABLE t6 (c1 BIGINT NOT NULL);
8795 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
8796 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
8797 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
8798 INSERT INTO t4 (c1) VALUES(10);
8799 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
8800 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 USING (c1);
8812 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1;
8824 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 <=> 5;
8827 DROP TABLE t1,t2,t3,t4,t5,t6;
8828 CREATE TABLE t1 (c1 TINYINT NOT NULL);
8829 CREATE TABLE t2 (c1 TINYINT NOT NULL);
8830 CREATE TABLE t3 (c1 TINYINT NOT NULL);
8831 CREATE TABLE t4 (c1 TINYINT NOT NULL);
8832 CREATE TABLE t5 (c1 TINYINT NOT NULL);
8833 CREATE TABLE t6 (c1 TINYINT NOT NULL);
8834 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
8835 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
8836 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
8837 INSERT INTO t4 (c1) VALUES(10);
8838 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
8839 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 USING (c1);
8851 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1;
8863 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 <=> 5;
8866 DROP TABLE t1,t2,t3,t4,t5,t6;
8867 CREATE TABLE t1 (c1 SMALLINT NOT NULL);
8868 CREATE TABLE t2 (c1 SMALLINT NOT NULL);
8869 CREATE TABLE t3 (c1 SMALLINT NOT NULL);
8870 CREATE TABLE t4 (c1 SMALLINT NOT NULL);
8871 CREATE TABLE t5 (c1 SMALLINT NOT NULL);
8872 CREATE TABLE t6 (c1 SMALLINT NOT NULL);
8873 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
8874 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
8875 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
8876 INSERT INTO t4 (c1) VALUES(10);
8877 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
8878 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 USING (c1);
8890 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1;
8902 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 <=> 5;
8905 DROP TABLE t1,t2,t3,t4,t5,t6;
8906 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
8907 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
8908 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
8909 CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
8910 CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
8911 CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
8912 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
8913 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
8914 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
8915 INSERT INTO t4 (c1) VALUES(10);
8916 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
8917 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 USING (c1);
8929 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1;
8941 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 <=> 5;
8944 DROP TABLE t1,t2,t3,t4,t5,t6;
8945 CREATE TABLE t1 (c1 INT NOT NULL);
8946 CREATE TABLE t2 (c1 INT NOT NULL);
8947 CREATE TABLE t3 (c1 INT NOT NULL);
8948 CREATE TABLE t4 (c1 INT NOT NULL);
8949 CREATE TABLE t5 (c1 INT NOT NULL);
8950 CREATE TABLE t6 (c1 INT NOT NULL);
8951 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
8952 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
8953 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
8954 INSERT INTO t4 (c1) VALUES(10);
8955 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
8956 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 USING (c1);
8968 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1;
8980 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 <=> 5;
8983 DROP TABLE t1,t2,t3,t4,t5,t6;
8984 CREATE TABLE t1 (c1 INTEGER NOT NULL);
8985 CREATE TABLE t2 (c1 INTEGER NOT NULL);
8986 CREATE TABLE t3 (c1 INTEGER NOT NULL);
8987 CREATE TABLE t4 (c1 INTEGER NOT NULL);
8988 CREATE TABLE t5 (c1 INTEGER NOT NULL);
8989 CREATE TABLE t6 (c1 INTEGER NOT NULL);
8990 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
8991 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
8992 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
8993 INSERT INTO t4 (c1) VALUES(10);
8994 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
8995 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 USING (c1);
9007 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1;
9019 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 <=> 5;
9022 DROP TABLE t1,t2,t3,t4,t5,t6;
9023 CREATE TABLE t1 (c1 BIGINT NOT NULL);
9024 CREATE TABLE t2 (c1 BIGINT NOT NULL);
9025 CREATE TABLE t3 (c1 BIGINT NOT NULL);
9026 CREATE TABLE t4 (c1 BIGINT NOT NULL);
9027 CREATE TABLE t5 (c1 BIGINT NOT NULL);
9028 CREATE TABLE t6 (c1 BIGINT NOT NULL);
9029 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
9030 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
9031 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
9032 INSERT INTO t4 (c1) VALUES(10);
9033 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
9034 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 USING (c1);
9046 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1;
9058 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 <=> 5;
9061 DROP TABLE t1,t2,t3,t4,t5,t6;