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 CROSS JOIN t2 USING (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 CROSS JOIN t2 ON t1.c1 = t2.c1; 26c1 c1 270 0 281 1 292 2 303 3 314 4 325 5 336 6 347 7 358 8 369 9 37SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 < 5; 38c1 c1 390 0 401 1 412 2 423 3 434 4 44DROP TABLE t1,t2,t3,t4,t5,t6; 45CREATE TABLE t1 (c1 SMALLINT NOT NULL); 46CREATE TABLE t2 (c1 SMALLINT NOT NULL); 47CREATE TABLE t3 (c1 SMALLINT NOT NULL); 48CREATE TABLE t4 (c1 SMALLINT NOT NULL); 49CREATE TABLE t5 (c1 SMALLINT NOT NULL); 50CREATE TABLE t6 (c1 SMALLINT NOT NULL); 51INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 52INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 53INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 54INSERT INTO t4 (c1) VALUES(10); 55INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 56SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 USING (c1); 57c1 c1 580 0 591 1 602 2 613 3 624 4 635 5 646 6 657 7 668 8 679 9 68SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1; 69c1 c1 700 0 711 1 722 2 733 3 744 4 755 5 766 6 777 7 788 8 799 9 80SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 < 5; 81c1 c1 820 0 831 1 842 2 853 3 864 4 87DROP TABLE t1,t2,t3,t4,t5,t6; 88CREATE TABLE t1 (c1 MEDIUMINT NOT NULL); 89CREATE TABLE t2 (c1 MEDIUMINT NOT NULL); 90CREATE TABLE t3 (c1 MEDIUMINT NOT NULL); 91CREATE TABLE t4 (c1 MEDIUMINT NOT NULL); 92CREATE TABLE t5 (c1 MEDIUMINT NOT NULL); 93CREATE TABLE t6 (c1 MEDIUMINT NOT NULL); 94INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 95INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 96INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 97INSERT INTO t4 (c1) VALUES(10); 98INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 99SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 USING (c1); 100c1 c1 1010 0 1021 1 1032 2 1043 3 1054 4 1065 5 1076 6 1087 7 1098 8 1109 9 111SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1; 112c1 c1 1130 0 1141 1 1152 2 1163 3 1174 4 1185 5 1196 6 1207 7 1218 8 1229 9 123SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 < 5; 124c1 c1 1250 0 1261 1 1272 2 1283 3 1294 4 130DROP TABLE t1,t2,t3,t4,t5,t6; 131CREATE TABLE t1 (c1 INT NOT NULL); 132CREATE TABLE t2 (c1 INT NOT NULL); 133CREATE TABLE t3 (c1 INT NOT NULL); 134CREATE TABLE t4 (c1 INT NOT NULL); 135CREATE TABLE t5 (c1 INT NOT NULL); 136CREATE TABLE t6 (c1 INT NOT NULL); 137INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 138INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 139INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 140INSERT INTO t4 (c1) VALUES(10); 141INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 142SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 USING (c1); 143c1 c1 1440 0 1451 1 1462 2 1473 3 1484 4 1495 5 1506 6 1517 7 1528 8 1539 9 154SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1; 155c1 c1 1560 0 1571 1 1582 2 1593 3 1604 4 1615 5 1626 6 1637 7 1648 8 1659 9 166SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 < 5; 167c1 c1 1680 0 1691 1 1702 2 1713 3 1724 4 173DROP TABLE t1,t2,t3,t4,t5,t6; 174CREATE TABLE t1 (c1 INTEGER NOT NULL); 175CREATE TABLE t2 (c1 INTEGER NOT NULL); 176CREATE TABLE t3 (c1 INTEGER NOT NULL); 177CREATE TABLE t4 (c1 INTEGER NOT NULL); 178CREATE TABLE t5 (c1 INTEGER NOT NULL); 179CREATE TABLE t6 (c1 INTEGER NOT NULL); 180INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 181INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 182INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 183INSERT INTO t4 (c1) VALUES(10); 184INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 185SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 USING (c1); 186c1 c1 1870 0 1881 1 1892 2 1903 3 1914 4 1925 5 1936 6 1947 7 1958 8 1969 9 197SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1; 198c1 c1 1990 0 2001 1 2012 2 2023 3 2034 4 2045 5 2056 6 2067 7 2078 8 2089 9 209SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 < 5; 210c1 c1 2110 0 2121 1 2132 2 2143 3 2154 4 216DROP TABLE t1,t2,t3,t4,t5,t6; 217CREATE TABLE t1 (c1 BIGINT NOT NULL); 218CREATE TABLE t2 (c1 BIGINT NOT NULL); 219CREATE TABLE t3 (c1 BIGINT NOT NULL); 220CREATE TABLE t4 (c1 BIGINT NOT NULL); 221CREATE TABLE t5 (c1 BIGINT NOT NULL); 222CREATE TABLE t6 (c1 BIGINT NOT NULL); 223INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 224INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 225INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 226INSERT INTO t4 (c1) VALUES(10); 227INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 228SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 USING (c1); 229c1 c1 2300 0 2311 1 2322 2 2333 3 2344 4 2355 5 2366 6 2377 7 2388 8 2399 9 240SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1; 241c1 c1 2420 0 2431 1 2442 2 2453 3 2464 4 2475 5 2486 6 2497 7 2508 8 2519 9 252SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 < 5; 253c1 c1 2540 0 2551 1 2562 2 2573 3 2584 4 259DROP TABLE t1,t2,t3,t4,t5,t6; 260CREATE TABLE t1 (c1 TINYINT NOT NULL); 261CREATE TABLE t2 (c1 TINYINT NOT NULL); 262CREATE TABLE t3 (c1 TINYINT NOT NULL); 263CREATE TABLE t4 (c1 TINYINT NOT NULL); 264CREATE TABLE t5 (c1 TINYINT NOT NULL); 265CREATE TABLE t6 (c1 TINYINT NOT NULL); 266INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 267INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 268INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 269INSERT INTO t4 (c1) VALUES(10); 270INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 271SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 USING (c1); 272c1 c1 2731 1 2743 3 2755 5 2767 7 2779 9 278SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1; 279c1 c1 2801 1 2813 3 2825 5 2837 7 2849 9 285SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 < 5; 286c1 c1 2871 1 2883 3 289DROP TABLE t1,t2,t3,t4,t5,t6; 290CREATE TABLE t1 (c1 SMALLINT NOT NULL); 291CREATE TABLE t2 (c1 SMALLINT NOT NULL); 292CREATE TABLE t3 (c1 SMALLINT NOT NULL); 293CREATE TABLE t4 (c1 SMALLINT NOT NULL); 294CREATE TABLE t5 (c1 SMALLINT NOT NULL); 295CREATE TABLE t6 (c1 SMALLINT NOT NULL); 296INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 297INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 298INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 299INSERT INTO t4 (c1) VALUES(10); 300INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 301SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 USING (c1); 302c1 c1 3031 1 3043 3 3055 5 3067 7 3079 9 308SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1; 309c1 c1 3101 1 3113 3 3125 5 3137 7 3149 9 315SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 < 5; 316c1 c1 3171 1 3183 3 319DROP TABLE t1,t2,t3,t4,t5,t6; 320CREATE TABLE t1 (c1 MEDIUMINT NOT NULL); 321CREATE TABLE t2 (c1 MEDIUMINT NOT NULL); 322CREATE TABLE t3 (c1 MEDIUMINT NOT NULL); 323CREATE TABLE t4 (c1 MEDIUMINT NOT NULL); 324CREATE TABLE t5 (c1 MEDIUMINT NOT NULL); 325CREATE TABLE t6 (c1 MEDIUMINT NOT NULL); 326INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 327INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 328INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 329INSERT INTO t4 (c1) VALUES(10); 330INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 331SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 USING (c1); 332c1 c1 3331 1 3343 3 3355 5 3367 7 3379 9 338SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1; 339c1 c1 3401 1 3413 3 3425 5 3437 7 3449 9 345SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 < 5; 346c1 c1 3471 1 3483 3 349DROP TABLE t1,t2,t3,t4,t5,t6; 350CREATE TABLE t1 (c1 INT NOT NULL); 351CREATE TABLE t2 (c1 INT NOT NULL); 352CREATE TABLE t3 (c1 INT NOT NULL); 353CREATE TABLE t4 (c1 INT NOT NULL); 354CREATE TABLE t5 (c1 INT NOT NULL); 355CREATE TABLE t6 (c1 INT NOT NULL); 356INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 357INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 358INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 359INSERT INTO t4 (c1) VALUES(10); 360INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 361SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 USING (c1); 362c1 c1 3631 1 3643 3 3655 5 3667 7 3679 9 368SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1; 369c1 c1 3701 1 3713 3 3725 5 3737 7 3749 9 375SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 < 5; 376c1 c1 3771 1 3783 3 379DROP TABLE t1,t2,t3,t4,t5,t6; 380CREATE TABLE t1 (c1 INTEGER NOT NULL); 381CREATE TABLE t2 (c1 INTEGER NOT NULL); 382CREATE TABLE t3 (c1 INTEGER NOT NULL); 383CREATE TABLE t4 (c1 INTEGER NOT NULL); 384CREATE TABLE t5 (c1 INTEGER NOT NULL); 385CREATE TABLE t6 (c1 INTEGER NOT NULL); 386INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 387INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 388INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 389INSERT INTO t4 (c1) VALUES(10); 390INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 391SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 USING (c1); 392c1 c1 3931 1 3943 3 3955 5 3967 7 3979 9 398SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1; 399c1 c1 4001 1 4013 3 4025 5 4037 7 4049 9 405SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 < 5; 406c1 c1 4071 1 4083 3 409DROP TABLE t1,t2,t3,t4,t5,t6; 410CREATE TABLE t1 (c1 BIGINT NOT NULL); 411CREATE TABLE t2 (c1 BIGINT NOT NULL); 412CREATE TABLE t3 (c1 BIGINT NOT NULL); 413CREATE TABLE t4 (c1 BIGINT NOT NULL); 414CREATE TABLE t5 (c1 BIGINT NOT NULL); 415CREATE TABLE t6 (c1 BIGINT NOT NULL); 416INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 417INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 418INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 419INSERT INTO t4 (c1) VALUES(10); 420INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 421SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 USING (c1); 422c1 c1 4231 1 4243 3 4255 5 4267 7 4279 9 428SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1; 429c1 c1 4301 1 4313 3 4325 5 4337 7 4349 9 435SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 < 5; 436c1 c1 4371 1 4383 3 439DROP TABLE t1,t2,t3,t4,t5,t6; 440CREATE TABLE t1 (c1 TINYINT NOT NULL); 441CREATE TABLE t2 (c1 TINYINT NOT NULL); 442CREATE TABLE t3 (c1 TINYINT NOT NULL); 443CREATE TABLE t4 (c1 TINYINT NOT NULL); 444CREATE TABLE t5 (c1 TINYINT NOT NULL); 445CREATE TABLE t6 (c1 TINYINT NOT NULL); 446INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 447INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 448INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 449INSERT INTO t4 (c1) VALUES(10); 450INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 451SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 USING (c1); 452c1 c1 453SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1; 454c1 c1 455SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 < 5; 456c1 c1 457DROP TABLE t1,t2,t3,t4,t5,t6; 458CREATE TABLE t1 (c1 SMALLINT NOT NULL); 459CREATE TABLE t2 (c1 SMALLINT NOT NULL); 460CREATE TABLE t3 (c1 SMALLINT NOT NULL); 461CREATE TABLE t4 (c1 SMALLINT NOT NULL); 462CREATE TABLE t5 (c1 SMALLINT NOT NULL); 463CREATE TABLE t6 (c1 SMALLINT NOT NULL); 464INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 465INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 466INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 467INSERT INTO t4 (c1) VALUES(10); 468INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 469SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 USING (c1); 470c1 c1 471SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1; 472c1 c1 473SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 < 5; 474c1 c1 475DROP TABLE t1,t2,t3,t4,t5,t6; 476CREATE TABLE t1 (c1 MEDIUMINT NOT NULL); 477CREATE TABLE t2 (c1 MEDIUMINT NOT NULL); 478CREATE TABLE t3 (c1 MEDIUMINT NOT NULL); 479CREATE TABLE t4 (c1 MEDIUMINT NOT NULL); 480CREATE TABLE t5 (c1 MEDIUMINT NOT NULL); 481CREATE TABLE t6 (c1 MEDIUMINT NOT NULL); 482INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 483INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 484INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 485INSERT INTO t4 (c1) VALUES(10); 486INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 487SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 USING (c1); 488c1 c1 489SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1; 490c1 c1 491SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 < 5; 492c1 c1 493DROP TABLE t1,t2,t3,t4,t5,t6; 494CREATE TABLE t1 (c1 INT NOT NULL); 495CREATE TABLE t2 (c1 INT NOT NULL); 496CREATE TABLE t3 (c1 INT NOT NULL); 497CREATE TABLE t4 (c1 INT NOT NULL); 498CREATE TABLE t5 (c1 INT NOT NULL); 499CREATE TABLE t6 (c1 INT NOT NULL); 500INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 501INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 502INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 503INSERT INTO t4 (c1) VALUES(10); 504INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 505SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 USING (c1); 506c1 c1 507SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1; 508c1 c1 509SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 < 5; 510c1 c1 511DROP TABLE t1,t2,t3,t4,t5,t6; 512CREATE TABLE t1 (c1 INTEGER NOT NULL); 513CREATE TABLE t2 (c1 INTEGER NOT NULL); 514CREATE TABLE t3 (c1 INTEGER NOT NULL); 515CREATE TABLE t4 (c1 INTEGER NOT NULL); 516CREATE TABLE t5 (c1 INTEGER NOT NULL); 517CREATE TABLE t6 (c1 INTEGER NOT NULL); 518INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 519INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 520INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 521INSERT INTO t4 (c1) VALUES(10); 522INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 523SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 USING (c1); 524c1 c1 525SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1; 526c1 c1 527SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 < 5; 528c1 c1 529DROP TABLE t1,t2,t3,t4,t5,t6; 530CREATE TABLE t1 (c1 BIGINT NOT NULL); 531CREATE TABLE t2 (c1 BIGINT NOT NULL); 532CREATE TABLE t3 (c1 BIGINT NOT NULL); 533CREATE TABLE t4 (c1 BIGINT NOT NULL); 534CREATE TABLE t5 (c1 BIGINT NOT NULL); 535CREATE TABLE t6 (c1 BIGINT NOT NULL); 536INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 537INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 538INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 539INSERT INTO t4 (c1) VALUES(10); 540INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 541SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 USING (c1); 542c1 c1 543SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1; 544c1 c1 545SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 < 5; 546c1 c1 547DROP TABLE t1,t2,t3,t4,t5,t6; 548CREATE TABLE t1 (c1 TINYINT NOT NULL); 549CREATE TABLE t2 (c1 TINYINT NOT NULL); 550CREATE TABLE t3 (c1 TINYINT NOT NULL); 551CREATE TABLE t4 (c1 TINYINT NOT NULL); 552CREATE TABLE t5 (c1 TINYINT NOT NULL); 553CREATE TABLE t6 (c1 TINYINT NOT NULL); 554INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 555INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 556INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 557INSERT INTO t4 (c1) VALUES(10); 558INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 559SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 USING (c1); 560c1 c1 561SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1; 562c1 c1 563SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 < 5; 564c1 c1 565DROP TABLE t1,t2,t3,t4,t5,t6; 566CREATE TABLE t1 (c1 SMALLINT NOT NULL); 567CREATE TABLE t2 (c1 SMALLINT NOT NULL); 568CREATE TABLE t3 (c1 SMALLINT NOT NULL); 569CREATE TABLE t4 (c1 SMALLINT NOT NULL); 570CREATE TABLE t5 (c1 SMALLINT NOT NULL); 571CREATE TABLE t6 (c1 SMALLINT NOT NULL); 572INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 573INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 574INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 575INSERT INTO t4 (c1) VALUES(10); 576INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 577SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 USING (c1); 578c1 c1 579SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1; 580c1 c1 581SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 < 5; 582c1 c1 583DROP TABLE t1,t2,t3,t4,t5,t6; 584CREATE TABLE t1 (c1 MEDIUMINT NOT NULL); 585CREATE TABLE t2 (c1 MEDIUMINT NOT NULL); 586CREATE TABLE t3 (c1 MEDIUMINT NOT NULL); 587CREATE TABLE t4 (c1 MEDIUMINT NOT NULL); 588CREATE TABLE t5 (c1 MEDIUMINT NOT NULL); 589CREATE TABLE t6 (c1 MEDIUMINT NOT NULL); 590INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 591INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 592INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 593INSERT INTO t4 (c1) VALUES(10); 594INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 595SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 USING (c1); 596c1 c1 597SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1; 598c1 c1 599SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 < 5; 600c1 c1 601DROP TABLE t1,t2,t3,t4,t5,t6; 602CREATE TABLE t1 (c1 INT NOT NULL); 603CREATE TABLE t2 (c1 INT NOT NULL); 604CREATE TABLE t3 (c1 INT NOT NULL); 605CREATE TABLE t4 (c1 INT NOT NULL); 606CREATE TABLE t5 (c1 INT NOT NULL); 607CREATE TABLE t6 (c1 INT NOT NULL); 608INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 609INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 610INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 611INSERT INTO t4 (c1) VALUES(10); 612INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 613SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 USING (c1); 614c1 c1 615SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1; 616c1 c1 617SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 < 5; 618c1 c1 619DROP TABLE t1,t2,t3,t4,t5,t6; 620CREATE TABLE t1 (c1 INTEGER NOT NULL); 621CREATE TABLE t2 (c1 INTEGER NOT NULL); 622CREATE TABLE t3 (c1 INTEGER NOT NULL); 623CREATE TABLE t4 (c1 INTEGER NOT NULL); 624CREATE TABLE t5 (c1 INTEGER NOT NULL); 625CREATE TABLE t6 (c1 INTEGER NOT NULL); 626INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 627INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 628INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 629INSERT INTO t4 (c1) VALUES(10); 630INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 631SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 USING (c1); 632c1 c1 633SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1; 634c1 c1 635SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 < 5; 636c1 c1 637DROP TABLE t1,t2,t3,t4,t5,t6; 638CREATE TABLE t1 (c1 BIGINT NOT NULL); 639CREATE TABLE t2 (c1 BIGINT NOT NULL); 640CREATE TABLE t3 (c1 BIGINT NOT NULL); 641CREATE TABLE t4 (c1 BIGINT NOT NULL); 642CREATE TABLE t5 (c1 BIGINT NOT NULL); 643CREATE TABLE t6 (c1 BIGINT NOT NULL); 644INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 645INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 646INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 647INSERT INTO t4 (c1) VALUES(10); 648INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 649SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 USING (c1); 650c1 c1 651SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1; 652c1 c1 653SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 < 5; 654c1 c1 655DROP TABLE t1,t2,t3,t4,t5,t6; 656CREATE TABLE t1 (c1 TINYINT NOT NULL); 657CREATE TABLE t2 (c1 TINYINT NOT NULL); 658CREATE TABLE t3 (c1 TINYINT NOT NULL); 659CREATE TABLE t4 (c1 TINYINT NOT NULL); 660CREATE TABLE t5 (c1 TINYINT NOT NULL); 661CREATE TABLE t6 (c1 TINYINT NOT NULL); 662INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 663INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 664INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 665INSERT INTO t4 (c1) VALUES(10); 666INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 667SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 USING (c1); 668c1 c1 669SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1; 670c1 c1 671SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 < 5; 672c1 c1 673DROP TABLE t1,t2,t3,t4,t5,t6; 674CREATE TABLE t1 (c1 SMALLINT NOT NULL); 675CREATE TABLE t2 (c1 SMALLINT NOT NULL); 676CREATE TABLE t3 (c1 SMALLINT NOT NULL); 677CREATE TABLE t4 (c1 SMALLINT NOT NULL); 678CREATE TABLE t5 (c1 SMALLINT NOT NULL); 679CREATE TABLE t6 (c1 SMALLINT NOT NULL); 680INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 681INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 682INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 683INSERT INTO t4 (c1) VALUES(10); 684INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 685SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 USING (c1); 686c1 c1 687SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1; 688c1 c1 689SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 < 5; 690c1 c1 691DROP TABLE t1,t2,t3,t4,t5,t6; 692CREATE TABLE t1 (c1 MEDIUMINT NOT NULL); 693CREATE TABLE t2 (c1 MEDIUMINT NOT NULL); 694CREATE TABLE t3 (c1 MEDIUMINT NOT NULL); 695CREATE TABLE t4 (c1 MEDIUMINT NOT NULL); 696CREATE TABLE t5 (c1 MEDIUMINT NOT NULL); 697CREATE TABLE t6 (c1 MEDIUMINT NOT NULL); 698INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 699INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 700INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 701INSERT INTO t4 (c1) VALUES(10); 702INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 703SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 USING (c1); 704c1 c1 705SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1; 706c1 c1 707SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 < 5; 708c1 c1 709DROP TABLE t1,t2,t3,t4,t5,t6; 710CREATE TABLE t1 (c1 INT NOT NULL); 711CREATE TABLE t2 (c1 INT NOT NULL); 712CREATE TABLE t3 (c1 INT NOT NULL); 713CREATE TABLE t4 (c1 INT NOT NULL); 714CREATE TABLE t5 (c1 INT NOT NULL); 715CREATE TABLE t6 (c1 INT NOT NULL); 716INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 717INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 718INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 719INSERT INTO t4 (c1) VALUES(10); 720INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 721SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 USING (c1); 722c1 c1 723SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1; 724c1 c1 725SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 < 5; 726c1 c1 727DROP TABLE t1,t2,t3,t4,t5,t6; 728CREATE TABLE t1 (c1 INTEGER NOT NULL); 729CREATE TABLE t2 (c1 INTEGER NOT NULL); 730CREATE TABLE t3 (c1 INTEGER NOT NULL); 731CREATE TABLE t4 (c1 INTEGER NOT NULL); 732CREATE TABLE t5 (c1 INTEGER NOT NULL); 733CREATE TABLE t6 (c1 INTEGER NOT NULL); 734INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 735INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 736INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 737INSERT INTO t4 (c1) VALUES(10); 738INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 739SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 USING (c1); 740c1 c1 741SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1; 742c1 c1 743SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 < 5; 744c1 c1 745DROP TABLE t1,t2,t3,t4,t5,t6; 746CREATE TABLE t1 (c1 BIGINT NOT NULL); 747CREATE TABLE t2 (c1 BIGINT NOT NULL); 748CREATE TABLE t3 (c1 BIGINT NOT NULL); 749CREATE TABLE t4 (c1 BIGINT NOT NULL); 750CREATE TABLE t5 (c1 BIGINT NOT NULL); 751CREATE TABLE t6 (c1 BIGINT 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 CROSS JOIN t6 USING (c1); 758c1 c1 759SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1; 760c1 c1 761SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 < 5; 762c1 c1 763DROP TABLE t1,t2,t3,t4,t5,t6; 764CREATE TABLE t1 (c1 TINYINT NOT NULL); 765CREATE TABLE t2 (c1 TINYINT NOT NULL); 766CREATE TABLE t3 (c1 TINYINT NOT NULL); 767CREATE TABLE t4 (c1 TINYINT NOT NULL); 768CREATE TABLE t5 (c1 TINYINT NOT NULL); 769CREATE TABLE t6 (c1 TINYINT NOT NULL); 770INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 771INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 772INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 773INSERT INTO t4 (c1) VALUES(10); 774INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 775SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 USING (c1); 776c1 c1 7770 0 7781 1 7792 2 7803 3 7814 4 7825 5 7836 6 7847 7 7858 8 7869 9 787SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1; 788c1 c1 7890 0 7901 1 7912 2 7923 3 7934 4 7945 5 7956 6 7967 7 7978 8 7989 9 799SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 <= 5; 800c1 c1 8010 0 8021 1 8032 2 8043 3 8054 4 8065 5 807DROP TABLE t1,t2,t3,t4,t5,t6; 808CREATE TABLE t1 (c1 SMALLINT NOT NULL); 809CREATE TABLE t2 (c1 SMALLINT NOT NULL); 810CREATE TABLE t3 (c1 SMALLINT NOT NULL); 811CREATE TABLE t4 (c1 SMALLINT NOT NULL); 812CREATE TABLE t5 (c1 SMALLINT NOT NULL); 813CREATE TABLE t6 (c1 SMALLINT 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,t2.c1 FROM t1 CROSS JOIN t2 USING (c1); 820c1 c1 8210 0 8221 1 8232 2 8243 3 8254 4 8265 5 8276 6 8287 7 8298 8 8309 9 831SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1; 832c1 c1 8330 0 8341 1 8352 2 8363 3 8374 4 8385 5 8396 6 8407 7 8418 8 8429 9 843SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 <= 5; 844c1 c1 8450 0 8461 1 8472 2 8483 3 8494 4 8505 5 851DROP TABLE t1,t2,t3,t4,t5,t6; 852CREATE TABLE t1 (c1 MEDIUMINT NOT NULL); 853CREATE TABLE t2 (c1 MEDIUMINT NOT NULL); 854CREATE TABLE t3 (c1 MEDIUMINT NOT NULL); 855CREATE TABLE t4 (c1 MEDIUMINT NOT NULL); 856CREATE TABLE t5 (c1 MEDIUMINT NOT NULL); 857CREATE TABLE t6 (c1 MEDIUMINT NOT NULL); 858INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 859INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 860INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 861INSERT INTO t4 (c1) VALUES(10); 862INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 863SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 USING (c1); 864c1 c1 8650 0 8661 1 8672 2 8683 3 8694 4 8705 5 8716 6 8727 7 8738 8 8749 9 875SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1; 876c1 c1 8770 0 8781 1 8792 2 8803 3 8814 4 8825 5 8836 6 8847 7 8858 8 8869 9 887SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 <= 5; 888c1 c1 8890 0 8901 1 8912 2 8923 3 8934 4 8945 5 895DROP TABLE t1,t2,t3,t4,t5,t6; 896CREATE TABLE t1 (c1 INT NOT NULL); 897CREATE TABLE t2 (c1 INT NOT NULL); 898CREATE TABLE t3 (c1 INT NOT NULL); 899CREATE TABLE t4 (c1 INT NOT NULL); 900CREATE TABLE t5 (c1 INT NOT NULL); 901CREATE TABLE t6 (c1 INT NOT NULL); 902INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 903INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 904INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 905INSERT INTO t4 (c1) VALUES(10); 906INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 907SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 USING (c1); 908c1 c1 9090 0 9101 1 9112 2 9123 3 9134 4 9145 5 9156 6 9167 7 9178 8 9189 9 919SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1; 920c1 c1 9210 0 9221 1 9232 2 9243 3 9254 4 9265 5 9276 6 9287 7 9298 8 9309 9 931SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 <= 5; 932c1 c1 9330 0 9341 1 9352 2 9363 3 9374 4 9385 5 939DROP TABLE t1,t2,t3,t4,t5,t6; 940CREATE TABLE t1 (c1 INTEGER NOT NULL); 941CREATE TABLE t2 (c1 INTEGER NOT NULL); 942CREATE TABLE t3 (c1 INTEGER NOT NULL); 943CREATE TABLE t4 (c1 INTEGER NOT NULL); 944CREATE TABLE t5 (c1 INTEGER NOT NULL); 945CREATE TABLE t6 (c1 INTEGER NOT NULL); 946INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 947INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 948INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 949INSERT INTO t4 (c1) VALUES(10); 950INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 951SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 USING (c1); 952c1 c1 9530 0 9541 1 9552 2 9563 3 9574 4 9585 5 9596 6 9607 7 9618 8 9629 9 963SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1; 964c1 c1 9650 0 9661 1 9672 2 9683 3 9694 4 9705 5 9716 6 9727 7 9738 8 9749 9 975SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 <= 5; 976c1 c1 9770 0 9781 1 9792 2 9803 3 9814 4 9825 5 983DROP TABLE t1,t2,t3,t4,t5,t6; 984CREATE TABLE t1 (c1 BIGINT NOT NULL); 985CREATE TABLE t2 (c1 BIGINT NOT NULL); 986CREATE TABLE t3 (c1 BIGINT NOT NULL); 987CREATE TABLE t4 (c1 BIGINT NOT NULL); 988CREATE TABLE t5 (c1 BIGINT NOT NULL); 989CREATE TABLE t6 (c1 BIGINT NOT NULL); 990INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 991INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 992INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 993INSERT INTO t4 (c1) VALUES(10); 994INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 995SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 USING (c1); 996c1 c1 9970 0 9981 1 9992 2 10003 3 10014 4 10025 5 10036 6 10047 7 10058 8 10069 9 1007SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON 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 CROSS JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 <= 5; 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 TINYINT NOT NULL); 1029CREATE TABLE t2 (c1 TINYINT NOT NULL); 1030CREATE TABLE t3 (c1 TINYINT NOT NULL); 1031CREATE TABLE t4 (c1 TINYINT NOT NULL); 1032CREATE TABLE t5 (c1 TINYINT NOT NULL); 1033CREATE TABLE t6 (c1 TINYINT 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,t3.c1 FROM t1 CROSS JOIN t3 USING (c1); 1040c1 c1 10411 1 10423 3 10435 5 10447 7 10459 9 1046SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1; 1047c1 c1 10481 1 10493 3 10505 5 10517 7 10529 9 1053SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 <= 5; 1054c1 c1 10551 1 10563 3 10575 5 1058DROP TABLE t1,t2,t3,t4,t5,t6; 1059CREATE TABLE t1 (c1 SMALLINT NOT NULL); 1060CREATE TABLE t2 (c1 SMALLINT NOT NULL); 1061CREATE TABLE t3 (c1 SMALLINT NOT NULL); 1062CREATE TABLE t4 (c1 SMALLINT NOT NULL); 1063CREATE TABLE t5 (c1 SMALLINT NOT NULL); 1064CREATE TABLE t6 (c1 SMALLINT NOT NULL); 1065INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1066INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1067INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 1068INSERT INTO t4 (c1) VALUES(10); 1069INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 1070SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 USING (c1); 1071c1 c1 10721 1 10733 3 10745 5 10757 7 10769 9 1077SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1; 1078c1 c1 10791 1 10803 3 10815 5 10827 7 10839 9 1084SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 <= 5; 1085c1 c1 10861 1 10873 3 10885 5 1089DROP TABLE t1,t2,t3,t4,t5,t6; 1090CREATE TABLE t1 (c1 MEDIUMINT NOT NULL); 1091CREATE TABLE t2 (c1 MEDIUMINT NOT NULL); 1092CREATE TABLE t3 (c1 MEDIUMINT NOT NULL); 1093CREATE TABLE t4 (c1 MEDIUMINT NOT NULL); 1094CREATE TABLE t5 (c1 MEDIUMINT NOT NULL); 1095CREATE TABLE t6 (c1 MEDIUMINT NOT NULL); 1096INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1097INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1098INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 1099INSERT INTO t4 (c1) VALUES(10); 1100INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 1101SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 USING (c1); 1102c1 c1 11031 1 11043 3 11055 5 11067 7 11079 9 1108SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1; 1109c1 c1 11101 1 11113 3 11125 5 11137 7 11149 9 1115SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 <= 5; 1116c1 c1 11171 1 11183 3 11195 5 1120DROP TABLE t1,t2,t3,t4,t5,t6; 1121CREATE TABLE t1 (c1 INT NOT NULL); 1122CREATE TABLE t2 (c1 INT NOT NULL); 1123CREATE TABLE t3 (c1 INT NOT NULL); 1124CREATE TABLE t4 (c1 INT NOT NULL); 1125CREATE TABLE t5 (c1 INT NOT NULL); 1126CREATE TABLE t6 (c1 INT NOT NULL); 1127INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1128INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1129INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 1130INSERT INTO t4 (c1) VALUES(10); 1131INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 1132SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 USING (c1); 1133c1 c1 11341 1 11353 3 11365 5 11377 7 11389 9 1139SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1; 1140c1 c1 11411 1 11423 3 11435 5 11447 7 11459 9 1146SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 <= 5; 1147c1 c1 11481 1 11493 3 11505 5 1151DROP TABLE t1,t2,t3,t4,t5,t6; 1152CREATE TABLE t1 (c1 INTEGER NOT NULL); 1153CREATE TABLE t2 (c1 INTEGER NOT NULL); 1154CREATE TABLE t3 (c1 INTEGER NOT NULL); 1155CREATE TABLE t4 (c1 INTEGER NOT NULL); 1156CREATE TABLE t5 (c1 INTEGER NOT NULL); 1157CREATE TABLE t6 (c1 INTEGER NOT NULL); 1158INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1159INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1160INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 1161INSERT INTO t4 (c1) VALUES(10); 1162INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 1163SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 USING (c1); 1164c1 c1 11651 1 11663 3 11675 5 11687 7 11699 9 1170SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1; 1171c1 c1 11721 1 11733 3 11745 5 11757 7 11769 9 1177SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 <= 5; 1178c1 c1 11791 1 11803 3 11815 5 1182DROP TABLE t1,t2,t3,t4,t5,t6; 1183CREATE TABLE t1 (c1 BIGINT NOT NULL); 1184CREATE TABLE t2 (c1 BIGINT NOT NULL); 1185CREATE TABLE t3 (c1 BIGINT NOT NULL); 1186CREATE TABLE t4 (c1 BIGINT NOT NULL); 1187CREATE TABLE t5 (c1 BIGINT NOT NULL); 1188CREATE TABLE t6 (c1 BIGINT NOT NULL); 1189INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1190INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1191INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 1192INSERT INTO t4 (c1) VALUES(10); 1193INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 1194SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 USING (c1); 1195c1 c1 11961 1 11973 3 11985 5 11997 7 12009 9 1201SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1; 1202c1 c1 12031 1 12043 3 12055 5 12067 7 12079 9 1208SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 <= 5; 1209c1 c1 12101 1 12113 3 12125 5 1213DROP TABLE t1,t2,t3,t4,t5,t6; 1214CREATE TABLE t1 (c1 TINYINT NOT NULL); 1215CREATE TABLE t2 (c1 TINYINT NOT NULL); 1216CREATE TABLE t3 (c1 TINYINT NOT NULL); 1217CREATE TABLE t4 (c1 TINYINT NOT NULL); 1218CREATE TABLE t5 (c1 TINYINT NOT NULL); 1219CREATE TABLE t6 (c1 TINYINT NOT NULL); 1220INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1221INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1222INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 1223INSERT INTO t4 (c1) VALUES(10); 1224INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 1225SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 USING (c1); 1226c1 c1 1227SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1; 1228c1 c1 1229SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 <= 5; 1230c1 c1 1231DROP TABLE t1,t2,t3,t4,t5,t6; 1232CREATE TABLE t1 (c1 SMALLINT NOT NULL); 1233CREATE TABLE t2 (c1 SMALLINT NOT NULL); 1234CREATE TABLE t3 (c1 SMALLINT NOT NULL); 1235CREATE TABLE t4 (c1 SMALLINT NOT NULL); 1236CREATE TABLE t5 (c1 SMALLINT NOT NULL); 1237CREATE TABLE t6 (c1 SMALLINT NOT NULL); 1238INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1239INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1240INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 1241INSERT INTO t4 (c1) VALUES(10); 1242INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 1243SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 USING (c1); 1244c1 c1 1245SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1; 1246c1 c1 1247SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 <= 5; 1248c1 c1 1249DROP TABLE t1,t2,t3,t4,t5,t6; 1250CREATE TABLE t1 (c1 MEDIUMINT NOT NULL); 1251CREATE TABLE t2 (c1 MEDIUMINT NOT NULL); 1252CREATE TABLE t3 (c1 MEDIUMINT NOT NULL); 1253CREATE TABLE t4 (c1 MEDIUMINT NOT NULL); 1254CREATE TABLE t5 (c1 MEDIUMINT NOT NULL); 1255CREATE TABLE t6 (c1 MEDIUMINT NOT NULL); 1256INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1257INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1258INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 1259INSERT INTO t4 (c1) VALUES(10); 1260INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 1261SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 USING (c1); 1262c1 c1 1263SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1; 1264c1 c1 1265SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 <= 5; 1266c1 c1 1267DROP TABLE t1,t2,t3,t4,t5,t6; 1268CREATE TABLE t1 (c1 INT NOT NULL); 1269CREATE TABLE t2 (c1 INT NOT NULL); 1270CREATE TABLE t3 (c1 INT NOT NULL); 1271CREATE TABLE t4 (c1 INT NOT NULL); 1272CREATE TABLE t5 (c1 INT NOT NULL); 1273CREATE TABLE t6 (c1 INT NOT NULL); 1274INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1275INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1276INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 1277INSERT INTO t4 (c1) VALUES(10); 1278INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 1279SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 USING (c1); 1280c1 c1 1281SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1; 1282c1 c1 1283SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 <= 5; 1284c1 c1 1285DROP TABLE t1,t2,t3,t4,t5,t6; 1286CREATE TABLE t1 (c1 INTEGER NOT NULL); 1287CREATE TABLE t2 (c1 INTEGER NOT NULL); 1288CREATE TABLE t3 (c1 INTEGER NOT NULL); 1289CREATE TABLE t4 (c1 INTEGER NOT NULL); 1290CREATE TABLE t5 (c1 INTEGER NOT NULL); 1291CREATE TABLE t6 (c1 INTEGER NOT NULL); 1292INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1293INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1294INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 1295INSERT INTO t4 (c1) VALUES(10); 1296INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 1297SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 USING (c1); 1298c1 c1 1299SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1; 1300c1 c1 1301SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 <= 5; 1302c1 c1 1303DROP TABLE t1,t2,t3,t4,t5,t6; 1304CREATE TABLE t1 (c1 BIGINT NOT NULL); 1305CREATE TABLE t2 (c1 BIGINT NOT NULL); 1306CREATE TABLE t3 (c1 BIGINT NOT NULL); 1307CREATE TABLE t4 (c1 BIGINT NOT NULL); 1308CREATE TABLE t5 (c1 BIGINT NOT NULL); 1309CREATE TABLE t6 (c1 BIGINT NOT NULL); 1310INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1311INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1312INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 1313INSERT INTO t4 (c1) VALUES(10); 1314INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 1315SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 USING (c1); 1316c1 c1 1317SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1; 1318c1 c1 1319SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 <= 5; 1320c1 c1 1321DROP TABLE t1,t2,t3,t4,t5,t6; 1322CREATE TABLE t1 (c1 TINYINT NOT NULL); 1323CREATE TABLE t2 (c1 TINYINT NOT NULL); 1324CREATE TABLE t3 (c1 TINYINT NOT NULL); 1325CREATE TABLE t4 (c1 TINYINT NOT NULL); 1326CREATE TABLE t5 (c1 TINYINT NOT NULL); 1327CREATE TABLE t6 (c1 TINYINT NOT NULL); 1328INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1329INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1330INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 1331INSERT INTO t4 (c1) VALUES(10); 1332INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 1333SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 USING (c1); 1334c1 c1 1335SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1; 1336c1 c1 1337SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 <= 5; 1338c1 c1 1339DROP TABLE t1,t2,t3,t4,t5,t6; 1340CREATE TABLE t1 (c1 SMALLINT NOT NULL); 1341CREATE TABLE t2 (c1 SMALLINT NOT NULL); 1342CREATE TABLE t3 (c1 SMALLINT NOT NULL); 1343CREATE TABLE t4 (c1 SMALLINT NOT NULL); 1344CREATE TABLE t5 (c1 SMALLINT NOT NULL); 1345CREATE TABLE t6 (c1 SMALLINT NOT NULL); 1346INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1347INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1348INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 1349INSERT INTO t4 (c1) VALUES(10); 1350INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 1351SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 USING (c1); 1352c1 c1 1353SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1; 1354c1 c1 1355SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 <= 5; 1356c1 c1 1357DROP TABLE t1,t2,t3,t4,t5,t6; 1358CREATE TABLE t1 (c1 MEDIUMINT NOT NULL); 1359CREATE TABLE t2 (c1 MEDIUMINT NOT NULL); 1360CREATE TABLE t3 (c1 MEDIUMINT NOT NULL); 1361CREATE TABLE t4 (c1 MEDIUMINT NOT NULL); 1362CREATE TABLE t5 (c1 MEDIUMINT NOT NULL); 1363CREATE TABLE t6 (c1 MEDIUMINT NOT NULL); 1364INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1365INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1366INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 1367INSERT INTO t4 (c1) VALUES(10); 1368INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 1369SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 USING (c1); 1370c1 c1 1371SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1; 1372c1 c1 1373SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 <= 5; 1374c1 c1 1375DROP TABLE t1,t2,t3,t4,t5,t6; 1376CREATE TABLE t1 (c1 INT NOT NULL); 1377CREATE TABLE t2 (c1 INT NOT NULL); 1378CREATE TABLE t3 (c1 INT NOT NULL); 1379CREATE TABLE t4 (c1 INT NOT NULL); 1380CREATE TABLE t5 (c1 INT NOT NULL); 1381CREATE TABLE t6 (c1 INT NOT NULL); 1382INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1383INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1384INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 1385INSERT INTO t4 (c1) VALUES(10); 1386INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 1387SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 USING (c1); 1388c1 c1 1389SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1; 1390c1 c1 1391SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 <= 5; 1392c1 c1 1393DROP TABLE t1,t2,t3,t4,t5,t6; 1394CREATE TABLE t1 (c1 INTEGER NOT NULL); 1395CREATE TABLE t2 (c1 INTEGER NOT NULL); 1396CREATE TABLE t3 (c1 INTEGER NOT NULL); 1397CREATE TABLE t4 (c1 INTEGER NOT NULL); 1398CREATE TABLE t5 (c1 INTEGER NOT NULL); 1399CREATE TABLE t6 (c1 INTEGER NOT NULL); 1400INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1401INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1402INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 1403INSERT INTO t4 (c1) VALUES(10); 1404INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 1405SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 USING (c1); 1406c1 c1 1407SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1; 1408c1 c1 1409SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 <= 5; 1410c1 c1 1411DROP TABLE t1,t2,t3,t4,t5,t6; 1412CREATE TABLE t1 (c1 BIGINT NOT NULL); 1413CREATE TABLE t2 (c1 BIGINT NOT NULL); 1414CREATE TABLE t3 (c1 BIGINT NOT NULL); 1415CREATE TABLE t4 (c1 BIGINT NOT NULL); 1416CREATE TABLE t5 (c1 BIGINT NOT NULL); 1417CREATE TABLE t6 (c1 BIGINT 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,t5.c1 FROM t1 CROSS JOIN t5 USING (c1); 1424c1 c1 1425SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1; 1426c1 c1 1427SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 <= 5; 1428c1 c1 1429DROP TABLE t1,t2,t3,t4,t5,t6; 1430CREATE TABLE t1 (c1 TINYINT NOT NULL); 1431CREATE TABLE t2 (c1 TINYINT NOT NULL); 1432CREATE TABLE t3 (c1 TINYINT NOT NULL); 1433CREATE TABLE t4 (c1 TINYINT NOT NULL); 1434CREATE TABLE t5 (c1 TINYINT NOT NULL); 1435CREATE TABLE t6 (c1 TINYINT NOT NULL); 1436INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1437INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1438INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 1439INSERT INTO t4 (c1) VALUES(10); 1440INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 1441SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 USING (c1); 1442c1 c1 1443SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1; 1444c1 c1 1445SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 <= 5; 1446c1 c1 1447DROP TABLE t1,t2,t3,t4,t5,t6; 1448CREATE TABLE t1 (c1 SMALLINT NOT NULL); 1449CREATE TABLE t2 (c1 SMALLINT NOT NULL); 1450CREATE TABLE t3 (c1 SMALLINT NOT NULL); 1451CREATE TABLE t4 (c1 SMALLINT NOT NULL); 1452CREATE TABLE t5 (c1 SMALLINT NOT NULL); 1453CREATE TABLE t6 (c1 SMALLINT NOT NULL); 1454INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1455INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1456INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 1457INSERT INTO t4 (c1) VALUES(10); 1458INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 1459SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 USING (c1); 1460c1 c1 1461SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1; 1462c1 c1 1463SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 <= 5; 1464c1 c1 1465DROP TABLE t1,t2,t3,t4,t5,t6; 1466CREATE TABLE t1 (c1 MEDIUMINT NOT NULL); 1467CREATE TABLE t2 (c1 MEDIUMINT NOT NULL); 1468CREATE TABLE t3 (c1 MEDIUMINT NOT NULL); 1469CREATE TABLE t4 (c1 MEDIUMINT NOT NULL); 1470CREATE TABLE t5 (c1 MEDIUMINT NOT NULL); 1471CREATE TABLE t6 (c1 MEDIUMINT NOT NULL); 1472INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1473INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1474INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 1475INSERT INTO t4 (c1) VALUES(10); 1476INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 1477SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 USING (c1); 1478c1 c1 1479SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1; 1480c1 c1 1481SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 <= 5; 1482c1 c1 1483DROP TABLE t1,t2,t3,t4,t5,t6; 1484CREATE TABLE t1 (c1 INT NOT NULL); 1485CREATE TABLE t2 (c1 INT NOT NULL); 1486CREATE TABLE t3 (c1 INT NOT NULL); 1487CREATE TABLE t4 (c1 INT NOT NULL); 1488CREATE TABLE t5 (c1 INT NOT NULL); 1489CREATE TABLE t6 (c1 INT NOT NULL); 1490INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1491INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1492INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 1493INSERT INTO t4 (c1) VALUES(10); 1494INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 1495SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 USING (c1); 1496c1 c1 1497SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1; 1498c1 c1 1499SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 <= 5; 1500c1 c1 1501DROP TABLE t1,t2,t3,t4,t5,t6; 1502CREATE TABLE t1 (c1 INTEGER NOT NULL); 1503CREATE TABLE t2 (c1 INTEGER NOT NULL); 1504CREATE TABLE t3 (c1 INTEGER NOT NULL); 1505CREATE TABLE t4 (c1 INTEGER NOT NULL); 1506CREATE TABLE t5 (c1 INTEGER NOT NULL); 1507CREATE TABLE t6 (c1 INTEGER NOT NULL); 1508INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1509INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1510INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 1511INSERT INTO t4 (c1) VALUES(10); 1512INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 1513SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 USING (c1); 1514c1 c1 1515SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1; 1516c1 c1 1517SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 <= 5; 1518c1 c1 1519DROP TABLE t1,t2,t3,t4,t5,t6; 1520CREATE TABLE t1 (c1 BIGINT NOT NULL); 1521CREATE TABLE t2 (c1 BIGINT NOT NULL); 1522CREATE TABLE t3 (c1 BIGINT NOT NULL); 1523CREATE TABLE t4 (c1 BIGINT NOT NULL); 1524CREATE TABLE t5 (c1 BIGINT NOT NULL); 1525CREATE TABLE t6 (c1 BIGINT NOT NULL); 1526INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1527INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1528INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 1529INSERT INTO t4 (c1) VALUES(10); 1530INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 1531SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 USING (c1); 1532c1 c1 1533SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1; 1534c1 c1 1535SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 <= 5; 1536c1 c1 1537DROP TABLE t1,t2,t3,t4,t5,t6; 1538CREATE TABLE t1 (c1 TINYINT NOT NULL); 1539CREATE TABLE t2 (c1 TINYINT NOT NULL); 1540CREATE TABLE t3 (c1 TINYINT NOT NULL); 1541CREATE TABLE t4 (c1 TINYINT NOT NULL); 1542CREATE TABLE t5 (c1 TINYINT NOT NULL); 1543CREATE TABLE t6 (c1 TINYINT NOT NULL); 1544INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1545INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1546INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 1547INSERT INTO t4 (c1) VALUES(10); 1548INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 1549SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 USING (c1); 1550c1 c1 15510 0 15521 1 15532 2 15543 3 15554 4 15565 5 15576 6 15587 7 15598 8 15609 9 1561SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1; 1562c1 c1 15630 0 15641 1 15652 2 15663 3 15674 4 15685 5 15696 6 15707 7 15718 8 15729 9 1573SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 = 5; 1574c1 c1 15755 5 1576DROP TABLE t1,t2,t3,t4,t5,t6; 1577CREATE TABLE t1 (c1 SMALLINT NOT NULL); 1578CREATE TABLE t2 (c1 SMALLINT NOT NULL); 1579CREATE TABLE t3 (c1 SMALLINT NOT NULL); 1580CREATE TABLE t4 (c1 SMALLINT NOT NULL); 1581CREATE TABLE t5 (c1 SMALLINT NOT NULL); 1582CREATE TABLE t6 (c1 SMALLINT NOT NULL); 1583INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1584INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1585INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 1586INSERT INTO t4 (c1) VALUES(10); 1587INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 1588SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 USING (c1); 1589c1 c1 15900 0 15911 1 15922 2 15933 3 15944 4 15955 5 15966 6 15977 7 15988 8 15999 9 1600SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1; 1601c1 c1 16020 0 16031 1 16042 2 16053 3 16064 4 16075 5 16086 6 16097 7 16108 8 16119 9 1612SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 = 5; 1613c1 c1 16145 5 1615DROP TABLE t1,t2,t3,t4,t5,t6; 1616CREATE TABLE t1 (c1 MEDIUMINT NOT NULL); 1617CREATE TABLE t2 (c1 MEDIUMINT NOT NULL); 1618CREATE TABLE t3 (c1 MEDIUMINT NOT NULL); 1619CREATE TABLE t4 (c1 MEDIUMINT NOT NULL); 1620CREATE TABLE t5 (c1 MEDIUMINT NOT NULL); 1621CREATE TABLE t6 (c1 MEDIUMINT NOT NULL); 1622INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1623INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1624INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 1625INSERT INTO t4 (c1) VALUES(10); 1626INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 1627SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 USING (c1); 1628c1 c1 16290 0 16301 1 16312 2 16323 3 16334 4 16345 5 16356 6 16367 7 16378 8 16389 9 1639SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1; 1640c1 c1 16410 0 16421 1 16432 2 16443 3 16454 4 16465 5 16476 6 16487 7 16498 8 16509 9 1651SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 = 5; 1652c1 c1 16535 5 1654DROP TABLE t1,t2,t3,t4,t5,t6; 1655CREATE TABLE t1 (c1 INT NOT NULL); 1656CREATE TABLE t2 (c1 INT NOT NULL); 1657CREATE TABLE t3 (c1 INT NOT NULL); 1658CREATE TABLE t4 (c1 INT NOT NULL); 1659CREATE TABLE t5 (c1 INT NOT NULL); 1660CREATE TABLE t6 (c1 INT NOT NULL); 1661INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1662INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1663INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 1664INSERT INTO t4 (c1) VALUES(10); 1665INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 1666SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 USING (c1); 1667c1 c1 16680 0 16691 1 16702 2 16713 3 16724 4 16735 5 16746 6 16757 7 16768 8 16779 9 1678SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1; 1679c1 c1 16800 0 16811 1 16822 2 16833 3 16844 4 16855 5 16866 6 16877 7 16888 8 16899 9 1690SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 = 5; 1691c1 c1 16925 5 1693DROP TABLE t1,t2,t3,t4,t5,t6; 1694CREATE TABLE t1 (c1 INTEGER NOT NULL); 1695CREATE TABLE t2 (c1 INTEGER NOT NULL); 1696CREATE TABLE t3 (c1 INTEGER NOT NULL); 1697CREATE TABLE t4 (c1 INTEGER NOT NULL); 1698CREATE TABLE t5 (c1 INTEGER NOT NULL); 1699CREATE TABLE t6 (c1 INTEGER NOT NULL); 1700INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1701INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1702INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 1703INSERT INTO t4 (c1) VALUES(10); 1704INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 1705SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 USING (c1); 1706c1 c1 17070 0 17081 1 17092 2 17103 3 17114 4 17125 5 17136 6 17147 7 17158 8 17169 9 1717SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1; 1718c1 c1 17190 0 17201 1 17212 2 17223 3 17234 4 17245 5 17256 6 17267 7 17278 8 17289 9 1729SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 = 5; 1730c1 c1 17315 5 1732DROP TABLE t1,t2,t3,t4,t5,t6; 1733CREATE TABLE t1 (c1 BIGINT NOT NULL); 1734CREATE TABLE t2 (c1 BIGINT NOT NULL); 1735CREATE TABLE t3 (c1 BIGINT NOT NULL); 1736CREATE TABLE t4 (c1 BIGINT NOT NULL); 1737CREATE TABLE t5 (c1 BIGINT NOT NULL); 1738CREATE TABLE t6 (c1 BIGINT NOT NULL); 1739INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1740INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1741INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 1742INSERT INTO t4 (c1) VALUES(10); 1743INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 1744SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 USING (c1); 1745c1 c1 17460 0 17471 1 17482 2 17493 3 17504 4 17515 5 17526 6 17537 7 17548 8 17559 9 1756SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1; 1757c1 c1 17580 0 17591 1 17602 2 17613 3 17624 4 17635 5 17646 6 17657 7 17668 8 17679 9 1768SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 = 5; 1769c1 c1 17705 5 1771DROP TABLE t1,t2,t3,t4,t5,t6; 1772CREATE TABLE t1 (c1 TINYINT NOT NULL); 1773CREATE TABLE t2 (c1 TINYINT NOT NULL); 1774CREATE TABLE t3 (c1 TINYINT NOT NULL); 1775CREATE TABLE t4 (c1 TINYINT NOT NULL); 1776CREATE TABLE t5 (c1 TINYINT NOT NULL); 1777CREATE TABLE t6 (c1 TINYINT NOT NULL); 1778INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1779INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1780INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 1781INSERT INTO t4 (c1) VALUES(10); 1782INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 1783SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 USING (c1); 1784c1 c1 17851 1 17863 3 17875 5 17887 7 17899 9 1790SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1; 1791c1 c1 17921 1 17933 3 17945 5 17957 7 17969 9 1797SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 = 5; 1798c1 c1 17995 5 1800DROP TABLE t1,t2,t3,t4,t5,t6; 1801CREATE TABLE t1 (c1 SMALLINT NOT NULL); 1802CREATE TABLE t2 (c1 SMALLINT NOT NULL); 1803CREATE TABLE t3 (c1 SMALLINT NOT NULL); 1804CREATE TABLE t4 (c1 SMALLINT NOT NULL); 1805CREATE TABLE t5 (c1 SMALLINT NOT NULL); 1806CREATE TABLE t6 (c1 SMALLINT NOT NULL); 1807INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1808INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1809INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 1810INSERT INTO t4 (c1) VALUES(10); 1811INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 1812SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 USING (c1); 1813c1 c1 18141 1 18153 3 18165 5 18177 7 18189 9 1819SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1; 1820c1 c1 18211 1 18223 3 18235 5 18247 7 18259 9 1826SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 = 5; 1827c1 c1 18285 5 1829DROP TABLE t1,t2,t3,t4,t5,t6; 1830CREATE TABLE t1 (c1 MEDIUMINT NOT NULL); 1831CREATE TABLE t2 (c1 MEDIUMINT NOT NULL); 1832CREATE TABLE t3 (c1 MEDIUMINT NOT NULL); 1833CREATE TABLE t4 (c1 MEDIUMINT NOT NULL); 1834CREATE TABLE t5 (c1 MEDIUMINT NOT NULL); 1835CREATE TABLE t6 (c1 MEDIUMINT NOT NULL); 1836INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1837INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1838INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 1839INSERT INTO t4 (c1) VALUES(10); 1840INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 1841SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 USING (c1); 1842c1 c1 18431 1 18443 3 18455 5 18467 7 18479 9 1848SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1; 1849c1 c1 18501 1 18513 3 18525 5 18537 7 18549 9 1855SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 = 5; 1856c1 c1 18575 5 1858DROP TABLE t1,t2,t3,t4,t5,t6; 1859CREATE TABLE t1 (c1 INT NOT NULL); 1860CREATE TABLE t2 (c1 INT NOT NULL); 1861CREATE TABLE t3 (c1 INT NOT NULL); 1862CREATE TABLE t4 (c1 INT NOT NULL); 1863CREATE TABLE t5 (c1 INT NOT NULL); 1864CREATE TABLE t6 (c1 INT NOT NULL); 1865INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1866INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1867INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 1868INSERT INTO t4 (c1) VALUES(10); 1869INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 1870SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 USING (c1); 1871c1 c1 18721 1 18733 3 18745 5 18757 7 18769 9 1877SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1; 1878c1 c1 18791 1 18803 3 18815 5 18827 7 18839 9 1884SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 = 5; 1885c1 c1 18865 5 1887DROP TABLE t1,t2,t3,t4,t5,t6; 1888CREATE TABLE t1 (c1 INTEGER NOT NULL); 1889CREATE TABLE t2 (c1 INTEGER NOT NULL); 1890CREATE TABLE t3 (c1 INTEGER NOT NULL); 1891CREATE TABLE t4 (c1 INTEGER NOT NULL); 1892CREATE TABLE t5 (c1 INTEGER NOT NULL); 1893CREATE TABLE t6 (c1 INTEGER NOT NULL); 1894INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1895INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1896INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 1897INSERT INTO t4 (c1) VALUES(10); 1898INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 1899SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 USING (c1); 1900c1 c1 19011 1 19023 3 19035 5 19047 7 19059 9 1906SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1; 1907c1 c1 19081 1 19093 3 19105 5 19117 7 19129 9 1913SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 = 5; 1914c1 c1 19155 5 1916DROP TABLE t1,t2,t3,t4,t5,t6; 1917CREATE TABLE t1 (c1 BIGINT NOT NULL); 1918CREATE TABLE t2 (c1 BIGINT NOT NULL); 1919CREATE TABLE t3 (c1 BIGINT NOT NULL); 1920CREATE TABLE t4 (c1 BIGINT NOT NULL); 1921CREATE TABLE t5 (c1 BIGINT NOT NULL); 1922CREATE TABLE t6 (c1 BIGINT NOT NULL); 1923INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1924INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1925INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 1926INSERT INTO t4 (c1) VALUES(10); 1927INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 1928SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 USING (c1); 1929c1 c1 19301 1 19313 3 19325 5 19337 7 19349 9 1935SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1; 1936c1 c1 19371 1 19383 3 19395 5 19407 7 19419 9 1942SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 = 5; 1943c1 c1 19445 5 1945DROP TABLE t1,t2,t3,t4,t5,t6; 1946CREATE TABLE t1 (c1 TINYINT NOT NULL); 1947CREATE TABLE t2 (c1 TINYINT NOT NULL); 1948CREATE TABLE t3 (c1 TINYINT NOT NULL); 1949CREATE TABLE t4 (c1 TINYINT NOT NULL); 1950CREATE TABLE t5 (c1 TINYINT NOT NULL); 1951CREATE TABLE t6 (c1 TINYINT 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,t4.c1 FROM t1 CROSS JOIN t4 USING (c1); 1958c1 c1 1959SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1; 1960c1 c1 1961SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 = 5; 1962c1 c1 1963DROP TABLE t1,t2,t3,t4,t5,t6; 1964CREATE TABLE t1 (c1 SMALLINT NOT NULL); 1965CREATE TABLE t2 (c1 SMALLINT NOT NULL); 1966CREATE TABLE t3 (c1 SMALLINT NOT NULL); 1967CREATE TABLE t4 (c1 SMALLINT NOT NULL); 1968CREATE TABLE t5 (c1 SMALLINT NOT NULL); 1969CREATE TABLE t6 (c1 SMALLINT NOT NULL); 1970INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1971INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1972INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 1973INSERT INTO t4 (c1) VALUES(10); 1974INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 1975SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 USING (c1); 1976c1 c1 1977SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1; 1978c1 c1 1979SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 = 5; 1980c1 c1 1981DROP TABLE t1,t2,t3,t4,t5,t6; 1982CREATE TABLE t1 (c1 MEDIUMINT NOT NULL); 1983CREATE TABLE t2 (c1 MEDIUMINT NOT NULL); 1984CREATE TABLE t3 (c1 MEDIUMINT NOT NULL); 1985CREATE TABLE t4 (c1 MEDIUMINT NOT NULL); 1986CREATE TABLE t5 (c1 MEDIUMINT NOT NULL); 1987CREATE TABLE t6 (c1 MEDIUMINT NOT NULL); 1988INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1989INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1990INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 1991INSERT INTO t4 (c1) VALUES(10); 1992INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 1993SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 USING (c1); 1994c1 c1 1995SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1; 1996c1 c1 1997SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 = 5; 1998c1 c1 1999DROP TABLE t1,t2,t3,t4,t5,t6; 2000CREATE TABLE t1 (c1 INT NOT NULL); 2001CREATE TABLE t2 (c1 INT NOT NULL); 2002CREATE TABLE t3 (c1 INT NOT NULL); 2003CREATE TABLE t4 (c1 INT NOT NULL); 2004CREATE TABLE t5 (c1 INT NOT NULL); 2005CREATE TABLE t6 (c1 INT 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,t4.c1 FROM t1 CROSS JOIN t4 USING (c1); 2012c1 c1 2013SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1; 2014c1 c1 2015SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 = 5; 2016c1 c1 2017DROP TABLE t1,t2,t3,t4,t5,t6; 2018CREATE TABLE t1 (c1 INTEGER NOT NULL); 2019CREATE TABLE t2 (c1 INTEGER NOT NULL); 2020CREATE TABLE t3 (c1 INTEGER NOT NULL); 2021CREATE TABLE t4 (c1 INTEGER NOT NULL); 2022CREATE TABLE t5 (c1 INTEGER NOT NULL); 2023CREATE TABLE t6 (c1 INTEGER NOT NULL); 2024INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2025INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2026INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 2027INSERT INTO t4 (c1) VALUES(10); 2028INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 2029SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 USING (c1); 2030c1 c1 2031SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1; 2032c1 c1 2033SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 = 5; 2034c1 c1 2035DROP TABLE t1,t2,t3,t4,t5,t6; 2036CREATE TABLE t1 (c1 BIGINT NOT NULL); 2037CREATE TABLE t2 (c1 BIGINT NOT NULL); 2038CREATE TABLE t3 (c1 BIGINT NOT NULL); 2039CREATE TABLE t4 (c1 BIGINT NOT NULL); 2040CREATE TABLE t5 (c1 BIGINT NOT NULL); 2041CREATE TABLE t6 (c1 BIGINT NOT NULL); 2042INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2043INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2044INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 2045INSERT INTO t4 (c1) VALUES(10); 2046INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 2047SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 USING (c1); 2048c1 c1 2049SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1; 2050c1 c1 2051SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 = 5; 2052c1 c1 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,t5.c1 FROM t1 CROSS JOIN t5 USING (c1); 2066c1 c1 2067SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1; 2068c1 c1 2069SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 = 5; 2070c1 c1 2071DROP TABLE t1,t2,t3,t4,t5,t6; 2072CREATE TABLE t1 (c1 SMALLINT NOT NULL); 2073CREATE TABLE t2 (c1 SMALLINT NOT NULL); 2074CREATE TABLE t3 (c1 SMALLINT NOT NULL); 2075CREATE TABLE t4 (c1 SMALLINT NOT NULL); 2076CREATE TABLE t5 (c1 SMALLINT NOT NULL); 2077CREATE TABLE t6 (c1 SMALLINT NOT NULL); 2078INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2079INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2080INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 2081INSERT INTO t4 (c1) VALUES(10); 2082INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 2083SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 USING (c1); 2084c1 c1 2085SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1; 2086c1 c1 2087SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 = 5; 2088c1 c1 2089DROP TABLE t1,t2,t3,t4,t5,t6; 2090CREATE TABLE t1 (c1 MEDIUMINT NOT NULL); 2091CREATE TABLE t2 (c1 MEDIUMINT NOT NULL); 2092CREATE TABLE t3 (c1 MEDIUMINT NOT NULL); 2093CREATE TABLE t4 (c1 MEDIUMINT NOT NULL); 2094CREATE TABLE t5 (c1 MEDIUMINT NOT NULL); 2095CREATE TABLE t6 (c1 MEDIUMINT NOT NULL); 2096INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2097INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2098INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 2099INSERT INTO t4 (c1) VALUES(10); 2100INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 2101SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 USING (c1); 2102c1 c1 2103SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1; 2104c1 c1 2105SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 = 5; 2106c1 c1 2107DROP TABLE t1,t2,t3,t4,t5,t6; 2108CREATE TABLE t1 (c1 INT NOT NULL); 2109CREATE TABLE t2 (c1 INT NOT NULL); 2110CREATE TABLE t3 (c1 INT NOT NULL); 2111CREATE TABLE t4 (c1 INT NOT NULL); 2112CREATE TABLE t5 (c1 INT NOT NULL); 2113CREATE TABLE t6 (c1 INT 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,t5.c1 FROM t1 CROSS JOIN t5 USING (c1); 2120c1 c1 2121SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1; 2122c1 c1 2123SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 = 5; 2124c1 c1 2125DROP TABLE t1,t2,t3,t4,t5,t6; 2126CREATE TABLE t1 (c1 INTEGER NOT NULL); 2127CREATE TABLE t2 (c1 INTEGER NOT NULL); 2128CREATE TABLE t3 (c1 INTEGER NOT NULL); 2129CREATE TABLE t4 (c1 INTEGER NOT NULL); 2130CREATE TABLE t5 (c1 INTEGER NOT NULL); 2131CREATE TABLE t6 (c1 INTEGER NOT NULL); 2132INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2133INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2134INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 2135INSERT INTO t4 (c1) VALUES(10); 2136INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 2137SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 USING (c1); 2138c1 c1 2139SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1; 2140c1 c1 2141SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 = 5; 2142c1 c1 2143DROP TABLE t1,t2,t3,t4,t5,t6; 2144CREATE TABLE t1 (c1 BIGINT NOT NULL); 2145CREATE TABLE t2 (c1 BIGINT NOT NULL); 2146CREATE TABLE t3 (c1 BIGINT NOT NULL); 2147CREATE TABLE t4 (c1 BIGINT NOT NULL); 2148CREATE TABLE t5 (c1 BIGINT NOT NULL); 2149CREATE TABLE t6 (c1 BIGINT NOT NULL); 2150INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2151INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2152INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 2153INSERT INTO t4 (c1) VALUES(10); 2154INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 2155SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 USING (c1); 2156c1 c1 2157SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1; 2158c1 c1 2159SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 = 5; 2160c1 c1 2161DROP TABLE t1,t2,t3,t4,t5,t6; 2162CREATE TABLE t1 (c1 TINYINT NOT NULL); 2163CREATE TABLE t2 (c1 TINYINT NOT NULL); 2164CREATE TABLE t3 (c1 TINYINT NOT NULL); 2165CREATE TABLE t4 (c1 TINYINT NOT NULL); 2166CREATE TABLE t5 (c1 TINYINT NOT NULL); 2167CREATE TABLE t6 (c1 TINYINT 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,t6.c1 FROM t1 CROSS JOIN t6 USING (c1); 2174c1 c1 2175SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1; 2176c1 c1 2177SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 = 5; 2178c1 c1 2179DROP TABLE t1,t2,t3,t4,t5,t6; 2180CREATE TABLE t1 (c1 SMALLINT NOT NULL); 2181CREATE TABLE t2 (c1 SMALLINT NOT NULL); 2182CREATE TABLE t3 (c1 SMALLINT NOT NULL); 2183CREATE TABLE t4 (c1 SMALLINT NOT NULL); 2184CREATE TABLE t5 (c1 SMALLINT NOT NULL); 2185CREATE TABLE t6 (c1 SMALLINT NOT NULL); 2186INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2187INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2188INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 2189INSERT INTO t4 (c1) VALUES(10); 2190INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 2191SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 USING (c1); 2192c1 c1 2193SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1; 2194c1 c1 2195SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 = 5; 2196c1 c1 2197DROP TABLE t1,t2,t3,t4,t5,t6; 2198CREATE TABLE t1 (c1 MEDIUMINT NOT NULL); 2199CREATE TABLE t2 (c1 MEDIUMINT NOT NULL); 2200CREATE TABLE t3 (c1 MEDIUMINT NOT NULL); 2201CREATE TABLE t4 (c1 MEDIUMINT NOT NULL); 2202CREATE TABLE t5 (c1 MEDIUMINT NOT NULL); 2203CREATE TABLE t6 (c1 MEDIUMINT NOT NULL); 2204INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2205INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2206INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 2207INSERT INTO t4 (c1) VALUES(10); 2208INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 2209SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 USING (c1); 2210c1 c1 2211SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1; 2212c1 c1 2213SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 = 5; 2214c1 c1 2215DROP TABLE t1,t2,t3,t4,t5,t6; 2216CREATE TABLE t1 (c1 INT NOT NULL); 2217CREATE TABLE t2 (c1 INT NOT NULL); 2218CREATE TABLE t3 (c1 INT NOT NULL); 2219CREATE TABLE t4 (c1 INT NOT NULL); 2220CREATE TABLE t5 (c1 INT NOT NULL); 2221CREATE TABLE t6 (c1 INT 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,t6.c1 FROM t1 CROSS JOIN t6 USING (c1); 2228c1 c1 2229SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1; 2230c1 c1 2231SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 = 5; 2232c1 c1 2233DROP TABLE t1,t2,t3,t4,t5,t6; 2234CREATE TABLE t1 (c1 INTEGER NOT NULL); 2235CREATE TABLE t2 (c1 INTEGER NOT NULL); 2236CREATE TABLE t3 (c1 INTEGER NOT NULL); 2237CREATE TABLE t4 (c1 INTEGER NOT NULL); 2238CREATE TABLE t5 (c1 INTEGER NOT NULL); 2239CREATE TABLE t6 (c1 INTEGER NOT NULL); 2240INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2241INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2242INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 2243INSERT INTO t4 (c1) VALUES(10); 2244INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 2245SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 USING (c1); 2246c1 c1 2247SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1; 2248c1 c1 2249SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 = 5; 2250c1 c1 2251DROP TABLE t1,t2,t3,t4,t5,t6; 2252CREATE TABLE t1 (c1 BIGINT NOT NULL); 2253CREATE TABLE t2 (c1 BIGINT NOT NULL); 2254CREATE TABLE t3 (c1 BIGINT NOT NULL); 2255CREATE TABLE t4 (c1 BIGINT NOT NULL); 2256CREATE TABLE t5 (c1 BIGINT NOT NULL); 2257CREATE TABLE t6 (c1 BIGINT NOT NULL); 2258INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2259INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2260INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 2261INSERT INTO t4 (c1) VALUES(10); 2262INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 2263SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 USING (c1); 2264c1 c1 2265SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1; 2266c1 c1 2267SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 = 5; 2268c1 c1 2269DROP TABLE t1,t2,t3,t4,t5,t6; 2270CREATE TABLE t1 (c1 TINYINT NOT NULL); 2271CREATE TABLE t2 (c1 TINYINT NOT NULL); 2272CREATE TABLE t3 (c1 TINYINT NOT NULL); 2273CREATE TABLE t4 (c1 TINYINT NOT NULL); 2274CREATE TABLE t5 (c1 TINYINT NOT NULL); 2275CREATE TABLE t6 (c1 TINYINT 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,t2.c1 FROM t1 CROSS JOIN t2 USING (c1); 2282c1 c1 22830 0 22841 1 22852 2 22863 3 22874 4 22885 5 22896 6 22907 7 22918 8 22929 9 2293SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1; 2294c1 c1 22950 0 22961 1 22972 2 22983 3 22994 4 23005 5 23016 6 23027 7 23038 8 23049 9 2305SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 >= 5; 2306c1 c1 23075 5 23086 6 23097 7 23108 8 23119 9 2312DROP TABLE t1,t2,t3,t4,t5,t6; 2313CREATE TABLE t1 (c1 SMALLINT NOT NULL); 2314CREATE TABLE t2 (c1 SMALLINT NOT NULL); 2315CREATE TABLE t3 (c1 SMALLINT NOT NULL); 2316CREATE TABLE t4 (c1 SMALLINT NOT NULL); 2317CREATE TABLE t5 (c1 SMALLINT NOT NULL); 2318CREATE TABLE t6 (c1 SMALLINT NOT NULL); 2319INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2320INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2321INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 2322INSERT INTO t4 (c1) VALUES(10); 2323INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 2324SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 USING (c1); 2325c1 c1 23260 0 23271 1 23282 2 23293 3 23304 4 23315 5 23326 6 23337 7 23348 8 23359 9 2336SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1; 2337c1 c1 23380 0 23391 1 23402 2 23413 3 23424 4 23435 5 23446 6 23457 7 23468 8 23479 9 2348SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 >= 5; 2349c1 c1 23505 5 23516 6 23527 7 23538 8 23549 9 2355DROP TABLE t1,t2,t3,t4,t5,t6; 2356CREATE TABLE t1 (c1 MEDIUMINT NOT NULL); 2357CREATE TABLE t2 (c1 MEDIUMINT NOT NULL); 2358CREATE TABLE t3 (c1 MEDIUMINT NOT NULL); 2359CREATE TABLE t4 (c1 MEDIUMINT NOT NULL); 2360CREATE TABLE t5 (c1 MEDIUMINT NOT NULL); 2361CREATE TABLE t6 (c1 MEDIUMINT NOT NULL); 2362INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2363INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2364INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 2365INSERT INTO t4 (c1) VALUES(10); 2366INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 2367SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 USING (c1); 2368c1 c1 23690 0 23701 1 23712 2 23723 3 23734 4 23745 5 23756 6 23767 7 23778 8 23789 9 2379SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1; 2380c1 c1 23810 0 23821 1 23832 2 23843 3 23854 4 23865 5 23876 6 23887 7 23898 8 23909 9 2391SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 >= 5; 2392c1 c1 23935 5 23946 6 23957 7 23968 8 23979 9 2398DROP TABLE t1,t2,t3,t4,t5,t6; 2399CREATE TABLE t1 (c1 INT NOT NULL); 2400CREATE TABLE t2 (c1 INT NOT NULL); 2401CREATE TABLE t3 (c1 INT NOT NULL); 2402CREATE TABLE t4 (c1 INT NOT NULL); 2403CREATE TABLE t5 (c1 INT NOT NULL); 2404CREATE TABLE t6 (c1 INT NOT NULL); 2405INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2406INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2407INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 2408INSERT INTO t4 (c1) VALUES(10); 2409INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 2410SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 USING (c1); 2411c1 c1 24120 0 24131 1 24142 2 24153 3 24164 4 24175 5 24186 6 24197 7 24208 8 24219 9 2422SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1; 2423c1 c1 24240 0 24251 1 24262 2 24273 3 24284 4 24295 5 24306 6 24317 7 24328 8 24339 9 2434SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 >= 5; 2435c1 c1 24365 5 24376 6 24387 7 24398 8 24409 9 2441DROP TABLE t1,t2,t3,t4,t5,t6; 2442CREATE TABLE t1 (c1 INTEGER NOT NULL); 2443CREATE TABLE t2 (c1 INTEGER NOT NULL); 2444CREATE TABLE t3 (c1 INTEGER NOT NULL); 2445CREATE TABLE t4 (c1 INTEGER NOT NULL); 2446CREATE TABLE t5 (c1 INTEGER NOT NULL); 2447CREATE TABLE t6 (c1 INTEGER NOT NULL); 2448INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2449INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2450INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 2451INSERT INTO t4 (c1) VALUES(10); 2452INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 2453SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 USING (c1); 2454c1 c1 24550 0 24561 1 24572 2 24583 3 24594 4 24605 5 24616 6 24627 7 24638 8 24649 9 2465SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1; 2466c1 c1 24670 0 24681 1 24692 2 24703 3 24714 4 24725 5 24736 6 24747 7 24758 8 24769 9 2477SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 >= 5; 2478c1 c1 24795 5 24806 6 24817 7 24828 8 24839 9 2484DROP TABLE t1,t2,t3,t4,t5,t6; 2485CREATE TABLE t1 (c1 BIGINT NOT NULL); 2486CREATE TABLE t2 (c1 BIGINT NOT NULL); 2487CREATE TABLE t3 (c1 BIGINT NOT NULL); 2488CREATE TABLE t4 (c1 BIGINT NOT NULL); 2489CREATE TABLE t5 (c1 BIGINT NOT NULL); 2490CREATE TABLE t6 (c1 BIGINT NOT NULL); 2491INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2492INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2493INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 2494INSERT INTO t4 (c1) VALUES(10); 2495INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 2496SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 USING (c1); 2497c1 c1 24980 0 24991 1 25002 2 25013 3 25024 4 25035 5 25046 6 25057 7 25068 8 25079 9 2508SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1; 2509c1 c1 25100 0 25111 1 25122 2 25133 3 25144 4 25155 5 25166 6 25177 7 25188 8 25199 9 2520SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 >= 5; 2521c1 c1 25225 5 25236 6 25247 7 25258 8 25269 9 2527DROP TABLE t1,t2,t3,t4,t5,t6; 2528CREATE TABLE t1 (c1 TINYINT NOT NULL); 2529CREATE TABLE t2 (c1 TINYINT NOT NULL); 2530CREATE TABLE t3 (c1 TINYINT NOT NULL); 2531CREATE TABLE t4 (c1 TINYINT NOT NULL); 2532CREATE TABLE t5 (c1 TINYINT NOT NULL); 2533CREATE TABLE t6 (c1 TINYINT NOT NULL); 2534INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2535INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2536INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 2537INSERT INTO t4 (c1) VALUES(10); 2538INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 2539SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 USING (c1); 2540c1 c1 25411 1 25423 3 25435 5 25447 7 25459 9 2546SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1; 2547c1 c1 25481 1 25493 3 25505 5 25517 7 25529 9 2553SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 >= 5; 2554c1 c1 25555 5 25567 7 25579 9 2558DROP TABLE t1,t2,t3,t4,t5,t6; 2559CREATE TABLE t1 (c1 SMALLINT NOT NULL); 2560CREATE TABLE t2 (c1 SMALLINT NOT NULL); 2561CREATE TABLE t3 (c1 SMALLINT NOT NULL); 2562CREATE TABLE t4 (c1 SMALLINT NOT NULL); 2563CREATE TABLE t5 (c1 SMALLINT NOT NULL); 2564CREATE TABLE t6 (c1 SMALLINT NOT NULL); 2565INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2566INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2567INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 2568INSERT INTO t4 (c1) VALUES(10); 2569INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 2570SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 USING (c1); 2571c1 c1 25721 1 25733 3 25745 5 25757 7 25769 9 2577SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1; 2578c1 c1 25791 1 25803 3 25815 5 25827 7 25839 9 2584SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 >= 5; 2585c1 c1 25865 5 25877 7 25889 9 2589DROP TABLE t1,t2,t3,t4,t5,t6; 2590CREATE TABLE t1 (c1 MEDIUMINT NOT NULL); 2591CREATE TABLE t2 (c1 MEDIUMINT NOT NULL); 2592CREATE TABLE t3 (c1 MEDIUMINT NOT NULL); 2593CREATE TABLE t4 (c1 MEDIUMINT NOT NULL); 2594CREATE TABLE t5 (c1 MEDIUMINT NOT NULL); 2595CREATE TABLE t6 (c1 MEDIUMINT NOT NULL); 2596INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2597INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2598INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 2599INSERT INTO t4 (c1) VALUES(10); 2600INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 2601SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 USING (c1); 2602c1 c1 26031 1 26043 3 26055 5 26067 7 26079 9 2608SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1; 2609c1 c1 26101 1 26113 3 26125 5 26137 7 26149 9 2615SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 >= 5; 2616c1 c1 26175 5 26187 7 26199 9 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,t3.c1 FROM t1 CROSS JOIN t3 USING (c1); 2633c1 c1 26341 1 26353 3 26365 5 26377 7 26389 9 2639SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1; 2640c1 c1 26411 1 26423 3 26435 5 26447 7 26459 9 2646SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 >= 5; 2647c1 c1 26485 5 26497 7 26509 9 2651DROP TABLE t1,t2,t3,t4,t5,t6; 2652CREATE TABLE t1 (c1 INTEGER NOT NULL); 2653CREATE TABLE t2 (c1 INTEGER NOT NULL); 2654CREATE TABLE t3 (c1 INTEGER NOT NULL); 2655CREATE TABLE t4 (c1 INTEGER NOT NULL); 2656CREATE TABLE t5 (c1 INTEGER NOT NULL); 2657CREATE TABLE t6 (c1 INTEGER NOT NULL); 2658INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2659INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2660INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 2661INSERT INTO t4 (c1) VALUES(10); 2662INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 2663SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 USING (c1); 2664c1 c1 26651 1 26663 3 26675 5 26687 7 26699 9 2670SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1; 2671c1 c1 26721 1 26733 3 26745 5 26757 7 26769 9 2677SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 >= 5; 2678c1 c1 26795 5 26807 7 26819 9 2682DROP TABLE t1,t2,t3,t4,t5,t6; 2683CREATE TABLE t1 (c1 BIGINT NOT NULL); 2684CREATE TABLE t2 (c1 BIGINT NOT NULL); 2685CREATE TABLE t3 (c1 BIGINT NOT NULL); 2686CREATE TABLE t4 (c1 BIGINT NOT NULL); 2687CREATE TABLE t5 (c1 BIGINT NOT NULL); 2688CREATE TABLE t6 (c1 BIGINT NOT NULL); 2689INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2690INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2691INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 2692INSERT INTO t4 (c1) VALUES(10); 2693INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 2694SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 USING (c1); 2695c1 c1 26961 1 26973 3 26985 5 26997 7 27009 9 2701SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1; 2702c1 c1 27031 1 27043 3 27055 5 27067 7 27079 9 2708SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 >= 5; 2709c1 c1 27105 5 27117 7 27129 9 2713DROP TABLE t1,t2,t3,t4,t5,t6; 2714CREATE TABLE t1 (c1 TINYINT NOT NULL); 2715CREATE TABLE t2 (c1 TINYINT NOT NULL); 2716CREATE TABLE t3 (c1 TINYINT NOT NULL); 2717CREATE TABLE t4 (c1 TINYINT NOT NULL); 2718CREATE TABLE t5 (c1 TINYINT NOT NULL); 2719CREATE TABLE t6 (c1 TINYINT NOT NULL); 2720INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2721INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2722INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 2723INSERT INTO t4 (c1) VALUES(10); 2724INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 2725SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 USING (c1); 2726c1 c1 2727SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1; 2728c1 c1 2729SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 >= 5; 2730c1 c1 2731DROP TABLE t1,t2,t3,t4,t5,t6; 2732CREATE TABLE t1 (c1 SMALLINT NOT NULL); 2733CREATE TABLE t2 (c1 SMALLINT NOT NULL); 2734CREATE TABLE t3 (c1 SMALLINT NOT NULL); 2735CREATE TABLE t4 (c1 SMALLINT NOT NULL); 2736CREATE TABLE t5 (c1 SMALLINT NOT NULL); 2737CREATE TABLE t6 (c1 SMALLINT NOT NULL); 2738INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2739INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2740INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 2741INSERT INTO t4 (c1) VALUES(10); 2742INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 2743SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 USING (c1); 2744c1 c1 2745SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1; 2746c1 c1 2747SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 >= 5; 2748c1 c1 2749DROP TABLE t1,t2,t3,t4,t5,t6; 2750CREATE TABLE t1 (c1 MEDIUMINT NOT NULL); 2751CREATE TABLE t2 (c1 MEDIUMINT NOT NULL); 2752CREATE TABLE t3 (c1 MEDIUMINT NOT NULL); 2753CREATE TABLE t4 (c1 MEDIUMINT NOT NULL); 2754CREATE TABLE t5 (c1 MEDIUMINT NOT NULL); 2755CREATE TABLE t6 (c1 MEDIUMINT NOT NULL); 2756INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2757INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2758INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 2759INSERT INTO t4 (c1) VALUES(10); 2760INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 2761SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 USING (c1); 2762c1 c1 2763SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1; 2764c1 c1 2765SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 >= 5; 2766c1 c1 2767DROP TABLE t1,t2,t3,t4,t5,t6; 2768CREATE TABLE t1 (c1 INT NOT NULL); 2769CREATE TABLE t2 (c1 INT NOT NULL); 2770CREATE TABLE t3 (c1 INT NOT NULL); 2771CREATE TABLE t4 (c1 INT NOT NULL); 2772CREATE TABLE t5 (c1 INT NOT NULL); 2773CREATE TABLE t6 (c1 INT NOT NULL); 2774INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2775INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2776INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 2777INSERT INTO t4 (c1) VALUES(10); 2778INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 2779SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 USING (c1); 2780c1 c1 2781SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1; 2782c1 c1 2783SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 >= 5; 2784c1 c1 2785DROP TABLE t1,t2,t3,t4,t5,t6; 2786CREATE TABLE t1 (c1 INTEGER NOT NULL); 2787CREATE TABLE t2 (c1 INTEGER NOT NULL); 2788CREATE TABLE t3 (c1 INTEGER NOT NULL); 2789CREATE TABLE t4 (c1 INTEGER NOT NULL); 2790CREATE TABLE t5 (c1 INTEGER NOT NULL); 2791CREATE TABLE t6 (c1 INTEGER NOT NULL); 2792INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2793INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2794INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 2795INSERT INTO t4 (c1) VALUES(10); 2796INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 2797SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 USING (c1); 2798c1 c1 2799SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1; 2800c1 c1 2801SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 >= 5; 2802c1 c1 2803DROP TABLE t1,t2,t3,t4,t5,t6; 2804CREATE TABLE t1 (c1 BIGINT NOT NULL); 2805CREATE TABLE t2 (c1 BIGINT NOT NULL); 2806CREATE TABLE t3 (c1 BIGINT NOT NULL); 2807CREATE TABLE t4 (c1 BIGINT NOT NULL); 2808CREATE TABLE t5 (c1 BIGINT NOT NULL); 2809CREATE TABLE t6 (c1 BIGINT NOT NULL); 2810INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2811INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2812INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 2813INSERT INTO t4 (c1) VALUES(10); 2814INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 2815SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 USING (c1); 2816c1 c1 2817SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1; 2818c1 c1 2819SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 >= 5; 2820c1 c1 2821DROP TABLE t1,t2,t3,t4,t5,t6; 2822CREATE TABLE t1 (c1 TINYINT NOT NULL); 2823CREATE TABLE t2 (c1 TINYINT NOT NULL); 2824CREATE TABLE t3 (c1 TINYINT NOT NULL); 2825CREATE TABLE t4 (c1 TINYINT NOT NULL); 2826CREATE TABLE t5 (c1 TINYINT NOT NULL); 2827CREATE TABLE t6 (c1 TINYINT NOT NULL); 2828INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2829INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2830INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 2831INSERT INTO t4 (c1) VALUES(10); 2832INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 2833SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 USING (c1); 2834c1 c1 2835SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1; 2836c1 c1 2837SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 >= 5; 2838c1 c1 2839DROP TABLE t1,t2,t3,t4,t5,t6; 2840CREATE TABLE t1 (c1 SMALLINT NOT NULL); 2841CREATE TABLE t2 (c1 SMALLINT NOT NULL); 2842CREATE TABLE t3 (c1 SMALLINT NOT NULL); 2843CREATE TABLE t4 (c1 SMALLINT NOT NULL); 2844CREATE TABLE t5 (c1 SMALLINT NOT NULL); 2845CREATE TABLE t6 (c1 SMALLINT NOT NULL); 2846INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2847INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2848INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 2849INSERT INTO t4 (c1) VALUES(10); 2850INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 2851SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 USING (c1); 2852c1 c1 2853SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1; 2854c1 c1 2855SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 >= 5; 2856c1 c1 2857DROP TABLE t1,t2,t3,t4,t5,t6; 2858CREATE TABLE t1 (c1 MEDIUMINT NOT NULL); 2859CREATE TABLE t2 (c1 MEDIUMINT NOT NULL); 2860CREATE TABLE t3 (c1 MEDIUMINT NOT NULL); 2861CREATE TABLE t4 (c1 MEDIUMINT NOT NULL); 2862CREATE TABLE t5 (c1 MEDIUMINT NOT NULL); 2863CREATE TABLE t6 (c1 MEDIUMINT NOT NULL); 2864INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2865INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2866INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 2867INSERT INTO t4 (c1) VALUES(10); 2868INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 2869SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 USING (c1); 2870c1 c1 2871SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1; 2872c1 c1 2873SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 >= 5; 2874c1 c1 2875DROP TABLE t1,t2,t3,t4,t5,t6; 2876CREATE TABLE t1 (c1 INT NOT NULL); 2877CREATE TABLE t2 (c1 INT NOT NULL); 2878CREATE TABLE t3 (c1 INT NOT NULL); 2879CREATE TABLE t4 (c1 INT NOT NULL); 2880CREATE TABLE t5 (c1 INT NOT NULL); 2881CREATE TABLE t6 (c1 INT NOT NULL); 2882INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2883INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2884INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 2885INSERT INTO t4 (c1) VALUES(10); 2886INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 2887SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 USING (c1); 2888c1 c1 2889SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1; 2890c1 c1 2891SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 >= 5; 2892c1 c1 2893DROP TABLE t1,t2,t3,t4,t5,t6; 2894CREATE TABLE t1 (c1 INTEGER NOT NULL); 2895CREATE TABLE t2 (c1 INTEGER NOT NULL); 2896CREATE TABLE t3 (c1 INTEGER NOT NULL); 2897CREATE TABLE t4 (c1 INTEGER NOT NULL); 2898CREATE TABLE t5 (c1 INTEGER NOT NULL); 2899CREATE TABLE t6 (c1 INTEGER NOT NULL); 2900INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2901INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2902INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 2903INSERT INTO t4 (c1) VALUES(10); 2904INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 2905SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 USING (c1); 2906c1 c1 2907SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1; 2908c1 c1 2909SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 >= 5; 2910c1 c1 2911DROP TABLE t1,t2,t3,t4,t5,t6; 2912CREATE TABLE t1 (c1 BIGINT NOT NULL); 2913CREATE TABLE t2 (c1 BIGINT NOT NULL); 2914CREATE TABLE t3 (c1 BIGINT NOT NULL); 2915CREATE TABLE t4 (c1 BIGINT NOT NULL); 2916CREATE TABLE t5 (c1 BIGINT NOT NULL); 2917CREATE TABLE t6 (c1 BIGINT NOT NULL); 2918INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2919INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2920INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 2921INSERT INTO t4 (c1) VALUES(10); 2922INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 2923SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 USING (c1); 2924c1 c1 2925SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1; 2926c1 c1 2927SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 >= 5; 2928c1 c1 2929DROP TABLE t1,t2,t3,t4,t5,t6; 2930CREATE TABLE t1 (c1 TINYINT NOT NULL); 2931CREATE TABLE t2 (c1 TINYINT NOT NULL); 2932CREATE TABLE t3 (c1 TINYINT NOT NULL); 2933CREATE TABLE t4 (c1 TINYINT NOT NULL); 2934CREATE TABLE t5 (c1 TINYINT NOT NULL); 2935CREATE TABLE t6 (c1 TINYINT NOT NULL); 2936INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2937INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2938INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 2939INSERT INTO t4 (c1) VALUES(10); 2940INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 2941SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 USING (c1); 2942c1 c1 2943SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1; 2944c1 c1 2945SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 >= 5; 2946c1 c1 2947DROP TABLE t1,t2,t3,t4,t5,t6; 2948CREATE TABLE t1 (c1 SMALLINT NOT NULL); 2949CREATE TABLE t2 (c1 SMALLINT NOT NULL); 2950CREATE TABLE t3 (c1 SMALLINT NOT NULL); 2951CREATE TABLE t4 (c1 SMALLINT NOT NULL); 2952CREATE TABLE t5 (c1 SMALLINT NOT NULL); 2953CREATE TABLE t6 (c1 SMALLINT NOT NULL); 2954INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2955INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2956INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 2957INSERT INTO t4 (c1) VALUES(10); 2958INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 2959SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 USING (c1); 2960c1 c1 2961SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1; 2962c1 c1 2963SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 >= 5; 2964c1 c1 2965DROP TABLE t1,t2,t3,t4,t5,t6; 2966CREATE TABLE t1 (c1 MEDIUMINT NOT NULL); 2967CREATE TABLE t2 (c1 MEDIUMINT NOT NULL); 2968CREATE TABLE t3 (c1 MEDIUMINT NOT NULL); 2969CREATE TABLE t4 (c1 MEDIUMINT NOT NULL); 2970CREATE TABLE t5 (c1 MEDIUMINT NOT NULL); 2971CREATE TABLE t6 (c1 MEDIUMINT NOT NULL); 2972INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2973INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2974INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 2975INSERT INTO t4 (c1) VALUES(10); 2976INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 2977SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 USING (c1); 2978c1 c1 2979SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1; 2980c1 c1 2981SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 >= 5; 2982c1 c1 2983DROP TABLE t1,t2,t3,t4,t5,t6; 2984CREATE TABLE t1 (c1 INT NOT NULL); 2985CREATE TABLE t2 (c1 INT NOT NULL); 2986CREATE TABLE t3 (c1 INT NOT NULL); 2987CREATE TABLE t4 (c1 INT NOT NULL); 2988CREATE TABLE t5 (c1 INT NOT NULL); 2989CREATE TABLE t6 (c1 INT NOT NULL); 2990INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2991INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2992INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 2993INSERT INTO t4 (c1) VALUES(10); 2994INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 2995SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 USING (c1); 2996c1 c1 2997SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1; 2998c1 c1 2999SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 >= 5; 3000c1 c1 3001DROP TABLE t1,t2,t3,t4,t5,t6; 3002CREATE TABLE t1 (c1 INTEGER NOT NULL); 3003CREATE TABLE t2 (c1 INTEGER NOT NULL); 3004CREATE TABLE t3 (c1 INTEGER NOT NULL); 3005CREATE TABLE t4 (c1 INTEGER NOT NULL); 3006CREATE TABLE t5 (c1 INTEGER NOT NULL); 3007CREATE TABLE t6 (c1 INTEGER NOT NULL); 3008INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3009INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3010INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 3011INSERT INTO t4 (c1) VALUES(10); 3012INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 3013SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 USING (c1); 3014c1 c1 3015SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1; 3016c1 c1 3017SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 >= 5; 3018c1 c1 3019DROP TABLE t1,t2,t3,t4,t5,t6; 3020CREATE TABLE t1 (c1 BIGINT NOT NULL); 3021CREATE TABLE t2 (c1 BIGINT NOT NULL); 3022CREATE TABLE t3 (c1 BIGINT NOT NULL); 3023CREATE TABLE t4 (c1 BIGINT NOT NULL); 3024CREATE TABLE t5 (c1 BIGINT NOT NULL); 3025CREATE TABLE t6 (c1 BIGINT NOT NULL); 3026INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3027INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3028INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 3029INSERT INTO t4 (c1) VALUES(10); 3030INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 3031SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 USING (c1); 3032c1 c1 3033SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1; 3034c1 c1 3035SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 >= 5; 3036c1 c1 3037DROP TABLE t1,t2,t3,t4,t5,t6; 3038CREATE TABLE t1 (c1 TINYINT NOT NULL); 3039CREATE TABLE t2 (c1 TINYINT NOT NULL); 3040CREATE TABLE t3 (c1 TINYINT NOT NULL); 3041CREATE TABLE t4 (c1 TINYINT NOT NULL); 3042CREATE TABLE t5 (c1 TINYINT NOT NULL); 3043CREATE TABLE t6 (c1 TINYINT NOT NULL); 3044INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3045INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3046INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 3047INSERT INTO t4 (c1) VALUES(10); 3048INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 3049SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 USING (c1); 3050c1 c1 30510 0 30521 1 30532 2 30543 3 30554 4 30565 5 30576 6 30587 7 30598 8 30609 9 3061SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1; 3062c1 c1 30630 0 30641 1 30652 2 30663 3 30674 4 30685 5 30696 6 30707 7 30718 8 30729 9 3073SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 != 5; 3074c1 c1 30750 0 30761 1 30772 2 30783 3 30794 4 30806 6 30817 7 30828 8 30839 9 3084DROP TABLE t1,t2,t3,t4,t5,t6; 3085CREATE TABLE t1 (c1 SMALLINT NOT NULL); 3086CREATE TABLE t2 (c1 SMALLINT NOT NULL); 3087CREATE TABLE t3 (c1 SMALLINT NOT NULL); 3088CREATE TABLE t4 (c1 SMALLINT NOT NULL); 3089CREATE TABLE t5 (c1 SMALLINT NOT NULL); 3090CREATE TABLE t6 (c1 SMALLINT NOT NULL); 3091INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3092INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3093INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 3094INSERT INTO t4 (c1) VALUES(10); 3095INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 3096SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 USING (c1); 3097c1 c1 30980 0 30991 1 31002 2 31013 3 31024 4 31035 5 31046 6 31057 7 31068 8 31079 9 3108SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1; 3109c1 c1 31100 0 31111 1 31122 2 31133 3 31144 4 31155 5 31166 6 31177 7 31188 8 31199 9 3120SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 != 5; 3121c1 c1 31220 0 31231 1 31242 2 31253 3 31264 4 31276 6 31287 7 31298 8 31309 9 3131DROP TABLE t1,t2,t3,t4,t5,t6; 3132CREATE TABLE t1 (c1 MEDIUMINT NOT NULL); 3133CREATE TABLE t2 (c1 MEDIUMINT NOT NULL); 3134CREATE TABLE t3 (c1 MEDIUMINT NOT NULL); 3135CREATE TABLE t4 (c1 MEDIUMINT NOT NULL); 3136CREATE TABLE t5 (c1 MEDIUMINT NOT NULL); 3137CREATE TABLE t6 (c1 MEDIUMINT NOT NULL); 3138INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3139INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3140INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 3141INSERT INTO t4 (c1) VALUES(10); 3142INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 3143SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 USING (c1); 3144c1 c1 31450 0 31461 1 31472 2 31483 3 31494 4 31505 5 31516 6 31527 7 31538 8 31549 9 3155SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1; 3156c1 c1 31570 0 31581 1 31592 2 31603 3 31614 4 31625 5 31636 6 31647 7 31658 8 31669 9 3167SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 != 5; 3168c1 c1 31690 0 31701 1 31712 2 31723 3 31734 4 31746 6 31757 7 31768 8 31779 9 3178DROP TABLE t1,t2,t3,t4,t5,t6; 3179CREATE TABLE t1 (c1 INT NOT NULL); 3180CREATE TABLE t2 (c1 INT NOT NULL); 3181CREATE TABLE t3 (c1 INT NOT NULL); 3182CREATE TABLE t4 (c1 INT NOT NULL); 3183CREATE TABLE t5 (c1 INT NOT NULL); 3184CREATE TABLE t6 (c1 INT NOT NULL); 3185INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3186INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3187INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 3188INSERT INTO t4 (c1) VALUES(10); 3189INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 3190SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 USING (c1); 3191c1 c1 31920 0 31931 1 31942 2 31953 3 31964 4 31975 5 31986 6 31997 7 32008 8 32019 9 3202SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1; 3203c1 c1 32040 0 32051 1 32062 2 32073 3 32084 4 32095 5 32106 6 32117 7 32128 8 32139 9 3214SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 != 5; 3215c1 c1 32160 0 32171 1 32182 2 32193 3 32204 4 32216 6 32227 7 32238 8 32249 9 3225DROP TABLE t1,t2,t3,t4,t5,t6; 3226CREATE TABLE t1 (c1 INTEGER NOT NULL); 3227CREATE TABLE t2 (c1 INTEGER NOT NULL); 3228CREATE TABLE t3 (c1 INTEGER NOT NULL); 3229CREATE TABLE t4 (c1 INTEGER NOT NULL); 3230CREATE TABLE t5 (c1 INTEGER NOT NULL); 3231CREATE TABLE t6 (c1 INTEGER NOT NULL); 3232INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3233INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3234INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 3235INSERT INTO t4 (c1) VALUES(10); 3236INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 3237SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 USING (c1); 3238c1 c1 32390 0 32401 1 32412 2 32423 3 32434 4 32445 5 32456 6 32467 7 32478 8 32489 9 3249SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1; 3250c1 c1 32510 0 32521 1 32532 2 32543 3 32554 4 32565 5 32576 6 32587 7 32598 8 32609 9 3261SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 != 5; 3262c1 c1 32630 0 32641 1 32652 2 32663 3 32674 4 32686 6 32697 7 32708 8 32719 9 3272DROP TABLE t1,t2,t3,t4,t5,t6; 3273CREATE TABLE t1 (c1 BIGINT NOT NULL); 3274CREATE TABLE t2 (c1 BIGINT NOT NULL); 3275CREATE TABLE t3 (c1 BIGINT NOT NULL); 3276CREATE TABLE t4 (c1 BIGINT NOT NULL); 3277CREATE TABLE t5 (c1 BIGINT NOT NULL); 3278CREATE TABLE t6 (c1 BIGINT NOT NULL); 3279INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3280INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3281INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 3282INSERT INTO t4 (c1) VALUES(10); 3283INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 3284SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 USING (c1); 3285c1 c1 32860 0 32871 1 32882 2 32893 3 32904 4 32915 5 32926 6 32937 7 32948 8 32959 9 3296SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1; 3297c1 c1 32980 0 32991 1 33002 2 33013 3 33024 4 33035 5 33046 6 33057 7 33068 8 33079 9 3308SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 != 5; 3309c1 c1 33100 0 33111 1 33122 2 33133 3 33144 4 33156 6 33167 7 33178 8 33189 9 3319DROP TABLE t1,t2,t3,t4,t5,t6; 3320CREATE TABLE t1 (c1 TINYINT NOT NULL); 3321CREATE TABLE t2 (c1 TINYINT NOT NULL); 3322CREATE TABLE t3 (c1 TINYINT NOT NULL); 3323CREATE TABLE t4 (c1 TINYINT NOT NULL); 3324CREATE TABLE t5 (c1 TINYINT NOT NULL); 3325CREATE TABLE t6 (c1 TINYINT NOT NULL); 3326INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3327INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3328INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 3329INSERT INTO t4 (c1) VALUES(10); 3330INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 3331SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 USING (c1); 3332c1 c1 33331 1 33343 3 33355 5 33367 7 33379 9 3338SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1; 3339c1 c1 33401 1 33413 3 33425 5 33437 7 33449 9 3345SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 != 5; 3346c1 c1 33471 1 33483 3 33497 7 33509 9 3351DROP TABLE t1,t2,t3,t4,t5,t6; 3352CREATE TABLE t1 (c1 SMALLINT NOT NULL); 3353CREATE TABLE t2 (c1 SMALLINT NOT NULL); 3354CREATE TABLE t3 (c1 SMALLINT NOT NULL); 3355CREATE TABLE t4 (c1 SMALLINT NOT NULL); 3356CREATE TABLE t5 (c1 SMALLINT NOT NULL); 3357CREATE TABLE t6 (c1 SMALLINT NOT NULL); 3358INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3359INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3360INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 3361INSERT INTO t4 (c1) VALUES(10); 3362INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 3363SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 USING (c1); 3364c1 c1 33651 1 33663 3 33675 5 33687 7 33699 9 3370SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1; 3371c1 c1 33721 1 33733 3 33745 5 33757 7 33769 9 3377SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 != 5; 3378c1 c1 33791 1 33803 3 33817 7 33829 9 3383DROP TABLE t1,t2,t3,t4,t5,t6; 3384CREATE TABLE t1 (c1 MEDIUMINT NOT NULL); 3385CREATE TABLE t2 (c1 MEDIUMINT NOT NULL); 3386CREATE TABLE t3 (c1 MEDIUMINT NOT NULL); 3387CREATE TABLE t4 (c1 MEDIUMINT NOT NULL); 3388CREATE TABLE t5 (c1 MEDIUMINT NOT NULL); 3389CREATE TABLE t6 (c1 MEDIUMINT 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,t3.c1 FROM t1 CROSS JOIN t3 USING (c1); 3396c1 c1 33971 1 33983 3 33995 5 34007 7 34019 9 3402SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1; 3403c1 c1 34041 1 34053 3 34065 5 34077 7 34089 9 3409SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 != 5; 3410c1 c1 34111 1 34123 3 34137 7 34149 9 3415DROP TABLE t1,t2,t3,t4,t5,t6; 3416CREATE TABLE t1 (c1 INT NOT NULL); 3417CREATE TABLE t2 (c1 INT NOT NULL); 3418CREATE TABLE t3 (c1 INT NOT NULL); 3419CREATE TABLE t4 (c1 INT NOT NULL); 3420CREATE TABLE t5 (c1 INT NOT NULL); 3421CREATE TABLE t6 (c1 INT NOT NULL); 3422INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3423INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3424INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 3425INSERT INTO t4 (c1) VALUES(10); 3426INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 3427SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 USING (c1); 3428c1 c1 34291 1 34303 3 34315 5 34327 7 34339 9 3434SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1; 3435c1 c1 34361 1 34373 3 34385 5 34397 7 34409 9 3441SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 != 5; 3442c1 c1 34431 1 34443 3 34457 7 34469 9 3447DROP TABLE t1,t2,t3,t4,t5,t6; 3448CREATE TABLE t1 (c1 INTEGER NOT NULL); 3449CREATE TABLE t2 (c1 INTEGER NOT NULL); 3450CREATE TABLE t3 (c1 INTEGER NOT NULL); 3451CREATE TABLE t4 (c1 INTEGER NOT NULL); 3452CREATE TABLE t5 (c1 INTEGER NOT NULL); 3453CREATE TABLE t6 (c1 INTEGER NOT NULL); 3454INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3455INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3456INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 3457INSERT INTO t4 (c1) VALUES(10); 3458INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 3459SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 USING (c1); 3460c1 c1 34611 1 34623 3 34635 5 34647 7 34659 9 3466SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1; 3467c1 c1 34681 1 34693 3 34705 5 34717 7 34729 9 3473SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 != 5; 3474c1 c1 34751 1 34763 3 34777 7 34789 9 3479DROP TABLE t1,t2,t3,t4,t5,t6; 3480CREATE TABLE t1 (c1 BIGINT NOT NULL); 3481CREATE TABLE t2 (c1 BIGINT NOT NULL); 3482CREATE TABLE t3 (c1 BIGINT NOT NULL); 3483CREATE TABLE t4 (c1 BIGINT NOT NULL); 3484CREATE TABLE t5 (c1 BIGINT NOT NULL); 3485CREATE TABLE t6 (c1 BIGINT NOT NULL); 3486INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3487INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3488INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 3489INSERT INTO t4 (c1) VALUES(10); 3490INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 3491SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 USING (c1); 3492c1 c1 34931 1 34943 3 34955 5 34967 7 34979 9 3498SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1; 3499c1 c1 35001 1 35013 3 35025 5 35037 7 35049 9 3505SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 != 5; 3506c1 c1 35071 1 35083 3 35097 7 35109 9 3511DROP TABLE t1,t2,t3,t4,t5,t6; 3512CREATE TABLE t1 (c1 TINYINT NOT NULL); 3513CREATE TABLE t2 (c1 TINYINT NOT NULL); 3514CREATE TABLE t3 (c1 TINYINT NOT NULL); 3515CREATE TABLE t4 (c1 TINYINT NOT NULL); 3516CREATE TABLE t5 (c1 TINYINT NOT NULL); 3517CREATE TABLE t6 (c1 TINYINT NOT NULL); 3518INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3519INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3520INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 3521INSERT INTO t4 (c1) VALUES(10); 3522INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 3523SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 USING (c1); 3524c1 c1 3525SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1; 3526c1 c1 3527SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 != 5; 3528c1 c1 3529DROP TABLE t1,t2,t3,t4,t5,t6; 3530CREATE TABLE t1 (c1 SMALLINT NOT NULL); 3531CREATE TABLE t2 (c1 SMALLINT NOT NULL); 3532CREATE TABLE t3 (c1 SMALLINT NOT NULL); 3533CREATE TABLE t4 (c1 SMALLINT NOT NULL); 3534CREATE TABLE t5 (c1 SMALLINT NOT NULL); 3535CREATE TABLE t6 (c1 SMALLINT NOT NULL); 3536INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3537INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3538INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 3539INSERT INTO t4 (c1) VALUES(10); 3540INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 3541SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 USING (c1); 3542c1 c1 3543SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1; 3544c1 c1 3545SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 != 5; 3546c1 c1 3547DROP TABLE t1,t2,t3,t4,t5,t6; 3548CREATE TABLE t1 (c1 MEDIUMINT NOT NULL); 3549CREATE TABLE t2 (c1 MEDIUMINT NOT NULL); 3550CREATE TABLE t3 (c1 MEDIUMINT NOT NULL); 3551CREATE TABLE t4 (c1 MEDIUMINT NOT NULL); 3552CREATE TABLE t5 (c1 MEDIUMINT NOT NULL); 3553CREATE TABLE t6 (c1 MEDIUMINT NOT NULL); 3554INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3555INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3556INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 3557INSERT INTO t4 (c1) VALUES(10); 3558INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 3559SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 USING (c1); 3560c1 c1 3561SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1; 3562c1 c1 3563SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 != 5; 3564c1 c1 3565DROP TABLE t1,t2,t3,t4,t5,t6; 3566CREATE TABLE t1 (c1 INT NOT NULL); 3567CREATE TABLE t2 (c1 INT NOT NULL); 3568CREATE TABLE t3 (c1 INT NOT NULL); 3569CREATE TABLE t4 (c1 INT NOT NULL); 3570CREATE TABLE t5 (c1 INT NOT NULL); 3571CREATE TABLE t6 (c1 INT NOT NULL); 3572INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3573INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3574INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 3575INSERT INTO t4 (c1) VALUES(10); 3576INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 3577SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 USING (c1); 3578c1 c1 3579SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1; 3580c1 c1 3581SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 != 5; 3582c1 c1 3583DROP TABLE t1,t2,t3,t4,t5,t6; 3584CREATE TABLE t1 (c1 INTEGER NOT NULL); 3585CREATE TABLE t2 (c1 INTEGER NOT NULL); 3586CREATE TABLE t3 (c1 INTEGER NOT NULL); 3587CREATE TABLE t4 (c1 INTEGER NOT NULL); 3588CREATE TABLE t5 (c1 INTEGER NOT NULL); 3589CREATE TABLE t6 (c1 INTEGER NOT NULL); 3590INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3591INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3592INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 3593INSERT INTO t4 (c1) VALUES(10); 3594INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 3595SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 USING (c1); 3596c1 c1 3597SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1; 3598c1 c1 3599SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 != 5; 3600c1 c1 3601DROP TABLE t1,t2,t3,t4,t5,t6; 3602CREATE TABLE t1 (c1 BIGINT NOT NULL); 3603CREATE TABLE t2 (c1 BIGINT NOT NULL); 3604CREATE TABLE t3 (c1 BIGINT NOT NULL); 3605CREATE TABLE t4 (c1 BIGINT NOT NULL); 3606CREATE TABLE t5 (c1 BIGINT NOT NULL); 3607CREATE TABLE t6 (c1 BIGINT NOT NULL); 3608INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3609INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3610INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 3611INSERT INTO t4 (c1) VALUES(10); 3612INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 3613SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 USING (c1); 3614c1 c1 3615SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1; 3616c1 c1 3617SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 != 5; 3618c1 c1 3619DROP TABLE t1,t2,t3,t4,t5,t6; 3620CREATE TABLE t1 (c1 TINYINT NOT NULL); 3621CREATE TABLE t2 (c1 TINYINT NOT NULL); 3622CREATE TABLE t3 (c1 TINYINT NOT NULL); 3623CREATE TABLE t4 (c1 TINYINT NOT NULL); 3624CREATE TABLE t5 (c1 TINYINT NOT NULL); 3625CREATE TABLE t6 (c1 TINYINT NOT NULL); 3626INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3627INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3628INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 3629INSERT INTO t4 (c1) VALUES(10); 3630INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 3631SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 USING (c1); 3632c1 c1 3633SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1; 3634c1 c1 3635SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 != 5; 3636c1 c1 3637DROP TABLE t1,t2,t3,t4,t5,t6; 3638CREATE TABLE t1 (c1 SMALLINT NOT NULL); 3639CREATE TABLE t2 (c1 SMALLINT NOT NULL); 3640CREATE TABLE t3 (c1 SMALLINT NOT NULL); 3641CREATE TABLE t4 (c1 SMALLINT NOT NULL); 3642CREATE TABLE t5 (c1 SMALLINT NOT NULL); 3643CREATE TABLE t6 (c1 SMALLINT NOT NULL); 3644INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3645INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3646INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 3647INSERT INTO t4 (c1) VALUES(10); 3648INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 3649SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 USING (c1); 3650c1 c1 3651SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1; 3652c1 c1 3653SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 != 5; 3654c1 c1 3655DROP TABLE t1,t2,t3,t4,t5,t6; 3656CREATE TABLE t1 (c1 MEDIUMINT NOT NULL); 3657CREATE TABLE t2 (c1 MEDIUMINT NOT NULL); 3658CREATE TABLE t3 (c1 MEDIUMINT NOT NULL); 3659CREATE TABLE t4 (c1 MEDIUMINT NOT NULL); 3660CREATE TABLE t5 (c1 MEDIUMINT NOT NULL); 3661CREATE TABLE t6 (c1 MEDIUMINT NOT NULL); 3662INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3663INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3664INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 3665INSERT INTO t4 (c1) VALUES(10); 3666INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 3667SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 USING (c1); 3668c1 c1 3669SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1; 3670c1 c1 3671SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 != 5; 3672c1 c1 3673DROP TABLE t1,t2,t3,t4,t5,t6; 3674CREATE TABLE t1 (c1 INT NOT NULL); 3675CREATE TABLE t2 (c1 INT NOT NULL); 3676CREATE TABLE t3 (c1 INT NOT NULL); 3677CREATE TABLE t4 (c1 INT NOT NULL); 3678CREATE TABLE t5 (c1 INT NOT NULL); 3679CREATE TABLE t6 (c1 INT NOT NULL); 3680INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3681INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3682INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 3683INSERT INTO t4 (c1) VALUES(10); 3684INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 3685SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 USING (c1); 3686c1 c1 3687SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1; 3688c1 c1 3689SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 != 5; 3690c1 c1 3691DROP TABLE t1,t2,t3,t4,t5,t6; 3692CREATE TABLE t1 (c1 INTEGER NOT NULL); 3693CREATE TABLE t2 (c1 INTEGER NOT NULL); 3694CREATE TABLE t3 (c1 INTEGER NOT NULL); 3695CREATE TABLE t4 (c1 INTEGER NOT NULL); 3696CREATE TABLE t5 (c1 INTEGER NOT NULL); 3697CREATE TABLE t6 (c1 INTEGER NOT NULL); 3698INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3699INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3700INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 3701INSERT INTO t4 (c1) VALUES(10); 3702INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 3703SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 USING (c1); 3704c1 c1 3705SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1; 3706c1 c1 3707SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 != 5; 3708c1 c1 3709DROP TABLE t1,t2,t3,t4,t5,t6; 3710CREATE TABLE t1 (c1 BIGINT NOT NULL); 3711CREATE TABLE t2 (c1 BIGINT NOT NULL); 3712CREATE TABLE t3 (c1 BIGINT NOT NULL); 3713CREATE TABLE t4 (c1 BIGINT NOT NULL); 3714CREATE TABLE t5 (c1 BIGINT NOT NULL); 3715CREATE TABLE t6 (c1 BIGINT NOT NULL); 3716INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3717INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3718INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 3719INSERT INTO t4 (c1) VALUES(10); 3720INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 3721SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 USING (c1); 3722c1 c1 3723SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1; 3724c1 c1 3725SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 != 5; 3726c1 c1 3727DROP TABLE t1,t2,t3,t4,t5,t6; 3728CREATE TABLE t1 (c1 TINYINT NOT NULL); 3729CREATE TABLE t2 (c1 TINYINT NOT NULL); 3730CREATE TABLE t3 (c1 TINYINT NOT NULL); 3731CREATE TABLE t4 (c1 TINYINT NOT NULL); 3732CREATE TABLE t5 (c1 TINYINT NOT NULL); 3733CREATE TABLE t6 (c1 TINYINT NOT NULL); 3734INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3735INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3736INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 3737INSERT INTO t4 (c1) VALUES(10); 3738INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 3739SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 USING (c1); 3740c1 c1 3741SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1; 3742c1 c1 3743SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 != 5; 3744c1 c1 3745DROP TABLE t1,t2,t3,t4,t5,t6; 3746CREATE TABLE t1 (c1 SMALLINT NOT NULL); 3747CREATE TABLE t2 (c1 SMALLINT NOT NULL); 3748CREATE TABLE t3 (c1 SMALLINT NOT NULL); 3749CREATE TABLE t4 (c1 SMALLINT NOT NULL); 3750CREATE TABLE t5 (c1 SMALLINT NOT NULL); 3751CREATE TABLE t6 (c1 SMALLINT NOT NULL); 3752INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3753INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3754INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 3755INSERT INTO t4 (c1) VALUES(10); 3756INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 3757SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 USING (c1); 3758c1 c1 3759SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1; 3760c1 c1 3761SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 != 5; 3762c1 c1 3763DROP TABLE t1,t2,t3,t4,t5,t6; 3764CREATE TABLE t1 (c1 MEDIUMINT NOT NULL); 3765CREATE TABLE t2 (c1 MEDIUMINT NOT NULL); 3766CREATE TABLE t3 (c1 MEDIUMINT NOT NULL); 3767CREATE TABLE t4 (c1 MEDIUMINT NOT NULL); 3768CREATE TABLE t5 (c1 MEDIUMINT NOT NULL); 3769CREATE TABLE t6 (c1 MEDIUMINT NOT NULL); 3770INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3771INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3772INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 3773INSERT INTO t4 (c1) VALUES(10); 3774INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 3775SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 USING (c1); 3776c1 c1 3777SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1; 3778c1 c1 3779SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 != 5; 3780c1 c1 3781DROP TABLE t1,t2,t3,t4,t5,t6; 3782CREATE TABLE t1 (c1 INT NOT NULL); 3783CREATE TABLE t2 (c1 INT NOT NULL); 3784CREATE TABLE t3 (c1 INT NOT NULL); 3785CREATE TABLE t4 (c1 INT NOT NULL); 3786CREATE TABLE t5 (c1 INT NOT NULL); 3787CREATE TABLE t6 (c1 INT NOT NULL); 3788INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3789INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3790INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 3791INSERT INTO t4 (c1) VALUES(10); 3792INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 3793SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 USING (c1); 3794c1 c1 3795SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1; 3796c1 c1 3797SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 != 5; 3798c1 c1 3799DROP TABLE t1,t2,t3,t4,t5,t6; 3800CREATE TABLE t1 (c1 INTEGER NOT NULL); 3801CREATE TABLE t2 (c1 INTEGER NOT NULL); 3802CREATE TABLE t3 (c1 INTEGER NOT NULL); 3803CREATE TABLE t4 (c1 INTEGER NOT NULL); 3804CREATE TABLE t5 (c1 INTEGER NOT NULL); 3805CREATE TABLE t6 (c1 INTEGER NOT NULL); 3806INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3807INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3808INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 3809INSERT INTO t4 (c1) VALUES(10); 3810INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 3811SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 USING (c1); 3812c1 c1 3813SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1; 3814c1 c1 3815SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 != 5; 3816c1 c1 3817DROP TABLE t1,t2,t3,t4,t5,t6; 3818CREATE TABLE t1 (c1 BIGINT NOT NULL); 3819CREATE TABLE t2 (c1 BIGINT NOT NULL); 3820CREATE TABLE t3 (c1 BIGINT NOT NULL); 3821CREATE TABLE t4 (c1 BIGINT NOT NULL); 3822CREATE TABLE t5 (c1 BIGINT NOT NULL); 3823CREATE TABLE t6 (c1 BIGINT NOT NULL); 3824INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3825INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3826INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 3827INSERT INTO t4 (c1) VALUES(10); 3828INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 3829SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 USING (c1); 3830c1 c1 3831SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1; 3832c1 c1 3833SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 != 5; 3834c1 c1 3835DROP TABLE t1,t2,t3,t4,t5,t6; 3836CREATE TABLE t1 (c1 TINYINT NOT NULL); 3837CREATE TABLE t2 (c1 TINYINT NOT NULL); 3838CREATE TABLE t3 (c1 TINYINT NOT NULL); 3839CREATE TABLE t4 (c1 TINYINT NOT NULL); 3840CREATE TABLE t5 (c1 TINYINT NOT NULL); 3841CREATE TABLE t6 (c1 TINYINT NOT NULL); 3842INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3843INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3844INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 3845INSERT INTO t4 (c1) VALUES(10); 3846INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 3847SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 USING (c1); 3848c1 c1 38490 0 38501 1 38512 2 38523 3 38534 4 38545 5 38556 6 38567 7 38578 8 38589 9 3859SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1; 3860c1 c1 38610 0 38621 1 38632 2 38643 3 38654 4 38665 5 38676 6 38687 7 38698 8 38709 9 3871SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 <> 5; 3872c1 c1 38730 0 38741 1 38752 2 38763 3 38774 4 38786 6 38797 7 38808 8 38819 9 3882DROP TABLE t1,t2,t3,t4,t5,t6; 3883CREATE TABLE t1 (c1 SMALLINT NOT NULL); 3884CREATE TABLE t2 (c1 SMALLINT NOT NULL); 3885CREATE TABLE t3 (c1 SMALLINT NOT NULL); 3886CREATE TABLE t4 (c1 SMALLINT NOT NULL); 3887CREATE TABLE t5 (c1 SMALLINT NOT NULL); 3888CREATE TABLE t6 (c1 SMALLINT NOT NULL); 3889INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3890INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3891INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 3892INSERT INTO t4 (c1) VALUES(10); 3893INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 3894SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 USING (c1); 3895c1 c1 38960 0 38971 1 38982 2 38993 3 39004 4 39015 5 39026 6 39037 7 39048 8 39059 9 3906SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1; 3907c1 c1 39080 0 39091 1 39102 2 39113 3 39124 4 39135 5 39146 6 39157 7 39168 8 39179 9 3918SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 <> 5; 3919c1 c1 39200 0 39211 1 39222 2 39233 3 39244 4 39256 6 39267 7 39278 8 39289 9 3929DROP TABLE t1,t2,t3,t4,t5,t6; 3930CREATE TABLE t1 (c1 MEDIUMINT NOT NULL); 3931CREATE TABLE t2 (c1 MEDIUMINT NOT NULL); 3932CREATE TABLE t3 (c1 MEDIUMINT NOT NULL); 3933CREATE TABLE t4 (c1 MEDIUMINT NOT NULL); 3934CREATE TABLE t5 (c1 MEDIUMINT NOT NULL); 3935CREATE TABLE t6 (c1 MEDIUMINT NOT NULL); 3936INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3937INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3938INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 3939INSERT INTO t4 (c1) VALUES(10); 3940INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 3941SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 USING (c1); 3942c1 c1 39430 0 39441 1 39452 2 39463 3 39474 4 39485 5 39496 6 39507 7 39518 8 39529 9 3953SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1; 3954c1 c1 39550 0 39561 1 39572 2 39583 3 39594 4 39605 5 39616 6 39627 7 39638 8 39649 9 3965SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 <> 5; 3966c1 c1 39670 0 39681 1 39692 2 39703 3 39714 4 39726 6 39737 7 39748 8 39759 9 3976DROP TABLE t1,t2,t3,t4,t5,t6; 3977CREATE TABLE t1 (c1 INT NOT NULL); 3978CREATE TABLE t2 (c1 INT NOT NULL); 3979CREATE TABLE t3 (c1 INT NOT NULL); 3980CREATE TABLE t4 (c1 INT NOT NULL); 3981CREATE TABLE t5 (c1 INT NOT NULL); 3982CREATE TABLE t6 (c1 INT NOT NULL); 3983INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3984INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3985INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 3986INSERT INTO t4 (c1) VALUES(10); 3987INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 3988SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 USING (c1); 3989c1 c1 39900 0 39911 1 39922 2 39933 3 39944 4 39955 5 39966 6 39977 7 39988 8 39999 9 4000SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1; 4001c1 c1 40020 0 40031 1 40042 2 40053 3 40064 4 40075 5 40086 6 40097 7 40108 8 40119 9 4012SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 <> 5; 4013c1 c1 40140 0 40151 1 40162 2 40173 3 40184 4 40196 6 40207 7 40218 8 40229 9 4023DROP TABLE t1,t2,t3,t4,t5,t6; 4024CREATE TABLE t1 (c1 INTEGER NOT NULL); 4025CREATE TABLE t2 (c1 INTEGER NOT NULL); 4026CREATE TABLE t3 (c1 INTEGER NOT NULL); 4027CREATE TABLE t4 (c1 INTEGER NOT NULL); 4028CREATE TABLE t5 (c1 INTEGER NOT NULL); 4029CREATE TABLE t6 (c1 INTEGER NOT NULL); 4030INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 4031INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 4032INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 4033INSERT INTO t4 (c1) VALUES(10); 4034INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 4035SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 USING (c1); 4036c1 c1 40370 0 40381 1 40392 2 40403 3 40414 4 40425 5 40436 6 40447 7 40458 8 40469 9 4047SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1; 4048c1 c1 40490 0 40501 1 40512 2 40523 3 40534 4 40545 5 40556 6 40567 7 40578 8 40589 9 4059SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 <> 5; 4060c1 c1 40610 0 40621 1 40632 2 40643 3 40654 4 40666 6 40677 7 40688 8 40699 9 4070DROP TABLE t1,t2,t3,t4,t5,t6; 4071CREATE TABLE t1 (c1 BIGINT NOT NULL); 4072CREATE TABLE t2 (c1 BIGINT NOT NULL); 4073CREATE TABLE t3 (c1 BIGINT NOT NULL); 4074CREATE TABLE t4 (c1 BIGINT NOT NULL); 4075CREATE TABLE t5 (c1 BIGINT NOT NULL); 4076CREATE TABLE t6 (c1 BIGINT NOT NULL); 4077INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 4078INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 4079INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 4080INSERT INTO t4 (c1) VALUES(10); 4081INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 4082SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 USING (c1); 4083c1 c1 40840 0 40851 1 40862 2 40873 3 40884 4 40895 5 40906 6 40917 7 40928 8 40939 9 4094SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1; 4095c1 c1 40960 0 40971 1 40982 2 40993 3 41004 4 41015 5 41026 6 41037 7 41048 8 41059 9 4106SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 <> 5; 4107c1 c1 41080 0 41091 1 41102 2 41113 3 41124 4 41136 6 41147 7 41158 8 41169 9 4117DROP TABLE t1,t2,t3,t4,t5,t6; 4118CREATE TABLE t1 (c1 TINYINT NOT NULL); 4119CREATE TABLE t2 (c1 TINYINT NOT NULL); 4120CREATE TABLE t3 (c1 TINYINT NOT NULL); 4121CREATE TABLE t4 (c1 TINYINT NOT NULL); 4122CREATE TABLE t5 (c1 TINYINT NOT NULL); 4123CREATE TABLE t6 (c1 TINYINT NOT NULL); 4124INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 4125INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 4126INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 4127INSERT INTO t4 (c1) VALUES(10); 4128INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 4129SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 USING (c1); 4130c1 c1 41311 1 41323 3 41335 5 41347 7 41359 9 4136SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1; 4137c1 c1 41381 1 41393 3 41405 5 41417 7 41429 9 4143SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 <> 5; 4144c1 c1 41451 1 41463 3 41477 7 41489 9 4149DROP TABLE t1,t2,t3,t4,t5,t6; 4150CREATE TABLE t1 (c1 SMALLINT NOT NULL); 4151CREATE TABLE t2 (c1 SMALLINT NOT NULL); 4152CREATE TABLE t3 (c1 SMALLINT NOT NULL); 4153CREATE TABLE t4 (c1 SMALLINT NOT NULL); 4154CREATE TABLE t5 (c1 SMALLINT NOT NULL); 4155CREATE TABLE t6 (c1 SMALLINT NOT NULL); 4156INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 4157INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 4158INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 4159INSERT INTO t4 (c1) VALUES(10); 4160INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 4161SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 USING (c1); 4162c1 c1 41631 1 41643 3 41655 5 41667 7 41679 9 4168SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1; 4169c1 c1 41701 1 41713 3 41725 5 41737 7 41749 9 4175SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 <> 5; 4176c1 c1 41771 1 41783 3 41797 7 41809 9 4181DROP TABLE t1,t2,t3,t4,t5,t6; 4182CREATE TABLE t1 (c1 MEDIUMINT NOT NULL); 4183CREATE TABLE t2 (c1 MEDIUMINT NOT NULL); 4184CREATE TABLE t3 (c1 MEDIUMINT NOT NULL); 4185CREATE TABLE t4 (c1 MEDIUMINT NOT NULL); 4186CREATE TABLE t5 (c1 MEDIUMINT NOT NULL); 4187CREATE TABLE t6 (c1 MEDIUMINT NOT NULL); 4188INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 4189INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 4190INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 4191INSERT INTO t4 (c1) VALUES(10); 4192INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 4193SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 USING (c1); 4194c1 c1 41951 1 41963 3 41975 5 41987 7 41999 9 4200SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1; 4201c1 c1 42021 1 42033 3 42045 5 42057 7 42069 9 4207SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 <> 5; 4208c1 c1 42091 1 42103 3 42117 7 42129 9 4213DROP TABLE t1,t2,t3,t4,t5,t6; 4214CREATE TABLE t1 (c1 INT NOT NULL); 4215CREATE TABLE t2 (c1 INT NOT NULL); 4216CREATE TABLE t3 (c1 INT NOT NULL); 4217CREATE TABLE t4 (c1 INT NOT NULL); 4218CREATE TABLE t5 (c1 INT NOT NULL); 4219CREATE TABLE t6 (c1 INT NOT NULL); 4220INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 4221INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 4222INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 4223INSERT INTO t4 (c1) VALUES(10); 4224INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 4225SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 USING (c1); 4226c1 c1 42271 1 42283 3 42295 5 42307 7 42319 9 4232SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1; 4233c1 c1 42341 1 42353 3 42365 5 42377 7 42389 9 4239SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 <> 5; 4240c1 c1 42411 1 42423 3 42437 7 42449 9 4245DROP TABLE t1,t2,t3,t4,t5,t6; 4246CREATE TABLE t1 (c1 INTEGER NOT NULL); 4247CREATE TABLE t2 (c1 INTEGER NOT NULL); 4248CREATE TABLE t3 (c1 INTEGER NOT NULL); 4249CREATE TABLE t4 (c1 INTEGER NOT NULL); 4250CREATE TABLE t5 (c1 INTEGER NOT NULL); 4251CREATE TABLE t6 (c1 INTEGER NOT NULL); 4252INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 4253INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 4254INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 4255INSERT INTO t4 (c1) VALUES(10); 4256INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 4257SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 USING (c1); 4258c1 c1 42591 1 42603 3 42615 5 42627 7 42639 9 4264SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1; 4265c1 c1 42661 1 42673 3 42685 5 42697 7 42709 9 4271SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 <> 5; 4272c1 c1 42731 1 42743 3 42757 7 42769 9 4277DROP TABLE t1,t2,t3,t4,t5,t6; 4278CREATE TABLE t1 (c1 BIGINT NOT NULL); 4279CREATE TABLE t2 (c1 BIGINT NOT NULL); 4280CREATE TABLE t3 (c1 BIGINT NOT NULL); 4281CREATE TABLE t4 (c1 BIGINT NOT NULL); 4282CREATE TABLE t5 (c1 BIGINT NOT NULL); 4283CREATE TABLE t6 (c1 BIGINT NOT NULL); 4284INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 4285INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 4286INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 4287INSERT INTO t4 (c1) VALUES(10); 4288INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 4289SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 USING (c1); 4290c1 c1 42911 1 42923 3 42935 5 42947 7 42959 9 4296SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1; 4297c1 c1 42981 1 42993 3 43005 5 43017 7 43029 9 4303SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 <> 5; 4304c1 c1 43051 1 43063 3 43077 7 43089 9 4309DROP TABLE t1,t2,t3,t4,t5,t6; 4310CREATE TABLE t1 (c1 TINYINT NOT NULL); 4311CREATE TABLE t2 (c1 TINYINT NOT NULL); 4312CREATE TABLE t3 (c1 TINYINT NOT NULL); 4313CREATE TABLE t4 (c1 TINYINT NOT NULL); 4314CREATE TABLE t5 (c1 TINYINT NOT NULL); 4315CREATE TABLE t6 (c1 TINYINT NOT NULL); 4316INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 4317INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 4318INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 4319INSERT INTO t4 (c1) VALUES(10); 4320INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 4321SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 USING (c1); 4322c1 c1 4323SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1; 4324c1 c1 4325SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 <> 5; 4326c1 c1 4327DROP TABLE t1,t2,t3,t4,t5,t6; 4328CREATE TABLE t1 (c1 SMALLINT NOT NULL); 4329CREATE TABLE t2 (c1 SMALLINT NOT NULL); 4330CREATE TABLE t3 (c1 SMALLINT NOT NULL); 4331CREATE TABLE t4 (c1 SMALLINT NOT NULL); 4332CREATE TABLE t5 (c1 SMALLINT NOT NULL); 4333CREATE TABLE t6 (c1 SMALLINT NOT NULL); 4334INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 4335INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 4336INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 4337INSERT INTO t4 (c1) VALUES(10); 4338INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 4339SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 USING (c1); 4340c1 c1 4341SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1; 4342c1 c1 4343SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 <> 5; 4344c1 c1 4345DROP TABLE t1,t2,t3,t4,t5,t6; 4346CREATE TABLE t1 (c1 MEDIUMINT NOT NULL); 4347CREATE TABLE t2 (c1 MEDIUMINT NOT NULL); 4348CREATE TABLE t3 (c1 MEDIUMINT NOT NULL); 4349CREATE TABLE t4 (c1 MEDIUMINT NOT NULL); 4350CREATE TABLE t5 (c1 MEDIUMINT NOT NULL); 4351CREATE TABLE t6 (c1 MEDIUMINT NOT NULL); 4352INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 4353INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 4354INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 4355INSERT INTO t4 (c1) VALUES(10); 4356INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 4357SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 USING (c1); 4358c1 c1 4359SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1; 4360c1 c1 4361SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 <> 5; 4362c1 c1 4363DROP TABLE t1,t2,t3,t4,t5,t6; 4364CREATE TABLE t1 (c1 INT NOT NULL); 4365CREATE TABLE t2 (c1 INT NOT NULL); 4366CREATE TABLE t3 (c1 INT NOT NULL); 4367CREATE TABLE t4 (c1 INT NOT NULL); 4368CREATE TABLE t5 (c1 INT NOT NULL); 4369CREATE TABLE t6 (c1 INT NOT NULL); 4370INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 4371INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 4372INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 4373INSERT INTO t4 (c1) VALUES(10); 4374INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 4375SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 USING (c1); 4376c1 c1 4377SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1; 4378c1 c1 4379SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 <> 5; 4380c1 c1 4381DROP TABLE t1,t2,t3,t4,t5,t6; 4382CREATE TABLE t1 (c1 INTEGER NOT NULL); 4383CREATE TABLE t2 (c1 INTEGER NOT NULL); 4384CREATE TABLE t3 (c1 INTEGER NOT NULL); 4385CREATE TABLE t4 (c1 INTEGER NOT NULL); 4386CREATE TABLE t5 (c1 INTEGER NOT NULL); 4387CREATE TABLE t6 (c1 INTEGER NOT NULL); 4388INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 4389INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 4390INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 4391INSERT INTO t4 (c1) VALUES(10); 4392INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 4393SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 USING (c1); 4394c1 c1 4395SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1; 4396c1 c1 4397SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 <> 5; 4398c1 c1 4399DROP TABLE t1,t2,t3,t4,t5,t6; 4400CREATE TABLE t1 (c1 BIGINT NOT NULL); 4401CREATE TABLE t2 (c1 BIGINT NOT NULL); 4402CREATE TABLE t3 (c1 BIGINT NOT NULL); 4403CREATE TABLE t4 (c1 BIGINT NOT NULL); 4404CREATE TABLE t5 (c1 BIGINT NOT NULL); 4405CREATE TABLE t6 (c1 BIGINT NOT NULL); 4406INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 4407INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 4408INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 4409INSERT INTO t4 (c1) VALUES(10); 4410INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 4411SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 USING (c1); 4412c1 c1 4413SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1; 4414c1 c1 4415SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 <> 5; 4416c1 c1 4417DROP TABLE t1,t2,t3,t4,t5,t6; 4418CREATE TABLE t1 (c1 TINYINT NOT NULL); 4419CREATE TABLE t2 (c1 TINYINT NOT NULL); 4420CREATE TABLE t3 (c1 TINYINT NOT NULL); 4421CREATE TABLE t4 (c1 TINYINT NOT NULL); 4422CREATE TABLE t5 (c1 TINYINT NOT NULL); 4423CREATE TABLE t6 (c1 TINYINT NOT NULL); 4424INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 4425INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 4426INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 4427INSERT INTO t4 (c1) VALUES(10); 4428INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 4429SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 USING (c1); 4430c1 c1 4431SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1; 4432c1 c1 4433SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 <> 5; 4434c1 c1 4435DROP TABLE t1,t2,t3,t4,t5,t6; 4436CREATE TABLE t1 (c1 SMALLINT NOT NULL); 4437CREATE TABLE t2 (c1 SMALLINT NOT NULL); 4438CREATE TABLE t3 (c1 SMALLINT NOT NULL); 4439CREATE TABLE t4 (c1 SMALLINT NOT NULL); 4440CREATE TABLE t5 (c1 SMALLINT NOT NULL); 4441CREATE TABLE t6 (c1 SMALLINT NOT NULL); 4442INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 4443INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 4444INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 4445INSERT INTO t4 (c1) VALUES(10); 4446INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 4447SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 USING (c1); 4448c1 c1 4449SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1; 4450c1 c1 4451SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 <> 5; 4452c1 c1 4453DROP TABLE t1,t2,t3,t4,t5,t6; 4454CREATE TABLE t1 (c1 MEDIUMINT NOT NULL); 4455CREATE TABLE t2 (c1 MEDIUMINT NOT NULL); 4456CREATE TABLE t3 (c1 MEDIUMINT NOT NULL); 4457CREATE TABLE t4 (c1 MEDIUMINT NOT NULL); 4458CREATE TABLE t5 (c1 MEDIUMINT NOT NULL); 4459CREATE TABLE t6 (c1 MEDIUMINT NOT NULL); 4460INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 4461INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 4462INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 4463INSERT INTO t4 (c1) VALUES(10); 4464INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 4465SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 USING (c1); 4466c1 c1 4467SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1; 4468c1 c1 4469SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 <> 5; 4470c1 c1 4471DROP TABLE t1,t2,t3,t4,t5,t6; 4472CREATE TABLE t1 (c1 INT NOT NULL); 4473CREATE TABLE t2 (c1 INT NOT NULL); 4474CREATE TABLE t3 (c1 INT NOT NULL); 4475CREATE TABLE t4 (c1 INT NOT NULL); 4476CREATE TABLE t5 (c1 INT NOT NULL); 4477CREATE TABLE t6 (c1 INT 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,t5.c1 FROM t1 CROSS JOIN t5 USING (c1); 4484c1 c1 4485SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1; 4486c1 c1 4487SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 <> 5; 4488c1 c1 4489DROP TABLE t1,t2,t3,t4,t5,t6; 4490CREATE TABLE t1 (c1 INTEGER NOT NULL); 4491CREATE TABLE t2 (c1 INTEGER NOT NULL); 4492CREATE TABLE t3 (c1 INTEGER NOT NULL); 4493CREATE TABLE t4 (c1 INTEGER NOT NULL); 4494CREATE TABLE t5 (c1 INTEGER NOT NULL); 4495CREATE TABLE t6 (c1 INTEGER NOT NULL); 4496INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 4497INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 4498INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 4499INSERT INTO t4 (c1) VALUES(10); 4500INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 4501SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 USING (c1); 4502c1 c1 4503SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1; 4504c1 c1 4505SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 <> 5; 4506c1 c1 4507DROP TABLE t1,t2,t3,t4,t5,t6; 4508CREATE TABLE t1 (c1 BIGINT NOT NULL); 4509CREATE TABLE t2 (c1 BIGINT NOT NULL); 4510CREATE TABLE t3 (c1 BIGINT NOT NULL); 4511CREATE TABLE t4 (c1 BIGINT NOT NULL); 4512CREATE TABLE t5 (c1 BIGINT NOT NULL); 4513CREATE TABLE t6 (c1 BIGINT NOT NULL); 4514INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 4515INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 4516INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 4517INSERT INTO t4 (c1) VALUES(10); 4518INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 4519SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 USING (c1); 4520c1 c1 4521SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1; 4522c1 c1 4523SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 <> 5; 4524c1 c1 4525DROP TABLE t1,t2,t3,t4,t5,t6; 4526CREATE TABLE t1 (c1 TINYINT NOT NULL); 4527CREATE TABLE t2 (c1 TINYINT NOT NULL); 4528CREATE TABLE t3 (c1 TINYINT NOT NULL); 4529CREATE TABLE t4 (c1 TINYINT NOT NULL); 4530CREATE TABLE t5 (c1 TINYINT NOT NULL); 4531CREATE TABLE t6 (c1 TINYINT NOT NULL); 4532INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 4533INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 4534INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 4535INSERT INTO t4 (c1) VALUES(10); 4536INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 4537SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 USING (c1); 4538c1 c1 4539SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1; 4540c1 c1 4541SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 <> 5; 4542c1 c1 4543DROP TABLE t1,t2,t3,t4,t5,t6; 4544CREATE TABLE t1 (c1 SMALLINT NOT NULL); 4545CREATE TABLE t2 (c1 SMALLINT NOT NULL); 4546CREATE TABLE t3 (c1 SMALLINT NOT NULL); 4547CREATE TABLE t4 (c1 SMALLINT NOT NULL); 4548CREATE TABLE t5 (c1 SMALLINT NOT NULL); 4549CREATE TABLE t6 (c1 SMALLINT NOT NULL); 4550INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 4551INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 4552INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 4553INSERT INTO t4 (c1) VALUES(10); 4554INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 4555SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 USING (c1); 4556c1 c1 4557SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1; 4558c1 c1 4559SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 <> 5; 4560c1 c1 4561DROP TABLE t1,t2,t3,t4,t5,t6; 4562CREATE TABLE t1 (c1 MEDIUMINT NOT NULL); 4563CREATE TABLE t2 (c1 MEDIUMINT NOT NULL); 4564CREATE TABLE t3 (c1 MEDIUMINT NOT NULL); 4565CREATE TABLE t4 (c1 MEDIUMINT NOT NULL); 4566CREATE TABLE t5 (c1 MEDIUMINT NOT NULL); 4567CREATE TABLE t6 (c1 MEDIUMINT NOT NULL); 4568INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 4569INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 4570INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 4571INSERT INTO t4 (c1) VALUES(10); 4572INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 4573SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 USING (c1); 4574c1 c1 4575SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1; 4576c1 c1 4577SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 <> 5; 4578c1 c1 4579DROP TABLE t1,t2,t3,t4,t5,t6; 4580CREATE TABLE t1 (c1 INT NOT NULL); 4581CREATE TABLE t2 (c1 INT NOT NULL); 4582CREATE TABLE t3 (c1 INT NOT NULL); 4583CREATE TABLE t4 (c1 INT NOT NULL); 4584CREATE TABLE t5 (c1 INT NOT NULL); 4585CREATE TABLE t6 (c1 INT NOT NULL); 4586INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 4587INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 4588INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 4589INSERT INTO t4 (c1) VALUES(10); 4590INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 4591SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 USING (c1); 4592c1 c1 4593SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1; 4594c1 c1 4595SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 <> 5; 4596c1 c1 4597DROP TABLE t1,t2,t3,t4,t5,t6; 4598CREATE TABLE t1 (c1 INTEGER NOT NULL); 4599CREATE TABLE t2 (c1 INTEGER NOT NULL); 4600CREATE TABLE t3 (c1 INTEGER NOT NULL); 4601CREATE TABLE t4 (c1 INTEGER NOT NULL); 4602CREATE TABLE t5 (c1 INTEGER NOT NULL); 4603CREATE TABLE t6 (c1 INTEGER NOT NULL); 4604INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 4605INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 4606INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 4607INSERT INTO t4 (c1) VALUES(10); 4608INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 4609SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 USING (c1); 4610c1 c1 4611SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1; 4612c1 c1 4613SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 <> 5; 4614c1 c1 4615DROP TABLE t1,t2,t3,t4,t5,t6; 4616CREATE TABLE t1 (c1 BIGINT NOT NULL); 4617CREATE TABLE t2 (c1 BIGINT NOT NULL); 4618CREATE TABLE t3 (c1 BIGINT NOT NULL); 4619CREATE TABLE t4 (c1 BIGINT NOT NULL); 4620CREATE TABLE t5 (c1 BIGINT NOT NULL); 4621CREATE TABLE t6 (c1 BIGINT NOT NULL); 4622INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 4623INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 4624INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 4625INSERT INTO t4 (c1) VALUES(10); 4626INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 4627SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 USING (c1); 4628c1 c1 4629SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1; 4630c1 c1 4631SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 <> 5; 4632c1 c1 4633DROP TABLE t1,t2,t3,t4,t5,t6; 4634CREATE TABLE t1 (c1 TINYINT NOT NULL); 4635CREATE TABLE t2 (c1 TINYINT NOT NULL); 4636CREATE TABLE t3 (c1 TINYINT NOT NULL); 4637CREATE TABLE t4 (c1 TINYINT NOT NULL); 4638CREATE TABLE t5 (c1 TINYINT NOT NULL); 4639CREATE TABLE t6 (c1 TINYINT NOT NULL); 4640INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 4641INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 4642INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 4643INSERT INTO t4 (c1) VALUES(10); 4644INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 4645SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 USING (c1); 4646c1 c1 46470 0 46481 1 46492 2 46503 3 46514 4 46525 5 46536 6 46547 7 46558 8 46569 9 4657SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1; 4658c1 c1 46590 0 46601 1 46612 2 46623 3 46634 4 46645 5 46656 6 46667 7 46678 8 46689 9 4669SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 <=> 5; 4670c1 c1 46715 5 4672DROP TABLE t1,t2,t3,t4,t5,t6; 4673CREATE TABLE t1 (c1 SMALLINT NOT NULL); 4674CREATE TABLE t2 (c1 SMALLINT NOT NULL); 4675CREATE TABLE t3 (c1 SMALLINT NOT NULL); 4676CREATE TABLE t4 (c1 SMALLINT NOT NULL); 4677CREATE TABLE t5 (c1 SMALLINT NOT NULL); 4678CREATE TABLE t6 (c1 SMALLINT NOT NULL); 4679INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 4680INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 4681INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 4682INSERT INTO t4 (c1) VALUES(10); 4683INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 4684SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 USING (c1); 4685c1 c1 46860 0 46871 1 46882 2 46893 3 46904 4 46915 5 46926 6 46937 7 46948 8 46959 9 4696SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1; 4697c1 c1 46980 0 46991 1 47002 2 47013 3 47024 4 47035 5 47046 6 47057 7 47068 8 47079 9 4708SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 <=> 5; 4709c1 c1 47105 5 4711DROP TABLE t1,t2,t3,t4,t5,t6; 4712CREATE TABLE t1 (c1 MEDIUMINT NOT NULL); 4713CREATE TABLE t2 (c1 MEDIUMINT NOT NULL); 4714CREATE TABLE t3 (c1 MEDIUMINT NOT NULL); 4715CREATE TABLE t4 (c1 MEDIUMINT NOT NULL); 4716CREATE TABLE t5 (c1 MEDIUMINT NOT NULL); 4717CREATE TABLE t6 (c1 MEDIUMINT NOT NULL); 4718INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 4719INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 4720INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 4721INSERT INTO t4 (c1) VALUES(10); 4722INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 4723SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 USING (c1); 4724c1 c1 47250 0 47261 1 47272 2 47283 3 47294 4 47305 5 47316 6 47327 7 47338 8 47349 9 4735SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1; 4736c1 c1 47370 0 47381 1 47392 2 47403 3 47414 4 47425 5 47436 6 47447 7 47458 8 47469 9 4747SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 <=> 5; 4748c1 c1 47495 5 4750DROP TABLE t1,t2,t3,t4,t5,t6; 4751CREATE TABLE t1 (c1 INT NOT NULL); 4752CREATE TABLE t2 (c1 INT NOT NULL); 4753CREATE TABLE t3 (c1 INT NOT NULL); 4754CREATE TABLE t4 (c1 INT NOT NULL); 4755CREATE TABLE t5 (c1 INT NOT NULL); 4756CREATE TABLE t6 (c1 INT NOT NULL); 4757INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 4758INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 4759INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 4760INSERT INTO t4 (c1) VALUES(10); 4761INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 4762SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 USING (c1); 4763c1 c1 47640 0 47651 1 47662 2 47673 3 47684 4 47695 5 47706 6 47717 7 47728 8 47739 9 4774SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1; 4775c1 c1 47760 0 47771 1 47782 2 47793 3 47804 4 47815 5 47826 6 47837 7 47848 8 47859 9 4786SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 <=> 5; 4787c1 c1 47885 5 4789DROP TABLE t1,t2,t3,t4,t5,t6; 4790CREATE TABLE t1 (c1 INTEGER NOT NULL); 4791CREATE TABLE t2 (c1 INTEGER NOT NULL); 4792CREATE TABLE t3 (c1 INTEGER NOT NULL); 4793CREATE TABLE t4 (c1 INTEGER NOT NULL); 4794CREATE TABLE t5 (c1 INTEGER NOT NULL); 4795CREATE TABLE t6 (c1 INTEGER NOT NULL); 4796INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 4797INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 4798INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 4799INSERT INTO t4 (c1) VALUES(10); 4800INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 4801SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 USING (c1); 4802c1 c1 48030 0 48041 1 48052 2 48063 3 48074 4 48085 5 48096 6 48107 7 48118 8 48129 9 4813SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1; 4814c1 c1 48150 0 48161 1 48172 2 48183 3 48194 4 48205 5 48216 6 48227 7 48238 8 48249 9 4825SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 <=> 5; 4826c1 c1 48275 5 4828DROP TABLE t1,t2,t3,t4,t5,t6; 4829CREATE TABLE t1 (c1 BIGINT NOT NULL); 4830CREATE TABLE t2 (c1 BIGINT NOT NULL); 4831CREATE TABLE t3 (c1 BIGINT NOT NULL); 4832CREATE TABLE t4 (c1 BIGINT NOT NULL); 4833CREATE TABLE t5 (c1 BIGINT NOT NULL); 4834CREATE TABLE t6 (c1 BIGINT NOT NULL); 4835INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 4836INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 4837INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 4838INSERT INTO t4 (c1) VALUES(10); 4839INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 4840SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 USING (c1); 4841c1 c1 48420 0 48431 1 48442 2 48453 3 48464 4 48475 5 48486 6 48497 7 48508 8 48519 9 4852SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1; 4853c1 c1 48540 0 48551 1 48562 2 48573 3 48584 4 48595 5 48606 6 48617 7 48628 8 48639 9 4864SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 <=> 5; 4865c1 c1 48665 5 4867DROP TABLE t1,t2,t3,t4,t5,t6; 4868CREATE TABLE t1 (c1 TINYINT NOT NULL); 4869CREATE TABLE t2 (c1 TINYINT NOT NULL); 4870CREATE TABLE t3 (c1 TINYINT NOT NULL); 4871CREATE TABLE t4 (c1 TINYINT NOT NULL); 4872CREATE TABLE t5 (c1 TINYINT NOT NULL); 4873CREATE TABLE t6 (c1 TINYINT NOT NULL); 4874INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 4875INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 4876INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 4877INSERT INTO t4 (c1) VALUES(10); 4878INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 4879SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 USING (c1); 4880c1 c1 48811 1 48823 3 48835 5 48847 7 48859 9 4886SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1; 4887c1 c1 48881 1 48893 3 48905 5 48917 7 48929 9 4893SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 <=> 5; 4894c1 c1 48955 5 4896DROP TABLE t1,t2,t3,t4,t5,t6; 4897CREATE TABLE t1 (c1 SMALLINT NOT NULL); 4898CREATE TABLE t2 (c1 SMALLINT NOT NULL); 4899CREATE TABLE t3 (c1 SMALLINT NOT NULL); 4900CREATE TABLE t4 (c1 SMALLINT NOT NULL); 4901CREATE TABLE t5 (c1 SMALLINT NOT NULL); 4902CREATE TABLE t6 (c1 SMALLINT NOT NULL); 4903INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 4904INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 4905INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 4906INSERT INTO t4 (c1) VALUES(10); 4907INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 4908SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 USING (c1); 4909c1 c1 49101 1 49113 3 49125 5 49137 7 49149 9 4915SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1; 4916c1 c1 49171 1 49183 3 49195 5 49207 7 49219 9 4922SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 <=> 5; 4923c1 c1 49245 5 4925DROP TABLE t1,t2,t3,t4,t5,t6; 4926CREATE TABLE t1 (c1 MEDIUMINT NOT NULL); 4927CREATE TABLE t2 (c1 MEDIUMINT NOT NULL); 4928CREATE TABLE t3 (c1 MEDIUMINT NOT NULL); 4929CREATE TABLE t4 (c1 MEDIUMINT NOT NULL); 4930CREATE TABLE t5 (c1 MEDIUMINT NOT NULL); 4931CREATE TABLE t6 (c1 MEDIUMINT NOT NULL); 4932INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 4933INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 4934INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 4935INSERT INTO t4 (c1) VALUES(10); 4936INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 4937SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 USING (c1); 4938c1 c1 49391 1 49403 3 49415 5 49427 7 49439 9 4944SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1; 4945c1 c1 49461 1 49473 3 49485 5 49497 7 49509 9 4951SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 <=> 5; 4952c1 c1 49535 5 4954DROP TABLE t1,t2,t3,t4,t5,t6; 4955CREATE TABLE t1 (c1 INT NOT NULL); 4956CREATE TABLE t2 (c1 INT NOT NULL); 4957CREATE TABLE t3 (c1 INT NOT NULL); 4958CREATE TABLE t4 (c1 INT NOT NULL); 4959CREATE TABLE t5 (c1 INT NOT NULL); 4960CREATE TABLE t6 (c1 INT NOT NULL); 4961INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 4962INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 4963INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 4964INSERT INTO t4 (c1) VALUES(10); 4965INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 4966SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 USING (c1); 4967c1 c1 49681 1 49693 3 49705 5 49717 7 49729 9 4973SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1; 4974c1 c1 49751 1 49763 3 49775 5 49787 7 49799 9 4980SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 <=> 5; 4981c1 c1 49825 5 4983DROP TABLE t1,t2,t3,t4,t5,t6; 4984CREATE TABLE t1 (c1 INTEGER NOT NULL); 4985CREATE TABLE t2 (c1 INTEGER NOT NULL); 4986CREATE TABLE t3 (c1 INTEGER NOT NULL); 4987CREATE TABLE t4 (c1 INTEGER NOT NULL); 4988CREATE TABLE t5 (c1 INTEGER NOT NULL); 4989CREATE TABLE t6 (c1 INTEGER NOT NULL); 4990INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 4991INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 4992INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 4993INSERT INTO t4 (c1) VALUES(10); 4994INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 4995SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 USING (c1); 4996c1 c1 49971 1 49983 3 49995 5 50007 7 50019 9 5002SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1; 5003c1 c1 50041 1 50053 3 50065 5 50077 7 50089 9 5009SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 <=> 5; 5010c1 c1 50115 5 5012DROP TABLE t1,t2,t3,t4,t5,t6; 5013CREATE TABLE t1 (c1 BIGINT NOT NULL); 5014CREATE TABLE t2 (c1 BIGINT NOT NULL); 5015CREATE TABLE t3 (c1 BIGINT NOT NULL); 5016CREATE TABLE t4 (c1 BIGINT NOT NULL); 5017CREATE TABLE t5 (c1 BIGINT NOT NULL); 5018CREATE TABLE t6 (c1 BIGINT NOT NULL); 5019INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 5020INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 5021INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 5022INSERT INTO t4 (c1) VALUES(10); 5023INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 5024SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 USING (c1); 5025c1 c1 50261 1 50273 3 50285 5 50297 7 50309 9 5031SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1; 5032c1 c1 50331 1 50343 3 50355 5 50367 7 50379 9 5038SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 <=> 5; 5039c1 c1 50405 5 5041DROP TABLE t1,t2,t3,t4,t5,t6; 5042CREATE TABLE t1 (c1 TINYINT NOT NULL); 5043CREATE TABLE t2 (c1 TINYINT NOT NULL); 5044CREATE TABLE t3 (c1 TINYINT NOT NULL); 5045CREATE TABLE t4 (c1 TINYINT NOT NULL); 5046CREATE TABLE t5 (c1 TINYINT NOT NULL); 5047CREATE TABLE t6 (c1 TINYINT NOT NULL); 5048INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 5049INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 5050INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 5051INSERT INTO t4 (c1) VALUES(10); 5052INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 5053SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 USING (c1); 5054c1 c1 5055SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1; 5056c1 c1 5057SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 <=> 5; 5058c1 c1 5059DROP TABLE t1,t2,t3,t4,t5,t6; 5060CREATE TABLE t1 (c1 SMALLINT NOT NULL); 5061CREATE TABLE t2 (c1 SMALLINT NOT NULL); 5062CREATE TABLE t3 (c1 SMALLINT NOT NULL); 5063CREATE TABLE t4 (c1 SMALLINT NOT NULL); 5064CREATE TABLE t5 (c1 SMALLINT NOT NULL); 5065CREATE TABLE t6 (c1 SMALLINT NOT NULL); 5066INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 5067INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 5068INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 5069INSERT INTO t4 (c1) VALUES(10); 5070INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 5071SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 USING (c1); 5072c1 c1 5073SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1; 5074c1 c1 5075SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 <=> 5; 5076c1 c1 5077DROP TABLE t1,t2,t3,t4,t5,t6; 5078CREATE TABLE t1 (c1 MEDIUMINT NOT NULL); 5079CREATE TABLE t2 (c1 MEDIUMINT NOT NULL); 5080CREATE TABLE t3 (c1 MEDIUMINT NOT NULL); 5081CREATE TABLE t4 (c1 MEDIUMINT NOT NULL); 5082CREATE TABLE t5 (c1 MEDIUMINT NOT NULL); 5083CREATE TABLE t6 (c1 MEDIUMINT NOT NULL); 5084INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 5085INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 5086INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 5087INSERT INTO t4 (c1) VALUES(10); 5088INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 5089SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 USING (c1); 5090c1 c1 5091SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1; 5092c1 c1 5093SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 <=> 5; 5094c1 c1 5095DROP TABLE t1,t2,t3,t4,t5,t6; 5096CREATE TABLE t1 (c1 INT NOT NULL); 5097CREATE TABLE t2 (c1 INT NOT NULL); 5098CREATE TABLE t3 (c1 INT NOT NULL); 5099CREATE TABLE t4 (c1 INT NOT NULL); 5100CREATE TABLE t5 (c1 INT NOT NULL); 5101CREATE TABLE t6 (c1 INT NOT NULL); 5102INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 5103INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 5104INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 5105INSERT INTO t4 (c1) VALUES(10); 5106INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 5107SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 USING (c1); 5108c1 c1 5109SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1; 5110c1 c1 5111SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 <=> 5; 5112c1 c1 5113DROP TABLE t1,t2,t3,t4,t5,t6; 5114CREATE TABLE t1 (c1 INTEGER NOT NULL); 5115CREATE TABLE t2 (c1 INTEGER NOT NULL); 5116CREATE TABLE t3 (c1 INTEGER NOT NULL); 5117CREATE TABLE t4 (c1 INTEGER NOT NULL); 5118CREATE TABLE t5 (c1 INTEGER NOT NULL); 5119CREATE TABLE t6 (c1 INTEGER NOT NULL); 5120INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 5121INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 5122INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 5123INSERT INTO t4 (c1) VALUES(10); 5124INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 5125SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 USING (c1); 5126c1 c1 5127SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1; 5128c1 c1 5129SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 <=> 5; 5130c1 c1 5131DROP TABLE t1,t2,t3,t4,t5,t6; 5132CREATE TABLE t1 (c1 BIGINT NOT NULL); 5133CREATE TABLE t2 (c1 BIGINT NOT NULL); 5134CREATE TABLE t3 (c1 BIGINT NOT NULL); 5135CREATE TABLE t4 (c1 BIGINT NOT NULL); 5136CREATE TABLE t5 (c1 BIGINT NOT NULL); 5137CREATE TABLE t6 (c1 BIGINT NOT NULL); 5138INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 5139INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 5140INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 5141INSERT INTO t4 (c1) VALUES(10); 5142INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 5143SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 USING (c1); 5144c1 c1 5145SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1; 5146c1 c1 5147SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 <=> 5; 5148c1 c1 5149DROP TABLE t1,t2,t3,t4,t5,t6; 5150CREATE TABLE t1 (c1 TINYINT NOT NULL); 5151CREATE TABLE t2 (c1 TINYINT NOT NULL); 5152CREATE TABLE t3 (c1 TINYINT NOT NULL); 5153CREATE TABLE t4 (c1 TINYINT NOT NULL); 5154CREATE TABLE t5 (c1 TINYINT NOT NULL); 5155CREATE TABLE t6 (c1 TINYINT NOT NULL); 5156INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 5157INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 5158INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 5159INSERT INTO t4 (c1) VALUES(10); 5160INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 5161SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 USING (c1); 5162c1 c1 5163SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1; 5164c1 c1 5165SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 <=> 5; 5166c1 c1 5167DROP TABLE t1,t2,t3,t4,t5,t6; 5168CREATE TABLE t1 (c1 SMALLINT NOT NULL); 5169CREATE TABLE t2 (c1 SMALLINT NOT NULL); 5170CREATE TABLE t3 (c1 SMALLINT NOT NULL); 5171CREATE TABLE t4 (c1 SMALLINT NOT NULL); 5172CREATE TABLE t5 (c1 SMALLINT NOT NULL); 5173CREATE TABLE t6 (c1 SMALLINT NOT NULL); 5174INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 5175INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 5176INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 5177INSERT INTO t4 (c1) VALUES(10); 5178INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 5179SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 USING (c1); 5180c1 c1 5181SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1; 5182c1 c1 5183SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 <=> 5; 5184c1 c1 5185DROP TABLE t1,t2,t3,t4,t5,t6; 5186CREATE TABLE t1 (c1 MEDIUMINT NOT NULL); 5187CREATE TABLE t2 (c1 MEDIUMINT NOT NULL); 5188CREATE TABLE t3 (c1 MEDIUMINT NOT NULL); 5189CREATE TABLE t4 (c1 MEDIUMINT NOT NULL); 5190CREATE TABLE t5 (c1 MEDIUMINT NOT NULL); 5191CREATE TABLE t6 (c1 MEDIUMINT NOT NULL); 5192INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 5193INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 5194INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 5195INSERT INTO t4 (c1) VALUES(10); 5196INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 5197SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 USING (c1); 5198c1 c1 5199SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1; 5200c1 c1 5201SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 <=> 5; 5202c1 c1 5203DROP TABLE t1,t2,t3,t4,t5,t6; 5204CREATE TABLE t1 (c1 INT NOT NULL); 5205CREATE TABLE t2 (c1 INT NOT NULL); 5206CREATE TABLE t3 (c1 INT NOT NULL); 5207CREATE TABLE t4 (c1 INT NOT NULL); 5208CREATE TABLE t5 (c1 INT NOT NULL); 5209CREATE TABLE t6 (c1 INT NOT NULL); 5210INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 5211INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 5212INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 5213INSERT INTO t4 (c1) VALUES(10); 5214INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 5215SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 USING (c1); 5216c1 c1 5217SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1; 5218c1 c1 5219SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 <=> 5; 5220c1 c1 5221DROP TABLE t1,t2,t3,t4,t5,t6; 5222CREATE TABLE t1 (c1 INTEGER NOT NULL); 5223CREATE TABLE t2 (c1 INTEGER NOT NULL); 5224CREATE TABLE t3 (c1 INTEGER NOT NULL); 5225CREATE TABLE t4 (c1 INTEGER NOT NULL); 5226CREATE TABLE t5 (c1 INTEGER NOT NULL); 5227CREATE TABLE t6 (c1 INTEGER NOT NULL); 5228INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 5229INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 5230INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 5231INSERT INTO t4 (c1) VALUES(10); 5232INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 5233SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 USING (c1); 5234c1 c1 5235SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1; 5236c1 c1 5237SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 <=> 5; 5238c1 c1 5239DROP TABLE t1,t2,t3,t4,t5,t6; 5240CREATE TABLE t1 (c1 BIGINT NOT NULL); 5241CREATE TABLE t2 (c1 BIGINT NOT NULL); 5242CREATE TABLE t3 (c1 BIGINT NOT NULL); 5243CREATE TABLE t4 (c1 BIGINT NOT NULL); 5244CREATE TABLE t5 (c1 BIGINT NOT NULL); 5245CREATE TABLE t6 (c1 BIGINT NOT NULL); 5246INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 5247INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 5248INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 5249INSERT INTO t4 (c1) VALUES(10); 5250INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 5251SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 USING (c1); 5252c1 c1 5253SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1; 5254c1 c1 5255SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 <=> 5; 5256c1 c1 5257DROP TABLE t1,t2,t3,t4,t5,t6; 5258CREATE TABLE t1 (c1 TINYINT NOT NULL); 5259CREATE TABLE t2 (c1 TINYINT NOT NULL); 5260CREATE TABLE t3 (c1 TINYINT NOT NULL); 5261CREATE TABLE t4 (c1 TINYINT NOT NULL); 5262CREATE TABLE t5 (c1 TINYINT NOT NULL); 5263CREATE TABLE t6 (c1 TINYINT NOT NULL); 5264INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 5265INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 5266INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 5267INSERT INTO t4 (c1) VALUES(10); 5268INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 5269SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 USING (c1); 5270c1 c1 5271SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1; 5272c1 c1 5273SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 <=> 5; 5274c1 c1 5275DROP TABLE t1,t2,t3,t4,t5,t6; 5276CREATE TABLE t1 (c1 SMALLINT NOT NULL); 5277CREATE TABLE t2 (c1 SMALLINT NOT NULL); 5278CREATE TABLE t3 (c1 SMALLINT NOT NULL); 5279CREATE TABLE t4 (c1 SMALLINT NOT NULL); 5280CREATE TABLE t5 (c1 SMALLINT NOT NULL); 5281CREATE TABLE t6 (c1 SMALLINT NOT NULL); 5282INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 5283INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 5284INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 5285INSERT INTO t4 (c1) VALUES(10); 5286INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 5287SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 USING (c1); 5288c1 c1 5289SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1; 5290c1 c1 5291SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 <=> 5; 5292c1 c1 5293DROP TABLE t1,t2,t3,t4,t5,t6; 5294CREATE TABLE t1 (c1 MEDIUMINT NOT NULL); 5295CREATE TABLE t2 (c1 MEDIUMINT NOT NULL); 5296CREATE TABLE t3 (c1 MEDIUMINT NOT NULL); 5297CREATE TABLE t4 (c1 MEDIUMINT NOT NULL); 5298CREATE TABLE t5 (c1 MEDIUMINT NOT NULL); 5299CREATE TABLE t6 (c1 MEDIUMINT NOT NULL); 5300INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 5301INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 5302INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 5303INSERT INTO t4 (c1) VALUES(10); 5304INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 5305SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 USING (c1); 5306c1 c1 5307SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1; 5308c1 c1 5309SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 <=> 5; 5310c1 c1 5311DROP TABLE t1,t2,t3,t4,t5,t6; 5312CREATE TABLE t1 (c1 INT NOT NULL); 5313CREATE TABLE t2 (c1 INT NOT NULL); 5314CREATE TABLE t3 (c1 INT NOT NULL); 5315CREATE TABLE t4 (c1 INT NOT NULL); 5316CREATE TABLE t5 (c1 INT NOT NULL); 5317CREATE TABLE t6 (c1 INT 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,t6.c1 FROM t1 CROSS JOIN t6 USING (c1); 5324c1 c1 5325SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1; 5326c1 c1 5327SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 <=> 5; 5328c1 c1 5329DROP TABLE t1,t2,t3,t4,t5,t6; 5330CREATE TABLE t1 (c1 INTEGER NOT NULL); 5331CREATE TABLE t2 (c1 INTEGER NOT NULL); 5332CREATE TABLE t3 (c1 INTEGER NOT NULL); 5333CREATE TABLE t4 (c1 INTEGER NOT NULL); 5334CREATE TABLE t5 (c1 INTEGER NOT NULL); 5335CREATE TABLE t6 (c1 INTEGER NOT NULL); 5336INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 5337INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 5338INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 5339INSERT INTO t4 (c1) VALUES(10); 5340INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 5341SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 USING (c1); 5342c1 c1 5343SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1; 5344c1 c1 5345SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 <=> 5; 5346c1 c1 5347DROP TABLE t1,t2,t3,t4,t5,t6; 5348CREATE TABLE t1 (c1 BIGINT NOT NULL); 5349CREATE TABLE t2 (c1 BIGINT NOT NULL); 5350CREATE TABLE t3 (c1 BIGINT NOT NULL); 5351CREATE TABLE t4 (c1 BIGINT NOT NULL); 5352CREATE TABLE t5 (c1 BIGINT NOT NULL); 5353CREATE TABLE t6 (c1 BIGINT NOT NULL); 5354INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 5355INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 5356INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 5357INSERT INTO t4 (c1) VALUES(10); 5358INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 5359SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 USING (c1); 5360c1 c1 5361SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1; 5362c1 c1 5363SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 <=> 5; 5364c1 c1 5365DROP TABLE t1,t2,t3,t4,t5,t6; 5366