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 NATURAL LEFT OUTER JOIN t2;
25
SELECT t1.c1,t2.c1 FROM t1 NATURAL LEFT OUTER JOIN t2 WHERE t1.c1 < 5;
32
DROP TABLE t1,t2,t3,t4,t5,t6;
33
CREATE TABLE t1 (c1 SMALLINT NOT NULL);
34
CREATE TABLE t2 (c1 SMALLINT NOT NULL);
35
CREATE TABLE t3 (c1 SMALLINT NOT NULL);
36
CREATE TABLE t4 (c1 SMALLINT NOT NULL);
37
CREATE TABLE t5 (c1 SMALLINT NOT NULL);
38
CREATE TABLE t6 (c1 SMALLINT NOT NULL);
39
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
40
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
41
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
42
INSERT INTO t4 (c1) VALUES(10);
43
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
44
SELECT t1.c1,t2.c1 FROM t1 NATURAL LEFT OUTER JOIN t2;
56
SELECT t1.c1,t2.c1 FROM t1 NATURAL LEFT OUTER JOIN t2 WHERE t1.c1 < 5;
63
DROP TABLE t1,t2,t3,t4,t5,t6;
64
CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
65
CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
66
CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
67
CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
68
CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
69
CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
70
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
71
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
72
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
73
INSERT INTO t4 (c1) VALUES(10);
74
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
75
SELECT t1.c1,t2.c1 FROM t1 NATURAL LEFT OUTER JOIN t2;
87
SELECT t1.c1,t2.c1 FROM t1 NATURAL LEFT OUTER JOIN t2 WHERE t1.c1 < 5;
94
DROP TABLE t1,t2,t3,t4,t5,t6;
95
CREATE TABLE t1 (c1 INT NOT NULL);
96
CREATE TABLE t2 (c1 INT NOT NULL);
97
CREATE TABLE t3 (c1 INT NOT NULL);
98
CREATE TABLE t4 (c1 INT NOT NULL);
99
CREATE TABLE t5 (c1 INT NOT NULL);
100
CREATE TABLE t6 (c1 INT NOT NULL);
101
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
102
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
103
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
104
INSERT INTO t4 (c1) VALUES(10);
105
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
106
SELECT t1.c1,t2.c1 FROM t1 NATURAL LEFT OUTER JOIN t2;
118
SELECT t1.c1,t2.c1 FROM t1 NATURAL LEFT OUTER JOIN t2 WHERE t1.c1 < 5;
125
DROP TABLE t1,t2,t3,t4,t5,t6;
126
CREATE TABLE t1 (c1 INTEGER NOT NULL);
127
CREATE TABLE t2 (c1 INTEGER NOT NULL);
128
CREATE TABLE t3 (c1 INTEGER NOT NULL);
129
CREATE TABLE t4 (c1 INTEGER NOT NULL);
130
CREATE TABLE t5 (c1 INTEGER NOT NULL);
131
CREATE TABLE t6 (c1 INTEGER NOT NULL);
132
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
133
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
134
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
135
INSERT INTO t4 (c1) VALUES(10);
136
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
137
SELECT t1.c1,t2.c1 FROM t1 NATURAL LEFT OUTER JOIN t2;
149
SELECT t1.c1,t2.c1 FROM t1 NATURAL LEFT OUTER JOIN t2 WHERE t1.c1 < 5;
156
DROP TABLE t1,t2,t3,t4,t5,t6;
157
CREATE TABLE t1 (c1 BIGINT NOT NULL);
158
CREATE TABLE t2 (c1 BIGINT NOT NULL);
159
CREATE TABLE t3 (c1 BIGINT NOT NULL);
160
CREATE TABLE t4 (c1 BIGINT NOT NULL);
161
CREATE TABLE t5 (c1 BIGINT NOT NULL);
162
CREATE TABLE t6 (c1 BIGINT NOT NULL);
163
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
164
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
165
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
166
INSERT INTO t4 (c1) VALUES(10);
167
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
168
SELECT t1.c1,t2.c1 FROM t1 NATURAL LEFT OUTER JOIN t2;
180
SELECT t1.c1,t2.c1 FROM t1 NATURAL LEFT OUTER JOIN t2 WHERE t1.c1 < 5;
187
DROP TABLE t1,t2,t3,t4,t5,t6;
188
CREATE TABLE t1 (c1 TINYINT NOT NULL);
189
CREATE TABLE t2 (c1 TINYINT NOT NULL);
190
CREATE TABLE t3 (c1 TINYINT NOT NULL);
191
CREATE TABLE t4 (c1 TINYINT NOT NULL);
192
CREATE TABLE t5 (c1 TINYINT NOT NULL);
193
CREATE TABLE t6 (c1 TINYINT NOT NULL);
194
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
195
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
196
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
197
INSERT INTO t4 (c1) VALUES(10);
198
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
199
SELECT t1.c1,t3.c1 FROM t1 NATURAL LEFT OUTER JOIN t3;
211
SELECT t1.c1,t3.c1 FROM t1 NATURAL LEFT OUTER JOIN t3 WHERE t1.c1 < 5;
218
DROP TABLE t1,t2,t3,t4,t5,t6;
219
CREATE TABLE t1 (c1 SMALLINT NOT NULL);
220
CREATE TABLE t2 (c1 SMALLINT NOT NULL);
221
CREATE TABLE t3 (c1 SMALLINT NOT NULL);
222
CREATE TABLE t4 (c1 SMALLINT NOT NULL);
223
CREATE TABLE t5 (c1 SMALLINT NOT NULL);
224
CREATE TABLE t6 (c1 SMALLINT NOT NULL);
225
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
226
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
227
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
228
INSERT INTO t4 (c1) VALUES(10);
229
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
230
SELECT t1.c1,t3.c1 FROM t1 NATURAL LEFT OUTER JOIN t3;
242
SELECT t1.c1,t3.c1 FROM t1 NATURAL LEFT OUTER JOIN t3 WHERE t1.c1 < 5;
249
DROP TABLE t1,t2,t3,t4,t5,t6;
250
CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
251
CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
252
CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
253
CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
254
CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
255
CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
256
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
257
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
258
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
259
INSERT INTO t4 (c1) VALUES(10);
260
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
261
SELECT t1.c1,t3.c1 FROM t1 NATURAL LEFT OUTER JOIN t3;
273
SELECT t1.c1,t3.c1 FROM t1 NATURAL LEFT OUTER JOIN t3 WHERE t1.c1 < 5;
280
DROP TABLE t1,t2,t3,t4,t5,t6;
281
CREATE TABLE t1 (c1 INT NOT NULL);
282
CREATE TABLE t2 (c1 INT NOT NULL);
283
CREATE TABLE t3 (c1 INT NOT NULL);
284
CREATE TABLE t4 (c1 INT NOT NULL);
285
CREATE TABLE t5 (c1 INT NOT NULL);
286
CREATE TABLE t6 (c1 INT NOT NULL);
287
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
288
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
289
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
290
INSERT INTO t4 (c1) VALUES(10);
291
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
292
SELECT t1.c1,t3.c1 FROM t1 NATURAL LEFT OUTER JOIN t3;
304
SELECT t1.c1,t3.c1 FROM t1 NATURAL LEFT OUTER JOIN t3 WHERE t1.c1 < 5;
311
DROP TABLE t1,t2,t3,t4,t5,t6;
312
CREATE TABLE t1 (c1 INTEGER NOT NULL);
313
CREATE TABLE t2 (c1 INTEGER NOT NULL);
314
CREATE TABLE t3 (c1 INTEGER NOT NULL);
315
CREATE TABLE t4 (c1 INTEGER NOT NULL);
316
CREATE TABLE t5 (c1 INTEGER NOT NULL);
317
CREATE TABLE t6 (c1 INTEGER NOT NULL);
318
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
319
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
320
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
321
INSERT INTO t4 (c1) VALUES(10);
322
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
323
SELECT t1.c1,t3.c1 FROM t1 NATURAL LEFT OUTER JOIN t3;
335
SELECT t1.c1,t3.c1 FROM t1 NATURAL LEFT OUTER JOIN t3 WHERE t1.c1 < 5;
342
DROP TABLE t1,t2,t3,t4,t5,t6;
343
CREATE TABLE t1 (c1 BIGINT NOT NULL);
344
CREATE TABLE t2 (c1 BIGINT NOT NULL);
345
CREATE TABLE t3 (c1 BIGINT NOT NULL);
346
CREATE TABLE t4 (c1 BIGINT NOT NULL);
347
CREATE TABLE t5 (c1 BIGINT NOT NULL);
348
CREATE TABLE t6 (c1 BIGINT NOT NULL);
349
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
350
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
351
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
352
INSERT INTO t4 (c1) VALUES(10);
353
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
354
SELECT t1.c1,t3.c1 FROM t1 NATURAL LEFT OUTER JOIN t3;
366
SELECT t1.c1,t3.c1 FROM t1 NATURAL LEFT OUTER JOIN t3 WHERE t1.c1 < 5;
373
DROP TABLE t1,t2,t3,t4,t5,t6;
374
CREATE TABLE t1 (c1 TINYINT NOT NULL);
375
CREATE TABLE t2 (c1 TINYINT NOT NULL);
376
CREATE TABLE t3 (c1 TINYINT NOT NULL);
377
CREATE TABLE t4 (c1 TINYINT NOT NULL);
378
CREATE TABLE t5 (c1 TINYINT NOT NULL);
379
CREATE TABLE t6 (c1 TINYINT NOT NULL);
380
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
381
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
382
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
383
INSERT INTO t4 (c1) VALUES(10);
384
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
385
SELECT t1.c1,t4.c1 FROM t1 NATURAL LEFT OUTER JOIN t4;
397
SELECT t1.c1,t4.c1 FROM t1 NATURAL LEFT OUTER JOIN t4 WHERE t1.c1 < 5;
404
DROP TABLE t1,t2,t3,t4,t5,t6;
405
CREATE TABLE t1 (c1 SMALLINT NOT NULL);
406
CREATE TABLE t2 (c1 SMALLINT NOT NULL);
407
CREATE TABLE t3 (c1 SMALLINT NOT NULL);
408
CREATE TABLE t4 (c1 SMALLINT NOT NULL);
409
CREATE TABLE t5 (c1 SMALLINT NOT NULL);
410
CREATE TABLE t6 (c1 SMALLINT NOT NULL);
411
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
412
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
413
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
414
INSERT INTO t4 (c1) VALUES(10);
415
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
416
SELECT t1.c1,t4.c1 FROM t1 NATURAL LEFT OUTER JOIN t4;
428
SELECT t1.c1,t4.c1 FROM t1 NATURAL LEFT OUTER JOIN t4 WHERE t1.c1 < 5;
435
DROP TABLE t1,t2,t3,t4,t5,t6;
436
CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
437
CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
438
CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
439
CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
440
CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
441
CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
442
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
443
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
444
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
445
INSERT INTO t4 (c1) VALUES(10);
446
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
447
SELECT t1.c1,t4.c1 FROM t1 NATURAL LEFT OUTER JOIN t4;
459
SELECT t1.c1,t4.c1 FROM t1 NATURAL LEFT OUTER JOIN t4 WHERE t1.c1 < 5;
466
DROP TABLE t1,t2,t3,t4,t5,t6;
467
CREATE TABLE t1 (c1 INT NOT NULL);
468
CREATE TABLE t2 (c1 INT NOT NULL);
469
CREATE TABLE t3 (c1 INT NOT NULL);
470
CREATE TABLE t4 (c1 INT NOT NULL);
471
CREATE TABLE t5 (c1 INT NOT NULL);
472
CREATE TABLE t6 (c1 INT NOT NULL);
473
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
474
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
475
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
476
INSERT INTO t4 (c1) VALUES(10);
477
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
478
SELECT t1.c1,t4.c1 FROM t1 NATURAL LEFT OUTER JOIN t4;
490
SELECT t1.c1,t4.c1 FROM t1 NATURAL LEFT OUTER JOIN t4 WHERE t1.c1 < 5;
497
DROP TABLE t1,t2,t3,t4,t5,t6;
498
CREATE TABLE t1 (c1 INTEGER NOT NULL);
499
CREATE TABLE t2 (c1 INTEGER NOT NULL);
500
CREATE TABLE t3 (c1 INTEGER NOT NULL);
501
CREATE TABLE t4 (c1 INTEGER NOT NULL);
502
CREATE TABLE t5 (c1 INTEGER NOT NULL);
503
CREATE TABLE t6 (c1 INTEGER NOT NULL);
504
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
505
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
506
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
507
INSERT INTO t4 (c1) VALUES(10);
508
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
509
SELECT t1.c1,t4.c1 FROM t1 NATURAL LEFT OUTER JOIN t4;
521
SELECT t1.c1,t4.c1 FROM t1 NATURAL LEFT OUTER JOIN t4 WHERE t1.c1 < 5;
528
DROP TABLE t1,t2,t3,t4,t5,t6;
529
CREATE TABLE t1 (c1 BIGINT NOT NULL);
530
CREATE TABLE t2 (c1 BIGINT NOT NULL);
531
CREATE TABLE t3 (c1 BIGINT NOT NULL);
532
CREATE TABLE t4 (c1 BIGINT NOT NULL);
533
CREATE TABLE t5 (c1 BIGINT NOT NULL);
534
CREATE TABLE t6 (c1 BIGINT NOT NULL);
535
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
536
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
537
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
538
INSERT INTO t4 (c1) VALUES(10);
539
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
540
SELECT t1.c1,t4.c1 FROM t1 NATURAL LEFT OUTER JOIN t4;
552
SELECT t1.c1,t4.c1 FROM t1 NATURAL LEFT OUTER JOIN t4 WHERE t1.c1 < 5;
559
DROP TABLE t1,t2,t3,t4,t5,t6;
560
CREATE TABLE t1 (c1 TINYINT NOT NULL);
561
CREATE TABLE t2 (c1 TINYINT NOT NULL);
562
CREATE TABLE t3 (c1 TINYINT NOT NULL);
563
CREATE TABLE t4 (c1 TINYINT NOT NULL);
564
CREATE TABLE t5 (c1 TINYINT NOT NULL);
565
CREATE TABLE t6 (c1 TINYINT NOT NULL);
566
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
567
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
568
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
569
INSERT INTO t4 (c1) VALUES(10);
570
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
571
SELECT t1.c1,t5.c1 FROM t1 NATURAL LEFT OUTER JOIN t5;
583
SELECT t1.c1,t5.c1 FROM t1 NATURAL LEFT OUTER JOIN t5 WHERE t1.c1 < 5;
590
DROP TABLE t1,t2,t3,t4,t5,t6;
591
CREATE TABLE t1 (c1 SMALLINT NOT NULL);
592
CREATE TABLE t2 (c1 SMALLINT NOT NULL);
593
CREATE TABLE t3 (c1 SMALLINT NOT NULL);
594
CREATE TABLE t4 (c1 SMALLINT NOT NULL);
595
CREATE TABLE t5 (c1 SMALLINT NOT NULL);
596
CREATE TABLE t6 (c1 SMALLINT NOT NULL);
597
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
598
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
599
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
600
INSERT INTO t4 (c1) VALUES(10);
601
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
602
SELECT t1.c1,t5.c1 FROM t1 NATURAL LEFT OUTER JOIN t5;
614
SELECT t1.c1,t5.c1 FROM t1 NATURAL LEFT OUTER JOIN t5 WHERE t1.c1 < 5;
621
DROP TABLE t1,t2,t3,t4,t5,t6;
622
CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
623
CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
624
CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
625
CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
626
CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
627
CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
628
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
629
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
630
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
631
INSERT INTO t4 (c1) VALUES(10);
632
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
633
SELECT t1.c1,t5.c1 FROM t1 NATURAL LEFT OUTER JOIN t5;
645
SELECT t1.c1,t5.c1 FROM t1 NATURAL LEFT OUTER JOIN t5 WHERE t1.c1 < 5;
652
DROP TABLE t1,t2,t3,t4,t5,t6;
653
CREATE TABLE t1 (c1 INT NOT NULL);
654
CREATE TABLE t2 (c1 INT NOT NULL);
655
CREATE TABLE t3 (c1 INT NOT NULL);
656
CREATE TABLE t4 (c1 INT NOT NULL);
657
CREATE TABLE t5 (c1 INT NOT NULL);
658
CREATE TABLE t6 (c1 INT NOT NULL);
659
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
660
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
661
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
662
INSERT INTO t4 (c1) VALUES(10);
663
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
664
SELECT t1.c1,t5.c1 FROM t1 NATURAL LEFT OUTER JOIN t5;
676
SELECT t1.c1,t5.c1 FROM t1 NATURAL LEFT OUTER JOIN t5 WHERE t1.c1 < 5;
683
DROP TABLE t1,t2,t3,t4,t5,t6;
684
CREATE TABLE t1 (c1 INTEGER NOT NULL);
685
CREATE TABLE t2 (c1 INTEGER NOT NULL);
686
CREATE TABLE t3 (c1 INTEGER NOT NULL);
687
CREATE TABLE t4 (c1 INTEGER NOT NULL);
688
CREATE TABLE t5 (c1 INTEGER NOT NULL);
689
CREATE TABLE t6 (c1 INTEGER NOT NULL);
690
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
691
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
692
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
693
INSERT INTO t4 (c1) VALUES(10);
694
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
695
SELECT t1.c1,t5.c1 FROM t1 NATURAL LEFT OUTER JOIN t5;
707
SELECT t1.c1,t5.c1 FROM t1 NATURAL LEFT OUTER JOIN t5 WHERE t1.c1 < 5;
714
DROP TABLE t1,t2,t3,t4,t5,t6;
715
CREATE TABLE t1 (c1 BIGINT NOT NULL);
716
CREATE TABLE t2 (c1 BIGINT NOT NULL);
717
CREATE TABLE t3 (c1 BIGINT NOT NULL);
718
CREATE TABLE t4 (c1 BIGINT NOT NULL);
719
CREATE TABLE t5 (c1 BIGINT NOT NULL);
720
CREATE TABLE t6 (c1 BIGINT NOT NULL);
721
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
722
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
723
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
724
INSERT INTO t4 (c1) VALUES(10);
725
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
726
SELECT t1.c1,t5.c1 FROM t1 NATURAL LEFT OUTER JOIN t5;
738
SELECT t1.c1,t5.c1 FROM t1 NATURAL LEFT OUTER JOIN t5 WHERE t1.c1 < 5;
745
DROP TABLE t1,t2,t3,t4,t5,t6;
746
CREATE TABLE t1 (c1 TINYINT NOT NULL);
747
CREATE TABLE t2 (c1 TINYINT NOT NULL);
748
CREATE TABLE t3 (c1 TINYINT NOT NULL);
749
CREATE TABLE t4 (c1 TINYINT NOT NULL);
750
CREATE TABLE t5 (c1 TINYINT NOT NULL);
751
CREATE TABLE t6 (c1 TINYINT NOT NULL);
752
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
753
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
754
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
755
INSERT INTO t4 (c1) VALUES(10);
756
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
757
SELECT t1.c1,t6.c1 FROM t1 NATURAL LEFT OUTER JOIN t6;
769
SELECT t1.c1,t6.c1 FROM t1 NATURAL LEFT OUTER JOIN t6 WHERE t1.c1 < 5;
776
DROP TABLE t1,t2,t3,t4,t5,t6;
777
CREATE TABLE t1 (c1 SMALLINT NOT NULL);
778
CREATE TABLE t2 (c1 SMALLINT NOT NULL);
779
CREATE TABLE t3 (c1 SMALLINT NOT NULL);
780
CREATE TABLE t4 (c1 SMALLINT NOT NULL);
781
CREATE TABLE t5 (c1 SMALLINT NOT NULL);
782
CREATE TABLE t6 (c1 SMALLINT NOT NULL);
783
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
784
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
785
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
786
INSERT INTO t4 (c1) VALUES(10);
787
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
788
SELECT t1.c1,t6.c1 FROM t1 NATURAL LEFT OUTER JOIN t6;
800
SELECT t1.c1,t6.c1 FROM t1 NATURAL LEFT OUTER JOIN t6 WHERE t1.c1 < 5;
807
DROP TABLE t1,t2,t3,t4,t5,t6;
808
CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
809
CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
810
CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
811
CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
812
CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
813
CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
814
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
815
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
816
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
817
INSERT INTO t4 (c1) VALUES(10);
818
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
819
SELECT t1.c1,t6.c1 FROM t1 NATURAL LEFT OUTER JOIN t6;
831
SELECT t1.c1,t6.c1 FROM t1 NATURAL LEFT OUTER JOIN t6 WHERE t1.c1 < 5;
838
DROP TABLE t1,t2,t3,t4,t5,t6;
839
CREATE TABLE t1 (c1 INT NOT NULL);
840
CREATE TABLE t2 (c1 INT NOT NULL);
841
CREATE TABLE t3 (c1 INT NOT NULL);
842
CREATE TABLE t4 (c1 INT NOT NULL);
843
CREATE TABLE t5 (c1 INT NOT NULL);
844
CREATE TABLE t6 (c1 INT NOT NULL);
845
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
846
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
847
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
848
INSERT INTO t4 (c1) VALUES(10);
849
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
850
SELECT t1.c1,t6.c1 FROM t1 NATURAL LEFT OUTER JOIN t6;
862
SELECT t1.c1,t6.c1 FROM t1 NATURAL LEFT OUTER JOIN t6 WHERE t1.c1 < 5;
869
DROP TABLE t1,t2,t3,t4,t5,t6;
870
CREATE TABLE t1 (c1 INTEGER NOT NULL);
871
CREATE TABLE t2 (c1 INTEGER NOT NULL);
872
CREATE TABLE t3 (c1 INTEGER NOT NULL);
873
CREATE TABLE t4 (c1 INTEGER NOT NULL);
874
CREATE TABLE t5 (c1 INTEGER NOT NULL);
875
CREATE TABLE t6 (c1 INTEGER NOT NULL);
876
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
877
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
878
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
879
INSERT INTO t4 (c1) VALUES(10);
880
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
881
SELECT t1.c1,t6.c1 FROM t1 NATURAL LEFT OUTER JOIN t6;
893
SELECT t1.c1,t6.c1 FROM t1 NATURAL LEFT OUTER JOIN t6 WHERE t1.c1 < 5;
900
DROP TABLE t1,t2,t3,t4,t5,t6;
901
CREATE TABLE t1 (c1 BIGINT NOT NULL);
902
CREATE TABLE t2 (c1 BIGINT NOT NULL);
903
CREATE TABLE t3 (c1 BIGINT NOT NULL);
904
CREATE TABLE t4 (c1 BIGINT NOT NULL);
905
CREATE TABLE t5 (c1 BIGINT NOT NULL);
906
CREATE TABLE t6 (c1 BIGINT NOT NULL);
907
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
908
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
909
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
910
INSERT INTO t4 (c1) VALUES(10);
911
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
912
SELECT t1.c1,t6.c1 FROM t1 NATURAL LEFT OUTER JOIN t6;
924
SELECT t1.c1,t6.c1 FROM t1 NATURAL LEFT OUTER JOIN t6 WHERE t1.c1 < 5;
931
DROP TABLE t1,t2,t3,t4,t5,t6;
932
CREATE TABLE t1 (c1 TINYINT NOT NULL);
933
CREATE TABLE t2 (c1 TINYINT NOT NULL);
934
CREATE TABLE t3 (c1 TINYINT NOT NULL);
935
CREATE TABLE t4 (c1 TINYINT NOT NULL);
936
CREATE TABLE t5 (c1 TINYINT NOT NULL);
937
CREATE TABLE t6 (c1 TINYINT NOT NULL);
938
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
939
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
940
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
941
INSERT INTO t4 (c1) VALUES(10);
942
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
943
SELECT t1.c1,t2.c1 FROM t1 NATURAL LEFT OUTER JOIN t2;
955
SELECT t1.c1,t2.c1 FROM t1 NATURAL LEFT OUTER JOIN t2 WHERE t1.c1 <= 5;
963
DROP TABLE t1,t2,t3,t4,t5,t6;
964
CREATE TABLE t1 (c1 SMALLINT NOT NULL);
965
CREATE TABLE t2 (c1 SMALLINT NOT NULL);
966
CREATE TABLE t3 (c1 SMALLINT NOT NULL);
967
CREATE TABLE t4 (c1 SMALLINT NOT NULL);
968
CREATE TABLE t5 (c1 SMALLINT NOT NULL);
969
CREATE TABLE t6 (c1 SMALLINT NOT NULL);
970
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
971
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
972
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
973
INSERT INTO t4 (c1) VALUES(10);
974
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
975
SELECT t1.c1,t2.c1 FROM t1 NATURAL LEFT OUTER JOIN t2;
987
SELECT t1.c1,t2.c1 FROM t1 NATURAL LEFT OUTER JOIN t2 WHERE t1.c1 <= 5;
995
DROP TABLE t1,t2,t3,t4,t5,t6;
996
CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
997
CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
998
CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
999
CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
1000
CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
1001
CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
1002
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1003
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1004
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1005
INSERT INTO t4 (c1) VALUES(10);
1006
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1007
SELECT t1.c1,t2.c1 FROM t1 NATURAL LEFT OUTER JOIN t2;
1019
SELECT t1.c1,t2.c1 FROM t1 NATURAL LEFT OUTER JOIN t2 WHERE t1.c1 <= 5;
1027
DROP TABLE t1,t2,t3,t4,t5,t6;
1028
CREATE TABLE t1 (c1 INT NOT NULL);
1029
CREATE TABLE t2 (c1 INT NOT NULL);
1030
CREATE TABLE t3 (c1 INT NOT NULL);
1031
CREATE TABLE t4 (c1 INT NOT NULL);
1032
CREATE TABLE t5 (c1 INT NOT NULL);
1033
CREATE TABLE t6 (c1 INT NOT NULL);
1034
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1035
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1036
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1037
INSERT INTO t4 (c1) VALUES(10);
1038
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1039
SELECT t1.c1,t2.c1 FROM t1 NATURAL LEFT OUTER JOIN t2;
1051
SELECT t1.c1,t2.c1 FROM t1 NATURAL LEFT OUTER JOIN t2 WHERE t1.c1 <= 5;
1059
DROP TABLE t1,t2,t3,t4,t5,t6;
1060
CREATE TABLE t1 (c1 INTEGER NOT NULL);
1061
CREATE TABLE t2 (c1 INTEGER NOT NULL);
1062
CREATE TABLE t3 (c1 INTEGER NOT NULL);
1063
CREATE TABLE t4 (c1 INTEGER NOT NULL);
1064
CREATE TABLE t5 (c1 INTEGER NOT NULL);
1065
CREATE TABLE t6 (c1 INTEGER NOT NULL);
1066
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1067
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1068
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1069
INSERT INTO t4 (c1) VALUES(10);
1070
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1071
SELECT t1.c1,t2.c1 FROM t1 NATURAL LEFT OUTER JOIN t2;
1083
SELECT t1.c1,t2.c1 FROM t1 NATURAL LEFT OUTER JOIN t2 WHERE t1.c1 <= 5;
1091
DROP TABLE t1,t2,t3,t4,t5,t6;
1092
CREATE TABLE t1 (c1 BIGINT NOT NULL);
1093
CREATE TABLE t2 (c1 BIGINT NOT NULL);
1094
CREATE TABLE t3 (c1 BIGINT NOT NULL);
1095
CREATE TABLE t4 (c1 BIGINT NOT NULL);
1096
CREATE TABLE t5 (c1 BIGINT NOT NULL);
1097
CREATE TABLE t6 (c1 BIGINT NOT NULL);
1098
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1099
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1100
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1101
INSERT INTO t4 (c1) VALUES(10);
1102
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1103
SELECT t1.c1,t2.c1 FROM t1 NATURAL LEFT OUTER JOIN t2;
1115
SELECT t1.c1,t2.c1 FROM t1 NATURAL LEFT OUTER JOIN t2 WHERE t1.c1 <= 5;
1123
DROP TABLE t1,t2,t3,t4,t5,t6;
1124
CREATE TABLE t1 (c1 TINYINT NOT NULL);
1125
CREATE TABLE t2 (c1 TINYINT NOT NULL);
1126
CREATE TABLE t3 (c1 TINYINT NOT NULL);
1127
CREATE TABLE t4 (c1 TINYINT NOT NULL);
1128
CREATE TABLE t5 (c1 TINYINT NOT NULL);
1129
CREATE TABLE t6 (c1 TINYINT NOT NULL);
1130
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1131
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1132
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1133
INSERT INTO t4 (c1) VALUES(10);
1134
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1135
SELECT t1.c1,t3.c1 FROM t1 NATURAL LEFT OUTER JOIN t3;
1147
SELECT t1.c1,t3.c1 FROM t1 NATURAL LEFT OUTER JOIN t3 WHERE t1.c1 <= 5;
1155
DROP TABLE t1,t2,t3,t4,t5,t6;
1156
CREATE TABLE t1 (c1 SMALLINT NOT NULL);
1157
CREATE TABLE t2 (c1 SMALLINT NOT NULL);
1158
CREATE TABLE t3 (c1 SMALLINT NOT NULL);
1159
CREATE TABLE t4 (c1 SMALLINT NOT NULL);
1160
CREATE TABLE t5 (c1 SMALLINT NOT NULL);
1161
CREATE TABLE t6 (c1 SMALLINT NOT NULL);
1162
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1163
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1164
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1165
INSERT INTO t4 (c1) VALUES(10);
1166
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1167
SELECT t1.c1,t3.c1 FROM t1 NATURAL LEFT OUTER JOIN t3;
1179
SELECT t1.c1,t3.c1 FROM t1 NATURAL LEFT OUTER JOIN t3 WHERE t1.c1 <= 5;
1187
DROP TABLE t1,t2,t3,t4,t5,t6;
1188
CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
1189
CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
1190
CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
1191
CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
1192
CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
1193
CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
1194
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1195
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1196
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1197
INSERT INTO t4 (c1) VALUES(10);
1198
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1199
SELECT t1.c1,t3.c1 FROM t1 NATURAL LEFT OUTER JOIN t3;
1211
SELECT t1.c1,t3.c1 FROM t1 NATURAL LEFT OUTER JOIN t3 WHERE t1.c1 <= 5;
1219
DROP TABLE t1,t2,t3,t4,t5,t6;
1220
CREATE TABLE t1 (c1 INT NOT NULL);
1221
CREATE TABLE t2 (c1 INT NOT NULL);
1222
CREATE TABLE t3 (c1 INT NOT NULL);
1223
CREATE TABLE t4 (c1 INT NOT NULL);
1224
CREATE TABLE t5 (c1 INT NOT NULL);
1225
CREATE TABLE t6 (c1 INT NOT NULL);
1226
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1227
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1228
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1229
INSERT INTO t4 (c1) VALUES(10);
1230
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1231
SELECT t1.c1,t3.c1 FROM t1 NATURAL LEFT OUTER JOIN t3;
1243
SELECT t1.c1,t3.c1 FROM t1 NATURAL LEFT OUTER JOIN t3 WHERE t1.c1 <= 5;
1251
DROP TABLE t1,t2,t3,t4,t5,t6;
1252
CREATE TABLE t1 (c1 INTEGER NOT NULL);
1253
CREATE TABLE t2 (c1 INTEGER NOT NULL);
1254
CREATE TABLE t3 (c1 INTEGER NOT NULL);
1255
CREATE TABLE t4 (c1 INTEGER NOT NULL);
1256
CREATE TABLE t5 (c1 INTEGER NOT NULL);
1257
CREATE TABLE t6 (c1 INTEGER NOT NULL);
1258
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1259
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1260
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1261
INSERT INTO t4 (c1) VALUES(10);
1262
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1263
SELECT t1.c1,t3.c1 FROM t1 NATURAL LEFT OUTER JOIN t3;
1275
SELECT t1.c1,t3.c1 FROM t1 NATURAL LEFT OUTER JOIN t3 WHERE t1.c1 <= 5;
1283
DROP TABLE t1,t2,t3,t4,t5,t6;
1284
CREATE TABLE t1 (c1 BIGINT NOT NULL);
1285
CREATE TABLE t2 (c1 BIGINT NOT NULL);
1286
CREATE TABLE t3 (c1 BIGINT NOT NULL);
1287
CREATE TABLE t4 (c1 BIGINT NOT NULL);
1288
CREATE TABLE t5 (c1 BIGINT NOT NULL);
1289
CREATE TABLE t6 (c1 BIGINT NOT NULL);
1290
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1291
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1292
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1293
INSERT INTO t4 (c1) VALUES(10);
1294
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1295
SELECT t1.c1,t3.c1 FROM t1 NATURAL LEFT OUTER JOIN t3;
1307
SELECT t1.c1,t3.c1 FROM t1 NATURAL LEFT OUTER JOIN t3 WHERE t1.c1 <= 5;
1315
DROP TABLE t1,t2,t3,t4,t5,t6;
1316
CREATE TABLE t1 (c1 TINYINT NOT NULL);
1317
CREATE TABLE t2 (c1 TINYINT NOT NULL);
1318
CREATE TABLE t3 (c1 TINYINT NOT NULL);
1319
CREATE TABLE t4 (c1 TINYINT NOT NULL);
1320
CREATE TABLE t5 (c1 TINYINT NOT NULL);
1321
CREATE TABLE t6 (c1 TINYINT NOT NULL);
1322
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1323
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1324
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1325
INSERT INTO t4 (c1) VALUES(10);
1326
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1327
SELECT t1.c1,t4.c1 FROM t1 NATURAL LEFT OUTER JOIN t4;
1339
SELECT t1.c1,t4.c1 FROM t1 NATURAL LEFT OUTER JOIN t4 WHERE t1.c1 <= 5;
1347
DROP TABLE t1,t2,t3,t4,t5,t6;
1348
CREATE TABLE t1 (c1 SMALLINT NOT NULL);
1349
CREATE TABLE t2 (c1 SMALLINT NOT NULL);
1350
CREATE TABLE t3 (c1 SMALLINT NOT NULL);
1351
CREATE TABLE t4 (c1 SMALLINT NOT NULL);
1352
CREATE TABLE t5 (c1 SMALLINT NOT NULL);
1353
CREATE TABLE t6 (c1 SMALLINT NOT NULL);
1354
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1355
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1356
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1357
INSERT INTO t4 (c1) VALUES(10);
1358
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1359
SELECT t1.c1,t4.c1 FROM t1 NATURAL LEFT OUTER JOIN t4;
1371
SELECT t1.c1,t4.c1 FROM t1 NATURAL LEFT OUTER JOIN t4 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,t4.c1 FROM t1 NATURAL LEFT OUTER JOIN t4;
1403
SELECT t1.c1,t4.c1 FROM t1 NATURAL LEFT OUTER JOIN t4 WHERE t1.c1 <= 5;
1411
DROP TABLE t1,t2,t3,t4,t5,t6;
1412
CREATE TABLE t1 (c1 INT NOT NULL);
1413
CREATE TABLE t2 (c1 INT NOT NULL);
1414
CREATE TABLE t3 (c1 INT NOT NULL);
1415
CREATE TABLE t4 (c1 INT NOT NULL);
1416
CREATE TABLE t5 (c1 INT NOT NULL);
1417
CREATE TABLE t6 (c1 INT NOT NULL);
1418
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1419
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1420
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1421
INSERT INTO t4 (c1) VALUES(10);
1422
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1423
SELECT t1.c1,t4.c1 FROM t1 NATURAL LEFT OUTER JOIN t4;
1435
SELECT t1.c1,t4.c1 FROM t1 NATURAL LEFT OUTER JOIN t4 WHERE t1.c1 <= 5;
1443
DROP TABLE t1,t2,t3,t4,t5,t6;
1444
CREATE TABLE t1 (c1 INTEGER NOT NULL);
1445
CREATE TABLE t2 (c1 INTEGER NOT NULL);
1446
CREATE TABLE t3 (c1 INTEGER NOT NULL);
1447
CREATE TABLE t4 (c1 INTEGER NOT NULL);
1448
CREATE TABLE t5 (c1 INTEGER NOT NULL);
1449
CREATE TABLE t6 (c1 INTEGER NOT NULL);
1450
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1451
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1452
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1453
INSERT INTO t4 (c1) VALUES(10);
1454
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1455
SELECT t1.c1,t4.c1 FROM t1 NATURAL LEFT OUTER JOIN t4;
1467
SELECT t1.c1,t4.c1 FROM t1 NATURAL LEFT OUTER JOIN t4 WHERE t1.c1 <= 5;
1475
DROP TABLE t1,t2,t3,t4,t5,t6;
1476
CREATE TABLE t1 (c1 BIGINT NOT NULL);
1477
CREATE TABLE t2 (c1 BIGINT NOT NULL);
1478
CREATE TABLE t3 (c1 BIGINT NOT NULL);
1479
CREATE TABLE t4 (c1 BIGINT NOT NULL);
1480
CREATE TABLE t5 (c1 BIGINT NOT NULL);
1481
CREATE TABLE t6 (c1 BIGINT NOT NULL);
1482
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1483
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1484
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1485
INSERT INTO t4 (c1) VALUES(10);
1486
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1487
SELECT t1.c1,t4.c1 FROM t1 NATURAL LEFT OUTER JOIN t4;
1499
SELECT t1.c1,t4.c1 FROM t1 NATURAL LEFT OUTER JOIN t4 WHERE t1.c1 <= 5;
1507
DROP TABLE t1,t2,t3,t4,t5,t6;
1508
CREATE TABLE t1 (c1 TINYINT NOT NULL);
1509
CREATE TABLE t2 (c1 TINYINT NOT NULL);
1510
CREATE TABLE t3 (c1 TINYINT NOT NULL);
1511
CREATE TABLE t4 (c1 TINYINT NOT NULL);
1512
CREATE TABLE t5 (c1 TINYINT NOT NULL);
1513
CREATE TABLE t6 (c1 TINYINT NOT NULL);
1514
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1515
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1516
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1517
INSERT INTO t4 (c1) VALUES(10);
1518
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1519
SELECT t1.c1,t5.c1 FROM t1 NATURAL LEFT OUTER JOIN t5;
1531
SELECT t1.c1,t5.c1 FROM t1 NATURAL LEFT OUTER JOIN t5 WHERE t1.c1 <= 5;
1539
DROP TABLE t1,t2,t3,t4,t5,t6;
1540
CREATE TABLE t1 (c1 SMALLINT NOT NULL);
1541
CREATE TABLE t2 (c1 SMALLINT NOT NULL);
1542
CREATE TABLE t3 (c1 SMALLINT NOT NULL);
1543
CREATE TABLE t4 (c1 SMALLINT NOT NULL);
1544
CREATE TABLE t5 (c1 SMALLINT NOT NULL);
1545
CREATE TABLE t6 (c1 SMALLINT NOT NULL);
1546
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1547
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1548
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1549
INSERT INTO t4 (c1) VALUES(10);
1550
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1551
SELECT t1.c1,t5.c1 FROM t1 NATURAL LEFT OUTER JOIN t5;
1563
SELECT t1.c1,t5.c1 FROM t1 NATURAL LEFT OUTER JOIN t5 WHERE t1.c1 <= 5;
1571
DROP TABLE t1,t2,t3,t4,t5,t6;
1572
CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
1573
CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
1574
CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
1575
CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
1576
CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
1577
CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
1578
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1579
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1580
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1581
INSERT INTO t4 (c1) VALUES(10);
1582
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1583
SELECT t1.c1,t5.c1 FROM t1 NATURAL LEFT OUTER JOIN t5;
1595
SELECT t1.c1,t5.c1 FROM t1 NATURAL LEFT OUTER JOIN t5 WHERE t1.c1 <= 5;
1603
DROP TABLE t1,t2,t3,t4,t5,t6;
1604
CREATE TABLE t1 (c1 INT NOT NULL);
1605
CREATE TABLE t2 (c1 INT NOT NULL);
1606
CREATE TABLE t3 (c1 INT NOT NULL);
1607
CREATE TABLE t4 (c1 INT NOT NULL);
1608
CREATE TABLE t5 (c1 INT NOT NULL);
1609
CREATE TABLE t6 (c1 INT NOT NULL);
1610
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1611
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1612
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1613
INSERT INTO t4 (c1) VALUES(10);
1614
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1615
SELECT t1.c1,t5.c1 FROM t1 NATURAL LEFT OUTER JOIN t5;
1627
SELECT t1.c1,t5.c1 FROM t1 NATURAL LEFT OUTER JOIN t5 WHERE t1.c1 <= 5;
1635
DROP TABLE t1,t2,t3,t4,t5,t6;
1636
CREATE TABLE t1 (c1 INTEGER NOT NULL);
1637
CREATE TABLE t2 (c1 INTEGER NOT NULL);
1638
CREATE TABLE t3 (c1 INTEGER NOT NULL);
1639
CREATE TABLE t4 (c1 INTEGER NOT NULL);
1640
CREATE TABLE t5 (c1 INTEGER NOT NULL);
1641
CREATE TABLE t6 (c1 INTEGER NOT NULL);
1642
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1643
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1644
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1645
INSERT INTO t4 (c1) VALUES(10);
1646
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1647
SELECT t1.c1,t5.c1 FROM t1 NATURAL LEFT OUTER JOIN t5;
1659
SELECT t1.c1,t5.c1 FROM t1 NATURAL LEFT OUTER JOIN t5 WHERE t1.c1 <= 5;
1667
DROP TABLE t1,t2,t3,t4,t5,t6;
1668
CREATE TABLE t1 (c1 BIGINT NOT NULL);
1669
CREATE TABLE t2 (c1 BIGINT NOT NULL);
1670
CREATE TABLE t3 (c1 BIGINT NOT NULL);
1671
CREATE TABLE t4 (c1 BIGINT NOT NULL);
1672
CREATE TABLE t5 (c1 BIGINT NOT NULL);
1673
CREATE TABLE t6 (c1 BIGINT NOT NULL);
1674
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1675
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1676
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1677
INSERT INTO t4 (c1) VALUES(10);
1678
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1679
SELECT t1.c1,t5.c1 FROM t1 NATURAL LEFT OUTER JOIN t5;
1691
SELECT t1.c1,t5.c1 FROM t1 NATURAL LEFT OUTER JOIN t5 WHERE t1.c1 <= 5;
1699
DROP TABLE t1,t2,t3,t4,t5,t6;
1700
CREATE TABLE t1 (c1 TINYINT NOT NULL);
1701
CREATE TABLE t2 (c1 TINYINT NOT NULL);
1702
CREATE TABLE t3 (c1 TINYINT NOT NULL);
1703
CREATE TABLE t4 (c1 TINYINT NOT NULL);
1704
CREATE TABLE t5 (c1 TINYINT NOT NULL);
1705
CREATE TABLE t6 (c1 TINYINT NOT NULL);
1706
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1707
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1708
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1709
INSERT INTO t4 (c1) VALUES(10);
1710
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1711
SELECT t1.c1,t6.c1 FROM t1 NATURAL LEFT OUTER JOIN t6;
1723
SELECT t1.c1,t6.c1 FROM t1 NATURAL LEFT OUTER JOIN t6 WHERE t1.c1 <= 5;
1731
DROP TABLE t1,t2,t3,t4,t5,t6;
1732
CREATE TABLE t1 (c1 SMALLINT NOT NULL);
1733
CREATE TABLE t2 (c1 SMALLINT NOT NULL);
1734
CREATE TABLE t3 (c1 SMALLINT NOT NULL);
1735
CREATE TABLE t4 (c1 SMALLINT NOT NULL);
1736
CREATE TABLE t5 (c1 SMALLINT NOT NULL);
1737
CREATE TABLE t6 (c1 SMALLINT 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,t6.c1 FROM t1 NATURAL LEFT OUTER JOIN t6;
1755
SELECT t1.c1,t6.c1 FROM t1 NATURAL LEFT OUTER JOIN t6 WHERE t1.c1 <= 5;
1763
DROP TABLE t1,t2,t3,t4,t5,t6;
1764
CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
1765
CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
1766
CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
1767
CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
1768
CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
1769
CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
1770
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1771
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1772
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1773
INSERT INTO t4 (c1) VALUES(10);
1774
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1775
SELECT t1.c1,t6.c1 FROM t1 NATURAL LEFT OUTER JOIN t6;
1787
SELECT t1.c1,t6.c1 FROM t1 NATURAL LEFT OUTER JOIN t6 WHERE t1.c1 <= 5;
1795
DROP TABLE t1,t2,t3,t4,t5,t6;
1796
CREATE TABLE t1 (c1 INT NOT NULL);
1797
CREATE TABLE t2 (c1 INT NOT NULL);
1798
CREATE TABLE t3 (c1 INT NOT NULL);
1799
CREATE TABLE t4 (c1 INT NOT NULL);
1800
CREATE TABLE t5 (c1 INT NOT NULL);
1801
CREATE TABLE t6 (c1 INT NOT NULL);
1802
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1803
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1804
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1805
INSERT INTO t4 (c1) VALUES(10);
1806
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1807
SELECT t1.c1,t6.c1 FROM t1 NATURAL LEFT OUTER JOIN t6;
1819
SELECT t1.c1,t6.c1 FROM t1 NATURAL LEFT OUTER JOIN t6 WHERE t1.c1 <= 5;
1827
DROP TABLE t1,t2,t3,t4,t5,t6;
1828
CREATE TABLE t1 (c1 INTEGER NOT NULL);
1829
CREATE TABLE t2 (c1 INTEGER NOT NULL);
1830
CREATE TABLE t3 (c1 INTEGER NOT NULL);
1831
CREATE TABLE t4 (c1 INTEGER NOT NULL);
1832
CREATE TABLE t5 (c1 INTEGER NOT NULL);
1833
CREATE TABLE t6 (c1 INTEGER NOT NULL);
1834
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1835
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1836
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1837
INSERT INTO t4 (c1) VALUES(10);
1838
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1839
SELECT t1.c1,t6.c1 FROM t1 NATURAL LEFT OUTER JOIN t6;
1851
SELECT t1.c1,t6.c1 FROM t1 NATURAL LEFT OUTER JOIN t6 WHERE t1.c1 <= 5;
1859
DROP TABLE t1,t2,t3,t4,t5,t6;
1860
CREATE TABLE t1 (c1 BIGINT NOT NULL);
1861
CREATE TABLE t2 (c1 BIGINT NOT NULL);
1862
CREATE TABLE t3 (c1 BIGINT NOT NULL);
1863
CREATE TABLE t4 (c1 BIGINT NOT NULL);
1864
CREATE TABLE t5 (c1 BIGINT NOT NULL);
1865
CREATE TABLE t6 (c1 BIGINT NOT NULL);
1866
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1867
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1868
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1869
INSERT INTO t4 (c1) VALUES(10);
1870
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1871
SELECT t1.c1,t6.c1 FROM t1 NATURAL LEFT OUTER JOIN t6;
1883
SELECT t1.c1,t6.c1 FROM t1 NATURAL LEFT OUTER JOIN t6 WHERE t1.c1 <= 5;
1891
DROP TABLE t1,t2,t3,t4,t5,t6;
1892
CREATE TABLE t1 (c1 TINYINT NOT NULL);
1893
CREATE TABLE t2 (c1 TINYINT NOT NULL);
1894
CREATE TABLE t3 (c1 TINYINT NOT NULL);
1895
CREATE TABLE t4 (c1 TINYINT NOT NULL);
1896
CREATE TABLE t5 (c1 TINYINT NOT NULL);
1897
CREATE TABLE t6 (c1 TINYINT NOT NULL);
1898
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1899
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1900
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1901
INSERT INTO t4 (c1) VALUES(10);
1902
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1903
SELECT t1.c1,t2.c1 FROM t1 NATURAL LEFT OUTER JOIN t2;
1915
SELECT t1.c1,t2.c1 FROM t1 NATURAL LEFT OUTER JOIN t2 WHERE t1.c1 = 5;
1918
DROP TABLE t1,t2,t3,t4,t5,t6;
1919
CREATE TABLE t1 (c1 SMALLINT NOT NULL);
1920
CREATE TABLE t2 (c1 SMALLINT NOT NULL);
1921
CREATE TABLE t3 (c1 SMALLINT NOT NULL);
1922
CREATE TABLE t4 (c1 SMALLINT NOT NULL);
1923
CREATE TABLE t5 (c1 SMALLINT NOT NULL);
1924
CREATE TABLE t6 (c1 SMALLINT NOT NULL);
1925
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1926
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1927
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1928
INSERT INTO t4 (c1) VALUES(10);
1929
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1930
SELECT t1.c1,t2.c1 FROM t1 NATURAL LEFT OUTER JOIN t2;
1942
SELECT t1.c1,t2.c1 FROM t1 NATURAL LEFT OUTER JOIN t2 WHERE t1.c1 = 5;
1945
DROP TABLE t1,t2,t3,t4,t5,t6;
1946
CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
1947
CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
1948
CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
1949
CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
1950
CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
1951
CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
1952
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1953
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1954
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1955
INSERT INTO t4 (c1) VALUES(10);
1956
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1957
SELECT t1.c1,t2.c1 FROM t1 NATURAL LEFT OUTER JOIN t2;
1969
SELECT t1.c1,t2.c1 FROM t1 NATURAL LEFT OUTER JOIN t2 WHERE t1.c1 = 5;
1972
DROP TABLE t1,t2,t3,t4,t5,t6;
1973
CREATE TABLE t1 (c1 INT NOT NULL);
1974
CREATE TABLE t2 (c1 INT NOT NULL);
1975
CREATE TABLE t3 (c1 INT NOT NULL);
1976
CREATE TABLE t4 (c1 INT NOT NULL);
1977
CREATE TABLE t5 (c1 INT NOT NULL);
1978
CREATE TABLE t6 (c1 INT NOT NULL);
1979
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1980
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1981
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1982
INSERT INTO t4 (c1) VALUES(10);
1983
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1984
SELECT t1.c1,t2.c1 FROM t1 NATURAL LEFT OUTER JOIN t2;
1996
SELECT t1.c1,t2.c1 FROM t1 NATURAL LEFT OUTER JOIN t2 WHERE t1.c1 = 5;
1999
DROP TABLE t1,t2,t3,t4,t5,t6;
2000
CREATE TABLE t1 (c1 INTEGER NOT NULL);
2001
CREATE TABLE t2 (c1 INTEGER NOT NULL);
2002
CREATE TABLE t3 (c1 INTEGER NOT NULL);
2003
CREATE TABLE t4 (c1 INTEGER NOT NULL);
2004
CREATE TABLE t5 (c1 INTEGER NOT NULL);
2005
CREATE TABLE t6 (c1 INTEGER NOT NULL);
2006
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2007
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2008
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2009
INSERT INTO t4 (c1) VALUES(10);
2010
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2011
SELECT t1.c1,t2.c1 FROM t1 NATURAL LEFT OUTER JOIN t2;
2023
SELECT t1.c1,t2.c1 FROM t1 NATURAL LEFT OUTER JOIN t2 WHERE t1.c1 = 5;
2026
DROP TABLE t1,t2,t3,t4,t5,t6;
2027
CREATE TABLE t1 (c1 BIGINT NOT NULL);
2028
CREATE TABLE t2 (c1 BIGINT NOT NULL);
2029
CREATE TABLE t3 (c1 BIGINT NOT NULL);
2030
CREATE TABLE t4 (c1 BIGINT NOT NULL);
2031
CREATE TABLE t5 (c1 BIGINT NOT NULL);
2032
CREATE TABLE t6 (c1 BIGINT NOT NULL);
2033
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2034
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2035
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2036
INSERT INTO t4 (c1) VALUES(10);
2037
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2038
SELECT t1.c1,t2.c1 FROM t1 NATURAL LEFT OUTER JOIN t2;
2050
SELECT t1.c1,t2.c1 FROM t1 NATURAL LEFT OUTER JOIN t2 WHERE t1.c1 = 5;
2053
DROP TABLE t1,t2,t3,t4,t5,t6;
2054
CREATE TABLE t1 (c1 TINYINT NOT NULL);
2055
CREATE TABLE t2 (c1 TINYINT NOT NULL);
2056
CREATE TABLE t3 (c1 TINYINT NOT NULL);
2057
CREATE TABLE t4 (c1 TINYINT NOT NULL);
2058
CREATE TABLE t5 (c1 TINYINT NOT NULL);
2059
CREATE TABLE t6 (c1 TINYINT NOT NULL);
2060
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2061
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2062
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2063
INSERT INTO t4 (c1) VALUES(10);
2064
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2065
SELECT t1.c1,t3.c1 FROM t1 NATURAL LEFT OUTER JOIN t3;
2077
SELECT t1.c1,t3.c1 FROM t1 NATURAL LEFT OUTER JOIN t3 WHERE t1.c1 = 5;
2080
DROP TABLE t1,t2,t3,t4,t5,t6;
2081
CREATE TABLE t1 (c1 SMALLINT NOT NULL);
2082
CREATE TABLE t2 (c1 SMALLINT NOT NULL);
2083
CREATE TABLE t3 (c1 SMALLINT NOT NULL);
2084
CREATE TABLE t4 (c1 SMALLINT NOT NULL);
2085
CREATE TABLE t5 (c1 SMALLINT NOT NULL);
2086
CREATE TABLE t6 (c1 SMALLINT NOT NULL);
2087
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2088
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2089
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2090
INSERT INTO t4 (c1) VALUES(10);
2091
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2092
SELECT t1.c1,t3.c1 FROM t1 NATURAL LEFT OUTER JOIN t3;
2104
SELECT t1.c1,t3.c1 FROM t1 NATURAL LEFT OUTER JOIN t3 WHERE t1.c1 = 5;
2107
DROP TABLE t1,t2,t3,t4,t5,t6;
2108
CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
2109
CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
2110
CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
2111
CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
2112
CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
2113
CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
2114
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2115
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2116
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2117
INSERT INTO t4 (c1) VALUES(10);
2118
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2119
SELECT t1.c1,t3.c1 FROM t1 NATURAL LEFT OUTER JOIN t3;
2131
SELECT t1.c1,t3.c1 FROM t1 NATURAL LEFT OUTER JOIN t3 WHERE t1.c1 = 5;
2134
DROP TABLE t1,t2,t3,t4,t5,t6;
2135
CREATE TABLE t1 (c1 INT NOT NULL);
2136
CREATE TABLE t2 (c1 INT NOT NULL);
2137
CREATE TABLE t3 (c1 INT NOT NULL);
2138
CREATE TABLE t4 (c1 INT NOT NULL);
2139
CREATE TABLE t5 (c1 INT NOT NULL);
2140
CREATE TABLE t6 (c1 INT NOT NULL);
2141
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2142
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2143
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2144
INSERT INTO t4 (c1) VALUES(10);
2145
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2146
SELECT t1.c1,t3.c1 FROM t1 NATURAL LEFT OUTER JOIN t3;
2158
SELECT t1.c1,t3.c1 FROM t1 NATURAL LEFT OUTER JOIN t3 WHERE t1.c1 = 5;
2161
DROP TABLE t1,t2,t3,t4,t5,t6;
2162
CREATE TABLE t1 (c1 INTEGER NOT NULL);
2163
CREATE TABLE t2 (c1 INTEGER NOT NULL);
2164
CREATE TABLE t3 (c1 INTEGER NOT NULL);
2165
CREATE TABLE t4 (c1 INTEGER NOT NULL);
2166
CREATE TABLE t5 (c1 INTEGER NOT NULL);
2167
CREATE TABLE t6 (c1 INTEGER NOT NULL);
2168
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2169
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2170
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2171
INSERT INTO t4 (c1) VALUES(10);
2172
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2173
SELECT t1.c1,t3.c1 FROM t1 NATURAL LEFT OUTER JOIN t3;
2185
SELECT t1.c1,t3.c1 FROM t1 NATURAL LEFT OUTER JOIN t3 WHERE t1.c1 = 5;
2188
DROP TABLE t1,t2,t3,t4,t5,t6;
2189
CREATE TABLE t1 (c1 BIGINT NOT NULL);
2190
CREATE TABLE t2 (c1 BIGINT NOT NULL);
2191
CREATE TABLE t3 (c1 BIGINT NOT NULL);
2192
CREATE TABLE t4 (c1 BIGINT NOT NULL);
2193
CREATE TABLE t5 (c1 BIGINT NOT NULL);
2194
CREATE TABLE t6 (c1 BIGINT NOT NULL);
2195
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2196
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2197
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2198
INSERT INTO t4 (c1) VALUES(10);
2199
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2200
SELECT t1.c1,t3.c1 FROM t1 NATURAL LEFT OUTER JOIN t3;
2212
SELECT t1.c1,t3.c1 FROM t1 NATURAL LEFT OUTER JOIN t3 WHERE t1.c1 = 5;
2215
DROP TABLE t1,t2,t3,t4,t5,t6;
2216
CREATE TABLE t1 (c1 TINYINT NOT NULL);
2217
CREATE TABLE t2 (c1 TINYINT NOT NULL);
2218
CREATE TABLE t3 (c1 TINYINT NOT NULL);
2219
CREATE TABLE t4 (c1 TINYINT NOT NULL);
2220
CREATE TABLE t5 (c1 TINYINT NOT NULL);
2221
CREATE TABLE t6 (c1 TINYINT 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,t4.c1 FROM t1 NATURAL LEFT OUTER JOIN t4;
2239
SELECT t1.c1,t4.c1 FROM t1 NATURAL LEFT OUTER JOIN t4 WHERE t1.c1 = 5;
2242
DROP TABLE t1,t2,t3,t4,t5,t6;
2243
CREATE TABLE t1 (c1 SMALLINT NOT NULL);
2244
CREATE TABLE t2 (c1 SMALLINT NOT NULL);
2245
CREATE TABLE t3 (c1 SMALLINT NOT NULL);
2246
CREATE TABLE t4 (c1 SMALLINT NOT NULL);
2247
CREATE TABLE t5 (c1 SMALLINT NOT NULL);
2248
CREATE TABLE t6 (c1 SMALLINT NOT NULL);
2249
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2250
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2251
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2252
INSERT INTO t4 (c1) VALUES(10);
2253
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2254
SELECT t1.c1,t4.c1 FROM t1 NATURAL LEFT OUTER JOIN t4;
2266
SELECT t1.c1,t4.c1 FROM t1 NATURAL LEFT OUTER JOIN t4 WHERE t1.c1 = 5;
2269
DROP TABLE t1,t2,t3,t4,t5,t6;
2270
CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
2271
CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
2272
CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
2273
CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
2274
CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
2275
CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
2276
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2277
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2278
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2279
INSERT INTO t4 (c1) VALUES(10);
2280
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2281
SELECT t1.c1,t4.c1 FROM t1 NATURAL LEFT OUTER JOIN t4;
2293
SELECT t1.c1,t4.c1 FROM t1 NATURAL LEFT OUTER JOIN t4 WHERE t1.c1 = 5;
2296
DROP TABLE t1,t2,t3,t4,t5,t6;
2297
CREATE TABLE t1 (c1 INT NOT NULL);
2298
CREATE TABLE t2 (c1 INT NOT NULL);
2299
CREATE TABLE t3 (c1 INT NOT NULL);
2300
CREATE TABLE t4 (c1 INT NOT NULL);
2301
CREATE TABLE t5 (c1 INT NOT NULL);
2302
CREATE TABLE t6 (c1 INT NOT NULL);
2303
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2304
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2305
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2306
INSERT INTO t4 (c1) VALUES(10);
2307
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2308
SELECT t1.c1,t4.c1 FROM t1 NATURAL LEFT OUTER JOIN t4;
2320
SELECT t1.c1,t4.c1 FROM t1 NATURAL LEFT OUTER JOIN t4 WHERE t1.c1 = 5;
2323
DROP TABLE t1,t2,t3,t4,t5,t6;
2324
CREATE TABLE t1 (c1 INTEGER NOT NULL);
2325
CREATE TABLE t2 (c1 INTEGER NOT NULL);
2326
CREATE TABLE t3 (c1 INTEGER NOT NULL);
2327
CREATE TABLE t4 (c1 INTEGER NOT NULL);
2328
CREATE TABLE t5 (c1 INTEGER NOT NULL);
2329
CREATE TABLE t6 (c1 INTEGER NOT NULL);
2330
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2331
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2332
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2333
INSERT INTO t4 (c1) VALUES(10);
2334
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2335
SELECT t1.c1,t4.c1 FROM t1 NATURAL LEFT OUTER JOIN t4;
2347
SELECT t1.c1,t4.c1 FROM t1 NATURAL LEFT OUTER JOIN t4 WHERE t1.c1 = 5;
2350
DROP TABLE t1,t2,t3,t4,t5,t6;
2351
CREATE TABLE t1 (c1 BIGINT NOT NULL);
2352
CREATE TABLE t2 (c1 BIGINT NOT NULL);
2353
CREATE TABLE t3 (c1 BIGINT NOT NULL);
2354
CREATE TABLE t4 (c1 BIGINT NOT NULL);
2355
CREATE TABLE t5 (c1 BIGINT NOT NULL);
2356
CREATE TABLE t6 (c1 BIGINT NOT NULL);
2357
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2358
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2359
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2360
INSERT INTO t4 (c1) VALUES(10);
2361
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2362
SELECT t1.c1,t4.c1 FROM t1 NATURAL LEFT OUTER JOIN t4;
2374
SELECT t1.c1,t4.c1 FROM t1 NATURAL LEFT OUTER JOIN t4 WHERE t1.c1 = 5;
2377
DROP TABLE t1,t2,t3,t4,t5,t6;
2378
CREATE TABLE t1 (c1 TINYINT NOT NULL);
2379
CREATE TABLE t2 (c1 TINYINT NOT NULL);
2380
CREATE TABLE t3 (c1 TINYINT NOT NULL);
2381
CREATE TABLE t4 (c1 TINYINT NOT NULL);
2382
CREATE TABLE t5 (c1 TINYINT NOT NULL);
2383
CREATE TABLE t6 (c1 TINYINT NOT NULL);
2384
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2385
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2386
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2387
INSERT INTO t4 (c1) VALUES(10);
2388
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2389
SELECT t1.c1,t5.c1 FROM t1 NATURAL LEFT OUTER JOIN t5;
2401
SELECT t1.c1,t5.c1 FROM t1 NATURAL LEFT OUTER JOIN t5 WHERE t1.c1 = 5;
2404
DROP TABLE t1,t2,t3,t4,t5,t6;
2405
CREATE TABLE t1 (c1 SMALLINT NOT NULL);
2406
CREATE TABLE t2 (c1 SMALLINT NOT NULL);
2407
CREATE TABLE t3 (c1 SMALLINT NOT NULL);
2408
CREATE TABLE t4 (c1 SMALLINT NOT NULL);
2409
CREATE TABLE t5 (c1 SMALLINT NOT NULL);
2410
CREATE TABLE t6 (c1 SMALLINT NOT NULL);
2411
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2412
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2413
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2414
INSERT INTO t4 (c1) VALUES(10);
2415
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2416
SELECT t1.c1,t5.c1 FROM t1 NATURAL LEFT OUTER JOIN t5;
2428
SELECT t1.c1,t5.c1 FROM t1 NATURAL LEFT OUTER JOIN t5 WHERE t1.c1 = 5;
2431
DROP TABLE t1,t2,t3,t4,t5,t6;
2432
CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
2433
CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
2434
CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
2435
CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
2436
CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
2437
CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
2438
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2439
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2440
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2441
INSERT INTO t4 (c1) VALUES(10);
2442
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2443
SELECT t1.c1,t5.c1 FROM t1 NATURAL LEFT OUTER JOIN t5;
2455
SELECT t1.c1,t5.c1 FROM t1 NATURAL LEFT OUTER JOIN t5 WHERE t1.c1 = 5;
2458
DROP TABLE t1,t2,t3,t4,t5,t6;
2459
CREATE TABLE t1 (c1 INT NOT NULL);
2460
CREATE TABLE t2 (c1 INT NOT NULL);
2461
CREATE TABLE t3 (c1 INT NOT NULL);
2462
CREATE TABLE t4 (c1 INT NOT NULL);
2463
CREATE TABLE t5 (c1 INT NOT NULL);
2464
CREATE TABLE t6 (c1 INT NOT NULL);
2465
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2466
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2467
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2468
INSERT INTO t4 (c1) VALUES(10);
2469
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2470
SELECT t1.c1,t5.c1 FROM t1 NATURAL LEFT OUTER JOIN t5;
2482
SELECT t1.c1,t5.c1 FROM t1 NATURAL LEFT OUTER JOIN t5 WHERE t1.c1 = 5;
2485
DROP TABLE t1,t2,t3,t4,t5,t6;
2486
CREATE TABLE t1 (c1 INTEGER NOT NULL);
2487
CREATE TABLE t2 (c1 INTEGER NOT NULL);
2488
CREATE TABLE t3 (c1 INTEGER NOT NULL);
2489
CREATE TABLE t4 (c1 INTEGER NOT NULL);
2490
CREATE TABLE t5 (c1 INTEGER NOT NULL);
2491
CREATE TABLE t6 (c1 INTEGER NOT NULL);
2492
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2493
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2494
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2495
INSERT INTO t4 (c1) VALUES(10);
2496
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2497
SELECT t1.c1,t5.c1 FROM t1 NATURAL LEFT OUTER JOIN t5;
2509
SELECT t1.c1,t5.c1 FROM t1 NATURAL LEFT OUTER JOIN t5 WHERE t1.c1 = 5;
2512
DROP TABLE t1,t2,t3,t4,t5,t6;
2513
CREATE TABLE t1 (c1 BIGINT NOT NULL);
2514
CREATE TABLE t2 (c1 BIGINT NOT NULL);
2515
CREATE TABLE t3 (c1 BIGINT NOT NULL);
2516
CREATE TABLE t4 (c1 BIGINT NOT NULL);
2517
CREATE TABLE t5 (c1 BIGINT NOT NULL);
2518
CREATE TABLE t6 (c1 BIGINT NOT NULL);
2519
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2520
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2521
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2522
INSERT INTO t4 (c1) VALUES(10);
2523
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2524
SELECT t1.c1,t5.c1 FROM t1 NATURAL LEFT OUTER JOIN t5;
2536
SELECT t1.c1,t5.c1 FROM t1 NATURAL LEFT OUTER JOIN t5 WHERE t1.c1 = 5;
2539
DROP TABLE t1,t2,t3,t4,t5,t6;
2540
CREATE TABLE t1 (c1 TINYINT NOT NULL);
2541
CREATE TABLE t2 (c1 TINYINT NOT NULL);
2542
CREATE TABLE t3 (c1 TINYINT NOT NULL);
2543
CREATE TABLE t4 (c1 TINYINT NOT NULL);
2544
CREATE TABLE t5 (c1 TINYINT NOT NULL);
2545
CREATE TABLE t6 (c1 TINYINT NOT NULL);
2546
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2547
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2548
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2549
INSERT INTO t4 (c1) VALUES(10);
2550
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2551
SELECT t1.c1,t6.c1 FROM t1 NATURAL LEFT OUTER JOIN t6;
2563
SELECT t1.c1,t6.c1 FROM t1 NATURAL LEFT OUTER JOIN t6 WHERE t1.c1 = 5;
2566
DROP TABLE t1,t2,t3,t4,t5,t6;
2567
CREATE TABLE t1 (c1 SMALLINT NOT NULL);
2568
CREATE TABLE t2 (c1 SMALLINT NOT NULL);
2569
CREATE TABLE t3 (c1 SMALLINT NOT NULL);
2570
CREATE TABLE t4 (c1 SMALLINT NOT NULL);
2571
CREATE TABLE t5 (c1 SMALLINT NOT NULL);
2572
CREATE TABLE t6 (c1 SMALLINT NOT NULL);
2573
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2574
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2575
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2576
INSERT INTO t4 (c1) VALUES(10);
2577
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2578
SELECT t1.c1,t6.c1 FROM t1 NATURAL LEFT OUTER JOIN t6;
2590
SELECT t1.c1,t6.c1 FROM t1 NATURAL LEFT OUTER JOIN t6 WHERE t1.c1 = 5;
2593
DROP TABLE t1,t2,t3,t4,t5,t6;
2594
CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
2595
CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
2596
CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
2597
CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
2598
CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
2599
CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
2600
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2601
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2602
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2603
INSERT INTO t4 (c1) VALUES(10);
2604
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2605
SELECT t1.c1,t6.c1 FROM t1 NATURAL LEFT OUTER JOIN t6;
2617
SELECT t1.c1,t6.c1 FROM t1 NATURAL LEFT OUTER JOIN t6 WHERE t1.c1 = 5;
2620
DROP TABLE t1,t2,t3,t4,t5,t6;
2621
CREATE TABLE t1 (c1 INT NOT NULL);
2622
CREATE TABLE t2 (c1 INT NOT NULL);
2623
CREATE TABLE t3 (c1 INT NOT NULL);
2624
CREATE TABLE t4 (c1 INT NOT NULL);
2625
CREATE TABLE t5 (c1 INT NOT NULL);
2626
CREATE TABLE t6 (c1 INT NOT NULL);
2627
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2628
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2629
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2630
INSERT INTO t4 (c1) VALUES(10);
2631
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2632
SELECT t1.c1,t6.c1 FROM t1 NATURAL LEFT OUTER JOIN t6;
2644
SELECT t1.c1,t6.c1 FROM t1 NATURAL LEFT OUTER JOIN t6 WHERE t1.c1 = 5;
2647
DROP TABLE t1,t2,t3,t4,t5,t6;
2648
CREATE TABLE t1 (c1 INTEGER NOT NULL);
2649
CREATE TABLE t2 (c1 INTEGER NOT NULL);
2650
CREATE TABLE t3 (c1 INTEGER NOT NULL);
2651
CREATE TABLE t4 (c1 INTEGER NOT NULL);
2652
CREATE TABLE t5 (c1 INTEGER NOT NULL);
2653
CREATE TABLE t6 (c1 INTEGER NOT NULL);
2654
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2655
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2656
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2657
INSERT INTO t4 (c1) VALUES(10);
2658
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2659
SELECT t1.c1,t6.c1 FROM t1 NATURAL LEFT OUTER JOIN t6;
2671
SELECT t1.c1,t6.c1 FROM t1 NATURAL LEFT OUTER JOIN t6 WHERE t1.c1 = 5;
2674
DROP TABLE t1,t2,t3,t4,t5,t6;
2675
CREATE TABLE t1 (c1 BIGINT NOT NULL);
2676
CREATE TABLE t2 (c1 BIGINT NOT NULL);
2677
CREATE TABLE t3 (c1 BIGINT NOT NULL);
2678
CREATE TABLE t4 (c1 BIGINT NOT NULL);
2679
CREATE TABLE t5 (c1 BIGINT NOT NULL);
2680
CREATE TABLE t6 (c1 BIGINT NOT NULL);
2681
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2682
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2683
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2684
INSERT INTO t4 (c1) VALUES(10);
2685
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2686
SELECT t1.c1,t6.c1 FROM t1 NATURAL LEFT OUTER JOIN t6;
2698
SELECT t1.c1,t6.c1 FROM t1 NATURAL LEFT OUTER JOIN t6 WHERE t1.c1 = 5;
2701
DROP TABLE t1,t2,t3,t4,t5,t6;
2702
CREATE TABLE t1 (c1 TINYINT NOT NULL);
2703
CREATE TABLE t2 (c1 TINYINT NOT NULL);
2704
CREATE TABLE t3 (c1 TINYINT NOT NULL);
2705
CREATE TABLE t4 (c1 TINYINT NOT NULL);
2706
CREATE TABLE t5 (c1 TINYINT NOT NULL);
2707
CREATE TABLE t6 (c1 TINYINT NOT NULL);
2708
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2709
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2710
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2711
INSERT INTO t4 (c1) VALUES(10);
2712
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2713
SELECT t1.c1,t2.c1 FROM t1 NATURAL LEFT OUTER JOIN t2;
2725
SELECT t1.c1,t2.c1 FROM t1 NATURAL LEFT OUTER JOIN t2 WHERE t1.c1 >= 5;
2732
DROP TABLE t1,t2,t3,t4,t5,t6;
2733
CREATE TABLE t1 (c1 SMALLINT NOT NULL);
2734
CREATE TABLE t2 (c1 SMALLINT NOT NULL);
2735
CREATE TABLE t3 (c1 SMALLINT NOT NULL);
2736
CREATE TABLE t4 (c1 SMALLINT NOT NULL);
2737
CREATE TABLE t5 (c1 SMALLINT NOT NULL);
2738
CREATE TABLE t6 (c1 SMALLINT NOT NULL);
2739
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2740
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2741
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2742
INSERT INTO t4 (c1) VALUES(10);
2743
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2744
SELECT t1.c1,t2.c1 FROM t1 NATURAL LEFT OUTER JOIN t2;
2756
SELECT t1.c1,t2.c1 FROM t1 NATURAL LEFT OUTER JOIN t2 WHERE t1.c1 >= 5;
2763
DROP TABLE t1,t2,t3,t4,t5,t6;
2764
CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
2765
CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
2766
CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
2767
CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
2768
CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
2769
CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
2770
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2771
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2772
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2773
INSERT INTO t4 (c1) VALUES(10);
2774
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2775
SELECT t1.c1,t2.c1 FROM t1 NATURAL LEFT OUTER JOIN t2;
2787
SELECT t1.c1,t2.c1 FROM t1 NATURAL LEFT OUTER JOIN t2 WHERE t1.c1 >= 5;
2794
DROP TABLE t1,t2,t3,t4,t5,t6;
2795
CREATE TABLE t1 (c1 INT NOT NULL);
2796
CREATE TABLE t2 (c1 INT NOT NULL);
2797
CREATE TABLE t3 (c1 INT NOT NULL);
2798
CREATE TABLE t4 (c1 INT NOT NULL);
2799
CREATE TABLE t5 (c1 INT NOT NULL);
2800
CREATE TABLE t6 (c1 INT NOT NULL);
2801
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2802
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2803
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2804
INSERT INTO t4 (c1) VALUES(10);
2805
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2806
SELECT t1.c1,t2.c1 FROM t1 NATURAL LEFT OUTER JOIN t2;
2818
SELECT t1.c1,t2.c1 FROM t1 NATURAL LEFT OUTER JOIN t2 WHERE t1.c1 >= 5;
2825
DROP TABLE t1,t2,t3,t4,t5,t6;
2826
CREATE TABLE t1 (c1 INTEGER NOT NULL);
2827
CREATE TABLE t2 (c1 INTEGER NOT NULL);
2828
CREATE TABLE t3 (c1 INTEGER NOT NULL);
2829
CREATE TABLE t4 (c1 INTEGER NOT NULL);
2830
CREATE TABLE t5 (c1 INTEGER NOT NULL);
2831
CREATE TABLE t6 (c1 INTEGER NOT NULL);
2832
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2833
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2834
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2835
INSERT INTO t4 (c1) VALUES(10);
2836
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2837
SELECT t1.c1,t2.c1 FROM t1 NATURAL LEFT OUTER JOIN t2;
2849
SELECT t1.c1,t2.c1 FROM t1 NATURAL LEFT OUTER JOIN t2 WHERE t1.c1 >= 5;
2856
DROP TABLE t1,t2,t3,t4,t5,t6;
2857
CREATE TABLE t1 (c1 BIGINT NOT NULL);
2858
CREATE TABLE t2 (c1 BIGINT NOT NULL);
2859
CREATE TABLE t3 (c1 BIGINT NOT NULL);
2860
CREATE TABLE t4 (c1 BIGINT NOT NULL);
2861
CREATE TABLE t5 (c1 BIGINT NOT NULL);
2862
CREATE TABLE t6 (c1 BIGINT NOT NULL);
2863
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2864
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2865
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2866
INSERT INTO t4 (c1) VALUES(10);
2867
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2868
SELECT t1.c1,t2.c1 FROM t1 NATURAL LEFT OUTER JOIN t2;
2880
SELECT t1.c1,t2.c1 FROM t1 NATURAL LEFT OUTER JOIN t2 WHERE t1.c1 >= 5;
2887
DROP TABLE t1,t2,t3,t4,t5,t6;
2888
CREATE TABLE t1 (c1 TINYINT NOT NULL);
2889
CREATE TABLE t2 (c1 TINYINT NOT NULL);
2890
CREATE TABLE t3 (c1 TINYINT NOT NULL);
2891
CREATE TABLE t4 (c1 TINYINT NOT NULL);
2892
CREATE TABLE t5 (c1 TINYINT NOT NULL);
2893
CREATE TABLE t6 (c1 TINYINT NOT NULL);
2894
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2895
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2896
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2897
INSERT INTO t4 (c1) VALUES(10);
2898
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2899
SELECT t1.c1,t3.c1 FROM t1 NATURAL LEFT OUTER JOIN t3;
2911
SELECT t1.c1,t3.c1 FROM t1 NATURAL LEFT OUTER JOIN t3 WHERE t1.c1 >= 5;
2918
DROP TABLE t1,t2,t3,t4,t5,t6;
2919
CREATE TABLE t1 (c1 SMALLINT NOT NULL);
2920
CREATE TABLE t2 (c1 SMALLINT NOT NULL);
2921
CREATE TABLE t3 (c1 SMALLINT NOT NULL);
2922
CREATE TABLE t4 (c1 SMALLINT NOT NULL);
2923
CREATE TABLE t5 (c1 SMALLINT NOT NULL);
2924
CREATE TABLE t6 (c1 SMALLINT NOT NULL);
2925
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2926
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2927
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2928
INSERT INTO t4 (c1) VALUES(10);
2929
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2930
SELECT t1.c1,t3.c1 FROM t1 NATURAL LEFT OUTER JOIN t3;
2942
SELECT t1.c1,t3.c1 FROM t1 NATURAL LEFT OUTER JOIN t3 WHERE t1.c1 >= 5;
2949
DROP TABLE t1,t2,t3,t4,t5,t6;
2950
CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
2951
CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
2952
CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
2953
CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
2954
CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
2955
CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
2956
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2957
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2958
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2959
INSERT INTO t4 (c1) VALUES(10);
2960
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2961
SELECT t1.c1,t3.c1 FROM t1 NATURAL LEFT OUTER JOIN t3;
2973
SELECT t1.c1,t3.c1 FROM t1 NATURAL LEFT OUTER JOIN t3 WHERE t1.c1 >= 5;
2980
DROP TABLE t1,t2,t3,t4,t5,t6;
2981
CREATE TABLE t1 (c1 INT NOT NULL);
2982
CREATE TABLE t2 (c1 INT NOT NULL);
2983
CREATE TABLE t3 (c1 INT NOT NULL);
2984
CREATE TABLE t4 (c1 INT NOT NULL);
2985
CREATE TABLE t5 (c1 INT NOT NULL);
2986
CREATE TABLE t6 (c1 INT NOT NULL);
2987
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2988
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2989
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2990
INSERT INTO t4 (c1) VALUES(10);
2991
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2992
SELECT t1.c1,t3.c1 FROM t1 NATURAL LEFT OUTER JOIN t3;
3004
SELECT t1.c1,t3.c1 FROM t1 NATURAL LEFT OUTER JOIN t3 WHERE t1.c1 >= 5;
3011
DROP TABLE t1,t2,t3,t4,t5,t6;
3012
CREATE TABLE t1 (c1 INTEGER NOT NULL);
3013
CREATE TABLE t2 (c1 INTEGER NOT NULL);
3014
CREATE TABLE t3 (c1 INTEGER NOT NULL);
3015
CREATE TABLE t4 (c1 INTEGER NOT NULL);
3016
CREATE TABLE t5 (c1 INTEGER NOT NULL);
3017
CREATE TABLE t6 (c1 INTEGER NOT NULL);
3018
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3019
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3020
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3021
INSERT INTO t4 (c1) VALUES(10);
3022
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3023
SELECT t1.c1,t3.c1 FROM t1 NATURAL LEFT OUTER JOIN t3;
3035
SELECT t1.c1,t3.c1 FROM t1 NATURAL LEFT OUTER JOIN t3 WHERE t1.c1 >= 5;
3042
DROP TABLE t1,t2,t3,t4,t5,t6;
3043
CREATE TABLE t1 (c1 BIGINT NOT NULL);
3044
CREATE TABLE t2 (c1 BIGINT NOT NULL);
3045
CREATE TABLE t3 (c1 BIGINT NOT NULL);
3046
CREATE TABLE t4 (c1 BIGINT NOT NULL);
3047
CREATE TABLE t5 (c1 BIGINT NOT NULL);
3048
CREATE TABLE t6 (c1 BIGINT NOT NULL);
3049
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3050
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3051
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3052
INSERT INTO t4 (c1) VALUES(10);
3053
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3054
SELECT t1.c1,t3.c1 FROM t1 NATURAL LEFT OUTER JOIN t3;
3066
SELECT t1.c1,t3.c1 FROM t1 NATURAL LEFT OUTER JOIN t3 WHERE t1.c1 >= 5;
3073
DROP TABLE t1,t2,t3,t4,t5,t6;
3074
CREATE TABLE t1 (c1 TINYINT NOT NULL);
3075
CREATE TABLE t2 (c1 TINYINT NOT NULL);
3076
CREATE TABLE t3 (c1 TINYINT NOT NULL);
3077
CREATE TABLE t4 (c1 TINYINT NOT NULL);
3078
CREATE TABLE t5 (c1 TINYINT NOT NULL);
3079
CREATE TABLE t6 (c1 TINYINT NOT NULL);
3080
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3081
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3082
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3083
INSERT INTO t4 (c1) VALUES(10);
3084
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3085
SELECT t1.c1,t4.c1 FROM t1 NATURAL LEFT OUTER JOIN t4;
3097
SELECT t1.c1,t4.c1 FROM t1 NATURAL LEFT OUTER JOIN t4 WHERE t1.c1 >= 5;
3104
DROP TABLE t1,t2,t3,t4,t5,t6;
3105
CREATE TABLE t1 (c1 SMALLINT NOT NULL);
3106
CREATE TABLE t2 (c1 SMALLINT NOT NULL);
3107
CREATE TABLE t3 (c1 SMALLINT NOT NULL);
3108
CREATE TABLE t4 (c1 SMALLINT NOT NULL);
3109
CREATE TABLE t5 (c1 SMALLINT NOT NULL);
3110
CREATE TABLE t6 (c1 SMALLINT NOT NULL);
3111
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3112
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3113
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3114
INSERT INTO t4 (c1) VALUES(10);
3115
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3116
SELECT t1.c1,t4.c1 FROM t1 NATURAL LEFT OUTER JOIN t4;
3128
SELECT t1.c1,t4.c1 FROM t1 NATURAL LEFT OUTER JOIN t4 WHERE t1.c1 >= 5;
3135
DROP TABLE t1,t2,t3,t4,t5,t6;
3136
CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
3137
CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
3138
CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
3139
CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
3140
CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
3141
CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
3142
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3143
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3144
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3145
INSERT INTO t4 (c1) VALUES(10);
3146
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3147
SELECT t1.c1,t4.c1 FROM t1 NATURAL LEFT OUTER JOIN t4;
3159
SELECT t1.c1,t4.c1 FROM t1 NATURAL LEFT OUTER JOIN t4 WHERE t1.c1 >= 5;
3166
DROP TABLE t1,t2,t3,t4,t5,t6;
3167
CREATE TABLE t1 (c1 INT NOT NULL);
3168
CREATE TABLE t2 (c1 INT NOT NULL);
3169
CREATE TABLE t3 (c1 INT NOT NULL);
3170
CREATE TABLE t4 (c1 INT NOT NULL);
3171
CREATE TABLE t5 (c1 INT NOT NULL);
3172
CREATE TABLE t6 (c1 INT NOT NULL);
3173
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3174
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3175
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3176
INSERT INTO t4 (c1) VALUES(10);
3177
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3178
SELECT t1.c1,t4.c1 FROM t1 NATURAL LEFT OUTER JOIN t4;
3190
SELECT t1.c1,t4.c1 FROM t1 NATURAL LEFT OUTER JOIN t4 WHERE t1.c1 >= 5;
3197
DROP TABLE t1,t2,t3,t4,t5,t6;
3198
CREATE TABLE t1 (c1 INTEGER NOT NULL);
3199
CREATE TABLE t2 (c1 INTEGER NOT NULL);
3200
CREATE TABLE t3 (c1 INTEGER NOT NULL);
3201
CREATE TABLE t4 (c1 INTEGER NOT NULL);
3202
CREATE TABLE t5 (c1 INTEGER NOT NULL);
3203
CREATE TABLE t6 (c1 INTEGER NOT NULL);
3204
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3205
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3206
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3207
INSERT INTO t4 (c1) VALUES(10);
3208
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3209
SELECT t1.c1,t4.c1 FROM t1 NATURAL LEFT OUTER JOIN t4;
3221
SELECT t1.c1,t4.c1 FROM t1 NATURAL LEFT OUTER JOIN t4 WHERE t1.c1 >= 5;
3228
DROP TABLE t1,t2,t3,t4,t5,t6;
3229
CREATE TABLE t1 (c1 BIGINT NOT NULL);
3230
CREATE TABLE t2 (c1 BIGINT NOT NULL);
3231
CREATE TABLE t3 (c1 BIGINT NOT NULL);
3232
CREATE TABLE t4 (c1 BIGINT NOT NULL);
3233
CREATE TABLE t5 (c1 BIGINT NOT NULL);
3234
CREATE TABLE t6 (c1 BIGINT NOT NULL);
3235
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3236
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3237
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3238
INSERT INTO t4 (c1) VALUES(10);
3239
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3240
SELECT t1.c1,t4.c1 FROM t1 NATURAL LEFT OUTER JOIN t4;
3252
SELECT t1.c1,t4.c1 FROM t1 NATURAL LEFT OUTER JOIN t4 WHERE t1.c1 >= 5;
3259
DROP TABLE t1,t2,t3,t4,t5,t6;
3260
CREATE TABLE t1 (c1 TINYINT NOT NULL);
3261
CREATE TABLE t2 (c1 TINYINT NOT NULL);
3262
CREATE TABLE t3 (c1 TINYINT NOT NULL);
3263
CREATE TABLE t4 (c1 TINYINT NOT NULL);
3264
CREATE TABLE t5 (c1 TINYINT NOT NULL);
3265
CREATE TABLE t6 (c1 TINYINT NOT NULL);
3266
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3267
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3268
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3269
INSERT INTO t4 (c1) VALUES(10);
3270
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3271
SELECT t1.c1,t5.c1 FROM t1 NATURAL LEFT OUTER JOIN t5;
3283
SELECT t1.c1,t5.c1 FROM t1 NATURAL LEFT OUTER JOIN t5 WHERE t1.c1 >= 5;
3290
DROP TABLE t1,t2,t3,t4,t5,t6;
3291
CREATE TABLE t1 (c1 SMALLINT NOT NULL);
3292
CREATE TABLE t2 (c1 SMALLINT NOT NULL);
3293
CREATE TABLE t3 (c1 SMALLINT NOT NULL);
3294
CREATE TABLE t4 (c1 SMALLINT NOT NULL);
3295
CREATE TABLE t5 (c1 SMALLINT NOT NULL);
3296
CREATE TABLE t6 (c1 SMALLINT NOT NULL);
3297
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3298
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3299
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3300
INSERT INTO t4 (c1) VALUES(10);
3301
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3302
SELECT t1.c1,t5.c1 FROM t1 NATURAL LEFT OUTER JOIN t5;
3314
SELECT t1.c1,t5.c1 FROM t1 NATURAL LEFT OUTER JOIN t5 WHERE t1.c1 >= 5;
3321
DROP TABLE t1,t2,t3,t4,t5,t6;
3322
CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
3323
CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
3324
CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
3325
CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
3326
CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
3327
CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
3328
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3329
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3330
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3331
INSERT INTO t4 (c1) VALUES(10);
3332
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3333
SELECT t1.c1,t5.c1 FROM t1 NATURAL LEFT OUTER JOIN t5;
3345
SELECT t1.c1,t5.c1 FROM t1 NATURAL LEFT OUTER JOIN t5 WHERE t1.c1 >= 5;
3352
DROP TABLE t1,t2,t3,t4,t5,t6;
3353
CREATE TABLE t1 (c1 INT NOT NULL);
3354
CREATE TABLE t2 (c1 INT NOT NULL);
3355
CREATE TABLE t3 (c1 INT NOT NULL);
3356
CREATE TABLE t4 (c1 INT NOT NULL);
3357
CREATE TABLE t5 (c1 INT NOT NULL);
3358
CREATE TABLE t6 (c1 INT 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 NATURAL LEFT OUTER JOIN t5;
3376
SELECT t1.c1,t5.c1 FROM t1 NATURAL LEFT OUTER JOIN t5 WHERE t1.c1 >= 5;
3383
DROP TABLE t1,t2,t3,t4,t5,t6;
3384
CREATE TABLE t1 (c1 INTEGER NOT NULL);
3385
CREATE TABLE t2 (c1 INTEGER NOT NULL);
3386
CREATE TABLE t3 (c1 INTEGER NOT NULL);
3387
CREATE TABLE t4 (c1 INTEGER NOT NULL);
3388
CREATE TABLE t5 (c1 INTEGER NOT NULL);
3389
CREATE TABLE t6 (c1 INTEGER NOT NULL);
3390
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3391
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3392
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3393
INSERT INTO t4 (c1) VALUES(10);
3394
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3395
SELECT t1.c1,t5.c1 FROM t1 NATURAL LEFT OUTER JOIN t5;
3407
SELECT t1.c1,t5.c1 FROM t1 NATURAL LEFT OUTER JOIN t5 WHERE t1.c1 >= 5;
3414
DROP TABLE t1,t2,t3,t4,t5,t6;
3415
CREATE TABLE t1 (c1 BIGINT NOT NULL);
3416
CREATE TABLE t2 (c1 BIGINT NOT NULL);
3417
CREATE TABLE t3 (c1 BIGINT NOT NULL);
3418
CREATE TABLE t4 (c1 BIGINT NOT NULL);
3419
CREATE TABLE t5 (c1 BIGINT NOT NULL);
3420
CREATE TABLE t6 (c1 BIGINT NOT NULL);
3421
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3422
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3423
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3424
INSERT INTO t4 (c1) VALUES(10);
3425
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3426
SELECT t1.c1,t5.c1 FROM t1 NATURAL LEFT OUTER JOIN t5;
3438
SELECT t1.c1,t5.c1 FROM t1 NATURAL LEFT OUTER JOIN t5 WHERE t1.c1 >= 5;
3445
DROP TABLE t1,t2,t3,t4,t5,t6;
3446
CREATE TABLE t1 (c1 TINYINT NOT NULL);
3447
CREATE TABLE t2 (c1 TINYINT NOT NULL);
3448
CREATE TABLE t3 (c1 TINYINT NOT NULL);
3449
CREATE TABLE t4 (c1 TINYINT NOT NULL);
3450
CREATE TABLE t5 (c1 TINYINT NOT NULL);
3451
CREATE TABLE t6 (c1 TINYINT NOT NULL);
3452
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3453
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3454
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3455
INSERT INTO t4 (c1) VALUES(10);
3456
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3457
SELECT t1.c1,t6.c1 FROM t1 NATURAL LEFT OUTER JOIN t6;
3469
SELECT t1.c1,t6.c1 FROM t1 NATURAL LEFT OUTER JOIN t6 WHERE t1.c1 >= 5;
3476
DROP TABLE t1,t2,t3,t4,t5,t6;
3477
CREATE TABLE t1 (c1 SMALLINT NOT NULL);
3478
CREATE TABLE t2 (c1 SMALLINT NOT NULL);
3479
CREATE TABLE t3 (c1 SMALLINT NOT NULL);
3480
CREATE TABLE t4 (c1 SMALLINT NOT NULL);
3481
CREATE TABLE t5 (c1 SMALLINT NOT NULL);
3482
CREATE TABLE t6 (c1 SMALLINT NOT NULL);
3483
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3484
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3485
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3486
INSERT INTO t4 (c1) VALUES(10);
3487
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3488
SELECT t1.c1,t6.c1 FROM t1 NATURAL LEFT OUTER JOIN t6;
3500
SELECT t1.c1,t6.c1 FROM t1 NATURAL LEFT OUTER JOIN t6 WHERE t1.c1 >= 5;
3507
DROP TABLE t1,t2,t3,t4,t5,t6;
3508
CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
3509
CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
3510
CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
3511
CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
3512
CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
3513
CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
3514
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3515
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3516
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3517
INSERT INTO t4 (c1) VALUES(10);
3518
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3519
SELECT t1.c1,t6.c1 FROM t1 NATURAL LEFT OUTER JOIN t6;
3531
SELECT t1.c1,t6.c1 FROM t1 NATURAL LEFT OUTER JOIN t6 WHERE t1.c1 >= 5;
3538
DROP TABLE t1,t2,t3,t4,t5,t6;
3539
CREATE TABLE t1 (c1 INT NOT NULL);
3540
CREATE TABLE t2 (c1 INT NOT NULL);
3541
CREATE TABLE t3 (c1 INT NOT NULL);
3542
CREATE TABLE t4 (c1 INT NOT NULL);
3543
CREATE TABLE t5 (c1 INT NOT NULL);
3544
CREATE TABLE t6 (c1 INT NOT NULL);
3545
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3546
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3547
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3548
INSERT INTO t4 (c1) VALUES(10);
3549
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3550
SELECT t1.c1,t6.c1 FROM t1 NATURAL LEFT OUTER JOIN t6;
3562
SELECT t1.c1,t6.c1 FROM t1 NATURAL LEFT OUTER JOIN t6 WHERE t1.c1 >= 5;
3569
DROP TABLE t1,t2,t3,t4,t5,t6;
3570
CREATE TABLE t1 (c1 INTEGER NOT NULL);
3571
CREATE TABLE t2 (c1 INTEGER NOT NULL);
3572
CREATE TABLE t3 (c1 INTEGER NOT NULL);
3573
CREATE TABLE t4 (c1 INTEGER NOT NULL);
3574
CREATE TABLE t5 (c1 INTEGER NOT NULL);
3575
CREATE TABLE t6 (c1 INTEGER NOT NULL);
3576
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3577
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3578
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3579
INSERT INTO t4 (c1) VALUES(10);
3580
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3581
SELECT t1.c1,t6.c1 FROM t1 NATURAL LEFT OUTER JOIN t6;
3593
SELECT t1.c1,t6.c1 FROM t1 NATURAL LEFT OUTER JOIN t6 WHERE t1.c1 >= 5;
3600
DROP TABLE t1,t2,t3,t4,t5,t6;
3601
CREATE TABLE t1 (c1 BIGINT NOT NULL);
3602
CREATE TABLE t2 (c1 BIGINT NOT NULL);
3603
CREATE TABLE t3 (c1 BIGINT NOT NULL);
3604
CREATE TABLE t4 (c1 BIGINT NOT NULL);
3605
CREATE TABLE t5 (c1 BIGINT NOT NULL);
3606
CREATE TABLE t6 (c1 BIGINT NOT NULL);
3607
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3608
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3609
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3610
INSERT INTO t4 (c1) VALUES(10);
3611
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3612
SELECT t1.c1,t6.c1 FROM t1 NATURAL LEFT OUTER JOIN t6;
3624
SELECT t1.c1,t6.c1 FROM t1 NATURAL LEFT OUTER JOIN t6 WHERE t1.c1 >= 5;
3631
DROP TABLE t1,t2,t3,t4,t5,t6;
3632
CREATE TABLE t1 (c1 TINYINT NOT NULL);
3633
CREATE TABLE t2 (c1 TINYINT NOT NULL);
3634
CREATE TABLE t3 (c1 TINYINT NOT NULL);
3635
CREATE TABLE t4 (c1 TINYINT NOT NULL);
3636
CREATE TABLE t5 (c1 TINYINT NOT NULL);
3637
CREATE TABLE t6 (c1 TINYINT NOT NULL);
3638
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3639
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3640
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3641
INSERT INTO t4 (c1) VALUES(10);
3642
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3643
SELECT t1.c1,t2.c1 FROM t1 NATURAL LEFT OUTER JOIN t2;
3655
SELECT t1.c1,t2.c1 FROM t1 NATURAL LEFT OUTER JOIN t2 WHERE t1.c1 != 5;
3666
DROP TABLE t1,t2,t3,t4,t5,t6;
3667
CREATE TABLE t1 (c1 SMALLINT NOT NULL);
3668
CREATE TABLE t2 (c1 SMALLINT NOT NULL);
3669
CREATE TABLE t3 (c1 SMALLINT NOT NULL);
3670
CREATE TABLE t4 (c1 SMALLINT NOT NULL);
3671
CREATE TABLE t5 (c1 SMALLINT NOT NULL);
3672
CREATE TABLE t6 (c1 SMALLINT NOT NULL);
3673
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3674
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3675
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3676
INSERT INTO t4 (c1) VALUES(10);
3677
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3678
SELECT t1.c1,t2.c1 FROM t1 NATURAL LEFT OUTER JOIN t2;
3690
SELECT t1.c1,t2.c1 FROM t1 NATURAL LEFT OUTER JOIN t2 WHERE t1.c1 != 5;
3701
DROP TABLE t1,t2,t3,t4,t5,t6;
3702
CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
3703
CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
3704
CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
3705
CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
3706
CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
3707
CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
3708
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3709
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3710
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3711
INSERT INTO t4 (c1) VALUES(10);
3712
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3713
SELECT t1.c1,t2.c1 FROM t1 NATURAL LEFT OUTER JOIN t2;
3725
SELECT t1.c1,t2.c1 FROM t1 NATURAL LEFT OUTER JOIN t2 WHERE t1.c1 != 5;
3736
DROP TABLE t1,t2,t3,t4,t5,t6;
3737
CREATE TABLE t1 (c1 INT NOT NULL);
3738
CREATE TABLE t2 (c1 INT NOT NULL);
3739
CREATE TABLE t3 (c1 INT NOT NULL);
3740
CREATE TABLE t4 (c1 INT NOT NULL);
3741
CREATE TABLE t5 (c1 INT NOT NULL);
3742
CREATE TABLE t6 (c1 INT NOT NULL);
3743
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3744
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3745
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3746
INSERT INTO t4 (c1) VALUES(10);
3747
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3748
SELECT t1.c1,t2.c1 FROM t1 NATURAL LEFT OUTER JOIN t2;
3760
SELECT t1.c1,t2.c1 FROM t1 NATURAL LEFT OUTER JOIN t2 WHERE t1.c1 != 5;
3771
DROP TABLE t1,t2,t3,t4,t5,t6;
3772
CREATE TABLE t1 (c1 INTEGER NOT NULL);
3773
CREATE TABLE t2 (c1 INTEGER NOT NULL);
3774
CREATE TABLE t3 (c1 INTEGER NOT NULL);
3775
CREATE TABLE t4 (c1 INTEGER NOT NULL);
3776
CREATE TABLE t5 (c1 INTEGER NOT NULL);
3777
CREATE TABLE t6 (c1 INTEGER NOT NULL);
3778
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3779
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3780
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3781
INSERT INTO t4 (c1) VALUES(10);
3782
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3783
SELECT t1.c1,t2.c1 FROM t1 NATURAL LEFT OUTER JOIN t2;
3795
SELECT t1.c1,t2.c1 FROM t1 NATURAL LEFT OUTER JOIN t2 WHERE t1.c1 != 5;
3806
DROP TABLE t1,t2,t3,t4,t5,t6;
3807
CREATE TABLE t1 (c1 BIGINT NOT NULL);
3808
CREATE TABLE t2 (c1 BIGINT NOT NULL);
3809
CREATE TABLE t3 (c1 BIGINT NOT NULL);
3810
CREATE TABLE t4 (c1 BIGINT NOT NULL);
3811
CREATE TABLE t5 (c1 BIGINT NOT NULL);
3812
CREATE TABLE t6 (c1 BIGINT NOT NULL);
3813
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3814
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3815
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3816
INSERT INTO t4 (c1) VALUES(10);
3817
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3818
SELECT t1.c1,t2.c1 FROM t1 NATURAL LEFT OUTER JOIN t2;
3830
SELECT t1.c1,t2.c1 FROM t1 NATURAL LEFT OUTER JOIN t2 WHERE t1.c1 != 5;
3841
DROP TABLE t1,t2,t3,t4,t5,t6;
3842
CREATE TABLE t1 (c1 TINYINT NOT NULL);
3843
CREATE TABLE t2 (c1 TINYINT NOT NULL);
3844
CREATE TABLE t3 (c1 TINYINT NOT NULL);
3845
CREATE TABLE t4 (c1 TINYINT NOT NULL);
3846
CREATE TABLE t5 (c1 TINYINT NOT NULL);
3847
CREATE TABLE t6 (c1 TINYINT NOT NULL);
3848
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3849
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3850
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3851
INSERT INTO t4 (c1) VALUES(10);
3852
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3853
SELECT t1.c1,t3.c1 FROM t1 NATURAL LEFT OUTER JOIN t3;
3865
SELECT t1.c1,t3.c1 FROM t1 NATURAL LEFT OUTER JOIN t3 WHERE t1.c1 != 5;
3876
DROP TABLE t1,t2,t3,t4,t5,t6;
3877
CREATE TABLE t1 (c1 SMALLINT NOT NULL);
3878
CREATE TABLE t2 (c1 SMALLINT NOT NULL);
3879
CREATE TABLE t3 (c1 SMALLINT NOT NULL);
3880
CREATE TABLE t4 (c1 SMALLINT NOT NULL);
3881
CREATE TABLE t5 (c1 SMALLINT NOT NULL);
3882
CREATE TABLE t6 (c1 SMALLINT NOT NULL);
3883
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3884
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3885
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3886
INSERT INTO t4 (c1) VALUES(10);
3887
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3888
SELECT t1.c1,t3.c1 FROM t1 NATURAL LEFT OUTER JOIN t3;
3900
SELECT t1.c1,t3.c1 FROM t1 NATURAL LEFT OUTER JOIN t3 WHERE t1.c1 != 5;
3911
DROP TABLE t1,t2,t3,t4,t5,t6;
3912
CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
3913
CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
3914
CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
3915
CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
3916
CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
3917
CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
3918
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3919
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3920
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3921
INSERT INTO t4 (c1) VALUES(10);
3922
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3923
SELECT t1.c1,t3.c1 FROM t1 NATURAL LEFT OUTER JOIN t3;
3935
SELECT t1.c1,t3.c1 FROM t1 NATURAL LEFT OUTER JOIN t3 WHERE t1.c1 != 5;
3946
DROP TABLE t1,t2,t3,t4,t5,t6;
3947
CREATE TABLE t1 (c1 INT NOT NULL);
3948
CREATE TABLE t2 (c1 INT NOT NULL);
3949
CREATE TABLE t3 (c1 INT NOT NULL);
3950
CREATE TABLE t4 (c1 INT NOT NULL);
3951
CREATE TABLE t5 (c1 INT NOT NULL);
3952
CREATE TABLE t6 (c1 INT NOT NULL);
3953
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3954
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3955
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3956
INSERT INTO t4 (c1) VALUES(10);
3957
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3958
SELECT t1.c1,t3.c1 FROM t1 NATURAL LEFT OUTER JOIN t3;
3970
SELECT t1.c1,t3.c1 FROM t1 NATURAL LEFT OUTER JOIN t3 WHERE t1.c1 != 5;
3981
DROP TABLE t1,t2,t3,t4,t5,t6;
3982
CREATE TABLE t1 (c1 INTEGER NOT NULL);
3983
CREATE TABLE t2 (c1 INTEGER NOT NULL);
3984
CREATE TABLE t3 (c1 INTEGER NOT NULL);
3985
CREATE TABLE t4 (c1 INTEGER NOT NULL);
3986
CREATE TABLE t5 (c1 INTEGER NOT NULL);
3987
CREATE TABLE t6 (c1 INTEGER NOT NULL);
3988
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3989
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3990
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3991
INSERT INTO t4 (c1) VALUES(10);
3992
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3993
SELECT t1.c1,t3.c1 FROM t1 NATURAL LEFT OUTER JOIN t3;
4005
SELECT t1.c1,t3.c1 FROM t1 NATURAL LEFT OUTER JOIN t3 WHERE t1.c1 != 5;
4016
DROP TABLE t1,t2,t3,t4,t5,t6;
4017
CREATE TABLE t1 (c1 BIGINT NOT NULL);
4018
CREATE TABLE t2 (c1 BIGINT NOT NULL);
4019
CREATE TABLE t3 (c1 BIGINT NOT NULL);
4020
CREATE TABLE t4 (c1 BIGINT NOT NULL);
4021
CREATE TABLE t5 (c1 BIGINT NOT NULL);
4022
CREATE TABLE t6 (c1 BIGINT NOT NULL);
4023
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4024
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4025
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
4026
INSERT INTO t4 (c1) VALUES(10);
4027
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
4028
SELECT t1.c1,t3.c1 FROM t1 NATURAL LEFT OUTER JOIN t3;
4040
SELECT t1.c1,t3.c1 FROM t1 NATURAL LEFT OUTER JOIN t3 WHERE t1.c1 != 5;
4051
DROP TABLE t1,t2,t3,t4,t5,t6;
4052
CREATE TABLE t1 (c1 TINYINT NOT NULL);
4053
CREATE TABLE t2 (c1 TINYINT NOT NULL);
4054
CREATE TABLE t3 (c1 TINYINT NOT NULL);
4055
CREATE TABLE t4 (c1 TINYINT NOT NULL);
4056
CREATE TABLE t5 (c1 TINYINT NOT NULL);
4057
CREATE TABLE t6 (c1 TINYINT NOT NULL);
4058
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4059
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4060
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
4061
INSERT INTO t4 (c1) VALUES(10);
4062
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
4063
SELECT t1.c1,t4.c1 FROM t1 NATURAL LEFT OUTER JOIN t4;
4075
SELECT t1.c1,t4.c1 FROM t1 NATURAL LEFT OUTER JOIN t4 WHERE t1.c1 != 5;
4086
DROP TABLE t1,t2,t3,t4,t5,t6;
4087
CREATE TABLE t1 (c1 SMALLINT NOT NULL);
4088
CREATE TABLE t2 (c1 SMALLINT NOT NULL);
4089
CREATE TABLE t3 (c1 SMALLINT NOT NULL);
4090
CREATE TABLE t4 (c1 SMALLINT NOT NULL);
4091
CREATE TABLE t5 (c1 SMALLINT NOT NULL);
4092
CREATE TABLE t6 (c1 SMALLINT NOT NULL);
4093
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4094
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4095
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
4096
INSERT INTO t4 (c1) VALUES(10);
4097
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
4098
SELECT t1.c1,t4.c1 FROM t1 NATURAL LEFT OUTER JOIN t4;
4110
SELECT t1.c1,t4.c1 FROM t1 NATURAL LEFT OUTER JOIN t4 WHERE t1.c1 != 5;
4121
DROP TABLE t1,t2,t3,t4,t5,t6;
4122
CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
4123
CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
4124
CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
4125
CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
4126
CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
4127
CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
4128
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4129
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4130
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
4131
INSERT INTO t4 (c1) VALUES(10);
4132
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
4133
SELECT t1.c1,t4.c1 FROM t1 NATURAL LEFT OUTER JOIN t4;
4145
SELECT t1.c1,t4.c1 FROM t1 NATURAL LEFT OUTER JOIN t4 WHERE t1.c1 != 5;
4156
DROP TABLE t1,t2,t3,t4,t5,t6;
4157
CREATE TABLE t1 (c1 INT NOT NULL);
4158
CREATE TABLE t2 (c1 INT NOT NULL);
4159
CREATE TABLE t3 (c1 INT NOT NULL);
4160
CREATE TABLE t4 (c1 INT NOT NULL);
4161
CREATE TABLE t5 (c1 INT NOT NULL);
4162
CREATE TABLE t6 (c1 INT NOT NULL);
4163
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4164
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4165
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
4166
INSERT INTO t4 (c1) VALUES(10);
4167
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
4168
SELECT t1.c1,t4.c1 FROM t1 NATURAL LEFT OUTER JOIN t4;
4180
SELECT t1.c1,t4.c1 FROM t1 NATURAL LEFT OUTER JOIN t4 WHERE t1.c1 != 5;
4191
DROP TABLE t1,t2,t3,t4,t5,t6;
4192
CREATE TABLE t1 (c1 INTEGER NOT NULL);
4193
CREATE TABLE t2 (c1 INTEGER NOT NULL);
4194
CREATE TABLE t3 (c1 INTEGER NOT NULL);
4195
CREATE TABLE t4 (c1 INTEGER NOT NULL);
4196
CREATE TABLE t5 (c1 INTEGER NOT NULL);
4197
CREATE TABLE t6 (c1 INTEGER NOT NULL);
4198
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4199
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4200
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
4201
INSERT INTO t4 (c1) VALUES(10);
4202
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
4203
SELECT t1.c1,t4.c1 FROM t1 NATURAL LEFT OUTER JOIN t4;
4215
SELECT t1.c1,t4.c1 FROM t1 NATURAL LEFT OUTER JOIN t4 WHERE t1.c1 != 5;
4226
DROP TABLE t1,t2,t3,t4,t5,t6;
4227
CREATE TABLE t1 (c1 BIGINT NOT NULL);
4228
CREATE TABLE t2 (c1 BIGINT NOT NULL);
4229
CREATE TABLE t3 (c1 BIGINT NOT NULL);
4230
CREATE TABLE t4 (c1 BIGINT NOT NULL);
4231
CREATE TABLE t5 (c1 BIGINT NOT NULL);
4232
CREATE TABLE t6 (c1 BIGINT NOT NULL);
4233
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4234
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4235
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
4236
INSERT INTO t4 (c1) VALUES(10);
4237
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
4238
SELECT t1.c1,t4.c1 FROM t1 NATURAL LEFT OUTER JOIN t4;
4250
SELECT t1.c1,t4.c1 FROM t1 NATURAL LEFT OUTER JOIN t4 WHERE t1.c1 != 5;
4261
DROP TABLE t1,t2,t3,t4,t5,t6;
4262
CREATE TABLE t1 (c1 TINYINT NOT NULL);
4263
CREATE TABLE t2 (c1 TINYINT NOT NULL);
4264
CREATE TABLE t3 (c1 TINYINT NOT NULL);
4265
CREATE TABLE t4 (c1 TINYINT NOT NULL);
4266
CREATE TABLE t5 (c1 TINYINT NOT NULL);
4267
CREATE TABLE t6 (c1 TINYINT NOT NULL);
4268
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4269
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4270
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
4271
INSERT INTO t4 (c1) VALUES(10);
4272
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
4273
SELECT t1.c1,t5.c1 FROM t1 NATURAL LEFT OUTER JOIN t5;
4285
SELECT t1.c1,t5.c1 FROM t1 NATURAL LEFT OUTER JOIN t5 WHERE t1.c1 != 5;
4296
DROP TABLE t1,t2,t3,t4,t5,t6;
4297
CREATE TABLE t1 (c1 SMALLINT NOT NULL);
4298
CREATE TABLE t2 (c1 SMALLINT NOT NULL);
4299
CREATE TABLE t3 (c1 SMALLINT NOT NULL);
4300
CREATE TABLE t4 (c1 SMALLINT NOT NULL);
4301
CREATE TABLE t5 (c1 SMALLINT NOT NULL);
4302
CREATE TABLE t6 (c1 SMALLINT NOT NULL);
4303
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4304
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4305
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
4306
INSERT INTO t4 (c1) VALUES(10);
4307
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
4308
SELECT t1.c1,t5.c1 FROM t1 NATURAL LEFT OUTER JOIN t5;
4320
SELECT t1.c1,t5.c1 FROM t1 NATURAL LEFT OUTER JOIN t5 WHERE t1.c1 != 5;
4331
DROP TABLE t1,t2,t3,t4,t5,t6;
4332
CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
4333
CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
4334
CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
4335
CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
4336
CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
4337
CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
4338
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4339
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4340
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
4341
INSERT INTO t4 (c1) VALUES(10);
4342
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
4343
SELECT t1.c1,t5.c1 FROM t1 NATURAL LEFT OUTER JOIN t5;
4355
SELECT t1.c1,t5.c1 FROM t1 NATURAL LEFT OUTER JOIN t5 WHERE t1.c1 != 5;
4366
DROP TABLE t1,t2,t3,t4,t5,t6;
4367
CREATE TABLE t1 (c1 INT NOT NULL);
4368
CREATE TABLE t2 (c1 INT NOT NULL);
4369
CREATE TABLE t3 (c1 INT NOT NULL);
4370
CREATE TABLE t4 (c1 INT NOT NULL);
4371
CREATE TABLE t5 (c1 INT NOT NULL);
4372
CREATE TABLE t6 (c1 INT NOT NULL);
4373
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4374
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4375
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
4376
INSERT INTO t4 (c1) VALUES(10);
4377
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
4378
SELECT t1.c1,t5.c1 FROM t1 NATURAL LEFT OUTER JOIN t5;
4390
SELECT t1.c1,t5.c1 FROM t1 NATURAL LEFT OUTER JOIN t5 WHERE t1.c1 != 5;
4401
DROP TABLE t1,t2,t3,t4,t5,t6;
4402
CREATE TABLE t1 (c1 INTEGER NOT NULL);
4403
CREATE TABLE t2 (c1 INTEGER NOT NULL);
4404
CREATE TABLE t3 (c1 INTEGER NOT NULL);
4405
CREATE TABLE t4 (c1 INTEGER NOT NULL);
4406
CREATE TABLE t5 (c1 INTEGER NOT NULL);
4407
CREATE TABLE t6 (c1 INTEGER NOT NULL);
4408
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4409
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4410
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
4411
INSERT INTO t4 (c1) VALUES(10);
4412
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
4413
SELECT t1.c1,t5.c1 FROM t1 NATURAL LEFT OUTER JOIN t5;
4425
SELECT t1.c1,t5.c1 FROM t1 NATURAL LEFT OUTER JOIN t5 WHERE t1.c1 != 5;
4436
DROP TABLE t1,t2,t3,t4,t5,t6;
4437
CREATE TABLE t1 (c1 BIGINT NOT NULL);
4438
CREATE TABLE t2 (c1 BIGINT NOT NULL);
4439
CREATE TABLE t3 (c1 BIGINT NOT NULL);
4440
CREATE TABLE t4 (c1 BIGINT NOT NULL);
4441
CREATE TABLE t5 (c1 BIGINT NOT NULL);
4442
CREATE TABLE t6 (c1 BIGINT NOT NULL);
4443
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4444
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4445
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
4446
INSERT INTO t4 (c1) VALUES(10);
4447
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
4448
SELECT t1.c1,t5.c1 FROM t1 NATURAL LEFT OUTER JOIN t5;
4460
SELECT t1.c1,t5.c1 FROM t1 NATURAL LEFT OUTER JOIN t5 WHERE t1.c1 != 5;
4471
DROP TABLE t1,t2,t3,t4,t5,t6;
4472
CREATE TABLE t1 (c1 TINYINT NOT NULL);
4473
CREATE TABLE t2 (c1 TINYINT NOT NULL);
4474
CREATE TABLE t3 (c1 TINYINT NOT NULL);
4475
CREATE TABLE t4 (c1 TINYINT NOT NULL);
4476
CREATE TABLE t5 (c1 TINYINT NOT NULL);
4477
CREATE TABLE t6 (c1 TINYINT NOT NULL);
4478
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4479
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4480
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
4481
INSERT INTO t4 (c1) VALUES(10);
4482
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
4483
SELECT t1.c1,t6.c1 FROM t1 NATURAL LEFT OUTER JOIN t6;
4495
SELECT t1.c1,t6.c1 FROM t1 NATURAL LEFT OUTER JOIN t6 WHERE t1.c1 != 5;
4506
DROP TABLE t1,t2,t3,t4,t5,t6;
4507
CREATE TABLE t1 (c1 SMALLINT NOT NULL);
4508
CREATE TABLE t2 (c1 SMALLINT NOT NULL);
4509
CREATE TABLE t3 (c1 SMALLINT NOT NULL);
4510
CREATE TABLE t4 (c1 SMALLINT NOT NULL);
4511
CREATE TABLE t5 (c1 SMALLINT NOT NULL);
4512
CREATE TABLE t6 (c1 SMALLINT NOT NULL);
4513
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4514
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4515
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
4516
INSERT INTO t4 (c1) VALUES(10);
4517
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
4518
SELECT t1.c1,t6.c1 FROM t1 NATURAL LEFT OUTER JOIN t6;
4530
SELECT t1.c1,t6.c1 FROM t1 NATURAL LEFT OUTER JOIN t6 WHERE t1.c1 != 5;
4541
DROP TABLE t1,t2,t3,t4,t5,t6;
4542
CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
4543
CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
4544
CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
4545
CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
4546
CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
4547
CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
4548
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4549
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4550
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
4551
INSERT INTO t4 (c1) VALUES(10);
4552
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
4553
SELECT t1.c1,t6.c1 FROM t1 NATURAL LEFT OUTER JOIN t6;
4565
SELECT t1.c1,t6.c1 FROM t1 NATURAL LEFT OUTER JOIN t6 WHERE t1.c1 != 5;
4576
DROP TABLE t1,t2,t3,t4,t5,t6;
4577
CREATE TABLE t1 (c1 INT NOT NULL);
4578
CREATE TABLE t2 (c1 INT NOT NULL);
4579
CREATE TABLE t3 (c1 INT NOT NULL);
4580
CREATE TABLE t4 (c1 INT NOT NULL);
4581
CREATE TABLE t5 (c1 INT NOT NULL);
4582
CREATE TABLE t6 (c1 INT NOT NULL);
4583
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4584
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4585
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
4586
INSERT INTO t4 (c1) VALUES(10);
4587
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
4588
SELECT t1.c1,t6.c1 FROM t1 NATURAL LEFT OUTER JOIN t6;
4600
SELECT t1.c1,t6.c1 FROM t1 NATURAL LEFT OUTER JOIN t6 WHERE t1.c1 != 5;
4611
DROP TABLE t1,t2,t3,t4,t5,t6;
4612
CREATE TABLE t1 (c1 INTEGER NOT NULL);
4613
CREATE TABLE t2 (c1 INTEGER NOT NULL);
4614
CREATE TABLE t3 (c1 INTEGER NOT NULL);
4615
CREATE TABLE t4 (c1 INTEGER NOT NULL);
4616
CREATE TABLE t5 (c1 INTEGER NOT NULL);
4617
CREATE TABLE t6 (c1 INTEGER NOT NULL);
4618
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4619
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4620
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
4621
INSERT INTO t4 (c1) VALUES(10);
4622
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
4623
SELECT t1.c1,t6.c1 FROM t1 NATURAL LEFT OUTER JOIN t6;
4635
SELECT t1.c1,t6.c1 FROM t1 NATURAL LEFT OUTER JOIN t6 WHERE t1.c1 != 5;
4646
DROP TABLE t1,t2,t3,t4,t5,t6;
4647
CREATE TABLE t1 (c1 BIGINT NOT NULL);
4648
CREATE TABLE t2 (c1 BIGINT NOT NULL);
4649
CREATE TABLE t3 (c1 BIGINT NOT NULL);
4650
CREATE TABLE t4 (c1 BIGINT NOT NULL);
4651
CREATE TABLE t5 (c1 BIGINT NOT NULL);
4652
CREATE TABLE t6 (c1 BIGINT NOT NULL);
4653
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4654
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4655
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
4656
INSERT INTO t4 (c1) VALUES(10);
4657
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
4658
SELECT t1.c1,t6.c1 FROM t1 NATURAL LEFT OUTER JOIN t6;
4670
SELECT t1.c1,t6.c1 FROM t1 NATURAL LEFT OUTER JOIN t6 WHERE t1.c1 != 5;
4681
DROP TABLE t1,t2,t3,t4,t5,t6;
4682
CREATE TABLE t1 (c1 TINYINT NOT NULL);
4683
CREATE TABLE t2 (c1 TINYINT NOT NULL);
4684
CREATE TABLE t3 (c1 TINYINT NOT NULL);
4685
CREATE TABLE t4 (c1 TINYINT NOT NULL);
4686
CREATE TABLE t5 (c1 TINYINT NOT NULL);
4687
CREATE TABLE t6 (c1 TINYINT NOT NULL);
4688
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4689
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4690
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
4691
INSERT INTO t4 (c1) VALUES(10);
4692
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
4693
SELECT t1.c1,t2.c1 FROM t1 NATURAL LEFT OUTER JOIN t2;
4705
SELECT t1.c1,t2.c1 FROM t1 NATURAL LEFT OUTER JOIN t2 WHERE t1.c1 <> 5;
4716
DROP TABLE t1,t2,t3,t4,t5,t6;
4717
CREATE TABLE t1 (c1 SMALLINT NOT NULL);
4718
CREATE TABLE t2 (c1 SMALLINT NOT NULL);
4719
CREATE TABLE t3 (c1 SMALLINT NOT NULL);
4720
CREATE TABLE t4 (c1 SMALLINT NOT NULL);
4721
CREATE TABLE t5 (c1 SMALLINT NOT NULL);
4722
CREATE TABLE t6 (c1 SMALLINT NOT NULL);
4723
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4724
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4725
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
4726
INSERT INTO t4 (c1) VALUES(10);
4727
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
4728
SELECT t1.c1,t2.c1 FROM t1 NATURAL LEFT OUTER JOIN t2;
4740
SELECT t1.c1,t2.c1 FROM t1 NATURAL LEFT OUTER JOIN t2 WHERE t1.c1 <> 5;
4751
DROP TABLE t1,t2,t3,t4,t5,t6;
4752
CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
4753
CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
4754
CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
4755
CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
4756
CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
4757
CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
4758
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4759
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4760
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
4761
INSERT INTO t4 (c1) VALUES(10);
4762
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
4763
SELECT t1.c1,t2.c1 FROM t1 NATURAL LEFT OUTER JOIN t2;
4775
SELECT t1.c1,t2.c1 FROM t1 NATURAL LEFT OUTER JOIN t2 WHERE t1.c1 <> 5;
4786
DROP TABLE t1,t2,t3,t4,t5,t6;
4787
CREATE TABLE t1 (c1 INT NOT NULL);
4788
CREATE TABLE t2 (c1 INT NOT NULL);
4789
CREATE TABLE t3 (c1 INT NOT NULL);
4790
CREATE TABLE t4 (c1 INT NOT NULL);
4791
CREATE TABLE t5 (c1 INT NOT NULL);
4792
CREATE TABLE t6 (c1 INT NOT NULL);
4793
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4794
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4795
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
4796
INSERT INTO t4 (c1) VALUES(10);
4797
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
4798
SELECT t1.c1,t2.c1 FROM t1 NATURAL LEFT OUTER JOIN t2;
4810
SELECT t1.c1,t2.c1 FROM t1 NATURAL LEFT OUTER JOIN t2 WHERE t1.c1 <> 5;
4821
DROP TABLE t1,t2,t3,t4,t5,t6;
4822
CREATE TABLE t1 (c1 INTEGER NOT NULL);
4823
CREATE TABLE t2 (c1 INTEGER NOT NULL);
4824
CREATE TABLE t3 (c1 INTEGER NOT NULL);
4825
CREATE TABLE t4 (c1 INTEGER NOT NULL);
4826
CREATE TABLE t5 (c1 INTEGER NOT NULL);
4827
CREATE TABLE t6 (c1 INTEGER NOT NULL);
4828
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4829
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4830
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
4831
INSERT INTO t4 (c1) VALUES(10);
4832
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
4833
SELECT t1.c1,t2.c1 FROM t1 NATURAL LEFT OUTER JOIN t2;
4845
SELECT t1.c1,t2.c1 FROM t1 NATURAL LEFT OUTER JOIN t2 WHERE t1.c1 <> 5;
4856
DROP TABLE t1,t2,t3,t4,t5,t6;
4857
CREATE TABLE t1 (c1 BIGINT NOT NULL);
4858
CREATE TABLE t2 (c1 BIGINT NOT NULL);
4859
CREATE TABLE t3 (c1 BIGINT NOT NULL);
4860
CREATE TABLE t4 (c1 BIGINT NOT NULL);
4861
CREATE TABLE t5 (c1 BIGINT NOT NULL);
4862
CREATE TABLE t6 (c1 BIGINT 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,t2.c1 FROM t1 NATURAL LEFT OUTER JOIN t2;
4880
SELECT t1.c1,t2.c1 FROM t1 NATURAL LEFT OUTER JOIN t2 WHERE t1.c1 <> 5;
4891
DROP TABLE t1,t2,t3,t4,t5,t6;
4892
CREATE TABLE t1 (c1 TINYINT NOT NULL);
4893
CREATE TABLE t2 (c1 TINYINT NOT NULL);
4894
CREATE TABLE t3 (c1 TINYINT NOT NULL);
4895
CREATE TABLE t4 (c1 TINYINT NOT NULL);
4896
CREATE TABLE t5 (c1 TINYINT NOT NULL);
4897
CREATE TABLE t6 (c1 TINYINT NOT NULL);
4898
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4899
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4900
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
4901
INSERT INTO t4 (c1) VALUES(10);
4902
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
4903
SELECT t1.c1,t3.c1 FROM t1 NATURAL LEFT OUTER JOIN t3;
4915
SELECT t1.c1,t3.c1 FROM t1 NATURAL LEFT OUTER JOIN t3 WHERE t1.c1 <> 5;
4926
DROP TABLE t1,t2,t3,t4,t5,t6;
4927
CREATE TABLE t1 (c1 SMALLINT NOT NULL);
4928
CREATE TABLE t2 (c1 SMALLINT NOT NULL);
4929
CREATE TABLE t3 (c1 SMALLINT NOT NULL);
4930
CREATE TABLE t4 (c1 SMALLINT NOT NULL);
4931
CREATE TABLE t5 (c1 SMALLINT NOT NULL);
4932
CREATE TABLE t6 (c1 SMALLINT NOT NULL);
4933
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4934
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4935
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
4936
INSERT INTO t4 (c1) VALUES(10);
4937
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
4938
SELECT t1.c1,t3.c1 FROM t1 NATURAL LEFT OUTER JOIN t3;
4950
SELECT t1.c1,t3.c1 FROM t1 NATURAL LEFT OUTER JOIN t3 WHERE t1.c1 <> 5;
4961
DROP TABLE t1,t2,t3,t4,t5,t6;
4962
CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
4963
CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
4964
CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
4965
CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
4966
CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
4967
CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
4968
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4969
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4970
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
4971
INSERT INTO t4 (c1) VALUES(10);
4972
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
4973
SELECT t1.c1,t3.c1 FROM t1 NATURAL LEFT OUTER JOIN t3;
4985
SELECT t1.c1,t3.c1 FROM t1 NATURAL LEFT OUTER JOIN t3 WHERE t1.c1 <> 5;
4996
DROP TABLE t1,t2,t3,t4,t5,t6;
4997
CREATE TABLE t1 (c1 INT NOT NULL);
4998
CREATE TABLE t2 (c1 INT NOT NULL);
4999
CREATE TABLE t3 (c1 INT NOT NULL);
5000
CREATE TABLE t4 (c1 INT NOT NULL);
5001
CREATE TABLE t5 (c1 INT NOT NULL);
5002
CREATE TABLE t6 (c1 INT NOT NULL);
5003
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5004
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5005
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
5006
INSERT INTO t4 (c1) VALUES(10);
5007
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
5008
SELECT t1.c1,t3.c1 FROM t1 NATURAL LEFT OUTER JOIN t3;
5020
SELECT t1.c1,t3.c1 FROM t1 NATURAL LEFT OUTER JOIN t3 WHERE t1.c1 <> 5;
5031
DROP TABLE t1,t2,t3,t4,t5,t6;
5032
CREATE TABLE t1 (c1 INTEGER NOT NULL);
5033
CREATE TABLE t2 (c1 INTEGER NOT NULL);
5034
CREATE TABLE t3 (c1 INTEGER NOT NULL);
5035
CREATE TABLE t4 (c1 INTEGER NOT NULL);
5036
CREATE TABLE t5 (c1 INTEGER NOT NULL);
5037
CREATE TABLE t6 (c1 INTEGER NOT NULL);
5038
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5039
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5040
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
5041
INSERT INTO t4 (c1) VALUES(10);
5042
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
5043
SELECT t1.c1,t3.c1 FROM t1 NATURAL LEFT OUTER JOIN t3;
5055
SELECT t1.c1,t3.c1 FROM t1 NATURAL LEFT OUTER JOIN t3 WHERE t1.c1 <> 5;
5066
DROP TABLE t1,t2,t3,t4,t5,t6;
5067
CREATE TABLE t1 (c1 BIGINT NOT NULL);
5068
CREATE TABLE t2 (c1 BIGINT NOT NULL);
5069
CREATE TABLE t3 (c1 BIGINT NOT NULL);
5070
CREATE TABLE t4 (c1 BIGINT NOT NULL);
5071
CREATE TABLE t5 (c1 BIGINT NOT NULL);
5072
CREATE TABLE t6 (c1 BIGINT NOT NULL);
5073
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5074
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5075
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
5076
INSERT INTO t4 (c1) VALUES(10);
5077
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
5078
SELECT t1.c1,t3.c1 FROM t1 NATURAL LEFT OUTER JOIN t3;
5090
SELECT t1.c1,t3.c1 FROM t1 NATURAL LEFT OUTER JOIN t3 WHERE t1.c1 <> 5;
5101
DROP TABLE t1,t2,t3,t4,t5,t6;
5102
CREATE TABLE t1 (c1 TINYINT NOT NULL);
5103
CREATE TABLE t2 (c1 TINYINT NOT NULL);
5104
CREATE TABLE t3 (c1 TINYINT NOT NULL);
5105
CREATE TABLE t4 (c1 TINYINT NOT NULL);
5106
CREATE TABLE t5 (c1 TINYINT NOT NULL);
5107
CREATE TABLE t6 (c1 TINYINT NOT NULL);
5108
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5109
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5110
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
5111
INSERT INTO t4 (c1) VALUES(10);
5112
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
5113
SELECT t1.c1,t4.c1 FROM t1 NATURAL LEFT OUTER JOIN t4;
5125
SELECT t1.c1,t4.c1 FROM t1 NATURAL LEFT OUTER JOIN t4 WHERE t1.c1 <> 5;
5136
DROP TABLE t1,t2,t3,t4,t5,t6;
5137
CREATE TABLE t1 (c1 SMALLINT NOT NULL);
5138
CREATE TABLE t2 (c1 SMALLINT NOT NULL);
5139
CREATE TABLE t3 (c1 SMALLINT NOT NULL);
5140
CREATE TABLE t4 (c1 SMALLINT NOT NULL);
5141
CREATE TABLE t5 (c1 SMALLINT NOT NULL);
5142
CREATE TABLE t6 (c1 SMALLINT NOT NULL);
5143
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5144
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5145
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
5146
INSERT INTO t4 (c1) VALUES(10);
5147
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
5148
SELECT t1.c1,t4.c1 FROM t1 NATURAL LEFT OUTER JOIN t4;
5160
SELECT t1.c1,t4.c1 FROM t1 NATURAL LEFT OUTER JOIN t4 WHERE t1.c1 <> 5;
5171
DROP TABLE t1,t2,t3,t4,t5,t6;
5172
CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
5173
CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
5174
CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
5175
CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
5176
CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
5177
CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
5178
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5179
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5180
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
5181
INSERT INTO t4 (c1) VALUES(10);
5182
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
5183
SELECT t1.c1,t4.c1 FROM t1 NATURAL LEFT OUTER JOIN t4;
5195
SELECT t1.c1,t4.c1 FROM t1 NATURAL LEFT OUTER JOIN t4 WHERE t1.c1 <> 5;
5206
DROP TABLE t1,t2,t3,t4,t5,t6;
5207
CREATE TABLE t1 (c1 INT NOT NULL);
5208
CREATE TABLE t2 (c1 INT NOT NULL);
5209
CREATE TABLE t3 (c1 INT NOT NULL);
5210
CREATE TABLE t4 (c1 INT NOT NULL);
5211
CREATE TABLE t5 (c1 INT NOT NULL);
5212
CREATE TABLE t6 (c1 INT NOT NULL);
5213
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5214
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5215
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
5216
INSERT INTO t4 (c1) VALUES(10);
5217
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
5218
SELECT t1.c1,t4.c1 FROM t1 NATURAL LEFT OUTER JOIN t4;
5230
SELECT t1.c1,t4.c1 FROM t1 NATURAL LEFT OUTER JOIN t4 WHERE t1.c1 <> 5;
5241
DROP TABLE t1,t2,t3,t4,t5,t6;
5242
CREATE TABLE t1 (c1 INTEGER NOT NULL);
5243
CREATE TABLE t2 (c1 INTEGER NOT NULL);
5244
CREATE TABLE t3 (c1 INTEGER NOT NULL);
5245
CREATE TABLE t4 (c1 INTEGER NOT NULL);
5246
CREATE TABLE t5 (c1 INTEGER NOT NULL);
5247
CREATE TABLE t6 (c1 INTEGER NOT NULL);
5248
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5249
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5250
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
5251
INSERT INTO t4 (c1) VALUES(10);
5252
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
5253
SELECT t1.c1,t4.c1 FROM t1 NATURAL LEFT OUTER JOIN t4;
5265
SELECT t1.c1,t4.c1 FROM t1 NATURAL LEFT OUTER JOIN t4 WHERE t1.c1 <> 5;
5276
DROP TABLE t1,t2,t3,t4,t5,t6;
5277
CREATE TABLE t1 (c1 BIGINT NOT NULL);
5278
CREATE TABLE t2 (c1 BIGINT NOT NULL);
5279
CREATE TABLE t3 (c1 BIGINT NOT NULL);
5280
CREATE TABLE t4 (c1 BIGINT NOT NULL);
5281
CREATE TABLE t5 (c1 BIGINT NOT NULL);
5282
CREATE TABLE t6 (c1 BIGINT NOT NULL);
5283
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5284
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5285
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
5286
INSERT INTO t4 (c1) VALUES(10);
5287
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
5288
SELECT t1.c1,t4.c1 FROM t1 NATURAL LEFT OUTER JOIN t4;
5300
SELECT t1.c1,t4.c1 FROM t1 NATURAL LEFT OUTER JOIN t4 WHERE t1.c1 <> 5;
5311
DROP TABLE t1,t2,t3,t4,t5,t6;
5312
CREATE TABLE t1 (c1 TINYINT NOT NULL);
5313
CREATE TABLE t2 (c1 TINYINT NOT NULL);
5314
CREATE TABLE t3 (c1 TINYINT NOT NULL);
5315
CREATE TABLE t4 (c1 TINYINT NOT NULL);
5316
CREATE TABLE t5 (c1 TINYINT NOT NULL);
5317
CREATE TABLE t6 (c1 TINYINT NOT NULL);
5318
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5319
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5320
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
5321
INSERT INTO t4 (c1) VALUES(10);
5322
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
5323
SELECT t1.c1,t5.c1 FROM t1 NATURAL LEFT OUTER JOIN t5;
5335
SELECT t1.c1,t5.c1 FROM t1 NATURAL LEFT OUTER JOIN t5 WHERE t1.c1 <> 5;
5346
DROP TABLE t1,t2,t3,t4,t5,t6;
5347
CREATE TABLE t1 (c1 SMALLINT NOT NULL);
5348
CREATE TABLE t2 (c1 SMALLINT NOT NULL);
5349
CREATE TABLE t3 (c1 SMALLINT NOT NULL);
5350
CREATE TABLE t4 (c1 SMALLINT NOT NULL);
5351
CREATE TABLE t5 (c1 SMALLINT NOT NULL);
5352
CREATE TABLE t6 (c1 SMALLINT NOT NULL);
5353
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5354
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5355
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
5356
INSERT INTO t4 (c1) VALUES(10);
5357
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
5358
SELECT t1.c1,t5.c1 FROM t1 NATURAL LEFT OUTER JOIN t5;
5370
SELECT t1.c1,t5.c1 FROM t1 NATURAL LEFT OUTER JOIN t5 WHERE t1.c1 <> 5;
5381
DROP TABLE t1,t2,t3,t4,t5,t6;
5382
CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
5383
CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
5384
CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
5385
CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
5386
CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
5387
CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
5388
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5389
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5390
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
5391
INSERT INTO t4 (c1) VALUES(10);
5392
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
5393
SELECT t1.c1,t5.c1 FROM t1 NATURAL LEFT OUTER JOIN t5;
5405
SELECT t1.c1,t5.c1 FROM t1 NATURAL LEFT OUTER JOIN t5 WHERE t1.c1 <> 5;
5416
DROP TABLE t1,t2,t3,t4,t5,t6;
5417
CREATE TABLE t1 (c1 INT NOT NULL);
5418
CREATE TABLE t2 (c1 INT NOT NULL);
5419
CREATE TABLE t3 (c1 INT NOT NULL);
5420
CREATE TABLE t4 (c1 INT NOT NULL);
5421
CREATE TABLE t5 (c1 INT NOT NULL);
5422
CREATE TABLE t6 (c1 INT NOT NULL);
5423
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5424
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5425
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
5426
INSERT INTO t4 (c1) VALUES(10);
5427
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
5428
SELECT t1.c1,t5.c1 FROM t1 NATURAL LEFT OUTER JOIN t5;
5440
SELECT t1.c1,t5.c1 FROM t1 NATURAL LEFT OUTER JOIN t5 WHERE t1.c1 <> 5;
5451
DROP TABLE t1,t2,t3,t4,t5,t6;
5452
CREATE TABLE t1 (c1 INTEGER NOT NULL);
5453
CREATE TABLE t2 (c1 INTEGER NOT NULL);
5454
CREATE TABLE t3 (c1 INTEGER NOT NULL);
5455
CREATE TABLE t4 (c1 INTEGER NOT NULL);
5456
CREATE TABLE t5 (c1 INTEGER NOT NULL);
5457
CREATE TABLE t6 (c1 INTEGER NOT NULL);
5458
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5459
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5460
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
5461
INSERT INTO t4 (c1) VALUES(10);
5462
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
5463
SELECT t1.c1,t5.c1 FROM t1 NATURAL LEFT OUTER JOIN t5;
5475
SELECT t1.c1,t5.c1 FROM t1 NATURAL LEFT OUTER JOIN t5 WHERE t1.c1 <> 5;
5486
DROP TABLE t1,t2,t3,t4,t5,t6;
5487
CREATE TABLE t1 (c1 BIGINT NOT NULL);
5488
CREATE TABLE t2 (c1 BIGINT NOT NULL);
5489
CREATE TABLE t3 (c1 BIGINT NOT NULL);
5490
CREATE TABLE t4 (c1 BIGINT NOT NULL);
5491
CREATE TABLE t5 (c1 BIGINT NOT NULL);
5492
CREATE TABLE t6 (c1 BIGINT NOT NULL);
5493
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5494
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5495
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
5496
INSERT INTO t4 (c1) VALUES(10);
5497
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
5498
SELECT t1.c1,t5.c1 FROM t1 NATURAL LEFT OUTER JOIN t5;
5510
SELECT t1.c1,t5.c1 FROM t1 NATURAL LEFT OUTER JOIN t5 WHERE t1.c1 <> 5;
5521
DROP TABLE t1,t2,t3,t4,t5,t6;
5522
CREATE TABLE t1 (c1 TINYINT NOT NULL);
5523
CREATE TABLE t2 (c1 TINYINT NOT NULL);
5524
CREATE TABLE t3 (c1 TINYINT NOT NULL);
5525
CREATE TABLE t4 (c1 TINYINT NOT NULL);
5526
CREATE TABLE t5 (c1 TINYINT NOT NULL);
5527
CREATE TABLE t6 (c1 TINYINT NOT NULL);
5528
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5529
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5530
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
5531
INSERT INTO t4 (c1) VALUES(10);
5532
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
5533
SELECT t1.c1,t6.c1 FROM t1 NATURAL LEFT OUTER JOIN t6;
5545
SELECT t1.c1,t6.c1 FROM t1 NATURAL LEFT OUTER JOIN t6 WHERE t1.c1 <> 5;
5556
DROP TABLE t1,t2,t3,t4,t5,t6;
5557
CREATE TABLE t1 (c1 SMALLINT NOT NULL);
5558
CREATE TABLE t2 (c1 SMALLINT NOT NULL);
5559
CREATE TABLE t3 (c1 SMALLINT NOT NULL);
5560
CREATE TABLE t4 (c1 SMALLINT NOT NULL);
5561
CREATE TABLE t5 (c1 SMALLINT NOT NULL);
5562
CREATE TABLE t6 (c1 SMALLINT NOT NULL);
5563
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5564
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5565
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
5566
INSERT INTO t4 (c1) VALUES(10);
5567
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
5568
SELECT t1.c1,t6.c1 FROM t1 NATURAL LEFT OUTER JOIN t6;
5580
SELECT t1.c1,t6.c1 FROM t1 NATURAL LEFT OUTER JOIN t6 WHERE t1.c1 <> 5;
5591
DROP TABLE t1,t2,t3,t4,t5,t6;
5592
CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
5593
CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
5594
CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
5595
CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
5596
CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
5597
CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
5598
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5599
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5600
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
5601
INSERT INTO t4 (c1) VALUES(10);
5602
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
5603
SELECT t1.c1,t6.c1 FROM t1 NATURAL LEFT OUTER JOIN t6;
5615
SELECT t1.c1,t6.c1 FROM t1 NATURAL LEFT OUTER JOIN t6 WHERE t1.c1 <> 5;
5626
DROP TABLE t1,t2,t3,t4,t5,t6;
5627
CREATE TABLE t1 (c1 INT NOT NULL);
5628
CREATE TABLE t2 (c1 INT NOT NULL);
5629
CREATE TABLE t3 (c1 INT NOT NULL);
5630
CREATE TABLE t4 (c1 INT NOT NULL);
5631
CREATE TABLE t5 (c1 INT NOT NULL);
5632
CREATE TABLE t6 (c1 INT NOT NULL);
5633
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5634
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5635
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
5636
INSERT INTO t4 (c1) VALUES(10);
5637
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
5638
SELECT t1.c1,t6.c1 FROM t1 NATURAL LEFT OUTER JOIN t6;
5650
SELECT t1.c1,t6.c1 FROM t1 NATURAL LEFT OUTER JOIN t6 WHERE t1.c1 <> 5;
5661
DROP TABLE t1,t2,t3,t4,t5,t6;
5662
CREATE TABLE t1 (c1 INTEGER NOT NULL);
5663
CREATE TABLE t2 (c1 INTEGER NOT NULL);
5664
CREATE TABLE t3 (c1 INTEGER NOT NULL);
5665
CREATE TABLE t4 (c1 INTEGER NOT NULL);
5666
CREATE TABLE t5 (c1 INTEGER NOT NULL);
5667
CREATE TABLE t6 (c1 INTEGER NOT NULL);
5668
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5669
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5670
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
5671
INSERT INTO t4 (c1) VALUES(10);
5672
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
5673
SELECT t1.c1,t6.c1 FROM t1 NATURAL LEFT OUTER JOIN t6;
5685
SELECT t1.c1,t6.c1 FROM t1 NATURAL LEFT OUTER JOIN t6 WHERE t1.c1 <> 5;
5696
DROP TABLE t1,t2,t3,t4,t5,t6;
5697
CREATE TABLE t1 (c1 BIGINT NOT NULL);
5698
CREATE TABLE t2 (c1 BIGINT NOT NULL);
5699
CREATE TABLE t3 (c1 BIGINT NOT NULL);
5700
CREATE TABLE t4 (c1 BIGINT NOT NULL);
5701
CREATE TABLE t5 (c1 BIGINT NOT NULL);
5702
CREATE TABLE t6 (c1 BIGINT NOT NULL);
5703
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5704
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5705
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
5706
INSERT INTO t4 (c1) VALUES(10);
5707
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
5708
SELECT t1.c1,t6.c1 FROM t1 NATURAL LEFT OUTER JOIN t6;
5720
SELECT t1.c1,t6.c1 FROM t1 NATURAL LEFT OUTER JOIN t6 WHERE t1.c1 <> 5;
5731
DROP TABLE t1,t2,t3,t4,t5,t6;
5732
CREATE TABLE t1 (c1 TINYINT NOT NULL);
5733
CREATE TABLE t2 (c1 TINYINT NOT NULL);
5734
CREATE TABLE t3 (c1 TINYINT NOT NULL);
5735
CREATE TABLE t4 (c1 TINYINT NOT NULL);
5736
CREATE TABLE t5 (c1 TINYINT NOT NULL);
5737
CREATE TABLE t6 (c1 TINYINT NOT NULL);
5738
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5739
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5740
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
5741
INSERT INTO t4 (c1) VALUES(10);
5742
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
5743
SELECT t1.c1,t2.c1 FROM t1 NATURAL LEFT OUTER JOIN t2;
5755
SELECT t1.c1,t2.c1 FROM t1 NATURAL LEFT OUTER JOIN t2 WHERE t1.c1 <=> 5;
5758
DROP TABLE t1,t2,t3,t4,t5,t6;
5759
CREATE TABLE t1 (c1 SMALLINT NOT NULL);
5760
CREATE TABLE t2 (c1 SMALLINT NOT NULL);
5761
CREATE TABLE t3 (c1 SMALLINT NOT NULL);
5762
CREATE TABLE t4 (c1 SMALLINT NOT NULL);
5763
CREATE TABLE t5 (c1 SMALLINT NOT NULL);
5764
CREATE TABLE t6 (c1 SMALLINT NOT NULL);
5765
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5766
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5767
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
5768
INSERT INTO t4 (c1) VALUES(10);
5769
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
5770
SELECT t1.c1,t2.c1 FROM t1 NATURAL LEFT OUTER JOIN t2;
5782
SELECT t1.c1,t2.c1 FROM t1 NATURAL LEFT OUTER JOIN t2 WHERE t1.c1 <=> 5;
5785
DROP TABLE t1,t2,t3,t4,t5,t6;
5786
CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
5787
CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
5788
CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
5789
CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
5790
CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
5791
CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
5792
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5793
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5794
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
5795
INSERT INTO t4 (c1) VALUES(10);
5796
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
5797
SELECT t1.c1,t2.c1 FROM t1 NATURAL LEFT OUTER JOIN t2;
5809
SELECT t1.c1,t2.c1 FROM t1 NATURAL LEFT OUTER JOIN t2 WHERE t1.c1 <=> 5;
5812
DROP TABLE t1,t2,t3,t4,t5,t6;
5813
CREATE TABLE t1 (c1 INT NOT NULL);
5814
CREATE TABLE t2 (c1 INT NOT NULL);
5815
CREATE TABLE t3 (c1 INT NOT NULL);
5816
CREATE TABLE t4 (c1 INT NOT NULL);
5817
CREATE TABLE t5 (c1 INT NOT NULL);
5818
CREATE TABLE t6 (c1 INT NOT NULL);
5819
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5820
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5821
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
5822
INSERT INTO t4 (c1) VALUES(10);
5823
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
5824
SELECT t1.c1,t2.c1 FROM t1 NATURAL LEFT OUTER JOIN t2;
5836
SELECT t1.c1,t2.c1 FROM t1 NATURAL LEFT OUTER JOIN t2 WHERE t1.c1 <=> 5;
5839
DROP TABLE t1,t2,t3,t4,t5,t6;
5840
CREATE TABLE t1 (c1 INTEGER NOT NULL);
5841
CREATE TABLE t2 (c1 INTEGER NOT NULL);
5842
CREATE TABLE t3 (c1 INTEGER NOT NULL);
5843
CREATE TABLE t4 (c1 INTEGER NOT NULL);
5844
CREATE TABLE t5 (c1 INTEGER NOT NULL);
5845
CREATE TABLE t6 (c1 INTEGER NOT NULL);
5846
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5847
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5848
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
5849
INSERT INTO t4 (c1) VALUES(10);
5850
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
5851
SELECT t1.c1,t2.c1 FROM t1 NATURAL LEFT OUTER JOIN t2;
5863
SELECT t1.c1,t2.c1 FROM t1 NATURAL LEFT OUTER JOIN t2 WHERE t1.c1 <=> 5;
5866
DROP TABLE t1,t2,t3,t4,t5,t6;
5867
CREATE TABLE t1 (c1 BIGINT NOT NULL);
5868
CREATE TABLE t2 (c1 BIGINT NOT NULL);
5869
CREATE TABLE t3 (c1 BIGINT NOT NULL);
5870
CREATE TABLE t4 (c1 BIGINT NOT NULL);
5871
CREATE TABLE t5 (c1 BIGINT NOT NULL);
5872
CREATE TABLE t6 (c1 BIGINT NOT NULL);
5873
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5874
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5875
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
5876
INSERT INTO t4 (c1) VALUES(10);
5877
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
5878
SELECT t1.c1,t2.c1 FROM t1 NATURAL LEFT OUTER JOIN t2;
5890
SELECT t1.c1,t2.c1 FROM t1 NATURAL LEFT OUTER JOIN t2 WHERE t1.c1 <=> 5;
5893
DROP TABLE t1,t2,t3,t4,t5,t6;
5894
CREATE TABLE t1 (c1 TINYINT NOT NULL);
5895
CREATE TABLE t2 (c1 TINYINT NOT NULL);
5896
CREATE TABLE t3 (c1 TINYINT NOT NULL);
5897
CREATE TABLE t4 (c1 TINYINT NOT NULL);
5898
CREATE TABLE t5 (c1 TINYINT NOT NULL);
5899
CREATE TABLE t6 (c1 TINYINT NOT NULL);
5900
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5901
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5902
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
5903
INSERT INTO t4 (c1) VALUES(10);
5904
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
5905
SELECT t1.c1,t3.c1 FROM t1 NATURAL LEFT OUTER JOIN t3;
5917
SELECT t1.c1,t3.c1 FROM t1 NATURAL LEFT OUTER JOIN t3 WHERE t1.c1 <=> 5;
5920
DROP TABLE t1,t2,t3,t4,t5,t6;
5921
CREATE TABLE t1 (c1 SMALLINT NOT NULL);
5922
CREATE TABLE t2 (c1 SMALLINT NOT NULL);
5923
CREATE TABLE t3 (c1 SMALLINT NOT NULL);
5924
CREATE TABLE t4 (c1 SMALLINT NOT NULL);
5925
CREATE TABLE t5 (c1 SMALLINT NOT NULL);
5926
CREATE TABLE t6 (c1 SMALLINT NOT NULL);
5927
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5928
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5929
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
5930
INSERT INTO t4 (c1) VALUES(10);
5931
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
5932
SELECT t1.c1,t3.c1 FROM t1 NATURAL LEFT OUTER JOIN t3;
5944
SELECT t1.c1,t3.c1 FROM t1 NATURAL LEFT OUTER JOIN t3 WHERE t1.c1 <=> 5;
5947
DROP TABLE t1,t2,t3,t4,t5,t6;
5948
CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
5949
CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
5950
CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
5951
CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
5952
CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
5953
CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
5954
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5955
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5956
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
5957
INSERT INTO t4 (c1) VALUES(10);
5958
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
5959
SELECT t1.c1,t3.c1 FROM t1 NATURAL LEFT OUTER JOIN t3;
5971
SELECT t1.c1,t3.c1 FROM t1 NATURAL LEFT OUTER JOIN t3 WHERE t1.c1 <=> 5;
5974
DROP TABLE t1,t2,t3,t4,t5,t6;
5975
CREATE TABLE t1 (c1 INT NOT NULL);
5976
CREATE TABLE t2 (c1 INT NOT NULL);
5977
CREATE TABLE t3 (c1 INT NOT NULL);
5978
CREATE TABLE t4 (c1 INT NOT NULL);
5979
CREATE TABLE t5 (c1 INT NOT NULL);
5980
CREATE TABLE t6 (c1 INT NOT NULL);
5981
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5982
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5983
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
5984
INSERT INTO t4 (c1) VALUES(10);
5985
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
5986
SELECT t1.c1,t3.c1 FROM t1 NATURAL LEFT OUTER JOIN t3;
5998
SELECT t1.c1,t3.c1 FROM t1 NATURAL LEFT OUTER JOIN t3 WHERE t1.c1 <=> 5;
6001
DROP TABLE t1,t2,t3,t4,t5,t6;
6002
CREATE TABLE t1 (c1 INTEGER NOT NULL);
6003
CREATE TABLE t2 (c1 INTEGER NOT NULL);
6004
CREATE TABLE t3 (c1 INTEGER NOT NULL);
6005
CREATE TABLE t4 (c1 INTEGER NOT NULL);
6006
CREATE TABLE t5 (c1 INTEGER NOT NULL);
6007
CREATE TABLE t6 (c1 INTEGER NOT NULL);
6008
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
6009
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
6010
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
6011
INSERT INTO t4 (c1) VALUES(10);
6012
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
6013
SELECT t1.c1,t3.c1 FROM t1 NATURAL LEFT OUTER JOIN t3;
6025
SELECT t1.c1,t3.c1 FROM t1 NATURAL LEFT OUTER JOIN t3 WHERE t1.c1 <=> 5;
6028
DROP TABLE t1,t2,t3,t4,t5,t6;
6029
CREATE TABLE t1 (c1 BIGINT NOT NULL);
6030
CREATE TABLE t2 (c1 BIGINT NOT NULL);
6031
CREATE TABLE t3 (c1 BIGINT NOT NULL);
6032
CREATE TABLE t4 (c1 BIGINT NOT NULL);
6033
CREATE TABLE t5 (c1 BIGINT NOT NULL);
6034
CREATE TABLE t6 (c1 BIGINT NOT NULL);
6035
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
6036
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
6037
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
6038
INSERT INTO t4 (c1) VALUES(10);
6039
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
6040
SELECT t1.c1,t3.c1 FROM t1 NATURAL LEFT OUTER JOIN t3;
6052
SELECT t1.c1,t3.c1 FROM t1 NATURAL LEFT OUTER JOIN t3 WHERE t1.c1 <=> 5;
6055
DROP TABLE t1,t2,t3,t4,t5,t6;
6056
CREATE TABLE t1 (c1 TINYINT NOT NULL);
6057
CREATE TABLE t2 (c1 TINYINT NOT NULL);
6058
CREATE TABLE t3 (c1 TINYINT NOT NULL);
6059
CREATE TABLE t4 (c1 TINYINT NOT NULL);
6060
CREATE TABLE t5 (c1 TINYINT NOT NULL);
6061
CREATE TABLE t6 (c1 TINYINT NOT NULL);
6062
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
6063
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
6064
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
6065
INSERT INTO t4 (c1) VALUES(10);
6066
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
6067
SELECT t1.c1,t4.c1 FROM t1 NATURAL LEFT OUTER JOIN t4;
6079
SELECT t1.c1,t4.c1 FROM t1 NATURAL LEFT OUTER JOIN t4 WHERE t1.c1 <=> 5;
6082
DROP TABLE t1,t2,t3,t4,t5,t6;
6083
CREATE TABLE t1 (c1 SMALLINT NOT NULL);
6084
CREATE TABLE t2 (c1 SMALLINT NOT NULL);
6085
CREATE TABLE t3 (c1 SMALLINT NOT NULL);
6086
CREATE TABLE t4 (c1 SMALLINT NOT NULL);
6087
CREATE TABLE t5 (c1 SMALLINT NOT NULL);
6088
CREATE TABLE t6 (c1 SMALLINT NOT NULL);
6089
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
6090
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
6091
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
6092
INSERT INTO t4 (c1) VALUES(10);
6093
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
6094
SELECT t1.c1,t4.c1 FROM t1 NATURAL LEFT OUTER JOIN t4;
6106
SELECT t1.c1,t4.c1 FROM t1 NATURAL LEFT OUTER JOIN t4 WHERE t1.c1 <=> 5;
6109
DROP TABLE t1,t2,t3,t4,t5,t6;
6110
CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
6111
CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
6112
CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
6113
CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
6114
CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
6115
CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
6116
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
6117
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
6118
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
6119
INSERT INTO t4 (c1) VALUES(10);
6120
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
6121
SELECT t1.c1,t4.c1 FROM t1 NATURAL LEFT OUTER JOIN t4;
6133
SELECT t1.c1,t4.c1 FROM t1 NATURAL LEFT OUTER JOIN t4 WHERE t1.c1 <=> 5;
6136
DROP TABLE t1,t2,t3,t4,t5,t6;
6137
CREATE TABLE t1 (c1 INT NOT NULL);
6138
CREATE TABLE t2 (c1 INT NOT NULL);
6139
CREATE TABLE t3 (c1 INT NOT NULL);
6140
CREATE TABLE t4 (c1 INT NOT NULL);
6141
CREATE TABLE t5 (c1 INT NOT NULL);
6142
CREATE TABLE t6 (c1 INT NOT NULL);
6143
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
6144
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
6145
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
6146
INSERT INTO t4 (c1) VALUES(10);
6147
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
6148
SELECT t1.c1,t4.c1 FROM t1 NATURAL LEFT OUTER JOIN t4;
6160
SELECT t1.c1,t4.c1 FROM t1 NATURAL LEFT OUTER JOIN t4 WHERE t1.c1 <=> 5;
6163
DROP TABLE t1,t2,t3,t4,t5,t6;
6164
CREATE TABLE t1 (c1 INTEGER NOT NULL);
6165
CREATE TABLE t2 (c1 INTEGER NOT NULL);
6166
CREATE TABLE t3 (c1 INTEGER NOT NULL);
6167
CREATE TABLE t4 (c1 INTEGER NOT NULL);
6168
CREATE TABLE t5 (c1 INTEGER NOT NULL);
6169
CREATE TABLE t6 (c1 INTEGER NOT NULL);
6170
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
6171
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
6172
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
6173
INSERT INTO t4 (c1) VALUES(10);
6174
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
6175
SELECT t1.c1,t4.c1 FROM t1 NATURAL LEFT OUTER JOIN t4;
6187
SELECT t1.c1,t4.c1 FROM t1 NATURAL LEFT OUTER JOIN t4 WHERE t1.c1 <=> 5;
6190
DROP TABLE t1,t2,t3,t4,t5,t6;
6191
CREATE TABLE t1 (c1 BIGINT NOT NULL);
6192
CREATE TABLE t2 (c1 BIGINT NOT NULL);
6193
CREATE TABLE t3 (c1 BIGINT NOT NULL);
6194
CREATE TABLE t4 (c1 BIGINT NOT NULL);
6195
CREATE TABLE t5 (c1 BIGINT NOT NULL);
6196
CREATE TABLE t6 (c1 BIGINT NOT NULL);
6197
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
6198
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
6199
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
6200
INSERT INTO t4 (c1) VALUES(10);
6201
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
6202
SELECT t1.c1,t4.c1 FROM t1 NATURAL LEFT OUTER JOIN t4;
6214
SELECT t1.c1,t4.c1 FROM t1 NATURAL LEFT OUTER JOIN t4 WHERE t1.c1 <=> 5;
6217
DROP TABLE t1,t2,t3,t4,t5,t6;
6218
CREATE TABLE t1 (c1 TINYINT NOT NULL);
6219
CREATE TABLE t2 (c1 TINYINT NOT NULL);
6220
CREATE TABLE t3 (c1 TINYINT NOT NULL);
6221
CREATE TABLE t4 (c1 TINYINT NOT NULL);
6222
CREATE TABLE t5 (c1 TINYINT NOT NULL);
6223
CREATE TABLE t6 (c1 TINYINT NOT NULL);
6224
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
6225
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
6226
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
6227
INSERT INTO t4 (c1) VALUES(10);
6228
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
6229
SELECT t1.c1,t5.c1 FROM t1 NATURAL LEFT OUTER JOIN t5;
6241
SELECT t1.c1,t5.c1 FROM t1 NATURAL LEFT OUTER JOIN t5 WHERE t1.c1 <=> 5;
6244
DROP TABLE t1,t2,t3,t4,t5,t6;
6245
CREATE TABLE t1 (c1 SMALLINT NOT NULL);
6246
CREATE TABLE t2 (c1 SMALLINT NOT NULL);
6247
CREATE TABLE t3 (c1 SMALLINT NOT NULL);
6248
CREATE TABLE t4 (c1 SMALLINT NOT NULL);
6249
CREATE TABLE t5 (c1 SMALLINT NOT NULL);
6250
CREATE TABLE t6 (c1 SMALLINT NOT NULL);
6251
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
6252
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
6253
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
6254
INSERT INTO t4 (c1) VALUES(10);
6255
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
6256
SELECT t1.c1,t5.c1 FROM t1 NATURAL LEFT OUTER JOIN t5;
6268
SELECT t1.c1,t5.c1 FROM t1 NATURAL LEFT OUTER JOIN t5 WHERE t1.c1 <=> 5;
6271
DROP TABLE t1,t2,t3,t4,t5,t6;
6272
CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
6273
CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
6274
CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
6275
CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
6276
CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
6277
CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
6278
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
6279
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
6280
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
6281
INSERT INTO t4 (c1) VALUES(10);
6282
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
6283
SELECT t1.c1,t5.c1 FROM t1 NATURAL LEFT OUTER JOIN t5;
6295
SELECT t1.c1,t5.c1 FROM t1 NATURAL LEFT OUTER JOIN t5 WHERE t1.c1 <=> 5;
6298
DROP TABLE t1,t2,t3,t4,t5,t6;
6299
CREATE TABLE t1 (c1 INT NOT NULL);
6300
CREATE TABLE t2 (c1 INT NOT NULL);
6301
CREATE TABLE t3 (c1 INT NOT NULL);
6302
CREATE TABLE t4 (c1 INT NOT NULL);
6303
CREATE TABLE t5 (c1 INT NOT NULL);
6304
CREATE TABLE t6 (c1 INT NOT NULL);
6305
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
6306
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
6307
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
6308
INSERT INTO t4 (c1) VALUES(10);
6309
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
6310
SELECT t1.c1,t5.c1 FROM t1 NATURAL LEFT OUTER JOIN t5;
6322
SELECT t1.c1,t5.c1 FROM t1 NATURAL LEFT OUTER JOIN t5 WHERE t1.c1 <=> 5;
6325
DROP TABLE t1,t2,t3,t4,t5,t6;
6326
CREATE TABLE t1 (c1 INTEGER NOT NULL);
6327
CREATE TABLE t2 (c1 INTEGER NOT NULL);
6328
CREATE TABLE t3 (c1 INTEGER NOT NULL);
6329
CREATE TABLE t4 (c1 INTEGER NOT NULL);
6330
CREATE TABLE t5 (c1 INTEGER NOT NULL);
6331
CREATE TABLE t6 (c1 INTEGER NOT NULL);
6332
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
6333
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
6334
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
6335
INSERT INTO t4 (c1) VALUES(10);
6336
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
6337
SELECT t1.c1,t5.c1 FROM t1 NATURAL LEFT OUTER JOIN t5;
6349
SELECT t1.c1,t5.c1 FROM t1 NATURAL LEFT OUTER JOIN t5 WHERE t1.c1 <=> 5;
6352
DROP TABLE t1,t2,t3,t4,t5,t6;
6353
CREATE TABLE t1 (c1 BIGINT NOT NULL);
6354
CREATE TABLE t2 (c1 BIGINT NOT NULL);
6355
CREATE TABLE t3 (c1 BIGINT NOT NULL);
6356
CREATE TABLE t4 (c1 BIGINT NOT NULL);
6357
CREATE TABLE t5 (c1 BIGINT NOT NULL);
6358
CREATE TABLE t6 (c1 BIGINT NOT NULL);
6359
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
6360
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
6361
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
6362
INSERT INTO t4 (c1) VALUES(10);
6363
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
6364
SELECT t1.c1,t5.c1 FROM t1 NATURAL LEFT OUTER JOIN t5;
6376
SELECT t1.c1,t5.c1 FROM t1 NATURAL LEFT OUTER JOIN t5 WHERE t1.c1 <=> 5;
6379
DROP TABLE t1,t2,t3,t4,t5,t6;
6380
CREATE TABLE t1 (c1 TINYINT NOT NULL);
6381
CREATE TABLE t2 (c1 TINYINT NOT NULL);
6382
CREATE TABLE t3 (c1 TINYINT NOT NULL);
6383
CREATE TABLE t4 (c1 TINYINT NOT NULL);
6384
CREATE TABLE t5 (c1 TINYINT NOT NULL);
6385
CREATE TABLE t6 (c1 TINYINT NOT NULL);
6386
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
6387
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
6388
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
6389
INSERT INTO t4 (c1) VALUES(10);
6390
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
6391
SELECT t1.c1,t6.c1 FROM t1 NATURAL LEFT OUTER JOIN t6;
6403
SELECT t1.c1,t6.c1 FROM t1 NATURAL LEFT OUTER JOIN t6 WHERE t1.c1 <=> 5;
6406
DROP TABLE t1,t2,t3,t4,t5,t6;
6407
CREATE TABLE t1 (c1 SMALLINT NOT NULL);
6408
CREATE TABLE t2 (c1 SMALLINT NOT NULL);
6409
CREATE TABLE t3 (c1 SMALLINT NOT NULL);
6410
CREATE TABLE t4 (c1 SMALLINT NOT NULL);
6411
CREATE TABLE t5 (c1 SMALLINT NOT NULL);
6412
CREATE TABLE t6 (c1 SMALLINT NOT NULL);
6413
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
6414
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
6415
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
6416
INSERT INTO t4 (c1) VALUES(10);
6417
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
6418
SELECT t1.c1,t6.c1 FROM t1 NATURAL LEFT OUTER JOIN t6;
6430
SELECT t1.c1,t6.c1 FROM t1 NATURAL LEFT OUTER JOIN t6 WHERE t1.c1 <=> 5;
6433
DROP TABLE t1,t2,t3,t4,t5,t6;
6434
CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
6435
CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
6436
CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
6437
CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
6438
CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
6439
CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
6440
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
6441
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
6442
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
6443
INSERT INTO t4 (c1) VALUES(10);
6444
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
6445
SELECT t1.c1,t6.c1 FROM t1 NATURAL LEFT OUTER JOIN t6;
6457
SELECT t1.c1,t6.c1 FROM t1 NATURAL LEFT OUTER JOIN t6 WHERE t1.c1 <=> 5;
6460
DROP TABLE t1,t2,t3,t4,t5,t6;
6461
CREATE TABLE t1 (c1 INT NOT NULL);
6462
CREATE TABLE t2 (c1 INT NOT NULL);
6463
CREATE TABLE t3 (c1 INT NOT NULL);
6464
CREATE TABLE t4 (c1 INT NOT NULL);
6465
CREATE TABLE t5 (c1 INT NOT NULL);
6466
CREATE TABLE t6 (c1 INT NOT NULL);
6467
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
6468
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
6469
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
6470
INSERT INTO t4 (c1) VALUES(10);
6471
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
6472
SELECT t1.c1,t6.c1 FROM t1 NATURAL LEFT OUTER JOIN t6;
6484
SELECT t1.c1,t6.c1 FROM t1 NATURAL LEFT OUTER JOIN t6 WHERE t1.c1 <=> 5;
6487
DROP TABLE t1,t2,t3,t4,t5,t6;
6488
CREATE TABLE t1 (c1 INTEGER NOT NULL);
6489
CREATE TABLE t2 (c1 INTEGER NOT NULL);
6490
CREATE TABLE t3 (c1 INTEGER NOT NULL);
6491
CREATE TABLE t4 (c1 INTEGER NOT NULL);
6492
CREATE TABLE t5 (c1 INTEGER NOT NULL);
6493
CREATE TABLE t6 (c1 INTEGER NOT NULL);
6494
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
6495
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
6496
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
6497
INSERT INTO t4 (c1) VALUES(10);
6498
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
6499
SELECT t1.c1,t6.c1 FROM t1 NATURAL LEFT OUTER JOIN t6;
6511
SELECT t1.c1,t6.c1 FROM t1 NATURAL LEFT OUTER JOIN t6 WHERE t1.c1 <=> 5;
6514
DROP TABLE t1,t2,t3,t4,t5,t6;
6515
CREATE TABLE t1 (c1 BIGINT NOT NULL);
6516
CREATE TABLE t2 (c1 BIGINT NOT NULL);
6517
CREATE TABLE t3 (c1 BIGINT NOT NULL);
6518
CREATE TABLE t4 (c1 BIGINT NOT NULL);
6519
CREATE TABLE t5 (c1 BIGINT NOT NULL);
6520
CREATE TABLE t6 (c1 BIGINT NOT NULL);
6521
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
6522
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
6523
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
6524
INSERT INTO t4 (c1) VALUES(10);
6525
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
6526
SELECT t1.c1,t6.c1 FROM t1 NATURAL LEFT OUTER JOIN t6;
6538
SELECT t1.c1,t6.c1 FROM t1 NATURAL LEFT OUTER JOIN t6 WHERE t1.c1 <=> 5;
6541
DROP TABLE t1,t2,t3,t4,t5,t6;