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;