1DROP TABLE IF EXISTS t1,t2,t3,t4,t5,t6; 2CREATE TABLE t1 (c1 TINYINT NOT NULL); 3CREATE TABLE t2 (c1 TINYINT NOT NULL); 4CREATE TABLE t3 (c1 TINYINT NOT NULL); 5CREATE TABLE t4 (c1 TINYINT NOT NULL); 6CREATE TABLE t5 (c1 TINYINT NOT NULL); 7CREATE TABLE t6 (c1 TINYINT NOT NULL); 8INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 9INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 10INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 11INSERT INTO t4 (c1) VALUES(10); 12INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 13SELECT t1.c1,t2.c1 FROM t1 LEFT OUTER JOIN t2 ON t1.c1 = t2.c1 ORDER BY t1.c1,t2.c1; 14c1 c1 150 0 161 1 172 2 183 3 194 4 205 5 216 6 227 7 238 8 249 9 25SELECT t1.c1,t2.c1 FROM t1 LEFT OUTER JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 < 5 ORDER BY t1.c1,t2.c1; 26c1 c1 270 0 281 1 292 2 303 3 314 4 32DROP TABLE t1,t2,t3,t4,t5,t6; 33CREATE TABLE t1 (c1 SMALLINT NOT NULL); 34CREATE TABLE t2 (c1 SMALLINT NOT NULL); 35CREATE TABLE t3 (c1 SMALLINT NOT NULL); 36CREATE TABLE t4 (c1 SMALLINT NOT NULL); 37CREATE TABLE t5 (c1 SMALLINT NOT NULL); 38CREATE TABLE t6 (c1 SMALLINT NOT NULL); 39INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 40INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 41INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 42INSERT INTO t4 (c1) VALUES(10); 43INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 44SELECT t1.c1,t2.c1 FROM t1 LEFT OUTER JOIN t2 ON t1.c1 = t2.c1 ORDER BY t1.c1,t2.c1; 45c1 c1 460 0 471 1 482 2 493 3 504 4 515 5 526 6 537 7 548 8 559 9 56SELECT t1.c1,t2.c1 FROM t1 LEFT OUTER JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 < 5 ORDER BY t1.c1,t2.c1; 57c1 c1 580 0 591 1 602 2 613 3 624 4 63DROP TABLE t1,t2,t3,t4,t5,t6; 64CREATE TABLE t1 (c1 MEDIUMINT NOT NULL); 65CREATE TABLE t2 (c1 MEDIUMINT NOT NULL); 66CREATE TABLE t3 (c1 MEDIUMINT NOT NULL); 67CREATE TABLE t4 (c1 MEDIUMINT NOT NULL); 68CREATE TABLE t5 (c1 MEDIUMINT NOT NULL); 69CREATE TABLE t6 (c1 MEDIUMINT NOT NULL); 70INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 71INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 72INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 73INSERT INTO t4 (c1) VALUES(10); 74INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 75SELECT t1.c1,t2.c1 FROM t1 LEFT OUTER JOIN t2 ON t1.c1 = t2.c1 ORDER BY t1.c1,t2.c1; 76c1 c1 770 0 781 1 792 2 803 3 814 4 825 5 836 6 847 7 858 8 869 9 87SELECT t1.c1,t2.c1 FROM t1 LEFT OUTER JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 < 5 ORDER BY t1.c1,t2.c1; 88c1 c1 890 0 901 1 912 2 923 3 934 4 94DROP TABLE t1,t2,t3,t4,t5,t6; 95CREATE TABLE t1 (c1 INT NOT NULL); 96CREATE TABLE t2 (c1 INT NOT NULL); 97CREATE TABLE t3 (c1 INT NOT NULL); 98CREATE TABLE t4 (c1 INT NOT NULL); 99CREATE TABLE t5 (c1 INT NOT NULL); 100CREATE TABLE t6 (c1 INT NOT NULL); 101INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 102INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 103INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 104INSERT INTO t4 (c1) VALUES(10); 105INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 106SELECT t1.c1,t2.c1 FROM t1 LEFT OUTER JOIN t2 ON t1.c1 = t2.c1 ORDER BY t1.c1,t2.c1; 107c1 c1 1080 0 1091 1 1102 2 1113 3 1124 4 1135 5 1146 6 1157 7 1168 8 1179 9 118SELECT t1.c1,t2.c1 FROM t1 LEFT OUTER JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 < 5 ORDER BY t1.c1,t2.c1; 119c1 c1 1200 0 1211 1 1222 2 1233 3 1244 4 125DROP TABLE t1,t2,t3,t4,t5,t6; 126CREATE TABLE t1 (c1 INTEGER NOT NULL); 127CREATE TABLE t2 (c1 INTEGER NOT NULL); 128CREATE TABLE t3 (c1 INTEGER NOT NULL); 129CREATE TABLE t4 (c1 INTEGER NOT NULL); 130CREATE TABLE t5 (c1 INTEGER NOT NULL); 131CREATE TABLE t6 (c1 INTEGER NOT NULL); 132INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 133INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 134INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 135INSERT INTO t4 (c1) VALUES(10); 136INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 137SELECT t1.c1,t2.c1 FROM t1 LEFT OUTER JOIN t2 ON t1.c1 = t2.c1 ORDER BY t1.c1,t2.c1; 138c1 c1 1390 0 1401 1 1412 2 1423 3 1434 4 1445 5 1456 6 1467 7 1478 8 1489 9 149SELECT t1.c1,t2.c1 FROM t1 LEFT OUTER JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 < 5 ORDER BY t1.c1,t2.c1; 150c1 c1 1510 0 1521 1 1532 2 1543 3 1554 4 156DROP TABLE t1,t2,t3,t4,t5,t6; 157CREATE TABLE t1 (c1 BIGINT NOT NULL); 158CREATE TABLE t2 (c1 BIGINT NOT NULL); 159CREATE TABLE t3 (c1 BIGINT NOT NULL); 160CREATE TABLE t4 (c1 BIGINT NOT NULL); 161CREATE TABLE t5 (c1 BIGINT NOT NULL); 162CREATE TABLE t6 (c1 BIGINT NOT NULL); 163INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 164INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 165INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 166INSERT INTO t4 (c1) VALUES(10); 167INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 168SELECT t1.c1,t2.c1 FROM t1 LEFT OUTER JOIN t2 ON t1.c1 = t2.c1 ORDER BY t1.c1,t2.c1; 169c1 c1 1700 0 1711 1 1722 2 1733 3 1744 4 1755 5 1766 6 1777 7 1788 8 1799 9 180SELECT t1.c1,t2.c1 FROM t1 LEFT OUTER JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 < 5 ORDER BY t1.c1,t2.c1; 181c1 c1 1820 0 1831 1 1842 2 1853 3 1864 4 187DROP TABLE t1,t2,t3,t4,t5,t6; 188CREATE TABLE t1 (c1 TINYINT NOT NULL); 189CREATE TABLE t2 (c1 TINYINT NOT NULL); 190CREATE TABLE t3 (c1 TINYINT NOT NULL); 191CREATE TABLE t4 (c1 TINYINT NOT NULL); 192CREATE TABLE t5 (c1 TINYINT NOT NULL); 193CREATE TABLE t6 (c1 TINYINT NOT NULL); 194INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 195INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 196INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 197INSERT INTO t4 (c1) VALUES(10); 198INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 199SELECT t1.c1,t3.c1 FROM t1 LEFT OUTER JOIN t3 ON t1.c1 = t3.c1 ORDER BY t1.c1,t3.c1; 200c1 c1 2010 NULL 2021 1 2032 NULL 2043 3 2054 NULL 2065 5 2076 NULL 2087 7 2098 NULL 2109 9 211SELECT t1.c1,t3.c1 FROM t1 LEFT OUTER JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 < 5 ORDER BY t1.c1,t3.c1; 212c1 c1 2130 NULL 2141 1 2152 NULL 2163 3 2174 NULL 218DROP TABLE t1,t2,t3,t4,t5,t6; 219CREATE TABLE t1 (c1 SMALLINT NOT NULL); 220CREATE TABLE t2 (c1 SMALLINT NOT NULL); 221CREATE TABLE t3 (c1 SMALLINT NOT NULL); 222CREATE TABLE t4 (c1 SMALLINT NOT NULL); 223CREATE TABLE t5 (c1 SMALLINT NOT NULL); 224CREATE TABLE t6 (c1 SMALLINT NOT NULL); 225INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 226INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 227INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 228INSERT INTO t4 (c1) VALUES(10); 229INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 230SELECT t1.c1,t3.c1 FROM t1 LEFT OUTER JOIN t3 ON t1.c1 = t3.c1 ORDER BY t1.c1,t3.c1; 231c1 c1 2320 NULL 2331 1 2342 NULL 2353 3 2364 NULL 2375 5 2386 NULL 2397 7 2408 NULL 2419 9 242SELECT t1.c1,t3.c1 FROM t1 LEFT OUTER JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 < 5 ORDER BY t1.c1,t3.c1; 243c1 c1 2440 NULL 2451 1 2462 NULL 2473 3 2484 NULL 249DROP TABLE t1,t2,t3,t4,t5,t6; 250CREATE TABLE t1 (c1 MEDIUMINT NOT NULL); 251CREATE TABLE t2 (c1 MEDIUMINT NOT NULL); 252CREATE TABLE t3 (c1 MEDIUMINT NOT NULL); 253CREATE TABLE t4 (c1 MEDIUMINT NOT NULL); 254CREATE TABLE t5 (c1 MEDIUMINT NOT NULL); 255CREATE TABLE t6 (c1 MEDIUMINT NOT NULL); 256INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 257INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 258INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 259INSERT INTO t4 (c1) VALUES(10); 260INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 261SELECT t1.c1,t3.c1 FROM t1 LEFT OUTER JOIN t3 ON t1.c1 = t3.c1 ORDER BY t1.c1,t3.c1; 262c1 c1 2630 NULL 2641 1 2652 NULL 2663 3 2674 NULL 2685 5 2696 NULL 2707 7 2718 NULL 2729 9 273SELECT t1.c1,t3.c1 FROM t1 LEFT OUTER JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 < 5 ORDER BY t1.c1,t3.c1; 274c1 c1 2750 NULL 2761 1 2772 NULL 2783 3 2794 NULL 280DROP TABLE t1,t2,t3,t4,t5,t6; 281CREATE TABLE t1 (c1 INT NOT NULL); 282CREATE TABLE t2 (c1 INT NOT NULL); 283CREATE TABLE t3 (c1 INT NOT NULL); 284CREATE TABLE t4 (c1 INT NOT NULL); 285CREATE TABLE t5 (c1 INT NOT NULL); 286CREATE TABLE t6 (c1 INT NOT NULL); 287INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 288INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 289INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 290INSERT INTO t4 (c1) VALUES(10); 291INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 292SELECT t1.c1,t3.c1 FROM t1 LEFT OUTER JOIN t3 ON t1.c1 = t3.c1 ORDER BY t1.c1,t3.c1; 293c1 c1 2940 NULL 2951 1 2962 NULL 2973 3 2984 NULL 2995 5 3006 NULL 3017 7 3028 NULL 3039 9 304SELECT t1.c1,t3.c1 FROM t1 LEFT OUTER JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 < 5 ORDER BY t1.c1,t3.c1; 305c1 c1 3060 NULL 3071 1 3082 NULL 3093 3 3104 NULL 311DROP TABLE t1,t2,t3,t4,t5,t6; 312CREATE TABLE t1 (c1 INTEGER NOT NULL); 313CREATE TABLE t2 (c1 INTEGER NOT NULL); 314CREATE TABLE t3 (c1 INTEGER NOT NULL); 315CREATE TABLE t4 (c1 INTEGER NOT NULL); 316CREATE TABLE t5 (c1 INTEGER NOT NULL); 317CREATE TABLE t6 (c1 INTEGER NOT NULL); 318INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 319INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 320INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 321INSERT INTO t4 (c1) VALUES(10); 322INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 323SELECT t1.c1,t3.c1 FROM t1 LEFT OUTER JOIN t3 ON t1.c1 = t3.c1 ORDER BY t1.c1,t3.c1; 324c1 c1 3250 NULL 3261 1 3272 NULL 3283 3 3294 NULL 3305 5 3316 NULL 3327 7 3338 NULL 3349 9 335SELECT t1.c1,t3.c1 FROM t1 LEFT OUTER JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 < 5 ORDER BY t1.c1,t3.c1; 336c1 c1 3370 NULL 3381 1 3392 NULL 3403 3 3414 NULL 342DROP TABLE t1,t2,t3,t4,t5,t6; 343CREATE TABLE t1 (c1 BIGINT NOT NULL); 344CREATE TABLE t2 (c1 BIGINT NOT NULL); 345CREATE TABLE t3 (c1 BIGINT NOT NULL); 346CREATE TABLE t4 (c1 BIGINT NOT NULL); 347CREATE TABLE t5 (c1 BIGINT NOT NULL); 348CREATE TABLE t6 (c1 BIGINT NOT NULL); 349INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 350INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 351INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 352INSERT INTO t4 (c1) VALUES(10); 353INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 354SELECT t1.c1,t3.c1 FROM t1 LEFT OUTER JOIN t3 ON t1.c1 = t3.c1 ORDER BY t1.c1,t3.c1; 355c1 c1 3560 NULL 3571 1 3582 NULL 3593 3 3604 NULL 3615 5 3626 NULL 3637 7 3648 NULL 3659 9 366SELECT t1.c1,t3.c1 FROM t1 LEFT OUTER JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 < 5 ORDER BY t1.c1,t3.c1; 367c1 c1 3680 NULL 3691 1 3702 NULL 3713 3 3724 NULL 373DROP TABLE t1,t2,t3,t4,t5,t6; 374CREATE TABLE t1 (c1 TINYINT NOT NULL); 375CREATE TABLE t2 (c1 TINYINT NOT NULL); 376CREATE TABLE t3 (c1 TINYINT NOT NULL); 377CREATE TABLE t4 (c1 TINYINT NOT NULL); 378CREATE TABLE t5 (c1 TINYINT NOT NULL); 379CREATE TABLE t6 (c1 TINYINT NOT NULL); 380INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 381INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 382INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 383INSERT INTO t4 (c1) VALUES(10); 384INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 385SELECT t1.c1,t4.c1 FROM t1 LEFT OUTER JOIN t4 ON t1.c1 = t4.c1 ORDER BY t1.c1,t4.c1; 386c1 c1 3870 NULL 3881 NULL 3892 NULL 3903 NULL 3914 NULL 3925 NULL 3936 NULL 3947 NULL 3958 NULL 3969 NULL 397SELECT t1.c1,t4.c1 FROM t1 LEFT OUTER JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 < 5 ORDER BY t1.c1,t4.c1; 398c1 c1 3990 NULL 4001 NULL 4012 NULL 4023 NULL 4034 NULL 404DROP TABLE t1,t2,t3,t4,t5,t6; 405CREATE TABLE t1 (c1 SMALLINT NOT NULL); 406CREATE TABLE t2 (c1 SMALLINT NOT NULL); 407CREATE TABLE t3 (c1 SMALLINT NOT NULL); 408CREATE TABLE t4 (c1 SMALLINT NOT NULL); 409CREATE TABLE t5 (c1 SMALLINT NOT NULL); 410CREATE TABLE t6 (c1 SMALLINT NOT NULL); 411INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 412INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 413INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 414INSERT INTO t4 (c1) VALUES(10); 415INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 416SELECT t1.c1,t4.c1 FROM t1 LEFT OUTER JOIN t4 ON t1.c1 = t4.c1 ORDER BY t1.c1,t4.c1; 417c1 c1 4180 NULL 4191 NULL 4202 NULL 4213 NULL 4224 NULL 4235 NULL 4246 NULL 4257 NULL 4268 NULL 4279 NULL 428SELECT t1.c1,t4.c1 FROM t1 LEFT OUTER JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 < 5 ORDER BY t1.c1,t4.c1; 429c1 c1 4300 NULL 4311 NULL 4322 NULL 4333 NULL 4344 NULL 435DROP TABLE t1,t2,t3,t4,t5,t6; 436CREATE TABLE t1 (c1 MEDIUMINT NOT NULL); 437CREATE TABLE t2 (c1 MEDIUMINT NOT NULL); 438CREATE TABLE t3 (c1 MEDIUMINT NOT NULL); 439CREATE TABLE t4 (c1 MEDIUMINT NOT NULL); 440CREATE TABLE t5 (c1 MEDIUMINT NOT NULL); 441CREATE TABLE t6 (c1 MEDIUMINT NOT NULL); 442INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 443INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 444INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 445INSERT INTO t4 (c1) VALUES(10); 446INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 447SELECT t1.c1,t4.c1 FROM t1 LEFT OUTER JOIN t4 ON t1.c1 = t4.c1 ORDER BY t1.c1,t4.c1; 448c1 c1 4490 NULL 4501 NULL 4512 NULL 4523 NULL 4534 NULL 4545 NULL 4556 NULL 4567 NULL 4578 NULL 4589 NULL 459SELECT t1.c1,t4.c1 FROM t1 LEFT OUTER JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 < 5 ORDER BY t1.c1,t4.c1; 460c1 c1 4610 NULL 4621 NULL 4632 NULL 4643 NULL 4654 NULL 466DROP TABLE t1,t2,t3,t4,t5,t6; 467CREATE TABLE t1 (c1 INT NOT NULL); 468CREATE TABLE t2 (c1 INT NOT NULL); 469CREATE TABLE t3 (c1 INT NOT NULL); 470CREATE TABLE t4 (c1 INT NOT NULL); 471CREATE TABLE t5 (c1 INT NOT NULL); 472CREATE TABLE t6 (c1 INT NOT NULL); 473INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 474INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 475INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 476INSERT INTO t4 (c1) VALUES(10); 477INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 478SELECT t1.c1,t4.c1 FROM t1 LEFT OUTER JOIN t4 ON t1.c1 = t4.c1 ORDER BY t1.c1,t4.c1; 479c1 c1 4800 NULL 4811 NULL 4822 NULL 4833 NULL 4844 NULL 4855 NULL 4866 NULL 4877 NULL 4888 NULL 4899 NULL 490SELECT t1.c1,t4.c1 FROM t1 LEFT OUTER JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 < 5 ORDER BY t1.c1,t4.c1; 491c1 c1 4920 NULL 4931 NULL 4942 NULL 4953 NULL 4964 NULL 497DROP TABLE t1,t2,t3,t4,t5,t6; 498CREATE TABLE t1 (c1 INTEGER NOT NULL); 499CREATE TABLE t2 (c1 INTEGER NOT NULL); 500CREATE TABLE t3 (c1 INTEGER NOT NULL); 501CREATE TABLE t4 (c1 INTEGER NOT NULL); 502CREATE TABLE t5 (c1 INTEGER NOT NULL); 503CREATE TABLE t6 (c1 INTEGER NOT NULL); 504INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 505INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 506INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 507INSERT INTO t4 (c1) VALUES(10); 508INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 509SELECT t1.c1,t4.c1 FROM t1 LEFT OUTER JOIN t4 ON t1.c1 = t4.c1 ORDER BY t1.c1,t4.c1; 510c1 c1 5110 NULL 5121 NULL 5132 NULL 5143 NULL 5154 NULL 5165 NULL 5176 NULL 5187 NULL 5198 NULL 5209 NULL 521SELECT t1.c1,t4.c1 FROM t1 LEFT OUTER JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 < 5 ORDER BY t1.c1,t4.c1; 522c1 c1 5230 NULL 5241 NULL 5252 NULL 5263 NULL 5274 NULL 528DROP TABLE t1,t2,t3,t4,t5,t6; 529CREATE TABLE t1 (c1 BIGINT NOT NULL); 530CREATE TABLE t2 (c1 BIGINT NOT NULL); 531CREATE TABLE t3 (c1 BIGINT NOT NULL); 532CREATE TABLE t4 (c1 BIGINT NOT NULL); 533CREATE TABLE t5 (c1 BIGINT NOT NULL); 534CREATE TABLE t6 (c1 BIGINT NOT NULL); 535INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 536INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 537INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 538INSERT INTO t4 (c1) VALUES(10); 539INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 540SELECT t1.c1,t4.c1 FROM t1 LEFT OUTER JOIN t4 ON t1.c1 = t4.c1 ORDER BY t1.c1,t4.c1; 541c1 c1 5420 NULL 5431 NULL 5442 NULL 5453 NULL 5464 NULL 5475 NULL 5486 NULL 5497 NULL 5508 NULL 5519 NULL 552SELECT t1.c1,t4.c1 FROM t1 LEFT OUTER JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 < 5 ORDER BY t1.c1,t4.c1; 553c1 c1 5540 NULL 5551 NULL 5562 NULL 5573 NULL 5584 NULL 559DROP TABLE t1,t2,t3,t4,t5,t6; 560CREATE TABLE t1 (c1 TINYINT NOT NULL); 561CREATE TABLE t2 (c1 TINYINT NOT NULL); 562CREATE TABLE t3 (c1 TINYINT NOT NULL); 563CREATE TABLE t4 (c1 TINYINT NOT NULL); 564CREATE TABLE t5 (c1 TINYINT NOT NULL); 565CREATE TABLE t6 (c1 TINYINT NOT NULL); 566INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 567INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 568INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 569INSERT INTO t4 (c1) VALUES(10); 570INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 571SELECT t1.c1,t5.c1 FROM t1 LEFT OUTER JOIN t5 ON t1.c1 = t5.c1 ORDER BY t1.c1,t5.c1; 572c1 c1 5730 NULL 5741 NULL 5752 NULL 5763 NULL 5774 NULL 5785 NULL 5796 NULL 5807 NULL 5818 NULL 5829 NULL 583SELECT t1.c1,t5.c1 FROM t1 LEFT OUTER JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 < 5 ORDER BY t1.c1,t5.c1; 584c1 c1 5850 NULL 5861 NULL 5872 NULL 5883 NULL 5894 NULL 590DROP TABLE t1,t2,t3,t4,t5,t6; 591CREATE TABLE t1 (c1 SMALLINT NOT NULL); 592CREATE TABLE t2 (c1 SMALLINT NOT NULL); 593CREATE TABLE t3 (c1 SMALLINT NOT NULL); 594CREATE TABLE t4 (c1 SMALLINT NOT NULL); 595CREATE TABLE t5 (c1 SMALLINT NOT NULL); 596CREATE TABLE t6 (c1 SMALLINT NOT NULL); 597INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 598INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 599INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 600INSERT INTO t4 (c1) VALUES(10); 601INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 602SELECT t1.c1,t5.c1 FROM t1 LEFT OUTER JOIN t5 ON t1.c1 = t5.c1 ORDER BY t1.c1,t5.c1; 603c1 c1 6040 NULL 6051 NULL 6062 NULL 6073 NULL 6084 NULL 6095 NULL 6106 NULL 6117 NULL 6128 NULL 6139 NULL 614SELECT t1.c1,t5.c1 FROM t1 LEFT OUTER JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 < 5 ORDER BY t1.c1,t5.c1; 615c1 c1 6160 NULL 6171 NULL 6182 NULL 6193 NULL 6204 NULL 621DROP TABLE t1,t2,t3,t4,t5,t6; 622CREATE TABLE t1 (c1 MEDIUMINT NOT NULL); 623CREATE TABLE t2 (c1 MEDIUMINT NOT NULL); 624CREATE TABLE t3 (c1 MEDIUMINT NOT NULL); 625CREATE TABLE t4 (c1 MEDIUMINT NOT NULL); 626CREATE TABLE t5 (c1 MEDIUMINT NOT NULL); 627CREATE TABLE t6 (c1 MEDIUMINT NOT NULL); 628INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 629INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 630INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 631INSERT INTO t4 (c1) VALUES(10); 632INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 633SELECT t1.c1,t5.c1 FROM t1 LEFT OUTER JOIN t5 ON t1.c1 = t5.c1 ORDER BY t1.c1,t5.c1; 634c1 c1 6350 NULL 6361 NULL 6372 NULL 6383 NULL 6394 NULL 6405 NULL 6416 NULL 6427 NULL 6438 NULL 6449 NULL 645SELECT t1.c1,t5.c1 FROM t1 LEFT OUTER JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 < 5 ORDER BY t1.c1,t5.c1; 646c1 c1 6470 NULL 6481 NULL 6492 NULL 6503 NULL 6514 NULL 652DROP TABLE t1,t2,t3,t4,t5,t6; 653CREATE TABLE t1 (c1 INT NOT NULL); 654CREATE TABLE t2 (c1 INT NOT NULL); 655CREATE TABLE t3 (c1 INT NOT NULL); 656CREATE TABLE t4 (c1 INT NOT NULL); 657CREATE TABLE t5 (c1 INT NOT NULL); 658CREATE TABLE t6 (c1 INT NOT NULL); 659INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 660INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 661INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 662INSERT INTO t4 (c1) VALUES(10); 663INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 664SELECT t1.c1,t5.c1 FROM t1 LEFT OUTER JOIN t5 ON t1.c1 = t5.c1 ORDER BY t1.c1,t5.c1; 665c1 c1 6660 NULL 6671 NULL 6682 NULL 6693 NULL 6704 NULL 6715 NULL 6726 NULL 6737 NULL 6748 NULL 6759 NULL 676SELECT t1.c1,t5.c1 FROM t1 LEFT OUTER JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 < 5 ORDER BY t1.c1,t5.c1; 677c1 c1 6780 NULL 6791 NULL 6802 NULL 6813 NULL 6824 NULL 683DROP TABLE t1,t2,t3,t4,t5,t6; 684CREATE TABLE t1 (c1 INTEGER NOT NULL); 685CREATE TABLE t2 (c1 INTEGER NOT NULL); 686CREATE TABLE t3 (c1 INTEGER NOT NULL); 687CREATE TABLE t4 (c1 INTEGER NOT NULL); 688CREATE TABLE t5 (c1 INTEGER NOT NULL); 689CREATE TABLE t6 (c1 INTEGER NOT NULL); 690INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 691INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 692INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 693INSERT INTO t4 (c1) VALUES(10); 694INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 695SELECT t1.c1,t5.c1 FROM t1 LEFT OUTER JOIN t5 ON t1.c1 = t5.c1 ORDER BY t1.c1,t5.c1; 696c1 c1 6970 NULL 6981 NULL 6992 NULL 7003 NULL 7014 NULL 7025 NULL 7036 NULL 7047 NULL 7058 NULL 7069 NULL 707SELECT t1.c1,t5.c1 FROM t1 LEFT OUTER JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 < 5 ORDER BY t1.c1,t5.c1; 708c1 c1 7090 NULL 7101 NULL 7112 NULL 7123 NULL 7134 NULL 714DROP TABLE t1,t2,t3,t4,t5,t6; 715CREATE TABLE t1 (c1 BIGINT NOT NULL); 716CREATE TABLE t2 (c1 BIGINT NOT NULL); 717CREATE TABLE t3 (c1 BIGINT NOT NULL); 718CREATE TABLE t4 (c1 BIGINT NOT NULL); 719CREATE TABLE t5 (c1 BIGINT NOT NULL); 720CREATE TABLE t6 (c1 BIGINT NOT NULL); 721INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 722INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 723INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 724INSERT INTO t4 (c1) VALUES(10); 725INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 726SELECT t1.c1,t5.c1 FROM t1 LEFT OUTER JOIN t5 ON t1.c1 = t5.c1 ORDER BY t1.c1,t5.c1; 727c1 c1 7280 NULL 7291 NULL 7302 NULL 7313 NULL 7324 NULL 7335 NULL 7346 NULL 7357 NULL 7368 NULL 7379 NULL 738SELECT t1.c1,t5.c1 FROM t1 LEFT OUTER JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 < 5 ORDER BY t1.c1,t5.c1; 739c1 c1 7400 NULL 7411 NULL 7422 NULL 7433 NULL 7444 NULL 745DROP TABLE t1,t2,t3,t4,t5,t6; 746CREATE TABLE t1 (c1 TINYINT NOT NULL); 747CREATE TABLE t2 (c1 TINYINT NOT NULL); 748CREATE TABLE t3 (c1 TINYINT NOT NULL); 749CREATE TABLE t4 (c1 TINYINT NOT NULL); 750CREATE TABLE t5 (c1 TINYINT NOT NULL); 751CREATE TABLE t6 (c1 TINYINT NOT NULL); 752INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 753INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 754INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 755INSERT INTO t4 (c1) VALUES(10); 756INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 757SELECT t1.c1,t6.c1 FROM t1 LEFT OUTER JOIN t6 ON t1.c1 = t6.c1 ORDER BY t1.c1,t6.c1; 758c1 c1 7590 NULL 7601 NULL 7612 NULL 7623 NULL 7634 NULL 7645 NULL 7656 NULL 7667 NULL 7678 NULL 7689 NULL 769SELECT t1.c1,t6.c1 FROM t1 LEFT OUTER JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 < 5 ORDER BY t1.c1,t6.c1; 770c1 c1 7710 NULL 7721 NULL 7732 NULL 7743 NULL 7754 NULL 776DROP TABLE t1,t2,t3,t4,t5,t6; 777CREATE TABLE t1 (c1 SMALLINT NOT NULL); 778CREATE TABLE t2 (c1 SMALLINT NOT NULL); 779CREATE TABLE t3 (c1 SMALLINT NOT NULL); 780CREATE TABLE t4 (c1 SMALLINT NOT NULL); 781CREATE TABLE t5 (c1 SMALLINT NOT NULL); 782CREATE TABLE t6 (c1 SMALLINT NOT NULL); 783INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 784INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 785INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 786INSERT INTO t4 (c1) VALUES(10); 787INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 788SELECT t1.c1,t6.c1 FROM t1 LEFT OUTER JOIN t6 ON t1.c1 = t6.c1 ORDER BY t1.c1,t6.c1; 789c1 c1 7900 NULL 7911 NULL 7922 NULL 7933 NULL 7944 NULL 7955 NULL 7966 NULL 7977 NULL 7988 NULL 7999 NULL 800SELECT t1.c1,t6.c1 FROM t1 LEFT OUTER JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 < 5 ORDER BY t1.c1,t6.c1; 801c1 c1 8020 NULL 8031 NULL 8042 NULL 8053 NULL 8064 NULL 807DROP TABLE t1,t2,t3,t4,t5,t6; 808CREATE TABLE t1 (c1 MEDIUMINT NOT NULL); 809CREATE TABLE t2 (c1 MEDIUMINT NOT NULL); 810CREATE TABLE t3 (c1 MEDIUMINT NOT NULL); 811CREATE TABLE t4 (c1 MEDIUMINT NOT NULL); 812CREATE TABLE t5 (c1 MEDIUMINT NOT NULL); 813CREATE TABLE t6 (c1 MEDIUMINT NOT NULL); 814INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 815INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 816INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 817INSERT INTO t4 (c1) VALUES(10); 818INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 819SELECT t1.c1,t6.c1 FROM t1 LEFT OUTER JOIN t6 ON t1.c1 = t6.c1 ORDER BY t1.c1,t6.c1; 820c1 c1 8210 NULL 8221 NULL 8232 NULL 8243 NULL 8254 NULL 8265 NULL 8276 NULL 8287 NULL 8298 NULL 8309 NULL 831SELECT t1.c1,t6.c1 FROM t1 LEFT OUTER JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 < 5 ORDER BY t1.c1,t6.c1; 832c1 c1 8330 NULL 8341 NULL 8352 NULL 8363 NULL 8374 NULL 838DROP TABLE t1,t2,t3,t4,t5,t6; 839CREATE TABLE t1 (c1 INT NOT NULL); 840CREATE TABLE t2 (c1 INT NOT NULL); 841CREATE TABLE t3 (c1 INT NOT NULL); 842CREATE TABLE t4 (c1 INT NOT NULL); 843CREATE TABLE t5 (c1 INT NOT NULL); 844CREATE TABLE t6 (c1 INT NOT NULL); 845INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 846INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 847INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 848INSERT INTO t4 (c1) VALUES(10); 849INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 850SELECT t1.c1,t6.c1 FROM t1 LEFT OUTER JOIN t6 ON t1.c1 = t6.c1 ORDER BY t1.c1,t6.c1; 851c1 c1 8520 NULL 8531 NULL 8542 NULL 8553 NULL 8564 NULL 8575 NULL 8586 NULL 8597 NULL 8608 NULL 8619 NULL 862SELECT t1.c1,t6.c1 FROM t1 LEFT OUTER JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 < 5 ORDER BY t1.c1,t6.c1; 863c1 c1 8640 NULL 8651 NULL 8662 NULL 8673 NULL 8684 NULL 869DROP TABLE t1,t2,t3,t4,t5,t6; 870CREATE TABLE t1 (c1 INTEGER NOT NULL); 871CREATE TABLE t2 (c1 INTEGER NOT NULL); 872CREATE TABLE t3 (c1 INTEGER NOT NULL); 873CREATE TABLE t4 (c1 INTEGER NOT NULL); 874CREATE TABLE t5 (c1 INTEGER NOT NULL); 875CREATE TABLE t6 (c1 INTEGER NOT NULL); 876INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 877INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 878INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 879INSERT INTO t4 (c1) VALUES(10); 880INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 881SELECT t1.c1,t6.c1 FROM t1 LEFT OUTER JOIN t6 ON t1.c1 = t6.c1 ORDER BY t1.c1,t6.c1; 882c1 c1 8830 NULL 8841 NULL 8852 NULL 8863 NULL 8874 NULL 8885 NULL 8896 NULL 8907 NULL 8918 NULL 8929 NULL 893SELECT t1.c1,t6.c1 FROM t1 LEFT OUTER JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 < 5 ORDER BY t1.c1,t6.c1; 894c1 c1 8950 NULL 8961 NULL 8972 NULL 8983 NULL 8994 NULL 900DROP TABLE t1,t2,t3,t4,t5,t6; 901CREATE TABLE t1 (c1 BIGINT NOT NULL); 902CREATE TABLE t2 (c1 BIGINT NOT NULL); 903CREATE TABLE t3 (c1 BIGINT NOT NULL); 904CREATE TABLE t4 (c1 BIGINT NOT NULL); 905CREATE TABLE t5 (c1 BIGINT NOT NULL); 906CREATE TABLE t6 (c1 BIGINT NOT NULL); 907INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 908INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 909INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 910INSERT INTO t4 (c1) VALUES(10); 911INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 912SELECT t1.c1,t6.c1 FROM t1 LEFT OUTER JOIN t6 ON t1.c1 = t6.c1 ORDER BY t1.c1,t6.c1; 913c1 c1 9140 NULL 9151 NULL 9162 NULL 9173 NULL 9184 NULL 9195 NULL 9206 NULL 9217 NULL 9228 NULL 9239 NULL 924SELECT t1.c1,t6.c1 FROM t1 LEFT OUTER JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 < 5 ORDER BY t1.c1,t6.c1; 925c1 c1 9260 NULL 9271 NULL 9282 NULL 9293 NULL 9304 NULL 931DROP TABLE t1,t2,t3,t4,t5,t6; 932CREATE TABLE t1 (c1 TINYINT NOT NULL); 933CREATE TABLE t2 (c1 TINYINT NOT NULL); 934CREATE TABLE t3 (c1 TINYINT NOT NULL); 935CREATE TABLE t4 (c1 TINYINT NOT NULL); 936CREATE TABLE t5 (c1 TINYINT NOT NULL); 937CREATE TABLE t6 (c1 TINYINT NOT NULL); 938INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 939INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 940INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 941INSERT INTO t4 (c1) VALUES(10); 942INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 943SELECT t1.c1,t2.c1 FROM t1 LEFT OUTER JOIN t2 ON t1.c1 = t2.c1 ORDER BY t1.c1,t2.c1; 944c1 c1 9450 0 9461 1 9472 2 9483 3 9494 4 9505 5 9516 6 9527 7 9538 8 9549 9 955SELECT t1.c1,t2.c1 FROM t1 LEFT OUTER JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 <= 5 ORDER BY t1.c1,t2.c1; 956c1 c1 9570 0 9581 1 9592 2 9603 3 9614 4 9625 5 963DROP TABLE t1,t2,t3,t4,t5,t6; 964CREATE TABLE t1 (c1 SMALLINT NOT NULL); 965CREATE TABLE t2 (c1 SMALLINT NOT NULL); 966CREATE TABLE t3 (c1 SMALLINT NOT NULL); 967CREATE TABLE t4 (c1 SMALLINT NOT NULL); 968CREATE TABLE t5 (c1 SMALLINT NOT NULL); 969CREATE TABLE t6 (c1 SMALLINT NOT NULL); 970INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 971INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 972INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 973INSERT INTO t4 (c1) VALUES(10); 974INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 975SELECT t1.c1,t2.c1 FROM t1 LEFT OUTER JOIN t2 ON t1.c1 = t2.c1 ORDER BY t1.c1,t2.c1; 976c1 c1 9770 0 9781 1 9792 2 9803 3 9814 4 9825 5 9836 6 9847 7 9858 8 9869 9 987SELECT t1.c1,t2.c1 FROM t1 LEFT OUTER JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 <= 5 ORDER BY t1.c1,t2.c1; 988c1 c1 9890 0 9901 1 9912 2 9923 3 9934 4 9945 5 995DROP TABLE t1,t2,t3,t4,t5,t6; 996CREATE TABLE t1 (c1 MEDIUMINT NOT NULL); 997CREATE TABLE t2 (c1 MEDIUMINT NOT NULL); 998CREATE TABLE t3 (c1 MEDIUMINT NOT NULL); 999CREATE TABLE t4 (c1 MEDIUMINT NOT NULL); 1000CREATE TABLE t5 (c1 MEDIUMINT NOT NULL); 1001CREATE TABLE t6 (c1 MEDIUMINT NOT NULL); 1002INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1003INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1004INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 1005INSERT INTO t4 (c1) VALUES(10); 1006INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 1007SELECT t1.c1,t2.c1 FROM t1 LEFT OUTER JOIN t2 ON t1.c1 = t2.c1 ORDER BY t1.c1,t2.c1; 1008c1 c1 10090 0 10101 1 10112 2 10123 3 10134 4 10145 5 10156 6 10167 7 10178 8 10189 9 1019SELECT t1.c1,t2.c1 FROM t1 LEFT OUTER JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 <= 5 ORDER BY t1.c1,t2.c1; 1020c1 c1 10210 0 10221 1 10232 2 10243 3 10254 4 10265 5 1027DROP TABLE t1,t2,t3,t4,t5,t6; 1028CREATE TABLE t1 (c1 INT NOT NULL); 1029CREATE TABLE t2 (c1 INT NOT NULL); 1030CREATE TABLE t3 (c1 INT NOT NULL); 1031CREATE TABLE t4 (c1 INT NOT NULL); 1032CREATE TABLE t5 (c1 INT NOT NULL); 1033CREATE TABLE t6 (c1 INT NOT NULL); 1034INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1035INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1036INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 1037INSERT INTO t4 (c1) VALUES(10); 1038INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 1039SELECT t1.c1,t2.c1 FROM t1 LEFT OUTER JOIN t2 ON t1.c1 = t2.c1 ORDER BY t1.c1,t2.c1; 1040c1 c1 10410 0 10421 1 10432 2 10443 3 10454 4 10465 5 10476 6 10487 7 10498 8 10509 9 1051SELECT t1.c1,t2.c1 FROM t1 LEFT OUTER JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 <= 5 ORDER BY t1.c1,t2.c1; 1052c1 c1 10530 0 10541 1 10552 2 10563 3 10574 4 10585 5 1059DROP TABLE t1,t2,t3,t4,t5,t6; 1060CREATE TABLE t1 (c1 INTEGER NOT NULL); 1061CREATE TABLE t2 (c1 INTEGER NOT NULL); 1062CREATE TABLE t3 (c1 INTEGER NOT NULL); 1063CREATE TABLE t4 (c1 INTEGER NOT NULL); 1064CREATE TABLE t5 (c1 INTEGER NOT NULL); 1065CREATE TABLE t6 (c1 INTEGER NOT NULL); 1066INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1067INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1068INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 1069INSERT INTO t4 (c1) VALUES(10); 1070INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 1071SELECT t1.c1,t2.c1 FROM t1 LEFT OUTER JOIN t2 ON t1.c1 = t2.c1 ORDER BY t1.c1,t2.c1; 1072c1 c1 10730 0 10741 1 10752 2 10763 3 10774 4 10785 5 10796 6 10807 7 10818 8 10829 9 1083SELECT t1.c1,t2.c1 FROM t1 LEFT OUTER JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 <= 5 ORDER BY t1.c1,t2.c1; 1084c1 c1 10850 0 10861 1 10872 2 10883 3 10894 4 10905 5 1091DROP TABLE t1,t2,t3,t4,t5,t6; 1092CREATE TABLE t1 (c1 BIGINT NOT NULL); 1093CREATE TABLE t2 (c1 BIGINT NOT NULL); 1094CREATE TABLE t3 (c1 BIGINT NOT NULL); 1095CREATE TABLE t4 (c1 BIGINT NOT NULL); 1096CREATE TABLE t5 (c1 BIGINT NOT NULL); 1097CREATE TABLE t6 (c1 BIGINT NOT NULL); 1098INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1099INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1100INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 1101INSERT INTO t4 (c1) VALUES(10); 1102INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 1103SELECT t1.c1,t2.c1 FROM t1 LEFT OUTER JOIN t2 ON t1.c1 = t2.c1 ORDER BY t1.c1,t2.c1; 1104c1 c1 11050 0 11061 1 11072 2 11083 3 11094 4 11105 5 11116 6 11127 7 11138 8 11149 9 1115SELECT t1.c1,t2.c1 FROM t1 LEFT OUTER JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 <= 5 ORDER BY t1.c1,t2.c1; 1116c1 c1 11170 0 11181 1 11192 2 11203 3 11214 4 11225 5 1123DROP TABLE t1,t2,t3,t4,t5,t6; 1124CREATE TABLE t1 (c1 TINYINT NOT NULL); 1125CREATE TABLE t2 (c1 TINYINT NOT NULL); 1126CREATE TABLE t3 (c1 TINYINT NOT NULL); 1127CREATE TABLE t4 (c1 TINYINT NOT NULL); 1128CREATE TABLE t5 (c1 TINYINT NOT NULL); 1129CREATE TABLE t6 (c1 TINYINT NOT NULL); 1130INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1131INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1132INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 1133INSERT INTO t4 (c1) VALUES(10); 1134INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 1135SELECT t1.c1,t3.c1 FROM t1 LEFT OUTER JOIN t3 ON t1.c1 = t3.c1 ORDER BY t1.c1,t3.c1; 1136c1 c1 11370 NULL 11381 1 11392 NULL 11403 3 11414 NULL 11425 5 11436 NULL 11447 7 11458 NULL 11469 9 1147SELECT t1.c1,t3.c1 FROM t1 LEFT OUTER JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 <= 5 ORDER BY t1.c1,t3.c1; 1148c1 c1 11490 NULL 11501 1 11512 NULL 11523 3 11534 NULL 11545 5 1155DROP TABLE t1,t2,t3,t4,t5,t6; 1156CREATE TABLE t1 (c1 SMALLINT NOT NULL); 1157CREATE TABLE t2 (c1 SMALLINT NOT NULL); 1158CREATE TABLE t3 (c1 SMALLINT NOT NULL); 1159CREATE TABLE t4 (c1 SMALLINT NOT NULL); 1160CREATE TABLE t5 (c1 SMALLINT NOT NULL); 1161CREATE TABLE t6 (c1 SMALLINT NOT NULL); 1162INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1163INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1164INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 1165INSERT INTO t4 (c1) VALUES(10); 1166INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 1167SELECT t1.c1,t3.c1 FROM t1 LEFT OUTER JOIN t3 ON t1.c1 = t3.c1 ORDER BY t1.c1,t3.c1; 1168c1 c1 11690 NULL 11701 1 11712 NULL 11723 3 11734 NULL 11745 5 11756 NULL 11767 7 11778 NULL 11789 9 1179SELECT t1.c1,t3.c1 FROM t1 LEFT OUTER JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 <= 5 ORDER BY t1.c1,t3.c1; 1180c1 c1 11810 NULL 11821 1 11832 NULL 11843 3 11854 NULL 11865 5 1187DROP TABLE t1,t2,t3,t4,t5,t6; 1188CREATE TABLE t1 (c1 MEDIUMINT NOT NULL); 1189CREATE TABLE t2 (c1 MEDIUMINT NOT NULL); 1190CREATE TABLE t3 (c1 MEDIUMINT NOT NULL); 1191CREATE TABLE t4 (c1 MEDIUMINT NOT NULL); 1192CREATE TABLE t5 (c1 MEDIUMINT NOT NULL); 1193CREATE TABLE t6 (c1 MEDIUMINT NOT NULL); 1194INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1195INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1196INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 1197INSERT INTO t4 (c1) VALUES(10); 1198INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 1199SELECT t1.c1,t3.c1 FROM t1 LEFT OUTER JOIN t3 ON t1.c1 = t3.c1 ORDER BY t1.c1,t3.c1; 1200c1 c1 12010 NULL 12021 1 12032 NULL 12043 3 12054 NULL 12065 5 12076 NULL 12087 7 12098 NULL 12109 9 1211SELECT t1.c1,t3.c1 FROM t1 LEFT OUTER JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 <= 5 ORDER BY t1.c1,t3.c1; 1212c1 c1 12130 NULL 12141 1 12152 NULL 12163 3 12174 NULL 12185 5 1219DROP TABLE t1,t2,t3,t4,t5,t6; 1220CREATE TABLE t1 (c1 INT NOT NULL); 1221CREATE TABLE t2 (c1 INT NOT NULL); 1222CREATE TABLE t3 (c1 INT NOT NULL); 1223CREATE TABLE t4 (c1 INT NOT NULL); 1224CREATE TABLE t5 (c1 INT NOT NULL); 1225CREATE TABLE t6 (c1 INT NOT NULL); 1226INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1227INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1228INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 1229INSERT INTO t4 (c1) VALUES(10); 1230INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 1231SELECT t1.c1,t3.c1 FROM t1 LEFT OUTER JOIN t3 ON t1.c1 = t3.c1 ORDER BY t1.c1,t3.c1; 1232c1 c1 12330 NULL 12341 1 12352 NULL 12363 3 12374 NULL 12385 5 12396 NULL 12407 7 12418 NULL 12429 9 1243SELECT t1.c1,t3.c1 FROM t1 LEFT OUTER JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 <= 5 ORDER BY t1.c1,t3.c1; 1244c1 c1 12450 NULL 12461 1 12472 NULL 12483 3 12494 NULL 12505 5 1251DROP TABLE t1,t2,t3,t4,t5,t6; 1252CREATE TABLE t1 (c1 INTEGER NOT NULL); 1253CREATE TABLE t2 (c1 INTEGER NOT NULL); 1254CREATE TABLE t3 (c1 INTEGER NOT NULL); 1255CREATE TABLE t4 (c1 INTEGER NOT NULL); 1256CREATE TABLE t5 (c1 INTEGER NOT NULL); 1257CREATE TABLE t6 (c1 INTEGER NOT NULL); 1258INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1259INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1260INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 1261INSERT INTO t4 (c1) VALUES(10); 1262INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 1263SELECT t1.c1,t3.c1 FROM t1 LEFT OUTER JOIN t3 ON t1.c1 = t3.c1 ORDER BY t1.c1,t3.c1; 1264c1 c1 12650 NULL 12661 1 12672 NULL 12683 3 12694 NULL 12705 5 12716 NULL 12727 7 12738 NULL 12749 9 1275SELECT t1.c1,t3.c1 FROM t1 LEFT OUTER JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 <= 5 ORDER BY t1.c1,t3.c1; 1276c1 c1 12770 NULL 12781 1 12792 NULL 12803 3 12814 NULL 12825 5 1283DROP TABLE t1,t2,t3,t4,t5,t6; 1284CREATE TABLE t1 (c1 BIGINT NOT NULL); 1285CREATE TABLE t2 (c1 BIGINT NOT NULL); 1286CREATE TABLE t3 (c1 BIGINT NOT NULL); 1287CREATE TABLE t4 (c1 BIGINT NOT NULL); 1288CREATE TABLE t5 (c1 BIGINT NOT NULL); 1289CREATE TABLE t6 (c1 BIGINT NOT NULL); 1290INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1291INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1292INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 1293INSERT INTO t4 (c1) VALUES(10); 1294INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 1295SELECT t1.c1,t3.c1 FROM t1 LEFT OUTER JOIN t3 ON t1.c1 = t3.c1 ORDER BY t1.c1,t3.c1; 1296c1 c1 12970 NULL 12981 1 12992 NULL 13003 3 13014 NULL 13025 5 13036 NULL 13047 7 13058 NULL 13069 9 1307SELECT t1.c1,t3.c1 FROM t1 LEFT OUTER JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 <= 5 ORDER BY t1.c1,t3.c1; 1308c1 c1 13090 NULL 13101 1 13112 NULL 13123 3 13134 NULL 13145 5 1315DROP TABLE t1,t2,t3,t4,t5,t6; 1316CREATE TABLE t1 (c1 TINYINT NOT NULL); 1317CREATE TABLE t2 (c1 TINYINT NOT NULL); 1318CREATE TABLE t3 (c1 TINYINT NOT NULL); 1319CREATE TABLE t4 (c1 TINYINT NOT NULL); 1320CREATE TABLE t5 (c1 TINYINT NOT NULL); 1321CREATE TABLE t6 (c1 TINYINT NOT NULL); 1322INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1323INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1324INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 1325INSERT INTO t4 (c1) VALUES(10); 1326INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 1327SELECT t1.c1,t4.c1 FROM t1 LEFT OUTER JOIN t4 ON t1.c1 = t4.c1 ORDER BY t1.c1,t4.c1; 1328c1 c1 13290 NULL 13301 NULL 13312 NULL 13323 NULL 13334 NULL 13345 NULL 13356 NULL 13367 NULL 13378 NULL 13389 NULL 1339SELECT t1.c1,t4.c1 FROM t1 LEFT OUTER JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 <= 5 ORDER BY t1.c1,t4.c1; 1340c1 c1 13410 NULL 13421 NULL 13432 NULL 13443 NULL 13454 NULL 13465 NULL 1347DROP TABLE t1,t2,t3,t4,t5,t6; 1348CREATE TABLE t1 (c1 SMALLINT NOT NULL); 1349CREATE TABLE t2 (c1 SMALLINT NOT NULL); 1350CREATE TABLE t3 (c1 SMALLINT NOT NULL); 1351CREATE TABLE t4 (c1 SMALLINT NOT NULL); 1352CREATE TABLE t5 (c1 SMALLINT NOT NULL); 1353CREATE TABLE t6 (c1 SMALLINT NOT NULL); 1354INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1355INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1356INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 1357INSERT INTO t4 (c1) VALUES(10); 1358INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 1359SELECT t1.c1,t4.c1 FROM t1 LEFT OUTER JOIN t4 ON t1.c1 = t4.c1 ORDER BY t1.c1,t4.c1; 1360c1 c1 13610 NULL 13621 NULL 13632 NULL 13643 NULL 13654 NULL 13665 NULL 13676 NULL 13687 NULL 13698 NULL 13709 NULL 1371SELECT t1.c1,t4.c1 FROM t1 LEFT OUTER JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 <= 5 ORDER BY t1.c1,t4.c1; 1372c1 c1 13730 NULL 13741 NULL 13752 NULL 13763 NULL 13774 NULL 13785 NULL 1379DROP TABLE t1,t2,t3,t4,t5,t6; 1380CREATE TABLE t1 (c1 MEDIUMINT NOT NULL); 1381CREATE TABLE t2 (c1 MEDIUMINT NOT NULL); 1382CREATE TABLE t3 (c1 MEDIUMINT NOT NULL); 1383CREATE TABLE t4 (c1 MEDIUMINT NOT NULL); 1384CREATE TABLE t5 (c1 MEDIUMINT NOT NULL); 1385CREATE TABLE t6 (c1 MEDIUMINT NOT NULL); 1386INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1387INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1388INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 1389INSERT INTO t4 (c1) VALUES(10); 1390INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 1391SELECT t1.c1,t4.c1 FROM t1 LEFT OUTER JOIN t4 ON t1.c1 = t4.c1 ORDER BY t1.c1,t4.c1; 1392c1 c1 13930 NULL 13941 NULL 13952 NULL 13963 NULL 13974 NULL 13985 NULL 13996 NULL 14007 NULL 14018 NULL 14029 NULL 1403SELECT t1.c1,t4.c1 FROM t1 LEFT OUTER JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 <= 5 ORDER BY t1.c1,t4.c1; 1404c1 c1 14050 NULL 14061 NULL 14072 NULL 14083 NULL 14094 NULL 14105 NULL 1411DROP TABLE t1,t2,t3,t4,t5,t6; 1412CREATE TABLE t1 (c1 INT NOT NULL); 1413CREATE TABLE t2 (c1 INT NOT NULL); 1414CREATE TABLE t3 (c1 INT NOT NULL); 1415CREATE TABLE t4 (c1 INT NOT NULL); 1416CREATE TABLE t5 (c1 INT NOT NULL); 1417CREATE TABLE t6 (c1 INT NOT NULL); 1418INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1419INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1420INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 1421INSERT INTO t4 (c1) VALUES(10); 1422INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 1423SELECT t1.c1,t4.c1 FROM t1 LEFT OUTER JOIN t4 ON t1.c1 = t4.c1 ORDER BY t1.c1,t4.c1; 1424c1 c1 14250 NULL 14261 NULL 14272 NULL 14283 NULL 14294 NULL 14305 NULL 14316 NULL 14327 NULL 14338 NULL 14349 NULL 1435SELECT t1.c1,t4.c1 FROM t1 LEFT OUTER JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 <= 5 ORDER BY t1.c1,t4.c1; 1436c1 c1 14370 NULL 14381 NULL 14392 NULL 14403 NULL 14414 NULL 14425 NULL 1443DROP TABLE t1,t2,t3,t4,t5,t6; 1444CREATE TABLE t1 (c1 INTEGER NOT NULL); 1445CREATE TABLE t2 (c1 INTEGER NOT NULL); 1446CREATE TABLE t3 (c1 INTEGER NOT NULL); 1447CREATE TABLE t4 (c1 INTEGER NOT NULL); 1448CREATE TABLE t5 (c1 INTEGER NOT NULL); 1449CREATE TABLE t6 (c1 INTEGER NOT NULL); 1450INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1451INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1452INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 1453INSERT INTO t4 (c1) VALUES(10); 1454INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 1455SELECT t1.c1,t4.c1 FROM t1 LEFT OUTER JOIN t4 ON t1.c1 = t4.c1 ORDER BY t1.c1,t4.c1; 1456c1 c1 14570 NULL 14581 NULL 14592 NULL 14603 NULL 14614 NULL 14625 NULL 14636 NULL 14647 NULL 14658 NULL 14669 NULL 1467SELECT t1.c1,t4.c1 FROM t1 LEFT OUTER JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 <= 5 ORDER BY t1.c1,t4.c1; 1468c1 c1 14690 NULL 14701 NULL 14712 NULL 14723 NULL 14734 NULL 14745 NULL 1475DROP TABLE t1,t2,t3,t4,t5,t6; 1476CREATE TABLE t1 (c1 BIGINT NOT NULL); 1477CREATE TABLE t2 (c1 BIGINT NOT NULL); 1478CREATE TABLE t3 (c1 BIGINT NOT NULL); 1479CREATE TABLE t4 (c1 BIGINT NOT NULL); 1480CREATE TABLE t5 (c1 BIGINT NOT NULL); 1481CREATE TABLE t6 (c1 BIGINT NOT NULL); 1482INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1483INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1484INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 1485INSERT INTO t4 (c1) VALUES(10); 1486INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 1487SELECT t1.c1,t4.c1 FROM t1 LEFT OUTER JOIN t4 ON t1.c1 = t4.c1 ORDER BY t1.c1,t4.c1; 1488c1 c1 14890 NULL 14901 NULL 14912 NULL 14923 NULL 14934 NULL 14945 NULL 14956 NULL 14967 NULL 14978 NULL 14989 NULL 1499SELECT t1.c1,t4.c1 FROM t1 LEFT OUTER JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 <= 5 ORDER BY t1.c1,t4.c1; 1500c1 c1 15010 NULL 15021 NULL 15032 NULL 15043 NULL 15054 NULL 15065 NULL 1507DROP TABLE t1,t2,t3,t4,t5,t6; 1508CREATE TABLE t1 (c1 TINYINT NOT NULL); 1509CREATE TABLE t2 (c1 TINYINT NOT NULL); 1510CREATE TABLE t3 (c1 TINYINT NOT NULL); 1511CREATE TABLE t4 (c1 TINYINT NOT NULL); 1512CREATE TABLE t5 (c1 TINYINT NOT NULL); 1513CREATE TABLE t6 (c1 TINYINT NOT NULL); 1514INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1515INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1516INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 1517INSERT INTO t4 (c1) VALUES(10); 1518INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 1519SELECT t1.c1,t5.c1 FROM t1 LEFT OUTER JOIN t5 ON t1.c1 = t5.c1 ORDER BY t1.c1,t5.c1; 1520c1 c1 15210 NULL 15221 NULL 15232 NULL 15243 NULL 15254 NULL 15265 NULL 15276 NULL 15287 NULL 15298 NULL 15309 NULL 1531SELECT t1.c1,t5.c1 FROM t1 LEFT OUTER JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 <= 5 ORDER BY t1.c1,t5.c1; 1532c1 c1 15330 NULL 15341 NULL 15352 NULL 15363 NULL 15374 NULL 15385 NULL 1539DROP TABLE t1,t2,t3,t4,t5,t6; 1540CREATE TABLE t1 (c1 SMALLINT NOT NULL); 1541CREATE TABLE t2 (c1 SMALLINT NOT NULL); 1542CREATE TABLE t3 (c1 SMALLINT NOT NULL); 1543CREATE TABLE t4 (c1 SMALLINT NOT NULL); 1544CREATE TABLE t5 (c1 SMALLINT NOT NULL); 1545CREATE TABLE t6 (c1 SMALLINT NOT NULL); 1546INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1547INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1548INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 1549INSERT INTO t4 (c1) VALUES(10); 1550INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 1551SELECT t1.c1,t5.c1 FROM t1 LEFT OUTER JOIN t5 ON t1.c1 = t5.c1 ORDER BY t1.c1,t5.c1; 1552c1 c1 15530 NULL 15541 NULL 15552 NULL 15563 NULL 15574 NULL 15585 NULL 15596 NULL 15607 NULL 15618 NULL 15629 NULL 1563SELECT t1.c1,t5.c1 FROM t1 LEFT OUTER JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 <= 5 ORDER BY t1.c1,t5.c1; 1564c1 c1 15650 NULL 15661 NULL 15672 NULL 15683 NULL 15694 NULL 15705 NULL 1571DROP TABLE t1,t2,t3,t4,t5,t6; 1572CREATE TABLE t1 (c1 MEDIUMINT NOT NULL); 1573CREATE TABLE t2 (c1 MEDIUMINT NOT NULL); 1574CREATE TABLE t3 (c1 MEDIUMINT NOT NULL); 1575CREATE TABLE t4 (c1 MEDIUMINT NOT NULL); 1576CREATE TABLE t5 (c1 MEDIUMINT NOT NULL); 1577CREATE TABLE t6 (c1 MEDIUMINT NOT NULL); 1578INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1579INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1580INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 1581INSERT INTO t4 (c1) VALUES(10); 1582INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 1583SELECT t1.c1,t5.c1 FROM t1 LEFT OUTER JOIN t5 ON t1.c1 = t5.c1 ORDER BY t1.c1,t5.c1; 1584c1 c1 15850 NULL 15861 NULL 15872 NULL 15883 NULL 15894 NULL 15905 NULL 15916 NULL 15927 NULL 15938 NULL 15949 NULL 1595SELECT t1.c1,t5.c1 FROM t1 LEFT OUTER JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 <= 5 ORDER BY t1.c1,t5.c1; 1596c1 c1 15970 NULL 15981 NULL 15992 NULL 16003 NULL 16014 NULL 16025 NULL 1603DROP TABLE t1,t2,t3,t4,t5,t6; 1604CREATE TABLE t1 (c1 INT NOT NULL); 1605CREATE TABLE t2 (c1 INT NOT NULL); 1606CREATE TABLE t3 (c1 INT NOT NULL); 1607CREATE TABLE t4 (c1 INT NOT NULL); 1608CREATE TABLE t5 (c1 INT NOT NULL); 1609CREATE TABLE t6 (c1 INT NOT NULL); 1610INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1611INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1612INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 1613INSERT INTO t4 (c1) VALUES(10); 1614INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 1615SELECT t1.c1,t5.c1 FROM t1 LEFT OUTER JOIN t5 ON t1.c1 = t5.c1 ORDER BY t1.c1,t5.c1; 1616c1 c1 16170 NULL 16181 NULL 16192 NULL 16203 NULL 16214 NULL 16225 NULL 16236 NULL 16247 NULL 16258 NULL 16269 NULL 1627SELECT t1.c1,t5.c1 FROM t1 LEFT OUTER JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 <= 5 ORDER BY t1.c1,t5.c1; 1628c1 c1 16290 NULL 16301 NULL 16312 NULL 16323 NULL 16334 NULL 16345 NULL 1635DROP TABLE t1,t2,t3,t4,t5,t6; 1636CREATE TABLE t1 (c1 INTEGER NOT NULL); 1637CREATE TABLE t2 (c1 INTEGER NOT NULL); 1638CREATE TABLE t3 (c1 INTEGER NOT NULL); 1639CREATE TABLE t4 (c1 INTEGER NOT NULL); 1640CREATE TABLE t5 (c1 INTEGER NOT NULL); 1641CREATE TABLE t6 (c1 INTEGER NOT NULL); 1642INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1643INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1644INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 1645INSERT INTO t4 (c1) VALUES(10); 1646INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 1647SELECT t1.c1,t5.c1 FROM t1 LEFT OUTER JOIN t5 ON t1.c1 = t5.c1 ORDER BY t1.c1,t5.c1; 1648c1 c1 16490 NULL 16501 NULL 16512 NULL 16523 NULL 16534 NULL 16545 NULL 16556 NULL 16567 NULL 16578 NULL 16589 NULL 1659SELECT t1.c1,t5.c1 FROM t1 LEFT OUTER JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 <= 5 ORDER BY t1.c1,t5.c1; 1660c1 c1 16610 NULL 16621 NULL 16632 NULL 16643 NULL 16654 NULL 16665 NULL 1667DROP TABLE t1,t2,t3,t4,t5,t6; 1668CREATE TABLE t1 (c1 BIGINT NOT NULL); 1669CREATE TABLE t2 (c1 BIGINT NOT NULL); 1670CREATE TABLE t3 (c1 BIGINT NOT NULL); 1671CREATE TABLE t4 (c1 BIGINT NOT NULL); 1672CREATE TABLE t5 (c1 BIGINT NOT NULL); 1673CREATE TABLE t6 (c1 BIGINT NOT NULL); 1674INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1675INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1676INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 1677INSERT INTO t4 (c1) VALUES(10); 1678INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 1679SELECT t1.c1,t5.c1 FROM t1 LEFT OUTER JOIN t5 ON t1.c1 = t5.c1 ORDER BY t1.c1,t5.c1; 1680c1 c1 16810 NULL 16821 NULL 16832 NULL 16843 NULL 16854 NULL 16865 NULL 16876 NULL 16887 NULL 16898 NULL 16909 NULL 1691SELECT t1.c1,t5.c1 FROM t1 LEFT OUTER JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 <= 5 ORDER BY t1.c1,t5.c1; 1692c1 c1 16930 NULL 16941 NULL 16952 NULL 16963 NULL 16974 NULL 16985 NULL 1699DROP TABLE t1,t2,t3,t4,t5,t6; 1700CREATE TABLE t1 (c1 TINYINT NOT NULL); 1701CREATE TABLE t2 (c1 TINYINT NOT NULL); 1702CREATE TABLE t3 (c1 TINYINT NOT NULL); 1703CREATE TABLE t4 (c1 TINYINT NOT NULL); 1704CREATE TABLE t5 (c1 TINYINT NOT NULL); 1705CREATE TABLE t6 (c1 TINYINT NOT NULL); 1706INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1707INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1708INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 1709INSERT INTO t4 (c1) VALUES(10); 1710INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 1711SELECT t1.c1,t6.c1 FROM t1 LEFT OUTER JOIN t6 ON t1.c1 = t6.c1 ORDER BY t1.c1,t6.c1; 1712c1 c1 17130 NULL 17141 NULL 17152 NULL 17163 NULL 17174 NULL 17185 NULL 17196 NULL 17207 NULL 17218 NULL 17229 NULL 1723SELECT t1.c1,t6.c1 FROM t1 LEFT OUTER JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 <= 5 ORDER BY t1.c1,t6.c1; 1724c1 c1 17250 NULL 17261 NULL 17272 NULL 17283 NULL 17294 NULL 17305 NULL 1731DROP TABLE t1,t2,t3,t4,t5,t6; 1732CREATE TABLE t1 (c1 SMALLINT NOT NULL); 1733CREATE TABLE t2 (c1 SMALLINT NOT NULL); 1734CREATE TABLE t3 (c1 SMALLINT NOT NULL); 1735CREATE TABLE t4 (c1 SMALLINT NOT NULL); 1736CREATE TABLE t5 (c1 SMALLINT NOT NULL); 1737CREATE TABLE t6 (c1 SMALLINT NOT NULL); 1738INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1739INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1740INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 1741INSERT INTO t4 (c1) VALUES(10); 1742INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 1743SELECT t1.c1,t6.c1 FROM t1 LEFT OUTER JOIN t6 ON t1.c1 = t6.c1 ORDER BY t1.c1,t6.c1; 1744c1 c1 17450 NULL 17461 NULL 17472 NULL 17483 NULL 17494 NULL 17505 NULL 17516 NULL 17527 NULL 17538 NULL 17549 NULL 1755SELECT t1.c1,t6.c1 FROM t1 LEFT OUTER JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 <= 5 ORDER BY t1.c1,t6.c1; 1756c1 c1 17570 NULL 17581 NULL 17592 NULL 17603 NULL 17614 NULL 17625 NULL 1763DROP TABLE t1,t2,t3,t4,t5,t6; 1764CREATE TABLE t1 (c1 MEDIUMINT NOT NULL); 1765CREATE TABLE t2 (c1 MEDIUMINT NOT NULL); 1766CREATE TABLE t3 (c1 MEDIUMINT NOT NULL); 1767CREATE TABLE t4 (c1 MEDIUMINT NOT NULL); 1768CREATE TABLE t5 (c1 MEDIUMINT NOT NULL); 1769CREATE TABLE t6 (c1 MEDIUMINT NOT NULL); 1770INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1771INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1772INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 1773INSERT INTO t4 (c1) VALUES(10); 1774INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 1775SELECT t1.c1,t6.c1 FROM t1 LEFT OUTER JOIN t6 ON t1.c1 = t6.c1 ORDER BY t1.c1,t6.c1; 1776c1 c1 17770 NULL 17781 NULL 17792 NULL 17803 NULL 17814 NULL 17825 NULL 17836 NULL 17847 NULL 17858 NULL 17869 NULL 1787SELECT t1.c1,t6.c1 FROM t1 LEFT OUTER JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 <= 5 ORDER BY t1.c1,t6.c1; 1788c1 c1 17890 NULL 17901 NULL 17912 NULL 17923 NULL 17934 NULL 17945 NULL 1795DROP TABLE t1,t2,t3,t4,t5,t6; 1796CREATE TABLE t1 (c1 INT NOT NULL); 1797CREATE TABLE t2 (c1 INT NOT NULL); 1798CREATE TABLE t3 (c1 INT NOT NULL); 1799CREATE TABLE t4 (c1 INT NOT NULL); 1800CREATE TABLE t5 (c1 INT NOT NULL); 1801CREATE TABLE t6 (c1 INT NOT NULL); 1802INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1803INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1804INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 1805INSERT INTO t4 (c1) VALUES(10); 1806INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 1807SELECT t1.c1,t6.c1 FROM t1 LEFT OUTER JOIN t6 ON t1.c1 = t6.c1 ORDER BY t1.c1,t6.c1; 1808c1 c1 18090 NULL 18101 NULL 18112 NULL 18123 NULL 18134 NULL 18145 NULL 18156 NULL 18167 NULL 18178 NULL 18189 NULL 1819SELECT t1.c1,t6.c1 FROM t1 LEFT OUTER JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 <= 5 ORDER BY t1.c1,t6.c1; 1820c1 c1 18210 NULL 18221 NULL 18232 NULL 18243 NULL 18254 NULL 18265 NULL 1827DROP TABLE t1,t2,t3,t4,t5,t6; 1828CREATE TABLE t1 (c1 INTEGER NOT NULL); 1829CREATE TABLE t2 (c1 INTEGER NOT NULL); 1830CREATE TABLE t3 (c1 INTEGER NOT NULL); 1831CREATE TABLE t4 (c1 INTEGER NOT NULL); 1832CREATE TABLE t5 (c1 INTEGER NOT NULL); 1833CREATE TABLE t6 (c1 INTEGER NOT NULL); 1834INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1835INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1836INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 1837INSERT INTO t4 (c1) VALUES(10); 1838INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 1839SELECT t1.c1,t6.c1 FROM t1 LEFT OUTER JOIN t6 ON t1.c1 = t6.c1 ORDER BY t1.c1,t6.c1; 1840c1 c1 18410 NULL 18421 NULL 18432 NULL 18443 NULL 18454 NULL 18465 NULL 18476 NULL 18487 NULL 18498 NULL 18509 NULL 1851SELECT t1.c1,t6.c1 FROM t1 LEFT OUTER JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 <= 5 ORDER BY t1.c1,t6.c1; 1852c1 c1 18530 NULL 18541 NULL 18552 NULL 18563 NULL 18574 NULL 18585 NULL 1859DROP TABLE t1,t2,t3,t4,t5,t6; 1860CREATE TABLE t1 (c1 BIGINT NOT NULL); 1861CREATE TABLE t2 (c1 BIGINT NOT NULL); 1862CREATE TABLE t3 (c1 BIGINT NOT NULL); 1863CREATE TABLE t4 (c1 BIGINT NOT NULL); 1864CREATE TABLE t5 (c1 BIGINT NOT NULL); 1865CREATE TABLE t6 (c1 BIGINT NOT NULL); 1866INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1867INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1868INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 1869INSERT INTO t4 (c1) VALUES(10); 1870INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 1871SELECT t1.c1,t6.c1 FROM t1 LEFT OUTER JOIN t6 ON t1.c1 = t6.c1 ORDER BY t1.c1,t6.c1; 1872c1 c1 18730 NULL 18741 NULL 18752 NULL 18763 NULL 18774 NULL 18785 NULL 18796 NULL 18807 NULL 18818 NULL 18829 NULL 1883SELECT t1.c1,t6.c1 FROM t1 LEFT OUTER JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 <= 5 ORDER BY t1.c1,t6.c1; 1884c1 c1 18850 NULL 18861 NULL 18872 NULL 18883 NULL 18894 NULL 18905 NULL 1891DROP TABLE t1,t2,t3,t4,t5,t6; 1892CREATE TABLE t1 (c1 TINYINT NOT NULL); 1893CREATE TABLE t2 (c1 TINYINT NOT NULL); 1894CREATE TABLE t3 (c1 TINYINT NOT NULL); 1895CREATE TABLE t4 (c1 TINYINT NOT NULL); 1896CREATE TABLE t5 (c1 TINYINT NOT NULL); 1897CREATE TABLE t6 (c1 TINYINT NOT NULL); 1898INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1899INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1900INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 1901INSERT INTO t4 (c1) VALUES(10); 1902INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 1903SELECT t1.c1,t2.c1 FROM t1 LEFT OUTER JOIN t2 ON t1.c1 = t2.c1 ORDER BY t1.c1,t2.c1; 1904c1 c1 19050 0 19061 1 19072 2 19083 3 19094 4 19105 5 19116 6 19127 7 19138 8 19149 9 1915SELECT t1.c1,t2.c1 FROM t1 LEFT OUTER JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 = 5 ORDER BY t1.c1,t2.c1; 1916c1 c1 19175 5 1918DROP TABLE t1,t2,t3,t4,t5,t6; 1919CREATE TABLE t1 (c1 SMALLINT NOT NULL); 1920CREATE TABLE t2 (c1 SMALLINT NOT NULL); 1921CREATE TABLE t3 (c1 SMALLINT NOT NULL); 1922CREATE TABLE t4 (c1 SMALLINT NOT NULL); 1923CREATE TABLE t5 (c1 SMALLINT NOT NULL); 1924CREATE TABLE t6 (c1 SMALLINT NOT NULL); 1925INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1926INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1927INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 1928INSERT INTO t4 (c1) VALUES(10); 1929INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 1930SELECT t1.c1,t2.c1 FROM t1 LEFT OUTER JOIN t2 ON t1.c1 = t2.c1 ORDER BY t1.c1,t2.c1; 1931c1 c1 19320 0 19331 1 19342 2 19353 3 19364 4 19375 5 19386 6 19397 7 19408 8 19419 9 1942SELECT t1.c1,t2.c1 FROM t1 LEFT OUTER JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 = 5 ORDER BY t1.c1,t2.c1; 1943c1 c1 19445 5 1945DROP TABLE t1,t2,t3,t4,t5,t6; 1946CREATE TABLE t1 (c1 MEDIUMINT NOT NULL); 1947CREATE TABLE t2 (c1 MEDIUMINT NOT NULL); 1948CREATE TABLE t3 (c1 MEDIUMINT NOT NULL); 1949CREATE TABLE t4 (c1 MEDIUMINT NOT NULL); 1950CREATE TABLE t5 (c1 MEDIUMINT NOT NULL); 1951CREATE TABLE t6 (c1 MEDIUMINT NOT NULL); 1952INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1953INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1954INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 1955INSERT INTO t4 (c1) VALUES(10); 1956INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 1957SELECT t1.c1,t2.c1 FROM t1 LEFT OUTER JOIN t2 ON t1.c1 = t2.c1 ORDER BY t1.c1,t2.c1; 1958c1 c1 19590 0 19601 1 19612 2 19623 3 19634 4 19645 5 19656 6 19667 7 19678 8 19689 9 1969SELECT t1.c1,t2.c1 FROM t1 LEFT OUTER JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 = 5 ORDER BY t1.c1,t2.c1; 1970c1 c1 19715 5 1972DROP TABLE t1,t2,t3,t4,t5,t6; 1973CREATE TABLE t1 (c1 INT NOT NULL); 1974CREATE TABLE t2 (c1 INT NOT NULL); 1975CREATE TABLE t3 (c1 INT NOT NULL); 1976CREATE TABLE t4 (c1 INT NOT NULL); 1977CREATE TABLE t5 (c1 INT NOT NULL); 1978CREATE TABLE t6 (c1 INT NOT NULL); 1979INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1980INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1981INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 1982INSERT INTO t4 (c1) VALUES(10); 1983INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 1984SELECT t1.c1,t2.c1 FROM t1 LEFT OUTER JOIN t2 ON t1.c1 = t2.c1 ORDER BY t1.c1,t2.c1; 1985c1 c1 19860 0 19871 1 19882 2 19893 3 19904 4 19915 5 19926 6 19937 7 19948 8 19959 9 1996SELECT t1.c1,t2.c1 FROM t1 LEFT OUTER JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 = 5 ORDER BY t1.c1,t2.c1; 1997c1 c1 19985 5 1999DROP TABLE t1,t2,t3,t4,t5,t6; 2000CREATE TABLE t1 (c1 INTEGER NOT NULL); 2001CREATE TABLE t2 (c1 INTEGER NOT NULL); 2002CREATE TABLE t3 (c1 INTEGER NOT NULL); 2003CREATE TABLE t4 (c1 INTEGER NOT NULL); 2004CREATE TABLE t5 (c1 INTEGER NOT NULL); 2005CREATE TABLE t6 (c1 INTEGER NOT NULL); 2006INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2007INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2008INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 2009INSERT INTO t4 (c1) VALUES(10); 2010INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 2011SELECT t1.c1,t2.c1 FROM t1 LEFT OUTER JOIN t2 ON t1.c1 = t2.c1 ORDER BY t1.c1,t2.c1; 2012c1 c1 20130 0 20141 1 20152 2 20163 3 20174 4 20185 5 20196 6 20207 7 20218 8 20229 9 2023SELECT t1.c1,t2.c1 FROM t1 LEFT OUTER JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 = 5 ORDER BY t1.c1,t2.c1; 2024c1 c1 20255 5 2026DROP TABLE t1,t2,t3,t4,t5,t6; 2027CREATE TABLE t1 (c1 BIGINT NOT NULL); 2028CREATE TABLE t2 (c1 BIGINT NOT NULL); 2029CREATE TABLE t3 (c1 BIGINT NOT NULL); 2030CREATE TABLE t4 (c1 BIGINT NOT NULL); 2031CREATE TABLE t5 (c1 BIGINT NOT NULL); 2032CREATE TABLE t6 (c1 BIGINT NOT NULL); 2033INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2034INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2035INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 2036INSERT INTO t4 (c1) VALUES(10); 2037INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 2038SELECT t1.c1,t2.c1 FROM t1 LEFT OUTER JOIN t2 ON t1.c1 = t2.c1 ORDER BY t1.c1,t2.c1; 2039c1 c1 20400 0 20411 1 20422 2 20433 3 20444 4 20455 5 20466 6 20477 7 20488 8 20499 9 2050SELECT t1.c1,t2.c1 FROM t1 LEFT OUTER JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 = 5 ORDER BY t1.c1,t2.c1; 2051c1 c1 20525 5 2053DROP TABLE t1,t2,t3,t4,t5,t6; 2054CREATE TABLE t1 (c1 TINYINT NOT NULL); 2055CREATE TABLE t2 (c1 TINYINT NOT NULL); 2056CREATE TABLE t3 (c1 TINYINT NOT NULL); 2057CREATE TABLE t4 (c1 TINYINT NOT NULL); 2058CREATE TABLE t5 (c1 TINYINT NOT NULL); 2059CREATE TABLE t6 (c1 TINYINT NOT NULL); 2060INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2061INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2062INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 2063INSERT INTO t4 (c1) VALUES(10); 2064INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 2065SELECT t1.c1,t3.c1 FROM t1 LEFT OUTER JOIN t3 ON t1.c1 = t3.c1 ORDER BY t1.c1,t3.c1; 2066c1 c1 20670 NULL 20681 1 20692 NULL 20703 3 20714 NULL 20725 5 20736 NULL 20747 7 20758 NULL 20769 9 2077SELECT t1.c1,t3.c1 FROM t1 LEFT OUTER JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 = 5 ORDER BY t1.c1,t3.c1; 2078c1 c1 20795 5 2080DROP TABLE t1,t2,t3,t4,t5,t6; 2081CREATE TABLE t1 (c1 SMALLINT NOT NULL); 2082CREATE TABLE t2 (c1 SMALLINT NOT NULL); 2083CREATE TABLE t3 (c1 SMALLINT NOT NULL); 2084CREATE TABLE t4 (c1 SMALLINT NOT NULL); 2085CREATE TABLE t5 (c1 SMALLINT NOT NULL); 2086CREATE TABLE t6 (c1 SMALLINT NOT NULL); 2087INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2088INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2089INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 2090INSERT INTO t4 (c1) VALUES(10); 2091INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 2092SELECT t1.c1,t3.c1 FROM t1 LEFT OUTER JOIN t3 ON t1.c1 = t3.c1 ORDER BY t1.c1,t3.c1; 2093c1 c1 20940 NULL 20951 1 20962 NULL 20973 3 20984 NULL 20995 5 21006 NULL 21017 7 21028 NULL 21039 9 2104SELECT t1.c1,t3.c1 FROM t1 LEFT OUTER JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 = 5 ORDER BY t1.c1,t3.c1; 2105c1 c1 21065 5 2107DROP TABLE t1,t2,t3,t4,t5,t6; 2108CREATE TABLE t1 (c1 MEDIUMINT NOT NULL); 2109CREATE TABLE t2 (c1 MEDIUMINT NOT NULL); 2110CREATE TABLE t3 (c1 MEDIUMINT NOT NULL); 2111CREATE TABLE t4 (c1 MEDIUMINT NOT NULL); 2112CREATE TABLE t5 (c1 MEDIUMINT NOT NULL); 2113CREATE TABLE t6 (c1 MEDIUMINT NOT NULL); 2114INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2115INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2116INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 2117INSERT INTO t4 (c1) VALUES(10); 2118INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 2119SELECT t1.c1,t3.c1 FROM t1 LEFT OUTER JOIN t3 ON t1.c1 = t3.c1 ORDER BY t1.c1,t3.c1; 2120c1 c1 21210 NULL 21221 1 21232 NULL 21243 3 21254 NULL 21265 5 21276 NULL 21287 7 21298 NULL 21309 9 2131SELECT t1.c1,t3.c1 FROM t1 LEFT OUTER JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 = 5 ORDER BY t1.c1,t3.c1; 2132c1 c1 21335 5 2134DROP TABLE t1,t2,t3,t4,t5,t6; 2135CREATE TABLE t1 (c1 INT NOT NULL); 2136CREATE TABLE t2 (c1 INT NOT NULL); 2137CREATE TABLE t3 (c1 INT NOT NULL); 2138CREATE TABLE t4 (c1 INT NOT NULL); 2139CREATE TABLE t5 (c1 INT NOT NULL); 2140CREATE TABLE t6 (c1 INT NOT NULL); 2141INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2142INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2143INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 2144INSERT INTO t4 (c1) VALUES(10); 2145INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 2146SELECT t1.c1,t3.c1 FROM t1 LEFT OUTER JOIN t3 ON t1.c1 = t3.c1 ORDER BY t1.c1,t3.c1; 2147c1 c1 21480 NULL 21491 1 21502 NULL 21513 3 21524 NULL 21535 5 21546 NULL 21557 7 21568 NULL 21579 9 2158SELECT t1.c1,t3.c1 FROM t1 LEFT OUTER JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 = 5 ORDER BY t1.c1,t3.c1; 2159c1 c1 21605 5 2161DROP TABLE t1,t2,t3,t4,t5,t6; 2162CREATE TABLE t1 (c1 INTEGER NOT NULL); 2163CREATE TABLE t2 (c1 INTEGER NOT NULL); 2164CREATE TABLE t3 (c1 INTEGER NOT NULL); 2165CREATE TABLE t4 (c1 INTEGER NOT NULL); 2166CREATE TABLE t5 (c1 INTEGER NOT NULL); 2167CREATE TABLE t6 (c1 INTEGER NOT NULL); 2168INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2169INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2170INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 2171INSERT INTO t4 (c1) VALUES(10); 2172INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 2173SELECT t1.c1,t3.c1 FROM t1 LEFT OUTER JOIN t3 ON t1.c1 = t3.c1 ORDER BY t1.c1,t3.c1; 2174c1 c1 21750 NULL 21761 1 21772 NULL 21783 3 21794 NULL 21805 5 21816 NULL 21827 7 21838 NULL 21849 9 2185SELECT t1.c1,t3.c1 FROM t1 LEFT OUTER JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 = 5 ORDER BY t1.c1,t3.c1; 2186c1 c1 21875 5 2188DROP TABLE t1,t2,t3,t4,t5,t6; 2189CREATE TABLE t1 (c1 BIGINT NOT NULL); 2190CREATE TABLE t2 (c1 BIGINT NOT NULL); 2191CREATE TABLE t3 (c1 BIGINT NOT NULL); 2192CREATE TABLE t4 (c1 BIGINT NOT NULL); 2193CREATE TABLE t5 (c1 BIGINT NOT NULL); 2194CREATE TABLE t6 (c1 BIGINT NOT NULL); 2195INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2196INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2197INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 2198INSERT INTO t4 (c1) VALUES(10); 2199INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 2200SELECT t1.c1,t3.c1 FROM t1 LEFT OUTER JOIN t3 ON t1.c1 = t3.c1 ORDER BY t1.c1,t3.c1; 2201c1 c1 22020 NULL 22031 1 22042 NULL 22053 3 22064 NULL 22075 5 22086 NULL 22097 7 22108 NULL 22119 9 2212SELECT t1.c1,t3.c1 FROM t1 LEFT OUTER JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 = 5 ORDER BY t1.c1,t3.c1; 2213c1 c1 22145 5 2215DROP TABLE t1,t2,t3,t4,t5,t6; 2216CREATE TABLE t1 (c1 TINYINT NOT NULL); 2217CREATE TABLE t2 (c1 TINYINT NOT NULL); 2218CREATE TABLE t3 (c1 TINYINT NOT NULL); 2219CREATE TABLE t4 (c1 TINYINT NOT NULL); 2220CREATE TABLE t5 (c1 TINYINT NOT NULL); 2221CREATE TABLE t6 (c1 TINYINT NOT NULL); 2222INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2223INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2224INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 2225INSERT INTO t4 (c1) VALUES(10); 2226INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 2227SELECT t1.c1,t4.c1 FROM t1 LEFT OUTER JOIN t4 ON t1.c1 = t4.c1 ORDER BY t1.c1,t4.c1; 2228c1 c1 22290 NULL 22301 NULL 22312 NULL 22323 NULL 22334 NULL 22345 NULL 22356 NULL 22367 NULL 22378 NULL 22389 NULL 2239SELECT t1.c1,t4.c1 FROM t1 LEFT OUTER JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 = 5 ORDER BY t1.c1,t4.c1; 2240c1 c1 22415 NULL 2242DROP TABLE t1,t2,t3,t4,t5,t6; 2243CREATE TABLE t1 (c1 SMALLINT NOT NULL); 2244CREATE TABLE t2 (c1 SMALLINT NOT NULL); 2245CREATE TABLE t3 (c1 SMALLINT NOT NULL); 2246CREATE TABLE t4 (c1 SMALLINT NOT NULL); 2247CREATE TABLE t5 (c1 SMALLINT NOT NULL); 2248CREATE TABLE t6 (c1 SMALLINT NOT NULL); 2249INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2250INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2251INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 2252INSERT INTO t4 (c1) VALUES(10); 2253INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 2254SELECT t1.c1,t4.c1 FROM t1 LEFT OUTER JOIN t4 ON t1.c1 = t4.c1 ORDER BY t1.c1,t4.c1; 2255c1 c1 22560 NULL 22571 NULL 22582 NULL 22593 NULL 22604 NULL 22615 NULL 22626 NULL 22637 NULL 22648 NULL 22659 NULL 2266SELECT t1.c1,t4.c1 FROM t1 LEFT OUTER JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 = 5 ORDER BY t1.c1,t4.c1; 2267c1 c1 22685 NULL 2269DROP TABLE t1,t2,t3,t4,t5,t6; 2270CREATE TABLE t1 (c1 MEDIUMINT NOT NULL); 2271CREATE TABLE t2 (c1 MEDIUMINT NOT NULL); 2272CREATE TABLE t3 (c1 MEDIUMINT NOT NULL); 2273CREATE TABLE t4 (c1 MEDIUMINT NOT NULL); 2274CREATE TABLE t5 (c1 MEDIUMINT NOT NULL); 2275CREATE TABLE t6 (c1 MEDIUMINT NOT NULL); 2276INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2277INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2278INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 2279INSERT INTO t4 (c1) VALUES(10); 2280INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 2281SELECT t1.c1,t4.c1 FROM t1 LEFT OUTER JOIN t4 ON t1.c1 = t4.c1 ORDER BY t1.c1,t4.c1; 2282c1 c1 22830 NULL 22841 NULL 22852 NULL 22863 NULL 22874 NULL 22885 NULL 22896 NULL 22907 NULL 22918 NULL 22929 NULL 2293SELECT t1.c1,t4.c1 FROM t1 LEFT OUTER JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 = 5 ORDER BY t1.c1,t4.c1; 2294c1 c1 22955 NULL 2296DROP TABLE t1,t2,t3,t4,t5,t6; 2297CREATE TABLE t1 (c1 INT NOT NULL); 2298CREATE TABLE t2 (c1 INT NOT NULL); 2299CREATE TABLE t3 (c1 INT NOT NULL); 2300CREATE TABLE t4 (c1 INT NOT NULL); 2301CREATE TABLE t5 (c1 INT NOT NULL); 2302CREATE TABLE t6 (c1 INT NOT NULL); 2303INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2304INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2305INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 2306INSERT INTO t4 (c1) VALUES(10); 2307INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 2308SELECT t1.c1,t4.c1 FROM t1 LEFT OUTER JOIN t4 ON t1.c1 = t4.c1 ORDER BY t1.c1,t4.c1; 2309c1 c1 23100 NULL 23111 NULL 23122 NULL 23133 NULL 23144 NULL 23155 NULL 23166 NULL 23177 NULL 23188 NULL 23199 NULL 2320SELECT t1.c1,t4.c1 FROM t1 LEFT OUTER JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 = 5 ORDER BY t1.c1,t4.c1; 2321c1 c1 23225 NULL 2323DROP TABLE t1,t2,t3,t4,t5,t6; 2324CREATE TABLE t1 (c1 INTEGER NOT NULL); 2325CREATE TABLE t2 (c1 INTEGER NOT NULL); 2326CREATE TABLE t3 (c1 INTEGER NOT NULL); 2327CREATE TABLE t4 (c1 INTEGER NOT NULL); 2328CREATE TABLE t5 (c1 INTEGER NOT NULL); 2329CREATE TABLE t6 (c1 INTEGER NOT NULL); 2330INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2331INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2332INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 2333INSERT INTO t4 (c1) VALUES(10); 2334INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 2335SELECT t1.c1,t4.c1 FROM t1 LEFT OUTER JOIN t4 ON t1.c1 = t4.c1 ORDER BY t1.c1,t4.c1; 2336c1 c1 23370 NULL 23381 NULL 23392 NULL 23403 NULL 23414 NULL 23425 NULL 23436 NULL 23447 NULL 23458 NULL 23469 NULL 2347SELECT t1.c1,t4.c1 FROM t1 LEFT OUTER JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 = 5 ORDER BY t1.c1,t4.c1; 2348c1 c1 23495 NULL 2350DROP TABLE t1,t2,t3,t4,t5,t6; 2351CREATE TABLE t1 (c1 BIGINT NOT NULL); 2352CREATE TABLE t2 (c1 BIGINT NOT NULL); 2353CREATE TABLE t3 (c1 BIGINT NOT NULL); 2354CREATE TABLE t4 (c1 BIGINT NOT NULL); 2355CREATE TABLE t5 (c1 BIGINT NOT NULL); 2356CREATE TABLE t6 (c1 BIGINT NOT NULL); 2357INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2358INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2359INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 2360INSERT INTO t4 (c1) VALUES(10); 2361INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 2362SELECT t1.c1,t4.c1 FROM t1 LEFT OUTER JOIN t4 ON t1.c1 = t4.c1 ORDER BY t1.c1,t4.c1; 2363c1 c1 23640 NULL 23651 NULL 23662 NULL 23673 NULL 23684 NULL 23695 NULL 23706 NULL 23717 NULL 23728 NULL 23739 NULL 2374SELECT t1.c1,t4.c1 FROM t1 LEFT OUTER JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 = 5 ORDER BY t1.c1,t4.c1; 2375c1 c1 23765 NULL 2377DROP TABLE t1,t2,t3,t4,t5,t6; 2378CREATE TABLE t1 (c1 TINYINT NOT NULL); 2379CREATE TABLE t2 (c1 TINYINT NOT NULL); 2380CREATE TABLE t3 (c1 TINYINT NOT NULL); 2381CREATE TABLE t4 (c1 TINYINT NOT NULL); 2382CREATE TABLE t5 (c1 TINYINT NOT NULL); 2383CREATE TABLE t6 (c1 TINYINT NOT NULL); 2384INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2385INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2386INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 2387INSERT INTO t4 (c1) VALUES(10); 2388INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 2389SELECT t1.c1,t5.c1 FROM t1 LEFT OUTER JOIN t5 ON t1.c1 = t5.c1 ORDER BY t1.c1,t5.c1; 2390c1 c1 23910 NULL 23921 NULL 23932 NULL 23943 NULL 23954 NULL 23965 NULL 23976 NULL 23987 NULL 23998 NULL 24009 NULL 2401SELECT t1.c1,t5.c1 FROM t1 LEFT OUTER JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 = 5 ORDER BY t1.c1,t5.c1; 2402c1 c1 24035 NULL 2404DROP TABLE t1,t2,t3,t4,t5,t6; 2405CREATE TABLE t1 (c1 SMALLINT NOT NULL); 2406CREATE TABLE t2 (c1 SMALLINT NOT NULL); 2407CREATE TABLE t3 (c1 SMALLINT NOT NULL); 2408CREATE TABLE t4 (c1 SMALLINT NOT NULL); 2409CREATE TABLE t5 (c1 SMALLINT NOT NULL); 2410CREATE TABLE t6 (c1 SMALLINT NOT NULL); 2411INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2412INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2413INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 2414INSERT INTO t4 (c1) VALUES(10); 2415INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 2416SELECT t1.c1,t5.c1 FROM t1 LEFT OUTER JOIN t5 ON t1.c1 = t5.c1 ORDER BY t1.c1,t5.c1; 2417c1 c1 24180 NULL 24191 NULL 24202 NULL 24213 NULL 24224 NULL 24235 NULL 24246 NULL 24257 NULL 24268 NULL 24279 NULL 2428SELECT t1.c1,t5.c1 FROM t1 LEFT OUTER JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 = 5 ORDER BY t1.c1,t5.c1; 2429c1 c1 24305 NULL 2431DROP TABLE t1,t2,t3,t4,t5,t6; 2432CREATE TABLE t1 (c1 MEDIUMINT NOT NULL); 2433CREATE TABLE t2 (c1 MEDIUMINT NOT NULL); 2434CREATE TABLE t3 (c1 MEDIUMINT NOT NULL); 2435CREATE TABLE t4 (c1 MEDIUMINT NOT NULL); 2436CREATE TABLE t5 (c1 MEDIUMINT NOT NULL); 2437CREATE TABLE t6 (c1 MEDIUMINT NOT NULL); 2438INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2439INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2440INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 2441INSERT INTO t4 (c1) VALUES(10); 2442INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 2443SELECT t1.c1,t5.c1 FROM t1 LEFT OUTER JOIN t5 ON t1.c1 = t5.c1 ORDER BY t1.c1,t5.c1; 2444c1 c1 24450 NULL 24461 NULL 24472 NULL 24483 NULL 24494 NULL 24505 NULL 24516 NULL 24527 NULL 24538 NULL 24549 NULL 2455SELECT t1.c1,t5.c1 FROM t1 LEFT OUTER JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 = 5 ORDER BY t1.c1,t5.c1; 2456c1 c1 24575 NULL 2458DROP TABLE t1,t2,t3,t4,t5,t6; 2459CREATE TABLE t1 (c1 INT NOT NULL); 2460CREATE TABLE t2 (c1 INT NOT NULL); 2461CREATE TABLE t3 (c1 INT NOT NULL); 2462CREATE TABLE t4 (c1 INT NOT NULL); 2463CREATE TABLE t5 (c1 INT NOT NULL); 2464CREATE TABLE t6 (c1 INT NOT NULL); 2465INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2466INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2467INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 2468INSERT INTO t4 (c1) VALUES(10); 2469INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 2470SELECT t1.c1,t5.c1 FROM t1 LEFT OUTER JOIN t5 ON t1.c1 = t5.c1 ORDER BY t1.c1,t5.c1; 2471c1 c1 24720 NULL 24731 NULL 24742 NULL 24753 NULL 24764 NULL 24775 NULL 24786 NULL 24797 NULL 24808 NULL 24819 NULL 2482SELECT t1.c1,t5.c1 FROM t1 LEFT OUTER JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 = 5 ORDER BY t1.c1,t5.c1; 2483c1 c1 24845 NULL 2485DROP TABLE t1,t2,t3,t4,t5,t6; 2486CREATE TABLE t1 (c1 INTEGER NOT NULL); 2487CREATE TABLE t2 (c1 INTEGER NOT NULL); 2488CREATE TABLE t3 (c1 INTEGER NOT NULL); 2489CREATE TABLE t4 (c1 INTEGER NOT NULL); 2490CREATE TABLE t5 (c1 INTEGER NOT NULL); 2491CREATE TABLE t6 (c1 INTEGER NOT NULL); 2492INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2493INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2494INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 2495INSERT INTO t4 (c1) VALUES(10); 2496INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 2497SELECT t1.c1,t5.c1 FROM t1 LEFT OUTER JOIN t5 ON t1.c1 = t5.c1 ORDER BY t1.c1,t5.c1; 2498c1 c1 24990 NULL 25001 NULL 25012 NULL 25023 NULL 25034 NULL 25045 NULL 25056 NULL 25067 NULL 25078 NULL 25089 NULL 2509SELECT t1.c1,t5.c1 FROM t1 LEFT OUTER JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 = 5 ORDER BY t1.c1,t5.c1; 2510c1 c1 25115 NULL 2512DROP TABLE t1,t2,t3,t4,t5,t6; 2513CREATE TABLE t1 (c1 BIGINT NOT NULL); 2514CREATE TABLE t2 (c1 BIGINT NOT NULL); 2515CREATE TABLE t3 (c1 BIGINT NOT NULL); 2516CREATE TABLE t4 (c1 BIGINT NOT NULL); 2517CREATE TABLE t5 (c1 BIGINT NOT NULL); 2518CREATE TABLE t6 (c1 BIGINT NOT NULL); 2519INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2520INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2521INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 2522INSERT INTO t4 (c1) VALUES(10); 2523INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 2524SELECT t1.c1,t5.c1 FROM t1 LEFT OUTER JOIN t5 ON t1.c1 = t5.c1 ORDER BY t1.c1,t5.c1; 2525c1 c1 25260 NULL 25271 NULL 25282 NULL 25293 NULL 25304 NULL 25315 NULL 25326 NULL 25337 NULL 25348 NULL 25359 NULL 2536SELECT t1.c1,t5.c1 FROM t1 LEFT OUTER JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 = 5 ORDER BY t1.c1,t5.c1; 2537c1 c1 25385 NULL 2539DROP TABLE t1,t2,t3,t4,t5,t6; 2540CREATE TABLE t1 (c1 TINYINT NOT NULL); 2541CREATE TABLE t2 (c1 TINYINT NOT NULL); 2542CREATE TABLE t3 (c1 TINYINT NOT NULL); 2543CREATE TABLE t4 (c1 TINYINT NOT NULL); 2544CREATE TABLE t5 (c1 TINYINT NOT NULL); 2545CREATE TABLE t6 (c1 TINYINT NOT NULL); 2546INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2547INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2548INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 2549INSERT INTO t4 (c1) VALUES(10); 2550INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 2551SELECT t1.c1,t6.c1 FROM t1 LEFT OUTER JOIN t6 ON t1.c1 = t6.c1 ORDER BY t1.c1,t6.c1; 2552c1 c1 25530 NULL 25541 NULL 25552 NULL 25563 NULL 25574 NULL 25585 NULL 25596 NULL 25607 NULL 25618 NULL 25629 NULL 2563SELECT t1.c1,t6.c1 FROM t1 LEFT OUTER JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 = 5 ORDER BY t1.c1,t6.c1; 2564c1 c1 25655 NULL 2566DROP TABLE t1,t2,t3,t4,t5,t6; 2567CREATE TABLE t1 (c1 SMALLINT NOT NULL); 2568CREATE TABLE t2 (c1 SMALLINT NOT NULL); 2569CREATE TABLE t3 (c1 SMALLINT NOT NULL); 2570CREATE TABLE t4 (c1 SMALLINT NOT NULL); 2571CREATE TABLE t5 (c1 SMALLINT NOT NULL); 2572CREATE TABLE t6 (c1 SMALLINT NOT NULL); 2573INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2574INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2575INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 2576INSERT INTO t4 (c1) VALUES(10); 2577INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 2578SELECT t1.c1,t6.c1 FROM t1 LEFT OUTER JOIN t6 ON t1.c1 = t6.c1 ORDER BY t1.c1,t6.c1; 2579c1 c1 25800 NULL 25811 NULL 25822 NULL 25833 NULL 25844 NULL 25855 NULL 25866 NULL 25877 NULL 25888 NULL 25899 NULL 2590SELECT t1.c1,t6.c1 FROM t1 LEFT OUTER JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 = 5 ORDER BY t1.c1,t6.c1; 2591c1 c1 25925 NULL 2593DROP TABLE t1,t2,t3,t4,t5,t6; 2594CREATE TABLE t1 (c1 MEDIUMINT NOT NULL); 2595CREATE TABLE t2 (c1 MEDIUMINT NOT NULL); 2596CREATE TABLE t3 (c1 MEDIUMINT NOT NULL); 2597CREATE TABLE t4 (c1 MEDIUMINT NOT NULL); 2598CREATE TABLE t5 (c1 MEDIUMINT NOT NULL); 2599CREATE TABLE t6 (c1 MEDIUMINT NOT NULL); 2600INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2601INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2602INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 2603INSERT INTO t4 (c1) VALUES(10); 2604INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 2605SELECT t1.c1,t6.c1 FROM t1 LEFT OUTER JOIN t6 ON t1.c1 = t6.c1 ORDER BY t1.c1,t6.c1; 2606c1 c1 26070 NULL 26081 NULL 26092 NULL 26103 NULL 26114 NULL 26125 NULL 26136 NULL 26147 NULL 26158 NULL 26169 NULL 2617SELECT t1.c1,t6.c1 FROM t1 LEFT OUTER JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 = 5 ORDER BY t1.c1,t6.c1; 2618c1 c1 26195 NULL 2620DROP TABLE t1,t2,t3,t4,t5,t6; 2621CREATE TABLE t1 (c1 INT NOT NULL); 2622CREATE TABLE t2 (c1 INT NOT NULL); 2623CREATE TABLE t3 (c1 INT NOT NULL); 2624CREATE TABLE t4 (c1 INT NOT NULL); 2625CREATE TABLE t5 (c1 INT NOT NULL); 2626CREATE TABLE t6 (c1 INT NOT NULL); 2627INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2628INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2629INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 2630INSERT INTO t4 (c1) VALUES(10); 2631INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 2632SELECT t1.c1,t6.c1 FROM t1 LEFT OUTER JOIN t6 ON t1.c1 = t6.c1 ORDER BY t1.c1,t6.c1; 2633c1 c1 26340 NULL 26351 NULL 26362 NULL 26373 NULL 26384 NULL 26395 NULL 26406 NULL 26417 NULL 26428 NULL 26439 NULL 2644SELECT t1.c1,t6.c1 FROM t1 LEFT OUTER JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 = 5 ORDER BY t1.c1,t6.c1; 2645c1 c1 26465 NULL 2647DROP TABLE t1,t2,t3,t4,t5,t6; 2648CREATE TABLE t1 (c1 INTEGER NOT NULL); 2649CREATE TABLE t2 (c1 INTEGER NOT NULL); 2650CREATE TABLE t3 (c1 INTEGER NOT NULL); 2651CREATE TABLE t4 (c1 INTEGER NOT NULL); 2652CREATE TABLE t5 (c1 INTEGER NOT NULL); 2653CREATE TABLE t6 (c1 INTEGER NOT NULL); 2654INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2655INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2656INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 2657INSERT INTO t4 (c1) VALUES(10); 2658INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 2659SELECT t1.c1,t6.c1 FROM t1 LEFT OUTER JOIN t6 ON t1.c1 = t6.c1 ORDER BY t1.c1,t6.c1; 2660c1 c1 26610 NULL 26621 NULL 26632 NULL 26643 NULL 26654 NULL 26665 NULL 26676 NULL 26687 NULL 26698 NULL 26709 NULL 2671SELECT t1.c1,t6.c1 FROM t1 LEFT OUTER JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 = 5 ORDER BY t1.c1,t6.c1; 2672c1 c1 26735 NULL 2674DROP TABLE t1,t2,t3,t4,t5,t6; 2675CREATE TABLE t1 (c1 BIGINT NOT NULL); 2676CREATE TABLE t2 (c1 BIGINT NOT NULL); 2677CREATE TABLE t3 (c1 BIGINT NOT NULL); 2678CREATE TABLE t4 (c1 BIGINT NOT NULL); 2679CREATE TABLE t5 (c1 BIGINT NOT NULL); 2680CREATE TABLE t6 (c1 BIGINT NOT NULL); 2681INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2682INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2683INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 2684INSERT INTO t4 (c1) VALUES(10); 2685INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 2686SELECT t1.c1,t6.c1 FROM t1 LEFT OUTER JOIN t6 ON t1.c1 = t6.c1 ORDER BY t1.c1,t6.c1; 2687c1 c1 26880 NULL 26891 NULL 26902 NULL 26913 NULL 26924 NULL 26935 NULL 26946 NULL 26957 NULL 26968 NULL 26979 NULL 2698SELECT t1.c1,t6.c1 FROM t1 LEFT OUTER JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 = 5 ORDER BY t1.c1,t6.c1; 2699c1 c1 27005 NULL 2701DROP TABLE t1,t2,t3,t4,t5,t6; 2702CREATE TABLE t1 (c1 TINYINT NOT NULL); 2703CREATE TABLE t2 (c1 TINYINT NOT NULL); 2704CREATE TABLE t3 (c1 TINYINT NOT NULL); 2705CREATE TABLE t4 (c1 TINYINT NOT NULL); 2706CREATE TABLE t5 (c1 TINYINT NOT NULL); 2707CREATE TABLE t6 (c1 TINYINT NOT NULL); 2708INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2709INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2710INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 2711INSERT INTO t4 (c1) VALUES(10); 2712INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 2713SELECT t1.c1,t2.c1 FROM t1 LEFT OUTER JOIN t2 ON t1.c1 = t2.c1 ORDER BY t1.c1,t2.c1; 2714c1 c1 27150 0 27161 1 27172 2 27183 3 27194 4 27205 5 27216 6 27227 7 27238 8 27249 9 2725SELECT t1.c1,t2.c1 FROM t1 LEFT OUTER JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 >= 5 ORDER BY t1.c1,t2.c1; 2726c1 c1 27275 5 27286 6 27297 7 27308 8 27319 9 2732DROP TABLE t1,t2,t3,t4,t5,t6; 2733CREATE TABLE t1 (c1 SMALLINT NOT NULL); 2734CREATE TABLE t2 (c1 SMALLINT NOT NULL); 2735CREATE TABLE t3 (c1 SMALLINT NOT NULL); 2736CREATE TABLE t4 (c1 SMALLINT NOT NULL); 2737CREATE TABLE t5 (c1 SMALLINT NOT NULL); 2738CREATE TABLE t6 (c1 SMALLINT NOT NULL); 2739INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2740INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2741INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 2742INSERT INTO t4 (c1) VALUES(10); 2743INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 2744SELECT t1.c1,t2.c1 FROM t1 LEFT OUTER JOIN t2 ON t1.c1 = t2.c1 ORDER BY t1.c1,t2.c1; 2745c1 c1 27460 0 27471 1 27482 2 27493 3 27504 4 27515 5 27526 6 27537 7 27548 8 27559 9 2756SELECT t1.c1,t2.c1 FROM t1 LEFT OUTER JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 >= 5 ORDER BY t1.c1,t2.c1; 2757c1 c1 27585 5 27596 6 27607 7 27618 8 27629 9 2763DROP TABLE t1,t2,t3,t4,t5,t6; 2764CREATE TABLE t1 (c1 MEDIUMINT NOT NULL); 2765CREATE TABLE t2 (c1 MEDIUMINT NOT NULL); 2766CREATE TABLE t3 (c1 MEDIUMINT NOT NULL); 2767CREATE TABLE t4 (c1 MEDIUMINT NOT NULL); 2768CREATE TABLE t5 (c1 MEDIUMINT NOT NULL); 2769CREATE TABLE t6 (c1 MEDIUMINT NOT NULL); 2770INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2771INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2772INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 2773INSERT INTO t4 (c1) VALUES(10); 2774INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 2775SELECT t1.c1,t2.c1 FROM t1 LEFT OUTER JOIN t2 ON t1.c1 = t2.c1 ORDER BY t1.c1,t2.c1; 2776c1 c1 27770 0 27781 1 27792 2 27803 3 27814 4 27825 5 27836 6 27847 7 27858 8 27869 9 2787SELECT t1.c1,t2.c1 FROM t1 LEFT OUTER JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 >= 5 ORDER BY t1.c1,t2.c1; 2788c1 c1 27895 5 27906 6 27917 7 27928 8 27939 9 2794DROP TABLE t1,t2,t3,t4,t5,t6; 2795CREATE TABLE t1 (c1 INT NOT NULL); 2796CREATE TABLE t2 (c1 INT NOT NULL); 2797CREATE TABLE t3 (c1 INT NOT NULL); 2798CREATE TABLE t4 (c1 INT NOT NULL); 2799CREATE TABLE t5 (c1 INT NOT NULL); 2800CREATE TABLE t6 (c1 INT NOT NULL); 2801INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2802INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2803INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 2804INSERT INTO t4 (c1) VALUES(10); 2805INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 2806SELECT t1.c1,t2.c1 FROM t1 LEFT OUTER JOIN t2 ON t1.c1 = t2.c1 ORDER BY t1.c1,t2.c1; 2807c1 c1 28080 0 28091 1 28102 2 28113 3 28124 4 28135 5 28146 6 28157 7 28168 8 28179 9 2818SELECT t1.c1,t2.c1 FROM t1 LEFT OUTER JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 >= 5 ORDER BY t1.c1,t2.c1; 2819c1 c1 28205 5 28216 6 28227 7 28238 8 28249 9 2825DROP TABLE t1,t2,t3,t4,t5,t6; 2826CREATE TABLE t1 (c1 INTEGER NOT NULL); 2827CREATE TABLE t2 (c1 INTEGER NOT NULL); 2828CREATE TABLE t3 (c1 INTEGER NOT NULL); 2829CREATE TABLE t4 (c1 INTEGER NOT NULL); 2830CREATE TABLE t5 (c1 INTEGER NOT NULL); 2831CREATE TABLE t6 (c1 INTEGER NOT NULL); 2832INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2833INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2834INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 2835INSERT INTO t4 (c1) VALUES(10); 2836INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 2837SELECT t1.c1,t2.c1 FROM t1 LEFT OUTER JOIN t2 ON t1.c1 = t2.c1 ORDER BY t1.c1,t2.c1; 2838c1 c1 28390 0 28401 1 28412 2 28423 3 28434 4 28445 5 28456 6 28467 7 28478 8 28489 9 2849SELECT t1.c1,t2.c1 FROM t1 LEFT OUTER JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 >= 5 ORDER BY t1.c1,t2.c1; 2850c1 c1 28515 5 28526 6 28537 7 28548 8 28559 9 2856DROP TABLE t1,t2,t3,t4,t5,t6; 2857CREATE TABLE t1 (c1 BIGINT NOT NULL); 2858CREATE TABLE t2 (c1 BIGINT NOT NULL); 2859CREATE TABLE t3 (c1 BIGINT NOT NULL); 2860CREATE TABLE t4 (c1 BIGINT NOT NULL); 2861CREATE TABLE t5 (c1 BIGINT NOT NULL); 2862CREATE TABLE t6 (c1 BIGINT NOT NULL); 2863INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2864INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2865INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 2866INSERT INTO t4 (c1) VALUES(10); 2867INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 2868SELECT t1.c1,t2.c1 FROM t1 LEFT OUTER JOIN t2 ON t1.c1 = t2.c1 ORDER BY t1.c1,t2.c1; 2869c1 c1 28700 0 28711 1 28722 2 28733 3 28744 4 28755 5 28766 6 28777 7 28788 8 28799 9 2880SELECT t1.c1,t2.c1 FROM t1 LEFT OUTER JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 >= 5 ORDER BY t1.c1,t2.c1; 2881c1 c1 28825 5 28836 6 28847 7 28858 8 28869 9 2887DROP TABLE t1,t2,t3,t4,t5,t6; 2888CREATE TABLE t1 (c1 TINYINT NOT NULL); 2889CREATE TABLE t2 (c1 TINYINT NOT NULL); 2890CREATE TABLE t3 (c1 TINYINT NOT NULL); 2891CREATE TABLE t4 (c1 TINYINT NOT NULL); 2892CREATE TABLE t5 (c1 TINYINT NOT NULL); 2893CREATE TABLE t6 (c1 TINYINT NOT NULL); 2894INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2895INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2896INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 2897INSERT INTO t4 (c1) VALUES(10); 2898INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 2899SELECT t1.c1,t3.c1 FROM t1 LEFT OUTER JOIN t3 ON t1.c1 = t3.c1 ORDER BY t1.c1,t3.c1; 2900c1 c1 29010 NULL 29021 1 29032 NULL 29043 3 29054 NULL 29065 5 29076 NULL 29087 7 29098 NULL 29109 9 2911SELECT t1.c1,t3.c1 FROM t1 LEFT OUTER JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 >= 5 ORDER BY t1.c1,t3.c1; 2912c1 c1 29135 5 29146 NULL 29157 7 29168 NULL 29179 9 2918DROP TABLE t1,t2,t3,t4,t5,t6; 2919CREATE TABLE t1 (c1 SMALLINT NOT NULL); 2920CREATE TABLE t2 (c1 SMALLINT NOT NULL); 2921CREATE TABLE t3 (c1 SMALLINT NOT NULL); 2922CREATE TABLE t4 (c1 SMALLINT NOT NULL); 2923CREATE TABLE t5 (c1 SMALLINT NOT NULL); 2924CREATE TABLE t6 (c1 SMALLINT NOT NULL); 2925INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2926INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2927INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 2928INSERT INTO t4 (c1) VALUES(10); 2929INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 2930SELECT t1.c1,t3.c1 FROM t1 LEFT OUTER JOIN t3 ON t1.c1 = t3.c1 ORDER BY t1.c1,t3.c1; 2931c1 c1 29320 NULL 29331 1 29342 NULL 29353 3 29364 NULL 29375 5 29386 NULL 29397 7 29408 NULL 29419 9 2942SELECT t1.c1,t3.c1 FROM t1 LEFT OUTER JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 >= 5 ORDER BY t1.c1,t3.c1; 2943c1 c1 29445 5 29456 NULL 29467 7 29478 NULL 29489 9 2949DROP TABLE t1,t2,t3,t4,t5,t6; 2950CREATE TABLE t1 (c1 MEDIUMINT NOT NULL); 2951CREATE TABLE t2 (c1 MEDIUMINT NOT NULL); 2952CREATE TABLE t3 (c1 MEDIUMINT NOT NULL); 2953CREATE TABLE t4 (c1 MEDIUMINT NOT NULL); 2954CREATE TABLE t5 (c1 MEDIUMINT NOT NULL); 2955CREATE TABLE t6 (c1 MEDIUMINT NOT NULL); 2956INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2957INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2958INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 2959INSERT INTO t4 (c1) VALUES(10); 2960INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 2961SELECT t1.c1,t3.c1 FROM t1 LEFT OUTER JOIN t3 ON t1.c1 = t3.c1 ORDER BY t1.c1,t3.c1; 2962c1 c1 29630 NULL 29641 1 29652 NULL 29663 3 29674 NULL 29685 5 29696 NULL 29707 7 29718 NULL 29729 9 2973SELECT t1.c1,t3.c1 FROM t1 LEFT OUTER JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 >= 5 ORDER BY t1.c1,t3.c1; 2974c1 c1 29755 5 29766 NULL 29777 7 29788 NULL 29799 9 2980DROP TABLE t1,t2,t3,t4,t5,t6; 2981CREATE TABLE t1 (c1 INT NOT NULL); 2982CREATE TABLE t2 (c1 INT NOT NULL); 2983CREATE TABLE t3 (c1 INT NOT NULL); 2984CREATE TABLE t4 (c1 INT NOT NULL); 2985CREATE TABLE t5 (c1 INT NOT NULL); 2986CREATE TABLE t6 (c1 INT NOT NULL); 2987INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2988INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2989INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 2990INSERT INTO t4 (c1) VALUES(10); 2991INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 2992SELECT t1.c1,t3.c1 FROM t1 LEFT OUTER JOIN t3 ON t1.c1 = t3.c1 ORDER BY t1.c1,t3.c1; 2993c1 c1 29940 NULL 29951 1 29962 NULL 29973 3 29984 NULL 29995 5 30006 NULL 30017 7 30028 NULL 30039 9 3004SELECT t1.c1,t3.c1 FROM t1 LEFT OUTER JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 >= 5 ORDER BY t1.c1,t3.c1; 3005c1 c1 30065 5 30076 NULL 30087 7 30098 NULL 30109 9 3011DROP TABLE t1,t2,t3,t4,t5,t6; 3012CREATE TABLE t1 (c1 INTEGER NOT NULL); 3013CREATE TABLE t2 (c1 INTEGER NOT NULL); 3014CREATE TABLE t3 (c1 INTEGER NOT NULL); 3015CREATE TABLE t4 (c1 INTEGER NOT NULL); 3016CREATE TABLE t5 (c1 INTEGER NOT NULL); 3017CREATE TABLE t6 (c1 INTEGER NOT NULL); 3018INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3019INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3020INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 3021INSERT INTO t4 (c1) VALUES(10); 3022INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 3023SELECT t1.c1,t3.c1 FROM t1 LEFT OUTER JOIN t3 ON t1.c1 = t3.c1 ORDER BY t1.c1,t3.c1; 3024c1 c1 30250 NULL 30261 1 30272 NULL 30283 3 30294 NULL 30305 5 30316 NULL 30327 7 30338 NULL 30349 9 3035SELECT t1.c1,t3.c1 FROM t1 LEFT OUTER JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 >= 5 ORDER BY t1.c1,t3.c1; 3036c1 c1 30375 5 30386 NULL 30397 7 30408 NULL 30419 9 3042DROP TABLE t1,t2,t3,t4,t5,t6; 3043CREATE TABLE t1 (c1 BIGINT NOT NULL); 3044CREATE TABLE t2 (c1 BIGINT NOT NULL); 3045CREATE TABLE t3 (c1 BIGINT NOT NULL); 3046CREATE TABLE t4 (c1 BIGINT NOT NULL); 3047CREATE TABLE t5 (c1 BIGINT NOT NULL); 3048CREATE TABLE t6 (c1 BIGINT NOT NULL); 3049INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3050INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3051INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 3052INSERT INTO t4 (c1) VALUES(10); 3053INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 3054SELECT t1.c1,t3.c1 FROM t1 LEFT OUTER JOIN t3 ON t1.c1 = t3.c1 ORDER BY t1.c1,t3.c1; 3055c1 c1 30560 NULL 30571 1 30582 NULL 30593 3 30604 NULL 30615 5 30626 NULL 30637 7 30648 NULL 30659 9 3066SELECT t1.c1,t3.c1 FROM t1 LEFT OUTER JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 >= 5 ORDER BY t1.c1,t3.c1; 3067c1 c1 30685 5 30696 NULL 30707 7 30718 NULL 30729 9 3073DROP TABLE t1,t2,t3,t4,t5,t6; 3074CREATE TABLE t1 (c1 TINYINT NOT NULL); 3075CREATE TABLE t2 (c1 TINYINT NOT NULL); 3076CREATE TABLE t3 (c1 TINYINT NOT NULL); 3077CREATE TABLE t4 (c1 TINYINT NOT NULL); 3078CREATE TABLE t5 (c1 TINYINT NOT NULL); 3079CREATE TABLE t6 (c1 TINYINT NOT NULL); 3080INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3081INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3082INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 3083INSERT INTO t4 (c1) VALUES(10); 3084INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 3085SELECT t1.c1,t4.c1 FROM t1 LEFT OUTER JOIN t4 ON t1.c1 = t4.c1 ORDER BY t1.c1,t4.c1; 3086c1 c1 30870 NULL 30881 NULL 30892 NULL 30903 NULL 30914 NULL 30925 NULL 30936 NULL 30947 NULL 30958 NULL 30969 NULL 3097SELECT t1.c1,t4.c1 FROM t1 LEFT OUTER JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 >= 5 ORDER BY t1.c1,t4.c1; 3098c1 c1 30995 NULL 31006 NULL 31017 NULL 31028 NULL 31039 NULL 3104DROP TABLE t1,t2,t3,t4,t5,t6; 3105CREATE TABLE t1 (c1 SMALLINT NOT NULL); 3106CREATE TABLE t2 (c1 SMALLINT NOT NULL); 3107CREATE TABLE t3 (c1 SMALLINT NOT NULL); 3108CREATE TABLE t4 (c1 SMALLINT NOT NULL); 3109CREATE TABLE t5 (c1 SMALLINT NOT NULL); 3110CREATE TABLE t6 (c1 SMALLINT NOT NULL); 3111INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3112INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3113INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 3114INSERT INTO t4 (c1) VALUES(10); 3115INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 3116SELECT t1.c1,t4.c1 FROM t1 LEFT OUTER JOIN t4 ON t1.c1 = t4.c1 ORDER BY t1.c1,t4.c1; 3117c1 c1 31180 NULL 31191 NULL 31202 NULL 31213 NULL 31224 NULL 31235 NULL 31246 NULL 31257 NULL 31268 NULL 31279 NULL 3128SELECT t1.c1,t4.c1 FROM t1 LEFT OUTER JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 >= 5 ORDER BY t1.c1,t4.c1; 3129c1 c1 31305 NULL 31316 NULL 31327 NULL 31338 NULL 31349 NULL 3135DROP TABLE t1,t2,t3,t4,t5,t6; 3136CREATE TABLE t1 (c1 MEDIUMINT NOT NULL); 3137CREATE TABLE t2 (c1 MEDIUMINT NOT NULL); 3138CREATE TABLE t3 (c1 MEDIUMINT NOT NULL); 3139CREATE TABLE t4 (c1 MEDIUMINT NOT NULL); 3140CREATE TABLE t5 (c1 MEDIUMINT NOT NULL); 3141CREATE TABLE t6 (c1 MEDIUMINT NOT NULL); 3142INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3143INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3144INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 3145INSERT INTO t4 (c1) VALUES(10); 3146INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 3147SELECT t1.c1,t4.c1 FROM t1 LEFT OUTER JOIN t4 ON t1.c1 = t4.c1 ORDER BY t1.c1,t4.c1; 3148c1 c1 31490 NULL 31501 NULL 31512 NULL 31523 NULL 31534 NULL 31545 NULL 31556 NULL 31567 NULL 31578 NULL 31589 NULL 3159SELECT t1.c1,t4.c1 FROM t1 LEFT OUTER JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 >= 5 ORDER BY t1.c1,t4.c1; 3160c1 c1 31615 NULL 31626 NULL 31637 NULL 31648 NULL 31659 NULL 3166DROP TABLE t1,t2,t3,t4,t5,t6; 3167CREATE TABLE t1 (c1 INT NOT NULL); 3168CREATE TABLE t2 (c1 INT NOT NULL); 3169CREATE TABLE t3 (c1 INT NOT NULL); 3170CREATE TABLE t4 (c1 INT NOT NULL); 3171CREATE TABLE t5 (c1 INT NOT NULL); 3172CREATE TABLE t6 (c1 INT NOT NULL); 3173INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3174INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3175INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 3176INSERT INTO t4 (c1) VALUES(10); 3177INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 3178SELECT t1.c1,t4.c1 FROM t1 LEFT OUTER JOIN t4 ON t1.c1 = t4.c1 ORDER BY t1.c1,t4.c1; 3179c1 c1 31800 NULL 31811 NULL 31822 NULL 31833 NULL 31844 NULL 31855 NULL 31866 NULL 31877 NULL 31888 NULL 31899 NULL 3190SELECT t1.c1,t4.c1 FROM t1 LEFT OUTER JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 >= 5 ORDER BY t1.c1,t4.c1; 3191c1 c1 31925 NULL 31936 NULL 31947 NULL 31958 NULL 31969 NULL 3197DROP TABLE t1,t2,t3,t4,t5,t6; 3198CREATE TABLE t1 (c1 INTEGER NOT NULL); 3199CREATE TABLE t2 (c1 INTEGER NOT NULL); 3200CREATE TABLE t3 (c1 INTEGER NOT NULL); 3201CREATE TABLE t4 (c1 INTEGER NOT NULL); 3202CREATE TABLE t5 (c1 INTEGER NOT NULL); 3203CREATE TABLE t6 (c1 INTEGER NOT NULL); 3204INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3205INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3206INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 3207INSERT INTO t4 (c1) VALUES(10); 3208INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 3209SELECT t1.c1,t4.c1 FROM t1 LEFT OUTER JOIN t4 ON t1.c1 = t4.c1 ORDER BY t1.c1,t4.c1; 3210c1 c1 32110 NULL 32121 NULL 32132 NULL 32143 NULL 32154 NULL 32165 NULL 32176 NULL 32187 NULL 32198 NULL 32209 NULL 3221SELECT t1.c1,t4.c1 FROM t1 LEFT OUTER JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 >= 5 ORDER BY t1.c1,t4.c1; 3222c1 c1 32235 NULL 32246 NULL 32257 NULL 32268 NULL 32279 NULL 3228DROP TABLE t1,t2,t3,t4,t5,t6; 3229CREATE TABLE t1 (c1 BIGINT NOT NULL); 3230CREATE TABLE t2 (c1 BIGINT NOT NULL); 3231CREATE TABLE t3 (c1 BIGINT NOT NULL); 3232CREATE TABLE t4 (c1 BIGINT NOT NULL); 3233CREATE TABLE t5 (c1 BIGINT NOT NULL); 3234CREATE TABLE t6 (c1 BIGINT NOT NULL); 3235INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3236INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3237INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 3238INSERT INTO t4 (c1) VALUES(10); 3239INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 3240SELECT t1.c1,t4.c1 FROM t1 LEFT OUTER JOIN t4 ON t1.c1 = t4.c1 ORDER BY t1.c1,t4.c1; 3241c1 c1 32420 NULL 32431 NULL 32442 NULL 32453 NULL 32464 NULL 32475 NULL 32486 NULL 32497 NULL 32508 NULL 32519 NULL 3252SELECT t1.c1,t4.c1 FROM t1 LEFT OUTER JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 >= 5 ORDER BY t1.c1,t4.c1; 3253c1 c1 32545 NULL 32556 NULL 32567 NULL 32578 NULL 32589 NULL 3259DROP TABLE t1,t2,t3,t4,t5,t6; 3260CREATE TABLE t1 (c1 TINYINT NOT NULL); 3261CREATE TABLE t2 (c1 TINYINT NOT NULL); 3262CREATE TABLE t3 (c1 TINYINT NOT NULL); 3263CREATE TABLE t4 (c1 TINYINT NOT NULL); 3264CREATE TABLE t5 (c1 TINYINT NOT NULL); 3265CREATE TABLE t6 (c1 TINYINT NOT NULL); 3266INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3267INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3268INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 3269INSERT INTO t4 (c1) VALUES(10); 3270INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 3271SELECT t1.c1,t5.c1 FROM t1 LEFT OUTER JOIN t5 ON t1.c1 = t5.c1 ORDER BY t1.c1,t5.c1; 3272c1 c1 32730 NULL 32741 NULL 32752 NULL 32763 NULL 32774 NULL 32785 NULL 32796 NULL 32807 NULL 32818 NULL 32829 NULL 3283SELECT t1.c1,t5.c1 FROM t1 LEFT OUTER JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 >= 5 ORDER BY t1.c1,t5.c1; 3284c1 c1 32855 NULL 32866 NULL 32877 NULL 32888 NULL 32899 NULL 3290DROP TABLE t1,t2,t3,t4,t5,t6; 3291CREATE TABLE t1 (c1 SMALLINT NOT NULL); 3292CREATE TABLE t2 (c1 SMALLINT NOT NULL); 3293CREATE TABLE t3 (c1 SMALLINT NOT NULL); 3294CREATE TABLE t4 (c1 SMALLINT NOT NULL); 3295CREATE TABLE t5 (c1 SMALLINT NOT NULL); 3296CREATE TABLE t6 (c1 SMALLINT NOT NULL); 3297INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3298INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3299INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 3300INSERT INTO t4 (c1) VALUES(10); 3301INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 3302SELECT t1.c1,t5.c1 FROM t1 LEFT OUTER JOIN t5 ON t1.c1 = t5.c1 ORDER BY t1.c1,t5.c1; 3303c1 c1 33040 NULL 33051 NULL 33062 NULL 33073 NULL 33084 NULL 33095 NULL 33106 NULL 33117 NULL 33128 NULL 33139 NULL 3314SELECT t1.c1,t5.c1 FROM t1 LEFT OUTER JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 >= 5 ORDER BY t1.c1,t5.c1; 3315c1 c1 33165 NULL 33176 NULL 33187 NULL 33198 NULL 33209 NULL 3321DROP TABLE t1,t2,t3,t4,t5,t6; 3322CREATE TABLE t1 (c1 MEDIUMINT NOT NULL); 3323CREATE TABLE t2 (c1 MEDIUMINT NOT NULL); 3324CREATE TABLE t3 (c1 MEDIUMINT NOT NULL); 3325CREATE TABLE t4 (c1 MEDIUMINT NOT NULL); 3326CREATE TABLE t5 (c1 MEDIUMINT NOT NULL); 3327CREATE TABLE t6 (c1 MEDIUMINT NOT NULL); 3328INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3329INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3330INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 3331INSERT INTO t4 (c1) VALUES(10); 3332INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 3333SELECT t1.c1,t5.c1 FROM t1 LEFT OUTER JOIN t5 ON t1.c1 = t5.c1 ORDER BY t1.c1,t5.c1; 3334c1 c1 33350 NULL 33361 NULL 33372 NULL 33383 NULL 33394 NULL 33405 NULL 33416 NULL 33427 NULL 33438 NULL 33449 NULL 3345SELECT t1.c1,t5.c1 FROM t1 LEFT OUTER JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 >= 5 ORDER BY t1.c1,t5.c1; 3346c1 c1 33475 NULL 33486 NULL 33497 NULL 33508 NULL 33519 NULL 3352DROP TABLE t1,t2,t3,t4,t5,t6; 3353CREATE TABLE t1 (c1 INT NOT NULL); 3354CREATE TABLE t2 (c1 INT NOT NULL); 3355CREATE TABLE t3 (c1 INT NOT NULL); 3356CREATE TABLE t4 (c1 INT NOT NULL); 3357CREATE TABLE t5 (c1 INT NOT NULL); 3358CREATE TABLE t6 (c1 INT NOT NULL); 3359INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3360INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3361INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 3362INSERT INTO t4 (c1) VALUES(10); 3363INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 3364SELECT t1.c1,t5.c1 FROM t1 LEFT OUTER JOIN t5 ON t1.c1 = t5.c1 ORDER BY t1.c1,t5.c1; 3365c1 c1 33660 NULL 33671 NULL 33682 NULL 33693 NULL 33704 NULL 33715 NULL 33726 NULL 33737 NULL 33748 NULL 33759 NULL 3376SELECT t1.c1,t5.c1 FROM t1 LEFT OUTER JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 >= 5 ORDER BY t1.c1,t5.c1; 3377c1 c1 33785 NULL 33796 NULL 33807 NULL 33818 NULL 33829 NULL 3383DROP TABLE t1,t2,t3,t4,t5,t6; 3384CREATE TABLE t1 (c1 INTEGER NOT NULL); 3385CREATE TABLE t2 (c1 INTEGER NOT NULL); 3386CREATE TABLE t3 (c1 INTEGER NOT NULL); 3387CREATE TABLE t4 (c1 INTEGER NOT NULL); 3388CREATE TABLE t5 (c1 INTEGER NOT NULL); 3389CREATE TABLE t6 (c1 INTEGER NOT NULL); 3390INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3391INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3392INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 3393INSERT INTO t4 (c1) VALUES(10); 3394INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 3395SELECT t1.c1,t5.c1 FROM t1 LEFT OUTER JOIN t5 ON t1.c1 = t5.c1 ORDER BY t1.c1,t5.c1; 3396c1 c1 33970 NULL 33981 NULL 33992 NULL 34003 NULL 34014 NULL 34025 NULL 34036 NULL 34047 NULL 34058 NULL 34069 NULL 3407SELECT t1.c1,t5.c1 FROM t1 LEFT OUTER JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 >= 5 ORDER BY t1.c1,t5.c1; 3408c1 c1 34095 NULL 34106 NULL 34117 NULL 34128 NULL 34139 NULL 3414DROP TABLE t1,t2,t3,t4,t5,t6; 3415CREATE TABLE t1 (c1 BIGINT NOT NULL); 3416CREATE TABLE t2 (c1 BIGINT NOT NULL); 3417CREATE TABLE t3 (c1 BIGINT NOT NULL); 3418CREATE TABLE t4 (c1 BIGINT NOT NULL); 3419CREATE TABLE t5 (c1 BIGINT NOT NULL); 3420CREATE TABLE t6 (c1 BIGINT NOT NULL); 3421INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3422INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3423INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 3424INSERT INTO t4 (c1) VALUES(10); 3425INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 3426SELECT t1.c1,t5.c1 FROM t1 LEFT OUTER JOIN t5 ON t1.c1 = t5.c1 ORDER BY t1.c1,t5.c1; 3427c1 c1 34280 NULL 34291 NULL 34302 NULL 34313 NULL 34324 NULL 34335 NULL 34346 NULL 34357 NULL 34368 NULL 34379 NULL 3438SELECT t1.c1,t5.c1 FROM t1 LEFT OUTER JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 >= 5 ORDER BY t1.c1,t5.c1; 3439c1 c1 34405 NULL 34416 NULL 34427 NULL 34438 NULL 34449 NULL 3445DROP TABLE t1,t2,t3,t4,t5,t6; 3446CREATE TABLE t1 (c1 TINYINT NOT NULL); 3447CREATE TABLE t2 (c1 TINYINT NOT NULL); 3448CREATE TABLE t3 (c1 TINYINT NOT NULL); 3449CREATE TABLE t4 (c1 TINYINT NOT NULL); 3450CREATE TABLE t5 (c1 TINYINT NOT NULL); 3451CREATE TABLE t6 (c1 TINYINT NOT NULL); 3452INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3453INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3454INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 3455INSERT INTO t4 (c1) VALUES(10); 3456INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 3457SELECT t1.c1,t6.c1 FROM t1 LEFT OUTER JOIN t6 ON t1.c1 = t6.c1 ORDER BY t1.c1,t6.c1; 3458c1 c1 34590 NULL 34601 NULL 34612 NULL 34623 NULL 34634 NULL 34645 NULL 34656 NULL 34667 NULL 34678 NULL 34689 NULL 3469SELECT t1.c1,t6.c1 FROM t1 LEFT OUTER JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 >= 5 ORDER BY t1.c1,t6.c1; 3470c1 c1 34715 NULL 34726 NULL 34737 NULL 34748 NULL 34759 NULL 3476DROP TABLE t1,t2,t3,t4,t5,t6; 3477CREATE TABLE t1 (c1 SMALLINT NOT NULL); 3478CREATE TABLE t2 (c1 SMALLINT NOT NULL); 3479CREATE TABLE t3 (c1 SMALLINT NOT NULL); 3480CREATE TABLE t4 (c1 SMALLINT NOT NULL); 3481CREATE TABLE t5 (c1 SMALLINT NOT NULL); 3482CREATE TABLE t6 (c1 SMALLINT NOT NULL); 3483INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3484INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3485INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 3486INSERT INTO t4 (c1) VALUES(10); 3487INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 3488SELECT t1.c1,t6.c1 FROM t1 LEFT OUTER JOIN t6 ON t1.c1 = t6.c1 ORDER BY t1.c1,t6.c1; 3489c1 c1 34900 NULL 34911 NULL 34922 NULL 34933 NULL 34944 NULL 34955 NULL 34966 NULL 34977 NULL 34988 NULL 34999 NULL 3500SELECT t1.c1,t6.c1 FROM t1 LEFT OUTER JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 >= 5 ORDER BY t1.c1,t6.c1; 3501c1 c1 35025 NULL 35036 NULL 35047 NULL 35058 NULL 35069 NULL 3507DROP TABLE t1,t2,t3,t4,t5,t6; 3508CREATE TABLE t1 (c1 MEDIUMINT NOT NULL); 3509CREATE TABLE t2 (c1 MEDIUMINT NOT NULL); 3510CREATE TABLE t3 (c1 MEDIUMINT NOT NULL); 3511CREATE TABLE t4 (c1 MEDIUMINT NOT NULL); 3512CREATE TABLE t5 (c1 MEDIUMINT NOT NULL); 3513CREATE TABLE t6 (c1 MEDIUMINT NOT NULL); 3514INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3515INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3516INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 3517INSERT INTO t4 (c1) VALUES(10); 3518INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 3519SELECT t1.c1,t6.c1 FROM t1 LEFT OUTER JOIN t6 ON t1.c1 = t6.c1 ORDER BY t1.c1,t6.c1; 3520c1 c1 35210 NULL 35221 NULL 35232 NULL 35243 NULL 35254 NULL 35265 NULL 35276 NULL 35287 NULL 35298 NULL 35309 NULL 3531SELECT t1.c1,t6.c1 FROM t1 LEFT OUTER JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 >= 5 ORDER BY t1.c1,t6.c1; 3532c1 c1 35335 NULL 35346 NULL 35357 NULL 35368 NULL 35379 NULL 3538DROP TABLE t1,t2,t3,t4,t5,t6; 3539CREATE TABLE t1 (c1 INT NOT NULL); 3540CREATE TABLE t2 (c1 INT NOT NULL); 3541CREATE TABLE t3 (c1 INT NOT NULL); 3542CREATE TABLE t4 (c1 INT NOT NULL); 3543CREATE TABLE t5 (c1 INT NOT NULL); 3544CREATE TABLE t6 (c1 INT NOT NULL); 3545INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3546INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3547INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 3548INSERT INTO t4 (c1) VALUES(10); 3549INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 3550SELECT t1.c1,t6.c1 FROM t1 LEFT OUTER JOIN t6 ON t1.c1 = t6.c1 ORDER BY t1.c1,t6.c1; 3551c1 c1 35520 NULL 35531 NULL 35542 NULL 35553 NULL 35564 NULL 35575 NULL 35586 NULL 35597 NULL 35608 NULL 35619 NULL 3562SELECT t1.c1,t6.c1 FROM t1 LEFT OUTER JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 >= 5 ORDER BY t1.c1,t6.c1; 3563c1 c1 35645 NULL 35656 NULL 35667 NULL 35678 NULL 35689 NULL 3569DROP TABLE t1,t2,t3,t4,t5,t6; 3570CREATE TABLE t1 (c1 INTEGER NOT NULL); 3571CREATE TABLE t2 (c1 INTEGER NOT NULL); 3572CREATE TABLE t3 (c1 INTEGER NOT NULL); 3573CREATE TABLE t4 (c1 INTEGER NOT NULL); 3574CREATE TABLE t5 (c1 INTEGER NOT NULL); 3575CREATE TABLE t6 (c1 INTEGER NOT NULL); 3576INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3577INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3578INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 3579INSERT INTO t4 (c1) VALUES(10); 3580INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 3581SELECT t1.c1,t6.c1 FROM t1 LEFT OUTER JOIN t6 ON t1.c1 = t6.c1 ORDER BY t1.c1,t6.c1; 3582c1 c1 35830 NULL 35841 NULL 35852 NULL 35863 NULL 35874 NULL 35885 NULL 35896 NULL 35907 NULL 35918 NULL 35929 NULL 3593SELECT t1.c1,t6.c1 FROM t1 LEFT OUTER JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 >= 5 ORDER BY t1.c1,t6.c1; 3594c1 c1 35955 NULL 35966 NULL 35977 NULL 35988 NULL 35999 NULL 3600DROP TABLE t1,t2,t3,t4,t5,t6; 3601CREATE TABLE t1 (c1 BIGINT NOT NULL); 3602CREATE TABLE t2 (c1 BIGINT NOT NULL); 3603CREATE TABLE t3 (c1 BIGINT NOT NULL); 3604CREATE TABLE t4 (c1 BIGINT NOT NULL); 3605CREATE TABLE t5 (c1 BIGINT NOT NULL); 3606CREATE TABLE t6 (c1 BIGINT NOT NULL); 3607INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3608INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3609INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 3610INSERT INTO t4 (c1) VALUES(10); 3611INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 3612SELECT t1.c1,t6.c1 FROM t1 LEFT OUTER JOIN t6 ON t1.c1 = t6.c1 ORDER BY t1.c1,t6.c1; 3613c1 c1 36140 NULL 36151 NULL 36162 NULL 36173 NULL 36184 NULL 36195 NULL 36206 NULL 36217 NULL 36228 NULL 36239 NULL 3624SELECT t1.c1,t6.c1 FROM t1 LEFT OUTER JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 >= 5 ORDER BY t1.c1,t6.c1; 3625c1 c1 36265 NULL 36276 NULL 36287 NULL 36298 NULL 36309 NULL 3631DROP TABLE t1,t2,t3,t4,t5,t6; 3632CREATE TABLE t1 (c1 TINYINT NOT NULL); 3633CREATE TABLE t2 (c1 TINYINT NOT NULL); 3634CREATE TABLE t3 (c1 TINYINT NOT NULL); 3635CREATE TABLE t4 (c1 TINYINT NOT NULL); 3636CREATE TABLE t5 (c1 TINYINT NOT NULL); 3637CREATE TABLE t6 (c1 TINYINT NOT NULL); 3638INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3639INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3640INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 3641INSERT INTO t4 (c1) VALUES(10); 3642INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 3643SELECT t1.c1,t2.c1 FROM t1 LEFT OUTER JOIN t2 ON t1.c1 = t2.c1 ORDER BY t1.c1,t2.c1; 3644c1 c1 36450 0 36461 1 36472 2 36483 3 36494 4 36505 5 36516 6 36527 7 36538 8 36549 9 3655SELECT t1.c1,t2.c1 FROM t1 LEFT OUTER JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 != 5 ORDER BY t1.c1,t2.c1; 3656c1 c1 36570 0 36581 1 36592 2 36603 3 36614 4 36626 6 36637 7 36648 8 36659 9 3666DROP TABLE t1,t2,t3,t4,t5,t6; 3667CREATE TABLE t1 (c1 SMALLINT NOT NULL); 3668CREATE TABLE t2 (c1 SMALLINT NOT NULL); 3669CREATE TABLE t3 (c1 SMALLINT NOT NULL); 3670CREATE TABLE t4 (c1 SMALLINT NOT NULL); 3671CREATE TABLE t5 (c1 SMALLINT NOT NULL); 3672CREATE TABLE t6 (c1 SMALLINT NOT NULL); 3673INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3674INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3675INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 3676INSERT INTO t4 (c1) VALUES(10); 3677INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 3678SELECT t1.c1,t2.c1 FROM t1 LEFT OUTER JOIN t2 ON t1.c1 = t2.c1 ORDER BY t1.c1,t2.c1; 3679c1 c1 36800 0 36811 1 36822 2 36833 3 36844 4 36855 5 36866 6 36877 7 36888 8 36899 9 3690SELECT t1.c1,t2.c1 FROM t1 LEFT OUTER JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 != 5 ORDER BY t1.c1,t2.c1; 3691c1 c1 36920 0 36931 1 36942 2 36953 3 36964 4 36976 6 36987 7 36998 8 37009 9 3701DROP TABLE t1,t2,t3,t4,t5,t6; 3702CREATE TABLE t1 (c1 MEDIUMINT NOT NULL); 3703CREATE TABLE t2 (c1 MEDIUMINT NOT NULL); 3704CREATE TABLE t3 (c1 MEDIUMINT NOT NULL); 3705CREATE TABLE t4 (c1 MEDIUMINT NOT NULL); 3706CREATE TABLE t5 (c1 MEDIUMINT NOT NULL); 3707CREATE TABLE t6 (c1 MEDIUMINT NOT NULL); 3708INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3709INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3710INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 3711INSERT INTO t4 (c1) VALUES(10); 3712INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 3713SELECT t1.c1,t2.c1 FROM t1 LEFT OUTER JOIN t2 ON t1.c1 = t2.c1 ORDER BY t1.c1,t2.c1; 3714c1 c1 37150 0 37161 1 37172 2 37183 3 37194 4 37205 5 37216 6 37227 7 37238 8 37249 9 3725SELECT t1.c1,t2.c1 FROM t1 LEFT OUTER JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 != 5 ORDER BY t1.c1,t2.c1; 3726c1 c1 37270 0 37281 1 37292 2 37303 3 37314 4 37326 6 37337 7 37348 8 37359 9 3736DROP TABLE t1,t2,t3,t4,t5,t6; 3737CREATE TABLE t1 (c1 INT NOT NULL); 3738CREATE TABLE t2 (c1 INT NOT NULL); 3739CREATE TABLE t3 (c1 INT NOT NULL); 3740CREATE TABLE t4 (c1 INT NOT NULL); 3741CREATE TABLE t5 (c1 INT NOT NULL); 3742CREATE TABLE t6 (c1 INT NOT NULL); 3743INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3744INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3745INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 3746INSERT INTO t4 (c1) VALUES(10); 3747INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 3748SELECT t1.c1,t2.c1 FROM t1 LEFT OUTER JOIN t2 ON t1.c1 = t2.c1 ORDER BY t1.c1,t2.c1; 3749c1 c1 37500 0 37511 1 37522 2 37533 3 37544 4 37555 5 37566 6 37577 7 37588 8 37599 9 3760SELECT t1.c1,t2.c1 FROM t1 LEFT OUTER JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 != 5 ORDER BY t1.c1,t2.c1; 3761c1 c1 37620 0 37631 1 37642 2 37653 3 37664 4 37676 6 37687 7 37698 8 37709 9 3771DROP TABLE t1,t2,t3,t4,t5,t6; 3772CREATE TABLE t1 (c1 INTEGER NOT NULL); 3773CREATE TABLE t2 (c1 INTEGER NOT NULL); 3774CREATE TABLE t3 (c1 INTEGER NOT NULL); 3775CREATE TABLE t4 (c1 INTEGER NOT NULL); 3776CREATE TABLE t5 (c1 INTEGER NOT NULL); 3777CREATE TABLE t6 (c1 INTEGER NOT NULL); 3778INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3779INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3780INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 3781INSERT INTO t4 (c1) VALUES(10); 3782INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 3783SELECT t1.c1,t2.c1 FROM t1 LEFT OUTER JOIN t2 ON t1.c1 = t2.c1 ORDER BY t1.c1,t2.c1; 3784c1 c1 37850 0 37861 1 37872 2 37883 3 37894 4 37905 5 37916 6 37927 7 37938 8 37949 9 3795SELECT t1.c1,t2.c1 FROM t1 LEFT OUTER JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 != 5 ORDER BY t1.c1,t2.c1; 3796c1 c1 37970 0 37981 1 37992 2 38003 3 38014 4 38026 6 38037 7 38048 8 38059 9 3806DROP TABLE t1,t2,t3,t4,t5,t6; 3807CREATE TABLE t1 (c1 BIGINT NOT NULL); 3808CREATE TABLE t2 (c1 BIGINT NOT NULL); 3809CREATE TABLE t3 (c1 BIGINT NOT NULL); 3810CREATE TABLE t4 (c1 BIGINT NOT NULL); 3811CREATE TABLE t5 (c1 BIGINT NOT NULL); 3812CREATE TABLE t6 (c1 BIGINT NOT NULL); 3813INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3814INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3815INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 3816INSERT INTO t4 (c1) VALUES(10); 3817INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 3818SELECT t1.c1,t2.c1 FROM t1 LEFT OUTER JOIN t2 ON t1.c1 = t2.c1 ORDER BY t1.c1,t2.c1; 3819c1 c1 38200 0 38211 1 38222 2 38233 3 38244 4 38255 5 38266 6 38277 7 38288 8 38299 9 3830SELECT t1.c1,t2.c1 FROM t1 LEFT OUTER JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 != 5 ORDER BY t1.c1,t2.c1; 3831c1 c1 38320 0 38331 1 38342 2 38353 3 38364 4 38376 6 38387 7 38398 8 38409 9 3841DROP TABLE t1,t2,t3,t4,t5,t6; 3842CREATE TABLE t1 (c1 TINYINT NOT NULL); 3843CREATE TABLE t2 (c1 TINYINT NOT NULL); 3844CREATE TABLE t3 (c1 TINYINT NOT NULL); 3845CREATE TABLE t4 (c1 TINYINT NOT NULL); 3846CREATE TABLE t5 (c1 TINYINT NOT NULL); 3847CREATE TABLE t6 (c1 TINYINT NOT NULL); 3848INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3849INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3850INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 3851INSERT INTO t4 (c1) VALUES(10); 3852INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 3853SELECT t1.c1,t3.c1 FROM t1 LEFT OUTER JOIN t3 ON t1.c1 = t3.c1 ORDER BY t1.c1,t3.c1; 3854c1 c1 38550 NULL 38561 1 38572 NULL 38583 3 38594 NULL 38605 5 38616 NULL 38627 7 38638 NULL 38649 9 3865SELECT t1.c1,t3.c1 FROM t1 LEFT OUTER JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 != 5 ORDER BY t1.c1,t3.c1; 3866c1 c1 38670 NULL 38681 1 38692 NULL 38703 3 38714 NULL 38726 NULL 38737 7 38748 NULL 38759 9 3876DROP TABLE t1,t2,t3,t4,t5,t6; 3877CREATE TABLE t1 (c1 SMALLINT NOT NULL); 3878CREATE TABLE t2 (c1 SMALLINT NOT NULL); 3879CREATE TABLE t3 (c1 SMALLINT NOT NULL); 3880CREATE TABLE t4 (c1 SMALLINT NOT NULL); 3881CREATE TABLE t5 (c1 SMALLINT NOT NULL); 3882CREATE TABLE t6 (c1 SMALLINT NOT NULL); 3883INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3884INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3885INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 3886INSERT INTO t4 (c1) VALUES(10); 3887INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 3888SELECT t1.c1,t3.c1 FROM t1 LEFT OUTER JOIN t3 ON t1.c1 = t3.c1 ORDER BY t1.c1,t3.c1; 3889c1 c1 38900 NULL 38911 1 38922 NULL 38933 3 38944 NULL 38955 5 38966 NULL 38977 7 38988 NULL 38999 9 3900SELECT t1.c1,t3.c1 FROM t1 LEFT OUTER JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 != 5 ORDER BY t1.c1,t3.c1; 3901c1 c1 39020 NULL 39031 1 39042 NULL 39053 3 39064 NULL 39076 NULL 39087 7 39098 NULL 39109 9 3911DROP TABLE t1,t2,t3,t4,t5,t6; 3912CREATE TABLE t1 (c1 MEDIUMINT NOT NULL); 3913CREATE TABLE t2 (c1 MEDIUMINT NOT NULL); 3914CREATE TABLE t3 (c1 MEDIUMINT NOT NULL); 3915CREATE TABLE t4 (c1 MEDIUMINT NOT NULL); 3916CREATE TABLE t5 (c1 MEDIUMINT NOT NULL); 3917CREATE TABLE t6 (c1 MEDIUMINT NOT NULL); 3918INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3919INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3920INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 3921INSERT INTO t4 (c1) VALUES(10); 3922INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 3923SELECT t1.c1,t3.c1 FROM t1 LEFT OUTER JOIN t3 ON t1.c1 = t3.c1 ORDER BY t1.c1,t3.c1; 3924c1 c1 39250 NULL 39261 1 39272 NULL 39283 3 39294 NULL 39305 5 39316 NULL 39327 7 39338 NULL 39349 9 3935SELECT t1.c1,t3.c1 FROM t1 LEFT OUTER JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 != 5 ORDER BY t1.c1,t3.c1; 3936c1 c1 39370 NULL 39381 1 39392 NULL 39403 3 39414 NULL 39426 NULL 39437 7 39448 NULL 39459 9 3946DROP TABLE t1,t2,t3,t4,t5,t6; 3947CREATE TABLE t1 (c1 INT NOT NULL); 3948CREATE TABLE t2 (c1 INT NOT NULL); 3949CREATE TABLE t3 (c1 INT NOT NULL); 3950CREATE TABLE t4 (c1 INT NOT NULL); 3951CREATE TABLE t5 (c1 INT NOT NULL); 3952CREATE TABLE t6 (c1 INT NOT NULL); 3953INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3954INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3955INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 3956INSERT INTO t4 (c1) VALUES(10); 3957INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 3958SELECT t1.c1,t3.c1 FROM t1 LEFT OUTER JOIN t3 ON t1.c1 = t3.c1 ORDER BY t1.c1,t3.c1; 3959c1 c1 39600 NULL 39611 1 39622 NULL 39633 3 39644 NULL 39655 5 39666 NULL 39677 7 39688 NULL 39699 9 3970SELECT t1.c1,t3.c1 FROM t1 LEFT OUTER JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 != 5 ORDER BY t1.c1,t3.c1; 3971c1 c1 39720 NULL 39731 1 39742 NULL 39753 3 39764 NULL 39776 NULL 39787 7 39798 NULL 39809 9 3981DROP TABLE t1,t2,t3,t4,t5,t6; 3982CREATE TABLE t1 (c1 INTEGER NOT NULL); 3983CREATE TABLE t2 (c1 INTEGER NOT NULL); 3984CREATE TABLE t3 (c1 INTEGER NOT NULL); 3985CREATE TABLE t4 (c1 INTEGER NOT NULL); 3986CREATE TABLE t5 (c1 INTEGER NOT NULL); 3987CREATE TABLE t6 (c1 INTEGER NOT NULL); 3988INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3989INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3990INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 3991INSERT INTO t4 (c1) VALUES(10); 3992INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 3993SELECT t1.c1,t3.c1 FROM t1 LEFT OUTER JOIN t3 ON t1.c1 = t3.c1 ORDER BY t1.c1,t3.c1; 3994c1 c1 39950 NULL 39961 1 39972 NULL 39983 3 39994 NULL 40005 5 40016 NULL 40027 7 40038 NULL 40049 9 4005SELECT t1.c1,t3.c1 FROM t1 LEFT OUTER JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 != 5 ORDER BY t1.c1,t3.c1; 4006c1 c1 40070 NULL 40081 1 40092 NULL 40103 3 40114 NULL 40126 NULL 40137 7 40148 NULL 40159 9 4016DROP TABLE t1,t2,t3,t4,t5,t6; 4017CREATE TABLE t1 (c1 BIGINT NOT NULL); 4018CREATE TABLE t2 (c1 BIGINT NOT NULL); 4019CREATE TABLE t3 (c1 BIGINT NOT NULL); 4020CREATE TABLE t4 (c1 BIGINT NOT NULL); 4021CREATE TABLE t5 (c1 BIGINT NOT NULL); 4022CREATE TABLE t6 (c1 BIGINT NOT NULL); 4023INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 4024INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 4025INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 4026INSERT INTO t4 (c1) VALUES(10); 4027INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 4028SELECT t1.c1,t3.c1 FROM t1 LEFT OUTER JOIN t3 ON t1.c1 = t3.c1 ORDER BY t1.c1,t3.c1; 4029c1 c1 40300 NULL 40311 1 40322 NULL 40333 3 40344 NULL 40355 5 40366 NULL 40377 7 40388 NULL 40399 9 4040SELECT t1.c1,t3.c1 FROM t1 LEFT OUTER JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 != 5 ORDER BY t1.c1,t3.c1; 4041c1 c1 40420 NULL 40431 1 40442 NULL 40453 3 40464 NULL 40476 NULL 40487 7 40498 NULL 40509 9 4051DROP TABLE t1,t2,t3,t4,t5,t6; 4052CREATE TABLE t1 (c1 TINYINT NOT NULL); 4053CREATE TABLE t2 (c1 TINYINT NOT NULL); 4054CREATE TABLE t3 (c1 TINYINT NOT NULL); 4055CREATE TABLE t4 (c1 TINYINT NOT NULL); 4056CREATE TABLE t5 (c1 TINYINT NOT NULL); 4057CREATE TABLE t6 (c1 TINYINT NOT NULL); 4058INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 4059INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 4060INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 4061INSERT INTO t4 (c1) VALUES(10); 4062INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 4063SELECT t1.c1,t4.c1 FROM t1 LEFT OUTER JOIN t4 ON t1.c1 = t4.c1 ORDER BY t1.c1,t4.c1; 4064c1 c1 40650 NULL 40661 NULL 40672 NULL 40683 NULL 40694 NULL 40705 NULL 40716 NULL 40727 NULL 40738 NULL 40749 NULL 4075SELECT t1.c1,t4.c1 FROM t1 LEFT OUTER JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 != 5 ORDER BY t1.c1,t4.c1; 4076c1 c1 40770 NULL 40781 NULL 40792 NULL 40803 NULL 40814 NULL 40826 NULL 40837 NULL 40848 NULL 40859 NULL 4086DROP TABLE t1,t2,t3,t4,t5,t6; 4087CREATE TABLE t1 (c1 SMALLINT NOT NULL); 4088CREATE TABLE t2 (c1 SMALLINT NOT NULL); 4089CREATE TABLE t3 (c1 SMALLINT NOT NULL); 4090CREATE TABLE t4 (c1 SMALLINT NOT NULL); 4091CREATE TABLE t5 (c1 SMALLINT NOT NULL); 4092CREATE TABLE t6 (c1 SMALLINT NOT NULL); 4093INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 4094INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 4095INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 4096INSERT INTO t4 (c1) VALUES(10); 4097INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 4098SELECT t1.c1,t4.c1 FROM t1 LEFT OUTER JOIN t4 ON t1.c1 = t4.c1 ORDER BY t1.c1,t4.c1; 4099c1 c1 41000 NULL 41011 NULL 41022 NULL 41033 NULL 41044 NULL 41055 NULL 41066 NULL 41077 NULL 41088 NULL 41099 NULL 4110SELECT t1.c1,t4.c1 FROM t1 LEFT OUTER JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 != 5 ORDER BY t1.c1,t4.c1; 4111c1 c1 41120 NULL 41131 NULL 41142 NULL 41153 NULL 41164 NULL 41176 NULL 41187 NULL 41198 NULL 41209 NULL 4121DROP TABLE t1,t2,t3,t4,t5,t6; 4122CREATE TABLE t1 (c1 MEDIUMINT NOT NULL); 4123CREATE TABLE t2 (c1 MEDIUMINT NOT NULL); 4124CREATE TABLE t3 (c1 MEDIUMINT NOT NULL); 4125CREATE TABLE t4 (c1 MEDIUMINT NOT NULL); 4126CREATE TABLE t5 (c1 MEDIUMINT NOT NULL); 4127CREATE TABLE t6 (c1 MEDIUMINT NOT NULL); 4128INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 4129INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 4130INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 4131INSERT INTO t4 (c1) VALUES(10); 4132INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 4133SELECT t1.c1,t4.c1 FROM t1 LEFT OUTER JOIN t4 ON t1.c1 = t4.c1 ORDER BY t1.c1,t4.c1; 4134c1 c1 41350 NULL 41361 NULL 41372 NULL 41383 NULL 41394 NULL 41405 NULL 41416 NULL 41427 NULL 41438 NULL 41449 NULL 4145SELECT t1.c1,t4.c1 FROM t1 LEFT OUTER JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 != 5 ORDER BY t1.c1,t4.c1; 4146c1 c1 41470 NULL 41481 NULL 41492 NULL 41503 NULL 41514 NULL 41526 NULL 41537 NULL 41548 NULL 41559 NULL 4156DROP TABLE t1,t2,t3,t4,t5,t6; 4157CREATE TABLE t1 (c1 INT NOT NULL); 4158CREATE TABLE t2 (c1 INT NOT NULL); 4159CREATE TABLE t3 (c1 INT NOT NULL); 4160CREATE TABLE t4 (c1 INT NOT NULL); 4161CREATE TABLE t5 (c1 INT NOT NULL); 4162CREATE TABLE t6 (c1 INT NOT NULL); 4163INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 4164INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 4165INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 4166INSERT INTO t4 (c1) VALUES(10); 4167INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 4168SELECT t1.c1,t4.c1 FROM t1 LEFT OUTER JOIN t4 ON t1.c1 = t4.c1 ORDER BY t1.c1,t4.c1; 4169c1 c1 41700 NULL 41711 NULL 41722 NULL 41733 NULL 41744 NULL 41755 NULL 41766 NULL 41777 NULL 41788 NULL 41799 NULL 4180SELECT t1.c1,t4.c1 FROM t1 LEFT OUTER JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 != 5 ORDER BY t1.c1,t4.c1; 4181c1 c1 41820 NULL 41831 NULL 41842 NULL 41853 NULL 41864 NULL 41876 NULL 41887 NULL 41898 NULL 41909 NULL 4191DROP TABLE t1,t2,t3,t4,t5,t6; 4192CREATE TABLE t1 (c1 INTEGER NOT NULL); 4193CREATE TABLE t2 (c1 INTEGER NOT NULL); 4194CREATE TABLE t3 (c1 INTEGER NOT NULL); 4195CREATE TABLE t4 (c1 INTEGER NOT NULL); 4196CREATE TABLE t5 (c1 INTEGER NOT NULL); 4197CREATE TABLE t6 (c1 INTEGER NOT NULL); 4198INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 4199INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 4200INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 4201INSERT INTO t4 (c1) VALUES(10); 4202INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 4203SELECT t1.c1,t4.c1 FROM t1 LEFT OUTER JOIN t4 ON t1.c1 = t4.c1 ORDER BY t1.c1,t4.c1; 4204c1 c1 42050 NULL 42061 NULL 42072 NULL 42083 NULL 42094 NULL 42105 NULL 42116 NULL 42127 NULL 42138 NULL 42149 NULL 4215SELECT t1.c1,t4.c1 FROM t1 LEFT OUTER JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 != 5 ORDER BY t1.c1,t4.c1; 4216c1 c1 42170 NULL 42181 NULL 42192 NULL 42203 NULL 42214 NULL 42226 NULL 42237 NULL 42248 NULL 42259 NULL 4226DROP TABLE t1,t2,t3,t4,t5,t6; 4227CREATE TABLE t1 (c1 BIGINT NOT NULL); 4228CREATE TABLE t2 (c1 BIGINT NOT NULL); 4229CREATE TABLE t3 (c1 BIGINT NOT NULL); 4230CREATE TABLE t4 (c1 BIGINT NOT NULL); 4231CREATE TABLE t5 (c1 BIGINT NOT NULL); 4232CREATE TABLE t6 (c1 BIGINT NOT NULL); 4233INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 4234INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 4235INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 4236INSERT INTO t4 (c1) VALUES(10); 4237INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 4238SELECT t1.c1,t4.c1 FROM t1 LEFT OUTER JOIN t4 ON t1.c1 = t4.c1 ORDER BY t1.c1,t4.c1; 4239c1 c1 42400 NULL 42411 NULL 42422 NULL 42433 NULL 42444 NULL 42455 NULL 42466 NULL 42477 NULL 42488 NULL 42499 NULL 4250SELECT t1.c1,t4.c1 FROM t1 LEFT OUTER JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 != 5 ORDER BY t1.c1,t4.c1; 4251c1 c1 42520 NULL 42531 NULL 42542 NULL 42553 NULL 42564 NULL 42576 NULL 42587 NULL 42598 NULL 42609 NULL 4261DROP TABLE t1,t2,t3,t4,t5,t6; 4262CREATE TABLE t1 (c1 TINYINT NOT NULL); 4263CREATE TABLE t2 (c1 TINYINT NOT NULL); 4264CREATE TABLE t3 (c1 TINYINT NOT NULL); 4265CREATE TABLE t4 (c1 TINYINT NOT NULL); 4266CREATE TABLE t5 (c1 TINYINT NOT NULL); 4267CREATE TABLE t6 (c1 TINYINT NOT NULL); 4268INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 4269INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 4270INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 4271INSERT INTO t4 (c1) VALUES(10); 4272INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 4273SELECT t1.c1,t5.c1 FROM t1 LEFT OUTER JOIN t5 ON t1.c1 = t5.c1 ORDER BY t1.c1,t5.c1; 4274c1 c1 42750 NULL 42761 NULL 42772 NULL 42783 NULL 42794 NULL 42805 NULL 42816 NULL 42827 NULL 42838 NULL 42849 NULL 4285SELECT t1.c1,t5.c1 FROM t1 LEFT OUTER JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 != 5 ORDER BY t1.c1,t5.c1; 4286c1 c1 42870 NULL 42881 NULL 42892 NULL 42903 NULL 42914 NULL 42926 NULL 42937 NULL 42948 NULL 42959 NULL 4296DROP TABLE t1,t2,t3,t4,t5,t6; 4297CREATE TABLE t1 (c1 SMALLINT NOT NULL); 4298CREATE TABLE t2 (c1 SMALLINT NOT NULL); 4299CREATE TABLE t3 (c1 SMALLINT NOT NULL); 4300CREATE TABLE t4 (c1 SMALLINT NOT NULL); 4301CREATE TABLE t5 (c1 SMALLINT NOT NULL); 4302CREATE TABLE t6 (c1 SMALLINT NOT NULL); 4303INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 4304INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 4305INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 4306INSERT INTO t4 (c1) VALUES(10); 4307INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 4308SELECT t1.c1,t5.c1 FROM t1 LEFT OUTER JOIN t5 ON t1.c1 = t5.c1 ORDER BY t1.c1,t5.c1; 4309c1 c1 43100 NULL 43111 NULL 43122 NULL 43133 NULL 43144 NULL 43155 NULL 43166 NULL 43177 NULL 43188 NULL 43199 NULL 4320SELECT t1.c1,t5.c1 FROM t1 LEFT OUTER JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 != 5 ORDER BY t1.c1,t5.c1; 4321c1 c1 43220 NULL 43231 NULL 43242 NULL 43253 NULL 43264 NULL 43276 NULL 43287 NULL 43298 NULL 43309 NULL 4331DROP TABLE t1,t2,t3,t4,t5,t6; 4332CREATE TABLE t1 (c1 MEDIUMINT NOT NULL); 4333CREATE TABLE t2 (c1 MEDIUMINT NOT NULL); 4334CREATE TABLE t3 (c1 MEDIUMINT NOT NULL); 4335CREATE TABLE t4 (c1 MEDIUMINT NOT NULL); 4336CREATE TABLE t5 (c1 MEDIUMINT NOT NULL); 4337CREATE TABLE t6 (c1 MEDIUMINT NOT NULL); 4338INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 4339INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 4340INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 4341INSERT INTO t4 (c1) VALUES(10); 4342INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 4343SELECT t1.c1,t5.c1 FROM t1 LEFT OUTER JOIN t5 ON t1.c1 = t5.c1 ORDER BY t1.c1,t5.c1; 4344c1 c1 43450 NULL 43461 NULL 43472 NULL 43483 NULL 43494 NULL 43505 NULL 43516 NULL 43527 NULL 43538 NULL 43549 NULL 4355SELECT t1.c1,t5.c1 FROM t1 LEFT OUTER JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 != 5 ORDER BY t1.c1,t5.c1; 4356c1 c1 43570 NULL 43581 NULL 43592 NULL 43603 NULL 43614 NULL 43626 NULL 43637 NULL 43648 NULL 43659 NULL 4366DROP TABLE t1,t2,t3,t4,t5,t6; 4367CREATE TABLE t1 (c1 INT NOT NULL); 4368CREATE TABLE t2 (c1 INT NOT NULL); 4369CREATE TABLE t3 (c1 INT NOT NULL); 4370CREATE TABLE t4 (c1 INT NOT NULL); 4371CREATE TABLE t5 (c1 INT NOT NULL); 4372CREATE TABLE t6 (c1 INT NOT NULL); 4373INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 4374INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 4375INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 4376INSERT INTO t4 (c1) VALUES(10); 4377INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 4378SELECT t1.c1,t5.c1 FROM t1 LEFT OUTER JOIN t5 ON t1.c1 = t5.c1 ORDER BY t1.c1,t5.c1; 4379c1 c1 43800 NULL 43811 NULL 43822 NULL 43833 NULL 43844 NULL 43855 NULL 43866 NULL 43877 NULL 43888 NULL 43899 NULL 4390SELECT t1.c1,t5.c1 FROM t1 LEFT OUTER JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 != 5 ORDER BY t1.c1,t5.c1; 4391c1 c1 43920 NULL 43931 NULL 43942 NULL 43953 NULL 43964 NULL 43976 NULL 43987 NULL 43998 NULL 44009 NULL 4401DROP TABLE t1,t2,t3,t4,t5,t6; 4402CREATE TABLE t1 (c1 INTEGER NOT NULL); 4403CREATE TABLE t2 (c1 INTEGER NOT NULL); 4404CREATE TABLE t3 (c1 INTEGER NOT NULL); 4405CREATE TABLE t4 (c1 INTEGER NOT NULL); 4406CREATE TABLE t5 (c1 INTEGER NOT NULL); 4407CREATE TABLE t6 (c1 INTEGER NOT NULL); 4408INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 4409INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 4410INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 4411INSERT INTO t4 (c1) VALUES(10); 4412INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 4413SELECT t1.c1,t5.c1 FROM t1 LEFT OUTER JOIN t5 ON t1.c1 = t5.c1 ORDER BY t1.c1,t5.c1; 4414c1 c1 44150 NULL 44161 NULL 44172 NULL 44183 NULL 44194 NULL 44205 NULL 44216 NULL 44227 NULL 44238 NULL 44249 NULL 4425SELECT t1.c1,t5.c1 FROM t1 LEFT OUTER JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 != 5 ORDER BY t1.c1,t5.c1; 4426c1 c1 44270 NULL 44281 NULL 44292 NULL 44303 NULL 44314 NULL 44326 NULL 44337 NULL 44348 NULL 44359 NULL 4436DROP TABLE t1,t2,t3,t4,t5,t6; 4437CREATE TABLE t1 (c1 BIGINT NOT NULL); 4438CREATE TABLE t2 (c1 BIGINT NOT NULL); 4439CREATE TABLE t3 (c1 BIGINT NOT NULL); 4440CREATE TABLE t4 (c1 BIGINT NOT NULL); 4441CREATE TABLE t5 (c1 BIGINT NOT NULL); 4442CREATE TABLE t6 (c1 BIGINT NOT NULL); 4443INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 4444INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 4445INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 4446INSERT INTO t4 (c1) VALUES(10); 4447INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 4448SELECT t1.c1,t5.c1 FROM t1 LEFT OUTER JOIN t5 ON t1.c1 = t5.c1 ORDER BY t1.c1,t5.c1; 4449c1 c1 44500 NULL 44511 NULL 44522 NULL 44533 NULL 44544 NULL 44555 NULL 44566 NULL 44577 NULL 44588 NULL 44599 NULL 4460SELECT t1.c1,t5.c1 FROM t1 LEFT OUTER JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 != 5 ORDER BY t1.c1,t5.c1; 4461c1 c1 44620 NULL 44631 NULL 44642 NULL 44653 NULL 44664 NULL 44676 NULL 44687 NULL 44698 NULL 44709 NULL 4471DROP TABLE t1,t2,t3,t4,t5,t6; 4472CREATE TABLE t1 (c1 TINYINT NOT NULL); 4473CREATE TABLE t2 (c1 TINYINT NOT NULL); 4474CREATE TABLE t3 (c1 TINYINT NOT NULL); 4475CREATE TABLE t4 (c1 TINYINT NOT NULL); 4476CREATE TABLE t5 (c1 TINYINT NOT NULL); 4477CREATE TABLE t6 (c1 TINYINT NOT NULL); 4478INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 4479INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 4480INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 4481INSERT INTO t4 (c1) VALUES(10); 4482INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 4483SELECT t1.c1,t6.c1 FROM t1 LEFT OUTER JOIN t6 ON t1.c1 = t6.c1 ORDER BY t1.c1,t6.c1; 4484c1 c1 44850 NULL 44861 NULL 44872 NULL 44883 NULL 44894 NULL 44905 NULL 44916 NULL 44927 NULL 44938 NULL 44949 NULL 4495SELECT t1.c1,t6.c1 FROM t1 LEFT OUTER JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 != 5 ORDER BY t1.c1,t6.c1; 4496c1 c1 44970 NULL 44981 NULL 44992 NULL 45003 NULL 45014 NULL 45026 NULL 45037 NULL 45048 NULL 45059 NULL 4506DROP TABLE t1,t2,t3,t4,t5,t6; 4507CREATE TABLE t1 (c1 SMALLINT NOT NULL); 4508CREATE TABLE t2 (c1 SMALLINT NOT NULL); 4509CREATE TABLE t3 (c1 SMALLINT NOT NULL); 4510CREATE TABLE t4 (c1 SMALLINT NOT NULL); 4511CREATE TABLE t5 (c1 SMALLINT NOT NULL); 4512CREATE TABLE t6 (c1 SMALLINT NOT NULL); 4513INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 4514INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 4515INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 4516INSERT INTO t4 (c1) VALUES(10); 4517INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 4518SELECT t1.c1,t6.c1 FROM t1 LEFT OUTER JOIN t6 ON t1.c1 = t6.c1 ORDER BY t1.c1,t6.c1; 4519c1 c1 45200 NULL 45211 NULL 45222 NULL 45233 NULL 45244 NULL 45255 NULL 45266 NULL 45277 NULL 45288 NULL 45299 NULL 4530SELECT t1.c1,t6.c1 FROM t1 LEFT OUTER JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 != 5 ORDER BY t1.c1,t6.c1; 4531c1 c1 45320 NULL 45331 NULL 45342 NULL 45353 NULL 45364 NULL 45376 NULL 45387 NULL 45398 NULL 45409 NULL 4541DROP TABLE t1,t2,t3,t4,t5,t6; 4542CREATE TABLE t1 (c1 MEDIUMINT NOT NULL); 4543CREATE TABLE t2 (c1 MEDIUMINT NOT NULL); 4544CREATE TABLE t3 (c1 MEDIUMINT NOT NULL); 4545CREATE TABLE t4 (c1 MEDIUMINT NOT NULL); 4546CREATE TABLE t5 (c1 MEDIUMINT NOT NULL); 4547CREATE TABLE t6 (c1 MEDIUMINT NOT NULL); 4548INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 4549INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 4550INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 4551INSERT INTO t4 (c1) VALUES(10); 4552INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 4553SELECT t1.c1,t6.c1 FROM t1 LEFT OUTER JOIN t6 ON t1.c1 = t6.c1 ORDER BY t1.c1,t6.c1; 4554c1 c1 45550 NULL 45561 NULL 45572 NULL 45583 NULL 45594 NULL 45605 NULL 45616 NULL 45627 NULL 45638 NULL 45649 NULL 4565SELECT t1.c1,t6.c1 FROM t1 LEFT OUTER JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 != 5 ORDER BY t1.c1,t6.c1; 4566c1 c1 45670 NULL 45681 NULL 45692 NULL 45703 NULL 45714 NULL 45726 NULL 45737 NULL 45748 NULL 45759 NULL 4576DROP TABLE t1,t2,t3,t4,t5,t6; 4577CREATE TABLE t1 (c1 INT NOT NULL); 4578CREATE TABLE t2 (c1 INT NOT NULL); 4579CREATE TABLE t3 (c1 INT NOT NULL); 4580CREATE TABLE t4 (c1 INT NOT NULL); 4581CREATE TABLE t5 (c1 INT NOT NULL); 4582CREATE TABLE t6 (c1 INT NOT NULL); 4583INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 4584INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 4585INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 4586INSERT INTO t4 (c1) VALUES(10); 4587INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 4588SELECT t1.c1,t6.c1 FROM t1 LEFT OUTER JOIN t6 ON t1.c1 = t6.c1 ORDER BY t1.c1,t6.c1; 4589c1 c1 45900 NULL 45911 NULL 45922 NULL 45933 NULL 45944 NULL 45955 NULL 45966 NULL 45977 NULL 45988 NULL 45999 NULL 4600SELECT t1.c1,t6.c1 FROM t1 LEFT OUTER JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 != 5 ORDER BY t1.c1,t6.c1; 4601c1 c1 46020 NULL 46031 NULL 46042 NULL 46053 NULL 46064 NULL 46076 NULL 46087 NULL 46098 NULL 46109 NULL 4611DROP TABLE t1,t2,t3,t4,t5,t6; 4612CREATE TABLE t1 (c1 INTEGER NOT NULL); 4613CREATE TABLE t2 (c1 INTEGER NOT NULL); 4614CREATE TABLE t3 (c1 INTEGER NOT NULL); 4615CREATE TABLE t4 (c1 INTEGER NOT NULL); 4616CREATE TABLE t5 (c1 INTEGER NOT NULL); 4617CREATE TABLE t6 (c1 INTEGER NOT NULL); 4618INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 4619INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 4620INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 4621INSERT INTO t4 (c1) VALUES(10); 4622INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 4623SELECT t1.c1,t6.c1 FROM t1 LEFT OUTER JOIN t6 ON t1.c1 = t6.c1 ORDER BY t1.c1,t6.c1; 4624c1 c1 46250 NULL 46261 NULL 46272 NULL 46283 NULL 46294 NULL 46305 NULL 46316 NULL 46327 NULL 46338 NULL 46349 NULL 4635SELECT t1.c1,t6.c1 FROM t1 LEFT OUTER JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 != 5 ORDER BY t1.c1,t6.c1; 4636c1 c1 46370 NULL 46381 NULL 46392 NULL 46403 NULL 46414 NULL 46426 NULL 46437 NULL 46448 NULL 46459 NULL 4646DROP TABLE t1,t2,t3,t4,t5,t6; 4647CREATE TABLE t1 (c1 BIGINT NOT NULL); 4648CREATE TABLE t2 (c1 BIGINT NOT NULL); 4649CREATE TABLE t3 (c1 BIGINT NOT NULL); 4650CREATE TABLE t4 (c1 BIGINT NOT NULL); 4651CREATE TABLE t5 (c1 BIGINT NOT NULL); 4652CREATE TABLE t6 (c1 BIGINT NOT NULL); 4653INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 4654INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 4655INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 4656INSERT INTO t4 (c1) VALUES(10); 4657INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 4658SELECT t1.c1,t6.c1 FROM t1 LEFT OUTER JOIN t6 ON t1.c1 = t6.c1 ORDER BY t1.c1,t6.c1; 4659c1 c1 46600 NULL 46611 NULL 46622 NULL 46633 NULL 46644 NULL 46655 NULL 46666 NULL 46677 NULL 46688 NULL 46699 NULL 4670SELECT t1.c1,t6.c1 FROM t1 LEFT OUTER JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 != 5 ORDER BY t1.c1,t6.c1; 4671c1 c1 46720 NULL 46731 NULL 46742 NULL 46753 NULL 46764 NULL 46776 NULL 46787 NULL 46798 NULL 46809 NULL 4681DROP TABLE t1,t2,t3,t4,t5,t6; 4682CREATE TABLE t1 (c1 TINYINT NOT NULL); 4683CREATE TABLE t2 (c1 TINYINT NOT NULL); 4684CREATE TABLE t3 (c1 TINYINT NOT NULL); 4685CREATE TABLE t4 (c1 TINYINT NOT NULL); 4686CREATE TABLE t5 (c1 TINYINT NOT NULL); 4687CREATE TABLE t6 (c1 TINYINT NOT NULL); 4688INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 4689INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 4690INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 4691INSERT INTO t4 (c1) VALUES(10); 4692INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 4693SELECT t1.c1,t2.c1 FROM t1 LEFT OUTER JOIN t2 ON t1.c1 = t2.c1 ORDER BY t1.c1,t2.c1; 4694c1 c1 46950 0 46961 1 46972 2 46983 3 46994 4 47005 5 47016 6 47027 7 47038 8 47049 9 4705SELECT t1.c1,t2.c1 FROM t1 LEFT OUTER JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 <> 5 ORDER BY t1.c1,t2.c1; 4706c1 c1 47070 0 47081 1 47092 2 47103 3 47114 4 47126 6 47137 7 47148 8 47159 9 4716DROP TABLE t1,t2,t3,t4,t5,t6; 4717CREATE TABLE t1 (c1 SMALLINT NOT NULL); 4718CREATE TABLE t2 (c1 SMALLINT NOT NULL); 4719CREATE TABLE t3 (c1 SMALLINT NOT NULL); 4720CREATE TABLE t4 (c1 SMALLINT NOT NULL); 4721CREATE TABLE t5 (c1 SMALLINT NOT NULL); 4722CREATE TABLE t6 (c1 SMALLINT NOT NULL); 4723INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 4724INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 4725INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 4726INSERT INTO t4 (c1) VALUES(10); 4727INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 4728SELECT t1.c1,t2.c1 FROM t1 LEFT OUTER JOIN t2 ON t1.c1 = t2.c1 ORDER BY t1.c1,t2.c1; 4729c1 c1 47300 0 47311 1 47322 2 47333 3 47344 4 47355 5 47366 6 47377 7 47388 8 47399 9 4740SELECT t1.c1,t2.c1 FROM t1 LEFT OUTER JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 <> 5 ORDER BY t1.c1,t2.c1; 4741c1 c1 47420 0 47431 1 47442 2 47453 3 47464 4 47476 6 47487 7 47498 8 47509 9 4751DROP TABLE t1,t2,t3,t4,t5,t6; 4752CREATE TABLE t1 (c1 MEDIUMINT NOT NULL); 4753CREATE TABLE t2 (c1 MEDIUMINT NOT NULL); 4754CREATE TABLE t3 (c1 MEDIUMINT NOT NULL); 4755CREATE TABLE t4 (c1 MEDIUMINT NOT NULL); 4756CREATE TABLE t5 (c1 MEDIUMINT NOT NULL); 4757CREATE TABLE t6 (c1 MEDIUMINT NOT NULL); 4758INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 4759INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 4760INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 4761INSERT INTO t4 (c1) VALUES(10); 4762INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 4763SELECT t1.c1,t2.c1 FROM t1 LEFT OUTER JOIN t2 ON t1.c1 = t2.c1 ORDER BY t1.c1,t2.c1; 4764c1 c1 47650 0 47661 1 47672 2 47683 3 47694 4 47705 5 47716 6 47727 7 47738 8 47749 9 4775SELECT t1.c1,t2.c1 FROM t1 LEFT OUTER JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 <> 5 ORDER BY t1.c1,t2.c1; 4776c1 c1 47770 0 47781 1 47792 2 47803 3 47814 4 47826 6 47837 7 47848 8 47859 9 4786DROP TABLE t1,t2,t3,t4,t5,t6; 4787CREATE TABLE t1 (c1 INT NOT NULL); 4788CREATE TABLE t2 (c1 INT NOT NULL); 4789CREATE TABLE t3 (c1 INT NOT NULL); 4790CREATE TABLE t4 (c1 INT NOT NULL); 4791CREATE TABLE t5 (c1 INT NOT NULL); 4792CREATE TABLE t6 (c1 INT NOT NULL); 4793INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 4794INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 4795INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 4796INSERT INTO t4 (c1) VALUES(10); 4797INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 4798SELECT t1.c1,t2.c1 FROM t1 LEFT OUTER JOIN t2 ON t1.c1 = t2.c1 ORDER BY t1.c1,t2.c1; 4799c1 c1 48000 0 48011 1 48022 2 48033 3 48044 4 48055 5 48066 6 48077 7 48088 8 48099 9 4810SELECT t1.c1,t2.c1 FROM t1 LEFT OUTER JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 <> 5 ORDER BY t1.c1,t2.c1; 4811c1 c1 48120 0 48131 1 48142 2 48153 3 48164 4 48176 6 48187 7 48198 8 48209 9 4821DROP TABLE t1,t2,t3,t4,t5,t6; 4822CREATE TABLE t1 (c1 INTEGER NOT NULL); 4823CREATE TABLE t2 (c1 INTEGER NOT NULL); 4824CREATE TABLE t3 (c1 INTEGER NOT NULL); 4825CREATE TABLE t4 (c1 INTEGER NOT NULL); 4826CREATE TABLE t5 (c1 INTEGER NOT NULL); 4827CREATE TABLE t6 (c1 INTEGER NOT NULL); 4828INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 4829INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 4830INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 4831INSERT INTO t4 (c1) VALUES(10); 4832INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 4833SELECT t1.c1,t2.c1 FROM t1 LEFT OUTER JOIN t2 ON t1.c1 = t2.c1 ORDER BY t1.c1,t2.c1; 4834c1 c1 48350 0 48361 1 48372 2 48383 3 48394 4 48405 5 48416 6 48427 7 48438 8 48449 9 4845SELECT t1.c1,t2.c1 FROM t1 LEFT OUTER JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 <> 5 ORDER BY t1.c1,t2.c1; 4846c1 c1 48470 0 48481 1 48492 2 48503 3 48514 4 48526 6 48537 7 48548 8 48559 9 4856DROP TABLE t1,t2,t3,t4,t5,t6; 4857CREATE TABLE t1 (c1 BIGINT NOT NULL); 4858CREATE TABLE t2 (c1 BIGINT NOT NULL); 4859CREATE TABLE t3 (c1 BIGINT NOT NULL); 4860CREATE TABLE t4 (c1 BIGINT NOT NULL); 4861CREATE TABLE t5 (c1 BIGINT NOT NULL); 4862CREATE TABLE t6 (c1 BIGINT NOT NULL); 4863INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 4864INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 4865INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 4866INSERT INTO t4 (c1) VALUES(10); 4867INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 4868SELECT t1.c1,t2.c1 FROM t1 LEFT OUTER JOIN t2 ON t1.c1 = t2.c1 ORDER BY t1.c1,t2.c1; 4869c1 c1 48700 0 48711 1 48722 2 48733 3 48744 4 48755 5 48766 6 48777 7 48788 8 48799 9 4880SELECT t1.c1,t2.c1 FROM t1 LEFT OUTER JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 <> 5 ORDER BY t1.c1,t2.c1; 4881c1 c1 48820 0 48831 1 48842 2 48853 3 48864 4 48876 6 48887 7 48898 8 48909 9 4891DROP TABLE t1,t2,t3,t4,t5,t6; 4892CREATE TABLE t1 (c1 TINYINT NOT NULL); 4893CREATE TABLE t2 (c1 TINYINT NOT NULL); 4894CREATE TABLE t3 (c1 TINYINT NOT NULL); 4895CREATE TABLE t4 (c1 TINYINT NOT NULL); 4896CREATE TABLE t5 (c1 TINYINT NOT NULL); 4897CREATE TABLE t6 (c1 TINYINT NOT NULL); 4898INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 4899INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 4900INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 4901INSERT INTO t4 (c1) VALUES(10); 4902INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 4903SELECT t1.c1,t3.c1 FROM t1 LEFT OUTER JOIN t3 ON t1.c1 = t3.c1 ORDER BY t1.c1,t3.c1; 4904c1 c1 49050 NULL 49061 1 49072 NULL 49083 3 49094 NULL 49105 5 49116 NULL 49127 7 49138 NULL 49149 9 4915SELECT t1.c1,t3.c1 FROM t1 LEFT OUTER JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 <> 5 ORDER BY t1.c1,t3.c1; 4916c1 c1 49170 NULL 49181 1 49192 NULL 49203 3 49214 NULL 49226 NULL 49237 7 49248 NULL 49259 9 4926DROP TABLE t1,t2,t3,t4,t5,t6; 4927CREATE TABLE t1 (c1 SMALLINT NOT NULL); 4928CREATE TABLE t2 (c1 SMALLINT NOT NULL); 4929CREATE TABLE t3 (c1 SMALLINT NOT NULL); 4930CREATE TABLE t4 (c1 SMALLINT NOT NULL); 4931CREATE TABLE t5 (c1 SMALLINT NOT NULL); 4932CREATE TABLE t6 (c1 SMALLINT NOT NULL); 4933INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 4934INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 4935INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 4936INSERT INTO t4 (c1) VALUES(10); 4937INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 4938SELECT t1.c1,t3.c1 FROM t1 LEFT OUTER JOIN t3 ON t1.c1 = t3.c1 ORDER BY t1.c1,t3.c1; 4939c1 c1 49400 NULL 49411 1 49422 NULL 49433 3 49444 NULL 49455 5 49466 NULL 49477 7 49488 NULL 49499 9 4950SELECT t1.c1,t3.c1 FROM t1 LEFT OUTER JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 <> 5 ORDER BY t1.c1,t3.c1; 4951c1 c1 49520 NULL 49531 1 49542 NULL 49553 3 49564 NULL 49576 NULL 49587 7 49598 NULL 49609 9 4961DROP TABLE t1,t2,t3,t4,t5,t6; 4962CREATE TABLE t1 (c1 MEDIUMINT NOT NULL); 4963CREATE TABLE t2 (c1 MEDIUMINT NOT NULL); 4964CREATE TABLE t3 (c1 MEDIUMINT NOT NULL); 4965CREATE TABLE t4 (c1 MEDIUMINT NOT NULL); 4966CREATE TABLE t5 (c1 MEDIUMINT NOT NULL); 4967CREATE TABLE t6 (c1 MEDIUMINT NOT NULL); 4968INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 4969INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 4970INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 4971INSERT INTO t4 (c1) VALUES(10); 4972INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 4973SELECT t1.c1,t3.c1 FROM t1 LEFT OUTER JOIN t3 ON t1.c1 = t3.c1 ORDER BY t1.c1,t3.c1; 4974c1 c1 49750 NULL 49761 1 49772 NULL 49783 3 49794 NULL 49805 5 49816 NULL 49827 7 49838 NULL 49849 9 4985SELECT t1.c1,t3.c1 FROM t1 LEFT OUTER JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 <> 5 ORDER BY t1.c1,t3.c1; 4986c1 c1 49870 NULL 49881 1 49892 NULL 49903 3 49914 NULL 49926 NULL 49937 7 49948 NULL 49959 9 4996DROP TABLE t1,t2,t3,t4,t5,t6; 4997CREATE TABLE t1 (c1 INT NOT NULL); 4998CREATE TABLE t2 (c1 INT NOT NULL); 4999CREATE TABLE t3 (c1 INT NOT NULL); 5000CREATE TABLE t4 (c1 INT NOT NULL); 5001CREATE TABLE t5 (c1 INT NOT NULL); 5002CREATE TABLE t6 (c1 INT NOT NULL); 5003INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 5004INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 5005INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 5006INSERT INTO t4 (c1) VALUES(10); 5007INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 5008SELECT t1.c1,t3.c1 FROM t1 LEFT OUTER JOIN t3 ON t1.c1 = t3.c1 ORDER BY t1.c1,t3.c1; 5009c1 c1 50100 NULL 50111 1 50122 NULL 50133 3 50144 NULL 50155 5 50166 NULL 50177 7 50188 NULL 50199 9 5020SELECT t1.c1,t3.c1 FROM t1 LEFT OUTER JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 <> 5 ORDER BY t1.c1,t3.c1; 5021c1 c1 50220 NULL 50231 1 50242 NULL 50253 3 50264 NULL 50276 NULL 50287 7 50298 NULL 50309 9 5031DROP TABLE t1,t2,t3,t4,t5,t6; 5032CREATE TABLE t1 (c1 INTEGER NOT NULL); 5033CREATE TABLE t2 (c1 INTEGER NOT NULL); 5034CREATE TABLE t3 (c1 INTEGER NOT NULL); 5035CREATE TABLE t4 (c1 INTEGER NOT NULL); 5036CREATE TABLE t5 (c1 INTEGER NOT NULL); 5037CREATE TABLE t6 (c1 INTEGER NOT NULL); 5038INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 5039INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 5040INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 5041INSERT INTO t4 (c1) VALUES(10); 5042INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 5043SELECT t1.c1,t3.c1 FROM t1 LEFT OUTER JOIN t3 ON t1.c1 = t3.c1 ORDER BY t1.c1,t3.c1; 5044c1 c1 50450 NULL 50461 1 50472 NULL 50483 3 50494 NULL 50505 5 50516 NULL 50527 7 50538 NULL 50549 9 5055SELECT t1.c1,t3.c1 FROM t1 LEFT OUTER JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 <> 5 ORDER BY t1.c1,t3.c1; 5056c1 c1 50570 NULL 50581 1 50592 NULL 50603 3 50614 NULL 50626 NULL 50637 7 50648 NULL 50659 9 5066DROP TABLE t1,t2,t3,t4,t5,t6; 5067CREATE TABLE t1 (c1 BIGINT NOT NULL); 5068CREATE TABLE t2 (c1 BIGINT NOT NULL); 5069CREATE TABLE t3 (c1 BIGINT NOT NULL); 5070CREATE TABLE t4 (c1 BIGINT NOT NULL); 5071CREATE TABLE t5 (c1 BIGINT NOT NULL); 5072CREATE TABLE t6 (c1 BIGINT NOT NULL); 5073INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 5074INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 5075INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 5076INSERT INTO t4 (c1) VALUES(10); 5077INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 5078SELECT t1.c1,t3.c1 FROM t1 LEFT OUTER JOIN t3 ON t1.c1 = t3.c1 ORDER BY t1.c1,t3.c1; 5079c1 c1 50800 NULL 50811 1 50822 NULL 50833 3 50844 NULL 50855 5 50866 NULL 50877 7 50888 NULL 50899 9 5090SELECT t1.c1,t3.c1 FROM t1 LEFT OUTER JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 <> 5 ORDER BY t1.c1,t3.c1; 5091c1 c1 50920 NULL 50931 1 50942 NULL 50953 3 50964 NULL 50976 NULL 50987 7 50998 NULL 51009 9 5101DROP TABLE t1,t2,t3,t4,t5,t6; 5102CREATE TABLE t1 (c1 TINYINT NOT NULL); 5103CREATE TABLE t2 (c1 TINYINT NOT NULL); 5104CREATE TABLE t3 (c1 TINYINT NOT NULL); 5105CREATE TABLE t4 (c1 TINYINT NOT NULL); 5106CREATE TABLE t5 (c1 TINYINT NOT NULL); 5107CREATE TABLE t6 (c1 TINYINT NOT NULL); 5108INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 5109INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 5110INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 5111INSERT INTO t4 (c1) VALUES(10); 5112INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 5113SELECT t1.c1,t4.c1 FROM t1 LEFT OUTER JOIN t4 ON t1.c1 = t4.c1 ORDER BY t1.c1,t4.c1; 5114c1 c1 51150 NULL 51161 NULL 51172 NULL 51183 NULL 51194 NULL 51205 NULL 51216 NULL 51227 NULL 51238 NULL 51249 NULL 5125SELECT t1.c1,t4.c1 FROM t1 LEFT OUTER JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 <> 5 ORDER BY t1.c1,t4.c1; 5126c1 c1 51270 NULL 51281 NULL 51292 NULL 51303 NULL 51314 NULL 51326 NULL 51337 NULL 51348 NULL 51359 NULL 5136DROP TABLE t1,t2,t3,t4,t5,t6; 5137CREATE TABLE t1 (c1 SMALLINT NOT NULL); 5138CREATE TABLE t2 (c1 SMALLINT NOT NULL); 5139CREATE TABLE t3 (c1 SMALLINT NOT NULL); 5140CREATE TABLE t4 (c1 SMALLINT NOT NULL); 5141CREATE TABLE t5 (c1 SMALLINT NOT NULL); 5142CREATE TABLE t6 (c1 SMALLINT NOT NULL); 5143INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 5144INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 5145INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 5146INSERT INTO t4 (c1) VALUES(10); 5147INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 5148SELECT t1.c1,t4.c1 FROM t1 LEFT OUTER JOIN t4 ON t1.c1 = t4.c1 ORDER BY t1.c1,t4.c1; 5149c1 c1 51500 NULL 51511 NULL 51522 NULL 51533 NULL 51544 NULL 51555 NULL 51566 NULL 51577 NULL 51588 NULL 51599 NULL 5160SELECT t1.c1,t4.c1 FROM t1 LEFT OUTER JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 <> 5 ORDER BY t1.c1,t4.c1; 5161c1 c1 51620 NULL 51631 NULL 51642 NULL 51653 NULL 51664 NULL 51676 NULL 51687 NULL 51698 NULL 51709 NULL 5171DROP TABLE t1,t2,t3,t4,t5,t6; 5172CREATE TABLE t1 (c1 MEDIUMINT NOT NULL); 5173CREATE TABLE t2 (c1 MEDIUMINT NOT NULL); 5174CREATE TABLE t3 (c1 MEDIUMINT NOT NULL); 5175CREATE TABLE t4 (c1 MEDIUMINT NOT NULL); 5176CREATE TABLE t5 (c1 MEDIUMINT NOT NULL); 5177CREATE TABLE t6 (c1 MEDIUMINT NOT NULL); 5178INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 5179INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 5180INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 5181INSERT INTO t4 (c1) VALUES(10); 5182INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 5183SELECT t1.c1,t4.c1 FROM t1 LEFT OUTER JOIN t4 ON t1.c1 = t4.c1 ORDER BY t1.c1,t4.c1; 5184c1 c1 51850 NULL 51861 NULL 51872 NULL 51883 NULL 51894 NULL 51905 NULL 51916 NULL 51927 NULL 51938 NULL 51949 NULL 5195SELECT t1.c1,t4.c1 FROM t1 LEFT OUTER JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 <> 5 ORDER BY t1.c1,t4.c1; 5196c1 c1 51970 NULL 51981 NULL 51992 NULL 52003 NULL 52014 NULL 52026 NULL 52037 NULL 52048 NULL 52059 NULL 5206DROP TABLE t1,t2,t3,t4,t5,t6; 5207CREATE TABLE t1 (c1 INT NOT NULL); 5208CREATE TABLE t2 (c1 INT NOT NULL); 5209CREATE TABLE t3 (c1 INT NOT NULL); 5210CREATE TABLE t4 (c1 INT NOT NULL); 5211CREATE TABLE t5 (c1 INT NOT NULL); 5212CREATE TABLE t6 (c1 INT NOT NULL); 5213INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 5214INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 5215INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 5216INSERT INTO t4 (c1) VALUES(10); 5217INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 5218SELECT t1.c1,t4.c1 FROM t1 LEFT OUTER JOIN t4 ON t1.c1 = t4.c1 ORDER BY t1.c1,t4.c1; 5219c1 c1 52200 NULL 52211 NULL 52222 NULL 52233 NULL 52244 NULL 52255 NULL 52266 NULL 52277 NULL 52288 NULL 52299 NULL 5230SELECT t1.c1,t4.c1 FROM t1 LEFT OUTER JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 <> 5 ORDER BY t1.c1,t4.c1; 5231c1 c1 52320 NULL 52331 NULL 52342 NULL 52353 NULL 52364 NULL 52376 NULL 52387 NULL 52398 NULL 52409 NULL 5241DROP TABLE t1,t2,t3,t4,t5,t6; 5242CREATE TABLE t1 (c1 INTEGER NOT NULL); 5243CREATE TABLE t2 (c1 INTEGER NOT NULL); 5244CREATE TABLE t3 (c1 INTEGER NOT NULL); 5245CREATE TABLE t4 (c1 INTEGER NOT NULL); 5246CREATE TABLE t5 (c1 INTEGER NOT NULL); 5247CREATE TABLE t6 (c1 INTEGER NOT NULL); 5248INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 5249INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 5250INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 5251INSERT INTO t4 (c1) VALUES(10); 5252INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 5253SELECT t1.c1,t4.c1 FROM t1 LEFT OUTER JOIN t4 ON t1.c1 = t4.c1 ORDER BY t1.c1,t4.c1; 5254c1 c1 52550 NULL 52561 NULL 52572 NULL 52583 NULL 52594 NULL 52605 NULL 52616 NULL 52627 NULL 52638 NULL 52649 NULL 5265SELECT t1.c1,t4.c1 FROM t1 LEFT OUTER JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 <> 5 ORDER BY t1.c1,t4.c1; 5266c1 c1 52670 NULL 52681 NULL 52692 NULL 52703 NULL 52714 NULL 52726 NULL 52737 NULL 52748 NULL 52759 NULL 5276DROP TABLE t1,t2,t3,t4,t5,t6; 5277CREATE TABLE t1 (c1 BIGINT NOT NULL); 5278CREATE TABLE t2 (c1 BIGINT NOT NULL); 5279CREATE TABLE t3 (c1 BIGINT NOT NULL); 5280CREATE TABLE t4 (c1 BIGINT NOT NULL); 5281CREATE TABLE t5 (c1 BIGINT NOT NULL); 5282CREATE TABLE t6 (c1 BIGINT NOT NULL); 5283INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 5284INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 5285INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 5286INSERT INTO t4 (c1) VALUES(10); 5287INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 5288SELECT t1.c1,t4.c1 FROM t1 LEFT OUTER JOIN t4 ON t1.c1 = t4.c1 ORDER BY t1.c1,t4.c1; 5289c1 c1 52900 NULL 52911 NULL 52922 NULL 52933 NULL 52944 NULL 52955 NULL 52966 NULL 52977 NULL 52988 NULL 52999 NULL 5300SELECT t1.c1,t4.c1 FROM t1 LEFT OUTER JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 <> 5 ORDER BY t1.c1,t4.c1; 5301c1 c1 53020 NULL 53031 NULL 53042 NULL 53053 NULL 53064 NULL 53076 NULL 53087 NULL 53098 NULL 53109 NULL 5311DROP TABLE t1,t2,t3,t4,t5,t6; 5312CREATE TABLE t1 (c1 TINYINT NOT NULL); 5313CREATE TABLE t2 (c1 TINYINT NOT NULL); 5314CREATE TABLE t3 (c1 TINYINT NOT NULL); 5315CREATE TABLE t4 (c1 TINYINT NOT NULL); 5316CREATE TABLE t5 (c1 TINYINT NOT NULL); 5317CREATE TABLE t6 (c1 TINYINT NOT NULL); 5318INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 5319INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 5320INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 5321INSERT INTO t4 (c1) VALUES(10); 5322INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 5323SELECT t1.c1,t5.c1 FROM t1 LEFT OUTER JOIN t5 ON t1.c1 = t5.c1 ORDER BY t1.c1,t5.c1; 5324c1 c1 53250 NULL 53261 NULL 53272 NULL 53283 NULL 53294 NULL 53305 NULL 53316 NULL 53327 NULL 53338 NULL 53349 NULL 5335SELECT t1.c1,t5.c1 FROM t1 LEFT OUTER JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 <> 5 ORDER BY t1.c1,t5.c1; 5336c1 c1 53370 NULL 53381 NULL 53392 NULL 53403 NULL 53414 NULL 53426 NULL 53437 NULL 53448 NULL 53459 NULL 5346DROP TABLE t1,t2,t3,t4,t5,t6; 5347CREATE TABLE t1 (c1 SMALLINT NOT NULL); 5348CREATE TABLE t2 (c1 SMALLINT NOT NULL); 5349CREATE TABLE t3 (c1 SMALLINT NOT NULL); 5350CREATE TABLE t4 (c1 SMALLINT NOT NULL); 5351CREATE TABLE t5 (c1 SMALLINT NOT NULL); 5352CREATE TABLE t6 (c1 SMALLINT NOT NULL); 5353INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 5354INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 5355INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 5356INSERT INTO t4 (c1) VALUES(10); 5357INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 5358SELECT t1.c1,t5.c1 FROM t1 LEFT OUTER JOIN t5 ON t1.c1 = t5.c1 ORDER BY t1.c1,t5.c1; 5359c1 c1 53600 NULL 53611 NULL 53622 NULL 53633 NULL 53644 NULL 53655 NULL 53666 NULL 53677 NULL 53688 NULL 53699 NULL 5370SELECT t1.c1,t5.c1 FROM t1 LEFT OUTER JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 <> 5 ORDER BY t1.c1,t5.c1; 5371c1 c1 53720 NULL 53731 NULL 53742 NULL 53753 NULL 53764 NULL 53776 NULL 53787 NULL 53798 NULL 53809 NULL 5381DROP TABLE t1,t2,t3,t4,t5,t6; 5382CREATE TABLE t1 (c1 MEDIUMINT NOT NULL); 5383CREATE TABLE t2 (c1 MEDIUMINT NOT NULL); 5384CREATE TABLE t3 (c1 MEDIUMINT NOT NULL); 5385CREATE TABLE t4 (c1 MEDIUMINT NOT NULL); 5386CREATE TABLE t5 (c1 MEDIUMINT NOT NULL); 5387CREATE TABLE t6 (c1 MEDIUMINT NOT NULL); 5388INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 5389INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 5390INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 5391INSERT INTO t4 (c1) VALUES(10); 5392INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 5393SELECT t1.c1,t5.c1 FROM t1 LEFT OUTER JOIN t5 ON t1.c1 = t5.c1 ORDER BY t1.c1,t5.c1; 5394c1 c1 53950 NULL 53961 NULL 53972 NULL 53983 NULL 53994 NULL 54005 NULL 54016 NULL 54027 NULL 54038 NULL 54049 NULL 5405SELECT t1.c1,t5.c1 FROM t1 LEFT OUTER JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 <> 5 ORDER BY t1.c1,t5.c1; 5406c1 c1 54070 NULL 54081 NULL 54092 NULL 54103 NULL 54114 NULL 54126 NULL 54137 NULL 54148 NULL 54159 NULL 5416DROP TABLE t1,t2,t3,t4,t5,t6; 5417CREATE TABLE t1 (c1 INT NOT NULL); 5418CREATE TABLE t2 (c1 INT NOT NULL); 5419CREATE TABLE t3 (c1 INT NOT NULL); 5420CREATE TABLE t4 (c1 INT NOT NULL); 5421CREATE TABLE t5 (c1 INT NOT NULL); 5422CREATE TABLE t6 (c1 INT NOT NULL); 5423INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 5424INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 5425INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 5426INSERT INTO t4 (c1) VALUES(10); 5427INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 5428SELECT t1.c1,t5.c1 FROM t1 LEFT OUTER JOIN t5 ON t1.c1 = t5.c1 ORDER BY t1.c1,t5.c1; 5429c1 c1 54300 NULL 54311 NULL 54322 NULL 54333 NULL 54344 NULL 54355 NULL 54366 NULL 54377 NULL 54388 NULL 54399 NULL 5440SELECT t1.c1,t5.c1 FROM t1 LEFT OUTER JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 <> 5 ORDER BY t1.c1,t5.c1; 5441c1 c1 54420 NULL 54431 NULL 54442 NULL 54453 NULL 54464 NULL 54476 NULL 54487 NULL 54498 NULL 54509 NULL 5451DROP TABLE t1,t2,t3,t4,t5,t6; 5452CREATE TABLE t1 (c1 INTEGER NOT NULL); 5453CREATE TABLE t2 (c1 INTEGER NOT NULL); 5454CREATE TABLE t3 (c1 INTEGER NOT NULL); 5455CREATE TABLE t4 (c1 INTEGER NOT NULL); 5456CREATE TABLE t5 (c1 INTEGER NOT NULL); 5457CREATE TABLE t6 (c1 INTEGER NOT NULL); 5458INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 5459INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 5460INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 5461INSERT INTO t4 (c1) VALUES(10); 5462INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 5463SELECT t1.c1,t5.c1 FROM t1 LEFT OUTER JOIN t5 ON t1.c1 = t5.c1 ORDER BY t1.c1,t5.c1; 5464c1 c1 54650 NULL 54661 NULL 54672 NULL 54683 NULL 54694 NULL 54705 NULL 54716 NULL 54727 NULL 54738 NULL 54749 NULL 5475SELECT t1.c1,t5.c1 FROM t1 LEFT OUTER JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 <> 5 ORDER BY t1.c1,t5.c1; 5476c1 c1 54770 NULL 54781 NULL 54792 NULL 54803 NULL 54814 NULL 54826 NULL 54837 NULL 54848 NULL 54859 NULL 5486DROP TABLE t1,t2,t3,t4,t5,t6; 5487CREATE TABLE t1 (c1 BIGINT NOT NULL); 5488CREATE TABLE t2 (c1 BIGINT NOT NULL); 5489CREATE TABLE t3 (c1 BIGINT NOT NULL); 5490CREATE TABLE t4 (c1 BIGINT NOT NULL); 5491CREATE TABLE t5 (c1 BIGINT NOT NULL); 5492CREATE TABLE t6 (c1 BIGINT NOT NULL); 5493INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 5494INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 5495INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 5496INSERT INTO t4 (c1) VALUES(10); 5497INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 5498SELECT t1.c1,t5.c1 FROM t1 LEFT OUTER JOIN t5 ON t1.c1 = t5.c1 ORDER BY t1.c1,t5.c1; 5499c1 c1 55000 NULL 55011 NULL 55022 NULL 55033 NULL 55044 NULL 55055 NULL 55066 NULL 55077 NULL 55088 NULL 55099 NULL 5510SELECT t1.c1,t5.c1 FROM t1 LEFT OUTER JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 <> 5 ORDER BY t1.c1,t5.c1; 5511c1 c1 55120 NULL 55131 NULL 55142 NULL 55153 NULL 55164 NULL 55176 NULL 55187 NULL 55198 NULL 55209 NULL 5521DROP TABLE t1,t2,t3,t4,t5,t6; 5522CREATE TABLE t1 (c1 TINYINT NOT NULL); 5523CREATE TABLE t2 (c1 TINYINT NOT NULL); 5524CREATE TABLE t3 (c1 TINYINT NOT NULL); 5525CREATE TABLE t4 (c1 TINYINT NOT NULL); 5526CREATE TABLE t5 (c1 TINYINT NOT NULL); 5527CREATE TABLE t6 (c1 TINYINT NOT NULL); 5528INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 5529INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 5530INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 5531INSERT INTO t4 (c1) VALUES(10); 5532INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 5533SELECT t1.c1,t6.c1 FROM t1 LEFT OUTER JOIN t6 ON t1.c1 = t6.c1 ORDER BY t1.c1,t6.c1; 5534c1 c1 55350 NULL 55361 NULL 55372 NULL 55383 NULL 55394 NULL 55405 NULL 55416 NULL 55427 NULL 55438 NULL 55449 NULL 5545SELECT t1.c1,t6.c1 FROM t1 LEFT OUTER JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 <> 5 ORDER BY t1.c1,t6.c1; 5546c1 c1 55470 NULL 55481 NULL 55492 NULL 55503 NULL 55514 NULL 55526 NULL 55537 NULL 55548 NULL 55559 NULL 5556DROP TABLE t1,t2,t3,t4,t5,t6; 5557CREATE TABLE t1 (c1 SMALLINT NOT NULL); 5558CREATE TABLE t2 (c1 SMALLINT NOT NULL); 5559CREATE TABLE t3 (c1 SMALLINT NOT NULL); 5560CREATE TABLE t4 (c1 SMALLINT NOT NULL); 5561CREATE TABLE t5 (c1 SMALLINT NOT NULL); 5562CREATE TABLE t6 (c1 SMALLINT NOT NULL); 5563INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 5564INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 5565INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 5566INSERT INTO t4 (c1) VALUES(10); 5567INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 5568SELECT t1.c1,t6.c1 FROM t1 LEFT OUTER JOIN t6 ON t1.c1 = t6.c1 ORDER BY t1.c1,t6.c1; 5569c1 c1 55700 NULL 55711 NULL 55722 NULL 55733 NULL 55744 NULL 55755 NULL 55766 NULL 55777 NULL 55788 NULL 55799 NULL 5580SELECT t1.c1,t6.c1 FROM t1 LEFT OUTER JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 <> 5 ORDER BY t1.c1,t6.c1; 5581c1 c1 55820 NULL 55831 NULL 55842 NULL 55853 NULL 55864 NULL 55876 NULL 55887 NULL 55898 NULL 55909 NULL 5591DROP TABLE t1,t2,t3,t4,t5,t6; 5592CREATE TABLE t1 (c1 MEDIUMINT NOT NULL); 5593CREATE TABLE t2 (c1 MEDIUMINT NOT NULL); 5594CREATE TABLE t3 (c1 MEDIUMINT NOT NULL); 5595CREATE TABLE t4 (c1 MEDIUMINT NOT NULL); 5596CREATE TABLE t5 (c1 MEDIUMINT NOT NULL); 5597CREATE TABLE t6 (c1 MEDIUMINT NOT NULL); 5598INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 5599INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 5600INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 5601INSERT INTO t4 (c1) VALUES(10); 5602INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 5603SELECT t1.c1,t6.c1 FROM t1 LEFT OUTER JOIN t6 ON t1.c1 = t6.c1 ORDER BY t1.c1,t6.c1; 5604c1 c1 56050 NULL 56061 NULL 56072 NULL 56083 NULL 56094 NULL 56105 NULL 56116 NULL 56127 NULL 56138 NULL 56149 NULL 5615SELECT t1.c1,t6.c1 FROM t1 LEFT OUTER JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 <> 5 ORDER BY t1.c1,t6.c1; 5616c1 c1 56170 NULL 56181 NULL 56192 NULL 56203 NULL 56214 NULL 56226 NULL 56237 NULL 56248 NULL 56259 NULL 5626DROP TABLE t1,t2,t3,t4,t5,t6; 5627CREATE TABLE t1 (c1 INT NOT NULL); 5628CREATE TABLE t2 (c1 INT NOT NULL); 5629CREATE TABLE t3 (c1 INT NOT NULL); 5630CREATE TABLE t4 (c1 INT NOT NULL); 5631CREATE TABLE t5 (c1 INT NOT NULL); 5632CREATE TABLE t6 (c1 INT NOT NULL); 5633INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 5634INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 5635INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 5636INSERT INTO t4 (c1) VALUES(10); 5637INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 5638SELECT t1.c1,t6.c1 FROM t1 LEFT OUTER JOIN t6 ON t1.c1 = t6.c1 ORDER BY t1.c1,t6.c1; 5639c1 c1 56400 NULL 56411 NULL 56422 NULL 56433 NULL 56444 NULL 56455 NULL 56466 NULL 56477 NULL 56488 NULL 56499 NULL 5650SELECT t1.c1,t6.c1 FROM t1 LEFT OUTER JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 <> 5 ORDER BY t1.c1,t6.c1; 5651c1 c1 56520 NULL 56531 NULL 56542 NULL 56553 NULL 56564 NULL 56576 NULL 56587 NULL 56598 NULL 56609 NULL 5661DROP TABLE t1,t2,t3,t4,t5,t6; 5662CREATE TABLE t1 (c1 INTEGER NOT NULL); 5663CREATE TABLE t2 (c1 INTEGER NOT NULL); 5664CREATE TABLE t3 (c1 INTEGER NOT NULL); 5665CREATE TABLE t4 (c1 INTEGER NOT NULL); 5666CREATE TABLE t5 (c1 INTEGER NOT NULL); 5667CREATE TABLE t6 (c1 INTEGER NOT NULL); 5668INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 5669INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 5670INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 5671INSERT INTO t4 (c1) VALUES(10); 5672INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 5673SELECT t1.c1,t6.c1 FROM t1 LEFT OUTER JOIN t6 ON t1.c1 = t6.c1 ORDER BY t1.c1,t6.c1; 5674c1 c1 56750 NULL 56761 NULL 56772 NULL 56783 NULL 56794 NULL 56805 NULL 56816 NULL 56827 NULL 56838 NULL 56849 NULL 5685SELECT t1.c1,t6.c1 FROM t1 LEFT OUTER JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 <> 5 ORDER BY t1.c1,t6.c1; 5686c1 c1 56870 NULL 56881 NULL 56892 NULL 56903 NULL 56914 NULL 56926 NULL 56937 NULL 56948 NULL 56959 NULL 5696DROP TABLE t1,t2,t3,t4,t5,t6; 5697CREATE TABLE t1 (c1 BIGINT NOT NULL); 5698CREATE TABLE t2 (c1 BIGINT NOT NULL); 5699CREATE TABLE t3 (c1 BIGINT NOT NULL); 5700CREATE TABLE t4 (c1 BIGINT NOT NULL); 5701CREATE TABLE t5 (c1 BIGINT NOT NULL); 5702CREATE TABLE t6 (c1 BIGINT NOT NULL); 5703INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 5704INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 5705INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 5706INSERT INTO t4 (c1) VALUES(10); 5707INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 5708SELECT t1.c1,t6.c1 FROM t1 LEFT OUTER JOIN t6 ON t1.c1 = t6.c1 ORDER BY t1.c1,t6.c1; 5709c1 c1 57100 NULL 57111 NULL 57122 NULL 57133 NULL 57144 NULL 57155 NULL 57166 NULL 57177 NULL 57188 NULL 57199 NULL 5720SELECT t1.c1,t6.c1 FROM t1 LEFT OUTER JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 <> 5 ORDER BY t1.c1,t6.c1; 5721c1 c1 57220 NULL 57231 NULL 57242 NULL 57253 NULL 57264 NULL 57276 NULL 57287 NULL 57298 NULL 57309 NULL 5731DROP TABLE t1,t2,t3,t4,t5,t6; 5732CREATE TABLE t1 (c1 TINYINT NOT NULL); 5733CREATE TABLE t2 (c1 TINYINT NOT NULL); 5734CREATE TABLE t3 (c1 TINYINT NOT NULL); 5735CREATE TABLE t4 (c1 TINYINT NOT NULL); 5736CREATE TABLE t5 (c1 TINYINT NOT NULL); 5737CREATE TABLE t6 (c1 TINYINT NOT NULL); 5738INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 5739INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 5740INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 5741INSERT INTO t4 (c1) VALUES(10); 5742INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 5743SELECT t1.c1,t2.c1 FROM t1 LEFT OUTER JOIN t2 ON t1.c1 = t2.c1 ORDER BY t1.c1,t2.c1; 5744c1 c1 57450 0 57461 1 57472 2 57483 3 57494 4 57505 5 57516 6 57527 7 57538 8 57549 9 5755SELECT t1.c1,t2.c1 FROM t1 LEFT OUTER JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 <=> 5 ORDER BY t1.c1,t2.c1; 5756c1 c1 57575 5 5758DROP TABLE t1,t2,t3,t4,t5,t6; 5759CREATE TABLE t1 (c1 SMALLINT NOT NULL); 5760CREATE TABLE t2 (c1 SMALLINT NOT NULL); 5761CREATE TABLE t3 (c1 SMALLINT NOT NULL); 5762CREATE TABLE t4 (c1 SMALLINT NOT NULL); 5763CREATE TABLE t5 (c1 SMALLINT NOT NULL); 5764CREATE TABLE t6 (c1 SMALLINT NOT NULL); 5765INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 5766INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 5767INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 5768INSERT INTO t4 (c1) VALUES(10); 5769INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 5770SELECT t1.c1,t2.c1 FROM t1 LEFT OUTER JOIN t2 ON t1.c1 = t2.c1 ORDER BY t1.c1,t2.c1; 5771c1 c1 57720 0 57731 1 57742 2 57753 3 57764 4 57775 5 57786 6 57797 7 57808 8 57819 9 5782SELECT t1.c1,t2.c1 FROM t1 LEFT OUTER JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 <=> 5 ORDER BY t1.c1,t2.c1; 5783c1 c1 57845 5 5785DROP TABLE t1,t2,t3,t4,t5,t6; 5786CREATE TABLE t1 (c1 MEDIUMINT NOT NULL); 5787CREATE TABLE t2 (c1 MEDIUMINT NOT NULL); 5788CREATE TABLE t3 (c1 MEDIUMINT NOT NULL); 5789CREATE TABLE t4 (c1 MEDIUMINT NOT NULL); 5790CREATE TABLE t5 (c1 MEDIUMINT NOT NULL); 5791CREATE TABLE t6 (c1 MEDIUMINT NOT NULL); 5792INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 5793INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 5794INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 5795INSERT INTO t4 (c1) VALUES(10); 5796INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 5797SELECT t1.c1,t2.c1 FROM t1 LEFT OUTER JOIN t2 ON t1.c1 = t2.c1 ORDER BY t1.c1,t2.c1; 5798c1 c1 57990 0 58001 1 58012 2 58023 3 58034 4 58045 5 58056 6 58067 7 58078 8 58089 9 5809SELECT t1.c1,t2.c1 FROM t1 LEFT OUTER JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 <=> 5 ORDER BY t1.c1,t2.c1; 5810c1 c1 58115 5 5812DROP TABLE t1,t2,t3,t4,t5,t6; 5813CREATE TABLE t1 (c1 INT NOT NULL); 5814CREATE TABLE t2 (c1 INT NOT NULL); 5815CREATE TABLE t3 (c1 INT NOT NULL); 5816CREATE TABLE t4 (c1 INT NOT NULL); 5817CREATE TABLE t5 (c1 INT NOT NULL); 5818CREATE TABLE t6 (c1 INT NOT NULL); 5819INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 5820INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 5821INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 5822INSERT INTO t4 (c1) VALUES(10); 5823INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 5824SELECT t1.c1,t2.c1 FROM t1 LEFT OUTER JOIN t2 ON t1.c1 = t2.c1 ORDER BY t1.c1,t2.c1; 5825c1 c1 58260 0 58271 1 58282 2 58293 3 58304 4 58315 5 58326 6 58337 7 58348 8 58359 9 5836SELECT t1.c1,t2.c1 FROM t1 LEFT OUTER JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 <=> 5 ORDER BY t1.c1,t2.c1; 5837c1 c1 58385 5 5839DROP TABLE t1,t2,t3,t4,t5,t6; 5840CREATE TABLE t1 (c1 INTEGER NOT NULL); 5841CREATE TABLE t2 (c1 INTEGER NOT NULL); 5842CREATE TABLE t3 (c1 INTEGER NOT NULL); 5843CREATE TABLE t4 (c1 INTEGER NOT NULL); 5844CREATE TABLE t5 (c1 INTEGER NOT NULL); 5845CREATE TABLE t6 (c1 INTEGER NOT NULL); 5846INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 5847INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 5848INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 5849INSERT INTO t4 (c1) VALUES(10); 5850INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 5851SELECT t1.c1,t2.c1 FROM t1 LEFT OUTER JOIN t2 ON t1.c1 = t2.c1 ORDER BY t1.c1,t2.c1; 5852c1 c1 58530 0 58541 1 58552 2 58563 3 58574 4 58585 5 58596 6 58607 7 58618 8 58629 9 5863SELECT t1.c1,t2.c1 FROM t1 LEFT OUTER JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 <=> 5 ORDER BY t1.c1,t2.c1; 5864c1 c1 58655 5 5866DROP TABLE t1,t2,t3,t4,t5,t6; 5867CREATE TABLE t1 (c1 BIGINT NOT NULL); 5868CREATE TABLE t2 (c1 BIGINT NOT NULL); 5869CREATE TABLE t3 (c1 BIGINT NOT NULL); 5870CREATE TABLE t4 (c1 BIGINT NOT NULL); 5871CREATE TABLE t5 (c1 BIGINT NOT NULL); 5872CREATE TABLE t6 (c1 BIGINT NOT NULL); 5873INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 5874INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 5875INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 5876INSERT INTO t4 (c1) VALUES(10); 5877INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 5878SELECT t1.c1,t2.c1 FROM t1 LEFT OUTER JOIN t2 ON t1.c1 = t2.c1 ORDER BY t1.c1,t2.c1; 5879c1 c1 58800 0 58811 1 58822 2 58833 3 58844 4 58855 5 58866 6 58877 7 58888 8 58899 9 5890SELECT t1.c1,t2.c1 FROM t1 LEFT OUTER JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 <=> 5 ORDER BY t1.c1,t2.c1; 5891c1 c1 58925 5 5893DROP TABLE t1,t2,t3,t4,t5,t6; 5894CREATE TABLE t1 (c1 TINYINT NOT NULL); 5895CREATE TABLE t2 (c1 TINYINT NOT NULL); 5896CREATE TABLE t3 (c1 TINYINT NOT NULL); 5897CREATE TABLE t4 (c1 TINYINT NOT NULL); 5898CREATE TABLE t5 (c1 TINYINT NOT NULL); 5899CREATE TABLE t6 (c1 TINYINT NOT NULL); 5900INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 5901INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 5902INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 5903INSERT INTO t4 (c1) VALUES(10); 5904INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 5905SELECT t1.c1,t3.c1 FROM t1 LEFT OUTER JOIN t3 ON t1.c1 = t3.c1 ORDER BY t1.c1,t3.c1; 5906c1 c1 59070 NULL 59081 1 59092 NULL 59103 3 59114 NULL 59125 5 59136 NULL 59147 7 59158 NULL 59169 9 5917SELECT t1.c1,t3.c1 FROM t1 LEFT OUTER JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 <=> 5 ORDER BY t1.c1,t3.c1; 5918c1 c1 59195 5 5920DROP TABLE t1,t2,t3,t4,t5,t6; 5921CREATE TABLE t1 (c1 SMALLINT NOT NULL); 5922CREATE TABLE t2 (c1 SMALLINT NOT NULL); 5923CREATE TABLE t3 (c1 SMALLINT NOT NULL); 5924CREATE TABLE t4 (c1 SMALLINT NOT NULL); 5925CREATE TABLE t5 (c1 SMALLINT NOT NULL); 5926CREATE TABLE t6 (c1 SMALLINT NOT NULL); 5927INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 5928INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 5929INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 5930INSERT INTO t4 (c1) VALUES(10); 5931INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 5932SELECT t1.c1,t3.c1 FROM t1 LEFT OUTER JOIN t3 ON t1.c1 = t3.c1 ORDER BY t1.c1,t3.c1; 5933c1 c1 59340 NULL 59351 1 59362 NULL 59373 3 59384 NULL 59395 5 59406 NULL 59417 7 59428 NULL 59439 9 5944SELECT t1.c1,t3.c1 FROM t1 LEFT OUTER JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 <=> 5 ORDER BY t1.c1,t3.c1; 5945c1 c1 59465 5 5947DROP TABLE t1,t2,t3,t4,t5,t6; 5948CREATE TABLE t1 (c1 MEDIUMINT NOT NULL); 5949CREATE TABLE t2 (c1 MEDIUMINT NOT NULL); 5950CREATE TABLE t3 (c1 MEDIUMINT NOT NULL); 5951CREATE TABLE t4 (c1 MEDIUMINT NOT NULL); 5952CREATE TABLE t5 (c1 MEDIUMINT NOT NULL); 5953CREATE TABLE t6 (c1 MEDIUMINT NOT NULL); 5954INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 5955INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 5956INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 5957INSERT INTO t4 (c1) VALUES(10); 5958INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 5959SELECT t1.c1,t3.c1 FROM t1 LEFT OUTER JOIN t3 ON t1.c1 = t3.c1 ORDER BY t1.c1,t3.c1; 5960c1 c1 59610 NULL 59621 1 59632 NULL 59643 3 59654 NULL 59665 5 59676 NULL 59687 7 59698 NULL 59709 9 5971SELECT t1.c1,t3.c1 FROM t1 LEFT OUTER JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 <=> 5 ORDER BY t1.c1,t3.c1; 5972c1 c1 59735 5 5974DROP TABLE t1,t2,t3,t4,t5,t6; 5975CREATE TABLE t1 (c1 INT NOT NULL); 5976CREATE TABLE t2 (c1 INT NOT NULL); 5977CREATE TABLE t3 (c1 INT NOT NULL); 5978CREATE TABLE t4 (c1 INT NOT NULL); 5979CREATE TABLE t5 (c1 INT NOT NULL); 5980CREATE TABLE t6 (c1 INT NOT NULL); 5981INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 5982INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 5983INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 5984INSERT INTO t4 (c1) VALUES(10); 5985INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 5986SELECT t1.c1,t3.c1 FROM t1 LEFT OUTER JOIN t3 ON t1.c1 = t3.c1 ORDER BY t1.c1,t3.c1; 5987c1 c1 59880 NULL 59891 1 59902 NULL 59913 3 59924 NULL 59935 5 59946 NULL 59957 7 59968 NULL 59979 9 5998SELECT t1.c1,t3.c1 FROM t1 LEFT OUTER JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 <=> 5 ORDER BY t1.c1,t3.c1; 5999c1 c1 60005 5 6001DROP TABLE t1,t2,t3,t4,t5,t6; 6002CREATE TABLE t1 (c1 INTEGER NOT NULL); 6003CREATE TABLE t2 (c1 INTEGER NOT NULL); 6004CREATE TABLE t3 (c1 INTEGER NOT NULL); 6005CREATE TABLE t4 (c1 INTEGER NOT NULL); 6006CREATE TABLE t5 (c1 INTEGER NOT NULL); 6007CREATE TABLE t6 (c1 INTEGER NOT NULL); 6008INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 6009INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 6010INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 6011INSERT INTO t4 (c1) VALUES(10); 6012INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 6013SELECT t1.c1,t3.c1 FROM t1 LEFT OUTER JOIN t3 ON t1.c1 = t3.c1 ORDER BY t1.c1,t3.c1; 6014c1 c1 60150 NULL 60161 1 60172 NULL 60183 3 60194 NULL 60205 5 60216 NULL 60227 7 60238 NULL 60249 9 6025SELECT t1.c1,t3.c1 FROM t1 LEFT OUTER JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 <=> 5 ORDER BY t1.c1,t3.c1; 6026c1 c1 60275 5 6028DROP TABLE t1,t2,t3,t4,t5,t6; 6029CREATE TABLE t1 (c1 BIGINT NOT NULL); 6030CREATE TABLE t2 (c1 BIGINT NOT NULL); 6031CREATE TABLE t3 (c1 BIGINT NOT NULL); 6032CREATE TABLE t4 (c1 BIGINT NOT NULL); 6033CREATE TABLE t5 (c1 BIGINT NOT NULL); 6034CREATE TABLE t6 (c1 BIGINT NOT NULL); 6035INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 6036INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 6037INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 6038INSERT INTO t4 (c1) VALUES(10); 6039INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 6040SELECT t1.c1,t3.c1 FROM t1 LEFT OUTER JOIN t3 ON t1.c1 = t3.c1 ORDER BY t1.c1,t3.c1; 6041c1 c1 60420 NULL 60431 1 60442 NULL 60453 3 60464 NULL 60475 5 60486 NULL 60497 7 60508 NULL 60519 9 6052SELECT t1.c1,t3.c1 FROM t1 LEFT OUTER JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 <=> 5 ORDER BY t1.c1,t3.c1; 6053c1 c1 60545 5 6055DROP TABLE t1,t2,t3,t4,t5,t6; 6056CREATE TABLE t1 (c1 TINYINT NOT NULL); 6057CREATE TABLE t2 (c1 TINYINT NOT NULL); 6058CREATE TABLE t3 (c1 TINYINT NOT NULL); 6059CREATE TABLE t4 (c1 TINYINT NOT NULL); 6060CREATE TABLE t5 (c1 TINYINT NOT NULL); 6061CREATE TABLE t6 (c1 TINYINT NOT NULL); 6062INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 6063INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 6064INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 6065INSERT INTO t4 (c1) VALUES(10); 6066INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 6067SELECT t1.c1,t4.c1 FROM t1 LEFT OUTER JOIN t4 ON t1.c1 = t4.c1 ORDER BY t1.c1,t4.c1; 6068c1 c1 60690 NULL 60701 NULL 60712 NULL 60723 NULL 60734 NULL 60745 NULL 60756 NULL 60767 NULL 60778 NULL 60789 NULL 6079SELECT t1.c1,t4.c1 FROM t1 LEFT OUTER JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 <=> 5 ORDER BY t1.c1,t4.c1; 6080c1 c1 60815 NULL 6082DROP TABLE t1,t2,t3,t4,t5,t6; 6083CREATE TABLE t1 (c1 SMALLINT NOT NULL); 6084CREATE TABLE t2 (c1 SMALLINT NOT NULL); 6085CREATE TABLE t3 (c1 SMALLINT NOT NULL); 6086CREATE TABLE t4 (c1 SMALLINT NOT NULL); 6087CREATE TABLE t5 (c1 SMALLINT NOT NULL); 6088CREATE TABLE t6 (c1 SMALLINT NOT NULL); 6089INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 6090INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 6091INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 6092INSERT INTO t4 (c1) VALUES(10); 6093INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 6094SELECT t1.c1,t4.c1 FROM t1 LEFT OUTER JOIN t4 ON t1.c1 = t4.c1 ORDER BY t1.c1,t4.c1; 6095c1 c1 60960 NULL 60971 NULL 60982 NULL 60993 NULL 61004 NULL 61015 NULL 61026 NULL 61037 NULL 61048 NULL 61059 NULL 6106SELECT t1.c1,t4.c1 FROM t1 LEFT OUTER JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 <=> 5 ORDER BY t1.c1,t4.c1; 6107c1 c1 61085 NULL 6109DROP TABLE t1,t2,t3,t4,t5,t6; 6110CREATE TABLE t1 (c1 MEDIUMINT NOT NULL); 6111CREATE TABLE t2 (c1 MEDIUMINT NOT NULL); 6112CREATE TABLE t3 (c1 MEDIUMINT NOT NULL); 6113CREATE TABLE t4 (c1 MEDIUMINT NOT NULL); 6114CREATE TABLE t5 (c1 MEDIUMINT NOT NULL); 6115CREATE TABLE t6 (c1 MEDIUMINT NOT NULL); 6116INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 6117INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 6118INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 6119INSERT INTO t4 (c1) VALUES(10); 6120INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 6121SELECT t1.c1,t4.c1 FROM t1 LEFT OUTER JOIN t4 ON t1.c1 = t4.c1 ORDER BY t1.c1,t4.c1; 6122c1 c1 61230 NULL 61241 NULL 61252 NULL 61263 NULL 61274 NULL 61285 NULL 61296 NULL 61307 NULL 61318 NULL 61329 NULL 6133SELECT t1.c1,t4.c1 FROM t1 LEFT OUTER JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 <=> 5 ORDER BY t1.c1,t4.c1; 6134c1 c1 61355 NULL 6136DROP TABLE t1,t2,t3,t4,t5,t6; 6137CREATE TABLE t1 (c1 INT NOT NULL); 6138CREATE TABLE t2 (c1 INT NOT NULL); 6139CREATE TABLE t3 (c1 INT NOT NULL); 6140CREATE TABLE t4 (c1 INT NOT NULL); 6141CREATE TABLE t5 (c1 INT NOT NULL); 6142CREATE TABLE t6 (c1 INT NOT NULL); 6143INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 6144INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 6145INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 6146INSERT INTO t4 (c1) VALUES(10); 6147INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 6148SELECT t1.c1,t4.c1 FROM t1 LEFT OUTER JOIN t4 ON t1.c1 = t4.c1 ORDER BY t1.c1,t4.c1; 6149c1 c1 61500 NULL 61511 NULL 61522 NULL 61533 NULL 61544 NULL 61555 NULL 61566 NULL 61577 NULL 61588 NULL 61599 NULL 6160SELECT t1.c1,t4.c1 FROM t1 LEFT OUTER JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 <=> 5 ORDER BY t1.c1,t4.c1; 6161c1 c1 61625 NULL 6163DROP TABLE t1,t2,t3,t4,t5,t6; 6164CREATE TABLE t1 (c1 INTEGER NOT NULL); 6165CREATE TABLE t2 (c1 INTEGER NOT NULL); 6166CREATE TABLE t3 (c1 INTEGER NOT NULL); 6167CREATE TABLE t4 (c1 INTEGER NOT NULL); 6168CREATE TABLE t5 (c1 INTEGER NOT NULL); 6169CREATE TABLE t6 (c1 INTEGER NOT NULL); 6170INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 6171INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 6172INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 6173INSERT INTO t4 (c1) VALUES(10); 6174INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 6175SELECT t1.c1,t4.c1 FROM t1 LEFT OUTER JOIN t4 ON t1.c1 = t4.c1 ORDER BY t1.c1,t4.c1; 6176c1 c1 61770 NULL 61781 NULL 61792 NULL 61803 NULL 61814 NULL 61825 NULL 61836 NULL 61847 NULL 61858 NULL 61869 NULL 6187SELECT t1.c1,t4.c1 FROM t1 LEFT OUTER JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 <=> 5 ORDER BY t1.c1,t4.c1; 6188c1 c1 61895 NULL 6190DROP TABLE t1,t2,t3,t4,t5,t6; 6191CREATE TABLE t1 (c1 BIGINT NOT NULL); 6192CREATE TABLE t2 (c1 BIGINT NOT NULL); 6193CREATE TABLE t3 (c1 BIGINT NOT NULL); 6194CREATE TABLE t4 (c1 BIGINT NOT NULL); 6195CREATE TABLE t5 (c1 BIGINT NOT NULL); 6196CREATE TABLE t6 (c1 BIGINT NOT NULL); 6197INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 6198INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 6199INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 6200INSERT INTO t4 (c1) VALUES(10); 6201INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 6202SELECT t1.c1,t4.c1 FROM t1 LEFT OUTER JOIN t4 ON t1.c1 = t4.c1 ORDER BY t1.c1,t4.c1; 6203c1 c1 62040 NULL 62051 NULL 62062 NULL 62073 NULL 62084 NULL 62095 NULL 62106 NULL 62117 NULL 62128 NULL 62139 NULL 6214SELECT t1.c1,t4.c1 FROM t1 LEFT OUTER JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 <=> 5 ORDER BY t1.c1,t4.c1; 6215c1 c1 62165 NULL 6217DROP TABLE t1,t2,t3,t4,t5,t6; 6218CREATE TABLE t1 (c1 TINYINT NOT NULL); 6219CREATE TABLE t2 (c1 TINYINT NOT NULL); 6220CREATE TABLE t3 (c1 TINYINT NOT NULL); 6221CREATE TABLE t4 (c1 TINYINT NOT NULL); 6222CREATE TABLE t5 (c1 TINYINT NOT NULL); 6223CREATE TABLE t6 (c1 TINYINT NOT NULL); 6224INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 6225INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 6226INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 6227INSERT INTO t4 (c1) VALUES(10); 6228INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 6229SELECT t1.c1,t5.c1 FROM t1 LEFT OUTER JOIN t5 ON t1.c1 = t5.c1 ORDER BY t1.c1,t5.c1; 6230c1 c1 62310 NULL 62321 NULL 62332 NULL 62343 NULL 62354 NULL 62365 NULL 62376 NULL 62387 NULL 62398 NULL 62409 NULL 6241SELECT t1.c1,t5.c1 FROM t1 LEFT OUTER JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 <=> 5 ORDER BY t1.c1,t5.c1; 6242c1 c1 62435 NULL 6244DROP TABLE t1,t2,t3,t4,t5,t6; 6245CREATE TABLE t1 (c1 SMALLINT NOT NULL); 6246CREATE TABLE t2 (c1 SMALLINT NOT NULL); 6247CREATE TABLE t3 (c1 SMALLINT NOT NULL); 6248CREATE TABLE t4 (c1 SMALLINT NOT NULL); 6249CREATE TABLE t5 (c1 SMALLINT NOT NULL); 6250CREATE TABLE t6 (c1 SMALLINT NOT NULL); 6251INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 6252INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 6253INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 6254INSERT INTO t4 (c1) VALUES(10); 6255INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 6256SELECT t1.c1,t5.c1 FROM t1 LEFT OUTER JOIN t5 ON t1.c1 = t5.c1 ORDER BY t1.c1,t5.c1; 6257c1 c1 62580 NULL 62591 NULL 62602 NULL 62613 NULL 62624 NULL 62635 NULL 62646 NULL 62657 NULL 62668 NULL 62679 NULL 6268SELECT t1.c1,t5.c1 FROM t1 LEFT OUTER JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 <=> 5 ORDER BY t1.c1,t5.c1; 6269c1 c1 62705 NULL 6271DROP TABLE t1,t2,t3,t4,t5,t6; 6272CREATE TABLE t1 (c1 MEDIUMINT NOT NULL); 6273CREATE TABLE t2 (c1 MEDIUMINT NOT NULL); 6274CREATE TABLE t3 (c1 MEDIUMINT NOT NULL); 6275CREATE TABLE t4 (c1 MEDIUMINT NOT NULL); 6276CREATE TABLE t5 (c1 MEDIUMINT NOT NULL); 6277CREATE TABLE t6 (c1 MEDIUMINT NOT NULL); 6278INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 6279INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 6280INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 6281INSERT INTO t4 (c1) VALUES(10); 6282INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 6283SELECT t1.c1,t5.c1 FROM t1 LEFT OUTER JOIN t5 ON t1.c1 = t5.c1 ORDER BY t1.c1,t5.c1; 6284c1 c1 62850 NULL 62861 NULL 62872 NULL 62883 NULL 62894 NULL 62905 NULL 62916 NULL 62927 NULL 62938 NULL 62949 NULL 6295SELECT t1.c1,t5.c1 FROM t1 LEFT OUTER JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 <=> 5 ORDER BY t1.c1,t5.c1; 6296c1 c1 62975 NULL 6298DROP TABLE t1,t2,t3,t4,t5,t6; 6299CREATE TABLE t1 (c1 INT NOT NULL); 6300CREATE TABLE t2 (c1 INT NOT NULL); 6301CREATE TABLE t3 (c1 INT NOT NULL); 6302CREATE TABLE t4 (c1 INT NOT NULL); 6303CREATE TABLE t5 (c1 INT NOT NULL); 6304CREATE TABLE t6 (c1 INT NOT NULL); 6305INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 6306INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 6307INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 6308INSERT INTO t4 (c1) VALUES(10); 6309INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 6310SELECT t1.c1,t5.c1 FROM t1 LEFT OUTER JOIN t5 ON t1.c1 = t5.c1 ORDER BY t1.c1,t5.c1; 6311c1 c1 63120 NULL 63131 NULL 63142 NULL 63153 NULL 63164 NULL 63175 NULL 63186 NULL 63197 NULL 63208 NULL 63219 NULL 6322SELECT t1.c1,t5.c1 FROM t1 LEFT OUTER JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 <=> 5 ORDER BY t1.c1,t5.c1; 6323c1 c1 63245 NULL 6325DROP TABLE t1,t2,t3,t4,t5,t6; 6326CREATE TABLE t1 (c1 INTEGER NOT NULL); 6327CREATE TABLE t2 (c1 INTEGER NOT NULL); 6328CREATE TABLE t3 (c1 INTEGER NOT NULL); 6329CREATE TABLE t4 (c1 INTEGER NOT NULL); 6330CREATE TABLE t5 (c1 INTEGER NOT NULL); 6331CREATE TABLE t6 (c1 INTEGER NOT NULL); 6332INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 6333INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 6334INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 6335INSERT INTO t4 (c1) VALUES(10); 6336INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 6337SELECT t1.c1,t5.c1 FROM t1 LEFT OUTER JOIN t5 ON t1.c1 = t5.c1 ORDER BY t1.c1,t5.c1; 6338c1 c1 63390 NULL 63401 NULL 63412 NULL 63423 NULL 63434 NULL 63445 NULL 63456 NULL 63467 NULL 63478 NULL 63489 NULL 6349SELECT t1.c1,t5.c1 FROM t1 LEFT OUTER JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 <=> 5 ORDER BY t1.c1,t5.c1; 6350c1 c1 63515 NULL 6352DROP TABLE t1,t2,t3,t4,t5,t6; 6353CREATE TABLE t1 (c1 BIGINT NOT NULL); 6354CREATE TABLE t2 (c1 BIGINT NOT NULL); 6355CREATE TABLE t3 (c1 BIGINT NOT NULL); 6356CREATE TABLE t4 (c1 BIGINT NOT NULL); 6357CREATE TABLE t5 (c1 BIGINT NOT NULL); 6358CREATE TABLE t6 (c1 BIGINT NOT NULL); 6359INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 6360INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 6361INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 6362INSERT INTO t4 (c1) VALUES(10); 6363INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 6364SELECT t1.c1,t5.c1 FROM t1 LEFT OUTER JOIN t5 ON t1.c1 = t5.c1 ORDER BY t1.c1,t5.c1; 6365c1 c1 63660 NULL 63671 NULL 63682 NULL 63693 NULL 63704 NULL 63715 NULL 63726 NULL 63737 NULL 63748 NULL 63759 NULL 6376SELECT t1.c1,t5.c1 FROM t1 LEFT OUTER JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 <=> 5 ORDER BY t1.c1,t5.c1; 6377c1 c1 63785 NULL 6379DROP TABLE t1,t2,t3,t4,t5,t6; 6380CREATE TABLE t1 (c1 TINYINT NOT NULL); 6381CREATE TABLE t2 (c1 TINYINT NOT NULL); 6382CREATE TABLE t3 (c1 TINYINT NOT NULL); 6383CREATE TABLE t4 (c1 TINYINT NOT NULL); 6384CREATE TABLE t5 (c1 TINYINT NOT NULL); 6385CREATE TABLE t6 (c1 TINYINT NOT NULL); 6386INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 6387INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 6388INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 6389INSERT INTO t4 (c1) VALUES(10); 6390INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 6391SELECT t1.c1,t6.c1 FROM t1 LEFT OUTER JOIN t6 ON t1.c1 = t6.c1 ORDER BY t1.c1,t6.c1; 6392c1 c1 63930 NULL 63941 NULL 63952 NULL 63963 NULL 63974 NULL 63985 NULL 63996 NULL 64007 NULL 64018 NULL 64029 NULL 6403SELECT t1.c1,t6.c1 FROM t1 LEFT OUTER JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 <=> 5 ORDER BY t1.c1,t6.c1; 6404c1 c1 64055 NULL 6406DROP TABLE t1,t2,t3,t4,t5,t6; 6407CREATE TABLE t1 (c1 SMALLINT NOT NULL); 6408CREATE TABLE t2 (c1 SMALLINT NOT NULL); 6409CREATE TABLE t3 (c1 SMALLINT NOT NULL); 6410CREATE TABLE t4 (c1 SMALLINT NOT NULL); 6411CREATE TABLE t5 (c1 SMALLINT NOT NULL); 6412CREATE TABLE t6 (c1 SMALLINT NOT NULL); 6413INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 6414INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 6415INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 6416INSERT INTO t4 (c1) VALUES(10); 6417INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 6418SELECT t1.c1,t6.c1 FROM t1 LEFT OUTER JOIN t6 ON t1.c1 = t6.c1 ORDER BY t1.c1,t6.c1; 6419c1 c1 64200 NULL 64211 NULL 64222 NULL 64233 NULL 64244 NULL 64255 NULL 64266 NULL 64277 NULL 64288 NULL 64299 NULL 6430SELECT t1.c1,t6.c1 FROM t1 LEFT OUTER JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 <=> 5 ORDER BY t1.c1,t6.c1; 6431c1 c1 64325 NULL 6433DROP TABLE t1,t2,t3,t4,t5,t6; 6434CREATE TABLE t1 (c1 MEDIUMINT NOT NULL); 6435CREATE TABLE t2 (c1 MEDIUMINT NOT NULL); 6436CREATE TABLE t3 (c1 MEDIUMINT NOT NULL); 6437CREATE TABLE t4 (c1 MEDIUMINT NOT NULL); 6438CREATE TABLE t5 (c1 MEDIUMINT NOT NULL); 6439CREATE TABLE t6 (c1 MEDIUMINT NOT NULL); 6440INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 6441INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 6442INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 6443INSERT INTO t4 (c1) VALUES(10); 6444INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 6445SELECT t1.c1,t6.c1 FROM t1 LEFT OUTER JOIN t6 ON t1.c1 = t6.c1 ORDER BY t1.c1,t6.c1; 6446c1 c1 64470 NULL 64481 NULL 64492 NULL 64503 NULL 64514 NULL 64525 NULL 64536 NULL 64547 NULL 64558 NULL 64569 NULL 6457SELECT t1.c1,t6.c1 FROM t1 LEFT OUTER JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 <=> 5 ORDER BY t1.c1,t6.c1; 6458c1 c1 64595 NULL 6460DROP TABLE t1,t2,t3,t4,t5,t6; 6461CREATE TABLE t1 (c1 INT NOT NULL); 6462CREATE TABLE t2 (c1 INT NOT NULL); 6463CREATE TABLE t3 (c1 INT NOT NULL); 6464CREATE TABLE t4 (c1 INT NOT NULL); 6465CREATE TABLE t5 (c1 INT NOT NULL); 6466CREATE TABLE t6 (c1 INT NOT NULL); 6467INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 6468INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 6469INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 6470INSERT INTO t4 (c1) VALUES(10); 6471INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 6472SELECT t1.c1,t6.c1 FROM t1 LEFT OUTER JOIN t6 ON t1.c1 = t6.c1 ORDER BY t1.c1,t6.c1; 6473c1 c1 64740 NULL 64751 NULL 64762 NULL 64773 NULL 64784 NULL 64795 NULL 64806 NULL 64817 NULL 64828 NULL 64839 NULL 6484SELECT t1.c1,t6.c1 FROM t1 LEFT OUTER JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 <=> 5 ORDER BY t1.c1,t6.c1; 6485c1 c1 64865 NULL 6487DROP TABLE t1,t2,t3,t4,t5,t6; 6488CREATE TABLE t1 (c1 INTEGER NOT NULL); 6489CREATE TABLE t2 (c1 INTEGER NOT NULL); 6490CREATE TABLE t3 (c1 INTEGER NOT NULL); 6491CREATE TABLE t4 (c1 INTEGER NOT NULL); 6492CREATE TABLE t5 (c1 INTEGER NOT NULL); 6493CREATE TABLE t6 (c1 INTEGER NOT NULL); 6494INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 6495INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 6496INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 6497INSERT INTO t4 (c1) VALUES(10); 6498INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 6499SELECT t1.c1,t6.c1 FROM t1 LEFT OUTER JOIN t6 ON t1.c1 = t6.c1 ORDER BY t1.c1,t6.c1; 6500c1 c1 65010 NULL 65021 NULL 65032 NULL 65043 NULL 65054 NULL 65065 NULL 65076 NULL 65087 NULL 65098 NULL 65109 NULL 6511SELECT t1.c1,t6.c1 FROM t1 LEFT OUTER JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 <=> 5 ORDER BY t1.c1,t6.c1; 6512c1 c1 65135 NULL 6514DROP TABLE t1,t2,t3,t4,t5,t6; 6515CREATE TABLE t1 (c1 BIGINT NOT NULL); 6516CREATE TABLE t2 (c1 BIGINT NOT NULL); 6517CREATE TABLE t3 (c1 BIGINT NOT NULL); 6518CREATE TABLE t4 (c1 BIGINT NOT NULL); 6519CREATE TABLE t5 (c1 BIGINT NOT NULL); 6520CREATE TABLE t6 (c1 BIGINT NOT NULL); 6521INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 6522INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 6523INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 6524INSERT INTO t4 (c1) VALUES(10); 6525INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 6526SELECT t1.c1,t6.c1 FROM t1 LEFT OUTER JOIN t6 ON t1.c1 = t6.c1 ORDER BY t1.c1,t6.c1; 6527c1 c1 65280 NULL 65291 NULL 65302 NULL 65313 NULL 65324 NULL 65335 NULL 65346 NULL 65357 NULL 65368 NULL 65379 NULL 6538SELECT t1.c1,t6.c1 FROM t1 LEFT OUTER JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 <=> 5 ORDER BY t1.c1,t6.c1; 6539c1 c1 65405 NULL 6541DROP TABLE t1,t2,t3,t4,t5,t6; 6542