[tomato.git] / release / src / router / mysql / mysql-test / suite / engines / funcs / r / se_join_default.result
| blob | a825ad314f33d63da499b175ef3294c29228a7e0 |
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,t2 WHERE t1.c1 < t2.c1;
14 c1 c1
15 0 1
16 0 2
17 1 2
18 0 3
19 1 3
20 2 3
21 0 4
22 1 4
23 2 4
24 3 4
25 0 5
26 1 5
27 2 5
28 3 5
29 4 5
30 0 6
31 1 6
32 2 6
33 3 6
34 4 6
35 5 6
36 0 7
37 1 7
38 2 7
39 3 7
40 4 7
41 5 7
42 6 7
43 0 8
44 1 8
45 2 8
46 3 8
47 4 8
48 5 8
49 6 8
50 7 8
51 0 9
52 1 9
53 2 9
54 3 9
55 4 9
56 5 9
57 6 9
58 7 9
59 8 9
60 DROP TABLE t1,t2,t3,t4,t5,t6;
61 CREATE TABLE t1 (c1 SMALLINT NOT NULL);
62 CREATE TABLE t2 (c1 SMALLINT NOT NULL);
63 CREATE TABLE t3 (c1 SMALLINT NOT NULL);
64 CREATE TABLE t4 (c1 SMALLINT NOT NULL);
65 CREATE TABLE t5 (c1 SMALLINT NOT NULL);
66 CREATE TABLE t6 (c1 SMALLINT NOT NULL);
67 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
68 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
69 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
70 INSERT INTO t4 (c1) VALUES(10);
71 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
72 SELECT t1.c1,t2.c1 FROM t1,t2 WHERE t1.c1 < t2.c1;
73 c1 c1
74 0 1
75 0 2
76 1 2
77 0 3
78 1 3
79 2 3
80 0 4
81 1 4
82 2 4
83 3 4
84 0 5
85 1 5
86 2 5
87 3 5
88 4 5
89 0 6
90 1 6
91 2 6
92 3 6
93 4 6
94 5 6
95 0 7
96 1 7
97 2 7
98 3 7
99 4 7
100 5 7
101 6 7
102 0 8
103 1 8
104 2 8
105 3 8
106 4 8
107 5 8
108 6 8
109 7 8
110 0 9
111 1 9
112 2 9
113 3 9
114 4 9
115 5 9
116 6 9
117 7 9
118 8 9
119 DROP TABLE t1,t2,t3,t4,t5,t6;
120 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
121 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
122 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
123 CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
124 CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
125 CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
126 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
127 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
128 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
129 INSERT INTO t4 (c1) VALUES(10);
130 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
131 SELECT t1.c1,t2.c1 FROM t1,t2 WHERE t1.c1 < t2.c1;
132 c1 c1
133 0 1
134 0 2
135 1 2
136 0 3
137 1 3
138 2 3
139 0 4
140 1 4
141 2 4
142 3 4
143 0 5
144 1 5
145 2 5
146 3 5
147 4 5
148 0 6
149 1 6
150 2 6
151 3 6
152 4 6
153 5 6
154 0 7
155 1 7
156 2 7
157 3 7
158 4 7
159 5 7
160 6 7
161 0 8
162 1 8
163 2 8
164 3 8
165 4 8
166 5 8
167 6 8
168 7 8
169 0 9
170 1 9
171 2 9
172 3 9
173 4 9
174 5 9
175 6 9
176 7 9
177 8 9
178 DROP TABLE t1,t2,t3,t4,t5,t6;
179 CREATE TABLE t1 (c1 INT NOT NULL);
180 CREATE TABLE t2 (c1 INT NOT NULL);
181 CREATE TABLE t3 (c1 INT NOT NULL);
182 CREATE TABLE t4 (c1 INT NOT NULL);
183 CREATE TABLE t5 (c1 INT NOT NULL);
184 CREATE TABLE t6 (c1 INT NOT NULL);
185 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
186 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
187 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
188 INSERT INTO t4 (c1) VALUES(10);
189 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
190 SELECT t1.c1,t2.c1 FROM t1,t2 WHERE t1.c1 < t2.c1;
191 c1 c1
192 0 1
193 0 2
194 1 2
195 0 3
196 1 3
197 2 3
198 0 4
199 1 4
200 2 4
201 3 4
202 0 5
203 1 5
204 2 5
205 3 5
206 4 5
207 0 6
208 1 6
209 2 6
210 3 6
211 4 6
212 5 6
213 0 7
214 1 7
215 2 7
216 3 7
217 4 7
218 5 7
219 6 7
220 0 8
221 1 8
222 2 8
223 3 8
224 4 8
225 5 8
226 6 8
227 7 8
228 0 9
229 1 9
230 2 9
231 3 9
232 4 9
233 5 9
234 6 9
235 7 9
236 8 9
237 DROP TABLE t1,t2,t3,t4,t5,t6;
238 CREATE TABLE t1 (c1 INTEGER NOT NULL);
239 CREATE TABLE t2 (c1 INTEGER NOT NULL);
240 CREATE TABLE t3 (c1 INTEGER NOT NULL);
241 CREATE TABLE t4 (c1 INTEGER NOT NULL);
242 CREATE TABLE t5 (c1 INTEGER NOT NULL);
243 CREATE TABLE t6 (c1 INTEGER NOT NULL);
244 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
245 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
246 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
247 INSERT INTO t4 (c1) VALUES(10);
248 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
249 SELECT t1.c1,t2.c1 FROM t1,t2 WHERE t1.c1 < t2.c1;
250 c1 c1
251 0 1
252 0 2
253 1 2
254 0 3
255 1 3
256 2 3
257 0 4
258 1 4
259 2 4
260 3 4
261 0 5
262 1 5
263 2 5
264 3 5
265 4 5
266 0 6
267 1 6
268 2 6
269 3 6
270 4 6
271 5 6
272 0 7
273 1 7
274 2 7
275 3 7
276 4 7
277 5 7
278 6 7
279 0 8
280 1 8
281 2 8
282 3 8
283 4 8
284 5 8
285 6 8
286 7 8
287 0 9
288 1 9
289 2 9
290 3 9
291 4 9
292 5 9
293 6 9
294 7 9
295 8 9
296 DROP TABLE t1,t2,t3,t4,t5,t6;
297 CREATE TABLE t1 (c1 BIGINT NOT NULL);
298 CREATE TABLE t2 (c1 BIGINT NOT NULL);
299 CREATE TABLE t3 (c1 BIGINT NOT NULL);
300 CREATE TABLE t4 (c1 BIGINT NOT NULL);
301 CREATE TABLE t5 (c1 BIGINT NOT NULL);
302 CREATE TABLE t6 (c1 BIGINT NOT NULL);
303 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
304 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
305 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
306 INSERT INTO t4 (c1) VALUES(10);
307 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
308 SELECT t1.c1,t2.c1 FROM t1,t2 WHERE t1.c1 < t2.c1;
309 c1 c1
310 0 1
311 0 2
312 1 2
313 0 3
314 1 3
315 2 3
316 0 4
317 1 4
318 2 4
319 3 4
320 0 5
321 1 5
322 2 5
323 3 5
324 4 5
325 0 6
326 1 6
327 2 6
328 3 6
329 4 6
330 5 6
331 0 7
332 1 7
333 2 7
334 3 7
335 4 7
336 5 7
337 6 7
338 0 8
339 1 8
340 2 8
341 3 8
342 4 8
343 5 8
344 6 8
345 7 8
346 0 9
347 1 9
348 2 9
349 3 9
350 4 9
351 5 9
352 6 9
353 7 9
354 8 9
355 DROP TABLE t1,t2,t3,t4,t5,t6;
356 CREATE TABLE t1 (c1 TINYINT NOT NULL);
357 CREATE TABLE t2 (c1 TINYINT NOT NULL);
358 CREATE TABLE t3 (c1 TINYINT NOT NULL);
359 CREATE TABLE t4 (c1 TINYINT NOT NULL);
360 CREATE TABLE t5 (c1 TINYINT NOT NULL);
361 CREATE TABLE t6 (c1 TINYINT NOT NULL);
362 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
363 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
364 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
365 INSERT INTO t4 (c1) VALUES(10);
366 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
367 SELECT t1.c1,t3.c1 FROM t1,t3 WHERE t1.c1 < t3.c1;
368 c1 c1
369 0 1
370 0 3
371 0 5
372 0 7
373 0 9
374 1 3
375 1 5
376 1 7
377 1 9
378 2 3
379 2 5
380 2 7
381 2 9
382 3 5
383 3 7
384 3 9
385 4 5
386 4 7
387 4 9
388 5 7
389 5 9
390 6 7
391 6 9
392 7 9
393 8 9
394 DROP TABLE t1,t2,t3,t4,t5,t6;
395 CREATE TABLE t1 (c1 SMALLINT NOT NULL);
396 CREATE TABLE t2 (c1 SMALLINT NOT NULL);
397 CREATE TABLE t3 (c1 SMALLINT NOT NULL);
398 CREATE TABLE t4 (c1 SMALLINT NOT NULL);
399 CREATE TABLE t5 (c1 SMALLINT NOT NULL);
400 CREATE TABLE t6 (c1 SMALLINT NOT NULL);
401 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
402 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
403 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
404 INSERT INTO t4 (c1) VALUES(10);
405 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
406 SELECT t1.c1,t3.c1 FROM t1,t3 WHERE t1.c1 < t3.c1;
407 c1 c1
408 0 1
409 0 3
410 0 5
411 0 7
412 0 9
413 1 3
414 1 5
415 1 7
416 1 9
417 2 3
418 2 5
419 2 7
420 2 9
421 3 5
422 3 7
423 3 9
424 4 5
425 4 7
426 4 9
427 5 7
428 5 9
429 6 7
430 6 9
431 7 9
432 8 9
433 DROP TABLE t1,t2,t3,t4,t5,t6;
434 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
435 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
436 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
437 CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
438 CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
439 CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
440 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
441 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
442 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
443 INSERT INTO t4 (c1) VALUES(10);
444 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
445 SELECT t1.c1,t3.c1 FROM t1,t3 WHERE t1.c1 < t3.c1;
446 c1 c1
447 0 1
448 0 3
449 0 5
450 0 7
451 0 9
452 1 3
453 1 5
454 1 7
455 1 9
456 2 3
457 2 5
458 2 7
459 2 9
460 3 5
461 3 7
462 3 9
463 4 5
464 4 7
465 4 9
466 5 7
467 5 9
468 6 7
469 6 9
470 7 9
471 8 9
472 DROP TABLE t1,t2,t3,t4,t5,t6;
473 CREATE TABLE t1 (c1 INT NOT NULL);
474 CREATE TABLE t2 (c1 INT NOT NULL);
475 CREATE TABLE t3 (c1 INT NOT NULL);
476 CREATE TABLE t4 (c1 INT NOT NULL);
477 CREATE TABLE t5 (c1 INT NOT NULL);
478 CREATE TABLE t6 (c1 INT NOT NULL);
479 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
480 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
481 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
482 INSERT INTO t4 (c1) VALUES(10);
483 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
484 SELECT t1.c1,t3.c1 FROM t1,t3 WHERE t1.c1 < t3.c1;
485 c1 c1
486 0 1
487 0 3
488 0 5
489 0 7
490 0 9
491 1 3
492 1 5
493 1 7
494 1 9
495 2 3
496 2 5
497 2 7
498 2 9
499 3 5
500 3 7
501 3 9
502 4 5
503 4 7
504 4 9
505 5 7
506 5 9
507 6 7
508 6 9
509 7 9
510 8 9
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,t3.c1 FROM t1,t3 WHERE t1.c1 < t3.c1;
524 c1 c1
525 0 1
526 0 3
527 0 5
528 0 7
529 0 9
530 1 3
531 1 5
532 1 7
533 1 9
534 2 3
535 2 5
536 2 7
537 2 9
538 3 5
539 3 7
540 3 9
541 4 5
542 4 7
543 4 9
544 5 7
545 5 9
546 6 7
547 6 9
548 7 9
549 8 9
550 DROP TABLE t1,t2,t3,t4,t5,t6;
551 CREATE TABLE t1 (c1 BIGINT NOT NULL);
552 CREATE TABLE t2 (c1 BIGINT NOT NULL);
553 CREATE TABLE t3 (c1 BIGINT NOT NULL);
554 CREATE TABLE t4 (c1 BIGINT NOT NULL);
555 CREATE TABLE t5 (c1 BIGINT NOT NULL);
556 CREATE TABLE t6 (c1 BIGINT NOT NULL);
557 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
558 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
559 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
560 INSERT INTO t4 (c1) VALUES(10);
561 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
562 SELECT t1.c1,t3.c1 FROM t1,t3 WHERE t1.c1 < t3.c1;
563 c1 c1
564 0 1
565 0 3
566 0 5
567 0 7
568 0 9
569 1 3
570 1 5
571 1 7
572 1 9
573 2 3
574 2 5
575 2 7
576 2 9
577 3 5
578 3 7
579 3 9
580 4 5
581 4 7
582 4 9
583 5 7
584 5 9
585 6 7
586 6 9
587 7 9
588 8 9
589 DROP TABLE t1,t2,t3,t4,t5,t6;
590 CREATE TABLE t1 (c1 TINYINT NOT NULL);
591 CREATE TABLE t2 (c1 TINYINT NOT NULL);
592 CREATE TABLE t3 (c1 TINYINT NOT NULL);
593 CREATE TABLE t4 (c1 TINYINT NOT NULL);
594 CREATE TABLE t5 (c1 TINYINT NOT NULL);
595 CREATE TABLE t6 (c1 TINYINT NOT NULL);
596 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
597 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
598 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
599 INSERT INTO t4 (c1) VALUES(10);
600 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
601 SELECT t1.c1,t4.c1 FROM t1,t4 WHERE t1.c1 < t4.c1;
602 c1 c1
603 0 10
604 1 10
605 2 10
606 3 10
607 4 10
608 5 10
609 6 10
610 7 10
611 8 10
612 9 10
613 DROP TABLE t1,t2,t3,t4,t5,t6;
614 CREATE TABLE t1 (c1 SMALLINT NOT NULL);
615 CREATE TABLE t2 (c1 SMALLINT NOT NULL);
616 CREATE TABLE t3 (c1 SMALLINT NOT NULL);
617 CREATE TABLE t4 (c1 SMALLINT NOT NULL);
618 CREATE TABLE t5 (c1 SMALLINT NOT NULL);
619 CREATE TABLE t6 (c1 SMALLINT NOT NULL);
620 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
621 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
622 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
623 INSERT INTO t4 (c1) VALUES(10);
624 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
625 SELECT t1.c1,t4.c1 FROM t1,t4 WHERE t1.c1 < t4.c1;
626 c1 c1
627 0 10
628 1 10
629 2 10
630 3 10
631 4 10
632 5 10
633 6 10
634 7 10
635 8 10
636 9 10
637 DROP TABLE t1,t2,t3,t4,t5,t6;
638 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
639 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
640 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
641 CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
642 CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
643 CREATE TABLE t6 (c1 MEDIUMINT 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,t4.c1 FROM t1,t4 WHERE t1.c1 < t4.c1;
650 c1 c1
651 0 10
652 1 10
653 2 10
654 3 10
655 4 10
656 5 10
657 6 10
658 7 10
659 8 10
660 9 10
661 DROP TABLE t1,t2,t3,t4,t5,t6;
662 CREATE TABLE t1 (c1 INT NOT NULL);
663 CREATE TABLE t2 (c1 INT NOT NULL);
664 CREATE TABLE t3 (c1 INT NOT NULL);
665 CREATE TABLE t4 (c1 INT NOT NULL);
666 CREATE TABLE t5 (c1 INT NOT NULL);
667 CREATE TABLE t6 (c1 INT NOT NULL);
668 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
669 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
670 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
671 INSERT INTO t4 (c1) VALUES(10);
672 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
673 SELECT t1.c1,t4.c1 FROM t1,t4 WHERE t1.c1 < t4.c1;
674 c1 c1
675 0 10
676 1 10
677 2 10
678 3 10
679 4 10
680 5 10
681 6 10
682 7 10
683 8 10
684 9 10
685 DROP TABLE t1,t2,t3,t4,t5,t6;
686 CREATE TABLE t1 (c1 INTEGER NOT NULL);
687 CREATE TABLE t2 (c1 INTEGER NOT NULL);
688 CREATE TABLE t3 (c1 INTEGER NOT NULL);
689 CREATE TABLE t4 (c1 INTEGER NOT NULL);
690 CREATE TABLE t5 (c1 INTEGER NOT NULL);
691 CREATE TABLE t6 (c1 INTEGER NOT NULL);
692 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
693 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
694 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
695 INSERT INTO t4 (c1) VALUES(10);
696 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
697 SELECT t1.c1,t4.c1 FROM t1,t4 WHERE t1.c1 < t4.c1;
698 c1 c1
699 0 10
700 1 10
701 2 10
702 3 10
703 4 10
704 5 10
705 6 10
706 7 10
707 8 10
708 9 10
709 DROP TABLE t1,t2,t3,t4,t5,t6;
710 CREATE TABLE t1 (c1 BIGINT NOT NULL);
711 CREATE TABLE t2 (c1 BIGINT NOT NULL);
712 CREATE TABLE t3 (c1 BIGINT NOT NULL);
713 CREATE TABLE t4 (c1 BIGINT NOT NULL);
714 CREATE TABLE t5 (c1 BIGINT NOT NULL);
715 CREATE TABLE t6 (c1 BIGINT 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,t4.c1 FROM t1,t4 WHERE t1.c1 < t4.c1;
722 c1 c1
723 0 10
724 1 10
725 2 10
726 3 10
727 4 10
728 5 10
729 6 10
730 7 10
731 8 10
732 9 10
733 DROP TABLE t1,t2,t3,t4,t5,t6;
734 CREATE TABLE t1 (c1 TINYINT NOT NULL);
735 CREATE TABLE t2 (c1 TINYINT NOT NULL);
736 CREATE TABLE t3 (c1 TINYINT NOT NULL);
737 CREATE TABLE t4 (c1 TINYINT NOT NULL);
738 CREATE TABLE t5 (c1 TINYINT NOT NULL);
739 CREATE TABLE t6 (c1 TINYINT NOT NULL);
740 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
741 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
742 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
743 INSERT INTO t4 (c1) VALUES(10);
744 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
745 SELECT t1.c1,t5.c1 FROM t1,t5 WHERE t1.c1 < t5.c1;
746 c1 c1
747 0 10
748 0 11
749 0 12
750 0 13
751 0 14
752 1 10
753 1 11
754 1 12
755 1 13
756 1 14
757 2 10
758 2 11
759 2 12
760 2 13
761 2 14
762 3 10
763 3 11
764 3 12
765 3 13
766 3 14
767 4 10
768 4 11
769 4 12
770 4 13
771 4 14
772 5 10
773 5 11
774 5 12
775 5 13
776 5 14
777 6 10
778 6 11
779 6 12
780 6 13
781 6 14
782 7 10
783 7 11
784 7 12
785 7 13
786 7 14
787 8 10
788 8 11
789 8 12
790 8 13
791 8 14
792 9 10
793 9 11
794 9 12
795 9 13
796 9 14
797 DROP TABLE t1,t2,t3,t4,t5,t6;
798 CREATE TABLE t1 (c1 SMALLINT NOT NULL);
799 CREATE TABLE t2 (c1 SMALLINT NOT NULL);
800 CREATE TABLE t3 (c1 SMALLINT NOT NULL);
801 CREATE TABLE t4 (c1 SMALLINT NOT NULL);
802 CREATE TABLE t5 (c1 SMALLINT NOT NULL);
803 CREATE TABLE t6 (c1 SMALLINT NOT NULL);
804 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
805 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
806 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
807 INSERT INTO t4 (c1) VALUES(10);
808 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
809 SELECT t1.c1,t5.c1 FROM t1,t5 WHERE t1.c1 < t5.c1;
810 c1 c1
811 0 10
812 0 11
813 0 12
814 0 13
815 0 14
816 1 10
817 1 11
818 1 12
819 1 13
820 1 14
821 2 10
822 2 11
823 2 12
824 2 13
825 2 14
826 3 10
827 3 11
828 3 12
829 3 13
830 3 14
831 4 10
832 4 11
833 4 12
834 4 13
835 4 14
836 5 10
837 5 11
838 5 12
839 5 13
840 5 14
841 6 10
842 6 11
843 6 12
844 6 13
845 6 14
846 7 10
847 7 11
848 7 12
849 7 13
850 7 14
851 8 10
852 8 11
853 8 12
854 8 13
855 8 14
856 9 10
857 9 11
858 9 12
859 9 13
860 9 14
861 DROP TABLE t1,t2,t3,t4,t5,t6;
862 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
863 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
864 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
865 CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
866 CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
867 CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
868 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
869 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
870 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
871 INSERT INTO t4 (c1) VALUES(10);
872 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
873 SELECT t1.c1,t5.c1 FROM t1,t5 WHERE t1.c1 < t5.c1;
874 c1 c1
875 0 10
876 0 11
877 0 12
878 0 13
879 0 14
880 1 10
881 1 11
882 1 12
883 1 13
884 1 14
885 2 10
886 2 11
887 2 12
888 2 13
889 2 14
890 3 10
891 3 11
892 3 12
893 3 13
894 3 14
895 4 10
896 4 11
897 4 12
898 4 13
899 4 14
900 5 10
901 5 11
902 5 12
903 5 13
904 5 14
905 6 10
906 6 11
907 6 12
908 6 13
909 6 14
910 7 10
911 7 11
912 7 12
913 7 13
914 7 14
915 8 10
916 8 11
917 8 12
918 8 13
919 8 14
920 9 10
921 9 11
922 9 12
923 9 13
924 9 14
925 DROP TABLE t1,t2,t3,t4,t5,t6;
926 CREATE TABLE t1 (c1 INT NOT NULL);
927 CREATE TABLE t2 (c1 INT NOT NULL);
928 CREATE TABLE t3 (c1 INT NOT NULL);
929 CREATE TABLE t4 (c1 INT NOT NULL);
930 CREATE TABLE t5 (c1 INT NOT NULL);
931 CREATE TABLE t6 (c1 INT NOT NULL);
932 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
933 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
934 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
935 INSERT INTO t4 (c1) VALUES(10);
936 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
937 SELECT t1.c1,t5.c1 FROM t1,t5 WHERE t1.c1 < t5.c1;
938 c1 c1
939 0 10
940 0 11
941 0 12
942 0 13
943 0 14
944 1 10
945 1 11
946 1 12
947 1 13
948 1 14
949 2 10
950 2 11
951 2 12
952 2 13
953 2 14
954 3 10
955 3 11
956 3 12
957 3 13
958 3 14
959 4 10
960 4 11
961 4 12
962 4 13
963 4 14
964 5 10
965 5 11
966 5 12
967 5 13
968 5 14
969 6 10
970 6 11
971 6 12
972 6 13
973 6 14
974 7 10
975 7 11
976 7 12
977 7 13
978 7 14
979 8 10
980 8 11
981 8 12
982 8 13
983 8 14
984 9 10
985 9 11
986 9 12
987 9 13
988 9 14
989 DROP TABLE t1,t2,t3,t4,t5,t6;
990 CREATE TABLE t1 (c1 INTEGER NOT NULL);
991 CREATE TABLE t2 (c1 INTEGER NOT NULL);
992 CREATE TABLE t3 (c1 INTEGER NOT NULL);
993 CREATE TABLE t4 (c1 INTEGER NOT NULL);
994 CREATE TABLE t5 (c1 INTEGER NOT NULL);
995 CREATE TABLE t6 (c1 INTEGER NOT NULL);
996 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
997 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
998 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
999 INSERT INTO t4 (c1) VALUES(10);
1000 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1001 SELECT t1.c1,t5.c1 FROM t1,t5 WHERE t1.c1 < t5.c1;
1002 c1 c1
1003 0 10
1004 0 11
1005 0 12
1006 0 13
1007 0 14
1008 1 10
1009 1 11
1010 1 12
1011 1 13
1012 1 14
1013 2 10
1014 2 11
1015 2 12
1016 2 13
1017 2 14
1018 3 10
1019 3 11
1020 3 12
1021 3 13
1022 3 14
1023 4 10
1024 4 11
1025 4 12
1026 4 13
1027 4 14
1028 5 10
1029 5 11
1030 5 12
1031 5 13
1032 5 14
1033 6 10
1034 6 11
1035 6 12
1036 6 13
1037 6 14
1038 7 10
1039 7 11
1040 7 12
1041 7 13
1042 7 14
1043 8 10
1044 8 11
1045 8 12
1046 8 13
1047 8 14
1048 9 10
1049 9 11
1050 9 12
1051 9 13
1052 9 14
1053 DROP TABLE t1,t2,t3,t4,t5,t6;
1054 CREATE TABLE t1 (c1 BIGINT NOT NULL);
1055 CREATE TABLE t2 (c1 BIGINT NOT NULL);
1056 CREATE TABLE t3 (c1 BIGINT NOT NULL);
1057 CREATE TABLE t4 (c1 BIGINT NOT NULL);
1058 CREATE TABLE t5 (c1 BIGINT NOT NULL);
1059 CREATE TABLE t6 (c1 BIGINT NOT NULL);
1060 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1061 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1062 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1063 INSERT INTO t4 (c1) VALUES(10);
1064 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1065 SELECT t1.c1,t5.c1 FROM t1,t5 WHERE t1.c1 < t5.c1;
1066 c1 c1
1067 0 10
1068 0 11
1069 0 12
1070 0 13
1071 0 14
1072 1 10
1073 1 11
1074 1 12
1075 1 13
1076 1 14
1077 2 10
1078 2 11
1079 2 12
1080 2 13
1081 2 14
1082 3 10
1083 3 11
1084 3 12
1085 3 13
1086 3 14
1087 4 10
1088 4 11
1089 4 12
1090 4 13
1091 4 14
1092 5 10
1093 5 11
1094 5 12
1095 5 13
1096 5 14
1097 6 10
1098 6 11
1099 6 12
1100 6 13
1101 6 14
1102 7 10
1103 7 11
1104 7 12
1105 7 13
1106 7 14
1107 8 10
1108 8 11
1109 8 12
1110 8 13
1111 8 14
1112 9 10
1113 9 11
1114 9 12
1115 9 13
1116 9 14
1117 DROP TABLE t1,t2,t3,t4,t5,t6;
1118 CREATE TABLE t1 (c1 TINYINT NOT NULL);
1119 CREATE TABLE t2 (c1 TINYINT NOT NULL);
1120 CREATE TABLE t3 (c1 TINYINT NOT NULL);
1121 CREATE TABLE t4 (c1 TINYINT NOT NULL);
1122 CREATE TABLE t5 (c1 TINYINT NOT NULL);
1123 CREATE TABLE t6 (c1 TINYINT NOT NULL);
1124 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1125 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1126 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1127 INSERT INTO t4 (c1) VALUES(10);
1128 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1129 SELECT t1.c1,t6.c1 FROM t1,t6 WHERE t1.c1 < t6.c1;
1130 c1 c1
1131 DROP TABLE t1,t2,t3,t4,t5,t6;
1132 CREATE TABLE t1 (c1 SMALLINT NOT NULL);
1133 CREATE TABLE t2 (c1 SMALLINT NOT NULL);
1134 CREATE TABLE t3 (c1 SMALLINT NOT NULL);
1135 CREATE TABLE t4 (c1 SMALLINT NOT NULL);
1136 CREATE TABLE t5 (c1 SMALLINT NOT NULL);
1137 CREATE TABLE t6 (c1 SMALLINT NOT NULL);
1138 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1139 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1140 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1141 INSERT INTO t4 (c1) VALUES(10);
1142 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1143 SELECT t1.c1,t6.c1 FROM t1,t6 WHERE t1.c1 < t6.c1;
1144 c1 c1
1145 DROP TABLE t1,t2,t3,t4,t5,t6;
1146 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
1147 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
1148 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
1149 CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
1150 CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
1151 CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
1152 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1153 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1154 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1155 INSERT INTO t4 (c1) VALUES(10);
1156 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1157 SELECT t1.c1,t6.c1 FROM t1,t6 WHERE t1.c1 < t6.c1;
1158 c1 c1
1159 DROP TABLE t1,t2,t3,t4,t5,t6;
1160 CREATE TABLE t1 (c1 INT NOT NULL);
1161 CREATE TABLE t2 (c1 INT NOT NULL);
1162 CREATE TABLE t3 (c1 INT NOT NULL);
1163 CREATE TABLE t4 (c1 INT NOT NULL);
1164 CREATE TABLE t5 (c1 INT NOT NULL);
1165 CREATE TABLE t6 (c1 INT NOT NULL);
1166 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1167 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1168 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1169 INSERT INTO t4 (c1) VALUES(10);
1170 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1171 SELECT t1.c1,t6.c1 FROM t1,t6 WHERE t1.c1 < t6.c1;
1172 c1 c1
1173 DROP TABLE t1,t2,t3,t4,t5,t6;
1174 CREATE TABLE t1 (c1 INTEGER NOT NULL);
1175 CREATE TABLE t2 (c1 INTEGER NOT NULL);
1176 CREATE TABLE t3 (c1 INTEGER NOT NULL);
1177 CREATE TABLE t4 (c1 INTEGER NOT NULL);
1178 CREATE TABLE t5 (c1 INTEGER NOT NULL);
1179 CREATE TABLE t6 (c1 INTEGER NOT NULL);
1180 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1181 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1182 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1183 INSERT INTO t4 (c1) VALUES(10);
1184 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1185 SELECT t1.c1,t6.c1 FROM t1,t6 WHERE t1.c1 < t6.c1;
1186 c1 c1
1187 DROP TABLE t1,t2,t3,t4,t5,t6;
1188 CREATE TABLE t1 (c1 BIGINT NOT NULL);
1189 CREATE TABLE t2 (c1 BIGINT NOT NULL);
1190 CREATE TABLE t3 (c1 BIGINT NOT NULL);
1191 CREATE TABLE t4 (c1 BIGINT NOT NULL);
1192 CREATE TABLE t5 (c1 BIGINT NOT NULL);
1193 CREATE TABLE t6 (c1 BIGINT NOT NULL);
1194 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1195 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1196 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1197 INSERT INTO t4 (c1) VALUES(10);
1198 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1199 SELECT t1.c1,t6.c1 FROM t1,t6 WHERE t1.c1 < t6.c1;
1200 c1 c1
1201 DROP TABLE t1,t2,t3,t4,t5,t6;
1202 CREATE TABLE t1 (c1 TINYINT NOT NULL);
1203 CREATE TABLE t2 (c1 TINYINT NOT NULL);
1204 CREATE TABLE t3 (c1 TINYINT NOT NULL);
1205 CREATE TABLE t4 (c1 TINYINT NOT NULL);
1206 CREATE TABLE t5 (c1 TINYINT NOT NULL);
1207 CREATE TABLE t6 (c1 TINYINT NOT NULL);
1208 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1209 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1210 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1211 INSERT INTO t4 (c1) VALUES(10);
1212 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1213 SELECT t1.c1,t2.c1 FROM t1,t2 WHERE t1.c1 <= t2.c1;
1214 c1 c1
1215 0 0
1216 0 1
1217 1 1
1218 0 2
1219 1 2
1220 2 2
1221 0 3
1222 1 3
1223 2 3
1224 3 3
1225 0 4
1226 1 4
1227 2 4
1228 3 4
1229 4 4
1230 0 5
1231 1 5
1232 2 5
1233 3 5
1234 4 5
1235 5 5
1236 0 6
1237 1 6
1238 2 6
1239 3 6
1240 4 6
1241 5 6
1242 6 6
1243 0 7
1244 1 7
1245 2 7
1246 3 7
1247 4 7
1248 5 7
1249 6 7
1250 7 7
1251 0 8
1252 1 8
1253 2 8
1254 3 8
1255 4 8
1256 5 8
1257 6 8
1258 7 8
1259 8 8
1260 0 9
1261 1 9
1262 2 9
1263 3 9
1264 4 9
1265 5 9
1266 6 9
1267 7 9
1268 8 9
1269 9 9
1270 DROP TABLE t1,t2,t3,t4,t5,t6;
1271 CREATE TABLE t1 (c1 SMALLINT NOT NULL);
1272 CREATE TABLE t2 (c1 SMALLINT NOT NULL);
1273 CREATE TABLE t3 (c1 SMALLINT NOT NULL);
1274 CREATE TABLE t4 (c1 SMALLINT NOT NULL);
1275 CREATE TABLE t5 (c1 SMALLINT NOT NULL);
1276 CREATE TABLE t6 (c1 SMALLINT NOT NULL);
1277 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1278 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1279 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1280 INSERT INTO t4 (c1) VALUES(10);
1281 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1282 SELECT t1.c1,t2.c1 FROM t1,t2 WHERE t1.c1 <= t2.c1;
1283 c1 c1
1284 0 0
1285 0 1
1286 1 1
1287 0 2
1288 1 2
1289 2 2
1290 0 3
1291 1 3
1292 2 3
1293 3 3
1294 0 4
1295 1 4
1296 2 4
1297 3 4
1298 4 4
1299 0 5
1300 1 5
1301 2 5
1302 3 5
1303 4 5
1304 5 5
1305 0 6
1306 1 6
1307 2 6
1308 3 6
1309 4 6
1310 5 6
1311 6 6
1312 0 7
1313 1 7
1314 2 7
1315 3 7
1316 4 7
1317 5 7
1318 6 7
1319 7 7
1320 0 8
1321 1 8
1322 2 8
1323 3 8
1324 4 8
1325 5 8
1326 6 8
1327 7 8
1328 8 8
1329 0 9
1330 1 9
1331 2 9
1332 3 9
1333 4 9
1334 5 9
1335 6 9
1336 7 9
1337 8 9
1338 9 9
1339 DROP TABLE t1,t2,t3,t4,t5,t6;
1340 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
1341 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
1342 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
1343 CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
1344 CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
1345 CREATE TABLE t6 (c1 MEDIUMINT 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,t2.c1 FROM t1,t2 WHERE t1.c1 <= t2.c1;
1352 c1 c1
1353 0 0
1354 0 1
1355 1 1
1356 0 2
1357 1 2
1358 2 2
1359 0 3
1360 1 3
1361 2 3
1362 3 3
1363 0 4
1364 1 4
1365 2 4
1366 3 4
1367 4 4
1368 0 5
1369 1 5
1370 2 5
1371 3 5
1372 4 5
1373 5 5
1374 0 6
1375 1 6
1376 2 6
1377 3 6
1378 4 6
1379 5 6
1380 6 6
1381 0 7
1382 1 7
1383 2 7
1384 3 7
1385 4 7
1386 5 7
1387 6 7
1388 7 7
1389 0 8
1390 1 8
1391 2 8
1392 3 8
1393 4 8
1394 5 8
1395 6 8
1396 7 8
1397 8 8
1398 0 9
1399 1 9
1400 2 9
1401 3 9
1402 4 9
1403 5 9
1404 6 9
1405 7 9
1406 8 9
1407 9 9
1408 DROP TABLE t1,t2,t3,t4,t5,t6;
1409 CREATE TABLE t1 (c1 INT NOT NULL);
1410 CREATE TABLE t2 (c1 INT NOT NULL);
1411 CREATE TABLE t3 (c1 INT NOT NULL);
1412 CREATE TABLE t4 (c1 INT NOT NULL);
1413 CREATE TABLE t5 (c1 INT NOT NULL);
1414 CREATE TABLE t6 (c1 INT NOT NULL);
1415 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1416 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1417 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1418 INSERT INTO t4 (c1) VALUES(10);
1419 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1420 SELECT t1.c1,t2.c1 FROM t1,t2 WHERE t1.c1 <= t2.c1;
1421 c1 c1
1422 0 0
1423 0 1
1424 1 1
1425 0 2
1426 1 2
1427 2 2
1428 0 3
1429 1 3
1430 2 3
1431 3 3
1432 0 4
1433 1 4
1434 2 4
1435 3 4
1436 4 4
1437 0 5
1438 1 5
1439 2 5
1440 3 5
1441 4 5
1442 5 5
1443 0 6
1444 1 6
1445 2 6
1446 3 6
1447 4 6
1448 5 6
1449 6 6
1450 0 7
1451 1 7
1452 2 7
1453 3 7
1454 4 7
1455 5 7
1456 6 7
1457 7 7
1458 0 8
1459 1 8
1460 2 8
1461 3 8
1462 4 8
1463 5 8
1464 6 8
1465 7 8
1466 8 8
1467 0 9
1468 1 9
1469 2 9
1470 3 9
1471 4 9
1472 5 9
1473 6 9
1474 7 9
1475 8 9
1476 9 9
1477 DROP TABLE t1,t2,t3,t4,t5,t6;
1478 CREATE TABLE t1 (c1 INTEGER NOT NULL);
1479 CREATE TABLE t2 (c1 INTEGER NOT NULL);
1480 CREATE TABLE t3 (c1 INTEGER NOT NULL);
1481 CREATE TABLE t4 (c1 INTEGER NOT NULL);
1482 CREATE TABLE t5 (c1 INTEGER NOT NULL);
1483 CREATE TABLE t6 (c1 INTEGER NOT NULL);
1484 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1485 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1486 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1487 INSERT INTO t4 (c1) VALUES(10);
1488 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1489 SELECT t1.c1,t2.c1 FROM t1,t2 WHERE t1.c1 <= t2.c1;
1490 c1 c1
1491 0 0
1492 0 1
1493 1 1
1494 0 2
1495 1 2
1496 2 2
1497 0 3
1498 1 3
1499 2 3
1500 3 3
1501 0 4
1502 1 4
1503 2 4
1504 3 4
1505 4 4
1506 0 5
1507 1 5
1508 2 5
1509 3 5
1510 4 5
1511 5 5
1512 0 6
1513 1 6
1514 2 6
1515 3 6
1516 4 6
1517 5 6
1518 6 6
1519 0 7
1520 1 7
1521 2 7
1522 3 7
1523 4 7
1524 5 7
1525 6 7
1526 7 7
1527 0 8
1528 1 8
1529 2 8
1530 3 8
1531 4 8
1532 5 8
1533 6 8
1534 7 8
1535 8 8
1536 0 9
1537 1 9
1538 2 9
1539 3 9
1540 4 9
1541 5 9
1542 6 9
1543 7 9
1544 8 9
1545 9 9
1546 DROP TABLE t1,t2,t3,t4,t5,t6;
1547 CREATE TABLE t1 (c1 BIGINT NOT NULL);
1548 CREATE TABLE t2 (c1 BIGINT NOT NULL);
1549 CREATE TABLE t3 (c1 BIGINT NOT NULL);
1550 CREATE TABLE t4 (c1 BIGINT NOT NULL);
1551 CREATE TABLE t5 (c1 BIGINT NOT NULL);
1552 CREATE TABLE t6 (c1 BIGINT NOT NULL);
1553 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1554 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1555 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1556 INSERT INTO t4 (c1) VALUES(10);
1557 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1558 SELECT t1.c1,t2.c1 FROM t1,t2 WHERE t1.c1 <= t2.c1;
1559 c1 c1
1560 0 0
1561 0 1
1562 1 1
1563 0 2
1564 1 2
1565 2 2
1566 0 3
1567 1 3
1568 2 3
1569 3 3
1570 0 4
1571 1 4
1572 2 4
1573 3 4
1574 4 4
1575 0 5
1576 1 5
1577 2 5
1578 3 5
1579 4 5
1580 5 5
1581 0 6
1582 1 6
1583 2 6
1584 3 6
1585 4 6
1586 5 6
1587 6 6
1588 0 7
1589 1 7
1590 2 7
1591 3 7
1592 4 7
1593 5 7
1594 6 7
1595 7 7
1596 0 8
1597 1 8
1598 2 8
1599 3 8
1600 4 8
1601 5 8
1602 6 8
1603 7 8
1604 8 8
1605 0 9
1606 1 9
1607 2 9
1608 3 9
1609 4 9
1610 5 9
1611 6 9
1612 7 9
1613 8 9
1614 9 9
1615 DROP TABLE t1,t2,t3,t4,t5,t6;
1616 CREATE TABLE t1 (c1 TINYINT NOT NULL);
1617 CREATE TABLE t2 (c1 TINYINT NOT NULL);
1618 CREATE TABLE t3 (c1 TINYINT NOT NULL);
1619 CREATE TABLE t4 (c1 TINYINT NOT NULL);
1620 CREATE TABLE t5 (c1 TINYINT NOT NULL);
1621 CREATE TABLE t6 (c1 TINYINT 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,t3.c1 FROM t1,t3 WHERE t1.c1 <= t3.c1;
1628 c1 c1
1629 0 1
1630 0 3
1631 0 5
1632 0 7
1633 0 9
1634 1 1
1635 1 3
1636 1 5
1637 1 7
1638 1 9
1639 2 3
1640 2 5
1641 2 7
1642 2 9
1643 3 3
1644 3 5
1645 3 7
1646 3 9
1647 4 5
1648 4 7
1649 4 9
1650 5 5
1651 5 7
1652 5 9
1653 6 7
1654 6 9
1655 7 7
1656 7 9
1657 8 9
1658 9 9
1659 DROP TABLE t1,t2,t3,t4,t5,t6;
1660 CREATE TABLE t1 (c1 SMALLINT NOT NULL);
1661 CREATE TABLE t2 (c1 SMALLINT NOT NULL);
1662 CREATE TABLE t3 (c1 SMALLINT NOT NULL);
1663 CREATE TABLE t4 (c1 SMALLINT NOT NULL);
1664 CREATE TABLE t5 (c1 SMALLINT NOT NULL);
1665 CREATE TABLE t6 (c1 SMALLINT NOT NULL);
1666 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1667 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1668 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1669 INSERT INTO t4 (c1) VALUES(10);
1670 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1671 SELECT t1.c1,t3.c1 FROM t1,t3 WHERE t1.c1 <= t3.c1;
1672 c1 c1
1673 0 1
1674 0 3
1675 0 5
1676 0 7
1677 0 9
1678 1 1
1679 1 3
1680 1 5
1681 1 7
1682 1 9
1683 2 3
1684 2 5
1685 2 7
1686 2 9
1687 3 3
1688 3 5
1689 3 7
1690 3 9
1691 4 5
1692 4 7
1693 4 9
1694 5 5
1695 5 7
1696 5 9
1697 6 7
1698 6 9
1699 7 7
1700 7 9
1701 8 9
1702 9 9
1703 DROP TABLE t1,t2,t3,t4,t5,t6;
1704 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
1705 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
1706 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
1707 CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
1708 CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
1709 CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
1710 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1711 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1712 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1713 INSERT INTO t4 (c1) VALUES(10);
1714 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1715 SELECT t1.c1,t3.c1 FROM t1,t3 WHERE t1.c1 <= t3.c1;
1716 c1 c1
1717 0 1
1718 0 3
1719 0 5
1720 0 7
1721 0 9
1722 1 1
1723 1 3
1724 1 5
1725 1 7
1726 1 9
1727 2 3
1728 2 5
1729 2 7
1730 2 9
1731 3 3
1732 3 5
1733 3 7
1734 3 9
1735 4 5
1736 4 7
1737 4 9
1738 5 5
1739 5 7
1740 5 9
1741 6 7
1742 6 9
1743 7 7
1744 7 9
1745 8 9
1746 9 9
1747 DROP TABLE t1,t2,t3,t4,t5,t6;
1748 CREATE TABLE t1 (c1 INT NOT NULL);
1749 CREATE TABLE t2 (c1 INT NOT NULL);
1750 CREATE TABLE t3 (c1 INT NOT NULL);
1751 CREATE TABLE t4 (c1 INT NOT NULL);
1752 CREATE TABLE t5 (c1 INT NOT NULL);
1753 CREATE TABLE t6 (c1 INT NOT NULL);
1754 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1755 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1756 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1757 INSERT INTO t4 (c1) VALUES(10);
1758 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1759 SELECT t1.c1,t3.c1 FROM t1,t3 WHERE t1.c1 <= t3.c1;
1760 c1 c1
1761 0 1
1762 0 3
1763 0 5
1764 0 7
1765 0 9
1766 1 1
1767 1 3
1768 1 5
1769 1 7
1770 1 9
1771 2 3
1772 2 5
1773 2 7
1774 2 9
1775 3 3
1776 3 5
1777 3 7
1778 3 9
1779 4 5
1780 4 7
1781 4 9
1782 5 5
1783 5 7
1784 5 9
1785 6 7
1786 6 9
1787 7 7
1788 7 9
1789 8 9
1790 9 9
1791 DROP TABLE t1,t2,t3,t4,t5,t6;
1792 CREATE TABLE t1 (c1 INTEGER NOT NULL);
1793 CREATE TABLE t2 (c1 INTEGER NOT NULL);
1794 CREATE TABLE t3 (c1 INTEGER NOT NULL);
1795 CREATE TABLE t4 (c1 INTEGER NOT NULL);
1796 CREATE TABLE t5 (c1 INTEGER NOT NULL);
1797 CREATE TABLE t6 (c1 INTEGER NOT NULL);
1798 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1799 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1800 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1801 INSERT INTO t4 (c1) VALUES(10);
1802 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1803 SELECT t1.c1,t3.c1 FROM t1,t3 WHERE t1.c1 <= t3.c1;
1804 c1 c1
1805 0 1
1806 0 3
1807 0 5
1808 0 7
1809 0 9
1810 1 1
1811 1 3
1812 1 5
1813 1 7
1814 1 9
1815 2 3
1816 2 5
1817 2 7
1818 2 9
1819 3 3
1820 3 5
1821 3 7
1822 3 9
1823 4 5
1824 4 7
1825 4 9
1826 5 5
1827 5 7
1828 5 9
1829 6 7
1830 6 9
1831 7 7
1832 7 9
1833 8 9
1834 9 9
1835 DROP TABLE t1,t2,t3,t4,t5,t6;
1836 CREATE TABLE t1 (c1 BIGINT NOT NULL);
1837 CREATE TABLE t2 (c1 BIGINT NOT NULL);
1838 CREATE TABLE t3 (c1 BIGINT NOT NULL);
1839 CREATE TABLE t4 (c1 BIGINT NOT NULL);
1840 CREATE TABLE t5 (c1 BIGINT NOT NULL);
1841 CREATE TABLE t6 (c1 BIGINT NOT NULL);
1842 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1843 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1844 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1845 INSERT INTO t4 (c1) VALUES(10);
1846 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1847 SELECT t1.c1,t3.c1 FROM t1,t3 WHERE t1.c1 <= t3.c1;
1848 c1 c1
1849 0 1
1850 0 3
1851 0 5
1852 0 7
1853 0 9
1854 1 1
1855 1 3
1856 1 5
1857 1 7
1858 1 9
1859 2 3
1860 2 5
1861 2 7
1862 2 9
1863 3 3
1864 3 5
1865 3 7
1866 3 9
1867 4 5
1868 4 7
1869 4 9
1870 5 5
1871 5 7
1872 5 9
1873 6 7
1874 6 9
1875 7 7
1876 7 9
1877 8 9
1878 9 9
1879 DROP TABLE t1,t2,t3,t4,t5,t6;
1880 CREATE TABLE t1 (c1 TINYINT NOT NULL);
1881 CREATE TABLE t2 (c1 TINYINT NOT NULL);
1882 CREATE TABLE t3 (c1 TINYINT NOT NULL);
1883 CREATE TABLE t4 (c1 TINYINT NOT NULL);
1884 CREATE TABLE t5 (c1 TINYINT NOT NULL);
1885 CREATE TABLE t6 (c1 TINYINT NOT NULL);
1886 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1887 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1888 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1889 INSERT INTO t4 (c1) VALUES(10);
1890 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1891 SELECT t1.c1,t4.c1 FROM t1,t4 WHERE t1.c1 <= t4.c1;
1892 c1 c1
1893 0 10
1894 1 10
1895 2 10
1896 3 10
1897 4 10
1898 5 10
1899 6 10
1900 7 10
1901 8 10
1902 9 10
1903 DROP TABLE t1,t2,t3,t4,t5,t6;
1904 CREATE TABLE t1 (c1 SMALLINT NOT NULL);
1905 CREATE TABLE t2 (c1 SMALLINT NOT NULL);
1906 CREATE TABLE t3 (c1 SMALLINT NOT NULL);
1907 CREATE TABLE t4 (c1 SMALLINT NOT NULL);
1908 CREATE TABLE t5 (c1 SMALLINT NOT NULL);
1909 CREATE TABLE t6 (c1 SMALLINT NOT NULL);
1910 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1911 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1912 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1913 INSERT INTO t4 (c1) VALUES(10);
1914 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1915 SELECT t1.c1,t4.c1 FROM t1,t4 WHERE t1.c1 <= t4.c1;
1916 c1 c1
1917 0 10
1918 1 10
1919 2 10
1920 3 10
1921 4 10
1922 5 10
1923 6 10
1924 7 10
1925 8 10
1926 9 10
1927 DROP TABLE t1,t2,t3,t4,t5,t6;
1928 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
1929 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
1930 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
1931 CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
1932 CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
1933 CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
1934 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1935 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1936 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1937 INSERT INTO t4 (c1) VALUES(10);
1938 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1939 SELECT t1.c1,t4.c1 FROM t1,t4 WHERE t1.c1 <= t4.c1;
1940 c1 c1
1941 0 10
1942 1 10
1943 2 10
1944 3 10
1945 4 10
1946 5 10
1947 6 10
1948 7 10
1949 8 10
1950 9 10
1951 DROP TABLE t1,t2,t3,t4,t5,t6;
1952 CREATE TABLE t1 (c1 INT NOT NULL);
1953 CREATE TABLE t2 (c1 INT NOT NULL);
1954 CREATE TABLE t3 (c1 INT NOT NULL);
1955 CREATE TABLE t4 (c1 INT NOT NULL);
1956 CREATE TABLE t5 (c1 INT NOT NULL);
1957 CREATE TABLE t6 (c1 INT NOT NULL);
1958 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1959 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1960 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1961 INSERT INTO t4 (c1) VALUES(10);
1962 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1963 SELECT t1.c1,t4.c1 FROM t1,t4 WHERE t1.c1 <= t4.c1;
1964 c1 c1
1965 0 10
1966 1 10
1967 2 10
1968 3 10
1969 4 10
1970 5 10
1971 6 10
1972 7 10
1973 8 10
1974 9 10
1975 DROP TABLE t1,t2,t3,t4,t5,t6;
1976 CREATE TABLE t1 (c1 INTEGER NOT NULL);
1977 CREATE TABLE t2 (c1 INTEGER NOT NULL);
1978 CREATE TABLE t3 (c1 INTEGER NOT NULL);
1979 CREATE TABLE t4 (c1 INTEGER NOT NULL);
1980 CREATE TABLE t5 (c1 INTEGER NOT NULL);
1981 CREATE TABLE t6 (c1 INTEGER NOT NULL);
1982 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1983 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1984 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1985 INSERT INTO t4 (c1) VALUES(10);
1986 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1987 SELECT t1.c1,t4.c1 FROM t1,t4 WHERE t1.c1 <= t4.c1;
1988 c1 c1
1989 0 10
1990 1 10
1991 2 10
1992 3 10
1993 4 10
1994 5 10
1995 6 10
1996 7 10
1997 8 10
1998 9 10
1999 DROP TABLE t1,t2,t3,t4,t5,t6;
2000 CREATE TABLE t1 (c1 BIGINT NOT NULL);
2001 CREATE TABLE t2 (c1 BIGINT NOT NULL);
2002 CREATE TABLE t3 (c1 BIGINT NOT NULL);
2003 CREATE TABLE t4 (c1 BIGINT NOT NULL);
2004 CREATE TABLE t5 (c1 BIGINT NOT NULL);
2005 CREATE TABLE t6 (c1 BIGINT 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,t4 WHERE t1.c1 <= t4.c1;
2012 c1 c1
2013 0 10
2014 1 10
2015 2 10
2016 3 10
2017 4 10
2018 5 10
2019 6 10
2020 7 10
2021 8 10
2022 9 10
2023 DROP TABLE t1,t2,t3,t4,t5,t6;
2024 CREATE TABLE t1 (c1 TINYINT NOT NULL);
2025 CREATE TABLE t2 (c1 TINYINT NOT NULL);
2026 CREATE TABLE t3 (c1 TINYINT NOT NULL);
2027 CREATE TABLE t4 (c1 TINYINT NOT NULL);
2028 CREATE TABLE t5 (c1 TINYINT NOT NULL);
2029 CREATE TABLE t6 (c1 TINYINT NOT NULL);
2030 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2031 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2032 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2033 INSERT INTO t4 (c1) VALUES(10);
2034 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2035 SELECT t1.c1,t5.c1 FROM t1,t5 WHERE t1.c1 <= t5.c1;
2036 c1 c1
2037 0 10
2038 0 11
2039 0 12
2040 0 13
2041 0 14
2042 1 10
2043 1 11
2044 1 12
2045 1 13
2046 1 14
2047 2 10
2048 2 11
2049 2 12
2050 2 13
2051 2 14
2052 3 10
2053 3 11
2054 3 12
2055 3 13
2056 3 14
2057 4 10
2058 4 11
2059 4 12
2060 4 13
2061 4 14
2062 5 10
2063 5 11
2064 5 12
2065 5 13
2066 5 14
2067 6 10
2068 6 11
2069 6 12
2070 6 13
2071 6 14
2072 7 10
2073 7 11
2074 7 12
2075 7 13
2076 7 14
2077 8 10
2078 8 11
2079 8 12
2080 8 13
2081 8 14
2082 9 10
2083 9 11
2084 9 12
2085 9 13
2086 9 14
2087 DROP TABLE t1,t2,t3,t4,t5,t6;
2088 CREATE TABLE t1 (c1 SMALLINT NOT NULL);
2089 CREATE TABLE t2 (c1 SMALLINT NOT NULL);
2090 CREATE TABLE t3 (c1 SMALLINT NOT NULL);
2091 CREATE TABLE t4 (c1 SMALLINT NOT NULL);
2092 CREATE TABLE t5 (c1 SMALLINT NOT NULL);
2093 CREATE TABLE t6 (c1 SMALLINT NOT NULL);
2094 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2095 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2096 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2097 INSERT INTO t4 (c1) VALUES(10);
2098 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2099 SELECT t1.c1,t5.c1 FROM t1,t5 WHERE t1.c1 <= t5.c1;
2100 c1 c1
2101 0 10
2102 0 11
2103 0 12
2104 0 13
2105 0 14
2106 1 10
2107 1 11
2108 1 12
2109 1 13
2110 1 14
2111 2 10
2112 2 11
2113 2 12
2114 2 13
2115 2 14
2116 3 10
2117 3 11
2118 3 12
2119 3 13
2120 3 14
2121 4 10
2122 4 11
2123 4 12
2124 4 13
2125 4 14
2126 5 10
2127 5 11
2128 5 12
2129 5 13
2130 5 14
2131 6 10
2132 6 11
2133 6 12
2134 6 13
2135 6 14
2136 7 10
2137 7 11
2138 7 12
2139 7 13
2140 7 14
2141 8 10
2142 8 11
2143 8 12
2144 8 13
2145 8 14
2146 9 10
2147 9 11
2148 9 12
2149 9 13
2150 9 14
2151 DROP TABLE t1,t2,t3,t4,t5,t6;
2152 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
2153 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
2154 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
2155 CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
2156 CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
2157 CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
2158 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2159 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2160 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2161 INSERT INTO t4 (c1) VALUES(10);
2162 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2163 SELECT t1.c1,t5.c1 FROM t1,t5 WHERE t1.c1 <= t5.c1;
2164 c1 c1
2165 0 10
2166 0 11
2167 0 12
2168 0 13
2169 0 14
2170 1 10
2171 1 11
2172 1 12
2173 1 13
2174 1 14
2175 2 10
2176 2 11
2177 2 12
2178 2 13
2179 2 14
2180 3 10
2181 3 11
2182 3 12
2183 3 13
2184 3 14
2185 4 10
2186 4 11
2187 4 12
2188 4 13
2189 4 14
2190 5 10
2191 5 11
2192 5 12
2193 5 13
2194 5 14
2195 6 10
2196 6 11
2197 6 12
2198 6 13
2199 6 14
2200 7 10
2201 7 11
2202 7 12
2203 7 13
2204 7 14
2205 8 10
2206 8 11
2207 8 12
2208 8 13
2209 8 14
2210 9 10
2211 9 11
2212 9 12
2213 9 13
2214 9 14
2215 DROP TABLE t1,t2,t3,t4,t5,t6;
2216 CREATE TABLE t1 (c1 INT NOT NULL);
2217 CREATE TABLE t2 (c1 INT NOT NULL);
2218 CREATE TABLE t3 (c1 INT NOT NULL);
2219 CREATE TABLE t4 (c1 INT NOT NULL);
2220 CREATE TABLE t5 (c1 INT NOT NULL);
2221 CREATE TABLE t6 (c1 INT NOT NULL);
2222 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2223 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2224 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2225 INSERT INTO t4 (c1) VALUES(10);
2226 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2227 SELECT t1.c1,t5.c1 FROM t1,t5 WHERE t1.c1 <= t5.c1;
2228 c1 c1
2229 0 10
2230 0 11
2231 0 12
2232 0 13
2233 0 14
2234 1 10
2235 1 11
2236 1 12
2237 1 13
2238 1 14
2239 2 10
2240 2 11
2241 2 12
2242 2 13
2243 2 14
2244 3 10
2245 3 11
2246 3 12
2247 3 13
2248 3 14
2249 4 10
2250 4 11
2251 4 12
2252 4 13
2253 4 14
2254 5 10
2255 5 11
2256 5 12
2257 5 13
2258 5 14
2259 6 10
2260 6 11
2261 6 12
2262 6 13
2263 6 14
2264 7 10
2265 7 11
2266 7 12
2267 7 13
2268 7 14
2269 8 10
2270 8 11
2271 8 12
2272 8 13
2273 8 14
2274 9 10
2275 9 11
2276 9 12
2277 9 13
2278 9 14
2279 DROP TABLE t1,t2,t3,t4,t5,t6;
2280 CREATE TABLE t1 (c1 INTEGER NOT NULL);
2281 CREATE TABLE t2 (c1 INTEGER NOT NULL);
2282 CREATE TABLE t3 (c1 INTEGER NOT NULL);
2283 CREATE TABLE t4 (c1 INTEGER NOT NULL);
2284 CREATE TABLE t5 (c1 INTEGER NOT NULL);
2285 CREATE TABLE t6 (c1 INTEGER NOT NULL);
2286 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2287 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2288 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2289 INSERT INTO t4 (c1) VALUES(10);
2290 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2291 SELECT t1.c1,t5.c1 FROM t1,t5 WHERE t1.c1 <= t5.c1;
2292 c1 c1
2293 0 10
2294 0 11
2295 0 12
2296 0 13
2297 0 14
2298 1 10
2299 1 11
2300 1 12
2301 1 13
2302 1 14
2303 2 10
2304 2 11
2305 2 12
2306 2 13
2307 2 14
2308 3 10
2309 3 11
2310 3 12
2311 3 13
2312 3 14
2313 4 10
2314 4 11
2315 4 12
2316 4 13
2317 4 14
2318 5 10
2319 5 11
2320 5 12
2321 5 13
2322 5 14
2323 6 10
2324 6 11
2325 6 12
2326 6 13
2327 6 14
2328 7 10
2329 7 11
2330 7 12
2331 7 13
2332 7 14
2333 8 10
2334 8 11
2335 8 12
2336 8 13
2337 8 14
2338 9 10
2339 9 11
2340 9 12
2341 9 13
2342 9 14
2343 DROP TABLE t1,t2,t3,t4,t5,t6;
2344 CREATE TABLE t1 (c1 BIGINT NOT NULL);
2345 CREATE TABLE t2 (c1 BIGINT NOT NULL);
2346 CREATE TABLE t3 (c1 BIGINT NOT NULL);
2347 CREATE TABLE t4 (c1 BIGINT NOT NULL);
2348 CREATE TABLE t5 (c1 BIGINT NOT NULL);
2349 CREATE TABLE t6 (c1 BIGINT NOT NULL);
2350 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2351 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2352 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2353 INSERT INTO t4 (c1) VALUES(10);
2354 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2355 SELECT t1.c1,t5.c1 FROM t1,t5 WHERE t1.c1 <= t5.c1;
2356 c1 c1
2357 0 10
2358 0 11
2359 0 12
2360 0 13
2361 0 14
2362 1 10
2363 1 11
2364 1 12
2365 1 13
2366 1 14
2367 2 10
2368 2 11
2369 2 12
2370 2 13
2371 2 14
2372 3 10
2373 3 11
2374 3 12
2375 3 13
2376 3 14
2377 4 10
2378 4 11
2379 4 12
2380 4 13
2381 4 14
2382 5 10
2383 5 11
2384 5 12
2385 5 13
2386 5 14
2387 6 10
2388 6 11
2389 6 12
2390 6 13
2391 6 14
2392 7 10
2393 7 11
2394 7 12
2395 7 13
2396 7 14
2397 8 10
2398 8 11
2399 8 12
2400 8 13
2401 8 14
2402 9 10
2403 9 11
2404 9 12
2405 9 13
2406 9 14
2407 DROP TABLE t1,t2,t3,t4,t5,t6;
2408 CREATE TABLE t1 (c1 TINYINT NOT NULL);
2409 CREATE TABLE t2 (c1 TINYINT NOT NULL);
2410 CREATE TABLE t3 (c1 TINYINT NOT NULL);
2411 CREATE TABLE t4 (c1 TINYINT NOT NULL);
2412 CREATE TABLE t5 (c1 TINYINT NOT NULL);
2413 CREATE TABLE t6 (c1 TINYINT NOT NULL);
2414 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2415 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2416 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2417 INSERT INTO t4 (c1) VALUES(10);
2418 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2419 SELECT t1.c1,t6.c1 FROM t1,t6 WHERE t1.c1 <= t6.c1;
2420 c1 c1
2421 DROP TABLE t1,t2,t3,t4,t5,t6;
2422 CREATE TABLE t1 (c1 SMALLINT NOT NULL);
2423 CREATE TABLE t2 (c1 SMALLINT NOT NULL);
2424 CREATE TABLE t3 (c1 SMALLINT NOT NULL);
2425 CREATE TABLE t4 (c1 SMALLINT NOT NULL);
2426 CREATE TABLE t5 (c1 SMALLINT NOT NULL);
2427 CREATE TABLE t6 (c1 SMALLINT NOT NULL);
2428 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2429 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2430 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2431 INSERT INTO t4 (c1) VALUES(10);
2432 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2433 SELECT t1.c1,t6.c1 FROM t1,t6 WHERE t1.c1 <= t6.c1;
2434 c1 c1
2435 DROP TABLE t1,t2,t3,t4,t5,t6;
2436 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
2437 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
2438 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
2439 CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
2440 CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
2441 CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
2442 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2443 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2444 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2445 INSERT INTO t4 (c1) VALUES(10);
2446 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2447 SELECT t1.c1,t6.c1 FROM t1,t6 WHERE t1.c1 <= t6.c1;
2448 c1 c1
2449 DROP TABLE t1,t2,t3,t4,t5,t6;
2450 CREATE TABLE t1 (c1 INT NOT NULL);
2451 CREATE TABLE t2 (c1 INT NOT NULL);
2452 CREATE TABLE t3 (c1 INT NOT NULL);
2453 CREATE TABLE t4 (c1 INT NOT NULL);
2454 CREATE TABLE t5 (c1 INT NOT NULL);
2455 CREATE TABLE t6 (c1 INT NOT NULL);
2456 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2457 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2458 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2459 INSERT INTO t4 (c1) VALUES(10);
2460 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2461 SELECT t1.c1,t6.c1 FROM t1,t6 WHERE t1.c1 <= t6.c1;
2462 c1 c1
2463 DROP TABLE t1,t2,t3,t4,t5,t6;
2464 CREATE TABLE t1 (c1 INTEGER NOT NULL);
2465 CREATE TABLE t2 (c1 INTEGER NOT NULL);
2466 CREATE TABLE t3 (c1 INTEGER NOT NULL);
2467 CREATE TABLE t4 (c1 INTEGER NOT NULL);
2468 CREATE TABLE t5 (c1 INTEGER NOT NULL);
2469 CREATE TABLE t6 (c1 INTEGER NOT NULL);
2470 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2471 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2472 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2473 INSERT INTO t4 (c1) VALUES(10);
2474 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2475 SELECT t1.c1,t6.c1 FROM t1,t6 WHERE t1.c1 <= t6.c1;
2476 c1 c1
2477 DROP TABLE t1,t2,t3,t4,t5,t6;
2478 CREATE TABLE t1 (c1 BIGINT NOT NULL);
2479 CREATE TABLE t2 (c1 BIGINT NOT NULL);
2480 CREATE TABLE t3 (c1 BIGINT NOT NULL);
2481 CREATE TABLE t4 (c1 BIGINT NOT NULL);
2482 CREATE TABLE t5 (c1 BIGINT NOT NULL);
2483 CREATE TABLE t6 (c1 BIGINT NOT NULL);
2484 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2485 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2486 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2487 INSERT INTO t4 (c1) VALUES(10);
2488 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2489 SELECT t1.c1,t6.c1 FROM t1,t6 WHERE t1.c1 <= t6.c1;
2490 c1 c1
2491 DROP TABLE t1,t2,t3,t4,t5,t6;
2492 CREATE TABLE t1 (c1 TINYINT NOT NULL);
2493 CREATE TABLE t2 (c1 TINYINT NOT NULL);
2494 CREATE TABLE t3 (c1 TINYINT NOT NULL);
2495 CREATE TABLE t4 (c1 TINYINT NOT NULL);
2496 CREATE TABLE t5 (c1 TINYINT NOT NULL);
2497 CREATE TABLE t6 (c1 TINYINT NOT NULL);
2498 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2499 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2500 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2501 INSERT INTO t4 (c1) VALUES(10);
2502 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2503 SELECT t1.c1,t2.c1 FROM t1,t2 WHERE t1.c1 = t2.c1;
2504 c1 c1
2505 0 0
2506 1 1
2507 2 2
2508 3 3
2509 4 4
2510 5 5
2511 6 6
2512 7 7
2513 8 8
2514 9 9
2515 DROP TABLE t1,t2,t3,t4,t5,t6;
2516 CREATE TABLE t1 (c1 SMALLINT NOT NULL);
2517 CREATE TABLE t2 (c1 SMALLINT NOT NULL);
2518 CREATE TABLE t3 (c1 SMALLINT NOT NULL);
2519 CREATE TABLE t4 (c1 SMALLINT NOT NULL);
2520 CREATE TABLE t5 (c1 SMALLINT NOT NULL);
2521 CREATE TABLE t6 (c1 SMALLINT NOT NULL);
2522 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2523 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2524 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2525 INSERT INTO t4 (c1) VALUES(10);
2526 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2527 SELECT t1.c1,t2.c1 FROM t1,t2 WHERE t1.c1 = t2.c1;
2528 c1 c1
2529 0 0
2530 1 1
2531 2 2
2532 3 3
2533 4 4
2534 5 5
2535 6 6
2536 7 7
2537 8 8
2538 9 9
2539 DROP TABLE t1,t2,t3,t4,t5,t6;
2540 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
2541 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
2542 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
2543 CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
2544 CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
2545 CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
2546 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2547 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2548 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2549 INSERT INTO t4 (c1) VALUES(10);
2550 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2551 SELECT t1.c1,t2.c1 FROM t1,t2 WHERE t1.c1 = t2.c1;
2552 c1 c1
2553 0 0
2554 1 1
2555 2 2
2556 3 3
2557 4 4
2558 5 5
2559 6 6
2560 7 7
2561 8 8
2562 9 9
2563 DROP TABLE t1,t2,t3,t4,t5,t6;
2564 CREATE TABLE t1 (c1 INT NOT NULL);
2565 CREATE TABLE t2 (c1 INT NOT NULL);
2566 CREATE TABLE t3 (c1 INT NOT NULL);
2567 CREATE TABLE t4 (c1 INT NOT NULL);
2568 CREATE TABLE t5 (c1 INT NOT NULL);
2569 CREATE TABLE t6 (c1 INT NOT NULL);
2570 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2571 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2572 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2573 INSERT INTO t4 (c1) VALUES(10);
2574 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2575 SELECT t1.c1,t2.c1 FROM t1,t2 WHERE t1.c1 = t2.c1;
2576 c1 c1
2577 0 0
2578 1 1
2579 2 2
2580 3 3
2581 4 4
2582 5 5
2583 6 6
2584 7 7
2585 8 8
2586 9 9
2587 DROP TABLE t1,t2,t3,t4,t5,t6;
2588 CREATE TABLE t1 (c1 INTEGER NOT NULL);
2589 CREATE TABLE t2 (c1 INTEGER NOT NULL);
2590 CREATE TABLE t3 (c1 INTEGER NOT NULL);
2591 CREATE TABLE t4 (c1 INTEGER NOT NULL);
2592 CREATE TABLE t5 (c1 INTEGER NOT NULL);
2593 CREATE TABLE t6 (c1 INTEGER NOT NULL);
2594 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2595 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2596 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2597 INSERT INTO t4 (c1) VALUES(10);
2598 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2599 SELECT t1.c1,t2.c1 FROM t1,t2 WHERE t1.c1 = t2.c1;
2600 c1 c1
2601 0 0
2602 1 1
2603 2 2
2604 3 3
2605 4 4
2606 5 5
2607 6 6
2608 7 7
2609 8 8
2610 9 9
2611 DROP TABLE t1,t2,t3,t4,t5,t6;
2612 CREATE TABLE t1 (c1 BIGINT NOT NULL);
2613 CREATE TABLE t2 (c1 BIGINT NOT NULL);
2614 CREATE TABLE t3 (c1 BIGINT NOT NULL);
2615 CREATE TABLE t4 (c1 BIGINT NOT NULL);
2616 CREATE TABLE t5 (c1 BIGINT NOT NULL);
2617 CREATE TABLE t6 (c1 BIGINT NOT NULL);
2618 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2619 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2620 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2621 INSERT INTO t4 (c1) VALUES(10);
2622 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2623 SELECT t1.c1,t2.c1 FROM t1,t2 WHERE t1.c1 = t2.c1;
2624 c1 c1
2625 0 0
2626 1 1
2627 2 2
2628 3 3
2629 4 4
2630 5 5
2631 6 6
2632 7 7
2633 8 8
2634 9 9
2635 DROP TABLE t1,t2,t3,t4,t5,t6;
2636 CREATE TABLE t1 (c1 TINYINT NOT NULL);
2637 CREATE TABLE t2 (c1 TINYINT NOT NULL);
2638 CREATE TABLE t3 (c1 TINYINT NOT NULL);
2639 CREATE TABLE t4 (c1 TINYINT NOT NULL);
2640 CREATE TABLE t5 (c1 TINYINT NOT NULL);
2641 CREATE TABLE t6 (c1 TINYINT NOT NULL);
2642 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2643 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2644 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2645 INSERT INTO t4 (c1) VALUES(10);
2646 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2647 SELECT t1.c1,t3.c1 FROM t1,t3 WHERE t1.c1 = t3.c1;
2648 c1 c1
2649 1 1
2650 3 3
2651 5 5
2652 7 7
2653 9 9
2654 DROP TABLE t1,t2,t3,t4,t5,t6;
2655 CREATE TABLE t1 (c1 SMALLINT NOT NULL);
2656 CREATE TABLE t2 (c1 SMALLINT NOT NULL);
2657 CREATE TABLE t3 (c1 SMALLINT NOT NULL);
2658 CREATE TABLE t4 (c1 SMALLINT NOT NULL);
2659 CREATE TABLE t5 (c1 SMALLINT NOT NULL);
2660 CREATE TABLE t6 (c1 SMALLINT NOT NULL);
2661 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2662 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2663 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2664 INSERT INTO t4 (c1) VALUES(10);
2665 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2666 SELECT t1.c1,t3.c1 FROM t1,t3 WHERE t1.c1 = t3.c1;
2667 c1 c1
2668 1 1
2669 3 3
2670 5 5
2671 7 7
2672 9 9
2673 DROP TABLE t1,t2,t3,t4,t5,t6;
2674 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
2675 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
2676 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
2677 CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
2678 CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
2679 CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
2680 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2681 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2682 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2683 INSERT INTO t4 (c1) VALUES(10);
2684 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2685 SELECT t1.c1,t3.c1 FROM t1,t3 WHERE t1.c1 = t3.c1;
2686 c1 c1
2687 1 1
2688 3 3
2689 5 5
2690 7 7
2691 9 9
2692 DROP TABLE t1,t2,t3,t4,t5,t6;
2693 CREATE TABLE t1 (c1 INT NOT NULL);
2694 CREATE TABLE t2 (c1 INT NOT NULL);
2695 CREATE TABLE t3 (c1 INT NOT NULL);
2696 CREATE TABLE t4 (c1 INT NOT NULL);
2697 CREATE TABLE t5 (c1 INT NOT NULL);
2698 CREATE TABLE t6 (c1 INT NOT NULL);
2699 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2700 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2701 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2702 INSERT INTO t4 (c1) VALUES(10);
2703 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2704 SELECT t1.c1,t3.c1 FROM t1,t3 WHERE t1.c1 = t3.c1;
2705 c1 c1
2706 1 1
2707 3 3
2708 5 5
2709 7 7
2710 9 9
2711 DROP TABLE t1,t2,t3,t4,t5,t6;
2712 CREATE TABLE t1 (c1 INTEGER NOT NULL);
2713 CREATE TABLE t2 (c1 INTEGER NOT NULL);
2714 CREATE TABLE t3 (c1 INTEGER NOT NULL);
2715 CREATE TABLE t4 (c1 INTEGER NOT NULL);
2716 CREATE TABLE t5 (c1 INTEGER NOT NULL);
2717 CREATE TABLE t6 (c1 INTEGER NOT NULL);
2718 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2719 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2720 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2721 INSERT INTO t4 (c1) VALUES(10);
2722 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2723 SELECT t1.c1,t3.c1 FROM t1,t3 WHERE t1.c1 = t3.c1;
2724 c1 c1
2725 1 1
2726 3 3
2727 5 5
2728 7 7
2729 9 9
2730 DROP TABLE t1,t2,t3,t4,t5,t6;
2731 CREATE TABLE t1 (c1 BIGINT NOT NULL);
2732 CREATE TABLE t2 (c1 BIGINT NOT NULL);
2733 CREATE TABLE t3 (c1 BIGINT NOT NULL);
2734 CREATE TABLE t4 (c1 BIGINT NOT NULL);
2735 CREATE TABLE t5 (c1 BIGINT NOT NULL);
2736 CREATE TABLE t6 (c1 BIGINT NOT NULL);
2737 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2738 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2739 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2740 INSERT INTO t4 (c1) VALUES(10);
2741 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2742 SELECT t1.c1,t3.c1 FROM t1,t3 WHERE t1.c1 = t3.c1;
2743 c1 c1
2744 1 1
2745 3 3
2746 5 5
2747 7 7
2748 9 9
2749 DROP TABLE t1,t2,t3,t4,t5,t6;
2750 CREATE TABLE t1 (c1 TINYINT NOT NULL);
2751 CREATE TABLE t2 (c1 TINYINT NOT NULL);
2752 CREATE TABLE t3 (c1 TINYINT NOT NULL);
2753 CREATE TABLE t4 (c1 TINYINT NOT NULL);
2754 CREATE TABLE t5 (c1 TINYINT NOT NULL);
2755 CREATE TABLE t6 (c1 TINYINT 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,t4 WHERE t1.c1 = t4.c1;
2762 c1 c1
2763 DROP TABLE t1,t2,t3,t4,t5,t6;
2764 CREATE TABLE t1 (c1 SMALLINT NOT NULL);
2765 CREATE TABLE t2 (c1 SMALLINT NOT NULL);
2766 CREATE TABLE t3 (c1 SMALLINT NOT NULL);
2767 CREATE TABLE t4 (c1 SMALLINT NOT NULL);
2768 CREATE TABLE t5 (c1 SMALLINT NOT NULL);
2769 CREATE TABLE t6 (c1 SMALLINT NOT NULL);
2770 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2771 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2772 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2773 INSERT INTO t4 (c1) VALUES(10);
2774 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2775 SELECT t1.c1,t4.c1 FROM t1,t4 WHERE t1.c1 = t4.c1;
2776 c1 c1
2777 DROP TABLE t1,t2,t3,t4,t5,t6;
2778 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
2779 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
2780 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
2781 CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
2782 CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
2783 CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
2784 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2785 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2786 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2787 INSERT INTO t4 (c1) VALUES(10);
2788 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2789 SELECT t1.c1,t4.c1 FROM t1,t4 WHERE t1.c1 = t4.c1;
2790 c1 c1
2791 DROP TABLE t1,t2,t3,t4,t5,t6;
2792 CREATE TABLE t1 (c1 INT NOT NULL);
2793 CREATE TABLE t2 (c1 INT NOT NULL);
2794 CREATE TABLE t3 (c1 INT NOT NULL);
2795 CREATE TABLE t4 (c1 INT NOT NULL);
2796 CREATE TABLE t5 (c1 INT NOT NULL);
2797 CREATE TABLE t6 (c1 INT NOT NULL);
2798 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2799 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2800 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2801 INSERT INTO t4 (c1) VALUES(10);
2802 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2803 SELECT t1.c1,t4.c1 FROM t1,t4 WHERE t1.c1 = t4.c1;
2804 c1 c1
2805 DROP TABLE t1,t2,t3,t4,t5,t6;
2806 CREATE TABLE t1 (c1 INTEGER NOT NULL);
2807 CREATE TABLE t2 (c1 INTEGER NOT NULL);
2808 CREATE TABLE t3 (c1 INTEGER NOT NULL);
2809 CREATE TABLE t4 (c1 INTEGER NOT NULL);
2810 CREATE TABLE t5 (c1 INTEGER NOT NULL);
2811 CREATE TABLE t6 (c1 INTEGER NOT NULL);
2812 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2813 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2814 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2815 INSERT INTO t4 (c1) VALUES(10);
2816 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2817 SELECT t1.c1,t4.c1 FROM t1,t4 WHERE t1.c1 = t4.c1;
2818 c1 c1
2819 DROP TABLE t1,t2,t3,t4,t5,t6;
2820 CREATE TABLE t1 (c1 BIGINT NOT NULL);
2821 CREATE TABLE t2 (c1 BIGINT NOT NULL);
2822 CREATE TABLE t3 (c1 BIGINT NOT NULL);
2823 CREATE TABLE t4 (c1 BIGINT NOT NULL);
2824 CREATE TABLE t5 (c1 BIGINT NOT NULL);
2825 CREATE TABLE t6 (c1 BIGINT NOT NULL);
2826 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2827 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2828 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2829 INSERT INTO t4 (c1) VALUES(10);
2830 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2831 SELECT t1.c1,t4.c1 FROM t1,t4 WHERE t1.c1 = t4.c1;
2832 c1 c1
2833 DROP TABLE t1,t2,t3,t4,t5,t6;
2834 CREATE TABLE t1 (c1 TINYINT NOT NULL);
2835 CREATE TABLE t2 (c1 TINYINT NOT NULL);
2836 CREATE TABLE t3 (c1 TINYINT NOT NULL);
2837 CREATE TABLE t4 (c1 TINYINT NOT NULL);
2838 CREATE TABLE t5 (c1 TINYINT NOT NULL);
2839 CREATE TABLE t6 (c1 TINYINT NOT NULL);
2840 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2841 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2842 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2843 INSERT INTO t4 (c1) VALUES(10);
2844 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2845 SELECT t1.c1,t5.c1 FROM t1,t5 WHERE t1.c1 = t5.c1;
2846 c1 c1
2847 DROP TABLE t1,t2,t3,t4,t5,t6;
2848 CREATE TABLE t1 (c1 SMALLINT NOT NULL);
2849 CREATE TABLE t2 (c1 SMALLINT NOT NULL);
2850 CREATE TABLE t3 (c1 SMALLINT NOT NULL);
2851 CREATE TABLE t4 (c1 SMALLINT NOT NULL);
2852 CREATE TABLE t5 (c1 SMALLINT NOT NULL);
2853 CREATE TABLE t6 (c1 SMALLINT NOT NULL);
2854 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2855 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2856 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2857 INSERT INTO t4 (c1) VALUES(10);
2858 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2859 SELECT t1.c1,t5.c1 FROM t1,t5 WHERE t1.c1 = t5.c1;
2860 c1 c1
2861 DROP TABLE t1,t2,t3,t4,t5,t6;
2862 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
2863 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
2864 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
2865 CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
2866 CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
2867 CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
2868 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2869 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2870 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2871 INSERT INTO t4 (c1) VALUES(10);
2872 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2873 SELECT t1.c1,t5.c1 FROM t1,t5 WHERE t1.c1 = t5.c1;
2874 c1 c1
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,t5 WHERE t1.c1 = t5.c1;
2888 c1 c1
2889 DROP TABLE t1,t2,t3,t4,t5,t6;
2890 CREATE TABLE t1 (c1 INTEGER NOT NULL);
2891 CREATE TABLE t2 (c1 INTEGER NOT NULL);
2892 CREATE TABLE t3 (c1 INTEGER NOT NULL);
2893 CREATE TABLE t4 (c1 INTEGER NOT NULL);
2894 CREATE TABLE t5 (c1 INTEGER NOT NULL);
2895 CREATE TABLE t6 (c1 INTEGER NOT NULL);
2896 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2897 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2898 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2899 INSERT INTO t4 (c1) VALUES(10);
2900 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2901 SELECT t1.c1,t5.c1 FROM t1,t5 WHERE t1.c1 = t5.c1;
2902 c1 c1
2903 DROP TABLE t1,t2,t3,t4,t5,t6;
2904 CREATE TABLE t1 (c1 BIGINT NOT NULL);
2905 CREATE TABLE t2 (c1 BIGINT NOT NULL);
2906 CREATE TABLE t3 (c1 BIGINT NOT NULL);
2907 CREATE TABLE t4 (c1 BIGINT NOT NULL);
2908 CREATE TABLE t5 (c1 BIGINT NOT NULL);
2909 CREATE TABLE t6 (c1 BIGINT NOT NULL);
2910 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2911 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2912 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2913 INSERT INTO t4 (c1) VALUES(10);
2914 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2915 SELECT t1.c1,t5.c1 FROM t1,t5 WHERE t1.c1 = t5.c1;
2916 c1 c1
2917 DROP TABLE t1,t2,t3,t4,t5,t6;
2918 CREATE TABLE t1 (c1 TINYINT NOT NULL);
2919 CREATE TABLE t2 (c1 TINYINT NOT NULL);
2920 CREATE TABLE t3 (c1 TINYINT NOT NULL);
2921 CREATE TABLE t4 (c1 TINYINT NOT NULL);
2922 CREATE TABLE t5 (c1 TINYINT NOT NULL);
2923 CREATE TABLE t6 (c1 TINYINT NOT NULL);
2924 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2925 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2926 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2927 INSERT INTO t4 (c1) VALUES(10);
2928 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2929 SELECT t1.c1,t6.c1 FROM t1,t6 WHERE t1.c1 = t6.c1;
2930 c1 c1
2931 DROP TABLE t1,t2,t3,t4,t5,t6;
2932 CREATE TABLE t1 (c1 SMALLINT NOT NULL);
2933 CREATE TABLE t2 (c1 SMALLINT NOT NULL);
2934 CREATE TABLE t3 (c1 SMALLINT NOT NULL);
2935 CREATE TABLE t4 (c1 SMALLINT NOT NULL);
2936 CREATE TABLE t5 (c1 SMALLINT NOT NULL);
2937 CREATE TABLE t6 (c1 SMALLINT NOT NULL);
2938 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2939 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2940 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2941 INSERT INTO t4 (c1) VALUES(10);
2942 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2943 SELECT t1.c1,t6.c1 FROM t1,t6 WHERE t1.c1 = t6.c1;
2944 c1 c1
2945 DROP TABLE t1,t2,t3,t4,t5,t6;
2946 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
2947 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
2948 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
2949 CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
2950 CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
2951 CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
2952 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2953 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2954 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2955 INSERT INTO t4 (c1) VALUES(10);
2956 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2957 SELECT t1.c1,t6.c1 FROM t1,t6 WHERE t1.c1 = t6.c1;
2958 c1 c1
2959 DROP TABLE t1,t2,t3,t4,t5,t6;
2960 CREATE TABLE t1 (c1 INT NOT NULL);
2961 CREATE TABLE t2 (c1 INT NOT NULL);
2962 CREATE TABLE t3 (c1 INT NOT NULL);
2963 CREATE TABLE t4 (c1 INT NOT NULL);
2964 CREATE TABLE t5 (c1 INT NOT NULL);
2965 CREATE TABLE t6 (c1 INT NOT NULL);
2966 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2967 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2968 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2969 INSERT INTO t4 (c1) VALUES(10);
2970 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2971 SELECT t1.c1,t6.c1 FROM t1,t6 WHERE t1.c1 = t6.c1;
2972 c1 c1
2973 DROP TABLE t1,t2,t3,t4,t5,t6;
2974 CREATE TABLE t1 (c1 INTEGER NOT NULL);
2975 CREATE TABLE t2 (c1 INTEGER NOT NULL);
2976 CREATE TABLE t3 (c1 INTEGER NOT NULL);
2977 CREATE TABLE t4 (c1 INTEGER NOT NULL);
2978 CREATE TABLE t5 (c1 INTEGER NOT NULL);
2979 CREATE TABLE t6 (c1 INTEGER NOT NULL);
2980 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2981 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2982 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2983 INSERT INTO t4 (c1) VALUES(10);
2984 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2985 SELECT t1.c1,t6.c1 FROM t1,t6 WHERE t1.c1 = t6.c1;
2986 c1 c1
2987 DROP TABLE t1,t2,t3,t4,t5,t6;
2988 CREATE TABLE t1 (c1 BIGINT NOT NULL);
2989 CREATE TABLE t2 (c1 BIGINT NOT NULL);
2990 CREATE TABLE t3 (c1 BIGINT NOT NULL);
2991 CREATE TABLE t4 (c1 BIGINT NOT NULL);
2992 CREATE TABLE t5 (c1 BIGINT NOT NULL);
2993 CREATE TABLE t6 (c1 BIGINT NOT NULL);
2994 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2995 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2996 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2997 INSERT INTO t4 (c1) VALUES(10);
2998 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2999 SELECT t1.c1,t6.c1 FROM t1,t6 WHERE t1.c1 = t6.c1;
3000 c1 c1
3001 DROP TABLE t1,t2,t3,t4,t5,t6;
3002 CREATE TABLE t1 (c1 TINYINT NOT NULL);
3003 CREATE TABLE t2 (c1 TINYINT NOT NULL);
3004 CREATE TABLE t3 (c1 TINYINT NOT NULL);
3005 CREATE TABLE t4 (c1 TINYINT NOT NULL);
3006 CREATE TABLE t5 (c1 TINYINT NOT NULL);
3007 CREATE TABLE t6 (c1 TINYINT 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,t2.c1 FROM t1,t2 WHERE t1.c1 >= t2.c1;
3014 c1 c1
3015 0 0
3016 1 0
3017 2 0
3018 3 0
3019 4 0
3020 5 0
3021 6 0
3022 7 0
3023 8 0
3024 9 0
3025 1 1
3026 2 1
3027 3 1
3028 4 1
3029 5 1
3030 6 1
3031 7 1
3032 8 1
3033 9 1
3034 2 2
3035 3 2
3036 4 2
3037 5 2
3038 6 2
3039 7 2
3040 8 2
3041 9 2
3042 3 3
3043 4 3
3044 5 3
3045 6 3
3046 7 3
3047 8 3
3048 9 3
3049 4 4
3050 5 4
3051 6 4
3052 7 4
3053 8 4
3054 9 4
3055 5 5
3056 6 5
3057 7 5
3058 8 5
3059 9 5
3060 6 6
3061 7 6
3062 8 6
3063 9 6
3064 7 7
3065 8 7
3066 9 7
3067 8 8
3068 9 8
3069 9 9
3070 DROP TABLE t1,t2,t3,t4,t5,t6;
3071 CREATE TABLE t1 (c1 SMALLINT NOT NULL);
3072 CREATE TABLE t2 (c1 SMALLINT NOT NULL);
3073 CREATE TABLE t3 (c1 SMALLINT NOT NULL);
3074 CREATE TABLE t4 (c1 SMALLINT NOT NULL);
3075 CREATE TABLE t5 (c1 SMALLINT NOT NULL);
3076 CREATE TABLE t6 (c1 SMALLINT NOT NULL);
3077 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3078 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3079 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3080 INSERT INTO t4 (c1) VALUES(10);
3081 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3082 SELECT t1.c1,t2.c1 FROM t1,t2 WHERE t1.c1 >= t2.c1;
3083 c1 c1
3084 0 0
3085 1 0
3086 2 0
3087 3 0
3088 4 0
3089 5 0
3090 6 0
3091 7 0
3092 8 0
3093 9 0
3094 1 1
3095 2 1
3096 3 1
3097 4 1
3098 5 1
3099 6 1
3100 7 1
3101 8 1
3102 9 1
3103 2 2
3104 3 2
3105 4 2
3106 5 2
3107 6 2
3108 7 2
3109 8 2
3110 9 2
3111 3 3
3112 4 3
3113 5 3
3114 6 3
3115 7 3
3116 8 3
3117 9 3
3118 4 4
3119 5 4
3120 6 4
3121 7 4
3122 8 4
3123 9 4
3124 5 5
3125 6 5
3126 7 5
3127 8 5
3128 9 5
3129 6 6
3130 7 6
3131 8 6
3132 9 6
3133 7 7
3134 8 7
3135 9 7
3136 8 8
3137 9 8
3138 9 9
3139 DROP TABLE t1,t2,t3,t4,t5,t6;
3140 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
3141 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
3142 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
3143 CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
3144 CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
3145 CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
3146 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3147 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3148 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3149 INSERT INTO t4 (c1) VALUES(10);
3150 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3151 SELECT t1.c1,t2.c1 FROM t1,t2 WHERE t1.c1 >= t2.c1;
3152 c1 c1
3153 0 0
3154 1 0
3155 2 0
3156 3 0
3157 4 0
3158 5 0
3159 6 0
3160 7 0
3161 8 0
3162 9 0
3163 1 1
3164 2 1
3165 3 1
3166 4 1
3167 5 1
3168 6 1
3169 7 1
3170 8 1
3171 9 1
3172 2 2
3173 3 2
3174 4 2
3175 5 2
3176 6 2
3177 7 2
3178 8 2
3179 9 2
3180 3 3
3181 4 3
3182 5 3
3183 6 3
3184 7 3
3185 8 3
3186 9 3
3187 4 4
3188 5 4
3189 6 4
3190 7 4
3191 8 4
3192 9 4
3193 5 5
3194 6 5
3195 7 5
3196 8 5
3197 9 5
3198 6 6
3199 7 6
3200 8 6
3201 9 6
3202 7 7
3203 8 7
3204 9 7
3205 8 8
3206 9 8
3207 9 9
3208 DROP TABLE t1,t2,t3,t4,t5,t6;
3209 CREATE TABLE t1 (c1 INT NOT NULL);
3210 CREATE TABLE t2 (c1 INT NOT NULL);
3211 CREATE TABLE t3 (c1 INT NOT NULL);
3212 CREATE TABLE t4 (c1 INT NOT NULL);
3213 CREATE TABLE t5 (c1 INT NOT NULL);
3214 CREATE TABLE t6 (c1 INT NOT NULL);
3215 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3216 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3217 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3218 INSERT INTO t4 (c1) VALUES(10);
3219 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3220 SELECT t1.c1,t2.c1 FROM t1,t2 WHERE t1.c1 >= t2.c1;
3221 c1 c1
3222 0 0
3223 1 0
3224 2 0
3225 3 0
3226 4 0
3227 5 0
3228 6 0
3229 7 0
3230 8 0
3231 9 0
3232 1 1
3233 2 1
3234 3 1
3235 4 1
3236 5 1
3237 6 1
3238 7 1
3239 8 1
3240 9 1
3241 2 2
3242 3 2
3243 4 2
3244 5 2
3245 6 2
3246 7 2
3247 8 2
3248 9 2
3249 3 3
3250 4 3
3251 5 3
3252 6 3
3253 7 3
3254 8 3
3255 9 3
3256 4 4
3257 5 4
3258 6 4
3259 7 4
3260 8 4
3261 9 4
3262 5 5
3263 6 5
3264 7 5
3265 8 5
3266 9 5
3267 6 6
3268 7 6
3269 8 6
3270 9 6
3271 7 7
3272 8 7
3273 9 7
3274 8 8
3275 9 8
3276 9 9
3277 DROP TABLE t1,t2,t3,t4,t5,t6;
3278 CREATE TABLE t1 (c1 INTEGER NOT NULL);
3279 CREATE TABLE t2 (c1 INTEGER NOT NULL);
3280 CREATE TABLE t3 (c1 INTEGER NOT NULL);
3281 CREATE TABLE t4 (c1 INTEGER NOT NULL);
3282 CREATE TABLE t5 (c1 INTEGER NOT NULL);
3283 CREATE TABLE t6 (c1 INTEGER NOT NULL);
3284 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3285 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3286 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3287 INSERT INTO t4 (c1) VALUES(10);
3288 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3289 SELECT t1.c1,t2.c1 FROM t1,t2 WHERE t1.c1 >= t2.c1;
3290 c1 c1
3291 0 0
3292 1 0
3293 2 0
3294 3 0
3295 4 0
3296 5 0
3297 6 0
3298 7 0
3299 8 0
3300 9 0
3301 1 1
3302 2 1
3303 3 1
3304 4 1
3305 5 1
3306 6 1
3307 7 1
3308 8 1
3309 9 1
3310 2 2
3311 3 2
3312 4 2
3313 5 2
3314 6 2
3315 7 2
3316 8 2
3317 9 2
3318 3 3
3319 4 3
3320 5 3
3321 6 3
3322 7 3
3323 8 3
3324 9 3
3325 4 4
3326 5 4
3327 6 4
3328 7 4
3329 8 4
3330 9 4
3331 5 5
3332 6 5
3333 7 5
3334 8 5
3335 9 5
3336 6 6
3337 7 6
3338 8 6
3339 9 6
3340 7 7
3341 8 7
3342 9 7
3343 8 8
3344 9 8
3345 9 9
3346 DROP TABLE t1,t2,t3,t4,t5,t6;
3347 CREATE TABLE t1 (c1 BIGINT NOT NULL);
3348 CREATE TABLE t2 (c1 BIGINT NOT NULL);
3349 CREATE TABLE t3 (c1 BIGINT NOT NULL);
3350 CREATE TABLE t4 (c1 BIGINT NOT NULL);
3351 CREATE TABLE t5 (c1 BIGINT NOT NULL);
3352 CREATE TABLE t6 (c1 BIGINT NOT NULL);
3353 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3354 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3355 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3356 INSERT INTO t4 (c1) VALUES(10);
3357 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3358 SELECT t1.c1,t2.c1 FROM t1,t2 WHERE t1.c1 >= t2.c1;
3359 c1 c1
3360 0 0
3361 1 0
3362 2 0
3363 3 0
3364 4 0
3365 5 0
3366 6 0
3367 7 0
3368 8 0
3369 9 0
3370 1 1
3371 2 1
3372 3 1
3373 4 1
3374 5 1
3375 6 1
3376 7 1
3377 8 1
3378 9 1
3379 2 2
3380 3 2
3381 4 2
3382 5 2
3383 6 2
3384 7 2
3385 8 2
3386 9 2
3387 3 3
3388 4 3
3389 5 3
3390 6 3
3391 7 3
3392 8 3
3393 9 3
3394 4 4
3395 5 4
3396 6 4
3397 7 4
3398 8 4
3399 9 4
3400 5 5
3401 6 5
3402 7 5
3403 8 5
3404 9 5
3405 6 6
3406 7 6
3407 8 6
3408 9 6
3409 7 7
3410 8 7
3411 9 7
3412 8 8
3413 9 8
3414 9 9
3415 DROP TABLE t1,t2,t3,t4,t5,t6;
3416 CREATE TABLE t1 (c1 TINYINT NOT NULL);
3417 CREATE TABLE t2 (c1 TINYINT NOT NULL);
3418 CREATE TABLE t3 (c1 TINYINT NOT NULL);
3419 CREATE TABLE t4 (c1 TINYINT NOT NULL);
3420 CREATE TABLE t5 (c1 TINYINT NOT NULL);
3421 CREATE TABLE t6 (c1 TINYINT 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,t3 WHERE t1.c1 >= t3.c1;
3428 c1 c1
3429 1 1
3430 2 1
3431 3 1
3432 3 3
3433 4 1
3434 4 3
3435 5 1
3436 5 3
3437 5 5
3438 6 1
3439 6 3
3440 6 5
3441 7 1
3442 7 3
3443 7 5
3444 7 7
3445 8 1
3446 8 3
3447 8 5
3448 8 7
3449 9 1
3450 9 3
3451 9 5
3452 9 7
3453 9 9
3454 DROP TABLE t1,t2,t3,t4,t5,t6;
3455 CREATE TABLE t1 (c1 SMALLINT NOT NULL);
3456 CREATE TABLE t2 (c1 SMALLINT NOT NULL);
3457 CREATE TABLE t3 (c1 SMALLINT NOT NULL);
3458 CREATE TABLE t4 (c1 SMALLINT NOT NULL);
3459 CREATE TABLE t5 (c1 SMALLINT NOT NULL);
3460 CREATE TABLE t6 (c1 SMALLINT NOT NULL);
3461 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3462 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3463 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3464 INSERT INTO t4 (c1) VALUES(10);
3465 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3466 SELECT t1.c1,t3.c1 FROM t1,t3 WHERE t1.c1 >= t3.c1;
3467 c1 c1
3468 1 1
3469 2 1
3470 3 1
3471 3 3
3472 4 1
3473 4 3
3474 5 1
3475 5 3
3476 5 5
3477 6 1
3478 6 3
3479 6 5
3480 7 1
3481 7 3
3482 7 5
3483 7 7
3484 8 1
3485 8 3
3486 8 5
3487 8 7
3488 9 1
3489 9 3
3490 9 5
3491 9 7
3492 9 9
3493 DROP TABLE t1,t2,t3,t4,t5,t6;
3494 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
3495 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
3496 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
3497 CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
3498 CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
3499 CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
3500 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3501 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3502 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3503 INSERT INTO t4 (c1) VALUES(10);
3504 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3505 SELECT t1.c1,t3.c1 FROM t1,t3 WHERE t1.c1 >= t3.c1;
3506 c1 c1
3507 1 1
3508 2 1
3509 3 1
3510 3 3
3511 4 1
3512 4 3
3513 5 1
3514 5 3
3515 5 5
3516 6 1
3517 6 3
3518 6 5
3519 7 1
3520 7 3
3521 7 5
3522 7 7
3523 8 1
3524 8 3
3525 8 5
3526 8 7
3527 9 1
3528 9 3
3529 9 5
3530 9 7
3531 9 9
3532 DROP TABLE t1,t2,t3,t4,t5,t6;
3533 CREATE TABLE t1 (c1 INT NOT NULL);
3534 CREATE TABLE t2 (c1 INT NOT NULL);
3535 CREATE TABLE t3 (c1 INT NOT NULL);
3536 CREATE TABLE t4 (c1 INT NOT NULL);
3537 CREATE TABLE t5 (c1 INT NOT NULL);
3538 CREATE TABLE t6 (c1 INT NOT NULL);
3539 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3540 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3541 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3542 INSERT INTO t4 (c1) VALUES(10);
3543 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3544 SELECT t1.c1,t3.c1 FROM t1,t3 WHERE t1.c1 >= t3.c1;
3545 c1 c1
3546 1 1
3547 2 1
3548 3 1
3549 3 3
3550 4 1
3551 4 3
3552 5 1
3553 5 3
3554 5 5
3555 6 1
3556 6 3
3557 6 5
3558 7 1
3559 7 3
3560 7 5
3561 7 7
3562 8 1
3563 8 3
3564 8 5
3565 8 7
3566 9 1
3567 9 3
3568 9 5
3569 9 7
3570 9 9
3571 DROP TABLE t1,t2,t3,t4,t5,t6;
3572 CREATE TABLE t1 (c1 INTEGER NOT NULL);
3573 CREATE TABLE t2 (c1 INTEGER NOT NULL);
3574 CREATE TABLE t3 (c1 INTEGER NOT NULL);
3575 CREATE TABLE t4 (c1 INTEGER NOT NULL);
3576 CREATE TABLE t5 (c1 INTEGER NOT NULL);
3577 CREATE TABLE t6 (c1 INTEGER NOT NULL);
3578 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3579 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3580 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3581 INSERT INTO t4 (c1) VALUES(10);
3582 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3583 SELECT t1.c1,t3.c1 FROM t1,t3 WHERE t1.c1 >= t3.c1;
3584 c1 c1
3585 1 1
3586 2 1
3587 3 1
3588 3 3
3589 4 1
3590 4 3
3591 5 1
3592 5 3
3593 5 5
3594 6 1
3595 6 3
3596 6 5
3597 7 1
3598 7 3
3599 7 5
3600 7 7
3601 8 1
3602 8 3
3603 8 5
3604 8 7
3605 9 1
3606 9 3
3607 9 5
3608 9 7
3609 9 9
3610 DROP TABLE t1,t2,t3,t4,t5,t6;
3611 CREATE TABLE t1 (c1 BIGINT NOT NULL);
3612 CREATE TABLE t2 (c1 BIGINT NOT NULL);
3613 CREATE TABLE t3 (c1 BIGINT NOT NULL);
3614 CREATE TABLE t4 (c1 BIGINT NOT NULL);
3615 CREATE TABLE t5 (c1 BIGINT NOT NULL);
3616 CREATE TABLE t6 (c1 BIGINT NOT NULL);
3617 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3618 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3619 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3620 INSERT INTO t4 (c1) VALUES(10);
3621 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3622 SELECT t1.c1,t3.c1 FROM t1,t3 WHERE t1.c1 >= t3.c1;
3623 c1 c1
3624 1 1
3625 2 1
3626 3 1
3627 3 3
3628 4 1
3629 4 3
3630 5 1
3631 5 3
3632 5 5
3633 6 1
3634 6 3
3635 6 5
3636 7 1
3637 7 3
3638 7 5
3639 7 7
3640 8 1
3641 8 3
3642 8 5
3643 8 7
3644 9 1
3645 9 3
3646 9 5
3647 9 7
3648 9 9
3649 DROP TABLE t1,t2,t3,t4,t5,t6;
3650 CREATE TABLE t1 (c1 TINYINT NOT NULL);
3651 CREATE TABLE t2 (c1 TINYINT NOT NULL);
3652 CREATE TABLE t3 (c1 TINYINT NOT NULL);
3653 CREATE TABLE t4 (c1 TINYINT NOT NULL);
3654 CREATE TABLE t5 (c1 TINYINT NOT NULL);
3655 CREATE TABLE t6 (c1 TINYINT NOT NULL);
3656 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3657 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3658 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3659 INSERT INTO t4 (c1) VALUES(10);
3660 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3661 SELECT t1.c1,t4.c1 FROM t1,t4 WHERE t1.c1 >= t4.c1;
3662 c1 c1
3663 DROP TABLE t1,t2,t3,t4,t5,t6;
3664 CREATE TABLE t1 (c1 SMALLINT NOT NULL);
3665 CREATE TABLE t2 (c1 SMALLINT NOT NULL);
3666 CREATE TABLE t3 (c1 SMALLINT NOT NULL);
3667 CREATE TABLE t4 (c1 SMALLINT NOT NULL);
3668 CREATE TABLE t5 (c1 SMALLINT NOT NULL);
3669 CREATE TABLE t6 (c1 SMALLINT NOT NULL);
3670 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3671 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3672 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3673 INSERT INTO t4 (c1) VALUES(10);
3674 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3675 SELECT t1.c1,t4.c1 FROM t1,t4 WHERE t1.c1 >= t4.c1;
3676 c1 c1
3677 DROP TABLE t1,t2,t3,t4,t5,t6;
3678 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
3679 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
3680 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
3681 CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
3682 CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
3683 CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
3684 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3685 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3686 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3687 INSERT INTO t4 (c1) VALUES(10);
3688 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3689 SELECT t1.c1,t4.c1 FROM t1,t4 WHERE t1.c1 >= t4.c1;
3690 c1 c1
3691 DROP TABLE t1,t2,t3,t4,t5,t6;
3692 CREATE TABLE t1 (c1 INT NOT NULL);
3693 CREATE TABLE t2 (c1 INT NOT NULL);
3694 CREATE TABLE t3 (c1 INT NOT NULL);
3695 CREATE TABLE t4 (c1 INT NOT NULL);
3696 CREATE TABLE t5 (c1 INT NOT NULL);
3697 CREATE TABLE t6 (c1 INT 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,t4.c1 FROM t1,t4 WHERE t1.c1 >= t4.c1;
3704 c1 c1
3705 DROP TABLE t1,t2,t3,t4,t5,t6;
3706 CREATE TABLE t1 (c1 INTEGER NOT NULL);
3707 CREATE TABLE t2 (c1 INTEGER NOT NULL);
3708 CREATE TABLE t3 (c1 INTEGER NOT NULL);
3709 CREATE TABLE t4 (c1 INTEGER NOT NULL);
3710 CREATE TABLE t5 (c1 INTEGER NOT NULL);
3711 CREATE TABLE t6 (c1 INTEGER NOT NULL);
3712 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3713 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3714 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3715 INSERT INTO t4 (c1) VALUES(10);
3716 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3717 SELECT t1.c1,t4.c1 FROM t1,t4 WHERE t1.c1 >= t4.c1;
3718 c1 c1
3719 DROP TABLE t1,t2,t3,t4,t5,t6;
3720 CREATE TABLE t1 (c1 BIGINT NOT NULL);
3721 CREATE TABLE t2 (c1 BIGINT NOT NULL);
3722 CREATE TABLE t3 (c1 BIGINT NOT NULL);
3723 CREATE TABLE t4 (c1 BIGINT NOT NULL);
3724 CREATE TABLE t5 (c1 BIGINT NOT NULL);
3725 CREATE TABLE t6 (c1 BIGINT NOT NULL);
3726 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3727 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3728 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3729 INSERT INTO t4 (c1) VALUES(10);
3730 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3731 SELECT t1.c1,t4.c1 FROM t1,t4 WHERE t1.c1 >= t4.c1;
3732 c1 c1
3733 DROP TABLE t1,t2,t3,t4,t5,t6;
3734 CREATE TABLE t1 (c1 TINYINT NOT NULL);
3735 CREATE TABLE t2 (c1 TINYINT NOT NULL);
3736 CREATE TABLE t3 (c1 TINYINT NOT NULL);
3737 CREATE TABLE t4 (c1 TINYINT NOT NULL);
3738 CREATE TABLE t5 (c1 TINYINT NOT NULL);
3739 CREATE TABLE t6 (c1 TINYINT NOT NULL);
3740 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3741 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3742 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3743 INSERT INTO t4 (c1) VALUES(10);
3744 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3745 SELECT t1.c1,t5.c1 FROM t1,t5 WHERE t1.c1 >= t5.c1;
3746 c1 c1
3747 DROP TABLE t1,t2,t3,t4,t5,t6;
3748 CREATE TABLE t1 (c1 SMALLINT NOT NULL);
3749 CREATE TABLE t2 (c1 SMALLINT NOT NULL);
3750 CREATE TABLE t3 (c1 SMALLINT NOT NULL);
3751 CREATE TABLE t4 (c1 SMALLINT NOT NULL);
3752 CREATE TABLE t5 (c1 SMALLINT NOT NULL);
3753 CREATE TABLE t6 (c1 SMALLINT NOT NULL);
3754 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3755 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3756 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3757 INSERT INTO t4 (c1) VALUES(10);
3758 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3759 SELECT t1.c1,t5.c1 FROM t1,t5 WHERE t1.c1 >= t5.c1;
3760 c1 c1
3761 DROP TABLE t1,t2,t3,t4,t5,t6;
3762 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
3763 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
3764 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
3765 CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
3766 CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
3767 CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
3768 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3769 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3770 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3771 INSERT INTO t4 (c1) VALUES(10);
3772 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3773 SELECT t1.c1,t5.c1 FROM t1,t5 WHERE t1.c1 >= t5.c1;
3774 c1 c1
3775 DROP TABLE t1,t2,t3,t4,t5,t6;
3776 CREATE TABLE t1 (c1 INT NOT NULL);
3777 CREATE TABLE t2 (c1 INT NOT NULL);
3778 CREATE TABLE t3 (c1 INT NOT NULL);
3779 CREATE TABLE t4 (c1 INT NOT NULL);
3780 CREATE TABLE t5 (c1 INT NOT NULL);
3781 CREATE TABLE t6 (c1 INT NOT NULL);
3782 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3783 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3784 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3785 INSERT INTO t4 (c1) VALUES(10);
3786 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3787 SELECT t1.c1,t5.c1 FROM t1,t5 WHERE t1.c1 >= t5.c1;
3788 c1 c1
3789 DROP TABLE t1,t2,t3,t4,t5,t6;
3790 CREATE TABLE t1 (c1 INTEGER NOT NULL);
3791 CREATE TABLE t2 (c1 INTEGER NOT NULL);
3792 CREATE TABLE t3 (c1 INTEGER NOT NULL);
3793 CREATE TABLE t4 (c1 INTEGER NOT NULL);
3794 CREATE TABLE t5 (c1 INTEGER NOT NULL);
3795 CREATE TABLE t6 (c1 INTEGER NOT NULL);
3796 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3797 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3798 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3799 INSERT INTO t4 (c1) VALUES(10);
3800 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3801 SELECT t1.c1,t5.c1 FROM t1,t5 WHERE t1.c1 >= t5.c1;
3802 c1 c1
3803 DROP TABLE t1,t2,t3,t4,t5,t6;
3804 CREATE TABLE t1 (c1 BIGINT NOT NULL);
3805 CREATE TABLE t2 (c1 BIGINT NOT NULL);
3806 CREATE TABLE t3 (c1 BIGINT NOT NULL);
3807 CREATE TABLE t4 (c1 BIGINT NOT NULL);
3808 CREATE TABLE t5 (c1 BIGINT NOT NULL);
3809 CREATE TABLE t6 (c1 BIGINT NOT NULL);
3810 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3811 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3812 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3813 INSERT INTO t4 (c1) VALUES(10);
3814 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3815 SELECT t1.c1,t5.c1 FROM t1,t5 WHERE t1.c1 >= t5.c1;
3816 c1 c1
3817 DROP TABLE t1,t2,t3,t4,t5,t6;
3818 CREATE TABLE t1 (c1 TINYINT NOT NULL);
3819 CREATE TABLE t2 (c1 TINYINT NOT NULL);
3820 CREATE TABLE t3 (c1 TINYINT NOT NULL);
3821 CREATE TABLE t4 (c1 TINYINT NOT NULL);
3822 CREATE TABLE t5 (c1 TINYINT NOT NULL);
3823 CREATE TABLE t6 (c1 TINYINT 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,t6 WHERE t1.c1 >= t6.c1;
3830 c1 c1
3831 DROP TABLE t1,t2,t3,t4,t5,t6;
3832 CREATE TABLE t1 (c1 SMALLINT NOT NULL);
3833 CREATE TABLE t2 (c1 SMALLINT NOT NULL);
3834 CREATE TABLE t3 (c1 SMALLINT NOT NULL);
3835 CREATE TABLE t4 (c1 SMALLINT NOT NULL);
3836 CREATE TABLE t5 (c1 SMALLINT NOT NULL);
3837 CREATE TABLE t6 (c1 SMALLINT NOT NULL);
3838 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3839 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3840 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3841 INSERT INTO t4 (c1) VALUES(10);
3842 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3843 SELECT t1.c1,t6.c1 FROM t1,t6 WHERE t1.c1 >= t6.c1;
3844 c1 c1
3845 DROP TABLE t1,t2,t3,t4,t5,t6;
3846 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
3847 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
3848 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
3849 CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
3850 CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
3851 CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
3852 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3853 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3854 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3855 INSERT INTO t4 (c1) VALUES(10);
3856 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3857 SELECT t1.c1,t6.c1 FROM t1,t6 WHERE t1.c1 >= t6.c1;
3858 c1 c1
3859 DROP TABLE t1,t2,t3,t4,t5,t6;
3860 CREATE TABLE t1 (c1 INT NOT NULL);
3861 CREATE TABLE t2 (c1 INT NOT NULL);
3862 CREATE TABLE t3 (c1 INT NOT NULL);
3863 CREATE TABLE t4 (c1 INT NOT NULL);
3864 CREATE TABLE t5 (c1 INT NOT NULL);
3865 CREATE TABLE t6 (c1 INT NOT NULL);
3866 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3867 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3868 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3869 INSERT INTO t4 (c1) VALUES(10);
3870 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3871 SELECT t1.c1,t6.c1 FROM t1,t6 WHERE t1.c1 >= t6.c1;
3872 c1 c1
3873 DROP TABLE t1,t2,t3,t4,t5,t6;
3874 CREATE TABLE t1 (c1 INTEGER NOT NULL);
3875 CREATE TABLE t2 (c1 INTEGER NOT NULL);
3876 CREATE TABLE t3 (c1 INTEGER NOT NULL);
3877 CREATE TABLE t4 (c1 INTEGER NOT NULL);
3878 CREATE TABLE t5 (c1 INTEGER NOT NULL);
3879 CREATE TABLE t6 (c1 INTEGER NOT NULL);
3880 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3881 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3882 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3883 INSERT INTO t4 (c1) VALUES(10);
3884 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3885 SELECT t1.c1,t6.c1 FROM t1,t6 WHERE t1.c1 >= t6.c1;
3886 c1 c1
3887 DROP TABLE t1,t2,t3,t4,t5,t6;
3888 CREATE TABLE t1 (c1 BIGINT NOT NULL);
3889 CREATE TABLE t2 (c1 BIGINT NOT NULL);
3890 CREATE TABLE t3 (c1 BIGINT NOT NULL);
3891 CREATE TABLE t4 (c1 BIGINT NOT NULL);
3892 CREATE TABLE t5 (c1 BIGINT NOT NULL);
3893 CREATE TABLE t6 (c1 BIGINT NOT NULL);
3894 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3895 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3896 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3897 INSERT INTO t4 (c1) VALUES(10);
3898 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3899 SELECT t1.c1,t6.c1 FROM t1,t6 WHERE t1.c1 >= t6.c1;
3900 c1 c1
3901 DROP TABLE t1,t2,t3,t4,t5,t6;
3902 CREATE TABLE t1 (c1 TINYINT NOT NULL);
3903 CREATE TABLE t2 (c1 TINYINT NOT NULL);
3904 CREATE TABLE t3 (c1 TINYINT NOT NULL);
3905 CREATE TABLE t4 (c1 TINYINT NOT NULL);
3906 CREATE TABLE t5 (c1 TINYINT NOT NULL);
3907 CREATE TABLE t6 (c1 TINYINT NOT NULL);
3908 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3909 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3910 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3911 INSERT INTO t4 (c1) VALUES(10);
3912 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3913 SELECT t1.c1,t2.c1 FROM t1,t2 WHERE t1.c1 != t2.c1;
3914 c1 c1
3915 1 0
3916 2 0
3917 3 0
3918 4 0
3919 5 0
3920 6 0
3921 7 0
3922 8 0
3923 9 0
3924 0 1
3925 2 1
3926 3 1
3927 4 1
3928 5 1
3929 6 1
3930 7 1
3931 8 1
3932 9 1
3933 0 2
3934 1 2
3935 3 2
3936 4 2
3937 5 2
3938 6 2
3939 7 2
3940 8 2
3941 9 2
3942 0 3
3943 1 3
3944 2 3
3945 4 3
3946 5 3
3947 6 3
3948 7 3
3949 8 3
3950 9 3
3951 0 4
3952 1 4
3953 2 4
3954 3 4
3955 5 4
3956 6 4
3957 7 4
3958 8 4
3959 9 4
3960 0 5
3961 1 5
3962 2 5
3963 3 5
3964 4 5
3965 6 5
3966 7 5
3967 8 5
3968 9 5
3969 0 6
3970 1 6
3971 2 6
3972 3 6
3973 4 6
3974 5 6
3975 7 6
3976 8 6
3977 9 6
3978 0 7
3979 1 7
3980 2 7
3981 3 7
3982 4 7
3983 5 7
3984 6 7
3985 8 7
3986 9 7
3987 0 8
3988 1 8
3989 2 8
3990 3 8
3991 4 8
3992 5 8
3993 6 8
3994 7 8
3995 9 8
3996 0 9
3997 1 9
3998 2 9
3999 3 9
4000 4 9
4001 5 9
4002 6 9
4003 7 9
4004 8 9
4005 DROP TABLE t1,t2,t3,t4,t5,t6;
4006 CREATE TABLE t1 (c1 SMALLINT NOT NULL);
4007 CREATE TABLE t2 (c1 SMALLINT NOT NULL);
4008 CREATE TABLE t3 (c1 SMALLINT NOT NULL);
4009 CREATE TABLE t4 (c1 SMALLINT NOT NULL);
4010 CREATE TABLE t5 (c1 SMALLINT NOT NULL);
4011 CREATE TABLE t6 (c1 SMALLINT NOT NULL);
4012 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4013 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4014 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
4015 INSERT INTO t4 (c1) VALUES(10);
4016 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
4017 SELECT t1.c1,t2.c1 FROM t1,t2 WHERE t1.c1 != t2.c1;
4018 c1 c1
4019 1 0
4020 2 0
4021 3 0
4022 4 0
4023 5 0
4024 6 0
4025 7 0
4026 8 0
4027 9 0
4028 0 1
4029 2 1
4030 3 1
4031 4 1
4032 5 1
4033 6 1
4034 7 1
4035 8 1
4036 9 1
4037 0 2
4038 1 2
4039 3 2
4040 4 2
4041 5 2
4042 6 2
4043 7 2
4044 8 2
4045 9 2
4046 0 3
4047 1 3
4048 2 3
4049 4 3
4050 5 3
4051 6 3
4052 7 3
4053 8 3
4054 9 3
4055 0 4
4056 1 4
4057 2 4
4058 3 4
4059 5 4
4060 6 4
4061 7 4
4062 8 4
4063 9 4
4064 0 5
4065 1 5
4066 2 5
4067 3 5
4068 4 5
4069 6 5
4070 7 5
4071 8 5
4072 9 5
4073 0 6
4074 1 6
4075 2 6
4076 3 6
4077 4 6
4078 5 6
4079 7 6
4080 8 6
4081 9 6
4082 0 7
4083 1 7
4084 2 7
4085 3 7
4086 4 7
4087 5 7
4088 6 7
4089 8 7
4090 9 7
4091 0 8
4092 1 8
4093 2 8
4094 3 8
4095 4 8
4096 5 8
4097 6 8
4098 7 8
4099 9 8
4100 0 9
4101 1 9
4102 2 9
4103 3 9
4104 4 9
4105 5 9
4106 6 9
4107 7 9
4108 8 9
4109 DROP TABLE t1,t2,t3,t4,t5,t6;
4110 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
4111 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
4112 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
4113 CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
4114 CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
4115 CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
4116 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4117 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4118 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
4119 INSERT INTO t4 (c1) VALUES(10);
4120 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
4121 SELECT t1.c1,t2.c1 FROM t1,t2 WHERE t1.c1 != t2.c1;
4122 c1 c1
4123 1 0
4124 2 0
4125 3 0
4126 4 0
4127 5 0
4128 6 0
4129 7 0
4130 8 0
4131 9 0
4132 0 1
4133 2 1
4134 3 1
4135 4 1
4136 5 1
4137 6 1
4138 7 1
4139 8 1
4140 9 1
4141 0 2
4142 1 2
4143 3 2
4144 4 2
4145 5 2
4146 6 2
4147 7 2
4148 8 2
4149 9 2
4150 0 3
4151 1 3
4152 2 3
4153 4 3
4154 5 3
4155 6 3
4156 7 3
4157 8 3
4158 9 3
4159 0 4
4160 1 4
4161 2 4
4162 3 4
4163 5 4
4164 6 4
4165 7 4
4166 8 4
4167 9 4
4168 0 5
4169 1 5
4170 2 5
4171 3 5
4172 4 5
4173 6 5
4174 7 5
4175 8 5
4176 9 5
4177 0 6
4178 1 6
4179 2 6
4180 3 6
4181 4 6
4182 5 6
4183 7 6
4184 8 6
4185 9 6
4186 0 7
4187 1 7
4188 2 7
4189 3 7
4190 4 7
4191 5 7
4192 6 7
4193 8 7
4194 9 7
4195 0 8
4196 1 8
4197 2 8
4198 3 8
4199 4 8
4200 5 8
4201 6 8
4202 7 8
4203 9 8
4204 0 9
4205 1 9
4206 2 9
4207 3 9
4208 4 9
4209 5 9
4210 6 9
4211 7 9
4212 8 9
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,t2.c1 FROM t1,t2 WHERE t1.c1 != t2.c1;
4226 c1 c1
4227 1 0
4228 2 0
4229 3 0
4230 4 0
4231 5 0
4232 6 0
4233 7 0
4234 8 0
4235 9 0
4236 0 1
4237 2 1
4238 3 1
4239 4 1
4240 5 1
4241 6 1
4242 7 1
4243 8 1
4244 9 1
4245 0 2
4246 1 2
4247 3 2
4248 4 2
4249 5 2
4250 6 2
4251 7 2
4252 8 2
4253 9 2
4254 0 3
4255 1 3
4256 2 3
4257 4 3
4258 5 3
4259 6 3
4260 7 3
4261 8 3
4262 9 3
4263 0 4
4264 1 4
4265 2 4
4266 3 4
4267 5 4
4268 6 4
4269 7 4
4270 8 4
4271 9 4
4272 0 5
4273 1 5
4274 2 5
4275 3 5
4276 4 5
4277 6 5
4278 7 5
4279 8 5
4280 9 5
4281 0 6
4282 1 6
4283 2 6
4284 3 6
4285 4 6
4286 5 6
4287 7 6
4288 8 6
4289 9 6
4290 0 7
4291 1 7
4292 2 7
4293 3 7
4294 4 7
4295 5 7
4296 6 7
4297 8 7
4298 9 7
4299 0 8
4300 1 8
4301 2 8
4302 3 8
4303 4 8
4304 5 8
4305 6 8
4306 7 8
4307 9 8
4308 0 9
4309 1 9
4310 2 9
4311 3 9
4312 4 9
4313 5 9
4314 6 9
4315 7 9
4316 8 9
4317 DROP TABLE t1,t2,t3,t4,t5,t6;
4318 CREATE TABLE t1 (c1 INTEGER NOT NULL);
4319 CREATE TABLE t2 (c1 INTEGER NOT NULL);
4320 CREATE TABLE t3 (c1 INTEGER NOT NULL);
4321 CREATE TABLE t4 (c1 INTEGER NOT NULL);
4322 CREATE TABLE t5 (c1 INTEGER NOT NULL);
4323 CREATE TABLE t6 (c1 INTEGER NOT NULL);
4324 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4325 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4326 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
4327 INSERT INTO t4 (c1) VALUES(10);
4328 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
4329 SELECT t1.c1,t2.c1 FROM t1,t2 WHERE t1.c1 != t2.c1;
4330 c1 c1
4331 1 0
4332 2 0
4333 3 0
4334 4 0
4335 5 0
4336 6 0
4337 7 0
4338 8 0
4339 9 0
4340 0 1
4341 2 1
4342 3 1
4343 4 1
4344 5 1
4345 6 1
4346 7 1
4347 8 1
4348 9 1
4349 0 2
4350 1 2
4351 3 2
4352 4 2
4353 5 2
4354 6 2
4355 7 2
4356 8 2
4357 9 2
4358 0 3
4359 1 3
4360 2 3
4361 4 3
4362 5 3
4363 6 3
4364 7 3
4365 8 3
4366 9 3
4367 0 4
4368 1 4
4369 2 4
4370 3 4
4371 5 4
4372 6 4
4373 7 4
4374 8 4
4375 9 4
4376 0 5
4377 1 5
4378 2 5
4379 3 5
4380 4 5
4381 6 5
4382 7 5
4383 8 5
4384 9 5
4385 0 6
4386 1 6
4387 2 6
4388 3 6
4389 4 6
4390 5 6
4391 7 6
4392 8 6
4393 9 6
4394 0 7
4395 1 7
4396 2 7
4397 3 7
4398 4 7
4399 5 7
4400 6 7
4401 8 7
4402 9 7
4403 0 8
4404 1 8
4405 2 8
4406 3 8
4407 4 8
4408 5 8
4409 6 8
4410 7 8
4411 9 8
4412 0 9
4413 1 9
4414 2 9
4415 3 9
4416 4 9
4417 5 9
4418 6 9
4419 7 9
4420 8 9
4421 DROP TABLE t1,t2,t3,t4,t5,t6;
4422 CREATE TABLE t1 (c1 BIGINT NOT NULL);
4423 CREATE TABLE t2 (c1 BIGINT NOT NULL);
4424 CREATE TABLE t3 (c1 BIGINT NOT NULL);
4425 CREATE TABLE t4 (c1 BIGINT NOT NULL);
4426 CREATE TABLE t5 (c1 BIGINT NOT NULL);
4427 CREATE TABLE t6 (c1 BIGINT NOT NULL);
4428 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4429 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4430 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
4431 INSERT INTO t4 (c1) VALUES(10);
4432 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
4433 SELECT t1.c1,t2.c1 FROM t1,t2 WHERE t1.c1 != t2.c1;
4434 c1 c1
4435 1 0
4436 2 0
4437 3 0
4438 4 0
4439 5 0
4440 6 0
4441 7 0
4442 8 0
4443 9 0
4444 0 1
4445 2 1
4446 3 1
4447 4 1
4448 5 1
4449 6 1
4450 7 1
4451 8 1
4452 9 1
4453 0 2
4454 1 2
4455 3 2
4456 4 2
4457 5 2
4458 6 2
4459 7 2
4460 8 2
4461 9 2
4462 0 3
4463 1 3
4464 2 3
4465 4 3
4466 5 3
4467 6 3
4468 7 3
4469 8 3
4470 9 3
4471 0 4
4472 1 4
4473 2 4
4474 3 4
4475 5 4
4476 6 4
4477 7 4
4478 8 4
4479 9 4
4480 0 5
4481 1 5
4482 2 5
4483 3 5
4484 4 5
4485 6 5
4486 7 5
4487 8 5
4488 9 5
4489 0 6
4490 1 6
4491 2 6
4492 3 6
4493 4 6
4494 5 6
4495 7 6
4496 8 6
4497 9 6
4498 0 7
4499 1 7
4500 2 7
4501 3 7
4502 4 7
4503 5 7
4504 6 7
4505 8 7
4506 9 7
4507 0 8
4508 1 8
4509 2 8
4510 3 8
4511 4 8
4512 5 8
4513 6 8
4514 7 8
4515 9 8
4516 0 9
4517 1 9
4518 2 9
4519 3 9
4520 4 9
4521 5 9
4522 6 9
4523 7 9
4524 8 9
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,t3.c1 FROM t1,t3 WHERE t1.c1 != t3.c1;
4538 c1 c1
4539 0 1
4540 0 3
4541 0 5
4542 0 7
4543 0 9
4544 1 3
4545 1 5
4546 1 7
4547 1 9
4548 2 1
4549 2 3
4550 2 5
4551 2 7
4552 2 9
4553 3 1
4554 3 5
4555 3 7
4556 3 9
4557 4 1
4558 4 3
4559 4 5
4560 4 7
4561 4 9
4562 5 1
4563 5 3
4564 5 7
4565 5 9
4566 6 1
4567 6 3
4568 6 5
4569 6 7
4570 6 9
4571 7 1
4572 7 3
4573 7 5
4574 7 9
4575 8 1
4576 8 3
4577 8 5
4578 8 7
4579 8 9
4580 9 1
4581 9 3
4582 9 5
4583 9 7
4584 DROP TABLE t1,t2,t3,t4,t5,t6;
4585 CREATE TABLE t1 (c1 SMALLINT NOT NULL);
4586 CREATE TABLE t2 (c1 SMALLINT NOT NULL);
4587 CREATE TABLE t3 (c1 SMALLINT NOT NULL);
4588 CREATE TABLE t4 (c1 SMALLINT NOT NULL);
4589 CREATE TABLE t5 (c1 SMALLINT NOT NULL);
4590 CREATE TABLE t6 (c1 SMALLINT NOT NULL);
4591 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4592 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4593 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
4594 INSERT INTO t4 (c1) VALUES(10);
4595 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
4596 SELECT t1.c1,t3.c1 FROM t1,t3 WHERE t1.c1 != t3.c1;
4597 c1 c1
4598 0 1
4599 0 3
4600 0 5
4601 0 7
4602 0 9
4603 1 3
4604 1 5
4605 1 7
4606 1 9
4607 2 1
4608 2 3
4609 2 5
4610 2 7
4611 2 9
4612 3 1
4613 3 5
4614 3 7
4615 3 9
4616 4 1
4617 4 3
4618 4 5
4619 4 7
4620 4 9
4621 5 1
4622 5 3
4623 5 7
4624 5 9
4625 6 1
4626 6 3
4627 6 5
4628 6 7
4629 6 9
4630 7 1
4631 7 3
4632 7 5
4633 7 9
4634 8 1
4635 8 3
4636 8 5
4637 8 7
4638 8 9
4639 9 1
4640 9 3
4641 9 5
4642 9 7
4643 DROP TABLE t1,t2,t3,t4,t5,t6;
4644 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
4645 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
4646 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
4647 CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
4648 CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
4649 CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
4650 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4651 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4652 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
4653 INSERT INTO t4 (c1) VALUES(10);
4654 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
4655 SELECT t1.c1,t3.c1 FROM t1,t3 WHERE t1.c1 != t3.c1;
4656 c1 c1
4657 0 1
4658 0 3
4659 0 5
4660 0 7
4661 0 9
4662 1 3
4663 1 5
4664 1 7
4665 1 9
4666 2 1
4667 2 3
4668 2 5
4669 2 7
4670 2 9
4671 3 1
4672 3 5
4673 3 7
4674 3 9
4675 4 1
4676 4 3
4677 4 5
4678 4 7
4679 4 9
4680 5 1
4681 5 3
4682 5 7
4683 5 9
4684 6 1
4685 6 3
4686 6 5
4687 6 7
4688 6 9
4689 7 1
4690 7 3
4691 7 5
4692 7 9
4693 8 1
4694 8 3
4695 8 5
4696 8 7
4697 8 9
4698 9 1
4699 9 3
4700 9 5
4701 9 7
4702 DROP TABLE t1,t2,t3,t4,t5,t6;
4703 CREATE TABLE t1 (c1 INT NOT NULL);
4704 CREATE TABLE t2 (c1 INT NOT NULL);
4705 CREATE TABLE t3 (c1 INT NOT NULL);
4706 CREATE TABLE t4 (c1 INT NOT NULL);
4707 CREATE TABLE t5 (c1 INT NOT NULL);
4708 CREATE TABLE t6 (c1 INT NOT NULL);
4709 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4710 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4711 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
4712 INSERT INTO t4 (c1) VALUES(10);
4713 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
4714 SELECT t1.c1,t3.c1 FROM t1,t3 WHERE t1.c1 != t3.c1;
4715 c1 c1
4716 0 1
4717 0 3
4718 0 5
4719 0 7
4720 0 9
4721 1 3
4722 1 5
4723 1 7
4724 1 9
4725 2 1
4726 2 3
4727 2 5
4728 2 7
4729 2 9
4730 3 1
4731 3 5
4732 3 7
4733 3 9
4734 4 1
4735 4 3
4736 4 5
4737 4 7
4738 4 9
4739 5 1
4740 5 3
4741 5 7
4742 5 9
4743 6 1
4744 6 3
4745 6 5
4746 6 7
4747 6 9
4748 7 1
4749 7 3
4750 7 5
4751 7 9
4752 8 1
4753 8 3
4754 8 5
4755 8 7
4756 8 9
4757 9 1
4758 9 3
4759 9 5
4760 9 7
4761 DROP TABLE t1,t2,t3,t4,t5,t6;
4762 CREATE TABLE t1 (c1 INTEGER NOT NULL);
4763 CREATE TABLE t2 (c1 INTEGER NOT NULL);
4764 CREATE TABLE t3 (c1 INTEGER NOT NULL);
4765 CREATE TABLE t4 (c1 INTEGER NOT NULL);
4766 CREATE TABLE t5 (c1 INTEGER NOT NULL);
4767 CREATE TABLE t6 (c1 INTEGER NOT NULL);
4768 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4769 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4770 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
4771 INSERT INTO t4 (c1) VALUES(10);
4772 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
4773 SELECT t1.c1,t3.c1 FROM t1,t3 WHERE t1.c1 != t3.c1;
4774 c1 c1
4775 0 1
4776 0 3
4777 0 5
4778 0 7
4779 0 9
4780 1 3
4781 1 5
4782 1 7
4783 1 9
4784 2 1
4785 2 3
4786 2 5
4787 2 7
4788 2 9
4789 3 1
4790 3 5
4791 3 7
4792 3 9
4793 4 1
4794 4 3
4795 4 5
4796 4 7
4797 4 9
4798 5 1
4799 5 3
4800 5 7
4801 5 9
4802 6 1
4803 6 3
4804 6 5
4805 6 7
4806 6 9
4807 7 1
4808 7 3
4809 7 5
4810 7 9
4811 8 1
4812 8 3
4813 8 5
4814 8 7
4815 8 9
4816 9 1
4817 9 3
4818 9 5
4819 9 7
4820 DROP TABLE t1,t2,t3,t4,t5,t6;
4821 CREATE TABLE t1 (c1 BIGINT NOT NULL);
4822 CREATE TABLE t2 (c1 BIGINT NOT NULL);
4823 CREATE TABLE t3 (c1 BIGINT NOT NULL);
4824 CREATE TABLE t4 (c1 BIGINT NOT NULL);
4825 CREATE TABLE t5 (c1 BIGINT NOT NULL);
4826 CREATE TABLE t6 (c1 BIGINT NOT NULL);
4827 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4828 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4829 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
4830 INSERT INTO t4 (c1) VALUES(10);
4831 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
4832 SELECT t1.c1,t3.c1 FROM t1,t3 WHERE t1.c1 != t3.c1;
4833 c1 c1
4834 0 1
4835 0 3
4836 0 5
4837 0 7
4838 0 9
4839 1 3
4840 1 5
4841 1 7
4842 1 9
4843 2 1
4844 2 3
4845 2 5
4846 2 7
4847 2 9
4848 3 1
4849 3 5
4850 3 7
4851 3 9
4852 4 1
4853 4 3
4854 4 5
4855 4 7
4856 4 9
4857 5 1
4858 5 3
4859 5 7
4860 5 9
4861 6 1
4862 6 3
4863 6 5
4864 6 7
4865 6 9
4866 7 1
4867 7 3
4868 7 5
4869 7 9
4870 8 1
4871 8 3
4872 8 5
4873 8 7
4874 8 9
4875 9 1
4876 9 3
4877 9 5
4878 9 7
4879 DROP TABLE t1,t2,t3,t4,t5,t6;
4880 CREATE TABLE t1 (c1 TINYINT NOT NULL);
4881 CREATE TABLE t2 (c1 TINYINT NOT NULL);
4882 CREATE TABLE t3 (c1 TINYINT NOT NULL);
4883 CREATE TABLE t4 (c1 TINYINT NOT NULL);
4884 CREATE TABLE t5 (c1 TINYINT NOT NULL);
4885 CREATE TABLE t6 (c1 TINYINT NOT NULL);
4886 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4887 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4888 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
4889 INSERT INTO t4 (c1) VALUES(10);
4890 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
4891 SELECT t1.c1,t4.c1 FROM t1,t4 WHERE t1.c1 != t4.c1;
4892 c1 c1
4893 0 10
4894 1 10
4895 2 10
4896 3 10
4897 4 10
4898 5 10
4899 6 10
4900 7 10
4901 8 10
4902 9 10
4903 DROP TABLE t1,t2,t3,t4,t5,t6;
4904 CREATE TABLE t1 (c1 SMALLINT NOT NULL);
4905 CREATE TABLE t2 (c1 SMALLINT NOT NULL);
4906 CREATE TABLE t3 (c1 SMALLINT NOT NULL);
4907 CREATE TABLE t4 (c1 SMALLINT NOT NULL);
4908 CREATE TABLE t5 (c1 SMALLINT NOT NULL);
4909 CREATE TABLE t6 (c1 SMALLINT NOT NULL);
4910 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4911 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4912 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
4913 INSERT INTO t4 (c1) VALUES(10);
4914 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
4915 SELECT t1.c1,t4.c1 FROM t1,t4 WHERE t1.c1 != t4.c1;
4916 c1 c1
4917 0 10
4918 1 10
4919 2 10
4920 3 10
4921 4 10
4922 5 10
4923 6 10
4924 7 10
4925 8 10
4926 9 10
4927 DROP TABLE t1,t2,t3,t4,t5,t6;
4928 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
4929 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
4930 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
4931 CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
4932 CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
4933 CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
4934 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4935 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4936 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
4937 INSERT INTO t4 (c1) VALUES(10);
4938 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
4939 SELECT t1.c1,t4.c1 FROM t1,t4 WHERE t1.c1 != t4.c1;
4940 c1 c1
4941 0 10
4942 1 10
4943 2 10
4944 3 10
4945 4 10
4946 5 10
4947 6 10
4948 7 10
4949 8 10
4950 9 10
4951 DROP TABLE t1,t2,t3,t4,t5,t6;
4952 CREATE TABLE t1 (c1 INT NOT NULL);
4953 CREATE TABLE t2 (c1 INT NOT NULL);
4954 CREATE TABLE t3 (c1 INT NOT NULL);
4955 CREATE TABLE t4 (c1 INT NOT NULL);
4956 CREATE TABLE t5 (c1 INT NOT NULL);
4957 CREATE TABLE t6 (c1 INT NOT NULL);
4958 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4959 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4960 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
4961 INSERT INTO t4 (c1) VALUES(10);
4962 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
4963 SELECT t1.c1,t4.c1 FROM t1,t4 WHERE t1.c1 != t4.c1;
4964 c1 c1
4965 0 10
4966 1 10
4967 2 10
4968 3 10
4969 4 10
4970 5 10
4971 6 10
4972 7 10
4973 8 10
4974 9 10
4975 DROP TABLE t1,t2,t3,t4,t5,t6;
4976 CREATE TABLE t1 (c1 INTEGER NOT NULL);
4977 CREATE TABLE t2 (c1 INTEGER NOT NULL);
4978 CREATE TABLE t3 (c1 INTEGER NOT NULL);
4979 CREATE TABLE t4 (c1 INTEGER NOT NULL);
4980 CREATE TABLE t5 (c1 INTEGER NOT NULL);
4981 CREATE TABLE t6 (c1 INTEGER NOT NULL);
4982 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4983 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4984 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
4985 INSERT INTO t4 (c1) VALUES(10);
4986 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
4987 SELECT t1.c1,t4.c1 FROM t1,t4 WHERE t1.c1 != t4.c1;
4988 c1 c1
4989 0 10
4990 1 10
4991 2 10
4992 3 10
4993 4 10
4994 5 10
4995 6 10
4996 7 10
4997 8 10
4998 9 10
4999 DROP TABLE t1,t2,t3,t4,t5,t6;
5000 CREATE TABLE t1 (c1 BIGINT NOT NULL);
5001 CREATE TABLE t2 (c1 BIGINT NOT NULL);
5002 CREATE TABLE t3 (c1 BIGINT NOT NULL);
5003 CREATE TABLE t4 (c1 BIGINT NOT NULL);
5004 CREATE TABLE t5 (c1 BIGINT NOT NULL);
5005 CREATE TABLE t6 (c1 BIGINT NOT NULL);
5006 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5007 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5008 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
5009 INSERT INTO t4 (c1) VALUES(10);
5010 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
5011 SELECT t1.c1,t4.c1 FROM t1,t4 WHERE t1.c1 != t4.c1;
5012 c1 c1
5013 0 10
5014 1 10
5015 2 10
5016 3 10
5017 4 10
5018 5 10
5019 6 10
5020 7 10
5021 8 10
5022 9 10
5023 DROP TABLE t1,t2,t3,t4,t5,t6;
5024 CREATE TABLE t1 (c1 TINYINT NOT NULL);
5025 CREATE TABLE t2 (c1 TINYINT NOT NULL);
5026 CREATE TABLE t3 (c1 TINYINT NOT NULL);
5027 CREATE TABLE t4 (c1 TINYINT NOT NULL);
5028 CREATE TABLE t5 (c1 TINYINT NOT NULL);
5029 CREATE TABLE t6 (c1 TINYINT NOT NULL);
5030 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5031 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5032 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
5033 INSERT INTO t4 (c1) VALUES(10);
5034 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
5035 SELECT t1.c1,t5.c1 FROM t1,t5 WHERE t1.c1 != t5.c1;
5036 c1 c1
5037 0 10
5038 0 11
5039 0 12
5040 0 13
5041 0 14
5042 1 10
5043 1 11
5044 1 12
5045 1 13
5046 1 14
5047 2 10
5048 2 11
5049 2 12
5050 2 13
5051 2 14
5052 3 10
5053 3 11
5054 3 12
5055 3 13
5056 3 14
5057 4 10
5058 4 11
5059 4 12
5060 4 13
5061 4 14
5062 5 10
5063 5 11
5064 5 12
5065 5 13
5066 5 14
5067 6 10
5068 6 11
5069 6 12
5070 6 13
5071 6 14
5072 7 10
5073 7 11
5074 7 12
5075 7 13
5076 7 14
5077 8 10
5078 8 11
5079 8 12
5080 8 13
5081 8 14
5082 9 10
5083 9 11
5084 9 12
5085 9 13
5086 9 14
5087 DROP TABLE t1,t2,t3,t4,t5,t6;
5088 CREATE TABLE t1 (c1 SMALLINT NOT NULL);
5089 CREATE TABLE t2 (c1 SMALLINT NOT NULL);
5090 CREATE TABLE t3 (c1 SMALLINT NOT NULL);
5091 CREATE TABLE t4 (c1 SMALLINT NOT NULL);
5092 CREATE TABLE t5 (c1 SMALLINT NOT NULL);
5093 CREATE TABLE t6 (c1 SMALLINT NOT NULL);
5094 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5095 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5096 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
5097 INSERT INTO t4 (c1) VALUES(10);
5098 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
5099 SELECT t1.c1,t5.c1 FROM t1,t5 WHERE t1.c1 != t5.c1;
5100 c1 c1
5101 0 10
5102 0 11
5103 0 12
5104 0 13
5105 0 14
5106 1 10
5107 1 11
5108 1 12
5109 1 13
5110 1 14
5111 2 10
5112 2 11
5113 2 12
5114 2 13
5115 2 14
5116 3 10
5117 3 11
5118 3 12
5119 3 13
5120 3 14
5121 4 10
5122 4 11
5123 4 12
5124 4 13
5125 4 14
5126 5 10
5127 5 11
5128 5 12
5129 5 13
5130 5 14
5131 6 10
5132 6 11
5133 6 12
5134 6 13
5135 6 14
5136 7 10
5137 7 11
5138 7 12
5139 7 13
5140 7 14
5141 8 10
5142 8 11
5143 8 12
5144 8 13
5145 8 14
5146 9 10
5147 9 11
5148 9 12
5149 9 13
5150 9 14
5151 DROP TABLE t1,t2,t3,t4,t5,t6;
5152 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
5153 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
5154 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
5155 CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
5156 CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
5157 CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
5158 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5159 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5160 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
5161 INSERT INTO t4 (c1) VALUES(10);
5162 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
5163 SELECT t1.c1,t5.c1 FROM t1,t5 WHERE t1.c1 != t5.c1;
5164 c1 c1
5165 0 10
5166 0 11
5167 0 12
5168 0 13
5169 0 14
5170 1 10
5171 1 11
5172 1 12
5173 1 13
5174 1 14
5175 2 10
5176 2 11
5177 2 12
5178 2 13
5179 2 14
5180 3 10
5181 3 11
5182 3 12
5183 3 13
5184 3 14
5185 4 10
5186 4 11
5187 4 12
5188 4 13
5189 4 14
5190 5 10
5191 5 11
5192 5 12
5193 5 13
5194 5 14
5195 6 10
5196 6 11
5197 6 12
5198 6 13
5199 6 14
5200 7 10
5201 7 11
5202 7 12
5203 7 13
5204 7 14
5205 8 10
5206 8 11
5207 8 12
5208 8 13
5209 8 14
5210 9 10
5211 9 11
5212 9 12
5213 9 13
5214 9 14
5215 DROP TABLE t1,t2,t3,t4,t5,t6;
5216 CREATE TABLE t1 (c1 INT NOT NULL);
5217 CREATE TABLE t2 (c1 INT NOT NULL);
5218 CREATE TABLE t3 (c1 INT NOT NULL);
5219 CREATE TABLE t4 (c1 INT NOT NULL);
5220 CREATE TABLE t5 (c1 INT NOT NULL);
5221 CREATE TABLE t6 (c1 INT NOT NULL);
5222 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5223 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5224 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
5225 INSERT INTO t4 (c1) VALUES(10);
5226 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
5227 SELECT t1.c1,t5.c1 FROM t1,t5 WHERE t1.c1 != t5.c1;
5228 c1 c1
5229 0 10
5230 0 11
5231 0 12
5232 0 13
5233 0 14
5234 1 10
5235 1 11
5236 1 12
5237 1 13
5238 1 14
5239 2 10
5240 2 11
5241 2 12
5242 2 13
5243 2 14
5244 3 10
5245 3 11
5246 3 12
5247 3 13
5248 3 14
5249 4 10
5250 4 11
5251 4 12
5252 4 13
5253 4 14
5254 5 10
5255 5 11
5256 5 12
5257 5 13
5258 5 14
5259 6 10
5260 6 11
5261 6 12
5262 6 13
5263 6 14
5264 7 10
5265 7 11
5266 7 12
5267 7 13
5268 7 14
5269 8 10
5270 8 11
5271 8 12
5272 8 13
5273 8 14
5274 9 10
5275 9 11
5276 9 12
5277 9 13
5278 9 14
5279 DROP TABLE t1,t2,t3,t4,t5,t6;
5280 CREATE TABLE t1 (c1 INTEGER NOT NULL);
5281 CREATE TABLE t2 (c1 INTEGER NOT NULL);
5282 CREATE TABLE t3 (c1 INTEGER NOT NULL);
5283 CREATE TABLE t4 (c1 INTEGER NOT NULL);
5284 CREATE TABLE t5 (c1 INTEGER NOT NULL);
5285 CREATE TABLE t6 (c1 INTEGER NOT NULL);
5286 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5287 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5288 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
5289 INSERT INTO t4 (c1) VALUES(10);
5290 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
5291 SELECT t1.c1,t5.c1 FROM t1,t5 WHERE t1.c1 != t5.c1;
5292 c1 c1
5293 0 10
5294 0 11
5295 0 12
5296 0 13
5297 0 14
5298 1 10
5299 1 11
5300 1 12
5301 1 13
5302 1 14
5303 2 10
5304 2 11
5305 2 12
5306 2 13
5307 2 14
5308 3 10
5309 3 11
5310 3 12
5311 3 13
5312 3 14
5313 4 10
5314 4 11
5315 4 12
5316 4 13
5317 4 14
5318 5 10
5319 5 11
5320 5 12
5321 5 13
5322 5 14
5323 6 10
5324 6 11
5325 6 12
5326 6 13
5327 6 14
5328 7 10
5329 7 11
5330 7 12
5331 7 13
5332 7 14
5333 8 10
5334 8 11
5335 8 12
5336 8 13
5337 8 14
5338 9 10
5339 9 11
5340 9 12
5341 9 13
5342 9 14
5343 DROP TABLE t1,t2,t3,t4,t5,t6;
5344 CREATE TABLE t1 (c1 BIGINT NOT NULL);
5345 CREATE TABLE t2 (c1 BIGINT NOT NULL);
5346 CREATE TABLE t3 (c1 BIGINT NOT NULL);
5347 CREATE TABLE t4 (c1 BIGINT NOT NULL);
5348 CREATE TABLE t5 (c1 BIGINT NOT NULL);
5349 CREATE TABLE t6 (c1 BIGINT NOT NULL);
5350 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5351 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5352 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
5353 INSERT INTO t4 (c1) VALUES(10);
5354 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
5355 SELECT t1.c1,t5.c1 FROM t1,t5 WHERE t1.c1 != t5.c1;
5356 c1 c1
5357 0 10
5358 0 11
5359 0 12
5360 0 13
5361 0 14
5362 1 10
5363 1 11
5364 1 12
5365 1 13
5366 1 14
5367 2 10
5368 2 11
5369 2 12
5370 2 13
5371 2 14
5372 3 10
5373 3 11
5374 3 12
5375 3 13
5376 3 14
5377 4 10
5378 4 11
5379 4 12
5380 4 13
5381 4 14
5382 5 10
5383 5 11
5384 5 12
5385 5 13
5386 5 14
5387 6 10
5388 6 11
5389 6 12
5390 6 13
5391 6 14
5392 7 10
5393 7 11
5394 7 12
5395 7 13
5396 7 14
5397 8 10
5398 8 11
5399 8 12
5400 8 13
5401 8 14
5402 9 10
5403 9 11
5404 9 12
5405 9 13
5406 9 14
5407 DROP TABLE t1,t2,t3,t4,t5,t6;
5408 CREATE TABLE t1 (c1 TINYINT NOT NULL);
5409 CREATE TABLE t2 (c1 TINYINT NOT NULL);
5410 CREATE TABLE t3 (c1 TINYINT NOT NULL);
5411 CREATE TABLE t4 (c1 TINYINT NOT NULL);
5412 CREATE TABLE t5 (c1 TINYINT NOT NULL);
5413 CREATE TABLE t6 (c1 TINYINT NOT NULL);
5414 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5415 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5416 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
5417 INSERT INTO t4 (c1) VALUES(10);
5418 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
5419 SELECT t1.c1,t6.c1 FROM t1,t6 WHERE t1.c1 != t6.c1;
5420 c1 c1
5421 DROP TABLE t1,t2,t3,t4,t5,t6;
5422 CREATE TABLE t1 (c1 SMALLINT NOT NULL);
5423 CREATE TABLE t2 (c1 SMALLINT NOT NULL);
5424 CREATE TABLE t3 (c1 SMALLINT NOT NULL);
5425 CREATE TABLE t4 (c1 SMALLINT NOT NULL);
5426 CREATE TABLE t5 (c1 SMALLINT NOT NULL);
5427 CREATE TABLE t6 (c1 SMALLINT NOT NULL);
5428 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5429 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5430 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
5431 INSERT INTO t4 (c1) VALUES(10);
5432 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
5433 SELECT t1.c1,t6.c1 FROM t1,t6 WHERE t1.c1 != t6.c1;
5434 c1 c1
5435 DROP TABLE t1,t2,t3,t4,t5,t6;
5436 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
5437 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
5438 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
5439 CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
5440 CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
5441 CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
5442 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5443 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5444 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
5445 INSERT INTO t4 (c1) VALUES(10);
5446 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
5447 SELECT t1.c1,t6.c1 FROM t1,t6 WHERE t1.c1 != t6.c1;
5448 c1 c1
5449 DROP TABLE t1,t2,t3,t4,t5,t6;
5450 CREATE TABLE t1 (c1 INT NOT NULL);
5451 CREATE TABLE t2 (c1 INT NOT NULL);
5452 CREATE TABLE t3 (c1 INT NOT NULL);
5453 CREATE TABLE t4 (c1 INT NOT NULL);
5454 CREATE TABLE t5 (c1 INT NOT NULL);
5455 CREATE TABLE t6 (c1 INT NOT NULL);
5456 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5457 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5458 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
5459 INSERT INTO t4 (c1) VALUES(10);
5460 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
5461 SELECT t1.c1,t6.c1 FROM t1,t6 WHERE t1.c1 != t6.c1;
5462 c1 c1
5463 DROP TABLE t1,t2,t3,t4,t5,t6;
5464 CREATE TABLE t1 (c1 INTEGER NOT NULL);
5465 CREATE TABLE t2 (c1 INTEGER NOT NULL);
5466 CREATE TABLE t3 (c1 INTEGER NOT NULL);
5467 CREATE TABLE t4 (c1 INTEGER NOT NULL);
5468 CREATE TABLE t5 (c1 INTEGER NOT NULL);
5469 CREATE TABLE t6 (c1 INTEGER NOT NULL);
5470 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5471 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5472 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
5473 INSERT INTO t4 (c1) VALUES(10);
5474 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
5475 SELECT t1.c1,t6.c1 FROM t1,t6 WHERE t1.c1 != t6.c1;
5476 c1 c1
5477 DROP TABLE t1,t2,t3,t4,t5,t6;
5478 CREATE TABLE t1 (c1 BIGINT NOT NULL);
5479 CREATE TABLE t2 (c1 BIGINT NOT NULL);
5480 CREATE TABLE t3 (c1 BIGINT NOT NULL);
5481 CREATE TABLE t4 (c1 BIGINT NOT NULL);
5482 CREATE TABLE t5 (c1 BIGINT NOT NULL);
5483 CREATE TABLE t6 (c1 BIGINT NOT NULL);
5484 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5485 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5486 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
5487 INSERT INTO t4 (c1) VALUES(10);
5488 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
5489 SELECT t1.c1,t6.c1 FROM t1,t6 WHERE t1.c1 != t6.c1;
5490 c1 c1
5491 DROP TABLE t1,t2,t3,t4,t5,t6;
5492 CREATE TABLE t1 (c1 TINYINT NOT NULL);
5493 CREATE TABLE t2 (c1 TINYINT NOT NULL);
5494 CREATE TABLE t3 (c1 TINYINT NOT NULL);
5495 CREATE TABLE t4 (c1 TINYINT NOT NULL);
5496 CREATE TABLE t5 (c1 TINYINT NOT NULL);
5497 CREATE TABLE t6 (c1 TINYINT NOT NULL);
5498 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5499 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5500 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
5501 INSERT INTO t4 (c1) VALUES(10);
5502 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
5503 SELECT t1.c1,t2.c1 FROM t1,t2 WHERE t1.c1 <> t2.c1;
5504 c1 c1
5505 1 0
5506 2 0
5507 3 0
5508 4 0
5509 5 0
5510 6 0
5511 7 0
5512 8 0
5513 9 0
5514 0 1
5515 2 1
5516 3 1
5517 4 1
5518 5 1
5519 6 1
5520 7 1
5521 8 1
5522 9 1
5523 0 2
5524 1 2
5525 3 2
5526 4 2
5527 5 2
5528 6 2
5529 7 2
5530 8 2
5531 9 2
5532 0 3
5533 1 3
5534 2 3
5535 4 3
5536 5 3
5537 6 3
5538 7 3
5539 8 3
5540 9 3
5541 0 4
5542 1 4
5543 2 4
5544 3 4
5545 5 4
5546 6 4
5547 7 4
5548 8 4
5549 9 4
5550 0 5
5551 1 5
5552 2 5
5553 3 5
5554 4 5
5555 6 5
5556 7 5
5557 8 5
5558 9 5
5559 0 6
5560 1 6
5561 2 6
5562 3 6
5563 4 6
5564 5 6
5565 7 6
5566 8 6
5567 9 6
5568 0 7
5569 1 7
5570 2 7
5571 3 7
5572 4 7
5573 5 7
5574 6 7
5575 8 7
5576 9 7
5577 0 8
5578 1 8
5579 2 8
5580 3 8
5581 4 8
5582 5 8
5583 6 8
5584 7 8
5585 9 8
5586 0 9
5587 1 9
5588 2 9
5589 3 9
5590 4 9
5591 5 9
5592 6 9
5593 7 9
5594 8 9
5595 DROP TABLE t1,t2,t3,t4,t5,t6;
5596 CREATE TABLE t1 (c1 SMALLINT NOT NULL);
5597 CREATE TABLE t2 (c1 SMALLINT NOT NULL);
5598 CREATE TABLE t3 (c1 SMALLINT NOT NULL);
5599 CREATE TABLE t4 (c1 SMALLINT NOT NULL);
5600 CREATE TABLE t5 (c1 SMALLINT NOT NULL);
5601 CREATE TABLE t6 (c1 SMALLINT NOT NULL);
5602 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5603 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5604 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
5605 INSERT INTO t4 (c1) VALUES(10);
5606 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
5607 SELECT t1.c1,t2.c1 FROM t1,t2 WHERE t1.c1 <> t2.c1;
5608 c1 c1
5609 1 0
5610 2 0
5611 3 0
5612 4 0
5613 5 0
5614 6 0
5615 7 0
5616 8 0
5617 9 0
5618 0 1
5619 2 1
5620 3 1
5621 4 1
5622 5 1
5623 6 1
5624 7 1
5625 8 1
5626 9 1
5627 0 2
5628 1 2
5629 3 2
5630 4 2
5631 5 2
5632 6 2
5633 7 2
5634 8 2
5635 9 2
5636 0 3
5637 1 3
5638 2 3
5639 4 3
5640 5 3
5641 6 3
5642 7 3
5643 8 3
5644 9 3
5645 0 4
5646 1 4
5647 2 4
5648 3 4
5649 5 4
5650 6 4
5651 7 4
5652 8 4
5653 9 4
5654 0 5
5655 1 5
5656 2 5
5657 3 5
5658 4 5
5659 6 5
5660 7 5
5661 8 5
5662 9 5
5663 0 6
5664 1 6
5665 2 6
5666 3 6
5667 4 6
5668 5 6
5669 7 6
5670 8 6
5671 9 6
5672 0 7
5673 1 7
5674 2 7
5675 3 7
5676 4 7
5677 5 7
5678 6 7
5679 8 7
5680 9 7
5681 0 8
5682 1 8
5683 2 8
5684 3 8
5685 4 8
5686 5 8
5687 6 8
5688 7 8
5689 9 8
5690 0 9
5691 1 9
5692 2 9
5693 3 9
5694 4 9
5695 5 9
5696 6 9
5697 7 9
5698 8 9
5699 DROP TABLE t1,t2,t3,t4,t5,t6;
5700 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
5701 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
5702 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
5703 CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
5704 CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
5705 CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
5706 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5707 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5708 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
5709 INSERT INTO t4 (c1) VALUES(10);
5710 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
5711 SELECT t1.c1,t2.c1 FROM t1,t2 WHERE t1.c1 <> t2.c1;
5712 c1 c1
5713 1 0
5714 2 0
5715 3 0
5716 4 0
5717 5 0
5718 6 0
5719 7 0
5720 8 0
5721 9 0
5722 0 1
5723 2 1
5724 3 1
5725 4 1
5726 5 1
5727 6 1
5728 7 1
5729 8 1
5730 9 1
5731 0 2
5732 1 2
5733 3 2
5734 4 2
5735 5 2
5736 6 2
5737 7 2
5738 8 2
5739 9 2
5740 0 3
5741 1 3
5742 2 3
5743 4 3
5744 5 3
5745 6 3
5746 7 3
5747 8 3
5748 9 3
5749 0 4
5750 1 4
5751 2 4
5752 3 4
5753 5 4
5754 6 4
5755 7 4
5756 8 4
5757 9 4
5758 0 5
5759 1 5
5760 2 5
5761 3 5
5762 4 5
5763 6 5
5764 7 5
5765 8 5
5766 9 5
5767 0 6
5768 1 6
5769 2 6
5770 3 6
5771 4 6
5772 5 6
5773 7 6
5774 8 6
5775 9 6
5776 0 7
5777 1 7
5778 2 7
5779 3 7
5780 4 7
5781 5 7
5782 6 7
5783 8 7
5784 9 7
5785 0 8
5786 1 8
5787 2 8
5788 3 8
5789 4 8
5790 5 8
5791 6 8
5792 7 8
5793 9 8
5794 0 9
5795 1 9
5796 2 9
5797 3 9
5798 4 9
5799 5 9
5800 6 9
5801 7 9
5802 8 9
5803 DROP TABLE t1,t2,t3,t4,t5,t6;
5804 CREATE TABLE t1 (c1 INT NOT NULL);
5805 CREATE TABLE t2 (c1 INT NOT NULL);
5806 CREATE TABLE t3 (c1 INT NOT NULL);
5807 CREATE TABLE t4 (c1 INT NOT NULL);
5808 CREATE TABLE t5 (c1 INT NOT NULL);
5809 CREATE TABLE t6 (c1 INT NOT NULL);
5810 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5811 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5812 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
5813 INSERT INTO t4 (c1) VALUES(10);
5814 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
5815 SELECT t1.c1,t2.c1 FROM t1,t2 WHERE t1.c1 <> t2.c1;
5816 c1 c1
5817 1 0
5818 2 0
5819 3 0
5820 4 0
5821 5 0
5822 6 0
5823 7 0
5824 8 0
5825 9 0
5826 0 1
5827 2 1
5828 3 1
5829 4 1
5830 5 1
5831 6 1
5832 7 1
5833 8 1
5834 9 1
5835 0 2
5836 1 2
5837 3 2
5838 4 2
5839 5 2
5840 6 2
5841 7 2
5842 8 2
5843 9 2
5844 0 3
5845 1 3
5846 2 3
5847 4 3
5848 5 3
5849 6 3
5850 7 3
5851 8 3
5852 9 3
5853 0 4
5854 1 4
5855 2 4
5856 3 4
5857 5 4
5858 6 4
5859 7 4
5860 8 4
5861 9 4
5862 0 5
5863 1 5
5864 2 5
5865 3 5
5866 4 5
5867 6 5
5868 7 5
5869 8 5
5870 9 5
5871 0 6
5872 1 6
5873 2 6
5874 3 6
5875 4 6
5876 5 6
5877 7 6
5878 8 6
5879 9 6
5880 0 7
5881 1 7
5882 2 7
5883 3 7
5884 4 7
5885 5 7
5886 6 7
5887 8 7
5888 9 7
5889 0 8
5890 1 8
5891 2 8
5892 3 8
5893 4 8
5894 5 8
5895 6 8
5896 7 8
5897 9 8
5898 0 9
5899 1 9
5900 2 9
5901 3 9
5902 4 9
5903 5 9
5904 6 9
5905 7 9
5906 8 9
5907 DROP TABLE t1,t2,t3,t4,t5,t6;
5908 CREATE TABLE t1 (c1 INTEGER NOT NULL);
5909 CREATE TABLE t2 (c1 INTEGER NOT NULL);
5910 CREATE TABLE t3 (c1 INTEGER NOT NULL);
5911 CREATE TABLE t4 (c1 INTEGER NOT NULL);
5912 CREATE TABLE t5 (c1 INTEGER NOT NULL);
5913 CREATE TABLE t6 (c1 INTEGER NOT NULL);
5914 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5915 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5916 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
5917 INSERT INTO t4 (c1) VALUES(10);
5918 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
5919 SELECT t1.c1,t2.c1 FROM t1,t2 WHERE t1.c1 <> t2.c1;
5920 c1 c1
5921 1 0
5922 2 0
5923 3 0
5924 4 0
5925 5 0
5926 6 0
5927 7 0
5928 8 0
5929 9 0
5930 0 1
5931 2 1
5932 3 1
5933 4 1
5934 5 1
5935 6 1
5936 7 1
5937 8 1
5938 9 1
5939 0 2
5940 1 2
5941 3 2
5942 4 2
5943 5 2
5944 6 2
5945 7 2
5946 8 2
5947 9 2
5948 0 3
5949 1 3
5950 2 3
5951 4 3
5952 5 3
5953 6 3
5954 7 3
5955 8 3
5956 9 3
5957 0 4
5958 1 4
5959 2 4
5960 3 4
5961 5 4
5962 6 4
5963 7 4
5964 8 4
5965 9 4
5966 0 5
5967 1 5
5968 2 5
5969 3 5
5970 4 5
5971 6 5
5972 7 5
5973 8 5
5974 9 5
5975 0 6
5976 1 6
5977 2 6
5978 3 6
5979 4 6
5980 5 6
5981 7 6
5982 8 6
5983 9 6
5984 0 7
5985 1 7
5986 2 7
5987 3 7
5988 4 7
5989 5 7
5990 6 7
5991 8 7
5992 9 7
5993 0 8
5994 1 8
5995 2 8
5996 3 8
5997 4 8
5998 5 8
5999 6 8
6000 7 8
6001 9 8
6002 0 9
6003 1 9
6004 2 9
6005 3 9
6006 4 9
6007 5 9
6008 6 9
6009 7 9
6010 8 9
6011 DROP TABLE t1,t2,t3,t4,t5,t6;
6012 CREATE TABLE t1 (c1 BIGINT NOT NULL);
6013 CREATE TABLE t2 (c1 BIGINT NOT NULL);
6014 CREATE TABLE t3 (c1 BIGINT NOT NULL);
6015 CREATE TABLE t4 (c1 BIGINT NOT NULL);
6016 CREATE TABLE t5 (c1 BIGINT NOT NULL);
6017 CREATE TABLE t6 (c1 BIGINT NOT NULL);
6018 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
6019 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
6020 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
6021 INSERT INTO t4 (c1) VALUES(10);
6022 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
6023 SELECT t1.c1,t2.c1 FROM t1,t2 WHERE t1.c1 <> t2.c1;
6024 c1 c1
6025 1 0
6026 2 0
6027 3 0
6028 4 0
6029 5 0
6030 6 0
6031 7 0
6032 8 0
6033 9 0
6034 0 1
6035 2 1
6036 3 1
6037 4 1
6038 5 1
6039 6 1
6040 7 1
6041 8 1
6042 9 1
6043 0 2
6044 1 2
6045 3 2
6046 4 2
6047 5 2
6048 6 2
6049 7 2
6050 8 2
6051 9 2
6052 0 3
6053 1 3
6054 2 3
6055 4 3
6056 5 3
6057 6 3
6058 7 3
6059 8 3
6060 9 3
6061 0 4
6062 1 4
6063 2 4
6064 3 4
6065 5 4
6066 6 4
6067 7 4
6068 8 4
6069 9 4
6070 0 5
6071 1 5
6072 2 5
6073 3 5
6074 4 5
6075 6 5
6076 7 5
6077 8 5
6078 9 5
6079 0 6
6080 1 6
6081 2 6
6082 3 6
6083 4 6
6084 5 6
6085 7 6
6086 8 6
6087 9 6
6088 0 7
6089 1 7
6090 2 7
6091 3 7
6092 4 7
6093 5 7
6094 6 7
6095 8 7
6096 9 7
6097 0 8
6098 1 8
6099 2 8
6100 3 8
6101 4 8
6102 5 8
6103 6 8
6104 7 8
6105 9 8
6106 0 9
6107 1 9
6108 2 9
6109 3 9
6110 4 9
6111 5 9
6112 6 9
6113 7 9
6114 8 9
6115 DROP TABLE t1,t2,t3,t4,t5,t6;
6116 CREATE TABLE t1 (c1 TINYINT NOT NULL);
6117 CREATE TABLE t2 (c1 TINYINT NOT NULL);
6118 CREATE TABLE t3 (c1 TINYINT NOT NULL);
6119 CREATE TABLE t4 (c1 TINYINT NOT NULL);
6120 CREATE TABLE t5 (c1 TINYINT NOT NULL);
6121 CREATE TABLE t6 (c1 TINYINT NOT NULL);
6122 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
6123 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
6124 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
6125 INSERT INTO t4 (c1) VALUES(10);
6126 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
6127 SELECT t1.c1,t3.c1 FROM t1,t3 WHERE t1.c1 <> t3.c1;
6128 c1 c1
6129 0 1
6130 0 3
6131 0 5
6132 0 7
6133 0 9
6134 1 3
6135 1 5
6136 1 7
6137 1 9
6138 2 1
6139 2 3
6140 2 5
6141 2 7
6142 2 9
6143 3 1
6144 3 5
6145 3 7
6146 3 9
6147 4 1
6148 4 3
6149 4 5
6150 4 7
6151 4 9
6152 5 1
6153 5 3
6154 5 7
6155 5 9
6156 6 1
6157 6 3
6158 6 5
6159 6 7
6160 6 9
6161 7 1
6162 7 3
6163 7 5
6164 7 9
6165 8 1
6166 8 3
6167 8 5
6168 8 7
6169 8 9
6170 9 1
6171 9 3
6172 9 5
6173 9 7
6174 DROP TABLE t1,t2,t3,t4,t5,t6;
6175 CREATE TABLE t1 (c1 SMALLINT NOT NULL);
6176 CREATE TABLE t2 (c1 SMALLINT NOT NULL);
6177 CREATE TABLE t3 (c1 SMALLINT NOT NULL);
6178 CREATE TABLE t4 (c1 SMALLINT NOT NULL);
6179 CREATE TABLE t5 (c1 SMALLINT NOT NULL);
6180 CREATE TABLE t6 (c1 SMALLINT NOT NULL);
6181 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
6182 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
6183 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
6184 INSERT INTO t4 (c1) VALUES(10);
6185 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
6186 SELECT t1.c1,t3.c1 FROM t1,t3 WHERE t1.c1 <> t3.c1;
6187 c1 c1
6188 0 1
6189 0 3
6190 0 5
6191 0 7
6192 0 9
6193 1 3
6194 1 5
6195 1 7
6196 1 9
6197 2 1
6198 2 3
6199 2 5
6200 2 7
6201 2 9
6202 3 1
6203 3 5
6204 3 7
6205 3 9
6206 4 1
6207 4 3
6208 4 5
6209 4 7
6210 4 9
6211 5 1
6212 5 3
6213 5 7
6214 5 9
6215 6 1
6216 6 3
6217 6 5
6218 6 7
6219 6 9
6220 7 1
6221 7 3
6222 7 5
6223 7 9
6224 8 1
6225 8 3
6226 8 5
6227 8 7
6228 8 9
6229 9 1
6230 9 3
6231 9 5
6232 9 7
6233 DROP TABLE t1,t2,t3,t4,t5,t6;
6234 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
6235 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
6236 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
6237 CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
6238 CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
6239 CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
6240 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
6241 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
6242 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
6243 INSERT INTO t4 (c1) VALUES(10);
6244 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
6245 SELECT t1.c1,t3.c1 FROM t1,t3 WHERE t1.c1 <> t3.c1;
6246 c1 c1
6247 0 1
6248 0 3
6249 0 5
6250 0 7
6251 0 9
6252 1 3
6253 1 5
6254 1 7
6255 1 9
6256 2 1
6257 2 3
6258 2 5
6259 2 7
6260 2 9
6261 3 1
6262 3 5
6263 3 7
6264 3 9
6265 4 1
6266 4 3
6267 4 5
6268 4 7
6269 4 9
6270 5 1
6271 5 3
6272 5 7
6273 5 9
6274 6 1
6275 6 3
6276 6 5
6277 6 7
6278 6 9
6279 7 1
6280 7 3
6281 7 5
6282 7 9
6283 8 1
6284 8 3
6285 8 5
6286 8 7
6287 8 9
6288 9 1
6289 9 3
6290 9 5
6291 9 7
6292 DROP TABLE t1,t2,t3,t4,t5,t6;
6293 CREATE TABLE t1 (c1 INT NOT NULL);
6294 CREATE TABLE t2 (c1 INT NOT NULL);
6295 CREATE TABLE t3 (c1 INT NOT NULL);
6296 CREATE TABLE t4 (c1 INT NOT NULL);
6297 CREATE TABLE t5 (c1 INT NOT NULL);
6298 CREATE TABLE t6 (c1 INT NOT NULL);
6299 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
6300 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
6301 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
6302 INSERT INTO t4 (c1) VALUES(10);
6303 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
6304 SELECT t1.c1,t3.c1 FROM t1,t3 WHERE t1.c1 <> t3.c1;
6305 c1 c1
6306 0 1
6307 0 3
6308 0 5
6309 0 7
6310 0 9
6311 1 3
6312 1 5
6313 1 7
6314 1 9
6315 2 1
6316 2 3
6317 2 5
6318 2 7
6319 2 9
6320 3 1
6321 3 5
6322 3 7
6323 3 9
6324 4 1
6325 4 3
6326 4 5
6327 4 7
6328 4 9
6329 5 1
6330 5 3
6331 5 7
6332 5 9
6333 6 1
6334 6 3
6335 6 5
6336 6 7
6337 6 9
6338 7 1
6339 7 3
6340 7 5
6341 7 9
6342 8 1
6343 8 3
6344 8 5
6345 8 7
6346 8 9
6347 9 1
6348 9 3
6349 9 5
6350 9 7
6351 DROP TABLE t1,t2,t3,t4,t5,t6;
6352 CREATE TABLE t1 (c1 INTEGER NOT NULL);
6353 CREATE TABLE t2 (c1 INTEGER NOT NULL);
6354 CREATE TABLE t3 (c1 INTEGER NOT NULL);
6355 CREATE TABLE t4 (c1 INTEGER NOT NULL);
6356 CREATE TABLE t5 (c1 INTEGER NOT NULL);
6357 CREATE TABLE t6 (c1 INTEGER NOT NULL);
6358 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
6359 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
6360 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
6361 INSERT INTO t4 (c1) VALUES(10);
6362 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
6363 SELECT t1.c1,t3.c1 FROM t1,t3 WHERE t1.c1 <> t3.c1;
6364 c1 c1
6365 0 1
6366 0 3
6367 0 5
6368 0 7
6369 0 9
6370 1 3
6371 1 5
6372 1 7
6373 1 9
6374 2 1
6375 2 3
6376 2 5
6377 2 7
6378 2 9
6379 3 1
6380 3 5
6381 3 7
6382 3 9
6383 4 1
6384 4 3
6385 4 5
6386 4 7
6387 4 9
6388 5 1
6389 5 3
6390 5 7
6391 5 9
6392 6 1
6393 6 3
6394 6 5
6395 6 7
6396 6 9
6397 7 1
6398 7 3
6399 7 5
6400 7 9
6401 8 1
6402 8 3
6403 8 5
6404 8 7
6405 8 9
6406 9 1
6407 9 3
6408 9 5
6409 9 7
6410 DROP TABLE t1,t2,t3,t4,t5,t6;
6411 CREATE TABLE t1 (c1 BIGINT NOT NULL);
6412 CREATE TABLE t2 (c1 BIGINT NOT NULL);
6413 CREATE TABLE t3 (c1 BIGINT NOT NULL);
6414 CREATE TABLE t4 (c1 BIGINT NOT NULL);
6415 CREATE TABLE t5 (c1 BIGINT NOT NULL);
6416 CREATE TABLE t6 (c1 BIGINT NOT NULL);
6417 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
6418 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
6419 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
6420 INSERT INTO t4 (c1) VALUES(10);
6421 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
6422 SELECT t1.c1,t3.c1 FROM t1,t3 WHERE t1.c1 <> t3.c1;
6423 c1 c1
6424 0 1
6425 0 3
6426 0 5
6427 0 7
6428 0 9
6429 1 3
6430 1 5
6431 1 7
6432 1 9
6433 2 1
6434 2 3
6435 2 5
6436 2 7
6437 2 9
6438 3 1
6439 3 5
6440 3 7
6441 3 9
6442 4 1
6443 4 3
6444 4 5
6445 4 7
6446 4 9
6447 5 1
6448 5 3
6449 5 7
6450 5 9
6451 6 1
6452 6 3
6453 6 5
6454 6 7
6455 6 9
6456 7 1
6457 7 3
6458 7 5
6459 7 9
6460 8 1
6461 8 3
6462 8 5
6463 8 7
6464 8 9
6465 9 1
6466 9 3
6467 9 5
6468 9 7
6469 DROP TABLE t1,t2,t3,t4,t5,t6;
6470 CREATE TABLE t1 (c1 TINYINT NOT NULL);
6471 CREATE TABLE t2 (c1 TINYINT NOT NULL);
6472 CREATE TABLE t3 (c1 TINYINT NOT NULL);
6473 CREATE TABLE t4 (c1 TINYINT NOT NULL);
6474 CREATE TABLE t5 (c1 TINYINT NOT NULL);
6475 CREATE TABLE t6 (c1 TINYINT NOT NULL);
6476 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
6477 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
6478 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
6479 INSERT INTO t4 (c1) VALUES(10);
6480 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
6481 SELECT t1.c1,t4.c1 FROM t1,t4 WHERE t1.c1 <> t4.c1;
6482 c1 c1
6483 0 10
6484 1 10
6485 2 10
6486 3 10
6487 4 10
6488 5 10
6489 6 10
6490 7 10
6491 8 10
6492 9 10
6493 DROP TABLE t1,t2,t3,t4,t5,t6;
6494 CREATE TABLE t1 (c1 SMALLINT NOT NULL);
6495 CREATE TABLE t2 (c1 SMALLINT NOT NULL);
6496 CREATE TABLE t3 (c1 SMALLINT NOT NULL);
6497 CREATE TABLE t4 (c1 SMALLINT NOT NULL);
6498 CREATE TABLE t5 (c1 SMALLINT NOT NULL);
6499 CREATE TABLE t6 (c1 SMALLINT NOT NULL);
6500 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
6501 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
6502 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
6503 INSERT INTO t4 (c1) VALUES(10);
6504 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
6505 SELECT t1.c1,t4.c1 FROM t1,t4 WHERE t1.c1 <> t4.c1;
6506 c1 c1
6507 0 10
6508 1 10
6509 2 10
6510 3 10
6511 4 10
6512 5 10
6513 6 10
6514 7 10
6515 8 10
6516 9 10
6517 DROP TABLE t1,t2,t3,t4,t5,t6;
6518 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
6519 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
6520 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
6521 CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
6522 CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
6523 CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
6524 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
6525 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
6526 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
6527 INSERT INTO t4 (c1) VALUES(10);
6528 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
6529 SELECT t1.c1,t4.c1 FROM t1,t4 WHERE t1.c1 <> t4.c1;
6530 c1 c1
6531 0 10
6532 1 10
6533 2 10
6534 3 10
6535 4 10
6536 5 10
6537 6 10
6538 7 10
6539 8 10
6540 9 10
6541 DROP TABLE t1,t2,t3,t4,t5,t6;
6542 CREATE TABLE t1 (c1 INT NOT NULL);
6543 CREATE TABLE t2 (c1 INT NOT NULL);
6544 CREATE TABLE t3 (c1 INT NOT NULL);
6545 CREATE TABLE t4 (c1 INT NOT NULL);
6546 CREATE TABLE t5 (c1 INT NOT NULL);
6547 CREATE TABLE t6 (c1 INT NOT NULL);
6548 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
6549 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
6550 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
6551 INSERT INTO t4 (c1) VALUES(10);
6552 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
6553 SELECT t1.c1,t4.c1 FROM t1,t4 WHERE t1.c1 <> t4.c1;
6554 c1 c1
6555 0 10
6556 1 10
6557 2 10
6558 3 10
6559 4 10
6560 5 10
6561 6 10
6562 7 10
6563 8 10
6564 9 10
6565 DROP TABLE t1,t2,t3,t4,t5,t6;
6566 CREATE TABLE t1 (c1 INTEGER NOT NULL);
6567 CREATE TABLE t2 (c1 INTEGER NOT NULL);
6568 CREATE TABLE t3 (c1 INTEGER NOT NULL);
6569 CREATE TABLE t4 (c1 INTEGER NOT NULL);
6570 CREATE TABLE t5 (c1 INTEGER NOT NULL);
6571 CREATE TABLE t6 (c1 INTEGER NOT NULL);
6572 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
6573 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
6574 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
6575 INSERT INTO t4 (c1) VALUES(10);
6576 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
6577 SELECT t1.c1,t4.c1 FROM t1,t4 WHERE t1.c1 <> t4.c1;
6578 c1 c1
6579 0 10
6580 1 10
6581 2 10
6582 3 10
6583 4 10
6584 5 10
6585 6 10
6586 7 10
6587 8 10
6588 9 10
6589 DROP TABLE t1,t2,t3,t4,t5,t6;
6590 CREATE TABLE t1 (c1 BIGINT NOT NULL);
6591 CREATE TABLE t2 (c1 BIGINT NOT NULL);
6592 CREATE TABLE t3 (c1 BIGINT NOT NULL);
6593 CREATE TABLE t4 (c1 BIGINT NOT NULL);
6594 CREATE TABLE t5 (c1 BIGINT NOT NULL);
6595 CREATE TABLE t6 (c1 BIGINT NOT NULL);
6596 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
6597 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
6598 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
6599 INSERT INTO t4 (c1) VALUES(10);
6600 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
6601 SELECT t1.c1,t4.c1 FROM t1,t4 WHERE t1.c1 <> t4.c1;
6602 c1 c1
6603 0 10
6604 1 10
6605 2 10
6606 3 10
6607 4 10
6608 5 10
6609 6 10
6610 7 10
6611 8 10
6612 9 10
6613 DROP TABLE t1,t2,t3,t4,t5,t6;
6614 CREATE TABLE t1 (c1 TINYINT NOT NULL);
6615 CREATE TABLE t2 (c1 TINYINT NOT NULL);
6616 CREATE TABLE t3 (c1 TINYINT NOT NULL);
6617 CREATE TABLE t4 (c1 TINYINT NOT NULL);
6618 CREATE TABLE t5 (c1 TINYINT NOT NULL);
6619 CREATE TABLE t6 (c1 TINYINT NOT NULL);
6620 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
6621 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
6622 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
6623 INSERT INTO t4 (c1) VALUES(10);
6624 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
6625 SELECT t1.c1,t5.c1 FROM t1,t5 WHERE t1.c1 <> t5.c1;
6626 c1 c1
6627 0 10
6628 0 11
6629 0 12
6630 0 13
6631 0 14
6632 1 10
6633 1 11
6634 1 12
6635 1 13
6636 1 14
6637 2 10
6638 2 11
6639 2 12
6640 2 13
6641 2 14
6642 3 10
6643 3 11
6644 3 12
6645 3 13
6646 3 14
6647 4 10
6648 4 11
6649 4 12
6650 4 13
6651 4 14
6652 5 10
6653 5 11
6654 5 12
6655 5 13
6656 5 14
6657 6 10
6658 6 11
6659 6 12
6660 6 13
6661 6 14
6662 7 10
6663 7 11
6664 7 12
6665 7 13
6666 7 14
6667 8 10
6668 8 11
6669 8 12
6670 8 13
6671 8 14
6672 9 10
6673 9 11
6674 9 12
6675 9 13
6676 9 14
6677 DROP TABLE t1,t2,t3,t4,t5,t6;
6678 CREATE TABLE t1 (c1 SMALLINT NOT NULL);
6679 CREATE TABLE t2 (c1 SMALLINT NOT NULL);
6680 CREATE TABLE t3 (c1 SMALLINT NOT NULL);
6681 CREATE TABLE t4 (c1 SMALLINT NOT NULL);
6682 CREATE TABLE t5 (c1 SMALLINT NOT NULL);
6683 CREATE TABLE t6 (c1 SMALLINT NOT NULL);
6684 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
6685 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
6686 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
6687 INSERT INTO t4 (c1) VALUES(10);
6688 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
6689 SELECT t1.c1,t5.c1 FROM t1,t5 WHERE t1.c1 <> t5.c1;
6690 c1 c1
6691 0 10
6692 0 11
6693 0 12
6694 0 13
6695 0 14
6696 1 10
6697 1 11
6698 1 12
6699 1 13
6700 1 14
6701 2 10
6702 2 11
6703 2 12
6704 2 13
6705 2 14
6706 3 10
6707 3 11
6708 3 12
6709 3 13
6710 3 14
6711 4 10
6712 4 11
6713 4 12
6714 4 13
6715 4 14
6716 5 10
6717 5 11
6718 5 12
6719 5 13
6720 5 14
6721 6 10
6722 6 11
6723 6 12
6724 6 13
6725 6 14
6726 7 10
6727 7 11
6728 7 12
6729 7 13
6730 7 14
6731 8 10
6732 8 11
6733 8 12
6734 8 13
6735 8 14
6736 9 10
6737 9 11
6738 9 12
6739 9 13
6740 9 14
6741 DROP TABLE t1,t2,t3,t4,t5,t6;
6742 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
6743 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
6744 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
6745 CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
6746 CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
6747 CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
6748 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
6749 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
6750 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
6751 INSERT INTO t4 (c1) VALUES(10);
6752 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
6753 SELECT t1.c1,t5.c1 FROM t1,t5 WHERE t1.c1 <> t5.c1;
6754 c1 c1
6755 0 10
6756 0 11
6757 0 12
6758 0 13
6759 0 14
6760 1 10
6761 1 11
6762 1 12
6763 1 13
6764 1 14
6765 2 10
6766 2 11
6767 2 12
6768 2 13
6769 2 14
6770 3 10
6771 3 11
6772 3 12
6773 3 13
6774 3 14
6775 4 10
6776 4 11
6777 4 12
6778 4 13
6779 4 14
6780 5 10
6781 5 11
6782 5 12
6783 5 13
6784 5 14
6785 6 10
6786 6 11
6787 6 12
6788 6 13
6789 6 14
6790 7 10
6791 7 11
6792 7 12
6793 7 13
6794 7 14
6795 8 10
6796 8 11
6797 8 12
6798 8 13
6799 8 14
6800 9 10
6801 9 11
6802 9 12
6803 9 13
6804 9 14
6805 DROP TABLE t1,t2,t3,t4,t5,t6;
6806 CREATE TABLE t1 (c1 INT NOT NULL);
6807 CREATE TABLE t2 (c1 INT NOT NULL);
6808 CREATE TABLE t3 (c1 INT NOT NULL);
6809 CREATE TABLE t4 (c1 INT NOT NULL);
6810 CREATE TABLE t5 (c1 INT NOT NULL);
6811 CREATE TABLE t6 (c1 INT NOT NULL);
6812 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
6813 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
6814 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
6815 INSERT INTO t4 (c1) VALUES(10);
6816 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
6817 SELECT t1.c1,t5.c1 FROM t1,t5 WHERE t1.c1 <> t5.c1;
6818 c1 c1
6819 0 10
6820 0 11
6821 0 12
6822 0 13
6823 0 14
6824 1 10
6825 1 11
6826 1 12
6827 1 13
6828 1 14
6829 2 10
6830 2 11
6831 2 12
6832 2 13
6833 2 14
6834 3 10
6835 3 11
6836 3 12
6837 3 13
6838 3 14
6839 4 10
6840 4 11
6841 4 12
6842 4 13
6843 4 14
6844 5 10
6845 5 11
6846 5 12
6847 5 13
6848 5 14
6849 6 10
6850 6 11
6851 6 12
6852 6 13
6853 6 14
6854 7 10
6855 7 11
6856 7 12
6857 7 13
6858 7 14
6859 8 10
6860 8 11
6861 8 12
6862 8 13
6863 8 14
6864 9 10
6865 9 11
6866 9 12
6867 9 13
6868 9 14
6869 DROP TABLE t1,t2,t3,t4,t5,t6;
6870 CREATE TABLE t1 (c1 INTEGER NOT NULL);
6871 CREATE TABLE t2 (c1 INTEGER NOT NULL);
6872 CREATE TABLE t3 (c1 INTEGER NOT NULL);
6873 CREATE TABLE t4 (c1 INTEGER NOT NULL);
6874 CREATE TABLE t5 (c1 INTEGER NOT NULL);
6875 CREATE TABLE t6 (c1 INTEGER NOT NULL);
6876 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
6877 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
6878 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
6879 INSERT INTO t4 (c1) VALUES(10);
6880 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
6881 SELECT t1.c1,t5.c1 FROM t1,t5 WHERE t1.c1 <> t5.c1;
6882 c1 c1
6883 0 10
6884 0 11
6885 0 12
6886 0 13
6887 0 14
6888 1 10
6889 1 11
6890 1 12
6891 1 13
6892 1 14
6893 2 10
6894 2 11
6895 2 12
6896 2 13
6897 2 14
6898 3 10
6899 3 11
6900 3 12
6901 3 13
6902 3 14
6903 4 10
6904 4 11
6905 4 12
6906 4 13
6907 4 14
6908 5 10
6909 5 11
6910 5 12
6911 5 13
6912 5 14
6913 6 10
6914 6 11
6915 6 12
6916 6 13
6917 6 14
6918 7 10
6919 7 11
6920 7 12
6921 7 13
6922 7 14
6923 8 10
6924 8 11
6925 8 12
6926 8 13
6927 8 14
6928 9 10
6929 9 11
6930 9 12
6931 9 13
6932 9 14
6933 DROP TABLE t1,t2,t3,t4,t5,t6;
6934 CREATE TABLE t1 (c1 BIGINT NOT NULL);
6935 CREATE TABLE t2 (c1 BIGINT NOT NULL);
6936 CREATE TABLE t3 (c1 BIGINT NOT NULL);
6937 CREATE TABLE t4 (c1 BIGINT NOT NULL);
6938 CREATE TABLE t5 (c1 BIGINT NOT NULL);
6939 CREATE TABLE t6 (c1 BIGINT NOT NULL);
6940 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
6941 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
6942 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
6943 INSERT INTO t4 (c1) VALUES(10);
6944 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
6945 SELECT t1.c1,t5.c1 FROM t1,t5 WHERE t1.c1 <> t5.c1;
6946 c1 c1
6947 0 10
6948 0 11
6949 0 12
6950 0 13
6951 0 14
6952 1 10
6953 1 11
6954 1 12
6955 1 13
6956 1 14
6957 2 10
6958 2 11
6959 2 12
6960 2 13
6961 2 14
6962 3 10
6963 3 11
6964 3 12
6965 3 13
6966 3 14
6967 4 10
6968 4 11
6969 4 12
6970 4 13
6971 4 14
6972 5 10
6973 5 11
6974 5 12
6975 5 13
6976 5 14
6977 6 10
6978 6 11
6979 6 12
6980 6 13
6981 6 14
6982 7 10
6983 7 11
6984 7 12
6985 7 13
6986 7 14
6987 8 10
6988 8 11
6989 8 12
6990 8 13
6991 8 14
6992 9 10
6993 9 11
6994 9 12
6995 9 13
6996 9 14
6997 DROP TABLE t1,t2,t3,t4,t5,t6;
6998 CREATE TABLE t1 (c1 TINYINT NOT NULL);
6999 CREATE TABLE t2 (c1 TINYINT NOT NULL);
7000 CREATE TABLE t3 (c1 TINYINT NOT NULL);
7001 CREATE TABLE t4 (c1 TINYINT NOT NULL);
7002 CREATE TABLE t5 (c1 TINYINT NOT NULL);
7003 CREATE TABLE t6 (c1 TINYINT NOT NULL);
7004 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
7005 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
7006 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
7007 INSERT INTO t4 (c1) VALUES(10);
7008 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
7009 SELECT t1.c1,t6.c1 FROM t1,t6 WHERE t1.c1 <> t6.c1;
7010 c1 c1
7011 DROP TABLE t1,t2,t3,t4,t5,t6;
7012 CREATE TABLE t1 (c1 SMALLINT NOT NULL);
7013 CREATE TABLE t2 (c1 SMALLINT NOT NULL);
7014 CREATE TABLE t3 (c1 SMALLINT NOT NULL);
7015 CREATE TABLE t4 (c1 SMALLINT NOT NULL);
7016 CREATE TABLE t5 (c1 SMALLINT NOT NULL);
7017 CREATE TABLE t6 (c1 SMALLINT NOT NULL);
7018 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
7019 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
7020 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
7021 INSERT INTO t4 (c1) VALUES(10);
7022 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
7023 SELECT t1.c1,t6.c1 FROM t1,t6 WHERE t1.c1 <> t6.c1;
7024 c1 c1
7025 DROP TABLE t1,t2,t3,t4,t5,t6;
7026 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
7027 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
7028 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
7029 CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
7030 CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
7031 CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
7032 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
7033 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
7034 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
7035 INSERT INTO t4 (c1) VALUES(10);
7036 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
7037 SELECT t1.c1,t6.c1 FROM t1,t6 WHERE t1.c1 <> t6.c1;
7038 c1 c1
7039 DROP TABLE t1,t2,t3,t4,t5,t6;
7040 CREATE TABLE t1 (c1 INT NOT NULL);
7041 CREATE TABLE t2 (c1 INT NOT NULL);
7042 CREATE TABLE t3 (c1 INT NOT NULL);
7043 CREATE TABLE t4 (c1 INT NOT NULL);
7044 CREATE TABLE t5 (c1 INT NOT NULL);
7045 CREATE TABLE t6 (c1 INT NOT NULL);
7046 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
7047 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
7048 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
7049 INSERT INTO t4 (c1) VALUES(10);
7050 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
7051 SELECT t1.c1,t6.c1 FROM t1,t6 WHERE t1.c1 <> t6.c1;
7052 c1 c1
7053 DROP TABLE t1,t2,t3,t4,t5,t6;
7054 CREATE TABLE t1 (c1 INTEGER NOT NULL);
7055 CREATE TABLE t2 (c1 INTEGER NOT NULL);
7056 CREATE TABLE t3 (c1 INTEGER NOT NULL);
7057 CREATE TABLE t4 (c1 INTEGER NOT NULL);
7058 CREATE TABLE t5 (c1 INTEGER NOT NULL);
7059 CREATE TABLE t6 (c1 INTEGER NOT NULL);
7060 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
7061 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
7062 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
7063 INSERT INTO t4 (c1) VALUES(10);
7064 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
7065 SELECT t1.c1,t6.c1 FROM t1,t6 WHERE t1.c1 <> t6.c1;
7066 c1 c1
7067 DROP TABLE t1,t2,t3,t4,t5,t6;
7068 CREATE TABLE t1 (c1 BIGINT NOT NULL);
7069 CREATE TABLE t2 (c1 BIGINT NOT NULL);
7070 CREATE TABLE t3 (c1 BIGINT NOT NULL);
7071 CREATE TABLE t4 (c1 BIGINT NOT NULL);
7072 CREATE TABLE t5 (c1 BIGINT NOT NULL);
7073 CREATE TABLE t6 (c1 BIGINT NOT NULL);
7074 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
7075 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
7076 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
7077 INSERT INTO t4 (c1) VALUES(10);
7078 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
7079 SELECT t1.c1,t6.c1 FROM t1,t6 WHERE t1.c1 <> t6.c1;
7080 c1 c1
7081 DROP TABLE t1,t2,t3,t4,t5,t6;
7082 CREATE TABLE t1 (c1 TINYINT NOT NULL);
7083 CREATE TABLE t2 (c1 TINYINT NOT NULL);
7084 CREATE TABLE t3 (c1 TINYINT NOT NULL);
7085 CREATE TABLE t4 (c1 TINYINT NOT NULL);
7086 CREATE TABLE t5 (c1 TINYINT NOT NULL);
7087 CREATE TABLE t6 (c1 TINYINT NOT NULL);
7088 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
7089 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
7090 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
7091 INSERT INTO t4 (c1) VALUES(10);
7092 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
7093 SELECT t1.c1,t2.c1 FROM t1,t2 WHERE t1.c1 <=> t2.c1;
7094 c1 c1
7095 0 0
7096 1 1
7097 2 2
7098 3 3
7099 4 4
7100 5 5
7101 6 6
7102 7 7
7103 8 8
7104 9 9
7105 DROP TABLE t1,t2,t3,t4,t5,t6;
7106 CREATE TABLE t1 (c1 SMALLINT NOT NULL);
7107 CREATE TABLE t2 (c1 SMALLINT NOT NULL);
7108 CREATE TABLE t3 (c1 SMALLINT NOT NULL);
7109 CREATE TABLE t4 (c1 SMALLINT NOT NULL);
7110 CREATE TABLE t5 (c1 SMALLINT NOT NULL);
7111 CREATE TABLE t6 (c1 SMALLINT NOT NULL);
7112 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
7113 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
7114 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
7115 INSERT INTO t4 (c1) VALUES(10);
7116 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
7117 SELECT t1.c1,t2.c1 FROM t1,t2 WHERE t1.c1 <=> t2.c1;
7118 c1 c1
7119 0 0
7120 1 1
7121 2 2
7122 3 3
7123 4 4
7124 5 5
7125 6 6
7126 7 7
7127 8 8
7128 9 9
7129 DROP TABLE t1,t2,t3,t4,t5,t6;
7130 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
7131 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
7132 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
7133 CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
7134 CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
7135 CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
7136 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
7137 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
7138 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
7139 INSERT INTO t4 (c1) VALUES(10);
7140 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
7141 SELECT t1.c1,t2.c1 FROM t1,t2 WHERE t1.c1 <=> t2.c1;
7142 c1 c1
7143 0 0
7144 1 1
7145 2 2
7146 3 3
7147 4 4
7148 5 5
7149 6 6
7150 7 7
7151 8 8
7152 9 9
7153 DROP TABLE t1,t2,t3,t4,t5,t6;
7154 CREATE TABLE t1 (c1 INT NOT NULL);
7155 CREATE TABLE t2 (c1 INT NOT NULL);
7156 CREATE TABLE t3 (c1 INT NOT NULL);
7157 CREATE TABLE t4 (c1 INT NOT NULL);
7158 CREATE TABLE t5 (c1 INT NOT NULL);
7159 CREATE TABLE t6 (c1 INT NOT NULL);
7160 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
7161 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
7162 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
7163 INSERT INTO t4 (c1) VALUES(10);
7164 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
7165 SELECT t1.c1,t2.c1 FROM t1,t2 WHERE t1.c1 <=> t2.c1;
7166 c1 c1
7167 0 0
7168 1 1
7169 2 2
7170 3 3
7171 4 4
7172 5 5
7173 6 6
7174 7 7
7175 8 8
7176 9 9
7177 DROP TABLE t1,t2,t3,t4,t5,t6;
7178 CREATE TABLE t1 (c1 INTEGER NOT NULL);
7179 CREATE TABLE t2 (c1 INTEGER NOT NULL);
7180 CREATE TABLE t3 (c1 INTEGER NOT NULL);
7181 CREATE TABLE t4 (c1 INTEGER NOT NULL);
7182 CREATE TABLE t5 (c1 INTEGER NOT NULL);
7183 CREATE TABLE t6 (c1 INTEGER NOT NULL);
7184 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
7185 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
7186 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
7187 INSERT INTO t4 (c1) VALUES(10);
7188 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
7189 SELECT t1.c1,t2.c1 FROM t1,t2 WHERE t1.c1 <=> t2.c1;
7190 c1 c1
7191 0 0
7192 1 1
7193 2 2
7194 3 3
7195 4 4
7196 5 5
7197 6 6
7198 7 7
7199 8 8
7200 9 9
7201 DROP TABLE t1,t2,t3,t4,t5,t6;
7202 CREATE TABLE t1 (c1 BIGINT NOT NULL);
7203 CREATE TABLE t2 (c1 BIGINT NOT NULL);
7204 CREATE TABLE t3 (c1 BIGINT NOT NULL);
7205 CREATE TABLE t4 (c1 BIGINT NOT NULL);
7206 CREATE TABLE t5 (c1 BIGINT NOT NULL);
7207 CREATE TABLE t6 (c1 BIGINT NOT NULL);
7208 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
7209 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
7210 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
7211 INSERT INTO t4 (c1) VALUES(10);
7212 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
7213 SELECT t1.c1,t2.c1 FROM t1,t2 WHERE t1.c1 <=> t2.c1;
7214 c1 c1
7215 0 0
7216 1 1
7217 2 2
7218 3 3
7219 4 4
7220 5 5
7221 6 6
7222 7 7
7223 8 8
7224 9 9
7225 DROP TABLE t1,t2,t3,t4,t5,t6;
7226 CREATE TABLE t1 (c1 TINYINT NOT NULL);
7227 CREATE TABLE t2 (c1 TINYINT NOT NULL);
7228 CREATE TABLE t3 (c1 TINYINT NOT NULL);
7229 CREATE TABLE t4 (c1 TINYINT NOT NULL);
7230 CREATE TABLE t5 (c1 TINYINT NOT NULL);
7231 CREATE TABLE t6 (c1 TINYINT NOT NULL);
7232 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
7233 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
7234 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
7235 INSERT INTO t4 (c1) VALUES(10);
7236 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
7237 SELECT t1.c1,t3.c1 FROM t1,t3 WHERE t1.c1 <=> t3.c1;
7238 c1 c1
7239 1 1
7240 3 3
7241 5 5
7242 7 7
7243 9 9
7244 DROP TABLE t1,t2,t3,t4,t5,t6;
7245 CREATE TABLE t1 (c1 SMALLINT NOT NULL);
7246 CREATE TABLE t2 (c1 SMALLINT NOT NULL);
7247 CREATE TABLE t3 (c1 SMALLINT NOT NULL);
7248 CREATE TABLE t4 (c1 SMALLINT NOT NULL);
7249 CREATE TABLE t5 (c1 SMALLINT NOT NULL);
7250 CREATE TABLE t6 (c1 SMALLINT NOT NULL);
7251 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
7252 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
7253 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
7254 INSERT INTO t4 (c1) VALUES(10);
7255 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
7256 SELECT t1.c1,t3.c1 FROM t1,t3 WHERE t1.c1 <=> t3.c1;
7257 c1 c1
7258 1 1
7259 3 3
7260 5 5
7261 7 7
7262 9 9
7263 DROP TABLE t1,t2,t3,t4,t5,t6;
7264 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
7265 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
7266 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
7267 CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
7268 CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
7269 CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
7270 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
7271 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
7272 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
7273 INSERT INTO t4 (c1) VALUES(10);
7274 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
7275 SELECT t1.c1,t3.c1 FROM t1,t3 WHERE t1.c1 <=> t3.c1;
7276 c1 c1
7277 1 1
7278 3 3
7279 5 5
7280 7 7
7281 9 9
7282 DROP TABLE t1,t2,t3,t4,t5,t6;
7283 CREATE TABLE t1 (c1 INT NOT NULL);
7284 CREATE TABLE t2 (c1 INT NOT NULL);
7285 CREATE TABLE t3 (c1 INT NOT NULL);
7286 CREATE TABLE t4 (c1 INT NOT NULL);
7287 CREATE TABLE t5 (c1 INT NOT NULL);
7288 CREATE TABLE t6 (c1 INT NOT NULL);
7289 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
7290 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
7291 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
7292 INSERT INTO t4 (c1) VALUES(10);
7293 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
7294 SELECT t1.c1,t3.c1 FROM t1,t3 WHERE t1.c1 <=> t3.c1;
7295 c1 c1
7296 1 1
7297 3 3
7298 5 5
7299 7 7
7300 9 9
7301 DROP TABLE t1,t2,t3,t4,t5,t6;
7302 CREATE TABLE t1 (c1 INTEGER NOT NULL);
7303 CREATE TABLE t2 (c1 INTEGER NOT NULL);
7304 CREATE TABLE t3 (c1 INTEGER NOT NULL);
7305 CREATE TABLE t4 (c1 INTEGER NOT NULL);
7306 CREATE TABLE t5 (c1 INTEGER NOT NULL);
7307 CREATE TABLE t6 (c1 INTEGER NOT NULL);
7308 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
7309 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
7310 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
7311 INSERT INTO t4 (c1) VALUES(10);
7312 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
7313 SELECT t1.c1,t3.c1 FROM t1,t3 WHERE t1.c1 <=> t3.c1;
7314 c1 c1
7315 1 1
7316 3 3
7317 5 5
7318 7 7
7319 9 9
7320 DROP TABLE t1,t2,t3,t4,t5,t6;
7321 CREATE TABLE t1 (c1 BIGINT NOT NULL);
7322 CREATE TABLE t2 (c1 BIGINT NOT NULL);
7323 CREATE TABLE t3 (c1 BIGINT NOT NULL);
7324 CREATE TABLE t4 (c1 BIGINT NOT NULL);
7325 CREATE TABLE t5 (c1 BIGINT NOT NULL);
7326 CREATE TABLE t6 (c1 BIGINT NOT NULL);
7327 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
7328 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
7329 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
7330 INSERT INTO t4 (c1) VALUES(10);
7331 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
7332 SELECT t1.c1,t3.c1 FROM t1,t3 WHERE t1.c1 <=> t3.c1;
7333 c1 c1
7334 1 1
7335 3 3
7336 5 5
7337 7 7
7338 9 9
7339 DROP TABLE t1,t2,t3,t4,t5,t6;
7340 CREATE TABLE t1 (c1 TINYINT NOT NULL);
7341 CREATE TABLE t2 (c1 TINYINT NOT NULL);
7342 CREATE TABLE t3 (c1 TINYINT NOT NULL);
7343 CREATE TABLE t4 (c1 TINYINT NOT NULL);
7344 CREATE TABLE t5 (c1 TINYINT NOT NULL);
7345 CREATE TABLE t6 (c1 TINYINT NOT NULL);
7346 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
7347 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
7348 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
7349 INSERT INTO t4 (c1) VALUES(10);
7350 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
7351 SELECT t1.c1,t4.c1 FROM t1,t4 WHERE t1.c1 <=> t4.c1;
7352 c1 c1
7353 DROP TABLE t1,t2,t3,t4,t5,t6;
7354 CREATE TABLE t1 (c1 SMALLINT NOT NULL);
7355 CREATE TABLE t2 (c1 SMALLINT NOT NULL);
7356 CREATE TABLE t3 (c1 SMALLINT NOT NULL);
7357 CREATE TABLE t4 (c1 SMALLINT NOT NULL);
7358 CREATE TABLE t5 (c1 SMALLINT NOT NULL);
7359 CREATE TABLE t6 (c1 SMALLINT NOT NULL);
7360 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
7361 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
7362 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
7363 INSERT INTO t4 (c1) VALUES(10);
7364 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
7365 SELECT t1.c1,t4.c1 FROM t1,t4 WHERE t1.c1 <=> t4.c1;
7366 c1 c1
7367 DROP TABLE t1,t2,t3,t4,t5,t6;
7368 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
7369 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
7370 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
7371 CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
7372 CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
7373 CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
7374 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
7375 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
7376 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
7377 INSERT INTO t4 (c1) VALUES(10);
7378 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
7379 SELECT t1.c1,t4.c1 FROM t1,t4 WHERE t1.c1 <=> t4.c1;
7380 c1 c1
7381 DROP TABLE t1,t2,t3,t4,t5,t6;
7382 CREATE TABLE t1 (c1 INT NOT NULL);
7383 CREATE TABLE t2 (c1 INT NOT NULL);
7384 CREATE TABLE t3 (c1 INT NOT NULL);
7385 CREATE TABLE t4 (c1 INT NOT NULL);
7386 CREATE TABLE t5 (c1 INT NOT NULL);
7387 CREATE TABLE t6 (c1 INT NOT NULL);
7388 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
7389 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
7390 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
7391 INSERT INTO t4 (c1) VALUES(10);
7392 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
7393 SELECT t1.c1,t4.c1 FROM t1,t4 WHERE t1.c1 <=> t4.c1;
7394 c1 c1
7395 DROP TABLE t1,t2,t3,t4,t5,t6;
7396 CREATE TABLE t1 (c1 INTEGER NOT NULL);
7397 CREATE TABLE t2 (c1 INTEGER NOT NULL);
7398 CREATE TABLE t3 (c1 INTEGER NOT NULL);
7399 CREATE TABLE t4 (c1 INTEGER NOT NULL);
7400 CREATE TABLE t5 (c1 INTEGER NOT NULL);
7401 CREATE TABLE t6 (c1 INTEGER NOT NULL);
7402 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
7403 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
7404 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
7405 INSERT INTO t4 (c1) VALUES(10);
7406 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
7407 SELECT t1.c1,t4.c1 FROM t1,t4 WHERE t1.c1 <=> t4.c1;
7408 c1 c1
7409 DROP TABLE t1,t2,t3,t4,t5,t6;
7410 CREATE TABLE t1 (c1 BIGINT NOT NULL);
7411 CREATE TABLE t2 (c1 BIGINT NOT NULL);
7412 CREATE TABLE t3 (c1 BIGINT NOT NULL);
7413 CREATE TABLE t4 (c1 BIGINT NOT NULL);
7414 CREATE TABLE t5 (c1 BIGINT NOT NULL);
7415 CREATE TABLE t6 (c1 BIGINT NOT NULL);
7416 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
7417 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
7418 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
7419 INSERT INTO t4 (c1) VALUES(10);
7420 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
7421 SELECT t1.c1,t4.c1 FROM t1,t4 WHERE t1.c1 <=> t4.c1;
7422 c1 c1
7423 DROP TABLE t1,t2,t3,t4,t5,t6;
7424 CREATE TABLE t1 (c1 TINYINT NOT NULL);
7425 CREATE TABLE t2 (c1 TINYINT NOT NULL);
7426 CREATE TABLE t3 (c1 TINYINT NOT NULL);
7427 CREATE TABLE t4 (c1 TINYINT NOT NULL);
7428 CREATE TABLE t5 (c1 TINYINT NOT NULL);
7429 CREATE TABLE t6 (c1 TINYINT NOT NULL);
7430 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
7431 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
7432 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
7433 INSERT INTO t4 (c1) VALUES(10);
7434 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
7435 SELECT t1.c1,t5.c1 FROM t1,t5 WHERE t1.c1 <=> t5.c1;
7436 c1 c1
7437 DROP TABLE t1,t2,t3,t4,t5,t6;
7438 CREATE TABLE t1 (c1 SMALLINT NOT NULL);
7439 CREATE TABLE t2 (c1 SMALLINT NOT NULL);
7440 CREATE TABLE t3 (c1 SMALLINT NOT NULL);
7441 CREATE TABLE t4 (c1 SMALLINT NOT NULL);
7442 CREATE TABLE t5 (c1 SMALLINT NOT NULL);
7443 CREATE TABLE t6 (c1 SMALLINT NOT NULL);
7444 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
7445 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
7446 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
7447 INSERT INTO t4 (c1) VALUES(10);
7448 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
7449 SELECT t1.c1,t5.c1 FROM t1,t5 WHERE t1.c1 <=> t5.c1;
7450 c1 c1
7451 DROP TABLE t1,t2,t3,t4,t5,t6;
7452 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
7453 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
7454 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
7455 CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
7456 CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
7457 CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
7458 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
7459 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
7460 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
7461 INSERT INTO t4 (c1) VALUES(10);
7462 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
7463 SELECT t1.c1,t5.c1 FROM t1,t5 WHERE t1.c1 <=> t5.c1;
7464 c1 c1
7465 DROP TABLE t1,t2,t3,t4,t5,t6;
7466 CREATE TABLE t1 (c1 INT NOT NULL);
7467 CREATE TABLE t2 (c1 INT NOT NULL);
7468 CREATE TABLE t3 (c1 INT NOT NULL);
7469 CREATE TABLE t4 (c1 INT NOT NULL);
7470 CREATE TABLE t5 (c1 INT NOT NULL);
7471 CREATE TABLE t6 (c1 INT NOT NULL);
7472 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
7473 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
7474 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
7475 INSERT INTO t4 (c1) VALUES(10);
7476 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
7477 SELECT t1.c1,t5.c1 FROM t1,t5 WHERE t1.c1 <=> t5.c1;
7478 c1 c1
7479 DROP TABLE t1,t2,t3,t4,t5,t6;
7480 CREATE TABLE t1 (c1 INTEGER NOT NULL);
7481 CREATE TABLE t2 (c1 INTEGER NOT NULL);
7482 CREATE TABLE t3 (c1 INTEGER NOT NULL);
7483 CREATE TABLE t4 (c1 INTEGER NOT NULL);
7484 CREATE TABLE t5 (c1 INTEGER NOT NULL);
7485 CREATE TABLE t6 (c1 INTEGER NOT NULL);
7486 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
7487 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
7488 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
7489 INSERT INTO t4 (c1) VALUES(10);
7490 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
7491 SELECT t1.c1,t5.c1 FROM t1,t5 WHERE t1.c1 <=> t5.c1;
7492 c1 c1
7493 DROP TABLE t1,t2,t3,t4,t5,t6;
7494 CREATE TABLE t1 (c1 BIGINT NOT NULL);
7495 CREATE TABLE t2 (c1 BIGINT NOT NULL);
7496 CREATE TABLE t3 (c1 BIGINT NOT NULL);
7497 CREATE TABLE t4 (c1 BIGINT NOT NULL);
7498 CREATE TABLE t5 (c1 BIGINT NOT NULL);
7499 CREATE TABLE t6 (c1 BIGINT NOT NULL);
7500 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
7501 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
7502 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
7503 INSERT INTO t4 (c1) VALUES(10);
7504 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
7505 SELECT t1.c1,t5.c1 FROM t1,t5 WHERE t1.c1 <=> t5.c1;
7506 c1 c1
7507 DROP TABLE t1,t2,t3,t4,t5,t6;
7508 CREATE TABLE t1 (c1 TINYINT NOT NULL);
7509 CREATE TABLE t2 (c1 TINYINT NOT NULL);
7510 CREATE TABLE t3 (c1 TINYINT NOT NULL);
7511 CREATE TABLE t4 (c1 TINYINT NOT NULL);
7512 CREATE TABLE t5 (c1 TINYINT NOT NULL);
7513 CREATE TABLE t6 (c1 TINYINT NOT NULL);
7514 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
7515 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
7516 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
7517 INSERT INTO t4 (c1) VALUES(10);
7518 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
7519 SELECT t1.c1,t6.c1 FROM t1,t6 WHERE t1.c1 <=> t6.c1;
7520 c1 c1
7521 DROP TABLE t1,t2,t3,t4,t5,t6;
7522 CREATE TABLE t1 (c1 SMALLINT NOT NULL);
7523 CREATE TABLE t2 (c1 SMALLINT NOT NULL);
7524 CREATE TABLE t3 (c1 SMALLINT NOT NULL);
7525 CREATE TABLE t4 (c1 SMALLINT NOT NULL);
7526 CREATE TABLE t5 (c1 SMALLINT NOT NULL);
7527 CREATE TABLE t6 (c1 SMALLINT NOT NULL);
7528 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
7529 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
7530 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
7531 INSERT INTO t4 (c1) VALUES(10);
7532 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
7533 SELECT t1.c1,t6.c1 FROM t1,t6 WHERE t1.c1 <=> t6.c1;
7534 c1 c1
7535 DROP TABLE t1,t2,t3,t4,t5,t6;
7536 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
7537 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
7538 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
7539 CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
7540 CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
7541 CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
7542 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
7543 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
7544 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
7545 INSERT INTO t4 (c1) VALUES(10);
7546 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
7547 SELECT t1.c1,t6.c1 FROM t1,t6 WHERE t1.c1 <=> t6.c1;
7548 c1 c1
7549 DROP TABLE t1,t2,t3,t4,t5,t6;
7550 CREATE TABLE t1 (c1 INT NOT NULL);
7551 CREATE TABLE t2 (c1 INT NOT NULL);
7552 CREATE TABLE t3 (c1 INT NOT NULL);
7553 CREATE TABLE t4 (c1 INT NOT NULL);
7554 CREATE TABLE t5 (c1 INT NOT NULL);
7555 CREATE TABLE t6 (c1 INT NOT NULL);
7556 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
7557 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
7558 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
7559 INSERT INTO t4 (c1) VALUES(10);
7560 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
7561 SELECT t1.c1,t6.c1 FROM t1,t6 WHERE t1.c1 <=> t6.c1;
7562 c1 c1
7563 DROP TABLE t1,t2,t3,t4,t5,t6;
7564 CREATE TABLE t1 (c1 INTEGER NOT NULL);
7565 CREATE TABLE t2 (c1 INTEGER NOT NULL);
7566 CREATE TABLE t3 (c1 INTEGER NOT NULL);
7567 CREATE TABLE t4 (c1 INTEGER NOT NULL);
7568 CREATE TABLE t5 (c1 INTEGER NOT NULL);
7569 CREATE TABLE t6 (c1 INTEGER NOT NULL);
7570 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
7571 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
7572 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
7573 INSERT INTO t4 (c1) VALUES(10);
7574 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
7575 SELECT t1.c1,t6.c1 FROM t1,t6 WHERE t1.c1 <=> t6.c1;
7576 c1 c1
7577 DROP TABLE t1,t2,t3,t4,t5,t6;
7578 CREATE TABLE t1 (c1 BIGINT NOT NULL);
7579 CREATE TABLE t2 (c1 BIGINT NOT NULL);
7580 CREATE TABLE t3 (c1 BIGINT NOT NULL);
7581 CREATE TABLE t4 (c1 BIGINT NOT NULL);
7582 CREATE TABLE t5 (c1 BIGINT NOT NULL);
7583 CREATE TABLE t6 (c1 BIGINT NOT NULL);
7584 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
7585 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
7586 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
7587 INSERT INTO t4 (c1) VALUES(10);
7588 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
7589 SELECT t1.c1,t6.c1 FROM t1,t6 WHERE t1.c1 <=> t6.c1;
7590 c1 c1
7591 DROP TABLE t1,t2,t3,t4,t5,t6;