Debian Codegraph @

mysql-test/suite/engines/funcs/r/se_join_default.result

raw
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 0 3
18 0 4
19 0 5
20 0 6
21 0 7
22 0 8
23 0 9
24 1 2
25 1 3
26 1 4
27 1 5
28 1 6
29 1 7
30 1 8
31 1 9
32 2 3
33 2 4
34 2 5
35 2 6
36 2 7
37 2 8
38 2 9
39 3 4
40 3 5
41 3 6
42 3 7
43 3 8
44 3 9
45 4 5
46 4 6
47 4 7
48 4 8
49 4 9
50 5 6
51 5 7
52 5 8
53 5 9
54 6 7
55 6 8
56 6 9
57 7 8
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 0 3
77 0 4
78 0 5
79 0 6
80 0 7
81 0 8
82 0 9
83 1 2
84 1 3
85 1 4
86 1 5
87 1 6
88 1 7
89 1 8
90 1 9
91 2 3
92 2 4
93 2 5
94 2 6
95 2 7
96 2 8
97 2 9
98 3 4
99 3 5
100 3 6
101 3 7
102 3 8
103 3 9
104 4 5
105 4 6
106 4 7
107 4 8
108 4 9
109 5 6
110 5 7
111 5 8
112 5 9
113 6 7
114 6 8
115 6 9
116 7 8
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 0 3
136 0 4
137 0 5
138 0 6
139 0 7
140 0 8
141 0 9
142 1 2
143 1 3
144 1 4
145 1 5
146 1 6
147 1 7
148 1 8
149 1 9
150 2 3
151 2 4
152 2 5
153 2 6
154 2 7
155 2 8
156 2 9
157 3 4
158 3 5
159 3 6
160 3 7
161 3 8
162 3 9
163 4 5
164 4 6
165 4 7
166 4 8
167 4 9
168 5 6
169 5 7
170 5 8
171 5 9
172 6 7
173 6 8
174 6 9
175 7 8
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 0 3
195 0 4
196 0 5
197 0 6
198 0 7
199 0 8
200 0 9
201 1 2
202 1 3
203 1 4
204 1 5
205 1 6
206 1 7
207 1 8
208 1 9
209 2 3
210 2 4
211 2 5
212 2 6
213 2 7
214 2 8
215 2 9
216 3 4
217 3 5
218 3 6
219 3 7
220 3 8
221 3 9
222 4 5
223 4 6
224 4 7
225 4 8
226 4 9
227 5 6
228 5 7
229 5 8
230 5 9
231 6 7
232 6 8
233 6 9
234 7 8
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 0 3
254 0 4
255 0 5
256 0 6
257 0 7
258 0 8
259 0 9
260 1 2
261 1 3
262 1 4
263 1 5
264 1 6
265 1 7
266 1 8
267 1 9
268 2 3
269 2 4
270 2 5
271 2 6
272 2 7
273 2 8
274 2 9
275 3 4
276 3 5
277 3 6
278 3 7
279 3 8
280 3 9
281 4 5
282 4 6
283 4 7
284 4 8
285 4 9
286 5 6
287 5 7
288 5 8
289 5 9
290 6 7
291 6 8
292 6 9
293 7 8
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 0 3
313 0 4
314 0 5
315 0 6
316 0 7
317 0 8
318 0 9
319 1 2
320 1 3
321 1 4
322 1 5
323 1 6
324 1 7
325 1 8
326 1 9
327 2 3
328 2 4
329 2 5
330 2 6
331 2 7
332 2 8
333 2 9
334 3 4
335 3 5
336 3 6
337 3 7
338 3 8
339 3 9
340 4 5
341 4 6
342 4 7
343 4 8
344 4 9
345 5 6
346 5 7
347 5 8
348 5 9
349 6 7
350 6 8
351 6 9
352 7 8
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 0 2
1218 0 3
1219 0 4
1220 0 5
1221 0 6
1222 0 7
1223 0 8
1224 0 9
1225 1 1
1226 1 2
1227 1 3
1228 1 4
1229 1 5
1230 1 6
1231 1 7
1232 1 8
1233 1 9
1234 2 2
1235 2 3
1236 2 4
1237 2 5
1238 2 6
1239 2 7
1240 2 8
1241 2 9
1242 3 3
1243 3 4
1244 3 5
1245 3 6
1246 3 7
1247 3 8
1248 3 9
1249 4 4
1250 4 5
1251 4 6
1252 4 7
1253 4 8
1254 4 9
1255 5 5
1256 5 6
1257 5 7
1258 5 8
1259 5 9
1260 6 6
1261 6 7
1262 6 8
1263 6 9
1264 7 7
1265 7 8
1266 7 9
1267 8 8
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 0 2
1287 0 3
1288 0 4
1289 0 5
1290 0 6
1291 0 7
1292 0 8
1293 0 9
1294 1 1
1295 1 2
1296 1 3
1297 1 4
1298 1 5
1299 1 6
1300 1 7
1301 1 8
1302 1 9
1303 2 2
1304 2 3
1305 2 4
1306 2 5
1307 2 6
1308 2 7
1309 2 8
1310 2 9
1311 3 3
1312 3 4
1313 3 5
1314 3 6
1315 3 7
1316 3 8
1317 3 9
1318 4 4
1319 4 5
1320 4 6
1321 4 7
1322 4 8
1323 4 9
1324 5 5
1325 5 6
1326 5 7
1327 5 8
1328 5 9
1329 6 6
1330 6 7
1331 6 8
1332 6 9
1333 7 7
1334 7 8
1335 7 9
1336 8 8
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 0 2
1356 0 3
1357 0 4
1358 0 5
1359 0 6
1360 0 7
1361 0 8
1362 0 9
1363 1 1
1364 1 2
1365 1 3
1366 1 4
1367 1 5
1368 1 6
1369 1 7
1370 1 8
1371 1 9
1372 2 2
1373 2 3
1374 2 4
1375 2 5
1376 2 6
1377 2 7
1378 2 8
1379 2 9
1380 3 3
1381 3 4
1382 3 5
1383 3 6
1384 3 7
1385 3 8
1386 3 9
1387 4 4
1388 4 5
1389 4 6
1390 4 7
1391 4 8
1392 4 9
1393 5 5
1394 5 6
1395 5 7
1396 5 8
1397 5 9
1398 6 6
1399 6 7
1400 6 8
1401 6 9
1402 7 7
1403 7 8
1404 7 9
1405 8 8
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 0 2
1425 0 3
1426 0 4
1427 0 5
1428 0 6
1429 0 7
1430 0 8
1431 0 9
1432 1 1
1433 1 2
1434 1 3
1435 1 4
1436 1 5
1437 1 6
1438 1 7
1439 1 8
1440 1 9
1441 2 2
1442 2 3
1443 2 4
1444 2 5
1445 2 6
1446 2 7
1447 2 8
1448 2 9
1449 3 3
1450 3 4
1451 3 5
1452 3 6
1453 3 7
1454 3 8
1455 3 9
1456 4 4
1457 4 5
1458 4 6
1459 4 7
1460 4 8
1461 4 9
1462 5 5
1463 5 6
1464 5 7
1465 5 8
1466 5 9
1467 6 6
1468 6 7
1469 6 8
1470 6 9
1471 7 7
1472 7 8
1473 7 9
1474 8 8
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 0 2
1494 0 3
1495 0 4
1496 0 5
1497 0 6
1498 0 7
1499 0 8
1500 0 9
1501 1 1
1502 1 2
1503 1 3
1504 1 4
1505 1 5
1506 1 6
1507 1 7
1508 1 8
1509 1 9
1510 2 2
1511 2 3
1512 2 4
1513 2 5
1514 2 6
1515 2 7
1516 2 8
1517 2 9
1518 3 3
1519 3 4
1520 3 5
1521 3 6
1522 3 7
1523 3 8
1524 3 9
1525 4 4
1526 4 5
1527 4 6
1528 4 7
1529 4 8
1530 4 9
1531 5 5
1532 5 6
1533 5 7
1534 5 8
1535 5 9
1536 6 6
1537 6 7
1538 6 8
1539 6 9
1540 7 7
1541 7 8
1542 7 9
1543 8 8
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 0 2
1563 0 3
1564 0 4
1565 0 5
1566 0 6
1567 0 7
1568 0 8
1569 0 9
1570 1 1
1571 1 2
1572 1 3
1573 1 4
1574 1 5
1575 1 6
1576 1 7
1577 1 8
1578 1 9
1579 2 2
1580 2 3
1581 2 4
1582 2 5
1583 2 6
1584 2 7
1585 2 8
1586 2 9
1587 3 3
1588 3 4
1589 3 5
1590 3 6
1591 3 7
1592 3 8
1593 3 9
1594 4 4
1595 4 5
1596 4 6
1597 4 7
1598 4 8
1599 4 9
1600 5 5
1601 5 6
1602 5 7
1603 5 8
1604 5 9
1605 6 6
1606 6 7
1607 6 8
1608 6 9
1609 7 7
1610 7 8
1611 7 9
1612 8 8
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 1 1
3018 2 0
3019 2 1
3020 2 2
3021 3 0
3022 3 1
3023 3 2
3024 3 3
3025 4 0
3026 4 1
3027 4 2
3028 4 3
3029 4 4
3030 5 0
3031 5 1
3032 5 2
3033 5 3
3034 5 4
3035 5 5
3036 6 0
3037 6 1
3038 6 2
3039 6 3
3040 6 4
3041 6 5
3042 6 6
3043 7 0
3044 7 1
3045 7 2
3046 7 3
3047 7 4
3048 7 5
3049 7 6
3050 7 7
3051 8 0
3052 8 1
3053 8 2
3054 8 3
3055 8 4
3056 8 5
3057 8 6
3058 8 7
3059 8 8
3060 9 0
3061 9 1
3062 9 2
3063 9 3
3064 9 4
3065 9 5
3066 9 6
3067 9 7
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 1 1
3087 2 0
3088 2 1
3089 2 2
3090 3 0
3091 3 1
3092 3 2
3093 3 3
3094 4 0
3095 4 1
3096 4 2
3097 4 3
3098 4 4
3099 5 0
3100 5 1
3101 5 2
3102 5 3
3103 5 4
3104 5 5
3105 6 0
3106 6 1
3107 6 2
3108 6 3
3109 6 4
3110 6 5
3111 6 6
3112 7 0
3113 7 1
3114 7 2
3115 7 3
3116 7 4
3117 7 5
3118 7 6
3119 7 7
3120 8 0
3121 8 1
3122 8 2
3123 8 3
3124 8 4
3125 8 5
3126 8 6
3127 8 7
3128 8 8
3129 9 0
3130 9 1
3131 9 2
3132 9 3
3133 9 4
3134 9 5
3135 9 6
3136 9 7
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 1 1
3156 2 0
3157 2 1
3158 2 2
3159 3 0
3160 3 1
3161 3 2
3162 3 3
3163 4 0
3164 4 1
3165 4 2
3166 4 3
3167 4 4
3168 5 0
3169 5 1
3170 5 2
3171 5 3
3172 5 4
3173 5 5
3174 6 0
3175 6 1
3176 6 2
3177 6 3
3178 6 4
3179 6 5
3180 6 6
3181 7 0
3182 7 1
3183 7 2
3184 7 3
3185 7 4
3186 7 5
3187 7 6
3188 7 7
3189 8 0
3190 8 1
3191 8 2
3192 8 3
3193 8 4
3194 8 5
3195 8 6
3196 8 7
3197 8 8
3198 9 0
3199 9 1
3200 9 2
3201 9 3
3202 9 4
3203 9 5
3204 9 6
3205 9 7
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 1 1
3225 2 0
3226 2 1
3227 2 2
3228 3 0
3229 3 1
3230 3 2
3231 3 3
3232 4 0
3233 4 1
3234 4 2
3235 4 3
3236 4 4
3237 5 0
3238 5 1
3239 5 2
3240 5 3
3241 5 4
3242 5 5
3243 6 0
3244 6 1
3245 6 2
3246 6 3
3247 6 4
3248 6 5
3249 6 6
3250 7 0
3251 7 1
3252 7 2
3253 7 3
3254 7 4
3255 7 5
3256 7 6
3257 7 7
3258 8 0
3259 8 1
3260 8 2
3261 8 3
3262 8 4
3263 8 5
3264 8 6
3265 8 7
3266 8 8
3267 9 0
3268 9 1
3269 9 2
3270 9 3
3271 9 4
3272 9 5
3273 9 6
3274 9 7
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 1 1
3294 2 0
3295 2 1
3296 2 2
3297 3 0
3298 3 1
3299 3 2
3300 3 3
3301 4 0
3302 4 1
3303 4 2
3304 4 3
3305 4 4
3306 5 0
3307 5 1
3308 5 2
3309 5 3
3310 5 4
3311 5 5
3312 6 0
3313 6 1
3314 6 2
3315 6 3
3316 6 4
3317 6 5
3318 6 6
3319 7 0
3320 7 1
3321 7 2
3322 7 3
3323 7 4
3324 7 5
3325 7 6
3326 7 7
3327 8 0
3328 8 1
3329 8 2
3330 8 3
3331 8 4
3332 8 5
3333 8 6
3334 8 7
3335 8 8
3336 9 0
3337 9 1
3338 9 2
3339 9 3
3340 9 4
3341 9 5
3342 9 6
3343 9 7
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 1 1
3363 2 0
3364 2 1
3365 2 2
3366 3 0
3367 3 1
3368 3 2
3369 3 3
3370 4 0
3371 4 1
3372 4 2
3373 4 3
3374 4 4
3375 5 0
3376 5 1
3377 5 2
3378 5 3
3379 5 4
3380 5 5
3381 6 0
3382 6 1
3383 6 2
3384 6 3
3385 6 4
3386 6 5
3387 6 6
3388 7 0
3389 7 1
3390 7 2
3391 7 3
3392 7 4
3393 7 5
3394 7 6
3395 7 7
3396 8 0
3397 8 1
3398 8 2
3399 8 3
3400 8 4
3401 8 5
3402 8 6
3403 8 7
3404 8 8
3405 9 0
3406 9 1
3407 9 2
3408 9 3
3409 9 4
3410 9 5
3411 9 6
3412 9 7
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 0 1
3916 0 2
3917 0 3
3918 0 4
3919 0 5
3920 0 6
3921 0 7
3922 0 8
3923 0 9
3924 1 0
3925 1 2
3926 1 3
3927 1 4
3928 1 5
3929 1 6
3930 1 7
3931 1 8
3932 1 9
3933 2 0
3934 2 1
3935 2 3
3936 2 4
3937 2 5
3938 2 6
3939 2 7
3940 2 8
3941 2 9
3942 3 0
3943 3 1
3944 3 2
3945 3 4
3946 3 5
3947 3 6
3948 3 7
3949 3 8
3950 3 9
3951 4 0
3952 4 1
3953 4 2
3954 4 3
3955 4 5
3956 4 6
3957 4 7
3958 4 8
3959 4 9
3960 5 0
3961 5 1
3962 5 2
3963 5 3
3964 5 4
3965 5 6
3966 5 7
3967 5 8
3968 5 9
3969 6 0
3970 6 1
3971 6 2
3972 6 3
3973 6 4
3974 6 5
3975 6 7
3976 6 8
3977 6 9
3978 7 0
3979 7 1
3980 7 2
3981 7 3
3982 7 4
3983 7 5
3984 7 6
3985 7 8
3986 7 9
3987 8 0
3988 8 1
3989 8 2
3990 8 3
3991 8 4
3992 8 5
3993 8 6
3994 8 7
3995 8 9
3996 9 0
3997 9 1
3998 9 2
3999 9 3
4000 9 4
4001 9 5
4002 9 6
4003 9 7
4004 9 8
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 0 1
4020 0 2
4021 0 3
4022 0 4
4023 0 5
4024 0 6
4025 0 7
4026 0 8
4027 0 9
4028 1 0
4029 1 2
4030 1 3
4031 1 4
4032 1 5
4033 1 6
4034 1 7
4035 1 8
4036 1 9
4037 2 0
4038 2 1
4039 2 3
4040 2 4
4041 2 5
4042 2 6
4043 2 7
4044 2 8
4045 2 9
4046 3 0
4047 3 1
4048 3 2
4049 3 4
4050 3 5
4051 3 6
4052 3 7
4053 3 8
4054 3 9
4055 4 0
4056 4 1
4057 4 2
4058 4 3
4059 4 5
4060 4 6
4061 4 7
4062 4 8
4063 4 9
4064 5 0
4065 5 1
4066 5 2
4067 5 3
4068 5 4
4069 5 6
4070 5 7
4071 5 8
4072 5 9
4073 6 0
4074 6 1
4075 6 2
4076 6 3
4077 6 4
4078 6 5
4079 6 7
4080 6 8
4081 6 9
4082 7 0
4083 7 1
4084 7 2
4085 7 3
4086 7 4
4087 7 5
4088 7 6
4089 7 8
4090 7 9
4091 8 0
4092 8 1
4093 8 2
4094 8 3
4095 8 4
4096 8 5
4097 8 6
4098 8 7
4099 8 9
4100 9 0
4101 9 1
4102 9 2
4103 9 3
4104 9 4
4105 9 5
4106 9 6
4107 9 7
4108 9 8
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 0 1
4124 0 2
4125 0 3
4126 0 4
4127 0 5
4128 0 6
4129 0 7
4130 0 8
4131 0 9
4132 1 0
4133 1 2
4134 1 3
4135 1 4
4136 1 5
4137 1 6
4138 1 7
4139 1 8
4140 1 9
4141 2 0
4142 2 1
4143 2 3
4144 2 4
4145 2 5
4146 2 6
4147 2 7
4148 2 8
4149 2 9
4150 3 0
4151 3 1
4152 3 2
4153 3 4
4154 3 5
4155 3 6
4156 3 7
4157 3 8
4158 3 9
4159 4 0
4160 4 1
4161 4 2
4162 4 3
4163 4 5
4164 4 6
4165 4 7
4166 4 8
4167 4 9
4168 5 0
4169 5 1
4170 5 2
4171 5 3
4172 5 4
4173 5 6
4174 5 7
4175 5 8
4176 5 9
4177 6 0
4178 6 1
4179 6 2
4180 6 3
4181 6 4
4182 6 5
4183 6 7
4184 6 8
4185 6 9
4186 7 0
4187 7 1
4188 7 2
4189 7 3
4190 7 4
4191 7 5
4192 7 6
4193 7 8
4194 7 9
4195 8 0
4196 8 1
4197 8 2
4198 8 3
4199 8 4
4200 8 5
4201 8 6
4202 8 7
4203 8 9
4204 9 0
4205 9 1
4206 9 2
4207 9 3
4208 9 4
4209 9 5
4210 9 6
4211 9 7
4212 9 8
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 0 1
4228 0 2
4229 0 3
4230 0 4
4231 0 5
4232 0 6
4233 0 7
4234 0 8
4235 0 9
4236 1 0
4237 1 2
4238 1 3
4239 1 4
4240 1 5
4241 1 6
4242 1 7
4243 1 8
4244 1 9
4245 2 0
4246 2 1
4247 2 3
4248 2 4
4249 2 5
4250 2 6
4251 2 7
4252 2 8
4253 2 9
4254 3 0
4255 3 1
4256 3 2
4257 3 4
4258 3 5
4259 3 6
4260 3 7
4261 3 8
4262 3 9
4263 4 0
4264 4 1
4265 4 2
4266 4 3
4267 4 5
4268 4 6
4269 4 7
4270 4 8
4271 4 9
4272 5 0
4273 5 1
4274 5 2
4275 5 3
4276 5 4
4277 5 6
4278 5 7
4279 5 8
4280 5 9
4281 6 0
4282 6 1
4283 6 2
4284 6 3
4285 6 4
4286 6 5
4287 6 7
4288 6 8
4289 6 9
4290 7 0
4291 7 1
4292 7 2
4293 7 3
4294 7 4
4295 7 5
4296 7 6
4297 7 8
4298 7 9
4299 8 0
4300 8 1
4301 8 2
4302 8 3
4303 8 4
4304 8 5
4305 8 6
4306 8 7
4307 8 9
4308 9 0
4309 9 1
4310 9 2
4311 9 3
4312 9 4
4313 9 5
4314 9 6
4315 9 7
4316 9 8
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 0 1
4332 0 2
4333 0 3
4334 0 4
4335 0 5
4336 0 6
4337 0 7
4338 0 8
4339 0 9
4340 1 0
4341 1 2
4342 1 3
4343 1 4
4344 1 5
4345 1 6
4346 1 7
4347 1 8
4348 1 9
4349 2 0
4350 2 1
4351 2 3
4352 2 4
4353 2 5
4354 2 6
4355 2 7
4356 2 8
4357 2 9
4358 3 0
4359 3 1
4360 3 2
4361 3 4
4362 3 5
4363 3 6
4364 3 7
4365 3 8
4366 3 9
4367 4 0
4368 4 1
4369 4 2
4370 4 3
4371 4 5
4372 4 6
4373 4 7
4374 4 8
4375 4 9
4376 5 0
4377 5 1
4378 5 2
4379 5 3
4380 5 4
4381 5 6
4382 5 7
4383 5 8
4384 5 9
4385 6 0
4386 6 1
4387 6 2
4388 6 3
4389 6 4
4390 6 5
4391 6 7
4392 6 8
4393 6 9
4394 7 0
4395 7 1
4396 7 2
4397 7 3
4398 7 4
4399 7 5
4400 7 6
4401 7 8
4402 7 9
4403 8 0
4404 8 1
4405 8 2
4406 8 3
4407 8 4
4408 8 5
4409 8 6
4410 8 7
4411 8 9
4412 9 0
4413 9 1
4414 9 2
4415 9 3
4416 9 4
4417 9 5
4418 9 6
4419 9 7
4420 9 8
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 0 1
4436 0 2
4437 0 3
4438 0 4
4439 0 5
4440 0 6
4441 0 7
4442 0 8
4443 0 9
4444 1 0
4445 1 2
4446 1 3
4447 1 4
4448 1 5
4449 1 6
4450 1 7
4451 1 8
4452 1 9
4453 2 0
4454 2 1
4455 2 3
4456 2 4
4457 2 5
4458 2 6
4459 2 7
4460 2 8
4461 2 9
4462 3 0
4463 3 1
4464 3 2
4465 3 4
4466 3 5
4467 3 6
4468 3 7
4469 3 8
4470 3 9
4471 4 0
4472 4 1
4473 4 2
4474 4 3
4475 4 5
4476 4 6
4477 4 7
4478 4 8
4479 4 9
4480 5 0
4481 5 1
4482 5 2
4483 5 3
4484 5 4
4485 5 6
4486 5 7
4487 5 8
4488 5 9
4489 6 0
4490 6 1
4491 6 2
4492 6 3
4493 6 4
4494 6 5
4495 6 7
4496 6 8
4497 6 9
4498 7 0
4499 7 1
4500 7 2
4501 7 3
4502 7 4
4503 7 5
4504 7 6
4505 7 8
4506 7 9
4507 8 0
4508 8 1
4509 8 2
4510 8 3
4511 8 4
4512 8 5
4513 8 6
4514 8 7
4515 8 9
4516 9 0
4517 9 1
4518 9 2
4519 9 3
4520 9 4
4521 9 5
4522 9 6
4523 9 7
4524 9 8
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 0 1
5506 0 2
5507 0 3
5508 0 4
5509 0 5
5510 0 6
5511 0 7
5512 0 8
5513 0 9
5514 1 0
5515 1 2
5516 1 3
5517 1 4
5518 1 5
5519 1 6
5520 1 7
5521 1 8
5522 1 9
5523 2 0
5524 2 1
5525 2 3
5526 2 4
5527 2 5
5528 2 6
5529 2 7
5530 2 8
5531 2 9
5532 3 0
5533 3 1
5534 3 2
5535 3 4
5536 3 5
5537 3 6
5538 3 7
5539 3 8
5540 3 9
5541 4 0
5542 4 1
5543 4 2
5544 4 3
5545 4 5
5546 4 6
5547 4 7
5548 4 8
5549 4 9
5550 5 0
5551 5 1
5552 5 2
5553 5 3
5554 5 4
5555 5 6
5556 5 7
5557 5 8
5558 5 9
5559 6 0
5560 6 1
5561 6 2
5562 6 3
5563 6 4
5564 6 5
5565 6 7
5566 6 8
5567 6 9
5568 7 0
5569 7 1
5570 7 2
5571 7 3
5572 7 4
5573 7 5
5574 7 6
5575 7 8
5576 7 9
5577 8 0
5578 8 1
5579 8 2
5580 8 3
5581 8 4
5582 8 5
5583 8 6
5584 8 7
5585 8 9
5586 9 0
5587 9 1
5588 9 2
5589 9 3
5590 9 4
5591 9 5
5592 9 6
5593 9 7
5594 9 8
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 0 1
5610 0 2
5611 0 3
5612 0 4
5613 0 5
5614 0 6
5615 0 7
5616 0 8
5617 0 9
5618 1 0
5619 1 2
5620 1 3
5621 1 4
5622 1 5
5623 1 6
5624 1 7
5625 1 8
5626 1 9
5627 2 0
5628 2 1
5629 2 3
5630 2 4
5631 2 5
5632 2 6
5633 2 7
5634 2 8
5635 2 9
5636 3 0
5637 3 1
5638 3 2
5639 3 4
5640 3 5
5641 3 6
5642 3 7
5643 3 8
5644 3 9
5645 4 0
5646 4 1
5647 4 2
5648 4 3
5649 4 5
5650 4 6
5651 4 7
5652 4 8
5653 4 9
5654 5 0
5655 5 1
5656 5 2
5657 5 3
5658 5 4
5659 5 6
5660 5 7
5661 5 8
5662 5 9
5663 6 0
5664 6 1
5665 6 2
5666 6 3
5667 6 4
5668 6 5
5669 6 7
5670 6 8
5671 6 9
5672 7 0
5673 7 1
5674 7 2
5675 7 3
5676 7 4
5677 7 5
5678 7 6
5679 7 8
5680 7 9
5681 8 0
5682 8 1
5683 8 2
5684 8 3
5685 8 4
5686 8 5
5687 8 6
5688 8 7
5689 8 9
5690 9 0
5691 9 1
5692 9 2
5693 9 3
5694 9 4
5695 9 5
5696 9 6
5697 9 7
5698 9 8
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 0 1
5714 0 2
5715 0 3
5716 0 4
5717 0 5
5718 0 6
5719 0 7
5720 0 8
5721 0 9
5722 1 0
5723 1 2
5724 1 3
5725 1 4
5726 1 5
5727 1 6
5728 1 7
5729 1 8
5730 1 9
5731 2 0
5732 2 1
5733 2 3
5734 2 4
5735 2 5
5736 2 6
5737 2 7
5738 2 8
5739 2 9
5740 3 0
5741 3 1
5742 3 2
5743 3 4
5744 3 5
5745 3 6
5746 3 7
5747 3 8
5748 3 9
5749 4 0
5750 4 1
5751 4 2
5752 4 3
5753 4 5
5754 4 6
5755 4 7
5756 4 8
5757 4 9
5758 5 0
5759 5 1
5760 5 2
5761 5 3
5762 5 4
5763 5 6
5764 5 7
5765 5 8
5766 5 9
5767 6 0
5768 6 1
5769 6 2
5770 6 3
5771 6 4
5772 6 5
5773 6 7
5774 6 8
5775 6 9
5776 7 0
5777 7 1
5778 7 2
5779 7 3
5780 7 4
5781 7 5
5782 7 6
5783 7 8
5784 7 9
5785 8 0
5786 8 1
5787 8 2
5788 8 3
5789 8 4
5790 8 5
5791 8 6
5792 8 7
5793 8 9
5794 9 0
5795 9 1
5796 9 2
5797 9 3
5798 9 4
5799 9 5
5800 9 6
5801 9 7
5802 9 8
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 0 1
5818 0 2
5819 0 3
5820 0 4
5821 0 5
5822 0 6
5823 0 7
5824 0 8
5825 0 9
5826 1 0
5827 1 2
5828 1 3
5829 1 4
5830 1 5
5831 1 6
5832 1 7
5833 1 8
5834 1 9
5835 2 0
5836 2 1
5837 2 3
5838 2 4
5839 2 5
5840 2 6
5841 2 7
5842 2 8
5843 2 9
5844 3 0
5845 3 1
5846 3 2
5847 3 4
5848 3 5
5849 3 6
5850 3 7
5851 3 8
5852 3 9
5853 4 0
5854 4 1
5855 4 2
5856 4 3
5857 4 5
5858 4 6
5859 4 7
5860 4 8
5861 4 9
5862 5 0
5863 5 1
5864 5 2
5865 5 3
5866 5 4
5867 5 6
5868 5 7
5869 5 8
5870 5 9
5871 6 0
5872 6 1
5873 6 2
5874 6 3
5875 6 4
5876 6 5
5877 6 7
5878 6 8
5879 6 9
5880 7 0
5881 7 1
5882 7 2
5883 7 3
5884 7 4
5885 7 5
5886 7 6
5887 7 8
5888 7 9
5889 8 0
5890 8 1
5891 8 2
5892 8 3
5893 8 4
5894 8 5
5895 8 6
5896 8 7
5897 8 9
5898 9 0
5899 9 1
5900 9 2
5901 9 3
5902 9 4
5903 9 5
5904 9 6
5905 9 7
5906 9 8
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 0 1
5922 0 2
5923 0 3
5924 0 4
5925 0 5
5926 0 6
5927 0 7
5928 0 8
5929 0 9
5930 1 0
5931 1 2
5932 1 3
5933 1 4
5934 1 5
5935 1 6
5936 1 7
5937 1 8
5938 1 9
5939 2 0
5940 2 1
5941 2 3
5942 2 4
5943 2 5
5944 2 6
5945 2 7
5946 2 8
5947 2 9
5948 3 0
5949 3 1
5950 3 2
5951 3 4
5952 3 5
5953 3 6
5954 3 7
5955 3 8
5956 3 9
5957 4 0
5958 4 1
5959 4 2
5960 4 3
5961 4 5
5962 4 6
5963 4 7
5964 4 8
5965 4 9
5966 5 0
5967 5 1
5968 5 2
5969 5 3
5970 5 4
5971 5 6
5972 5 7
5973 5 8
5974 5 9
5975 6 0
5976 6 1
5977 6 2
5978 6 3
5979 6 4
5980 6 5
5981 6 7
5982 6 8
5983 6 9
5984 7 0
5985 7 1
5986 7 2
5987 7 3
5988 7 4
5989 7 5
5990 7 6
5991 7 8
5992 7 9
5993 8 0
5994 8 1
5995 8 2
5996 8 3
5997 8 4
5998 8 5
5999 8 6
6000 8 7
6001 8 9
6002 9 0
6003 9 1
6004 9 2
6005 9 3
6006 9 4
6007 9 5
6008 9 6
6009 9 7
6010 9 8
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 0 1
6026 0 2
6027 0 3
6028 0 4
6029 0 5
6030 0 6
6031 0 7
6032 0 8
6033 0 9
6034 1 0
6035 1 2
6036 1 3
6037 1 4
6038 1 5
6039 1 6
6040 1 7
6041 1 8
6042 1 9
6043 2 0
6044 2 1
6045 2 3
6046 2 4
6047 2 5
6048 2 6
6049 2 7
6050 2 8
6051 2 9
6052 3 0
6053 3 1
6054 3 2
6055 3 4
6056 3 5
6057 3 6
6058 3 7
6059 3 8
6060 3 9
6061 4 0
6062 4 1
6063 4 2
6064 4 3
6065 4 5
6066 4 6
6067 4 7
6068 4 8
6069 4 9
6070 5 0
6071 5 1
6072 5 2
6073 5 3
6074 5 4
6075 5 6
6076 5 7
6077 5 8
6078 5 9
6079 6 0
6080 6 1
6081 6 2
6082 6 3
6083 6 4
6084 6 5
6085 6 7
6086 6 8
6087 6 9
6088 7 0
6089 7 1
6090 7 2
6091 7 3
6092 7 4
6093 7 5
6094 7 6
6095 7 8
6096 7 9
6097 8 0
6098 8 1
6099 8 2
6100 8 3
6101 8 4
6102 8 5
6103 8 6
6104 8 7
6105 8 9
6106 9 0
6107 9 1
6108 9 2
6109 9 3
6110 9 4
6111 9 5
6112 9 6
6113 9 7
6114 9 8
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;