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 INNER JOIN t2 USING (c1);
25
SELECT t1.c1,t2.c1 FROM t1 INNER JOIN t2 ON t1.c1 = t2.c1;
37
SELECT t1.c1,t2.c1 FROM t1 INNER JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 < 5;
44
DROP TABLE t1,t2,t3,t4,t5,t6;
45
CREATE TABLE t1 (c1 SMALLINT NOT NULL);
46
CREATE TABLE t2 (c1 SMALLINT NOT NULL);
47
CREATE TABLE t3 (c1 SMALLINT NOT NULL);
48
CREATE TABLE t4 (c1 SMALLINT NOT NULL);
49
CREATE TABLE t5 (c1 SMALLINT NOT NULL);
50
CREATE TABLE t6 (c1 SMALLINT NOT NULL);
51
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
52
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
53
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
54
INSERT INTO t4 (c1) VALUES(10);
55
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
56
SELECT t1.c1,t2.c1 FROM t1 INNER JOIN t2 USING (c1);
68
SELECT t1.c1,t2.c1 FROM t1 INNER JOIN t2 ON t1.c1 = t2.c1;
80
SELECT t1.c1,t2.c1 FROM t1 INNER JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 < 5;
87
DROP TABLE t1,t2,t3,t4,t5,t6;
88
CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
89
CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
90
CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
91
CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
92
CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
93
CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
94
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
95
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
96
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
97
INSERT INTO t4 (c1) VALUES(10);
98
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
99
SELECT t1.c1,t2.c1 FROM t1 INNER JOIN t2 USING (c1);
111
SELECT t1.c1,t2.c1 FROM t1 INNER JOIN t2 ON t1.c1 = t2.c1;
123
SELECT t1.c1,t2.c1 FROM t1 INNER JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 < 5;
130
DROP TABLE t1,t2,t3,t4,t5,t6;
131
CREATE TABLE t1 (c1 INT NOT NULL);
132
CREATE TABLE t2 (c1 INT NOT NULL);
133
CREATE TABLE t3 (c1 INT NOT NULL);
134
CREATE TABLE t4 (c1 INT NOT NULL);
135
CREATE TABLE t5 (c1 INT NOT NULL);
136
CREATE TABLE t6 (c1 INT NOT NULL);
137
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
138
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
139
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
140
INSERT INTO t4 (c1) VALUES(10);
141
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
142
SELECT t1.c1,t2.c1 FROM t1 INNER JOIN t2 USING (c1);
154
SELECT t1.c1,t2.c1 FROM t1 INNER JOIN t2 ON t1.c1 = t2.c1;
166
SELECT t1.c1,t2.c1 FROM t1 INNER JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 < 5;
173
DROP TABLE t1,t2,t3,t4,t5,t6;
174
CREATE TABLE t1 (c1 INTEGER NOT NULL);
175
CREATE TABLE t2 (c1 INTEGER NOT NULL);
176
CREATE TABLE t3 (c1 INTEGER NOT NULL);
177
CREATE TABLE t4 (c1 INTEGER NOT NULL);
178
CREATE TABLE t5 (c1 INTEGER NOT NULL);
179
CREATE TABLE t6 (c1 INTEGER NOT NULL);
180
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
181
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
182
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
183
INSERT INTO t4 (c1) VALUES(10);
184
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
185
SELECT t1.c1,t2.c1 FROM t1 INNER JOIN t2 USING (c1);
197
SELECT t1.c1,t2.c1 FROM t1 INNER JOIN t2 ON t1.c1 = t2.c1;
209
SELECT t1.c1,t2.c1 FROM t1 INNER JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 < 5;
216
DROP TABLE t1,t2,t3,t4,t5,t6;
217
CREATE TABLE t1 (c1 BIGINT NOT NULL);
218
CREATE TABLE t2 (c1 BIGINT NOT NULL);
219
CREATE TABLE t3 (c1 BIGINT NOT NULL);
220
CREATE TABLE t4 (c1 BIGINT NOT NULL);
221
CREATE TABLE t5 (c1 BIGINT NOT NULL);
222
CREATE TABLE t6 (c1 BIGINT NOT NULL);
223
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
224
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
225
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
226
INSERT INTO t4 (c1) VALUES(10);
227
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
228
SELECT t1.c1,t2.c1 FROM t1 INNER JOIN t2 USING (c1);
240
SELECT t1.c1,t2.c1 FROM t1 INNER JOIN t2 ON t1.c1 = t2.c1;
252
SELECT t1.c1,t2.c1 FROM t1 INNER JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 < 5;
259
DROP TABLE t1,t2,t3,t4,t5,t6;
260
CREATE TABLE t1 (c1 TINYINT NOT NULL);
261
CREATE TABLE t2 (c1 TINYINT NOT NULL);
262
CREATE TABLE t3 (c1 TINYINT NOT NULL);
263
CREATE TABLE t4 (c1 TINYINT NOT NULL);
264
CREATE TABLE t5 (c1 TINYINT NOT NULL);
265
CREATE TABLE t6 (c1 TINYINT NOT NULL);
266
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
267
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
268
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
269
INSERT INTO t4 (c1) VALUES(10);
270
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
271
SELECT t1.c1,t3.c1 FROM t1 INNER JOIN t3 USING (c1);
278
SELECT t1.c1,t3.c1 FROM t1 INNER JOIN t3 ON t1.c1 = t3.c1;
285
SELECT t1.c1,t3.c1 FROM t1 INNER JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 < 5;
289
DROP TABLE t1,t2,t3,t4,t5,t6;
290
CREATE TABLE t1 (c1 SMALLINT NOT NULL);
291
CREATE TABLE t2 (c1 SMALLINT NOT NULL);
292
CREATE TABLE t3 (c1 SMALLINT NOT NULL);
293
CREATE TABLE t4 (c1 SMALLINT NOT NULL);
294
CREATE TABLE t5 (c1 SMALLINT NOT NULL);
295
CREATE TABLE t6 (c1 SMALLINT NOT NULL);
296
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
297
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
298
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
299
INSERT INTO t4 (c1) VALUES(10);
300
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
301
SELECT t1.c1,t3.c1 FROM t1 INNER JOIN t3 USING (c1);
308
SELECT t1.c1,t3.c1 FROM t1 INNER JOIN t3 ON t1.c1 = t3.c1;
315
SELECT t1.c1,t3.c1 FROM t1 INNER JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 < 5;
319
DROP TABLE t1,t2,t3,t4,t5,t6;
320
CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
321
CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
322
CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
323
CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
324
CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
325
CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
326
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
327
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
328
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
329
INSERT INTO t4 (c1) VALUES(10);
330
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
331
SELECT t1.c1,t3.c1 FROM t1 INNER JOIN t3 USING (c1);
338
SELECT t1.c1,t3.c1 FROM t1 INNER JOIN t3 ON t1.c1 = t3.c1;
345
SELECT t1.c1,t3.c1 FROM t1 INNER JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 < 5;
349
DROP TABLE t1,t2,t3,t4,t5,t6;
350
CREATE TABLE t1 (c1 INT NOT NULL);
351
CREATE TABLE t2 (c1 INT NOT NULL);
352
CREATE TABLE t3 (c1 INT NOT NULL);
353
CREATE TABLE t4 (c1 INT NOT NULL);
354
CREATE TABLE t5 (c1 INT NOT NULL);
355
CREATE TABLE t6 (c1 INT NOT NULL);
356
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
357
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
358
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
359
INSERT INTO t4 (c1) VALUES(10);
360
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
361
SELECT t1.c1,t3.c1 FROM t1 INNER JOIN t3 USING (c1);
368
SELECT t1.c1,t3.c1 FROM t1 INNER JOIN t3 ON t1.c1 = t3.c1;
375
SELECT t1.c1,t3.c1 FROM t1 INNER JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 < 5;
379
DROP TABLE t1,t2,t3,t4,t5,t6;
380
CREATE TABLE t1 (c1 INTEGER NOT NULL);
381
CREATE TABLE t2 (c1 INTEGER NOT NULL);
382
CREATE TABLE t3 (c1 INTEGER NOT NULL);
383
CREATE TABLE t4 (c1 INTEGER NOT NULL);
384
CREATE TABLE t5 (c1 INTEGER NOT NULL);
385
CREATE TABLE t6 (c1 INTEGER NOT NULL);
386
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
387
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
388
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
389
INSERT INTO t4 (c1) VALUES(10);
390
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
391
SELECT t1.c1,t3.c1 FROM t1 INNER JOIN t3 USING (c1);
398
SELECT t1.c1,t3.c1 FROM t1 INNER JOIN t3 ON t1.c1 = t3.c1;
405
SELECT t1.c1,t3.c1 FROM t1 INNER JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 < 5;
409
DROP TABLE t1,t2,t3,t4,t5,t6;
410
CREATE TABLE t1 (c1 BIGINT NOT NULL);
411
CREATE TABLE t2 (c1 BIGINT NOT NULL);
412
CREATE TABLE t3 (c1 BIGINT NOT NULL);
413
CREATE TABLE t4 (c1 BIGINT NOT NULL);
414
CREATE TABLE t5 (c1 BIGINT NOT NULL);
415
CREATE TABLE t6 (c1 BIGINT NOT NULL);
416
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
417
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
418
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
419
INSERT INTO t4 (c1) VALUES(10);
420
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
421
SELECT t1.c1,t3.c1 FROM t1 INNER JOIN t3 USING (c1);
428
SELECT t1.c1,t3.c1 FROM t1 INNER JOIN t3 ON t1.c1 = t3.c1;
435
SELECT t1.c1,t3.c1 FROM t1 INNER JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 < 5;
439
DROP TABLE t1,t2,t3,t4,t5,t6;
440
CREATE TABLE t1 (c1 TINYINT NOT NULL);
441
CREATE TABLE t2 (c1 TINYINT NOT NULL);
442
CREATE TABLE t3 (c1 TINYINT NOT NULL);
443
CREATE TABLE t4 (c1 TINYINT NOT NULL);
444
CREATE TABLE t5 (c1 TINYINT NOT NULL);
445
CREATE TABLE t6 (c1 TINYINT NOT NULL);
446
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
447
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
448
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
449
INSERT INTO t4 (c1) VALUES(10);
450
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
451
SELECT t1.c1,t4.c1 FROM t1 INNER JOIN t4 USING (c1);
453
SELECT t1.c1,t4.c1 FROM t1 INNER JOIN t4 ON t1.c1 = t4.c1;
455
SELECT t1.c1,t4.c1 FROM t1 INNER JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 < 5;
457
DROP TABLE t1,t2,t3,t4,t5,t6;
458
CREATE TABLE t1 (c1 SMALLINT NOT NULL);
459
CREATE TABLE t2 (c1 SMALLINT NOT NULL);
460
CREATE TABLE t3 (c1 SMALLINT NOT NULL);
461
CREATE TABLE t4 (c1 SMALLINT NOT NULL);
462
CREATE TABLE t5 (c1 SMALLINT NOT NULL);
463
CREATE TABLE t6 (c1 SMALLINT NOT NULL);
464
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
465
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
466
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
467
INSERT INTO t4 (c1) VALUES(10);
468
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
469
SELECT t1.c1,t4.c1 FROM t1 INNER JOIN t4 USING (c1);
471
SELECT t1.c1,t4.c1 FROM t1 INNER JOIN t4 ON t1.c1 = t4.c1;
473
SELECT t1.c1,t4.c1 FROM t1 INNER JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 < 5;
475
DROP TABLE t1,t2,t3,t4,t5,t6;
476
CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
477
CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
478
CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
479
CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
480
CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
481
CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
482
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
483
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
484
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
485
INSERT INTO t4 (c1) VALUES(10);
486
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
487
SELECT t1.c1,t4.c1 FROM t1 INNER JOIN t4 USING (c1);
489
SELECT t1.c1,t4.c1 FROM t1 INNER JOIN t4 ON t1.c1 = t4.c1;
491
SELECT t1.c1,t4.c1 FROM t1 INNER JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 < 5;
493
DROP TABLE t1,t2,t3,t4,t5,t6;
494
CREATE TABLE t1 (c1 INT NOT NULL);
495
CREATE TABLE t2 (c1 INT NOT NULL);
496
CREATE TABLE t3 (c1 INT NOT NULL);
497
CREATE TABLE t4 (c1 INT NOT NULL);
498
CREATE TABLE t5 (c1 INT NOT NULL);
499
CREATE TABLE t6 (c1 INT NOT NULL);
500
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
501
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
502
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
503
INSERT INTO t4 (c1) VALUES(10);
504
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
505
SELECT t1.c1,t4.c1 FROM t1 INNER JOIN t4 USING (c1);
507
SELECT t1.c1,t4.c1 FROM t1 INNER JOIN t4 ON t1.c1 = t4.c1;
509
SELECT t1.c1,t4.c1 FROM t1 INNER JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 < 5;
511
DROP TABLE t1,t2,t3,t4,t5,t6;
512
CREATE TABLE t1 (c1 INTEGER NOT NULL);
513
CREATE TABLE t2 (c1 INTEGER NOT NULL);
514
CREATE TABLE t3 (c1 INTEGER NOT NULL);
515
CREATE TABLE t4 (c1 INTEGER NOT NULL);
516
CREATE TABLE t5 (c1 INTEGER NOT NULL);
517
CREATE TABLE t6 (c1 INTEGER NOT NULL);
518
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
519
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
520
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
521
INSERT INTO t4 (c1) VALUES(10);
522
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
523
SELECT t1.c1,t4.c1 FROM t1 INNER JOIN t4 USING (c1);
525
SELECT t1.c1,t4.c1 FROM t1 INNER JOIN t4 ON t1.c1 = t4.c1;
527
SELECT t1.c1,t4.c1 FROM t1 INNER JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 < 5;
529
DROP TABLE t1,t2,t3,t4,t5,t6;
530
CREATE TABLE t1 (c1 BIGINT NOT NULL);
531
CREATE TABLE t2 (c1 BIGINT NOT NULL);
532
CREATE TABLE t3 (c1 BIGINT NOT NULL);
533
CREATE TABLE t4 (c1 BIGINT NOT NULL);
534
CREATE TABLE t5 (c1 BIGINT NOT NULL);
535
CREATE TABLE t6 (c1 BIGINT NOT NULL);
536
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
537
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
538
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
539
INSERT INTO t4 (c1) VALUES(10);
540
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
541
SELECT t1.c1,t4.c1 FROM t1 INNER JOIN t4 USING (c1);
543
SELECT t1.c1,t4.c1 FROM t1 INNER JOIN t4 ON t1.c1 = t4.c1;
545
SELECT t1.c1,t4.c1 FROM t1 INNER JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 < 5;
547
DROP TABLE t1,t2,t3,t4,t5,t6;
548
CREATE TABLE t1 (c1 TINYINT NOT NULL);
549
CREATE TABLE t2 (c1 TINYINT NOT NULL);
550
CREATE TABLE t3 (c1 TINYINT NOT NULL);
551
CREATE TABLE t4 (c1 TINYINT NOT NULL);
552
CREATE TABLE t5 (c1 TINYINT NOT NULL);
553
CREATE TABLE t6 (c1 TINYINT NOT NULL);
554
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
555
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
556
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
557
INSERT INTO t4 (c1) VALUES(10);
558
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
559
SELECT t1.c1,t5.c1 FROM t1 INNER JOIN t5 USING (c1);
561
SELECT t1.c1,t5.c1 FROM t1 INNER JOIN t5 ON t1.c1 = t5.c1;
563
SELECT t1.c1,t5.c1 FROM t1 INNER JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 < 5;
565
DROP TABLE t1,t2,t3,t4,t5,t6;
566
CREATE TABLE t1 (c1 SMALLINT NOT NULL);
567
CREATE TABLE t2 (c1 SMALLINT NOT NULL);
568
CREATE TABLE t3 (c1 SMALLINT NOT NULL);
569
CREATE TABLE t4 (c1 SMALLINT NOT NULL);
570
CREATE TABLE t5 (c1 SMALLINT NOT NULL);
571
CREATE TABLE t6 (c1 SMALLINT NOT NULL);
572
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
573
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
574
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
575
INSERT INTO t4 (c1) VALUES(10);
576
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
577
SELECT t1.c1,t5.c1 FROM t1 INNER JOIN t5 USING (c1);
579
SELECT t1.c1,t5.c1 FROM t1 INNER JOIN t5 ON t1.c1 = t5.c1;
581
SELECT t1.c1,t5.c1 FROM t1 INNER JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 < 5;
583
DROP TABLE t1,t2,t3,t4,t5,t6;
584
CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
585
CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
586
CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
587
CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
588
CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
589
CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
590
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
591
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
592
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
593
INSERT INTO t4 (c1) VALUES(10);
594
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
595
SELECT t1.c1,t5.c1 FROM t1 INNER JOIN t5 USING (c1);
597
SELECT t1.c1,t5.c1 FROM t1 INNER JOIN t5 ON t1.c1 = t5.c1;
599
SELECT t1.c1,t5.c1 FROM t1 INNER JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 < 5;
601
DROP TABLE t1,t2,t3,t4,t5,t6;
602
CREATE TABLE t1 (c1 INT NOT NULL);
603
CREATE TABLE t2 (c1 INT NOT NULL);
604
CREATE TABLE t3 (c1 INT NOT NULL);
605
CREATE TABLE t4 (c1 INT NOT NULL);
606
CREATE TABLE t5 (c1 INT NOT NULL);
607
CREATE TABLE t6 (c1 INT NOT NULL);
608
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
609
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
610
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
611
INSERT INTO t4 (c1) VALUES(10);
612
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
613
SELECT t1.c1,t5.c1 FROM t1 INNER JOIN t5 USING (c1);
615
SELECT t1.c1,t5.c1 FROM t1 INNER JOIN t5 ON t1.c1 = t5.c1;
617
SELECT t1.c1,t5.c1 FROM t1 INNER JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 < 5;
619
DROP TABLE t1,t2,t3,t4,t5,t6;
620
CREATE TABLE t1 (c1 INTEGER NOT NULL);
621
CREATE TABLE t2 (c1 INTEGER NOT NULL);
622
CREATE TABLE t3 (c1 INTEGER NOT NULL);
623
CREATE TABLE t4 (c1 INTEGER NOT NULL);
624
CREATE TABLE t5 (c1 INTEGER NOT NULL);
625
CREATE TABLE t6 (c1 INTEGER NOT NULL);
626
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
627
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
628
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
629
INSERT INTO t4 (c1) VALUES(10);
630
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
631
SELECT t1.c1,t5.c1 FROM t1 INNER JOIN t5 USING (c1);
633
SELECT t1.c1,t5.c1 FROM t1 INNER JOIN t5 ON t1.c1 = t5.c1;
635
SELECT t1.c1,t5.c1 FROM t1 INNER JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 < 5;
637
DROP TABLE t1,t2,t3,t4,t5,t6;
638
CREATE TABLE t1 (c1 BIGINT NOT NULL);
639
CREATE TABLE t2 (c1 BIGINT NOT NULL);
640
CREATE TABLE t3 (c1 BIGINT NOT NULL);
641
CREATE TABLE t4 (c1 BIGINT NOT NULL);
642
CREATE TABLE t5 (c1 BIGINT NOT NULL);
643
CREATE TABLE t6 (c1 BIGINT NOT NULL);
644
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
645
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
646
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
647
INSERT INTO t4 (c1) VALUES(10);
648
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
649
SELECT t1.c1,t5.c1 FROM t1 INNER JOIN t5 USING (c1);
651
SELECT t1.c1,t5.c1 FROM t1 INNER JOIN t5 ON t1.c1 = t5.c1;
653
SELECT t1.c1,t5.c1 FROM t1 INNER JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 < 5;
655
DROP TABLE t1,t2,t3,t4,t5,t6;
656
CREATE TABLE t1 (c1 TINYINT NOT NULL);
657
CREATE TABLE t2 (c1 TINYINT NOT NULL);
658
CREATE TABLE t3 (c1 TINYINT NOT NULL);
659
CREATE TABLE t4 (c1 TINYINT NOT NULL);
660
CREATE TABLE t5 (c1 TINYINT NOT NULL);
661
CREATE TABLE t6 (c1 TINYINT NOT NULL);
662
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
663
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
664
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
665
INSERT INTO t4 (c1) VALUES(10);
666
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
667
SELECT t1.c1,t6.c1 FROM t1 INNER JOIN t6 USING (c1);
669
SELECT t1.c1,t6.c1 FROM t1 INNER JOIN t6 ON t1.c1 = t6.c1;
671
SELECT t1.c1,t6.c1 FROM t1 INNER JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 < 5;
673
DROP TABLE t1,t2,t3,t4,t5,t6;
674
CREATE TABLE t1 (c1 SMALLINT NOT NULL);
675
CREATE TABLE t2 (c1 SMALLINT NOT NULL);
676
CREATE TABLE t3 (c1 SMALLINT NOT NULL);
677
CREATE TABLE t4 (c1 SMALLINT NOT NULL);
678
CREATE TABLE t5 (c1 SMALLINT NOT NULL);
679
CREATE TABLE t6 (c1 SMALLINT NOT NULL);
680
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
681
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
682
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
683
INSERT INTO t4 (c1) VALUES(10);
684
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
685
SELECT t1.c1,t6.c1 FROM t1 INNER JOIN t6 USING (c1);
687
SELECT t1.c1,t6.c1 FROM t1 INNER JOIN t6 ON t1.c1 = t6.c1;
689
SELECT t1.c1,t6.c1 FROM t1 INNER JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 < 5;
691
DROP TABLE t1,t2,t3,t4,t5,t6;
692
CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
693
CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
694
CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
695
CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
696
CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
697
CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
698
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
699
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
700
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
701
INSERT INTO t4 (c1) VALUES(10);
702
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
703
SELECT t1.c1,t6.c1 FROM t1 INNER JOIN t6 USING (c1);
705
SELECT t1.c1,t6.c1 FROM t1 INNER JOIN t6 ON t1.c1 = t6.c1;
707
SELECT t1.c1,t6.c1 FROM t1 INNER JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 < 5;
709
DROP TABLE t1,t2,t3,t4,t5,t6;
710
CREATE TABLE t1 (c1 INT NOT NULL);
711
CREATE TABLE t2 (c1 INT NOT NULL);
712
CREATE TABLE t3 (c1 INT NOT NULL);
713
CREATE TABLE t4 (c1 INT NOT NULL);
714
CREATE TABLE t5 (c1 INT NOT NULL);
715
CREATE TABLE t6 (c1 INT NOT NULL);
716
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
717
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
718
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
719
INSERT INTO t4 (c1) VALUES(10);
720
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
721
SELECT t1.c1,t6.c1 FROM t1 INNER JOIN t6 USING (c1);
723
SELECT t1.c1,t6.c1 FROM t1 INNER JOIN t6 ON t1.c1 = t6.c1;
725
SELECT t1.c1,t6.c1 FROM t1 INNER JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 < 5;
727
DROP TABLE t1,t2,t3,t4,t5,t6;
728
CREATE TABLE t1 (c1 INTEGER NOT NULL);
729
CREATE TABLE t2 (c1 INTEGER NOT NULL);
730
CREATE TABLE t3 (c1 INTEGER NOT NULL);
731
CREATE TABLE t4 (c1 INTEGER NOT NULL);
732
CREATE TABLE t5 (c1 INTEGER NOT NULL);
733
CREATE TABLE t6 (c1 INTEGER NOT NULL);
734
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
735
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
736
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
737
INSERT INTO t4 (c1) VALUES(10);
738
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
739
SELECT t1.c1,t6.c1 FROM t1 INNER JOIN t6 USING (c1);
741
SELECT t1.c1,t6.c1 FROM t1 INNER JOIN t6 ON t1.c1 = t6.c1;
743
SELECT t1.c1,t6.c1 FROM t1 INNER JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 < 5;
745
DROP TABLE t1,t2,t3,t4,t5,t6;
746
CREATE TABLE t1 (c1 BIGINT NOT NULL);
747
CREATE TABLE t2 (c1 BIGINT NOT NULL);
748
CREATE TABLE t3 (c1 BIGINT NOT NULL);
749
CREATE TABLE t4 (c1 BIGINT NOT NULL);
750
CREATE TABLE t5 (c1 BIGINT NOT NULL);
751
CREATE TABLE t6 (c1 BIGINT 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 INNER JOIN t6 USING (c1);
759
SELECT t1.c1,t6.c1 FROM t1 INNER JOIN t6 ON t1.c1 = t6.c1;
761
SELECT t1.c1,t6.c1 FROM t1 INNER JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 < 5;
763
DROP TABLE t1,t2,t3,t4,t5,t6;
764
CREATE TABLE t1 (c1 TINYINT NOT NULL);
765
CREATE TABLE t2 (c1 TINYINT NOT NULL);
766
CREATE TABLE t3 (c1 TINYINT NOT NULL);
767
CREATE TABLE t4 (c1 TINYINT NOT NULL);
768
CREATE TABLE t5 (c1 TINYINT NOT NULL);
769
CREATE TABLE t6 (c1 TINYINT NOT NULL);
770
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
771
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
772
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
773
INSERT INTO t4 (c1) VALUES(10);
774
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
775
SELECT t1.c1,t2.c1 FROM t1 INNER JOIN t2 USING (c1);
787
SELECT t1.c1,t2.c1 FROM t1 INNER JOIN t2 ON t1.c1 = t2.c1;
799
SELECT t1.c1,t2.c1 FROM t1 INNER JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 <= 5;
807
DROP TABLE t1,t2,t3,t4,t5,t6;
808
CREATE TABLE t1 (c1 SMALLINT NOT NULL);
809
CREATE TABLE t2 (c1 SMALLINT NOT NULL);
810
CREATE TABLE t3 (c1 SMALLINT NOT NULL);
811
CREATE TABLE t4 (c1 SMALLINT NOT NULL);
812
CREATE TABLE t5 (c1 SMALLINT NOT NULL);
813
CREATE TABLE t6 (c1 SMALLINT 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,t2.c1 FROM t1 INNER JOIN t2 USING (c1);
831
SELECT t1.c1,t2.c1 FROM t1 INNER JOIN t2 ON t1.c1 = t2.c1;
843
SELECT t1.c1,t2.c1 FROM t1 INNER JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 <= 5;
851
DROP TABLE t1,t2,t3,t4,t5,t6;
852
CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
853
CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
854
CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
855
CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
856
CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
857
CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
858
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
859
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
860
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
861
INSERT INTO t4 (c1) VALUES(10);
862
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
863
SELECT t1.c1,t2.c1 FROM t1 INNER JOIN t2 USING (c1);
875
SELECT t1.c1,t2.c1 FROM t1 INNER JOIN t2 ON t1.c1 = t2.c1;
887
SELECT t1.c1,t2.c1 FROM t1 INNER JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 <= 5;
895
DROP TABLE t1,t2,t3,t4,t5,t6;
896
CREATE TABLE t1 (c1 INT NOT NULL);
897
CREATE TABLE t2 (c1 INT NOT NULL);
898
CREATE TABLE t3 (c1 INT NOT NULL);
899
CREATE TABLE t4 (c1 INT NOT NULL);
900
CREATE TABLE t5 (c1 INT NOT NULL);
901
CREATE TABLE t6 (c1 INT NOT NULL);
902
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
903
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
904
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
905
INSERT INTO t4 (c1) VALUES(10);
906
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
907
SELECT t1.c1,t2.c1 FROM t1 INNER JOIN t2 USING (c1);
919
SELECT t1.c1,t2.c1 FROM t1 INNER JOIN t2 ON t1.c1 = t2.c1;
931
SELECT t1.c1,t2.c1 FROM t1 INNER JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 <= 5;
939
DROP TABLE t1,t2,t3,t4,t5,t6;
940
CREATE TABLE t1 (c1 INTEGER NOT NULL);
941
CREATE TABLE t2 (c1 INTEGER NOT NULL);
942
CREATE TABLE t3 (c1 INTEGER NOT NULL);
943
CREATE TABLE t4 (c1 INTEGER NOT NULL);
944
CREATE TABLE t5 (c1 INTEGER NOT NULL);
945
CREATE TABLE t6 (c1 INTEGER NOT NULL);
946
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
947
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
948
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
949
INSERT INTO t4 (c1) VALUES(10);
950
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
951
SELECT t1.c1,t2.c1 FROM t1 INNER JOIN t2 USING (c1);
963
SELECT t1.c1,t2.c1 FROM t1 INNER JOIN t2 ON t1.c1 = t2.c1;
975
SELECT t1.c1,t2.c1 FROM t1 INNER JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 <= 5;
983
DROP TABLE t1,t2,t3,t4,t5,t6;
984
CREATE TABLE t1 (c1 BIGINT NOT NULL);
985
CREATE TABLE t2 (c1 BIGINT NOT NULL);
986
CREATE TABLE t3 (c1 BIGINT NOT NULL);
987
CREATE TABLE t4 (c1 BIGINT NOT NULL);
988
CREATE TABLE t5 (c1 BIGINT NOT NULL);
989
CREATE TABLE t6 (c1 BIGINT NOT NULL);
990
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
991
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
992
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
993
INSERT INTO t4 (c1) VALUES(10);
994
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
995
SELECT t1.c1,t2.c1 FROM t1 INNER JOIN t2 USING (c1);
1007
SELECT t1.c1,t2.c1 FROM t1 INNER JOIN t2 ON t1.c1 = t2.c1;
1019
SELECT t1.c1,t2.c1 FROM t1 INNER JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 <= 5;
1027
DROP TABLE t1,t2,t3,t4,t5,t6;
1028
CREATE TABLE t1 (c1 TINYINT NOT NULL);
1029
CREATE TABLE t2 (c1 TINYINT NOT NULL);
1030
CREATE TABLE t3 (c1 TINYINT NOT NULL);
1031
CREATE TABLE t4 (c1 TINYINT NOT NULL);
1032
CREATE TABLE t5 (c1 TINYINT NOT NULL);
1033
CREATE TABLE t6 (c1 TINYINT 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,t3.c1 FROM t1 INNER JOIN t3 USING (c1);
1046
SELECT t1.c1,t3.c1 FROM t1 INNER JOIN t3 ON t1.c1 = t3.c1;
1053
SELECT t1.c1,t3.c1 FROM t1 INNER JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 <= 5;
1058
DROP TABLE t1,t2,t3,t4,t5,t6;
1059
CREATE TABLE t1 (c1 SMALLINT NOT NULL);
1060
CREATE TABLE t2 (c1 SMALLINT NOT NULL);
1061
CREATE TABLE t3 (c1 SMALLINT NOT NULL);
1062
CREATE TABLE t4 (c1 SMALLINT NOT NULL);
1063
CREATE TABLE t5 (c1 SMALLINT NOT NULL);
1064
CREATE TABLE t6 (c1 SMALLINT NOT NULL);
1065
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1066
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1067
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1068
INSERT INTO t4 (c1) VALUES(10);
1069
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1070
SELECT t1.c1,t3.c1 FROM t1 INNER JOIN t3 USING (c1);
1077
SELECT t1.c1,t3.c1 FROM t1 INNER JOIN t3 ON t1.c1 = t3.c1;
1084
SELECT t1.c1,t3.c1 FROM t1 INNER JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 <= 5;
1089
DROP TABLE t1,t2,t3,t4,t5,t6;
1090
CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
1091
CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
1092
CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
1093
CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
1094
CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
1095
CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
1096
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1097
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1098
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1099
INSERT INTO t4 (c1) VALUES(10);
1100
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1101
SELECT t1.c1,t3.c1 FROM t1 INNER JOIN t3 USING (c1);
1108
SELECT t1.c1,t3.c1 FROM t1 INNER JOIN t3 ON t1.c1 = t3.c1;
1115
SELECT t1.c1,t3.c1 FROM t1 INNER JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 <= 5;
1120
DROP TABLE t1,t2,t3,t4,t5,t6;
1121
CREATE TABLE t1 (c1 INT NOT NULL);
1122
CREATE TABLE t2 (c1 INT NOT NULL);
1123
CREATE TABLE t3 (c1 INT NOT NULL);
1124
CREATE TABLE t4 (c1 INT NOT NULL);
1125
CREATE TABLE t5 (c1 INT NOT NULL);
1126
CREATE TABLE t6 (c1 INT NOT NULL);
1127
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1128
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1129
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1130
INSERT INTO t4 (c1) VALUES(10);
1131
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1132
SELECT t1.c1,t3.c1 FROM t1 INNER JOIN t3 USING (c1);
1139
SELECT t1.c1,t3.c1 FROM t1 INNER JOIN t3 ON t1.c1 = t3.c1;
1146
SELECT t1.c1,t3.c1 FROM t1 INNER JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 <= 5;
1151
DROP TABLE t1,t2,t3,t4,t5,t6;
1152
CREATE TABLE t1 (c1 INTEGER NOT NULL);
1153
CREATE TABLE t2 (c1 INTEGER NOT NULL);
1154
CREATE TABLE t3 (c1 INTEGER NOT NULL);
1155
CREATE TABLE t4 (c1 INTEGER NOT NULL);
1156
CREATE TABLE t5 (c1 INTEGER NOT NULL);
1157
CREATE TABLE t6 (c1 INTEGER NOT NULL);
1158
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1159
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1160
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1161
INSERT INTO t4 (c1) VALUES(10);
1162
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1163
SELECT t1.c1,t3.c1 FROM t1 INNER JOIN t3 USING (c1);
1170
SELECT t1.c1,t3.c1 FROM t1 INNER JOIN t3 ON t1.c1 = t3.c1;
1177
SELECT t1.c1,t3.c1 FROM t1 INNER JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 <= 5;
1182
DROP TABLE t1,t2,t3,t4,t5,t6;
1183
CREATE TABLE t1 (c1 BIGINT NOT NULL);
1184
CREATE TABLE t2 (c1 BIGINT NOT NULL);
1185
CREATE TABLE t3 (c1 BIGINT NOT NULL);
1186
CREATE TABLE t4 (c1 BIGINT NOT NULL);
1187
CREATE TABLE t5 (c1 BIGINT NOT NULL);
1188
CREATE TABLE t6 (c1 BIGINT NOT NULL);
1189
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1190
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1191
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1192
INSERT INTO t4 (c1) VALUES(10);
1193
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1194
SELECT t1.c1,t3.c1 FROM t1 INNER JOIN t3 USING (c1);
1201
SELECT t1.c1,t3.c1 FROM t1 INNER JOIN t3 ON t1.c1 = t3.c1;
1208
SELECT t1.c1,t3.c1 FROM t1 INNER JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 <= 5;
1213
DROP TABLE t1,t2,t3,t4,t5,t6;
1214
CREATE TABLE t1 (c1 TINYINT NOT NULL);
1215
CREATE TABLE t2 (c1 TINYINT NOT NULL);
1216
CREATE TABLE t3 (c1 TINYINT NOT NULL);
1217
CREATE TABLE t4 (c1 TINYINT NOT NULL);
1218
CREATE TABLE t5 (c1 TINYINT NOT NULL);
1219
CREATE TABLE t6 (c1 TINYINT NOT NULL);
1220
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1221
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1222
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1223
INSERT INTO t4 (c1) VALUES(10);
1224
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1225
SELECT t1.c1,t4.c1 FROM t1 INNER JOIN t4 USING (c1);
1227
SELECT t1.c1,t4.c1 FROM t1 INNER JOIN t4 ON t1.c1 = t4.c1;
1229
SELECT t1.c1,t4.c1 FROM t1 INNER JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 <= 5;
1231
DROP TABLE t1,t2,t3,t4,t5,t6;
1232
CREATE TABLE t1 (c1 SMALLINT NOT NULL);
1233
CREATE TABLE t2 (c1 SMALLINT NOT NULL);
1234
CREATE TABLE t3 (c1 SMALLINT NOT NULL);
1235
CREATE TABLE t4 (c1 SMALLINT NOT NULL);
1236
CREATE TABLE t5 (c1 SMALLINT NOT NULL);
1237
CREATE TABLE t6 (c1 SMALLINT NOT NULL);
1238
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1239
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1240
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1241
INSERT INTO t4 (c1) VALUES(10);
1242
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1243
SELECT t1.c1,t4.c1 FROM t1 INNER JOIN t4 USING (c1);
1245
SELECT t1.c1,t4.c1 FROM t1 INNER JOIN t4 ON t1.c1 = t4.c1;
1247
SELECT t1.c1,t4.c1 FROM t1 INNER JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 <= 5;
1249
DROP TABLE t1,t2,t3,t4,t5,t6;
1250
CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
1251
CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
1252
CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
1253
CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
1254
CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
1255
CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
1256
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1257
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1258
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1259
INSERT INTO t4 (c1) VALUES(10);
1260
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1261
SELECT t1.c1,t4.c1 FROM t1 INNER JOIN t4 USING (c1);
1263
SELECT t1.c1,t4.c1 FROM t1 INNER JOIN t4 ON t1.c1 = t4.c1;
1265
SELECT t1.c1,t4.c1 FROM t1 INNER JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 <= 5;
1267
DROP TABLE t1,t2,t3,t4,t5,t6;
1268
CREATE TABLE t1 (c1 INT NOT NULL);
1269
CREATE TABLE t2 (c1 INT NOT NULL);
1270
CREATE TABLE t3 (c1 INT NOT NULL);
1271
CREATE TABLE t4 (c1 INT NOT NULL);
1272
CREATE TABLE t5 (c1 INT NOT NULL);
1273
CREATE TABLE t6 (c1 INT NOT NULL);
1274
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1275
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1276
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1277
INSERT INTO t4 (c1) VALUES(10);
1278
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1279
SELECT t1.c1,t4.c1 FROM t1 INNER JOIN t4 USING (c1);
1281
SELECT t1.c1,t4.c1 FROM t1 INNER JOIN t4 ON t1.c1 = t4.c1;
1283
SELECT t1.c1,t4.c1 FROM t1 INNER JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 <= 5;
1285
DROP TABLE t1,t2,t3,t4,t5,t6;
1286
CREATE TABLE t1 (c1 INTEGER NOT NULL);
1287
CREATE TABLE t2 (c1 INTEGER NOT NULL);
1288
CREATE TABLE t3 (c1 INTEGER NOT NULL);
1289
CREATE TABLE t4 (c1 INTEGER NOT NULL);
1290
CREATE TABLE t5 (c1 INTEGER NOT NULL);
1291
CREATE TABLE t6 (c1 INTEGER NOT NULL);
1292
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1293
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1294
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1295
INSERT INTO t4 (c1) VALUES(10);
1296
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1297
SELECT t1.c1,t4.c1 FROM t1 INNER JOIN t4 USING (c1);
1299
SELECT t1.c1,t4.c1 FROM t1 INNER JOIN t4 ON t1.c1 = t4.c1;
1301
SELECT t1.c1,t4.c1 FROM t1 INNER JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 <= 5;
1303
DROP TABLE t1,t2,t3,t4,t5,t6;
1304
CREATE TABLE t1 (c1 BIGINT NOT NULL);
1305
CREATE TABLE t2 (c1 BIGINT NOT NULL);
1306
CREATE TABLE t3 (c1 BIGINT NOT NULL);
1307
CREATE TABLE t4 (c1 BIGINT NOT NULL);
1308
CREATE TABLE t5 (c1 BIGINT NOT NULL);
1309
CREATE TABLE t6 (c1 BIGINT NOT NULL);
1310
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1311
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1312
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1313
INSERT INTO t4 (c1) VALUES(10);
1314
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1315
SELECT t1.c1,t4.c1 FROM t1 INNER JOIN t4 USING (c1);
1317
SELECT t1.c1,t4.c1 FROM t1 INNER JOIN t4 ON t1.c1 = t4.c1;
1319
SELECT t1.c1,t4.c1 FROM t1 INNER JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 <= 5;
1321
DROP TABLE t1,t2,t3,t4,t5,t6;
1322
CREATE TABLE t1 (c1 TINYINT NOT NULL);
1323
CREATE TABLE t2 (c1 TINYINT NOT NULL);
1324
CREATE TABLE t3 (c1 TINYINT NOT NULL);
1325
CREATE TABLE t4 (c1 TINYINT NOT NULL);
1326
CREATE TABLE t5 (c1 TINYINT NOT NULL);
1327
CREATE TABLE t6 (c1 TINYINT NOT NULL);
1328
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1329
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1330
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1331
INSERT INTO t4 (c1) VALUES(10);
1332
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1333
SELECT t1.c1,t5.c1 FROM t1 INNER JOIN t5 USING (c1);
1335
SELECT t1.c1,t5.c1 FROM t1 INNER JOIN t5 ON t1.c1 = t5.c1;
1337
SELECT t1.c1,t5.c1 FROM t1 INNER JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 <= 5;
1339
DROP TABLE t1,t2,t3,t4,t5,t6;
1340
CREATE TABLE t1 (c1 SMALLINT NOT NULL);
1341
CREATE TABLE t2 (c1 SMALLINT NOT NULL);
1342
CREATE TABLE t3 (c1 SMALLINT NOT NULL);
1343
CREATE TABLE t4 (c1 SMALLINT NOT NULL);
1344
CREATE TABLE t5 (c1 SMALLINT NOT NULL);
1345
CREATE TABLE t6 (c1 SMALLINT NOT NULL);
1346
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1347
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1348
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1349
INSERT INTO t4 (c1) VALUES(10);
1350
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1351
SELECT t1.c1,t5.c1 FROM t1 INNER JOIN t5 USING (c1);
1353
SELECT t1.c1,t5.c1 FROM t1 INNER JOIN t5 ON t1.c1 = t5.c1;
1355
SELECT t1.c1,t5.c1 FROM t1 INNER JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 <= 5;
1357
DROP TABLE t1,t2,t3,t4,t5,t6;
1358
CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
1359
CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
1360
CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
1361
CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
1362
CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
1363
CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
1364
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1365
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1366
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1367
INSERT INTO t4 (c1) VALUES(10);
1368
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1369
SELECT t1.c1,t5.c1 FROM t1 INNER JOIN t5 USING (c1);
1371
SELECT t1.c1,t5.c1 FROM t1 INNER JOIN t5 ON t1.c1 = t5.c1;
1373
SELECT t1.c1,t5.c1 FROM t1 INNER JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 <= 5;
1375
DROP TABLE t1,t2,t3,t4,t5,t6;
1376
CREATE TABLE t1 (c1 INT NOT NULL);
1377
CREATE TABLE t2 (c1 INT NOT NULL);
1378
CREATE TABLE t3 (c1 INT NOT NULL);
1379
CREATE TABLE t4 (c1 INT NOT NULL);
1380
CREATE TABLE t5 (c1 INT NOT NULL);
1381
CREATE TABLE t6 (c1 INT NOT NULL);
1382
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1383
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1384
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1385
INSERT INTO t4 (c1) VALUES(10);
1386
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1387
SELECT t1.c1,t5.c1 FROM t1 INNER JOIN t5 USING (c1);
1389
SELECT t1.c1,t5.c1 FROM t1 INNER JOIN t5 ON t1.c1 = t5.c1;
1391
SELECT t1.c1,t5.c1 FROM t1 INNER JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 <= 5;
1393
DROP TABLE t1,t2,t3,t4,t5,t6;
1394
CREATE TABLE t1 (c1 INTEGER NOT NULL);
1395
CREATE TABLE t2 (c1 INTEGER NOT NULL);
1396
CREATE TABLE t3 (c1 INTEGER NOT NULL);
1397
CREATE TABLE t4 (c1 INTEGER NOT NULL);
1398
CREATE TABLE t5 (c1 INTEGER NOT NULL);
1399
CREATE TABLE t6 (c1 INTEGER NOT NULL);
1400
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1401
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1402
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1403
INSERT INTO t4 (c1) VALUES(10);
1404
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1405
SELECT t1.c1,t5.c1 FROM t1 INNER JOIN t5 USING (c1);
1407
SELECT t1.c1,t5.c1 FROM t1 INNER JOIN t5 ON t1.c1 = t5.c1;
1409
SELECT t1.c1,t5.c1 FROM t1 INNER JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 <= 5;
1411
DROP TABLE t1,t2,t3,t4,t5,t6;
1412
CREATE TABLE t1 (c1 BIGINT NOT NULL);
1413
CREATE TABLE t2 (c1 BIGINT NOT NULL);
1414
CREATE TABLE t3 (c1 BIGINT NOT NULL);
1415
CREATE TABLE t4 (c1 BIGINT NOT NULL);
1416
CREATE TABLE t5 (c1 BIGINT NOT NULL);
1417
CREATE TABLE t6 (c1 BIGINT 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,t5.c1 FROM t1 INNER JOIN t5 USING (c1);
1425
SELECT t1.c1,t5.c1 FROM t1 INNER JOIN t5 ON t1.c1 = t5.c1;
1427
SELECT t1.c1,t5.c1 FROM t1 INNER JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 <= 5;
1429
DROP TABLE t1,t2,t3,t4,t5,t6;
1430
CREATE TABLE t1 (c1 TINYINT NOT NULL);
1431
CREATE TABLE t2 (c1 TINYINT NOT NULL);
1432
CREATE TABLE t3 (c1 TINYINT NOT NULL);
1433
CREATE TABLE t4 (c1 TINYINT NOT NULL);
1434
CREATE TABLE t5 (c1 TINYINT NOT NULL);
1435
CREATE TABLE t6 (c1 TINYINT NOT NULL);
1436
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1437
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1438
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1439
INSERT INTO t4 (c1) VALUES(10);
1440
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1441
SELECT t1.c1,t6.c1 FROM t1 INNER JOIN t6 USING (c1);
1443
SELECT t1.c1,t6.c1 FROM t1 INNER JOIN t6 ON t1.c1 = t6.c1;
1445
SELECT t1.c1,t6.c1 FROM t1 INNER JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 <= 5;
1447
DROP TABLE t1,t2,t3,t4,t5,t6;
1448
CREATE TABLE t1 (c1 SMALLINT NOT NULL);
1449
CREATE TABLE t2 (c1 SMALLINT NOT NULL);
1450
CREATE TABLE t3 (c1 SMALLINT NOT NULL);
1451
CREATE TABLE t4 (c1 SMALLINT NOT NULL);
1452
CREATE TABLE t5 (c1 SMALLINT NOT NULL);
1453
CREATE TABLE t6 (c1 SMALLINT NOT NULL);
1454
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1455
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1456
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1457
INSERT INTO t4 (c1) VALUES(10);
1458
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1459
SELECT t1.c1,t6.c1 FROM t1 INNER JOIN t6 USING (c1);
1461
SELECT t1.c1,t6.c1 FROM t1 INNER JOIN t6 ON t1.c1 = t6.c1;
1463
SELECT t1.c1,t6.c1 FROM t1 INNER JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 <= 5;
1465
DROP TABLE t1,t2,t3,t4,t5,t6;
1466
CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
1467
CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
1468
CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
1469
CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
1470
CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
1471
CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
1472
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1473
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1474
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1475
INSERT INTO t4 (c1) VALUES(10);
1476
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1477
SELECT t1.c1,t6.c1 FROM t1 INNER JOIN t6 USING (c1);
1479
SELECT t1.c1,t6.c1 FROM t1 INNER JOIN t6 ON t1.c1 = t6.c1;
1481
SELECT t1.c1,t6.c1 FROM t1 INNER JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 <= 5;
1483
DROP TABLE t1,t2,t3,t4,t5,t6;
1484
CREATE TABLE t1 (c1 INT NOT NULL);
1485
CREATE TABLE t2 (c1 INT NOT NULL);
1486
CREATE TABLE t3 (c1 INT NOT NULL);
1487
CREATE TABLE t4 (c1 INT NOT NULL);
1488
CREATE TABLE t5 (c1 INT NOT NULL);
1489
CREATE TABLE t6 (c1 INT NOT NULL);
1490
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1491
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1492
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1493
INSERT INTO t4 (c1) VALUES(10);
1494
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1495
SELECT t1.c1,t6.c1 FROM t1 INNER JOIN t6 USING (c1);
1497
SELECT t1.c1,t6.c1 FROM t1 INNER JOIN t6 ON t1.c1 = t6.c1;
1499
SELECT t1.c1,t6.c1 FROM t1 INNER JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 <= 5;
1501
DROP TABLE t1,t2,t3,t4,t5,t6;
1502
CREATE TABLE t1 (c1 INTEGER NOT NULL);
1503
CREATE TABLE t2 (c1 INTEGER NOT NULL);
1504
CREATE TABLE t3 (c1 INTEGER NOT NULL);
1505
CREATE TABLE t4 (c1 INTEGER NOT NULL);
1506
CREATE TABLE t5 (c1 INTEGER NOT NULL);
1507
CREATE TABLE t6 (c1 INTEGER NOT NULL);
1508
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1509
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1510
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1511
INSERT INTO t4 (c1) VALUES(10);
1512
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1513
SELECT t1.c1,t6.c1 FROM t1 INNER JOIN t6 USING (c1);
1515
SELECT t1.c1,t6.c1 FROM t1 INNER JOIN t6 ON t1.c1 = t6.c1;
1517
SELECT t1.c1,t6.c1 FROM t1 INNER JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 <= 5;
1519
DROP TABLE t1,t2,t3,t4,t5,t6;
1520
CREATE TABLE t1 (c1 BIGINT NOT NULL);
1521
CREATE TABLE t2 (c1 BIGINT NOT NULL);
1522
CREATE TABLE t3 (c1 BIGINT NOT NULL);
1523
CREATE TABLE t4 (c1 BIGINT NOT NULL);
1524
CREATE TABLE t5 (c1 BIGINT NOT NULL);
1525
CREATE TABLE t6 (c1 BIGINT NOT NULL);
1526
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1527
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1528
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1529
INSERT INTO t4 (c1) VALUES(10);
1530
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1531
SELECT t1.c1,t6.c1 FROM t1 INNER JOIN t6 USING (c1);
1533
SELECT t1.c1,t6.c1 FROM t1 INNER JOIN t6 ON t1.c1 = t6.c1;
1535
SELECT t1.c1,t6.c1 FROM t1 INNER JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 <= 5;
1537
DROP TABLE t1,t2,t3,t4,t5,t6;
1538
CREATE TABLE t1 (c1 TINYINT NOT NULL);
1539
CREATE TABLE t2 (c1 TINYINT NOT NULL);
1540
CREATE TABLE t3 (c1 TINYINT NOT NULL);
1541
CREATE TABLE t4 (c1 TINYINT NOT NULL);
1542
CREATE TABLE t5 (c1 TINYINT NOT NULL);
1543
CREATE TABLE t6 (c1 TINYINT NOT NULL);
1544
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1545
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1546
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1547
INSERT INTO t4 (c1) VALUES(10);
1548
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1549
SELECT t1.c1,t2.c1 FROM t1 INNER JOIN t2 USING (c1);
1561
SELECT t1.c1,t2.c1 FROM t1 INNER JOIN t2 ON t1.c1 = t2.c1;
1573
SELECT t1.c1,t2.c1 FROM t1 INNER JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 = 5;
1576
DROP TABLE t1,t2,t3,t4,t5,t6;
1577
CREATE TABLE t1 (c1 SMALLINT NOT NULL);
1578
CREATE TABLE t2 (c1 SMALLINT NOT NULL);
1579
CREATE TABLE t3 (c1 SMALLINT NOT NULL);
1580
CREATE TABLE t4 (c1 SMALLINT NOT NULL);
1581
CREATE TABLE t5 (c1 SMALLINT NOT NULL);
1582
CREATE TABLE t6 (c1 SMALLINT NOT NULL);
1583
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1584
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1585
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1586
INSERT INTO t4 (c1) VALUES(10);
1587
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1588
SELECT t1.c1,t2.c1 FROM t1 INNER JOIN t2 USING (c1);
1600
SELECT t1.c1,t2.c1 FROM t1 INNER JOIN t2 ON t1.c1 = t2.c1;
1612
SELECT t1.c1,t2.c1 FROM t1 INNER JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 = 5;
1615
DROP TABLE t1,t2,t3,t4,t5,t6;
1616
CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
1617
CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
1618
CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
1619
CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
1620
CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
1621
CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
1622
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1623
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1624
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1625
INSERT INTO t4 (c1) VALUES(10);
1626
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1627
SELECT t1.c1,t2.c1 FROM t1 INNER JOIN t2 USING (c1);
1639
SELECT t1.c1,t2.c1 FROM t1 INNER JOIN t2 ON t1.c1 = t2.c1;
1651
SELECT t1.c1,t2.c1 FROM t1 INNER JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 = 5;
1654
DROP TABLE t1,t2,t3,t4,t5,t6;
1655
CREATE TABLE t1 (c1 INT NOT NULL);
1656
CREATE TABLE t2 (c1 INT NOT NULL);
1657
CREATE TABLE t3 (c1 INT NOT NULL);
1658
CREATE TABLE t4 (c1 INT NOT NULL);
1659
CREATE TABLE t5 (c1 INT NOT NULL);
1660
CREATE TABLE t6 (c1 INT NOT NULL);
1661
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1662
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1663
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1664
INSERT INTO t4 (c1) VALUES(10);
1665
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1666
SELECT t1.c1,t2.c1 FROM t1 INNER JOIN t2 USING (c1);
1678
SELECT t1.c1,t2.c1 FROM t1 INNER JOIN t2 ON t1.c1 = t2.c1;
1690
SELECT t1.c1,t2.c1 FROM t1 INNER JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 = 5;
1693
DROP TABLE t1,t2,t3,t4,t5,t6;
1694
CREATE TABLE t1 (c1 INTEGER NOT NULL);
1695
CREATE TABLE t2 (c1 INTEGER NOT NULL);
1696
CREATE TABLE t3 (c1 INTEGER NOT NULL);
1697
CREATE TABLE t4 (c1 INTEGER NOT NULL);
1698
CREATE TABLE t5 (c1 INTEGER NOT NULL);
1699
CREATE TABLE t6 (c1 INTEGER NOT NULL);
1700
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1701
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1702
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1703
INSERT INTO t4 (c1) VALUES(10);
1704
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1705
SELECT t1.c1,t2.c1 FROM t1 INNER JOIN t2 USING (c1);
1717
SELECT t1.c1,t2.c1 FROM t1 INNER JOIN t2 ON t1.c1 = t2.c1;
1729
SELECT t1.c1,t2.c1 FROM t1 INNER JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 = 5;
1732
DROP TABLE t1,t2,t3,t4,t5,t6;
1733
CREATE TABLE t1 (c1 BIGINT NOT NULL);
1734
CREATE TABLE t2 (c1 BIGINT NOT NULL);
1735
CREATE TABLE t3 (c1 BIGINT NOT NULL);
1736
CREATE TABLE t4 (c1 BIGINT NOT NULL);
1737
CREATE TABLE t5 (c1 BIGINT NOT NULL);
1738
CREATE TABLE t6 (c1 BIGINT NOT NULL);
1739
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1740
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1741
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1742
INSERT INTO t4 (c1) VALUES(10);
1743
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1744
SELECT t1.c1,t2.c1 FROM t1 INNER JOIN t2 USING (c1);
1756
SELECT t1.c1,t2.c1 FROM t1 INNER JOIN t2 ON t1.c1 = t2.c1;
1768
SELECT t1.c1,t2.c1 FROM t1 INNER JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 = 5;
1771
DROP TABLE t1,t2,t3,t4,t5,t6;
1772
CREATE TABLE t1 (c1 TINYINT NOT NULL);
1773
CREATE TABLE t2 (c1 TINYINT NOT NULL);
1774
CREATE TABLE t3 (c1 TINYINT NOT NULL);
1775
CREATE TABLE t4 (c1 TINYINT NOT NULL);
1776
CREATE TABLE t5 (c1 TINYINT NOT NULL);
1777
CREATE TABLE t6 (c1 TINYINT NOT NULL);
1778
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1779
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1780
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1781
INSERT INTO t4 (c1) VALUES(10);
1782
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1783
SELECT t1.c1,t3.c1 FROM t1 INNER JOIN t3 USING (c1);
1790
SELECT t1.c1,t3.c1 FROM t1 INNER JOIN t3 ON t1.c1 = t3.c1;
1797
SELECT t1.c1,t3.c1 FROM t1 INNER JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 = 5;
1800
DROP TABLE t1,t2,t3,t4,t5,t6;
1801
CREATE TABLE t1 (c1 SMALLINT NOT NULL);
1802
CREATE TABLE t2 (c1 SMALLINT NOT NULL);
1803
CREATE TABLE t3 (c1 SMALLINT NOT NULL);
1804
CREATE TABLE t4 (c1 SMALLINT NOT NULL);
1805
CREATE TABLE t5 (c1 SMALLINT NOT NULL);
1806
CREATE TABLE t6 (c1 SMALLINT NOT NULL);
1807
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1808
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1809
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1810
INSERT INTO t4 (c1) VALUES(10);
1811
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1812
SELECT t1.c1,t3.c1 FROM t1 INNER JOIN t3 USING (c1);
1819
SELECT t1.c1,t3.c1 FROM t1 INNER JOIN t3 ON t1.c1 = t3.c1;
1826
SELECT t1.c1,t3.c1 FROM t1 INNER JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 = 5;
1829
DROP TABLE t1,t2,t3,t4,t5,t6;
1830
CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
1831
CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
1832
CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
1833
CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
1834
CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
1835
CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
1836
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1837
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1838
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1839
INSERT INTO t4 (c1) VALUES(10);
1840
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1841
SELECT t1.c1,t3.c1 FROM t1 INNER JOIN t3 USING (c1);
1848
SELECT t1.c1,t3.c1 FROM t1 INNER JOIN t3 ON t1.c1 = t3.c1;
1855
SELECT t1.c1,t3.c1 FROM t1 INNER JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 = 5;
1858
DROP TABLE t1,t2,t3,t4,t5,t6;
1859
CREATE TABLE t1 (c1 INT NOT NULL);
1860
CREATE TABLE t2 (c1 INT NOT NULL);
1861
CREATE TABLE t3 (c1 INT NOT NULL);
1862
CREATE TABLE t4 (c1 INT NOT NULL);
1863
CREATE TABLE t5 (c1 INT NOT NULL);
1864
CREATE TABLE t6 (c1 INT NOT NULL);
1865
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1866
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1867
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1868
INSERT INTO t4 (c1) VALUES(10);
1869
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1870
SELECT t1.c1,t3.c1 FROM t1 INNER JOIN t3 USING (c1);
1877
SELECT t1.c1,t3.c1 FROM t1 INNER JOIN t3 ON t1.c1 = t3.c1;
1884
SELECT t1.c1,t3.c1 FROM t1 INNER JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 = 5;
1887
DROP TABLE t1,t2,t3,t4,t5,t6;
1888
CREATE TABLE t1 (c1 INTEGER NOT NULL);
1889
CREATE TABLE t2 (c1 INTEGER NOT NULL);
1890
CREATE TABLE t3 (c1 INTEGER NOT NULL);
1891
CREATE TABLE t4 (c1 INTEGER NOT NULL);
1892
CREATE TABLE t5 (c1 INTEGER NOT NULL);
1893
CREATE TABLE t6 (c1 INTEGER NOT NULL);
1894
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1895
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1896
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1897
INSERT INTO t4 (c1) VALUES(10);
1898
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1899
SELECT t1.c1,t3.c1 FROM t1 INNER JOIN t3 USING (c1);
1906
SELECT t1.c1,t3.c1 FROM t1 INNER JOIN t3 ON t1.c1 = t3.c1;
1913
SELECT t1.c1,t3.c1 FROM t1 INNER JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 = 5;
1916
DROP TABLE t1,t2,t3,t4,t5,t6;
1917
CREATE TABLE t1 (c1 BIGINT NOT NULL);
1918
CREATE TABLE t2 (c1 BIGINT NOT NULL);
1919
CREATE TABLE t3 (c1 BIGINT NOT NULL);
1920
CREATE TABLE t4 (c1 BIGINT NOT NULL);
1921
CREATE TABLE t5 (c1 BIGINT NOT NULL);
1922
CREATE TABLE t6 (c1 BIGINT NOT NULL);
1923
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1924
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1925
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1926
INSERT INTO t4 (c1) VALUES(10);
1927
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1928
SELECT t1.c1,t3.c1 FROM t1 INNER JOIN t3 USING (c1);
1935
SELECT t1.c1,t3.c1 FROM t1 INNER JOIN t3 ON t1.c1 = t3.c1;
1942
SELECT t1.c1,t3.c1 FROM t1 INNER JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 = 5;
1945
DROP TABLE t1,t2,t3,t4,t5,t6;
1946
CREATE TABLE t1 (c1 TINYINT NOT NULL);
1947
CREATE TABLE t2 (c1 TINYINT NOT NULL);
1948
CREATE TABLE t3 (c1 TINYINT NOT NULL);
1949
CREATE TABLE t4 (c1 TINYINT NOT NULL);
1950
CREATE TABLE t5 (c1 TINYINT NOT NULL);
1951
CREATE TABLE t6 (c1 TINYINT 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,t4.c1 FROM t1 INNER JOIN t4 USING (c1);
1959
SELECT t1.c1,t4.c1 FROM t1 INNER JOIN t4 ON t1.c1 = t4.c1;
1961
SELECT t1.c1,t4.c1 FROM t1 INNER JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 = 5;
1963
DROP TABLE t1,t2,t3,t4,t5,t6;
1964
CREATE TABLE t1 (c1 SMALLINT NOT NULL);
1965
CREATE TABLE t2 (c1 SMALLINT NOT NULL);
1966
CREATE TABLE t3 (c1 SMALLINT NOT NULL);
1967
CREATE TABLE t4 (c1 SMALLINT NOT NULL);
1968
CREATE TABLE t5 (c1 SMALLINT NOT NULL);
1969
CREATE TABLE t6 (c1 SMALLINT NOT NULL);
1970
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1971
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1972
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1973
INSERT INTO t4 (c1) VALUES(10);
1974
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1975
SELECT t1.c1,t4.c1 FROM t1 INNER JOIN t4 USING (c1);
1977
SELECT t1.c1,t4.c1 FROM t1 INNER JOIN t4 ON t1.c1 = t4.c1;
1979
SELECT t1.c1,t4.c1 FROM t1 INNER JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 = 5;
1981
DROP TABLE t1,t2,t3,t4,t5,t6;
1982
CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
1983
CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
1984
CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
1985
CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
1986
CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
1987
CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
1988
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1989
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1990
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1991
INSERT INTO t4 (c1) VALUES(10);
1992
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1993
SELECT t1.c1,t4.c1 FROM t1 INNER JOIN t4 USING (c1);
1995
SELECT t1.c1,t4.c1 FROM t1 INNER JOIN t4 ON t1.c1 = t4.c1;
1997
SELECT t1.c1,t4.c1 FROM t1 INNER JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 = 5;
1999
DROP TABLE t1,t2,t3,t4,t5,t6;
2000
CREATE TABLE t1 (c1 INT NOT NULL);
2001
CREATE TABLE t2 (c1 INT NOT NULL);
2002
CREATE TABLE t3 (c1 INT NOT NULL);
2003
CREATE TABLE t4 (c1 INT NOT NULL);
2004
CREATE TABLE t5 (c1 INT NOT NULL);
2005
CREATE TABLE t6 (c1 INT 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,t4.c1 FROM t1 INNER JOIN t4 USING (c1);
2013
SELECT t1.c1,t4.c1 FROM t1 INNER JOIN t4 ON t1.c1 = t4.c1;
2015
SELECT t1.c1,t4.c1 FROM t1 INNER JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 = 5;
2017
DROP TABLE t1,t2,t3,t4,t5,t6;
2018
CREATE TABLE t1 (c1 INTEGER NOT NULL);
2019
CREATE TABLE t2 (c1 INTEGER NOT NULL);
2020
CREATE TABLE t3 (c1 INTEGER NOT NULL);
2021
CREATE TABLE t4 (c1 INTEGER NOT NULL);
2022
CREATE TABLE t5 (c1 INTEGER NOT NULL);
2023
CREATE TABLE t6 (c1 INTEGER NOT NULL);
2024
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2025
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2026
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2027
INSERT INTO t4 (c1) VALUES(10);
2028
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2029
SELECT t1.c1,t4.c1 FROM t1 INNER JOIN t4 USING (c1);
2031
SELECT t1.c1,t4.c1 FROM t1 INNER JOIN t4 ON t1.c1 = t4.c1;
2033
SELECT t1.c1,t4.c1 FROM t1 INNER JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 = 5;
2035
DROP TABLE t1,t2,t3,t4,t5,t6;
2036
CREATE TABLE t1 (c1 BIGINT NOT NULL);
2037
CREATE TABLE t2 (c1 BIGINT NOT NULL);
2038
CREATE TABLE t3 (c1 BIGINT NOT NULL);
2039
CREATE TABLE t4 (c1 BIGINT NOT NULL);
2040
CREATE TABLE t5 (c1 BIGINT NOT NULL);
2041
CREATE TABLE t6 (c1 BIGINT NOT NULL);
2042
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2043
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2044
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2045
INSERT INTO t4 (c1) VALUES(10);
2046
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2047
SELECT t1.c1,t4.c1 FROM t1 INNER JOIN t4 USING (c1);
2049
SELECT t1.c1,t4.c1 FROM t1 INNER JOIN t4 ON t1.c1 = t4.c1;
2051
SELECT t1.c1,t4.c1 FROM t1 INNER JOIN t4 ON t1.c1 = t4.c1 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,t5.c1 FROM t1 INNER JOIN t5 USING (c1);
2067
SELECT t1.c1,t5.c1 FROM t1 INNER JOIN t5 ON t1.c1 = t5.c1;
2069
SELECT t1.c1,t5.c1 FROM t1 INNER JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 = 5;
2071
DROP TABLE t1,t2,t3,t4,t5,t6;
2072
CREATE TABLE t1 (c1 SMALLINT NOT NULL);
2073
CREATE TABLE t2 (c1 SMALLINT NOT NULL);
2074
CREATE TABLE t3 (c1 SMALLINT NOT NULL);
2075
CREATE TABLE t4 (c1 SMALLINT NOT NULL);
2076
CREATE TABLE t5 (c1 SMALLINT NOT NULL);
2077
CREATE TABLE t6 (c1 SMALLINT NOT NULL);
2078
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2079
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2080
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2081
INSERT INTO t4 (c1) VALUES(10);
2082
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2083
SELECT t1.c1,t5.c1 FROM t1 INNER JOIN t5 USING (c1);
2085
SELECT t1.c1,t5.c1 FROM t1 INNER JOIN t5 ON t1.c1 = t5.c1;
2087
SELECT t1.c1,t5.c1 FROM t1 INNER JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 = 5;
2089
DROP TABLE t1,t2,t3,t4,t5,t6;
2090
CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
2091
CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
2092
CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
2093
CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
2094
CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
2095
CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
2096
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2097
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2098
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2099
INSERT INTO t4 (c1) VALUES(10);
2100
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2101
SELECT t1.c1,t5.c1 FROM t1 INNER JOIN t5 USING (c1);
2103
SELECT t1.c1,t5.c1 FROM t1 INNER JOIN t5 ON t1.c1 = t5.c1;
2105
SELECT t1.c1,t5.c1 FROM t1 INNER JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 = 5;
2107
DROP TABLE t1,t2,t3,t4,t5,t6;
2108
CREATE TABLE t1 (c1 INT NOT NULL);
2109
CREATE TABLE t2 (c1 INT NOT NULL);
2110
CREATE TABLE t3 (c1 INT NOT NULL);
2111
CREATE TABLE t4 (c1 INT NOT NULL);
2112
CREATE TABLE t5 (c1 INT NOT NULL);
2113
CREATE TABLE t6 (c1 INT 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,t5.c1 FROM t1 INNER JOIN t5 USING (c1);
2121
SELECT t1.c1,t5.c1 FROM t1 INNER JOIN t5 ON t1.c1 = t5.c1;
2123
SELECT t1.c1,t5.c1 FROM t1 INNER JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 = 5;
2125
DROP TABLE t1,t2,t3,t4,t5,t6;
2126
CREATE TABLE t1 (c1 INTEGER NOT NULL);
2127
CREATE TABLE t2 (c1 INTEGER NOT NULL);
2128
CREATE TABLE t3 (c1 INTEGER NOT NULL);
2129
CREATE TABLE t4 (c1 INTEGER NOT NULL);
2130
CREATE TABLE t5 (c1 INTEGER NOT NULL);
2131
CREATE TABLE t6 (c1 INTEGER NOT NULL);
2132
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2133
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2134
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2135
INSERT INTO t4 (c1) VALUES(10);
2136
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2137
SELECT t1.c1,t5.c1 FROM t1 INNER JOIN t5 USING (c1);
2139
SELECT t1.c1,t5.c1 FROM t1 INNER JOIN t5 ON t1.c1 = t5.c1;
2141
SELECT t1.c1,t5.c1 FROM t1 INNER JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 = 5;
2143
DROP TABLE t1,t2,t3,t4,t5,t6;
2144
CREATE TABLE t1 (c1 BIGINT NOT NULL);
2145
CREATE TABLE t2 (c1 BIGINT NOT NULL);
2146
CREATE TABLE t3 (c1 BIGINT NOT NULL);
2147
CREATE TABLE t4 (c1 BIGINT NOT NULL);
2148
CREATE TABLE t5 (c1 BIGINT NOT NULL);
2149
CREATE TABLE t6 (c1 BIGINT NOT NULL);
2150
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2151
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2152
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2153
INSERT INTO t4 (c1) VALUES(10);
2154
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2155
SELECT t1.c1,t5.c1 FROM t1 INNER JOIN t5 USING (c1);
2157
SELECT t1.c1,t5.c1 FROM t1 INNER JOIN t5 ON t1.c1 = t5.c1;
2159
SELECT t1.c1,t5.c1 FROM t1 INNER JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 = 5;
2161
DROP TABLE t1,t2,t3,t4,t5,t6;
2162
CREATE TABLE t1 (c1 TINYINT NOT NULL);
2163
CREATE TABLE t2 (c1 TINYINT NOT NULL);
2164
CREATE TABLE t3 (c1 TINYINT NOT NULL);
2165
CREATE TABLE t4 (c1 TINYINT NOT NULL);
2166
CREATE TABLE t5 (c1 TINYINT NOT NULL);
2167
CREATE TABLE t6 (c1 TINYINT 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,t6.c1 FROM t1 INNER JOIN t6 USING (c1);
2175
SELECT t1.c1,t6.c1 FROM t1 INNER JOIN t6 ON t1.c1 = t6.c1;
2177
SELECT t1.c1,t6.c1 FROM t1 INNER JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 = 5;
2179
DROP TABLE t1,t2,t3,t4,t5,t6;
2180
CREATE TABLE t1 (c1 SMALLINT NOT NULL);
2181
CREATE TABLE t2 (c1 SMALLINT NOT NULL);
2182
CREATE TABLE t3 (c1 SMALLINT NOT NULL);
2183
CREATE TABLE t4 (c1 SMALLINT NOT NULL);
2184
CREATE TABLE t5 (c1 SMALLINT NOT NULL);
2185
CREATE TABLE t6 (c1 SMALLINT NOT NULL);
2186
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2187
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2188
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2189
INSERT INTO t4 (c1) VALUES(10);
2190
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2191
SELECT t1.c1,t6.c1 FROM t1 INNER JOIN t6 USING (c1);
2193
SELECT t1.c1,t6.c1 FROM t1 INNER JOIN t6 ON t1.c1 = t6.c1;
2195
SELECT t1.c1,t6.c1 FROM t1 INNER JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 = 5;
2197
DROP TABLE t1,t2,t3,t4,t5,t6;
2198
CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
2199
CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
2200
CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
2201
CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
2202
CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
2203
CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
2204
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2205
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2206
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2207
INSERT INTO t4 (c1) VALUES(10);
2208
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2209
SELECT t1.c1,t6.c1 FROM t1 INNER JOIN t6 USING (c1);
2211
SELECT t1.c1,t6.c1 FROM t1 INNER JOIN t6 ON t1.c1 = t6.c1;
2213
SELECT t1.c1,t6.c1 FROM t1 INNER JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 = 5;
2215
DROP TABLE t1,t2,t3,t4,t5,t6;
2216
CREATE TABLE t1 (c1 INT NOT NULL);
2217
CREATE TABLE t2 (c1 INT NOT NULL);
2218
CREATE TABLE t3 (c1 INT NOT NULL);
2219
CREATE TABLE t4 (c1 INT NOT NULL);
2220
CREATE TABLE t5 (c1 INT NOT NULL);
2221
CREATE TABLE t6 (c1 INT NOT NULL);
2222
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2223
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2224
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2225
INSERT INTO t4 (c1) VALUES(10);
2226
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2227
SELECT t1.c1,t6.c1 FROM t1 INNER JOIN t6 USING (c1);
2229
SELECT t1.c1,t6.c1 FROM t1 INNER JOIN t6 ON t1.c1 = t6.c1;
2231
SELECT t1.c1,t6.c1 FROM t1 INNER JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 = 5;
2233
DROP TABLE t1,t2,t3,t4,t5,t6;
2234
CREATE TABLE t1 (c1 INTEGER NOT NULL);
2235
CREATE TABLE t2 (c1 INTEGER NOT NULL);
2236
CREATE TABLE t3 (c1 INTEGER NOT NULL);
2237
CREATE TABLE t4 (c1 INTEGER NOT NULL);
2238
CREATE TABLE t5 (c1 INTEGER NOT NULL);
2239
CREATE TABLE t6 (c1 INTEGER NOT NULL);
2240
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2241
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2242
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2243
INSERT INTO t4 (c1) VALUES(10);
2244
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2245
SELECT t1.c1,t6.c1 FROM t1 INNER JOIN t6 USING (c1);
2247
SELECT t1.c1,t6.c1 FROM t1 INNER JOIN t6 ON t1.c1 = t6.c1;
2249
SELECT t1.c1,t6.c1 FROM t1 INNER JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 = 5;
2251
DROP TABLE t1,t2,t3,t4,t5,t6;
2252
CREATE TABLE t1 (c1 BIGINT NOT NULL);
2253
CREATE TABLE t2 (c1 BIGINT NOT NULL);
2254
CREATE TABLE t3 (c1 BIGINT NOT NULL);
2255
CREATE TABLE t4 (c1 BIGINT NOT NULL);
2256
CREATE TABLE t5 (c1 BIGINT NOT NULL);
2257
CREATE TABLE t6 (c1 BIGINT NOT NULL);
2258
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2259
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2260
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2261
INSERT INTO t4 (c1) VALUES(10);
2262
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2263
SELECT t1.c1,t6.c1 FROM t1 INNER JOIN t6 USING (c1);
2265
SELECT t1.c1,t6.c1 FROM t1 INNER JOIN t6 ON t1.c1 = t6.c1;
2267
SELECT t1.c1,t6.c1 FROM t1 INNER JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 = 5;
2269
DROP TABLE t1,t2,t3,t4,t5,t6;
2270
CREATE TABLE t1 (c1 TINYINT NOT NULL);
2271
CREATE TABLE t2 (c1 TINYINT NOT NULL);
2272
CREATE TABLE t3 (c1 TINYINT NOT NULL);
2273
CREATE TABLE t4 (c1 TINYINT NOT NULL);
2274
CREATE TABLE t5 (c1 TINYINT NOT NULL);
2275
CREATE TABLE t6 (c1 TINYINT 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,t2.c1 FROM t1 INNER JOIN t2 USING (c1);
2293
SELECT t1.c1,t2.c1 FROM t1 INNER JOIN t2 ON t1.c1 = t2.c1;
2305
SELECT t1.c1,t2.c1 FROM t1 INNER JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 >= 5;
2312
DROP TABLE t1,t2,t3,t4,t5,t6;
2313
CREATE TABLE t1 (c1 SMALLINT NOT NULL);
2314
CREATE TABLE t2 (c1 SMALLINT NOT NULL);
2315
CREATE TABLE t3 (c1 SMALLINT NOT NULL);
2316
CREATE TABLE t4 (c1 SMALLINT NOT NULL);
2317
CREATE TABLE t5 (c1 SMALLINT NOT NULL);
2318
CREATE TABLE t6 (c1 SMALLINT NOT NULL);
2319
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2320
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2321
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2322
INSERT INTO t4 (c1) VALUES(10);
2323
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2324
SELECT t1.c1,t2.c1 FROM t1 INNER JOIN t2 USING (c1);
2336
SELECT t1.c1,t2.c1 FROM t1 INNER JOIN t2 ON t1.c1 = t2.c1;
2348
SELECT t1.c1,t2.c1 FROM t1 INNER JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 >= 5;
2355
DROP TABLE t1,t2,t3,t4,t5,t6;
2356
CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
2357
CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
2358
CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
2359
CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
2360
CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
2361
CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
2362
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2363
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2364
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2365
INSERT INTO t4 (c1) VALUES(10);
2366
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2367
SELECT t1.c1,t2.c1 FROM t1 INNER JOIN t2 USING (c1);
2379
SELECT t1.c1,t2.c1 FROM t1 INNER JOIN t2 ON t1.c1 = t2.c1;
2391
SELECT t1.c1,t2.c1 FROM t1 INNER JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 >= 5;
2398
DROP TABLE t1,t2,t3,t4,t5,t6;
2399
CREATE TABLE t1 (c1 INT NOT NULL);
2400
CREATE TABLE t2 (c1 INT NOT NULL);
2401
CREATE TABLE t3 (c1 INT NOT NULL);
2402
CREATE TABLE t4 (c1 INT NOT NULL);
2403
CREATE TABLE t5 (c1 INT NOT NULL);
2404
CREATE TABLE t6 (c1 INT NOT NULL);
2405
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2406
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2407
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2408
INSERT INTO t4 (c1) VALUES(10);
2409
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2410
SELECT t1.c1,t2.c1 FROM t1 INNER JOIN t2 USING (c1);
2422
SELECT t1.c1,t2.c1 FROM t1 INNER JOIN t2 ON t1.c1 = t2.c1;
2434
SELECT t1.c1,t2.c1 FROM t1 INNER JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 >= 5;
2441
DROP TABLE t1,t2,t3,t4,t5,t6;
2442
CREATE TABLE t1 (c1 INTEGER NOT NULL);
2443
CREATE TABLE t2 (c1 INTEGER NOT NULL);
2444
CREATE TABLE t3 (c1 INTEGER NOT NULL);
2445
CREATE TABLE t4 (c1 INTEGER NOT NULL);
2446
CREATE TABLE t5 (c1 INTEGER NOT NULL);
2447
CREATE TABLE t6 (c1 INTEGER NOT NULL);
2448
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2449
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2450
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2451
INSERT INTO t4 (c1) VALUES(10);
2452
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2453
SELECT t1.c1,t2.c1 FROM t1 INNER JOIN t2 USING (c1);
2465
SELECT t1.c1,t2.c1 FROM t1 INNER JOIN t2 ON t1.c1 = t2.c1;
2477
SELECT t1.c1,t2.c1 FROM t1 INNER JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 >= 5;
2484
DROP TABLE t1,t2,t3,t4,t5,t6;
2485
CREATE TABLE t1 (c1 BIGINT NOT NULL);
2486
CREATE TABLE t2 (c1 BIGINT NOT NULL);
2487
CREATE TABLE t3 (c1 BIGINT NOT NULL);
2488
CREATE TABLE t4 (c1 BIGINT NOT NULL);
2489
CREATE TABLE t5 (c1 BIGINT NOT NULL);
2490
CREATE TABLE t6 (c1 BIGINT NOT NULL);
2491
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2492
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2493
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2494
INSERT INTO t4 (c1) VALUES(10);
2495
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2496
SELECT t1.c1,t2.c1 FROM t1 INNER JOIN t2 USING (c1);
2508
SELECT t1.c1,t2.c1 FROM t1 INNER JOIN t2 ON t1.c1 = t2.c1;
2520
SELECT t1.c1,t2.c1 FROM t1 INNER JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 >= 5;
2527
DROP TABLE t1,t2,t3,t4,t5,t6;
2528
CREATE TABLE t1 (c1 TINYINT NOT NULL);
2529
CREATE TABLE t2 (c1 TINYINT NOT NULL);
2530
CREATE TABLE t3 (c1 TINYINT NOT NULL);
2531
CREATE TABLE t4 (c1 TINYINT NOT NULL);
2532
CREATE TABLE t5 (c1 TINYINT NOT NULL);
2533
CREATE TABLE t6 (c1 TINYINT NOT NULL);
2534
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2535
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2536
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2537
INSERT INTO t4 (c1) VALUES(10);
2538
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2539
SELECT t1.c1,t3.c1 FROM t1 INNER JOIN t3 USING (c1);
2546
SELECT t1.c1,t3.c1 FROM t1 INNER JOIN t3 ON t1.c1 = t3.c1;
2553
SELECT t1.c1,t3.c1 FROM t1 INNER JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 >= 5;
2558
DROP TABLE t1,t2,t3,t4,t5,t6;
2559
CREATE TABLE t1 (c1 SMALLINT NOT NULL);
2560
CREATE TABLE t2 (c1 SMALLINT NOT NULL);
2561
CREATE TABLE t3 (c1 SMALLINT NOT NULL);
2562
CREATE TABLE t4 (c1 SMALLINT NOT NULL);
2563
CREATE TABLE t5 (c1 SMALLINT NOT NULL);
2564
CREATE TABLE t6 (c1 SMALLINT NOT NULL);
2565
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2566
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2567
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2568
INSERT INTO t4 (c1) VALUES(10);
2569
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2570
SELECT t1.c1,t3.c1 FROM t1 INNER JOIN t3 USING (c1);
2577
SELECT t1.c1,t3.c1 FROM t1 INNER JOIN t3 ON t1.c1 = t3.c1;
2584
SELECT t1.c1,t3.c1 FROM t1 INNER JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 >= 5;
2589
DROP TABLE t1,t2,t3,t4,t5,t6;
2590
CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
2591
CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
2592
CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
2593
CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
2594
CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
2595
CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
2596
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2597
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2598
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2599
INSERT INTO t4 (c1) VALUES(10);
2600
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2601
SELECT t1.c1,t3.c1 FROM t1 INNER JOIN t3 USING (c1);
2608
SELECT t1.c1,t3.c1 FROM t1 INNER JOIN t3 ON t1.c1 = t3.c1;
2615
SELECT t1.c1,t3.c1 FROM t1 INNER JOIN t3 ON t1.c1 = t3.c1 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,t3.c1 FROM t1 INNER JOIN t3 USING (c1);
2639
SELECT t1.c1,t3.c1 FROM t1 INNER JOIN t3 ON t1.c1 = t3.c1;
2646
SELECT t1.c1,t3.c1 FROM t1 INNER JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 >= 5;
2651
DROP TABLE t1,t2,t3,t4,t5,t6;
2652
CREATE TABLE t1 (c1 INTEGER NOT NULL);
2653
CREATE TABLE t2 (c1 INTEGER NOT NULL);
2654
CREATE TABLE t3 (c1 INTEGER NOT NULL);
2655
CREATE TABLE t4 (c1 INTEGER NOT NULL);
2656
CREATE TABLE t5 (c1 INTEGER NOT NULL);
2657
CREATE TABLE t6 (c1 INTEGER NOT NULL);
2658
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2659
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2660
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2661
INSERT INTO t4 (c1) VALUES(10);
2662
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2663
SELECT t1.c1,t3.c1 FROM t1 INNER JOIN t3 USING (c1);
2670
SELECT t1.c1,t3.c1 FROM t1 INNER JOIN t3 ON t1.c1 = t3.c1;
2677
SELECT t1.c1,t3.c1 FROM t1 INNER JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 >= 5;
2682
DROP TABLE t1,t2,t3,t4,t5,t6;
2683
CREATE TABLE t1 (c1 BIGINT NOT NULL);
2684
CREATE TABLE t2 (c1 BIGINT NOT NULL);
2685
CREATE TABLE t3 (c1 BIGINT NOT NULL);
2686
CREATE TABLE t4 (c1 BIGINT NOT NULL);
2687
CREATE TABLE t5 (c1 BIGINT NOT NULL);
2688
CREATE TABLE t6 (c1 BIGINT NOT NULL);
2689
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2690
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2691
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2692
INSERT INTO t4 (c1) VALUES(10);
2693
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2694
SELECT t1.c1,t3.c1 FROM t1 INNER JOIN t3 USING (c1);
2701
SELECT t1.c1,t3.c1 FROM t1 INNER JOIN t3 ON t1.c1 = t3.c1;
2708
SELECT t1.c1,t3.c1 FROM t1 INNER JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 >= 5;
2713
DROP TABLE t1,t2,t3,t4,t5,t6;
2714
CREATE TABLE t1 (c1 TINYINT NOT NULL);
2715
CREATE TABLE t2 (c1 TINYINT NOT NULL);
2716
CREATE TABLE t3 (c1 TINYINT NOT NULL);
2717
CREATE TABLE t4 (c1 TINYINT NOT NULL);
2718
CREATE TABLE t5 (c1 TINYINT NOT NULL);
2719
CREATE TABLE t6 (c1 TINYINT NOT NULL);
2720
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2721
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2722
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2723
INSERT INTO t4 (c1) VALUES(10);
2724
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2725
SELECT t1.c1,t4.c1 FROM t1 INNER JOIN t4 USING (c1);
2727
SELECT t1.c1,t4.c1 FROM t1 INNER JOIN t4 ON t1.c1 = t4.c1;
2729
SELECT t1.c1,t4.c1 FROM t1 INNER JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 >= 5;
2731
DROP TABLE t1,t2,t3,t4,t5,t6;
2732
CREATE TABLE t1 (c1 SMALLINT NOT NULL);
2733
CREATE TABLE t2 (c1 SMALLINT NOT NULL);
2734
CREATE TABLE t3 (c1 SMALLINT NOT NULL);
2735
CREATE TABLE t4 (c1 SMALLINT NOT NULL);
2736
CREATE TABLE t5 (c1 SMALLINT NOT NULL);
2737
CREATE TABLE t6 (c1 SMALLINT NOT NULL);
2738
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2739
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2740
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2741
INSERT INTO t4 (c1) VALUES(10);
2742
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2743
SELECT t1.c1,t4.c1 FROM t1 INNER JOIN t4 USING (c1);
2745
SELECT t1.c1,t4.c1 FROM t1 INNER JOIN t4 ON t1.c1 = t4.c1;
2747
SELECT t1.c1,t4.c1 FROM t1 INNER JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 >= 5;
2749
DROP TABLE t1,t2,t3,t4,t5,t6;
2750
CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
2751
CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
2752
CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
2753
CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
2754
CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
2755
CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
2756
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2757
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2758
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2759
INSERT INTO t4 (c1) VALUES(10);
2760
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2761
SELECT t1.c1,t4.c1 FROM t1 INNER JOIN t4 USING (c1);
2763
SELECT t1.c1,t4.c1 FROM t1 INNER JOIN t4 ON t1.c1 = t4.c1;
2765
SELECT t1.c1,t4.c1 FROM t1 INNER JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 >= 5;
2767
DROP TABLE t1,t2,t3,t4,t5,t6;
2768
CREATE TABLE t1 (c1 INT NOT NULL);
2769
CREATE TABLE t2 (c1 INT NOT NULL);
2770
CREATE TABLE t3 (c1 INT NOT NULL);
2771
CREATE TABLE t4 (c1 INT NOT NULL);
2772
CREATE TABLE t5 (c1 INT NOT NULL);
2773
CREATE TABLE t6 (c1 INT NOT NULL);
2774
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2775
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2776
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2777
INSERT INTO t4 (c1) VALUES(10);
2778
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2779
SELECT t1.c1,t4.c1 FROM t1 INNER JOIN t4 USING (c1);
2781
SELECT t1.c1,t4.c1 FROM t1 INNER JOIN t4 ON t1.c1 = t4.c1;
2783
SELECT t1.c1,t4.c1 FROM t1 INNER JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 >= 5;
2785
DROP TABLE t1,t2,t3,t4,t5,t6;
2786
CREATE TABLE t1 (c1 INTEGER NOT NULL);
2787
CREATE TABLE t2 (c1 INTEGER NOT NULL);
2788
CREATE TABLE t3 (c1 INTEGER NOT NULL);
2789
CREATE TABLE t4 (c1 INTEGER NOT NULL);
2790
CREATE TABLE t5 (c1 INTEGER NOT NULL);
2791
CREATE TABLE t6 (c1 INTEGER NOT NULL);
2792
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2793
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2794
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2795
INSERT INTO t4 (c1) VALUES(10);
2796
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2797
SELECT t1.c1,t4.c1 FROM t1 INNER JOIN t4 USING (c1);
2799
SELECT t1.c1,t4.c1 FROM t1 INNER JOIN t4 ON t1.c1 = t4.c1;
2801
SELECT t1.c1,t4.c1 FROM t1 INNER JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 >= 5;
2803
DROP TABLE t1,t2,t3,t4,t5,t6;
2804
CREATE TABLE t1 (c1 BIGINT NOT NULL);
2805
CREATE TABLE t2 (c1 BIGINT NOT NULL);
2806
CREATE TABLE t3 (c1 BIGINT NOT NULL);
2807
CREATE TABLE t4 (c1 BIGINT NOT NULL);
2808
CREATE TABLE t5 (c1 BIGINT NOT NULL);
2809
CREATE TABLE t6 (c1 BIGINT NOT NULL);
2810
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2811
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2812
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2813
INSERT INTO t4 (c1) VALUES(10);
2814
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2815
SELECT t1.c1,t4.c1 FROM t1 INNER JOIN t4 USING (c1);
2817
SELECT t1.c1,t4.c1 FROM t1 INNER JOIN t4 ON t1.c1 = t4.c1;
2819
SELECT t1.c1,t4.c1 FROM t1 INNER JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 >= 5;
2821
DROP TABLE t1,t2,t3,t4,t5,t6;
2822
CREATE TABLE t1 (c1 TINYINT NOT NULL);
2823
CREATE TABLE t2 (c1 TINYINT NOT NULL);
2824
CREATE TABLE t3 (c1 TINYINT NOT NULL);
2825
CREATE TABLE t4 (c1 TINYINT NOT NULL);
2826
CREATE TABLE t5 (c1 TINYINT NOT NULL);
2827
CREATE TABLE t6 (c1 TINYINT NOT NULL);
2828
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2829
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2830
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2831
INSERT INTO t4 (c1) VALUES(10);
2832
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2833
SELECT t1.c1,t5.c1 FROM t1 INNER JOIN t5 USING (c1);
2835
SELECT t1.c1,t5.c1 FROM t1 INNER JOIN t5 ON t1.c1 = t5.c1;
2837
SELECT t1.c1,t5.c1 FROM t1 INNER JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 >= 5;
2839
DROP TABLE t1,t2,t3,t4,t5,t6;
2840
CREATE TABLE t1 (c1 SMALLINT NOT NULL);
2841
CREATE TABLE t2 (c1 SMALLINT NOT NULL);
2842
CREATE TABLE t3 (c1 SMALLINT NOT NULL);
2843
CREATE TABLE t4 (c1 SMALLINT NOT NULL);
2844
CREATE TABLE t5 (c1 SMALLINT NOT NULL);
2845
CREATE TABLE t6 (c1 SMALLINT NOT NULL);
2846
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2847
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2848
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2849
INSERT INTO t4 (c1) VALUES(10);
2850
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2851
SELECT t1.c1,t5.c1 FROM t1 INNER JOIN t5 USING (c1);
2853
SELECT t1.c1,t5.c1 FROM t1 INNER JOIN t5 ON t1.c1 = t5.c1;
2855
SELECT t1.c1,t5.c1 FROM t1 INNER JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 >= 5;
2857
DROP TABLE t1,t2,t3,t4,t5,t6;
2858
CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
2859
CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
2860
CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
2861
CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
2862
CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
2863
CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
2864
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2865
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2866
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2867
INSERT INTO t4 (c1) VALUES(10);
2868
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2869
SELECT t1.c1,t5.c1 FROM t1 INNER JOIN t5 USING (c1);
2871
SELECT t1.c1,t5.c1 FROM t1 INNER JOIN t5 ON t1.c1 = t5.c1;
2873
SELECT t1.c1,t5.c1 FROM t1 INNER JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 >= 5;
2875
DROP TABLE t1,t2,t3,t4,t5,t6;
2876
CREATE TABLE t1 (c1 INT NOT NULL);
2877
CREATE TABLE t2 (c1 INT NOT NULL);
2878
CREATE TABLE t3 (c1 INT NOT NULL);
2879
CREATE TABLE t4 (c1 INT NOT NULL);
2880
CREATE TABLE t5 (c1 INT NOT NULL);
2881
CREATE TABLE t6 (c1 INT NOT NULL);
2882
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2883
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2884
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2885
INSERT INTO t4 (c1) VALUES(10);
2886
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2887
SELECT t1.c1,t5.c1 FROM t1 INNER JOIN t5 USING (c1);
2889
SELECT t1.c1,t5.c1 FROM t1 INNER JOIN t5 ON t1.c1 = t5.c1;
2891
SELECT t1.c1,t5.c1 FROM t1 INNER JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 >= 5;
2893
DROP TABLE t1,t2,t3,t4,t5,t6;
2894
CREATE TABLE t1 (c1 INTEGER NOT NULL);
2895
CREATE TABLE t2 (c1 INTEGER NOT NULL);
2896
CREATE TABLE t3 (c1 INTEGER NOT NULL);
2897
CREATE TABLE t4 (c1 INTEGER NOT NULL);
2898
CREATE TABLE t5 (c1 INTEGER NOT NULL);
2899
CREATE TABLE t6 (c1 INTEGER NOT NULL);
2900
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2901
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2902
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2903
INSERT INTO t4 (c1) VALUES(10);
2904
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2905
SELECT t1.c1,t5.c1 FROM t1 INNER JOIN t5 USING (c1);
2907
SELECT t1.c1,t5.c1 FROM t1 INNER JOIN t5 ON t1.c1 = t5.c1;
2909
SELECT t1.c1,t5.c1 FROM t1 INNER JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 >= 5;
2911
DROP TABLE t1,t2,t3,t4,t5,t6;
2912
CREATE TABLE t1 (c1 BIGINT NOT NULL);
2913
CREATE TABLE t2 (c1 BIGINT NOT NULL);
2914
CREATE TABLE t3 (c1 BIGINT NOT NULL);
2915
CREATE TABLE t4 (c1 BIGINT NOT NULL);
2916
CREATE TABLE t5 (c1 BIGINT NOT NULL);
2917
CREATE TABLE t6 (c1 BIGINT NOT NULL);
2918
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2919
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2920
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2921
INSERT INTO t4 (c1) VALUES(10);
2922
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2923
SELECT t1.c1,t5.c1 FROM t1 INNER JOIN t5 USING (c1);
2925
SELECT t1.c1,t5.c1 FROM t1 INNER JOIN t5 ON t1.c1 = t5.c1;
2927
SELECT t1.c1,t5.c1 FROM t1 INNER JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 >= 5;
2929
DROP TABLE t1,t2,t3,t4,t5,t6;
2930
CREATE TABLE t1 (c1 TINYINT NOT NULL);
2931
CREATE TABLE t2 (c1 TINYINT NOT NULL);
2932
CREATE TABLE t3 (c1 TINYINT NOT NULL);
2933
CREATE TABLE t4 (c1 TINYINT NOT NULL);
2934
CREATE TABLE t5 (c1 TINYINT NOT NULL);
2935
CREATE TABLE t6 (c1 TINYINT NOT NULL);
2936
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2937
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2938
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2939
INSERT INTO t4 (c1) VALUES(10);
2940
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2941
SELECT t1.c1,t6.c1 FROM t1 INNER JOIN t6 USING (c1);
2943
SELECT t1.c1,t6.c1 FROM t1 INNER JOIN t6 ON t1.c1 = t6.c1;
2945
SELECT t1.c1,t6.c1 FROM t1 INNER JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 >= 5;
2947
DROP TABLE t1,t2,t3,t4,t5,t6;
2948
CREATE TABLE t1 (c1 SMALLINT NOT NULL);
2949
CREATE TABLE t2 (c1 SMALLINT NOT NULL);
2950
CREATE TABLE t3 (c1 SMALLINT NOT NULL);
2951
CREATE TABLE t4 (c1 SMALLINT NOT NULL);
2952
CREATE TABLE t5 (c1 SMALLINT NOT NULL);
2953
CREATE TABLE t6 (c1 SMALLINT NOT NULL);
2954
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2955
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2956
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2957
INSERT INTO t4 (c1) VALUES(10);
2958
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2959
SELECT t1.c1,t6.c1 FROM t1 INNER JOIN t6 USING (c1);
2961
SELECT t1.c1,t6.c1 FROM t1 INNER JOIN t6 ON t1.c1 = t6.c1;
2963
SELECT t1.c1,t6.c1 FROM t1 INNER JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 >= 5;
2965
DROP TABLE t1,t2,t3,t4,t5,t6;
2966
CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
2967
CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
2968
CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
2969
CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
2970
CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
2971
CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
2972
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2973
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2974
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2975
INSERT INTO t4 (c1) VALUES(10);
2976
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2977
SELECT t1.c1,t6.c1 FROM t1 INNER JOIN t6 USING (c1);
2979
SELECT t1.c1,t6.c1 FROM t1 INNER JOIN t6 ON t1.c1 = t6.c1;
2981
SELECT t1.c1,t6.c1 FROM t1 INNER JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 >= 5;
2983
DROP TABLE t1,t2,t3,t4,t5,t6;
2984
CREATE TABLE t1 (c1 INT NOT NULL);
2985
CREATE TABLE t2 (c1 INT NOT NULL);
2986
CREATE TABLE t3 (c1 INT NOT NULL);
2987
CREATE TABLE t4 (c1 INT NOT NULL);
2988
CREATE TABLE t5 (c1 INT NOT NULL);
2989
CREATE TABLE t6 (c1 INT NOT NULL);
2990
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2991
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2992
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2993
INSERT INTO t4 (c1) VALUES(10);
2994
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2995
SELECT t1.c1,t6.c1 FROM t1 INNER JOIN t6 USING (c1);
2997
SELECT t1.c1,t6.c1 FROM t1 INNER JOIN t6 ON t1.c1 = t6.c1;
2999
SELECT t1.c1,t6.c1 FROM t1 INNER JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 >= 5;
3001
DROP TABLE t1,t2,t3,t4,t5,t6;
3002
CREATE TABLE t1 (c1 INTEGER NOT NULL);
3003
CREATE TABLE t2 (c1 INTEGER NOT NULL);
3004
CREATE TABLE t3 (c1 INTEGER NOT NULL);
3005
CREATE TABLE t4 (c1 INTEGER NOT NULL);
3006
CREATE TABLE t5 (c1 INTEGER NOT NULL);
3007
CREATE TABLE t6 (c1 INTEGER NOT NULL);
3008
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3009
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3010
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3011
INSERT INTO t4 (c1) VALUES(10);
3012
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3013
SELECT t1.c1,t6.c1 FROM t1 INNER JOIN t6 USING (c1);
3015
SELECT t1.c1,t6.c1 FROM t1 INNER JOIN t6 ON t1.c1 = t6.c1;
3017
SELECT t1.c1,t6.c1 FROM t1 INNER JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 >= 5;
3019
DROP TABLE t1,t2,t3,t4,t5,t6;
3020
CREATE TABLE t1 (c1 BIGINT NOT NULL);
3021
CREATE TABLE t2 (c1 BIGINT NOT NULL);
3022
CREATE TABLE t3 (c1 BIGINT NOT NULL);
3023
CREATE TABLE t4 (c1 BIGINT NOT NULL);
3024
CREATE TABLE t5 (c1 BIGINT NOT NULL);
3025
CREATE TABLE t6 (c1 BIGINT NOT NULL);
3026
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3027
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3028
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3029
INSERT INTO t4 (c1) VALUES(10);
3030
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3031
SELECT t1.c1,t6.c1 FROM t1 INNER JOIN t6 USING (c1);
3033
SELECT t1.c1,t6.c1 FROM t1 INNER JOIN t6 ON t1.c1 = t6.c1;
3035
SELECT t1.c1,t6.c1 FROM t1 INNER JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 >= 5;
3037
DROP TABLE t1,t2,t3,t4,t5,t6;
3038
CREATE TABLE t1 (c1 TINYINT NOT NULL);
3039
CREATE TABLE t2 (c1 TINYINT NOT NULL);
3040
CREATE TABLE t3 (c1 TINYINT NOT NULL);
3041
CREATE TABLE t4 (c1 TINYINT NOT NULL);
3042
CREATE TABLE t5 (c1 TINYINT NOT NULL);
3043
CREATE TABLE t6 (c1 TINYINT NOT NULL);
3044
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3045
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3046
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3047
INSERT INTO t4 (c1) VALUES(10);
3048
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3049
SELECT t1.c1,t2.c1 FROM t1 INNER JOIN t2 USING (c1);
3061
SELECT t1.c1,t2.c1 FROM t1 INNER JOIN t2 ON t1.c1 = t2.c1;
3073
SELECT t1.c1,t2.c1 FROM t1 INNER JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 != 5;
3084
DROP TABLE t1,t2,t3,t4,t5,t6;
3085
CREATE TABLE t1 (c1 SMALLINT NOT NULL);
3086
CREATE TABLE t2 (c1 SMALLINT NOT NULL);
3087
CREATE TABLE t3 (c1 SMALLINT NOT NULL);
3088
CREATE TABLE t4 (c1 SMALLINT NOT NULL);
3089
CREATE TABLE t5 (c1 SMALLINT NOT NULL);
3090
CREATE TABLE t6 (c1 SMALLINT NOT NULL);
3091
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3092
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3093
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3094
INSERT INTO t4 (c1) VALUES(10);
3095
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3096
SELECT t1.c1,t2.c1 FROM t1 INNER JOIN t2 USING (c1);
3108
SELECT t1.c1,t2.c1 FROM t1 INNER JOIN t2 ON t1.c1 = t2.c1;
3120
SELECT t1.c1,t2.c1 FROM t1 INNER JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 != 5;
3131
DROP TABLE t1,t2,t3,t4,t5,t6;
3132
CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
3133
CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
3134
CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
3135
CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
3136
CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
3137
CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
3138
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3139
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3140
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3141
INSERT INTO t4 (c1) VALUES(10);
3142
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3143
SELECT t1.c1,t2.c1 FROM t1 INNER JOIN t2 USING (c1);
3155
SELECT t1.c1,t2.c1 FROM t1 INNER JOIN t2 ON t1.c1 = t2.c1;
3167
SELECT t1.c1,t2.c1 FROM t1 INNER JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 != 5;
3178
DROP TABLE t1,t2,t3,t4,t5,t6;
3179
CREATE TABLE t1 (c1 INT NOT NULL);
3180
CREATE TABLE t2 (c1 INT NOT NULL);
3181
CREATE TABLE t3 (c1 INT NOT NULL);
3182
CREATE TABLE t4 (c1 INT NOT NULL);
3183
CREATE TABLE t5 (c1 INT NOT NULL);
3184
CREATE TABLE t6 (c1 INT NOT NULL);
3185
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3186
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3187
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3188
INSERT INTO t4 (c1) VALUES(10);
3189
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3190
SELECT t1.c1,t2.c1 FROM t1 INNER JOIN t2 USING (c1);
3202
SELECT t1.c1,t2.c1 FROM t1 INNER JOIN t2 ON t1.c1 = t2.c1;
3214
SELECT t1.c1,t2.c1 FROM t1 INNER JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 != 5;
3225
DROP TABLE t1,t2,t3,t4,t5,t6;
3226
CREATE TABLE t1 (c1 INTEGER NOT NULL);
3227
CREATE TABLE t2 (c1 INTEGER NOT NULL);
3228
CREATE TABLE t3 (c1 INTEGER NOT NULL);
3229
CREATE TABLE t4 (c1 INTEGER NOT NULL);
3230
CREATE TABLE t5 (c1 INTEGER NOT NULL);
3231
CREATE TABLE t6 (c1 INTEGER NOT NULL);
3232
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3233
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3234
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3235
INSERT INTO t4 (c1) VALUES(10);
3236
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3237
SELECT t1.c1,t2.c1 FROM t1 INNER JOIN t2 USING (c1);
3249
SELECT t1.c1,t2.c1 FROM t1 INNER JOIN t2 ON t1.c1 = t2.c1;
3261
SELECT t1.c1,t2.c1 FROM t1 INNER JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 != 5;
3272
DROP TABLE t1,t2,t3,t4,t5,t6;
3273
CREATE TABLE t1 (c1 BIGINT NOT NULL);
3274
CREATE TABLE t2 (c1 BIGINT NOT NULL);
3275
CREATE TABLE t3 (c1 BIGINT NOT NULL);
3276
CREATE TABLE t4 (c1 BIGINT NOT NULL);
3277
CREATE TABLE t5 (c1 BIGINT NOT NULL);
3278
CREATE TABLE t6 (c1 BIGINT NOT NULL);
3279
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3280
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3281
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3282
INSERT INTO t4 (c1) VALUES(10);
3283
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3284
SELECT t1.c1,t2.c1 FROM t1 INNER JOIN t2 USING (c1);
3296
SELECT t1.c1,t2.c1 FROM t1 INNER JOIN t2 ON t1.c1 = t2.c1;
3308
SELECT t1.c1,t2.c1 FROM t1 INNER JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 != 5;
3319
DROP TABLE t1,t2,t3,t4,t5,t6;
3320
CREATE TABLE t1 (c1 TINYINT NOT NULL);
3321
CREATE TABLE t2 (c1 TINYINT NOT NULL);
3322
CREATE TABLE t3 (c1 TINYINT NOT NULL);
3323
CREATE TABLE t4 (c1 TINYINT NOT NULL);
3324
CREATE TABLE t5 (c1 TINYINT NOT NULL);
3325
CREATE TABLE t6 (c1 TINYINT NOT NULL);
3326
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3327
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3328
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3329
INSERT INTO t4 (c1) VALUES(10);
3330
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3331
SELECT t1.c1,t3.c1 FROM t1 INNER JOIN t3 USING (c1);
3338
SELECT t1.c1,t3.c1 FROM t1 INNER JOIN t3 ON t1.c1 = t3.c1;
3345
SELECT t1.c1,t3.c1 FROM t1 INNER JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 != 5;
3351
DROP TABLE t1,t2,t3,t4,t5,t6;
3352
CREATE TABLE t1 (c1 SMALLINT NOT NULL);
3353
CREATE TABLE t2 (c1 SMALLINT NOT NULL);
3354
CREATE TABLE t3 (c1 SMALLINT NOT NULL);
3355
CREATE TABLE t4 (c1 SMALLINT NOT NULL);
3356
CREATE TABLE t5 (c1 SMALLINT NOT NULL);
3357
CREATE TABLE t6 (c1 SMALLINT NOT NULL);
3358
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3359
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3360
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3361
INSERT INTO t4 (c1) VALUES(10);
3362
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3363
SELECT t1.c1,t3.c1 FROM t1 INNER JOIN t3 USING (c1);
3370
SELECT t1.c1,t3.c1 FROM t1 INNER JOIN t3 ON t1.c1 = t3.c1;
3377
SELECT t1.c1,t3.c1 FROM t1 INNER JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 != 5;
3383
DROP TABLE t1,t2,t3,t4,t5,t6;
3384
CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
3385
CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
3386
CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
3387
CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
3388
CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
3389
CREATE TABLE t6 (c1 MEDIUMINT 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,t3.c1 FROM t1 INNER JOIN t3 USING (c1);
3402
SELECT t1.c1,t3.c1 FROM t1 INNER JOIN t3 ON t1.c1 = t3.c1;
3409
SELECT t1.c1,t3.c1 FROM t1 INNER JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 != 5;
3415
DROP TABLE t1,t2,t3,t4,t5,t6;
3416
CREATE TABLE t1 (c1 INT NOT NULL);
3417
CREATE TABLE t2 (c1 INT NOT NULL);
3418
CREATE TABLE t3 (c1 INT NOT NULL);
3419
CREATE TABLE t4 (c1 INT NOT NULL);
3420
CREATE TABLE t5 (c1 INT NOT NULL);
3421
CREATE TABLE t6 (c1 INT NOT NULL);
3422
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3423
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3424
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3425
INSERT INTO t4 (c1) VALUES(10);
3426
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3427
SELECT t1.c1,t3.c1 FROM t1 INNER JOIN t3 USING (c1);
3434
SELECT t1.c1,t3.c1 FROM t1 INNER JOIN t3 ON t1.c1 = t3.c1;
3441
SELECT t1.c1,t3.c1 FROM t1 INNER JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 != 5;
3447
DROP TABLE t1,t2,t3,t4,t5,t6;
3448
CREATE TABLE t1 (c1 INTEGER NOT NULL);
3449
CREATE TABLE t2 (c1 INTEGER NOT NULL);
3450
CREATE TABLE t3 (c1 INTEGER NOT NULL);
3451
CREATE TABLE t4 (c1 INTEGER NOT NULL);
3452
CREATE TABLE t5 (c1 INTEGER NOT NULL);
3453
CREATE TABLE t6 (c1 INTEGER NOT NULL);
3454
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3455
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3456
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3457
INSERT INTO t4 (c1) VALUES(10);
3458
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3459
SELECT t1.c1,t3.c1 FROM t1 INNER JOIN t3 USING (c1);
3466
SELECT t1.c1,t3.c1 FROM t1 INNER JOIN t3 ON t1.c1 = t3.c1;
3473
SELECT t1.c1,t3.c1 FROM t1 INNER JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 != 5;
3479
DROP TABLE t1,t2,t3,t4,t5,t6;
3480
CREATE TABLE t1 (c1 BIGINT NOT NULL);
3481
CREATE TABLE t2 (c1 BIGINT NOT NULL);
3482
CREATE TABLE t3 (c1 BIGINT NOT NULL);
3483
CREATE TABLE t4 (c1 BIGINT NOT NULL);
3484
CREATE TABLE t5 (c1 BIGINT NOT NULL);
3485
CREATE TABLE t6 (c1 BIGINT NOT NULL);
3486
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3487
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3488
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3489
INSERT INTO t4 (c1) VALUES(10);
3490
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3491
SELECT t1.c1,t3.c1 FROM t1 INNER JOIN t3 USING (c1);
3498
SELECT t1.c1,t3.c1 FROM t1 INNER JOIN t3 ON t1.c1 = t3.c1;
3505
SELECT t1.c1,t3.c1 FROM t1 INNER JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 != 5;
3511
DROP TABLE t1,t2,t3,t4,t5,t6;
3512
CREATE TABLE t1 (c1 TINYINT NOT NULL);
3513
CREATE TABLE t2 (c1 TINYINT NOT NULL);
3514
CREATE TABLE t3 (c1 TINYINT NOT NULL);
3515
CREATE TABLE t4 (c1 TINYINT NOT NULL);
3516
CREATE TABLE t5 (c1 TINYINT NOT NULL);
3517
CREATE TABLE t6 (c1 TINYINT NOT NULL);
3518
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3519
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3520
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3521
INSERT INTO t4 (c1) VALUES(10);
3522
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3523
SELECT t1.c1,t4.c1 FROM t1 INNER JOIN t4 USING (c1);
3525
SELECT t1.c1,t4.c1 FROM t1 INNER JOIN t4 ON t1.c1 = t4.c1;
3527
SELECT t1.c1,t4.c1 FROM t1 INNER JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 != 5;
3529
DROP TABLE t1,t2,t3,t4,t5,t6;
3530
CREATE TABLE t1 (c1 SMALLINT NOT NULL);
3531
CREATE TABLE t2 (c1 SMALLINT NOT NULL);
3532
CREATE TABLE t3 (c1 SMALLINT NOT NULL);
3533
CREATE TABLE t4 (c1 SMALLINT NOT NULL);
3534
CREATE TABLE t5 (c1 SMALLINT NOT NULL);
3535
CREATE TABLE t6 (c1 SMALLINT NOT NULL);
3536
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3537
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3538
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3539
INSERT INTO t4 (c1) VALUES(10);
3540
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3541
SELECT t1.c1,t4.c1 FROM t1 INNER JOIN t4 USING (c1);
3543
SELECT t1.c1,t4.c1 FROM t1 INNER JOIN t4 ON t1.c1 = t4.c1;
3545
SELECT t1.c1,t4.c1 FROM t1 INNER JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 != 5;
3547
DROP TABLE t1,t2,t3,t4,t5,t6;
3548
CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
3549
CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
3550
CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
3551
CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
3552
CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
3553
CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
3554
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3555
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3556
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3557
INSERT INTO t4 (c1) VALUES(10);
3558
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3559
SELECT t1.c1,t4.c1 FROM t1 INNER JOIN t4 USING (c1);
3561
SELECT t1.c1,t4.c1 FROM t1 INNER JOIN t4 ON t1.c1 = t4.c1;
3563
SELECT t1.c1,t4.c1 FROM t1 INNER JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 != 5;
3565
DROP TABLE t1,t2,t3,t4,t5,t6;
3566
CREATE TABLE t1 (c1 INT NOT NULL);
3567
CREATE TABLE t2 (c1 INT NOT NULL);
3568
CREATE TABLE t3 (c1 INT NOT NULL);
3569
CREATE TABLE t4 (c1 INT NOT NULL);
3570
CREATE TABLE t5 (c1 INT NOT NULL);
3571
CREATE TABLE t6 (c1 INT NOT NULL);
3572
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3573
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3574
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3575
INSERT INTO t4 (c1) VALUES(10);
3576
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3577
SELECT t1.c1,t4.c1 FROM t1 INNER JOIN t4 USING (c1);
3579
SELECT t1.c1,t4.c1 FROM t1 INNER JOIN t4 ON t1.c1 = t4.c1;
3581
SELECT t1.c1,t4.c1 FROM t1 INNER JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 != 5;
3583
DROP TABLE t1,t2,t3,t4,t5,t6;
3584
CREATE TABLE t1 (c1 INTEGER NOT NULL);
3585
CREATE TABLE t2 (c1 INTEGER NOT NULL);
3586
CREATE TABLE t3 (c1 INTEGER NOT NULL);
3587
CREATE TABLE t4 (c1 INTEGER NOT NULL);
3588
CREATE TABLE t5 (c1 INTEGER NOT NULL);
3589
CREATE TABLE t6 (c1 INTEGER NOT NULL);
3590
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3591
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3592
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3593
INSERT INTO t4 (c1) VALUES(10);
3594
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3595
SELECT t1.c1,t4.c1 FROM t1 INNER JOIN t4 USING (c1);
3597
SELECT t1.c1,t4.c1 FROM t1 INNER JOIN t4 ON t1.c1 = t4.c1;
3599
SELECT t1.c1,t4.c1 FROM t1 INNER JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 != 5;
3601
DROP TABLE t1,t2,t3,t4,t5,t6;
3602
CREATE TABLE t1 (c1 BIGINT NOT NULL);
3603
CREATE TABLE t2 (c1 BIGINT NOT NULL);
3604
CREATE TABLE t3 (c1 BIGINT NOT NULL);
3605
CREATE TABLE t4 (c1 BIGINT NOT NULL);
3606
CREATE TABLE t5 (c1 BIGINT NOT NULL);
3607
CREATE TABLE t6 (c1 BIGINT NOT NULL);
3608
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3609
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3610
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3611
INSERT INTO t4 (c1) VALUES(10);
3612
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3613
SELECT t1.c1,t4.c1 FROM t1 INNER JOIN t4 USING (c1);
3615
SELECT t1.c1,t4.c1 FROM t1 INNER JOIN t4 ON t1.c1 = t4.c1;
3617
SELECT t1.c1,t4.c1 FROM t1 INNER JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 != 5;
3619
DROP TABLE t1,t2,t3,t4,t5,t6;
3620
CREATE TABLE t1 (c1 TINYINT NOT NULL);
3621
CREATE TABLE t2 (c1 TINYINT NOT NULL);
3622
CREATE TABLE t3 (c1 TINYINT NOT NULL);
3623
CREATE TABLE t4 (c1 TINYINT NOT NULL);
3624
CREATE TABLE t5 (c1 TINYINT NOT NULL);
3625
CREATE TABLE t6 (c1 TINYINT NOT NULL);
3626
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3627
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3628
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3629
INSERT INTO t4 (c1) VALUES(10);
3630
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3631
SELECT t1.c1,t5.c1 FROM t1 INNER JOIN t5 USING (c1);
3633
SELECT t1.c1,t5.c1 FROM t1 INNER JOIN t5 ON t1.c1 = t5.c1;
3635
SELECT t1.c1,t5.c1 FROM t1 INNER JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 != 5;
3637
DROP TABLE t1,t2,t3,t4,t5,t6;
3638
CREATE TABLE t1 (c1 SMALLINT NOT NULL);
3639
CREATE TABLE t2 (c1 SMALLINT NOT NULL);
3640
CREATE TABLE t3 (c1 SMALLINT NOT NULL);
3641
CREATE TABLE t4 (c1 SMALLINT NOT NULL);
3642
CREATE TABLE t5 (c1 SMALLINT NOT NULL);
3643
CREATE TABLE t6 (c1 SMALLINT NOT NULL);
3644
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3645
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3646
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3647
INSERT INTO t4 (c1) VALUES(10);
3648
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3649
SELECT t1.c1,t5.c1 FROM t1 INNER JOIN t5 USING (c1);
3651
SELECT t1.c1,t5.c1 FROM t1 INNER JOIN t5 ON t1.c1 = t5.c1;
3653
SELECT t1.c1,t5.c1 FROM t1 INNER JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 != 5;
3655
DROP TABLE t1,t2,t3,t4,t5,t6;
3656
CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
3657
CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
3658
CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
3659
CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
3660
CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
3661
CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
3662
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3663
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3664
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3665
INSERT INTO t4 (c1) VALUES(10);
3666
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3667
SELECT t1.c1,t5.c1 FROM t1 INNER JOIN t5 USING (c1);
3669
SELECT t1.c1,t5.c1 FROM t1 INNER JOIN t5 ON t1.c1 = t5.c1;
3671
SELECT t1.c1,t5.c1 FROM t1 INNER JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 != 5;
3673
DROP TABLE t1,t2,t3,t4,t5,t6;
3674
CREATE TABLE t1 (c1 INT NOT NULL);
3675
CREATE TABLE t2 (c1 INT NOT NULL);
3676
CREATE TABLE t3 (c1 INT NOT NULL);
3677
CREATE TABLE t4 (c1 INT NOT NULL);
3678
CREATE TABLE t5 (c1 INT NOT NULL);
3679
CREATE TABLE t6 (c1 INT NOT NULL);
3680
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3681
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3682
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3683
INSERT INTO t4 (c1) VALUES(10);
3684
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3685
SELECT t1.c1,t5.c1 FROM t1 INNER JOIN t5 USING (c1);
3687
SELECT t1.c1,t5.c1 FROM t1 INNER JOIN t5 ON t1.c1 = t5.c1;
3689
SELECT t1.c1,t5.c1 FROM t1 INNER JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 != 5;
3691
DROP TABLE t1,t2,t3,t4,t5,t6;
3692
CREATE TABLE t1 (c1 INTEGER NOT NULL);
3693
CREATE TABLE t2 (c1 INTEGER NOT NULL);
3694
CREATE TABLE t3 (c1 INTEGER NOT NULL);
3695
CREATE TABLE t4 (c1 INTEGER NOT NULL);
3696
CREATE TABLE t5 (c1 INTEGER NOT NULL);
3697
CREATE TABLE t6 (c1 INTEGER NOT NULL);
3698
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3699
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3700
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3701
INSERT INTO t4 (c1) VALUES(10);
3702
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3703
SELECT t1.c1,t5.c1 FROM t1 INNER JOIN t5 USING (c1);
3705
SELECT t1.c1,t5.c1 FROM t1 INNER JOIN t5 ON t1.c1 = t5.c1;
3707
SELECT t1.c1,t5.c1 FROM t1 INNER JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 != 5;
3709
DROP TABLE t1,t2,t3,t4,t5,t6;
3710
CREATE TABLE t1 (c1 BIGINT NOT NULL);
3711
CREATE TABLE t2 (c1 BIGINT NOT NULL);
3712
CREATE TABLE t3 (c1 BIGINT NOT NULL);
3713
CREATE TABLE t4 (c1 BIGINT NOT NULL);
3714
CREATE TABLE t5 (c1 BIGINT NOT NULL);
3715
CREATE TABLE t6 (c1 BIGINT NOT NULL);
3716
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3717
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3718
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3719
INSERT INTO t4 (c1) VALUES(10);
3720
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3721
SELECT t1.c1,t5.c1 FROM t1 INNER JOIN t5 USING (c1);
3723
SELECT t1.c1,t5.c1 FROM t1 INNER JOIN t5 ON t1.c1 = t5.c1;
3725
SELECT t1.c1,t5.c1 FROM t1 INNER JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 != 5;
3727
DROP TABLE t1,t2,t3,t4,t5,t6;
3728
CREATE TABLE t1 (c1 TINYINT NOT NULL);
3729
CREATE TABLE t2 (c1 TINYINT NOT NULL);
3730
CREATE TABLE t3 (c1 TINYINT NOT NULL);
3731
CREATE TABLE t4 (c1 TINYINT NOT NULL);
3732
CREATE TABLE t5 (c1 TINYINT NOT NULL);
3733
CREATE TABLE t6 (c1 TINYINT NOT NULL);
3734
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3735
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3736
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3737
INSERT INTO t4 (c1) VALUES(10);
3738
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3739
SELECT t1.c1,t6.c1 FROM t1 INNER JOIN t6 USING (c1);
3741
SELECT t1.c1,t6.c1 FROM t1 INNER JOIN t6 ON t1.c1 = t6.c1;
3743
SELECT t1.c1,t6.c1 FROM t1 INNER JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 != 5;
3745
DROP TABLE t1,t2,t3,t4,t5,t6;
3746
CREATE TABLE t1 (c1 SMALLINT NOT NULL);
3747
CREATE TABLE t2 (c1 SMALLINT NOT NULL);
3748
CREATE TABLE t3 (c1 SMALLINT NOT NULL);
3749
CREATE TABLE t4 (c1 SMALLINT NOT NULL);
3750
CREATE TABLE t5 (c1 SMALLINT NOT NULL);
3751
CREATE TABLE t6 (c1 SMALLINT NOT NULL);
3752
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3753
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3754
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3755
INSERT INTO t4 (c1) VALUES(10);
3756
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3757
SELECT t1.c1,t6.c1 FROM t1 INNER JOIN t6 USING (c1);
3759
SELECT t1.c1,t6.c1 FROM t1 INNER JOIN t6 ON t1.c1 = t6.c1;
3761
SELECT t1.c1,t6.c1 FROM t1 INNER JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 != 5;
3763
DROP TABLE t1,t2,t3,t4,t5,t6;
3764
CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
3765
CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
3766
CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
3767
CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
3768
CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
3769
CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
3770
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3771
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3772
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3773
INSERT INTO t4 (c1) VALUES(10);
3774
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3775
SELECT t1.c1,t6.c1 FROM t1 INNER JOIN t6 USING (c1);
3777
SELECT t1.c1,t6.c1 FROM t1 INNER JOIN t6 ON t1.c1 = t6.c1;
3779
SELECT t1.c1,t6.c1 FROM t1 INNER JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 != 5;
3781
DROP TABLE t1,t2,t3,t4,t5,t6;
3782
CREATE TABLE t1 (c1 INT NOT NULL);
3783
CREATE TABLE t2 (c1 INT NOT NULL);
3784
CREATE TABLE t3 (c1 INT NOT NULL);
3785
CREATE TABLE t4 (c1 INT NOT NULL);
3786
CREATE TABLE t5 (c1 INT NOT NULL);
3787
CREATE TABLE t6 (c1 INT NOT NULL);
3788
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3789
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3790
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3791
INSERT INTO t4 (c1) VALUES(10);
3792
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3793
SELECT t1.c1,t6.c1 FROM t1 INNER JOIN t6 USING (c1);
3795
SELECT t1.c1,t6.c1 FROM t1 INNER JOIN t6 ON t1.c1 = t6.c1;
3797
SELECT t1.c1,t6.c1 FROM t1 INNER JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 != 5;
3799
DROP TABLE t1,t2,t3,t4,t5,t6;
3800
CREATE TABLE t1 (c1 INTEGER NOT NULL);
3801
CREATE TABLE t2 (c1 INTEGER NOT NULL);
3802
CREATE TABLE t3 (c1 INTEGER NOT NULL);
3803
CREATE TABLE t4 (c1 INTEGER NOT NULL);
3804
CREATE TABLE t5 (c1 INTEGER NOT NULL);
3805
CREATE TABLE t6 (c1 INTEGER NOT NULL);
3806
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3807
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3808
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3809
INSERT INTO t4 (c1) VALUES(10);
3810
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3811
SELECT t1.c1,t6.c1 FROM t1 INNER JOIN t6 USING (c1);
3813
SELECT t1.c1,t6.c1 FROM t1 INNER JOIN t6 ON t1.c1 = t6.c1;
3815
SELECT t1.c1,t6.c1 FROM t1 INNER JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 != 5;
3817
DROP TABLE t1,t2,t3,t4,t5,t6;
3818
CREATE TABLE t1 (c1 BIGINT NOT NULL);
3819
CREATE TABLE t2 (c1 BIGINT NOT NULL);
3820
CREATE TABLE t3 (c1 BIGINT NOT NULL);
3821
CREATE TABLE t4 (c1 BIGINT NOT NULL);
3822
CREATE TABLE t5 (c1 BIGINT NOT NULL);
3823
CREATE TABLE t6 (c1 BIGINT NOT NULL);
3824
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3825
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3826
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3827
INSERT INTO t4 (c1) VALUES(10);
3828
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3829
SELECT t1.c1,t6.c1 FROM t1 INNER JOIN t6 USING (c1);
3831
SELECT t1.c1,t6.c1 FROM t1 INNER JOIN t6 ON t1.c1 = t6.c1;
3833
SELECT t1.c1,t6.c1 FROM t1 INNER JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 != 5;
3835
DROP TABLE t1,t2,t3,t4,t5,t6;
3836
CREATE TABLE t1 (c1 TINYINT NOT NULL);
3837
CREATE TABLE t2 (c1 TINYINT NOT NULL);
3838
CREATE TABLE t3 (c1 TINYINT NOT NULL);
3839
CREATE TABLE t4 (c1 TINYINT NOT NULL);
3840
CREATE TABLE t5 (c1 TINYINT NOT NULL);
3841
CREATE TABLE t6 (c1 TINYINT NOT NULL);
3842
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3843
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3844
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3845
INSERT INTO t4 (c1) VALUES(10);
3846
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3847
SELECT t1.c1,t2.c1 FROM t1 INNER JOIN t2 USING (c1);
3859
SELECT t1.c1,t2.c1 FROM t1 INNER JOIN t2 ON t1.c1 = t2.c1;
3871
SELECT t1.c1,t2.c1 FROM t1 INNER JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 <> 5;
3882
DROP TABLE t1,t2,t3,t4,t5,t6;
3883
CREATE TABLE t1 (c1 SMALLINT NOT NULL);
3884
CREATE TABLE t2 (c1 SMALLINT NOT NULL);
3885
CREATE TABLE t3 (c1 SMALLINT NOT NULL);
3886
CREATE TABLE t4 (c1 SMALLINT NOT NULL);
3887
CREATE TABLE t5 (c1 SMALLINT NOT NULL);
3888
CREATE TABLE t6 (c1 SMALLINT NOT NULL);
3889
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3890
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3891
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3892
INSERT INTO t4 (c1) VALUES(10);
3893
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3894
SELECT t1.c1,t2.c1 FROM t1 INNER JOIN t2 USING (c1);
3906
SELECT t1.c1,t2.c1 FROM t1 INNER JOIN t2 ON t1.c1 = t2.c1;
3918
SELECT t1.c1,t2.c1 FROM t1 INNER JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 <> 5;
3929
DROP TABLE t1,t2,t3,t4,t5,t6;
3930
CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
3931
CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
3932
CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
3933
CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
3934
CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
3935
CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
3936
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3937
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3938
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3939
INSERT INTO t4 (c1) VALUES(10);
3940
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3941
SELECT t1.c1,t2.c1 FROM t1 INNER JOIN t2 USING (c1);
3953
SELECT t1.c1,t2.c1 FROM t1 INNER JOIN t2 ON t1.c1 = t2.c1;
3965
SELECT t1.c1,t2.c1 FROM t1 INNER JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 <> 5;
3976
DROP TABLE t1,t2,t3,t4,t5,t6;
3977
CREATE TABLE t1 (c1 INT NOT NULL);
3978
CREATE TABLE t2 (c1 INT NOT NULL);
3979
CREATE TABLE t3 (c1 INT NOT NULL);
3980
CREATE TABLE t4 (c1 INT NOT NULL);
3981
CREATE TABLE t5 (c1 INT NOT NULL);
3982
CREATE TABLE t6 (c1 INT NOT NULL);
3983
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3984
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3985
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3986
INSERT INTO t4 (c1) VALUES(10);
3987
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3988
SELECT t1.c1,t2.c1 FROM t1 INNER JOIN t2 USING (c1);
4000
SELECT t1.c1,t2.c1 FROM t1 INNER JOIN t2 ON t1.c1 = t2.c1;
4012
SELECT t1.c1,t2.c1 FROM t1 INNER JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 <> 5;
4023
DROP TABLE t1,t2,t3,t4,t5,t6;
4024
CREATE TABLE t1 (c1 INTEGER NOT NULL);
4025
CREATE TABLE t2 (c1 INTEGER NOT NULL);
4026
CREATE TABLE t3 (c1 INTEGER NOT NULL);
4027
CREATE TABLE t4 (c1 INTEGER NOT NULL);
4028
CREATE TABLE t5 (c1 INTEGER NOT NULL);
4029
CREATE TABLE t6 (c1 INTEGER NOT NULL);
4030
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4031
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4032
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
4033
INSERT INTO t4 (c1) VALUES(10);
4034
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
4035
SELECT t1.c1,t2.c1 FROM t1 INNER JOIN t2 USING (c1);
4047
SELECT t1.c1,t2.c1 FROM t1 INNER JOIN t2 ON t1.c1 = t2.c1;
4059
SELECT t1.c1,t2.c1 FROM t1 INNER JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 <> 5;
4070
DROP TABLE t1,t2,t3,t4,t5,t6;
4071
CREATE TABLE t1 (c1 BIGINT NOT NULL);
4072
CREATE TABLE t2 (c1 BIGINT NOT NULL);
4073
CREATE TABLE t3 (c1 BIGINT NOT NULL);
4074
CREATE TABLE t4 (c1 BIGINT NOT NULL);
4075
CREATE TABLE t5 (c1 BIGINT NOT NULL);
4076
CREATE TABLE t6 (c1 BIGINT NOT NULL);
4077
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4078
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4079
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
4080
INSERT INTO t4 (c1) VALUES(10);
4081
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
4082
SELECT t1.c1,t2.c1 FROM t1 INNER JOIN t2 USING (c1);
4094
SELECT t1.c1,t2.c1 FROM t1 INNER JOIN t2 ON t1.c1 = t2.c1;
4106
SELECT t1.c1,t2.c1 FROM t1 INNER JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 <> 5;
4117
DROP TABLE t1,t2,t3,t4,t5,t6;
4118
CREATE TABLE t1 (c1 TINYINT NOT NULL);
4119
CREATE TABLE t2 (c1 TINYINT NOT NULL);
4120
CREATE TABLE t3 (c1 TINYINT NOT NULL);
4121
CREATE TABLE t4 (c1 TINYINT NOT NULL);
4122
CREATE TABLE t5 (c1 TINYINT NOT NULL);
4123
CREATE TABLE t6 (c1 TINYINT NOT NULL);
4124
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4125
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4126
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
4127
INSERT INTO t4 (c1) VALUES(10);
4128
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
4129
SELECT t1.c1,t3.c1 FROM t1 INNER JOIN t3 USING (c1);
4136
SELECT t1.c1,t3.c1 FROM t1 INNER JOIN t3 ON t1.c1 = t3.c1;
4143
SELECT t1.c1,t3.c1 FROM t1 INNER JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 <> 5;
4149
DROP TABLE t1,t2,t3,t4,t5,t6;
4150
CREATE TABLE t1 (c1 SMALLINT NOT NULL);
4151
CREATE TABLE t2 (c1 SMALLINT NOT NULL);
4152
CREATE TABLE t3 (c1 SMALLINT NOT NULL);
4153
CREATE TABLE t4 (c1 SMALLINT NOT NULL);
4154
CREATE TABLE t5 (c1 SMALLINT NOT NULL);
4155
CREATE TABLE t6 (c1 SMALLINT NOT NULL);
4156
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4157
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4158
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
4159
INSERT INTO t4 (c1) VALUES(10);
4160
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
4161
SELECT t1.c1,t3.c1 FROM t1 INNER JOIN t3 USING (c1);
4168
SELECT t1.c1,t3.c1 FROM t1 INNER JOIN t3 ON t1.c1 = t3.c1;
4175
SELECT t1.c1,t3.c1 FROM t1 INNER JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 <> 5;
4181
DROP TABLE t1,t2,t3,t4,t5,t6;
4182
CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
4183
CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
4184
CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
4185
CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
4186
CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
4187
CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
4188
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4189
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4190
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
4191
INSERT INTO t4 (c1) VALUES(10);
4192
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
4193
SELECT t1.c1,t3.c1 FROM t1 INNER JOIN t3 USING (c1);
4200
SELECT t1.c1,t3.c1 FROM t1 INNER JOIN t3 ON t1.c1 = t3.c1;
4207
SELECT t1.c1,t3.c1 FROM t1 INNER JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 <> 5;
4213
DROP TABLE t1,t2,t3,t4,t5,t6;
4214
CREATE TABLE t1 (c1 INT NOT NULL);
4215
CREATE TABLE t2 (c1 INT NOT NULL);
4216
CREATE TABLE t3 (c1 INT NOT NULL);
4217
CREATE TABLE t4 (c1 INT NOT NULL);
4218
CREATE TABLE t5 (c1 INT NOT NULL);
4219
CREATE TABLE t6 (c1 INT NOT NULL);
4220
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4221
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4222
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
4223
INSERT INTO t4 (c1) VALUES(10);
4224
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
4225
SELECT t1.c1,t3.c1 FROM t1 INNER JOIN t3 USING (c1);
4232
SELECT t1.c1,t3.c1 FROM t1 INNER JOIN t3 ON t1.c1 = t3.c1;
4239
SELECT t1.c1,t3.c1 FROM t1 INNER JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 <> 5;
4245
DROP TABLE t1,t2,t3,t4,t5,t6;
4246
CREATE TABLE t1 (c1 INTEGER NOT NULL);
4247
CREATE TABLE t2 (c1 INTEGER NOT NULL);
4248
CREATE TABLE t3 (c1 INTEGER NOT NULL);
4249
CREATE TABLE t4 (c1 INTEGER NOT NULL);
4250
CREATE TABLE t5 (c1 INTEGER NOT NULL);
4251
CREATE TABLE t6 (c1 INTEGER NOT NULL);
4252
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4253
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4254
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
4255
INSERT INTO t4 (c1) VALUES(10);
4256
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
4257
SELECT t1.c1,t3.c1 FROM t1 INNER JOIN t3 USING (c1);
4264
SELECT t1.c1,t3.c1 FROM t1 INNER JOIN t3 ON t1.c1 = t3.c1;
4271
SELECT t1.c1,t3.c1 FROM t1 INNER JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 <> 5;
4277
DROP TABLE t1,t2,t3,t4,t5,t6;
4278
CREATE TABLE t1 (c1 BIGINT NOT NULL);
4279
CREATE TABLE t2 (c1 BIGINT NOT NULL);
4280
CREATE TABLE t3 (c1 BIGINT NOT NULL);
4281
CREATE TABLE t4 (c1 BIGINT NOT NULL);
4282
CREATE TABLE t5 (c1 BIGINT NOT NULL);
4283
CREATE TABLE t6 (c1 BIGINT NOT NULL);
4284
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4285
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4286
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
4287
INSERT INTO t4 (c1) VALUES(10);
4288
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
4289
SELECT t1.c1,t3.c1 FROM t1 INNER JOIN t3 USING (c1);
4296
SELECT t1.c1,t3.c1 FROM t1 INNER JOIN t3 ON t1.c1 = t3.c1;
4303
SELECT t1.c1,t3.c1 FROM t1 INNER JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 <> 5;
4309
DROP TABLE t1,t2,t3,t4,t5,t6;
4310
CREATE TABLE t1 (c1 TINYINT NOT NULL);
4311
CREATE TABLE t2 (c1 TINYINT NOT NULL);
4312
CREATE TABLE t3 (c1 TINYINT NOT NULL);
4313
CREATE TABLE t4 (c1 TINYINT NOT NULL);
4314
CREATE TABLE t5 (c1 TINYINT NOT NULL);
4315
CREATE TABLE t6 (c1 TINYINT NOT NULL);
4316
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4317
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4318
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
4319
INSERT INTO t4 (c1) VALUES(10);
4320
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
4321
SELECT t1.c1,t4.c1 FROM t1 INNER JOIN t4 USING (c1);
4323
SELECT t1.c1,t4.c1 FROM t1 INNER JOIN t4 ON t1.c1 = t4.c1;
4325
SELECT t1.c1,t4.c1 FROM t1 INNER JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 <> 5;
4327
DROP TABLE t1,t2,t3,t4,t5,t6;
4328
CREATE TABLE t1 (c1 SMALLINT NOT NULL);
4329
CREATE TABLE t2 (c1 SMALLINT NOT NULL);
4330
CREATE TABLE t3 (c1 SMALLINT NOT NULL);
4331
CREATE TABLE t4 (c1 SMALLINT NOT NULL);
4332
CREATE TABLE t5 (c1 SMALLINT NOT NULL);
4333
CREATE TABLE t6 (c1 SMALLINT NOT NULL);
4334
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4335
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4336
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
4337
INSERT INTO t4 (c1) VALUES(10);
4338
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
4339
SELECT t1.c1,t4.c1 FROM t1 INNER JOIN t4 USING (c1);
4341
SELECT t1.c1,t4.c1 FROM t1 INNER JOIN t4 ON t1.c1 = t4.c1;
4343
SELECT t1.c1,t4.c1 FROM t1 INNER JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 <> 5;
4345
DROP TABLE t1,t2,t3,t4,t5,t6;
4346
CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
4347
CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
4348
CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
4349
CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
4350
CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
4351
CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
4352
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4353
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4354
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
4355
INSERT INTO t4 (c1) VALUES(10);
4356
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
4357
SELECT t1.c1,t4.c1 FROM t1 INNER JOIN t4 USING (c1);
4359
SELECT t1.c1,t4.c1 FROM t1 INNER JOIN t4 ON t1.c1 = t4.c1;
4361
SELECT t1.c1,t4.c1 FROM t1 INNER JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 <> 5;
4363
DROP TABLE t1,t2,t3,t4,t5,t6;
4364
CREATE TABLE t1 (c1 INT NOT NULL);
4365
CREATE TABLE t2 (c1 INT NOT NULL);
4366
CREATE TABLE t3 (c1 INT NOT NULL);
4367
CREATE TABLE t4 (c1 INT NOT NULL);
4368
CREATE TABLE t5 (c1 INT NOT NULL);
4369
CREATE TABLE t6 (c1 INT NOT NULL);
4370
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4371
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4372
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
4373
INSERT INTO t4 (c1) VALUES(10);
4374
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
4375
SELECT t1.c1,t4.c1 FROM t1 INNER JOIN t4 USING (c1);
4377
SELECT t1.c1,t4.c1 FROM t1 INNER JOIN t4 ON t1.c1 = t4.c1;
4379
SELECT t1.c1,t4.c1 FROM t1 INNER JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 <> 5;
4381
DROP TABLE t1,t2,t3,t4,t5,t6;
4382
CREATE TABLE t1 (c1 INTEGER NOT NULL);
4383
CREATE TABLE t2 (c1 INTEGER NOT NULL);
4384
CREATE TABLE t3 (c1 INTEGER NOT NULL);
4385
CREATE TABLE t4 (c1 INTEGER NOT NULL);
4386
CREATE TABLE t5 (c1 INTEGER NOT NULL);
4387
CREATE TABLE t6 (c1 INTEGER NOT NULL);
4388
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4389
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4390
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
4391
INSERT INTO t4 (c1) VALUES(10);
4392
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
4393
SELECT t1.c1,t4.c1 FROM t1 INNER JOIN t4 USING (c1);
4395
SELECT t1.c1,t4.c1 FROM t1 INNER JOIN t4 ON t1.c1 = t4.c1;
4397
SELECT t1.c1,t4.c1 FROM t1 INNER JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 <> 5;
4399
DROP TABLE t1,t2,t3,t4,t5,t6;
4400
CREATE TABLE t1 (c1 BIGINT NOT NULL);
4401
CREATE TABLE t2 (c1 BIGINT NOT NULL);
4402
CREATE TABLE t3 (c1 BIGINT NOT NULL);
4403
CREATE TABLE t4 (c1 BIGINT NOT NULL);
4404
CREATE TABLE t5 (c1 BIGINT NOT NULL);
4405
CREATE TABLE t6 (c1 BIGINT NOT NULL);
4406
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4407
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4408
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
4409
INSERT INTO t4 (c1) VALUES(10);
4410
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
4411
SELECT t1.c1,t4.c1 FROM t1 INNER JOIN t4 USING (c1);
4413
SELECT t1.c1,t4.c1 FROM t1 INNER JOIN t4 ON t1.c1 = t4.c1;
4415
SELECT t1.c1,t4.c1 FROM t1 INNER JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 <> 5;
4417
DROP TABLE t1,t2,t3,t4,t5,t6;
4418
CREATE TABLE t1 (c1 TINYINT NOT NULL);
4419
CREATE TABLE t2 (c1 TINYINT NOT NULL);
4420
CREATE TABLE t3 (c1 TINYINT NOT NULL);
4421
CREATE TABLE t4 (c1 TINYINT NOT NULL);
4422
CREATE TABLE t5 (c1 TINYINT NOT NULL);
4423
CREATE TABLE t6 (c1 TINYINT NOT NULL);
4424
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4425
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4426
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
4427
INSERT INTO t4 (c1) VALUES(10);
4428
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
4429
SELECT t1.c1,t5.c1 FROM t1 INNER JOIN t5 USING (c1);
4431
SELECT t1.c1,t5.c1 FROM t1 INNER JOIN t5 ON t1.c1 = t5.c1;
4433
SELECT t1.c1,t5.c1 FROM t1 INNER JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 <> 5;
4435
DROP TABLE t1,t2,t3,t4,t5,t6;
4436
CREATE TABLE t1 (c1 SMALLINT NOT NULL);
4437
CREATE TABLE t2 (c1 SMALLINT NOT NULL);
4438
CREATE TABLE t3 (c1 SMALLINT NOT NULL);
4439
CREATE TABLE t4 (c1 SMALLINT NOT NULL);
4440
CREATE TABLE t5 (c1 SMALLINT NOT NULL);
4441
CREATE TABLE t6 (c1 SMALLINT NOT NULL);
4442
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4443
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4444
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
4445
INSERT INTO t4 (c1) VALUES(10);
4446
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
4447
SELECT t1.c1,t5.c1 FROM t1 INNER JOIN t5 USING (c1);
4449
SELECT t1.c1,t5.c1 FROM t1 INNER JOIN t5 ON t1.c1 = t5.c1;
4451
SELECT t1.c1,t5.c1 FROM t1 INNER JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 <> 5;
4453
DROP TABLE t1,t2,t3,t4,t5,t6;
4454
CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
4455
CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
4456
CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
4457
CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
4458
CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
4459
CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
4460
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4461
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4462
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
4463
INSERT INTO t4 (c1) VALUES(10);
4464
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
4465
SELECT t1.c1,t5.c1 FROM t1 INNER JOIN t5 USING (c1);
4467
SELECT t1.c1,t5.c1 FROM t1 INNER JOIN t5 ON t1.c1 = t5.c1;
4469
SELECT t1.c1,t5.c1 FROM t1 INNER JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 <> 5;
4471
DROP TABLE t1,t2,t3,t4,t5,t6;
4472
CREATE TABLE t1 (c1 INT NOT NULL);
4473
CREATE TABLE t2 (c1 INT NOT NULL);
4474
CREATE TABLE t3 (c1 INT NOT NULL);
4475
CREATE TABLE t4 (c1 INT NOT NULL);
4476
CREATE TABLE t5 (c1 INT NOT NULL);
4477
CREATE TABLE t6 (c1 INT 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,t5.c1 FROM t1 INNER JOIN t5 USING (c1);
4485
SELECT t1.c1,t5.c1 FROM t1 INNER JOIN t5 ON t1.c1 = t5.c1;
4487
SELECT t1.c1,t5.c1 FROM t1 INNER JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 <> 5;
4489
DROP TABLE t1,t2,t3,t4,t5,t6;
4490
CREATE TABLE t1 (c1 INTEGER NOT NULL);
4491
CREATE TABLE t2 (c1 INTEGER NOT NULL);
4492
CREATE TABLE t3 (c1 INTEGER NOT NULL);
4493
CREATE TABLE t4 (c1 INTEGER NOT NULL);
4494
CREATE TABLE t5 (c1 INTEGER NOT NULL);
4495
CREATE TABLE t6 (c1 INTEGER NOT NULL);
4496
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4497
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4498
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
4499
INSERT INTO t4 (c1) VALUES(10);
4500
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
4501
SELECT t1.c1,t5.c1 FROM t1 INNER JOIN t5 USING (c1);
4503
SELECT t1.c1,t5.c1 FROM t1 INNER JOIN t5 ON t1.c1 = t5.c1;
4505
SELECT t1.c1,t5.c1 FROM t1 INNER JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 <> 5;
4507
DROP TABLE t1,t2,t3,t4,t5,t6;
4508
CREATE TABLE t1 (c1 BIGINT NOT NULL);
4509
CREATE TABLE t2 (c1 BIGINT NOT NULL);
4510
CREATE TABLE t3 (c1 BIGINT NOT NULL);
4511
CREATE TABLE t4 (c1 BIGINT NOT NULL);
4512
CREATE TABLE t5 (c1 BIGINT NOT NULL);
4513
CREATE TABLE t6 (c1 BIGINT NOT NULL);
4514
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4515
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4516
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
4517
INSERT INTO t4 (c1) VALUES(10);
4518
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
4519
SELECT t1.c1,t5.c1 FROM t1 INNER JOIN t5 USING (c1);
4521
SELECT t1.c1,t5.c1 FROM t1 INNER JOIN t5 ON t1.c1 = t5.c1;
4523
SELECT t1.c1,t5.c1 FROM t1 INNER JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 <> 5;
4525
DROP TABLE t1,t2,t3,t4,t5,t6;
4526
CREATE TABLE t1 (c1 TINYINT NOT NULL);
4527
CREATE TABLE t2 (c1 TINYINT NOT NULL);
4528
CREATE TABLE t3 (c1 TINYINT NOT NULL);
4529
CREATE TABLE t4 (c1 TINYINT NOT NULL);
4530
CREATE TABLE t5 (c1 TINYINT NOT NULL);
4531
CREATE TABLE t6 (c1 TINYINT NOT NULL);
4532
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4533
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4534
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
4535
INSERT INTO t4 (c1) VALUES(10);
4536
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
4537
SELECT t1.c1,t6.c1 FROM t1 INNER JOIN t6 USING (c1);
4539
SELECT t1.c1,t6.c1 FROM t1 INNER JOIN t6 ON t1.c1 = t6.c1;
4541
SELECT t1.c1,t6.c1 FROM t1 INNER JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 <> 5;
4543
DROP TABLE t1,t2,t3,t4,t5,t6;
4544
CREATE TABLE t1 (c1 SMALLINT NOT NULL);
4545
CREATE TABLE t2 (c1 SMALLINT NOT NULL);
4546
CREATE TABLE t3 (c1 SMALLINT NOT NULL);
4547
CREATE TABLE t4 (c1 SMALLINT NOT NULL);
4548
CREATE TABLE t5 (c1 SMALLINT NOT NULL);
4549
CREATE TABLE t6 (c1 SMALLINT NOT NULL);
4550
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4551
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4552
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
4553
INSERT INTO t4 (c1) VALUES(10);
4554
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
4555
SELECT t1.c1,t6.c1 FROM t1 INNER JOIN t6 USING (c1);
4557
SELECT t1.c1,t6.c1 FROM t1 INNER JOIN t6 ON t1.c1 = t6.c1;
4559
SELECT t1.c1,t6.c1 FROM t1 INNER JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 <> 5;
4561
DROP TABLE t1,t2,t3,t4,t5,t6;
4562
CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
4563
CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
4564
CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
4565
CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
4566
CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
4567
CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
4568
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4569
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4570
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
4571
INSERT INTO t4 (c1) VALUES(10);
4572
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
4573
SELECT t1.c1,t6.c1 FROM t1 INNER JOIN t6 USING (c1);
4575
SELECT t1.c1,t6.c1 FROM t1 INNER JOIN t6 ON t1.c1 = t6.c1;
4577
SELECT t1.c1,t6.c1 FROM t1 INNER JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 <> 5;
4579
DROP TABLE t1,t2,t3,t4,t5,t6;
4580
CREATE TABLE t1 (c1 INT NOT NULL);
4581
CREATE TABLE t2 (c1 INT NOT NULL);
4582
CREATE TABLE t3 (c1 INT NOT NULL);
4583
CREATE TABLE t4 (c1 INT NOT NULL);
4584
CREATE TABLE t5 (c1 INT NOT NULL);
4585
CREATE TABLE t6 (c1 INT NOT NULL);
4586
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4587
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4588
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
4589
INSERT INTO t4 (c1) VALUES(10);
4590
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
4591
SELECT t1.c1,t6.c1 FROM t1 INNER JOIN t6 USING (c1);
4593
SELECT t1.c1,t6.c1 FROM t1 INNER JOIN t6 ON t1.c1 = t6.c1;
4595
SELECT t1.c1,t6.c1 FROM t1 INNER JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 <> 5;
4597
DROP TABLE t1,t2,t3,t4,t5,t6;
4598
CREATE TABLE t1 (c1 INTEGER NOT NULL);
4599
CREATE TABLE t2 (c1 INTEGER NOT NULL);
4600
CREATE TABLE t3 (c1 INTEGER NOT NULL);
4601
CREATE TABLE t4 (c1 INTEGER NOT NULL);
4602
CREATE TABLE t5 (c1 INTEGER NOT NULL);
4603
CREATE TABLE t6 (c1 INTEGER NOT NULL);
4604
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4605
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4606
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
4607
INSERT INTO t4 (c1) VALUES(10);
4608
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
4609
SELECT t1.c1,t6.c1 FROM t1 INNER JOIN t6 USING (c1);
4611
SELECT t1.c1,t6.c1 FROM t1 INNER JOIN t6 ON t1.c1 = t6.c1;
4613
SELECT t1.c1,t6.c1 FROM t1 INNER JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 <> 5;
4615
DROP TABLE t1,t2,t3,t4,t5,t6;
4616
CREATE TABLE t1 (c1 BIGINT NOT NULL);
4617
CREATE TABLE t2 (c1 BIGINT NOT NULL);
4618
CREATE TABLE t3 (c1 BIGINT NOT NULL);
4619
CREATE TABLE t4 (c1 BIGINT NOT NULL);
4620
CREATE TABLE t5 (c1 BIGINT NOT NULL);
4621
CREATE TABLE t6 (c1 BIGINT NOT NULL);
4622
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4623
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4624
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
4625
INSERT INTO t4 (c1) VALUES(10);
4626
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
4627
SELECT t1.c1,t6.c1 FROM t1 INNER JOIN t6 USING (c1);
4629
SELECT t1.c1,t6.c1 FROM t1 INNER JOIN t6 ON t1.c1 = t6.c1;
4631
SELECT t1.c1,t6.c1 FROM t1 INNER JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 <> 5;
4633
DROP TABLE t1,t2,t3,t4,t5,t6;
4634
CREATE TABLE t1 (c1 TINYINT NOT NULL);
4635
CREATE TABLE t2 (c1 TINYINT NOT NULL);
4636
CREATE TABLE t3 (c1 TINYINT NOT NULL);
4637
CREATE TABLE t4 (c1 TINYINT NOT NULL);
4638
CREATE TABLE t5 (c1 TINYINT NOT NULL);
4639
CREATE TABLE t6 (c1 TINYINT NOT NULL);
4640
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4641
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4642
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
4643
INSERT INTO t4 (c1) VALUES(10);
4644
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
4645
SELECT t1.c1,t2.c1 FROM t1 INNER JOIN t2 USING (c1);
4657
SELECT t1.c1,t2.c1 FROM t1 INNER JOIN t2 ON t1.c1 = t2.c1;
4669
SELECT t1.c1,t2.c1 FROM t1 INNER JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 <=> 5;
4672
DROP TABLE t1,t2,t3,t4,t5,t6;
4673
CREATE TABLE t1 (c1 SMALLINT NOT NULL);
4674
CREATE TABLE t2 (c1 SMALLINT NOT NULL);
4675
CREATE TABLE t3 (c1 SMALLINT NOT NULL);
4676
CREATE TABLE t4 (c1 SMALLINT NOT NULL);
4677
CREATE TABLE t5 (c1 SMALLINT NOT NULL);
4678
CREATE TABLE t6 (c1 SMALLINT NOT NULL);
4679
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4680
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4681
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
4682
INSERT INTO t4 (c1) VALUES(10);
4683
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
4684
SELECT t1.c1,t2.c1 FROM t1 INNER JOIN t2 USING (c1);
4696
SELECT t1.c1,t2.c1 FROM t1 INNER JOIN t2 ON t1.c1 = t2.c1;
4708
SELECT t1.c1,t2.c1 FROM t1 INNER JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 <=> 5;
4711
DROP TABLE t1,t2,t3,t4,t5,t6;
4712
CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
4713
CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
4714
CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
4715
CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
4716
CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
4717
CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
4718
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4719
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4720
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
4721
INSERT INTO t4 (c1) VALUES(10);
4722
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
4723
SELECT t1.c1,t2.c1 FROM t1 INNER JOIN t2 USING (c1);
4735
SELECT t1.c1,t2.c1 FROM t1 INNER JOIN t2 ON t1.c1 = t2.c1;
4747
SELECT t1.c1,t2.c1 FROM t1 INNER JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 <=> 5;
4750
DROP TABLE t1,t2,t3,t4,t5,t6;
4751
CREATE TABLE t1 (c1 INT NOT NULL);
4752
CREATE TABLE t2 (c1 INT NOT NULL);
4753
CREATE TABLE t3 (c1 INT NOT NULL);
4754
CREATE TABLE t4 (c1 INT NOT NULL);
4755
CREATE TABLE t5 (c1 INT NOT NULL);
4756
CREATE TABLE t6 (c1 INT NOT NULL);
4757
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4758
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4759
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
4760
INSERT INTO t4 (c1) VALUES(10);
4761
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
4762
SELECT t1.c1,t2.c1 FROM t1 INNER JOIN t2 USING (c1);
4774
SELECT t1.c1,t2.c1 FROM t1 INNER JOIN t2 ON t1.c1 = t2.c1;
4786
SELECT t1.c1,t2.c1 FROM t1 INNER JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 <=> 5;
4789
DROP TABLE t1,t2,t3,t4,t5,t6;
4790
CREATE TABLE t1 (c1 INTEGER NOT NULL);
4791
CREATE TABLE t2 (c1 INTEGER NOT NULL);
4792
CREATE TABLE t3 (c1 INTEGER NOT NULL);
4793
CREATE TABLE t4 (c1 INTEGER NOT NULL);
4794
CREATE TABLE t5 (c1 INTEGER NOT NULL);
4795
CREATE TABLE t6 (c1 INTEGER NOT NULL);
4796
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4797
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4798
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
4799
INSERT INTO t4 (c1) VALUES(10);
4800
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
4801
SELECT t1.c1,t2.c1 FROM t1 INNER JOIN t2 USING (c1);
4813
SELECT t1.c1,t2.c1 FROM t1 INNER JOIN t2 ON t1.c1 = t2.c1;
4825
SELECT t1.c1,t2.c1 FROM t1 INNER JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 <=> 5;
4828
DROP TABLE t1,t2,t3,t4,t5,t6;
4829
CREATE TABLE t1 (c1 BIGINT NOT NULL);
4830
CREATE TABLE t2 (c1 BIGINT NOT NULL);
4831
CREATE TABLE t3 (c1 BIGINT NOT NULL);
4832
CREATE TABLE t4 (c1 BIGINT NOT NULL);
4833
CREATE TABLE t5 (c1 BIGINT NOT NULL);
4834
CREATE TABLE t6 (c1 BIGINT NOT NULL);
4835
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4836
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4837
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
4838
INSERT INTO t4 (c1) VALUES(10);
4839
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
4840
SELECT t1.c1,t2.c1 FROM t1 INNER JOIN t2 USING (c1);
4852
SELECT t1.c1,t2.c1 FROM t1 INNER JOIN t2 ON t1.c1 = t2.c1;
4864
SELECT t1.c1,t2.c1 FROM t1 INNER JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 <=> 5;
4867
DROP TABLE t1,t2,t3,t4,t5,t6;
4868
CREATE TABLE t1 (c1 TINYINT NOT NULL);
4869
CREATE TABLE t2 (c1 TINYINT NOT NULL);
4870
CREATE TABLE t3 (c1 TINYINT NOT NULL);
4871
CREATE TABLE t4 (c1 TINYINT NOT NULL);
4872
CREATE TABLE t5 (c1 TINYINT NOT NULL);
4873
CREATE TABLE t6 (c1 TINYINT NOT NULL);
4874
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4875
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4876
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
4877
INSERT INTO t4 (c1) VALUES(10);
4878
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
4879
SELECT t1.c1,t3.c1 FROM t1 INNER JOIN t3 USING (c1);
4886
SELECT t1.c1,t3.c1 FROM t1 INNER JOIN t3 ON t1.c1 = t3.c1;
4893
SELECT t1.c1,t3.c1 FROM t1 INNER JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 <=> 5;
4896
DROP TABLE t1,t2,t3,t4,t5,t6;
4897
CREATE TABLE t1 (c1 SMALLINT NOT NULL);
4898
CREATE TABLE t2 (c1 SMALLINT NOT NULL);
4899
CREATE TABLE t3 (c1 SMALLINT NOT NULL);
4900
CREATE TABLE t4 (c1 SMALLINT NOT NULL);
4901
CREATE TABLE t5 (c1 SMALLINT NOT NULL);
4902
CREATE TABLE t6 (c1 SMALLINT NOT NULL);
4903
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4904
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4905
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
4906
INSERT INTO t4 (c1) VALUES(10);
4907
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
4908
SELECT t1.c1,t3.c1 FROM t1 INNER JOIN t3 USING (c1);
4915
SELECT t1.c1,t3.c1 FROM t1 INNER JOIN t3 ON t1.c1 = t3.c1;
4922
SELECT t1.c1,t3.c1 FROM t1 INNER JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 <=> 5;
4925
DROP TABLE t1,t2,t3,t4,t5,t6;
4926
CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
4927
CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
4928
CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
4929
CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
4930
CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
4931
CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
4932
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4933
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4934
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
4935
INSERT INTO t4 (c1) VALUES(10);
4936
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
4937
SELECT t1.c1,t3.c1 FROM t1 INNER JOIN t3 USING (c1);
4944
SELECT t1.c1,t3.c1 FROM t1 INNER JOIN t3 ON t1.c1 = t3.c1;
4951
SELECT t1.c1,t3.c1 FROM t1 INNER JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 <=> 5;
4954
DROP TABLE t1,t2,t3,t4,t5,t6;
4955
CREATE TABLE t1 (c1 INT NOT NULL);
4956
CREATE TABLE t2 (c1 INT NOT NULL);
4957
CREATE TABLE t3 (c1 INT NOT NULL);
4958
CREATE TABLE t4 (c1 INT NOT NULL);
4959
CREATE TABLE t5 (c1 INT NOT NULL);
4960
CREATE TABLE t6 (c1 INT NOT NULL);
4961
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4962
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4963
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
4964
INSERT INTO t4 (c1) VALUES(10);
4965
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
4966
SELECT t1.c1,t3.c1 FROM t1 INNER JOIN t3 USING (c1);
4973
SELECT t1.c1,t3.c1 FROM t1 INNER JOIN t3 ON t1.c1 = t3.c1;
4980
SELECT t1.c1,t3.c1 FROM t1 INNER JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 <=> 5;
4983
DROP TABLE t1,t2,t3,t4,t5,t6;
4984
CREATE TABLE t1 (c1 INTEGER NOT NULL);
4985
CREATE TABLE t2 (c1 INTEGER NOT NULL);
4986
CREATE TABLE t3 (c1 INTEGER NOT NULL);
4987
CREATE TABLE t4 (c1 INTEGER NOT NULL);
4988
CREATE TABLE t5 (c1 INTEGER NOT NULL);
4989
CREATE TABLE t6 (c1 INTEGER NOT NULL);
4990
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4991
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4992
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
4993
INSERT INTO t4 (c1) VALUES(10);
4994
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
4995
SELECT t1.c1,t3.c1 FROM t1 INNER JOIN t3 USING (c1);
5002
SELECT t1.c1,t3.c1 FROM t1 INNER JOIN t3 ON t1.c1 = t3.c1;
5009
SELECT t1.c1,t3.c1 FROM t1 INNER JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 <=> 5;
5012
DROP TABLE t1,t2,t3,t4,t5,t6;
5013
CREATE TABLE t1 (c1 BIGINT NOT NULL);
5014
CREATE TABLE t2 (c1 BIGINT NOT NULL);
5015
CREATE TABLE t3 (c1 BIGINT NOT NULL);
5016
CREATE TABLE t4 (c1 BIGINT NOT NULL);
5017
CREATE TABLE t5 (c1 BIGINT NOT NULL);
5018
CREATE TABLE t6 (c1 BIGINT NOT NULL);
5019
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5020
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5021
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
5022
INSERT INTO t4 (c1) VALUES(10);
5023
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
5024
SELECT t1.c1,t3.c1 FROM t1 INNER JOIN t3 USING (c1);
5031
SELECT t1.c1,t3.c1 FROM t1 INNER JOIN t3 ON t1.c1 = t3.c1;
5038
SELECT t1.c1,t3.c1 FROM t1 INNER JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 <=> 5;
5041
DROP TABLE t1,t2,t3,t4,t5,t6;
5042
CREATE TABLE t1 (c1 TINYINT NOT NULL);
5043
CREATE TABLE t2 (c1 TINYINT NOT NULL);
5044
CREATE TABLE t3 (c1 TINYINT NOT NULL);
5045
CREATE TABLE t4 (c1 TINYINT NOT NULL);
5046
CREATE TABLE t5 (c1 TINYINT NOT NULL);
5047
CREATE TABLE t6 (c1 TINYINT NOT NULL);
5048
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5049
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5050
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
5051
INSERT INTO t4 (c1) VALUES(10);
5052
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
5053
SELECT t1.c1,t4.c1 FROM t1 INNER JOIN t4 USING (c1);
5055
SELECT t1.c1,t4.c1 FROM t1 INNER JOIN t4 ON t1.c1 = t4.c1;
5057
SELECT t1.c1,t4.c1 FROM t1 INNER JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 <=> 5;
5059
DROP TABLE t1,t2,t3,t4,t5,t6;
5060
CREATE TABLE t1 (c1 SMALLINT NOT NULL);
5061
CREATE TABLE t2 (c1 SMALLINT NOT NULL);
5062
CREATE TABLE t3 (c1 SMALLINT NOT NULL);
5063
CREATE TABLE t4 (c1 SMALLINT NOT NULL);
5064
CREATE TABLE t5 (c1 SMALLINT NOT NULL);
5065
CREATE TABLE t6 (c1 SMALLINT NOT NULL);
5066
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5067
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5068
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
5069
INSERT INTO t4 (c1) VALUES(10);
5070
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
5071
SELECT t1.c1,t4.c1 FROM t1 INNER JOIN t4 USING (c1);
5073
SELECT t1.c1,t4.c1 FROM t1 INNER JOIN t4 ON t1.c1 = t4.c1;
5075
SELECT t1.c1,t4.c1 FROM t1 INNER JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 <=> 5;
5077
DROP TABLE t1,t2,t3,t4,t5,t6;
5078
CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
5079
CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
5080
CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
5081
CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
5082
CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
5083
CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
5084
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5085
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5086
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
5087
INSERT INTO t4 (c1) VALUES(10);
5088
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
5089
SELECT t1.c1,t4.c1 FROM t1 INNER JOIN t4 USING (c1);
5091
SELECT t1.c1,t4.c1 FROM t1 INNER JOIN t4 ON t1.c1 = t4.c1;
5093
SELECT t1.c1,t4.c1 FROM t1 INNER JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 <=> 5;
5095
DROP TABLE t1,t2,t3,t4,t5,t6;
5096
CREATE TABLE t1 (c1 INT NOT NULL);
5097
CREATE TABLE t2 (c1 INT NOT NULL);
5098
CREATE TABLE t3 (c1 INT NOT NULL);
5099
CREATE TABLE t4 (c1 INT NOT NULL);
5100
CREATE TABLE t5 (c1 INT NOT NULL);
5101
CREATE TABLE t6 (c1 INT NOT NULL);
5102
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5103
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5104
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
5105
INSERT INTO t4 (c1) VALUES(10);
5106
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
5107
SELECT t1.c1,t4.c1 FROM t1 INNER JOIN t4 USING (c1);
5109
SELECT t1.c1,t4.c1 FROM t1 INNER JOIN t4 ON t1.c1 = t4.c1;
5111
SELECT t1.c1,t4.c1 FROM t1 INNER JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 <=> 5;
5113
DROP TABLE t1,t2,t3,t4,t5,t6;
5114
CREATE TABLE t1 (c1 INTEGER NOT NULL);
5115
CREATE TABLE t2 (c1 INTEGER NOT NULL);
5116
CREATE TABLE t3 (c1 INTEGER NOT NULL);
5117
CREATE TABLE t4 (c1 INTEGER NOT NULL);
5118
CREATE TABLE t5 (c1 INTEGER NOT NULL);
5119
CREATE TABLE t6 (c1 INTEGER NOT NULL);
5120
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5121
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5122
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
5123
INSERT INTO t4 (c1) VALUES(10);
5124
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
5125
SELECT t1.c1,t4.c1 FROM t1 INNER JOIN t4 USING (c1);
5127
SELECT t1.c1,t4.c1 FROM t1 INNER JOIN t4 ON t1.c1 = t4.c1;
5129
SELECT t1.c1,t4.c1 FROM t1 INNER JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 <=> 5;
5131
DROP TABLE t1,t2,t3,t4,t5,t6;
5132
CREATE TABLE t1 (c1 BIGINT NOT NULL);
5133
CREATE TABLE t2 (c1 BIGINT NOT NULL);
5134
CREATE TABLE t3 (c1 BIGINT NOT NULL);
5135
CREATE TABLE t4 (c1 BIGINT NOT NULL);
5136
CREATE TABLE t5 (c1 BIGINT NOT NULL);
5137
CREATE TABLE t6 (c1 BIGINT NOT NULL);
5138
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5139
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5140
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
5141
INSERT INTO t4 (c1) VALUES(10);
5142
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
5143
SELECT t1.c1,t4.c1 FROM t1 INNER JOIN t4 USING (c1);
5145
SELECT t1.c1,t4.c1 FROM t1 INNER JOIN t4 ON t1.c1 = t4.c1;
5147
SELECT t1.c1,t4.c1 FROM t1 INNER JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 <=> 5;
5149
DROP TABLE t1,t2,t3,t4,t5,t6;
5150
CREATE TABLE t1 (c1 TINYINT NOT NULL);
5151
CREATE TABLE t2 (c1 TINYINT NOT NULL);
5152
CREATE TABLE t3 (c1 TINYINT NOT NULL);
5153
CREATE TABLE t4 (c1 TINYINT NOT NULL);
5154
CREATE TABLE t5 (c1 TINYINT NOT NULL);
5155
CREATE TABLE t6 (c1 TINYINT NOT NULL);
5156
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5157
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5158
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
5159
INSERT INTO t4 (c1) VALUES(10);
5160
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
5161
SELECT t1.c1,t5.c1 FROM t1 INNER JOIN t5 USING (c1);
5163
SELECT t1.c1,t5.c1 FROM t1 INNER JOIN t5 ON t1.c1 = t5.c1;
5165
SELECT t1.c1,t5.c1 FROM t1 INNER JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 <=> 5;
5167
DROP TABLE t1,t2,t3,t4,t5,t6;
5168
CREATE TABLE t1 (c1 SMALLINT NOT NULL);
5169
CREATE TABLE t2 (c1 SMALLINT NOT NULL);
5170
CREATE TABLE t3 (c1 SMALLINT NOT NULL);
5171
CREATE TABLE t4 (c1 SMALLINT NOT NULL);
5172
CREATE TABLE t5 (c1 SMALLINT NOT NULL);
5173
CREATE TABLE t6 (c1 SMALLINT NOT NULL);
5174
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5175
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5176
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
5177
INSERT INTO t4 (c1) VALUES(10);
5178
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
5179
SELECT t1.c1,t5.c1 FROM t1 INNER JOIN t5 USING (c1);
5181
SELECT t1.c1,t5.c1 FROM t1 INNER JOIN t5 ON t1.c1 = t5.c1;
5183
SELECT t1.c1,t5.c1 FROM t1 INNER JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 <=> 5;
5185
DROP TABLE t1,t2,t3,t4,t5,t6;
5186
CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
5187
CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
5188
CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
5189
CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
5190
CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
5191
CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
5192
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5193
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5194
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
5195
INSERT INTO t4 (c1) VALUES(10);
5196
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
5197
SELECT t1.c1,t5.c1 FROM t1 INNER JOIN t5 USING (c1);
5199
SELECT t1.c1,t5.c1 FROM t1 INNER JOIN t5 ON t1.c1 = t5.c1;
5201
SELECT t1.c1,t5.c1 FROM t1 INNER JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 <=> 5;
5203
DROP TABLE t1,t2,t3,t4,t5,t6;
5204
CREATE TABLE t1 (c1 INT NOT NULL);
5205
CREATE TABLE t2 (c1 INT NOT NULL);
5206
CREATE TABLE t3 (c1 INT NOT NULL);
5207
CREATE TABLE t4 (c1 INT NOT NULL);
5208
CREATE TABLE t5 (c1 INT NOT NULL);
5209
CREATE TABLE t6 (c1 INT NOT NULL);
5210
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5211
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5212
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
5213
INSERT INTO t4 (c1) VALUES(10);
5214
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
5215
SELECT t1.c1,t5.c1 FROM t1 INNER JOIN t5 USING (c1);
5217
SELECT t1.c1,t5.c1 FROM t1 INNER JOIN t5 ON t1.c1 = t5.c1;
5219
SELECT t1.c1,t5.c1 FROM t1 INNER JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 <=> 5;
5221
DROP TABLE t1,t2,t3,t4,t5,t6;
5222
CREATE TABLE t1 (c1 INTEGER NOT NULL);
5223
CREATE TABLE t2 (c1 INTEGER NOT NULL);
5224
CREATE TABLE t3 (c1 INTEGER NOT NULL);
5225
CREATE TABLE t4 (c1 INTEGER NOT NULL);
5226
CREATE TABLE t5 (c1 INTEGER NOT NULL);
5227
CREATE TABLE t6 (c1 INTEGER NOT NULL);
5228
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5229
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5230
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
5231
INSERT INTO t4 (c1) VALUES(10);
5232
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
5233
SELECT t1.c1,t5.c1 FROM t1 INNER JOIN t5 USING (c1);
5235
SELECT t1.c1,t5.c1 FROM t1 INNER JOIN t5 ON t1.c1 = t5.c1;
5237
SELECT t1.c1,t5.c1 FROM t1 INNER JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 <=> 5;
5239
DROP TABLE t1,t2,t3,t4,t5,t6;
5240
CREATE TABLE t1 (c1 BIGINT NOT NULL);
5241
CREATE TABLE t2 (c1 BIGINT NOT NULL);
5242
CREATE TABLE t3 (c1 BIGINT NOT NULL);
5243
CREATE TABLE t4 (c1 BIGINT NOT NULL);
5244
CREATE TABLE t5 (c1 BIGINT NOT NULL);
5245
CREATE TABLE t6 (c1 BIGINT NOT NULL);
5246
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5247
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5248
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
5249
INSERT INTO t4 (c1) VALUES(10);
5250
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
5251
SELECT t1.c1,t5.c1 FROM t1 INNER JOIN t5 USING (c1);
5253
SELECT t1.c1,t5.c1 FROM t1 INNER JOIN t5 ON t1.c1 = t5.c1;
5255
SELECT t1.c1,t5.c1 FROM t1 INNER JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 <=> 5;
5257
DROP TABLE t1,t2,t3,t4,t5,t6;
5258
CREATE TABLE t1 (c1 TINYINT NOT NULL);
5259
CREATE TABLE t2 (c1 TINYINT NOT NULL);
5260
CREATE TABLE t3 (c1 TINYINT NOT NULL);
5261
CREATE TABLE t4 (c1 TINYINT NOT NULL);
5262
CREATE TABLE t5 (c1 TINYINT NOT NULL);
5263
CREATE TABLE t6 (c1 TINYINT NOT NULL);
5264
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5265
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5266
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
5267
INSERT INTO t4 (c1) VALUES(10);
5268
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
5269
SELECT t1.c1,t6.c1 FROM t1 INNER JOIN t6 USING (c1);
5271
SELECT t1.c1,t6.c1 FROM t1 INNER JOIN t6 ON t1.c1 = t6.c1;
5273
SELECT t1.c1,t6.c1 FROM t1 INNER JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 <=> 5;
5275
DROP TABLE t1,t2,t3,t4,t5,t6;
5276
CREATE TABLE t1 (c1 SMALLINT NOT NULL);
5277
CREATE TABLE t2 (c1 SMALLINT NOT NULL);
5278
CREATE TABLE t3 (c1 SMALLINT NOT NULL);
5279
CREATE TABLE t4 (c1 SMALLINT NOT NULL);
5280
CREATE TABLE t5 (c1 SMALLINT NOT NULL);
5281
CREATE TABLE t6 (c1 SMALLINT NOT NULL);
5282
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5283
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5284
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
5285
INSERT INTO t4 (c1) VALUES(10);
5286
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
5287
SELECT t1.c1,t6.c1 FROM t1 INNER JOIN t6 USING (c1);
5289
SELECT t1.c1,t6.c1 FROM t1 INNER JOIN t6 ON t1.c1 = t6.c1;
5291
SELECT t1.c1,t6.c1 FROM t1 INNER JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 <=> 5;
5293
DROP TABLE t1,t2,t3,t4,t5,t6;
5294
CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
5295
CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
5296
CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
5297
CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
5298
CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
5299
CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
5300
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5301
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5302
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
5303
INSERT INTO t4 (c1) VALUES(10);
5304
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
5305
SELECT t1.c1,t6.c1 FROM t1 INNER JOIN t6 USING (c1);
5307
SELECT t1.c1,t6.c1 FROM t1 INNER JOIN t6 ON t1.c1 = t6.c1;
5309
SELECT t1.c1,t6.c1 FROM t1 INNER JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 <=> 5;
5311
DROP TABLE t1,t2,t3,t4,t5,t6;
5312
CREATE TABLE t1 (c1 INT NOT NULL);
5313
CREATE TABLE t2 (c1 INT NOT NULL);
5314
CREATE TABLE t3 (c1 INT NOT NULL);
5315
CREATE TABLE t4 (c1 INT NOT NULL);
5316
CREATE TABLE t5 (c1 INT NOT NULL);
5317
CREATE TABLE t6 (c1 INT 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,t6.c1 FROM t1 INNER JOIN t6 USING (c1);
5325
SELECT t1.c1,t6.c1 FROM t1 INNER JOIN t6 ON t1.c1 = t6.c1;
5327
SELECT t1.c1,t6.c1 FROM t1 INNER JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 <=> 5;
5329
DROP TABLE t1,t2,t3,t4,t5,t6;
5330
CREATE TABLE t1 (c1 INTEGER NOT NULL);
5331
CREATE TABLE t2 (c1 INTEGER NOT NULL);
5332
CREATE TABLE t3 (c1 INTEGER NOT NULL);
5333
CREATE TABLE t4 (c1 INTEGER NOT NULL);
5334
CREATE TABLE t5 (c1 INTEGER NOT NULL);
5335
CREATE TABLE t6 (c1 INTEGER NOT NULL);
5336
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5337
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5338
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
5339
INSERT INTO t4 (c1) VALUES(10);
5340
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
5341
SELECT t1.c1,t6.c1 FROM t1 INNER JOIN t6 USING (c1);
5343
SELECT t1.c1,t6.c1 FROM t1 INNER JOIN t6 ON t1.c1 = t6.c1;
5345
SELECT t1.c1,t6.c1 FROM t1 INNER JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 <=> 5;
5347
DROP TABLE t1,t2,t3,t4,t5,t6;
5348
CREATE TABLE t1 (c1 BIGINT NOT NULL);
5349
CREATE TABLE t2 (c1 BIGINT NOT NULL);
5350
CREATE TABLE t3 (c1 BIGINT NOT NULL);
5351
CREATE TABLE t4 (c1 BIGINT NOT NULL);
5352
CREATE TABLE t5 (c1 BIGINT NOT NULL);
5353
CREATE TABLE t6 (c1 BIGINT NOT NULL);
5354
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5355
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5356
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
5357
INSERT INTO t4 (c1) VALUES(10);
5358
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
5359
SELECT t1.c1,t6.c1 FROM t1 INNER JOIN t6 USING (c1);
5361
SELECT t1.c1,t6.c1 FROM t1 INNER JOIN t6 ON t1.c1 = t6.c1;
5363
SELECT t1.c1,t6.c1 FROM t1 INNER JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 <=> 5;
5365
DROP TABLE t1,t2,t3,t4,t5,t6;