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;