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 STRAIGHT_JOIN t2 ON t1.c1 = t2.c1; 14c1 c1 150 0 161 1 172 2 183 3 194 4 205 5 216 6 227 7 238 8 249 9 25SELECT t1.c1,t2.c1 FROM t1 STRAIGHT_JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 < 5; 26c1 c1 270 0 281 1 292 2 303 3 314 4 32DROP TABLE t1,t2,t3,t4,t5,t6; 33CREATE TABLE t1 (c1 SMALLINT NOT NULL); 34CREATE TABLE t2 (c1 SMALLINT NOT NULL); 35CREATE TABLE t3 (c1 SMALLINT NOT NULL); 36CREATE TABLE t4 (c1 SMALLINT NOT NULL); 37CREATE TABLE t5 (c1 SMALLINT NOT NULL); 38CREATE TABLE t6 (c1 SMALLINT NOT NULL); 39INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 40INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 41INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 42INSERT INTO t4 (c1) VALUES(10); 43INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 44SELECT t1.c1,t2.c1 FROM t1 STRAIGHT_JOIN t2 ON t1.c1 = t2.c1; 45c1 c1 460 0 471 1 482 2 493 3 504 4 515 5 526 6 537 7 548 8 559 9 56SELECT t1.c1,t2.c1 FROM t1 STRAIGHT_JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 < 5; 57c1 c1 580 0 591 1 602 2 613 3 624 4 63DROP TABLE t1,t2,t3,t4,t5,t6; 64CREATE TABLE t1 (c1 MEDIUMINT NOT NULL); 65CREATE TABLE t2 (c1 MEDIUMINT NOT NULL); 66CREATE TABLE t3 (c1 MEDIUMINT NOT NULL); 67CREATE TABLE t4 (c1 MEDIUMINT NOT NULL); 68CREATE TABLE t5 (c1 MEDIUMINT NOT NULL); 69CREATE TABLE t6 (c1 MEDIUMINT NOT NULL); 70INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 71INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 72INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 73INSERT INTO t4 (c1) VALUES(10); 74INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 75SELECT t1.c1,t2.c1 FROM t1 STRAIGHT_JOIN t2 ON t1.c1 = t2.c1; 76c1 c1 770 0 781 1 792 2 803 3 814 4 825 5 836 6 847 7 858 8 869 9 87SELECT t1.c1,t2.c1 FROM t1 STRAIGHT_JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 < 5; 88c1 c1 890 0 901 1 912 2 923 3 934 4 94DROP TABLE t1,t2,t3,t4,t5,t6; 95CREATE TABLE t1 (c1 INT NOT NULL); 96CREATE TABLE t2 (c1 INT NOT NULL); 97CREATE TABLE t3 (c1 INT NOT NULL); 98CREATE TABLE t4 (c1 INT NOT NULL); 99CREATE TABLE t5 (c1 INT NOT NULL); 100CREATE TABLE t6 (c1 INT NOT NULL); 101INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 102INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 103INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 104INSERT INTO t4 (c1) VALUES(10); 105INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 106SELECT t1.c1,t2.c1 FROM t1 STRAIGHT_JOIN t2 ON t1.c1 = t2.c1; 107c1 c1 1080 0 1091 1 1102 2 1113 3 1124 4 1135 5 1146 6 1157 7 1168 8 1179 9 118SELECT t1.c1,t2.c1 FROM t1 STRAIGHT_JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 < 5; 119c1 c1 1200 0 1211 1 1222 2 1233 3 1244 4 125DROP TABLE t1,t2,t3,t4,t5,t6; 126CREATE TABLE t1 (c1 INTEGER NOT NULL); 127CREATE TABLE t2 (c1 INTEGER NOT NULL); 128CREATE TABLE t3 (c1 INTEGER NOT NULL); 129CREATE TABLE t4 (c1 INTEGER NOT NULL); 130CREATE TABLE t5 (c1 INTEGER NOT NULL); 131CREATE TABLE t6 (c1 INTEGER NOT NULL); 132INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 133INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 134INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 135INSERT INTO t4 (c1) VALUES(10); 136INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 137SELECT t1.c1,t2.c1 FROM t1 STRAIGHT_JOIN t2 ON t1.c1 = t2.c1; 138c1 c1 1390 0 1401 1 1412 2 1423 3 1434 4 1445 5 1456 6 1467 7 1478 8 1489 9 149SELECT t1.c1,t2.c1 FROM t1 STRAIGHT_JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 < 5; 150c1 c1 1510 0 1521 1 1532 2 1543 3 1554 4 156DROP TABLE t1,t2,t3,t4,t5,t6; 157CREATE TABLE t1 (c1 BIGINT NOT NULL); 158CREATE TABLE t2 (c1 BIGINT NOT NULL); 159CREATE TABLE t3 (c1 BIGINT NOT NULL); 160CREATE TABLE t4 (c1 BIGINT NOT NULL); 161CREATE TABLE t5 (c1 BIGINT NOT NULL); 162CREATE TABLE t6 (c1 BIGINT NOT NULL); 163INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 164INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 165INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 166INSERT INTO t4 (c1) VALUES(10); 167INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 168SELECT t1.c1,t2.c1 FROM t1 STRAIGHT_JOIN t2 ON t1.c1 = t2.c1; 169c1 c1 1700 0 1711 1 1722 2 1733 3 1744 4 1755 5 1766 6 1777 7 1788 8 1799 9 180SELECT t1.c1,t2.c1 FROM t1 STRAIGHT_JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 < 5; 181c1 c1 1820 0 1831 1 1842 2 1853 3 1864 4 187DROP TABLE t1,t2,t3,t4,t5,t6; 188CREATE TABLE t1 (c1 TINYINT NOT NULL); 189CREATE TABLE t2 (c1 TINYINT NOT NULL); 190CREATE TABLE t3 (c1 TINYINT NOT NULL); 191CREATE TABLE t4 (c1 TINYINT NOT NULL); 192CREATE TABLE t5 (c1 TINYINT NOT NULL); 193CREATE TABLE t6 (c1 TINYINT NOT NULL); 194INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 195INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 196INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 197INSERT INTO t4 (c1) VALUES(10); 198INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 199SELECT t1.c1,t3.c1 FROM t1 STRAIGHT_JOIN t3 ON t1.c1 = t3.c1; 200c1 c1 2011 1 2023 3 2035 5 2047 7 2059 9 206SELECT t1.c1,t3.c1 FROM t1 STRAIGHT_JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 < 5; 207c1 c1 2081 1 2093 3 210DROP TABLE t1,t2,t3,t4,t5,t6; 211CREATE TABLE t1 (c1 SMALLINT NOT NULL); 212CREATE TABLE t2 (c1 SMALLINT NOT NULL); 213CREATE TABLE t3 (c1 SMALLINT NOT NULL); 214CREATE TABLE t4 (c1 SMALLINT NOT NULL); 215CREATE TABLE t5 (c1 SMALLINT NOT NULL); 216CREATE TABLE t6 (c1 SMALLINT NOT NULL); 217INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 218INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 219INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 220INSERT INTO t4 (c1) VALUES(10); 221INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 222SELECT t1.c1,t3.c1 FROM t1 STRAIGHT_JOIN t3 ON t1.c1 = t3.c1; 223c1 c1 2241 1 2253 3 2265 5 2277 7 2289 9 229SELECT t1.c1,t3.c1 FROM t1 STRAIGHT_JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 < 5; 230c1 c1 2311 1 2323 3 233DROP TABLE t1,t2,t3,t4,t5,t6; 234CREATE TABLE t1 (c1 MEDIUMINT NOT NULL); 235CREATE TABLE t2 (c1 MEDIUMINT NOT NULL); 236CREATE TABLE t3 (c1 MEDIUMINT NOT NULL); 237CREATE TABLE t4 (c1 MEDIUMINT NOT NULL); 238CREATE TABLE t5 (c1 MEDIUMINT NOT NULL); 239CREATE TABLE t6 (c1 MEDIUMINT NOT NULL); 240INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 241INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 242INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 243INSERT INTO t4 (c1) VALUES(10); 244INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 245SELECT t1.c1,t3.c1 FROM t1 STRAIGHT_JOIN t3 ON t1.c1 = t3.c1; 246c1 c1 2471 1 2483 3 2495 5 2507 7 2519 9 252SELECT t1.c1,t3.c1 FROM t1 STRAIGHT_JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 < 5; 253c1 c1 2541 1 2553 3 256DROP TABLE t1,t2,t3,t4,t5,t6; 257CREATE TABLE t1 (c1 INT NOT NULL); 258CREATE TABLE t2 (c1 INT NOT NULL); 259CREATE TABLE t3 (c1 INT NOT NULL); 260CREATE TABLE t4 (c1 INT NOT NULL); 261CREATE TABLE t5 (c1 INT NOT NULL); 262CREATE TABLE t6 (c1 INT NOT NULL); 263INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 264INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 265INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 266INSERT INTO t4 (c1) VALUES(10); 267INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 268SELECT t1.c1,t3.c1 FROM t1 STRAIGHT_JOIN t3 ON t1.c1 = t3.c1; 269c1 c1 2701 1 2713 3 2725 5 2737 7 2749 9 275SELECT t1.c1,t3.c1 FROM t1 STRAIGHT_JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 < 5; 276c1 c1 2771 1 2783 3 279DROP TABLE t1,t2,t3,t4,t5,t6; 280CREATE TABLE t1 (c1 INTEGER NOT NULL); 281CREATE TABLE t2 (c1 INTEGER NOT NULL); 282CREATE TABLE t3 (c1 INTEGER NOT NULL); 283CREATE TABLE t4 (c1 INTEGER NOT NULL); 284CREATE TABLE t5 (c1 INTEGER NOT NULL); 285CREATE TABLE t6 (c1 INTEGER NOT NULL); 286INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 287INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 288INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 289INSERT INTO t4 (c1) VALUES(10); 290INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 291SELECT t1.c1,t3.c1 FROM t1 STRAIGHT_JOIN t3 ON t1.c1 = t3.c1; 292c1 c1 2931 1 2943 3 2955 5 2967 7 2979 9 298SELECT t1.c1,t3.c1 FROM t1 STRAIGHT_JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 < 5; 299c1 c1 3001 1 3013 3 302DROP TABLE t1,t2,t3,t4,t5,t6; 303CREATE TABLE t1 (c1 BIGINT NOT NULL); 304CREATE TABLE t2 (c1 BIGINT NOT NULL); 305CREATE TABLE t3 (c1 BIGINT NOT NULL); 306CREATE TABLE t4 (c1 BIGINT NOT NULL); 307CREATE TABLE t5 (c1 BIGINT NOT NULL); 308CREATE TABLE t6 (c1 BIGINT NOT NULL); 309INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 310INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 311INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 312INSERT INTO t4 (c1) VALUES(10); 313INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 314SELECT t1.c1,t3.c1 FROM t1 STRAIGHT_JOIN t3 ON t1.c1 = t3.c1; 315c1 c1 3161 1 3173 3 3185 5 3197 7 3209 9 321SELECT t1.c1,t3.c1 FROM t1 STRAIGHT_JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 < 5; 322c1 c1 3231 1 3243 3 325DROP TABLE t1,t2,t3,t4,t5,t6; 326CREATE TABLE t1 (c1 TINYINT NOT NULL); 327CREATE TABLE t2 (c1 TINYINT NOT NULL); 328CREATE TABLE t3 (c1 TINYINT NOT NULL); 329CREATE TABLE t4 (c1 TINYINT NOT NULL); 330CREATE TABLE t5 (c1 TINYINT NOT NULL); 331CREATE TABLE t6 (c1 TINYINT NOT NULL); 332INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 333INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 334INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 335INSERT INTO t4 (c1) VALUES(10); 336INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 337SELECT t1.c1,t4.c1 FROM t1 STRAIGHT_JOIN t4 ON t1.c1 = t4.c1; 338c1 c1 339SELECT t1.c1,t4.c1 FROM t1 STRAIGHT_JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 < 5; 340c1 c1 341DROP TABLE t1,t2,t3,t4,t5,t6; 342CREATE TABLE t1 (c1 SMALLINT NOT NULL); 343CREATE TABLE t2 (c1 SMALLINT NOT NULL); 344CREATE TABLE t3 (c1 SMALLINT NOT NULL); 345CREATE TABLE t4 (c1 SMALLINT NOT NULL); 346CREATE TABLE t5 (c1 SMALLINT NOT NULL); 347CREATE TABLE t6 (c1 SMALLINT NOT NULL); 348INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 349INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 350INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 351INSERT INTO t4 (c1) VALUES(10); 352INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 353SELECT t1.c1,t4.c1 FROM t1 STRAIGHT_JOIN t4 ON t1.c1 = t4.c1; 354c1 c1 355SELECT t1.c1,t4.c1 FROM t1 STRAIGHT_JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 < 5; 356c1 c1 357DROP TABLE t1,t2,t3,t4,t5,t6; 358CREATE TABLE t1 (c1 MEDIUMINT NOT NULL); 359CREATE TABLE t2 (c1 MEDIUMINT NOT NULL); 360CREATE TABLE t3 (c1 MEDIUMINT NOT NULL); 361CREATE TABLE t4 (c1 MEDIUMINT NOT NULL); 362CREATE TABLE t5 (c1 MEDIUMINT NOT NULL); 363CREATE TABLE t6 (c1 MEDIUMINT NOT NULL); 364INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 365INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 366INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 367INSERT INTO t4 (c1) VALUES(10); 368INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 369SELECT t1.c1,t4.c1 FROM t1 STRAIGHT_JOIN t4 ON t1.c1 = t4.c1; 370c1 c1 371SELECT t1.c1,t4.c1 FROM t1 STRAIGHT_JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 < 5; 372c1 c1 373DROP TABLE t1,t2,t3,t4,t5,t6; 374CREATE TABLE t1 (c1 INT NOT NULL); 375CREATE TABLE t2 (c1 INT NOT NULL); 376CREATE TABLE t3 (c1 INT NOT NULL); 377CREATE TABLE t4 (c1 INT NOT NULL); 378CREATE TABLE t5 (c1 INT NOT NULL); 379CREATE TABLE t6 (c1 INT NOT NULL); 380INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 381INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 382INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 383INSERT INTO t4 (c1) VALUES(10); 384INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 385SELECT t1.c1,t4.c1 FROM t1 STRAIGHT_JOIN t4 ON t1.c1 = t4.c1; 386c1 c1 387SELECT t1.c1,t4.c1 FROM t1 STRAIGHT_JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 < 5; 388c1 c1 389DROP TABLE t1,t2,t3,t4,t5,t6; 390CREATE TABLE t1 (c1 INTEGER NOT NULL); 391CREATE TABLE t2 (c1 INTEGER NOT NULL); 392CREATE TABLE t3 (c1 INTEGER NOT NULL); 393CREATE TABLE t4 (c1 INTEGER NOT NULL); 394CREATE TABLE t5 (c1 INTEGER NOT NULL); 395CREATE TABLE t6 (c1 INTEGER NOT NULL); 396INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 397INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 398INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 399INSERT INTO t4 (c1) VALUES(10); 400INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 401SELECT t1.c1,t4.c1 FROM t1 STRAIGHT_JOIN t4 ON t1.c1 = t4.c1; 402c1 c1 403SELECT t1.c1,t4.c1 FROM t1 STRAIGHT_JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 < 5; 404c1 c1 405DROP TABLE t1,t2,t3,t4,t5,t6; 406CREATE TABLE t1 (c1 BIGINT NOT NULL); 407CREATE TABLE t2 (c1 BIGINT NOT NULL); 408CREATE TABLE t3 (c1 BIGINT NOT NULL); 409CREATE TABLE t4 (c1 BIGINT NOT NULL); 410CREATE TABLE t5 (c1 BIGINT NOT NULL); 411CREATE TABLE t6 (c1 BIGINT NOT NULL); 412INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 413INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 414INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 415INSERT INTO t4 (c1) VALUES(10); 416INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 417SELECT t1.c1,t4.c1 FROM t1 STRAIGHT_JOIN t4 ON t1.c1 = t4.c1; 418c1 c1 419SELECT t1.c1,t4.c1 FROM t1 STRAIGHT_JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 < 5; 420c1 c1 421DROP TABLE t1,t2,t3,t4,t5,t6; 422CREATE TABLE t1 (c1 TINYINT NOT NULL); 423CREATE TABLE t2 (c1 TINYINT NOT NULL); 424CREATE TABLE t3 (c1 TINYINT NOT NULL); 425CREATE TABLE t4 (c1 TINYINT NOT NULL); 426CREATE TABLE t5 (c1 TINYINT NOT NULL); 427CREATE TABLE t6 (c1 TINYINT NOT NULL); 428INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 429INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 430INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 431INSERT INTO t4 (c1) VALUES(10); 432INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 433SELECT t1.c1,t5.c1 FROM t1 STRAIGHT_JOIN t5 ON t1.c1 = t5.c1; 434c1 c1 435SELECT t1.c1,t5.c1 FROM t1 STRAIGHT_JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 < 5; 436c1 c1 437DROP TABLE t1,t2,t3,t4,t5,t6; 438CREATE TABLE t1 (c1 SMALLINT NOT NULL); 439CREATE TABLE t2 (c1 SMALLINT NOT NULL); 440CREATE TABLE t3 (c1 SMALLINT NOT NULL); 441CREATE TABLE t4 (c1 SMALLINT NOT NULL); 442CREATE TABLE t5 (c1 SMALLINT NOT NULL); 443CREATE TABLE t6 (c1 SMALLINT NOT NULL); 444INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 445INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 446INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 447INSERT INTO t4 (c1) VALUES(10); 448INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 449SELECT t1.c1,t5.c1 FROM t1 STRAIGHT_JOIN t5 ON t1.c1 = t5.c1; 450c1 c1 451SELECT t1.c1,t5.c1 FROM t1 STRAIGHT_JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 < 5; 452c1 c1 453DROP TABLE t1,t2,t3,t4,t5,t6; 454CREATE TABLE t1 (c1 MEDIUMINT NOT NULL); 455CREATE TABLE t2 (c1 MEDIUMINT NOT NULL); 456CREATE TABLE t3 (c1 MEDIUMINT NOT NULL); 457CREATE TABLE t4 (c1 MEDIUMINT NOT NULL); 458CREATE TABLE t5 (c1 MEDIUMINT NOT NULL); 459CREATE TABLE t6 (c1 MEDIUMINT NOT NULL); 460INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 461INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 462INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 463INSERT INTO t4 (c1) VALUES(10); 464INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 465SELECT t1.c1,t5.c1 FROM t1 STRAIGHT_JOIN t5 ON t1.c1 = t5.c1; 466c1 c1 467SELECT t1.c1,t5.c1 FROM t1 STRAIGHT_JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 < 5; 468c1 c1 469DROP TABLE t1,t2,t3,t4,t5,t6; 470CREATE TABLE t1 (c1 INT NOT NULL); 471CREATE TABLE t2 (c1 INT NOT NULL); 472CREATE TABLE t3 (c1 INT NOT NULL); 473CREATE TABLE t4 (c1 INT NOT NULL); 474CREATE TABLE t5 (c1 INT NOT NULL); 475CREATE TABLE t6 (c1 INT NOT NULL); 476INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 477INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 478INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 479INSERT INTO t4 (c1) VALUES(10); 480INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 481SELECT t1.c1,t5.c1 FROM t1 STRAIGHT_JOIN t5 ON t1.c1 = t5.c1; 482c1 c1 483SELECT t1.c1,t5.c1 FROM t1 STRAIGHT_JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 < 5; 484c1 c1 485DROP TABLE t1,t2,t3,t4,t5,t6; 486CREATE TABLE t1 (c1 INTEGER NOT NULL); 487CREATE TABLE t2 (c1 INTEGER NOT NULL); 488CREATE TABLE t3 (c1 INTEGER NOT NULL); 489CREATE TABLE t4 (c1 INTEGER NOT NULL); 490CREATE TABLE t5 (c1 INTEGER NOT NULL); 491CREATE TABLE t6 (c1 INTEGER NOT NULL); 492INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 493INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 494INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 495INSERT INTO t4 (c1) VALUES(10); 496INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 497SELECT t1.c1,t5.c1 FROM t1 STRAIGHT_JOIN t5 ON t1.c1 = t5.c1; 498c1 c1 499SELECT t1.c1,t5.c1 FROM t1 STRAIGHT_JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 < 5; 500c1 c1 501DROP TABLE t1,t2,t3,t4,t5,t6; 502CREATE TABLE t1 (c1 BIGINT NOT NULL); 503CREATE TABLE t2 (c1 BIGINT NOT NULL); 504CREATE TABLE t3 (c1 BIGINT NOT NULL); 505CREATE TABLE t4 (c1 BIGINT NOT NULL); 506CREATE TABLE t5 (c1 BIGINT NOT NULL); 507CREATE TABLE t6 (c1 BIGINT NOT NULL); 508INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 509INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 510INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 511INSERT INTO t4 (c1) VALUES(10); 512INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 513SELECT t1.c1,t5.c1 FROM t1 STRAIGHT_JOIN t5 ON t1.c1 = t5.c1; 514c1 c1 515SELECT t1.c1,t5.c1 FROM t1 STRAIGHT_JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 < 5; 516c1 c1 517DROP TABLE t1,t2,t3,t4,t5,t6; 518CREATE TABLE t1 (c1 TINYINT NOT NULL); 519CREATE TABLE t2 (c1 TINYINT NOT NULL); 520CREATE TABLE t3 (c1 TINYINT NOT NULL); 521CREATE TABLE t4 (c1 TINYINT NOT NULL); 522CREATE TABLE t5 (c1 TINYINT NOT NULL); 523CREATE TABLE t6 (c1 TINYINT NOT NULL); 524INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 525INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 526INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 527INSERT INTO t4 (c1) VALUES(10); 528INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 529SELECT t1.c1,t6.c1 FROM t1 STRAIGHT_JOIN t6 ON t1.c1 = t6.c1; 530c1 c1 531SELECT t1.c1,t6.c1 FROM t1 STRAIGHT_JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 < 5; 532c1 c1 533DROP TABLE t1,t2,t3,t4,t5,t6; 534CREATE TABLE t1 (c1 SMALLINT NOT NULL); 535CREATE TABLE t2 (c1 SMALLINT NOT NULL); 536CREATE TABLE t3 (c1 SMALLINT NOT NULL); 537CREATE TABLE t4 (c1 SMALLINT NOT NULL); 538CREATE TABLE t5 (c1 SMALLINT NOT NULL); 539CREATE TABLE t6 (c1 SMALLINT NOT NULL); 540INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 541INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 542INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 543INSERT INTO t4 (c1) VALUES(10); 544INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 545SELECT t1.c1,t6.c1 FROM t1 STRAIGHT_JOIN t6 ON t1.c1 = t6.c1; 546c1 c1 547SELECT t1.c1,t6.c1 FROM t1 STRAIGHT_JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 < 5; 548c1 c1 549DROP TABLE t1,t2,t3,t4,t5,t6; 550CREATE TABLE t1 (c1 MEDIUMINT NOT NULL); 551CREATE TABLE t2 (c1 MEDIUMINT NOT NULL); 552CREATE TABLE t3 (c1 MEDIUMINT NOT NULL); 553CREATE TABLE t4 (c1 MEDIUMINT NOT NULL); 554CREATE TABLE t5 (c1 MEDIUMINT NOT NULL); 555CREATE TABLE t6 (c1 MEDIUMINT NOT NULL); 556INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 557INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 558INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 559INSERT INTO t4 (c1) VALUES(10); 560INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 561SELECT t1.c1,t6.c1 FROM t1 STRAIGHT_JOIN t6 ON t1.c1 = t6.c1; 562c1 c1 563SELECT t1.c1,t6.c1 FROM t1 STRAIGHT_JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 < 5; 564c1 c1 565DROP TABLE t1,t2,t3,t4,t5,t6; 566CREATE TABLE t1 (c1 INT NOT NULL); 567CREATE TABLE t2 (c1 INT NOT NULL); 568CREATE TABLE t3 (c1 INT NOT NULL); 569CREATE TABLE t4 (c1 INT NOT NULL); 570CREATE TABLE t5 (c1 INT NOT NULL); 571CREATE TABLE t6 (c1 INT 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,t6.c1 FROM t1 STRAIGHT_JOIN t6 ON t1.c1 = t6.c1; 578c1 c1 579SELECT t1.c1,t6.c1 FROM t1 STRAIGHT_JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 < 5; 580c1 c1 581DROP TABLE t1,t2,t3,t4,t5,t6; 582CREATE TABLE t1 (c1 INTEGER NOT NULL); 583CREATE TABLE t2 (c1 INTEGER NOT NULL); 584CREATE TABLE t3 (c1 INTEGER NOT NULL); 585CREATE TABLE t4 (c1 INTEGER NOT NULL); 586CREATE TABLE t5 (c1 INTEGER NOT NULL); 587CREATE TABLE t6 (c1 INTEGER NOT NULL); 588INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 589INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 590INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 591INSERT INTO t4 (c1) VALUES(10); 592INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 593SELECT t1.c1,t6.c1 FROM t1 STRAIGHT_JOIN t6 ON t1.c1 = t6.c1; 594c1 c1 595SELECT t1.c1,t6.c1 FROM t1 STRAIGHT_JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 < 5; 596c1 c1 597DROP TABLE t1,t2,t3,t4,t5,t6; 598CREATE TABLE t1 (c1 BIGINT NOT NULL); 599CREATE TABLE t2 (c1 BIGINT NOT NULL); 600CREATE TABLE t3 (c1 BIGINT NOT NULL); 601CREATE TABLE t4 (c1 BIGINT NOT NULL); 602CREATE TABLE t5 (c1 BIGINT NOT NULL); 603CREATE TABLE t6 (c1 BIGINT NOT NULL); 604INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 605INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 606INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 607INSERT INTO t4 (c1) VALUES(10); 608INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 609SELECT t1.c1,t6.c1 FROM t1 STRAIGHT_JOIN t6 ON t1.c1 = t6.c1; 610c1 c1 611SELECT t1.c1,t6.c1 FROM t1 STRAIGHT_JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 < 5; 612c1 c1 613DROP TABLE t1,t2,t3,t4,t5,t6; 614CREATE TABLE t1 (c1 TINYINT NOT NULL); 615CREATE TABLE t2 (c1 TINYINT NOT NULL); 616CREATE TABLE t3 (c1 TINYINT NOT NULL); 617CREATE TABLE t4 (c1 TINYINT NOT NULL); 618CREATE TABLE t5 (c1 TINYINT NOT NULL); 619CREATE TABLE t6 (c1 TINYINT NOT NULL); 620INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 621INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 622INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 623INSERT INTO t4 (c1) VALUES(10); 624INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 625SELECT t1.c1,t2.c1 FROM t1 STRAIGHT_JOIN t2 ON t1.c1 = t2.c1; 626c1 c1 6270 0 6281 1 6292 2 6303 3 6314 4 6325 5 6336 6 6347 7 6358 8 6369 9 637SELECT t1.c1,t2.c1 FROM t1 STRAIGHT_JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 <= 5; 638c1 c1 6390 0 6401 1 6412 2 6423 3 6434 4 6445 5 645DROP TABLE t1,t2,t3,t4,t5,t6; 646CREATE TABLE t1 (c1 SMALLINT NOT NULL); 647CREATE TABLE t2 (c1 SMALLINT NOT NULL); 648CREATE TABLE t3 (c1 SMALLINT NOT NULL); 649CREATE TABLE t4 (c1 SMALLINT NOT NULL); 650CREATE TABLE t5 (c1 SMALLINT NOT NULL); 651CREATE TABLE t6 (c1 SMALLINT NOT NULL); 652INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 653INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 654INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 655INSERT INTO t4 (c1) VALUES(10); 656INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 657SELECT t1.c1,t2.c1 FROM t1 STRAIGHT_JOIN t2 ON t1.c1 = t2.c1; 658c1 c1 6590 0 6601 1 6612 2 6623 3 6634 4 6645 5 6656 6 6667 7 6678 8 6689 9 669SELECT t1.c1,t2.c1 FROM t1 STRAIGHT_JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 <= 5; 670c1 c1 6710 0 6721 1 6732 2 6743 3 6754 4 6765 5 677DROP TABLE t1,t2,t3,t4,t5,t6; 678CREATE TABLE t1 (c1 MEDIUMINT NOT NULL); 679CREATE TABLE t2 (c1 MEDIUMINT NOT NULL); 680CREATE TABLE t3 (c1 MEDIUMINT NOT NULL); 681CREATE TABLE t4 (c1 MEDIUMINT NOT NULL); 682CREATE TABLE t5 (c1 MEDIUMINT NOT NULL); 683CREATE TABLE t6 (c1 MEDIUMINT NOT NULL); 684INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 685INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 686INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 687INSERT INTO t4 (c1) VALUES(10); 688INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 689SELECT t1.c1,t2.c1 FROM t1 STRAIGHT_JOIN t2 ON t1.c1 = t2.c1; 690c1 c1 6910 0 6921 1 6932 2 6943 3 6954 4 6965 5 6976 6 6987 7 6998 8 7009 9 701SELECT t1.c1,t2.c1 FROM t1 STRAIGHT_JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 <= 5; 702c1 c1 7030 0 7041 1 7052 2 7063 3 7074 4 7085 5 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,t2.c1 FROM t1 STRAIGHT_JOIN t2 ON t1.c1 = t2.c1; 722c1 c1 7230 0 7241 1 7252 2 7263 3 7274 4 7285 5 7296 6 7307 7 7318 8 7329 9 733SELECT t1.c1,t2.c1 FROM t1 STRAIGHT_JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 <= 5; 734c1 c1 7350 0 7361 1 7372 2 7383 3 7394 4 7405 5 741DROP TABLE t1,t2,t3,t4,t5,t6; 742CREATE TABLE t1 (c1 INTEGER NOT NULL); 743CREATE TABLE t2 (c1 INTEGER NOT NULL); 744CREATE TABLE t3 (c1 INTEGER NOT NULL); 745CREATE TABLE t4 (c1 INTEGER NOT NULL); 746CREATE TABLE t5 (c1 INTEGER NOT NULL); 747CREATE TABLE t6 (c1 INTEGER NOT NULL); 748INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 749INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 750INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 751INSERT INTO t4 (c1) VALUES(10); 752INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 753SELECT t1.c1,t2.c1 FROM t1 STRAIGHT_JOIN t2 ON t1.c1 = t2.c1; 754c1 c1 7550 0 7561 1 7572 2 7583 3 7594 4 7605 5 7616 6 7627 7 7638 8 7649 9 765SELECT t1.c1,t2.c1 FROM t1 STRAIGHT_JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 <= 5; 766c1 c1 7670 0 7681 1 7692 2 7703 3 7714 4 7725 5 773DROP TABLE t1,t2,t3,t4,t5,t6; 774CREATE TABLE t1 (c1 BIGINT NOT NULL); 775CREATE TABLE t2 (c1 BIGINT NOT NULL); 776CREATE TABLE t3 (c1 BIGINT NOT NULL); 777CREATE TABLE t4 (c1 BIGINT NOT NULL); 778CREATE TABLE t5 (c1 BIGINT NOT NULL); 779CREATE TABLE t6 (c1 BIGINT NOT NULL); 780INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 781INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 782INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 783INSERT INTO t4 (c1) VALUES(10); 784INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 785SELECT t1.c1,t2.c1 FROM t1 STRAIGHT_JOIN t2 ON t1.c1 = t2.c1; 786c1 c1 7870 0 7881 1 7892 2 7903 3 7914 4 7925 5 7936 6 7947 7 7958 8 7969 9 797SELECT t1.c1,t2.c1 FROM t1 STRAIGHT_JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 <= 5; 798c1 c1 7990 0 8001 1 8012 2 8023 3 8034 4 8045 5 805DROP TABLE t1,t2,t3,t4,t5,t6; 806CREATE TABLE t1 (c1 TINYINT NOT NULL); 807CREATE TABLE t2 (c1 TINYINT NOT NULL); 808CREATE TABLE t3 (c1 TINYINT NOT NULL); 809CREATE TABLE t4 (c1 TINYINT NOT NULL); 810CREATE TABLE t5 (c1 TINYINT NOT NULL); 811CREATE TABLE t6 (c1 TINYINT NOT NULL); 812INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 813INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 814INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 815INSERT INTO t4 (c1) VALUES(10); 816INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 817SELECT t1.c1,t3.c1 FROM t1 STRAIGHT_JOIN t3 ON t1.c1 = t3.c1; 818c1 c1 8191 1 8203 3 8215 5 8227 7 8239 9 824SELECT t1.c1,t3.c1 FROM t1 STRAIGHT_JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 <= 5; 825c1 c1 8261 1 8273 3 8285 5 829DROP TABLE t1,t2,t3,t4,t5,t6; 830CREATE TABLE t1 (c1 SMALLINT NOT NULL); 831CREATE TABLE t2 (c1 SMALLINT NOT NULL); 832CREATE TABLE t3 (c1 SMALLINT NOT NULL); 833CREATE TABLE t4 (c1 SMALLINT NOT NULL); 834CREATE TABLE t5 (c1 SMALLINT NOT NULL); 835CREATE TABLE t6 (c1 SMALLINT NOT NULL); 836INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 837INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 838INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 839INSERT INTO t4 (c1) VALUES(10); 840INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 841SELECT t1.c1,t3.c1 FROM t1 STRAIGHT_JOIN t3 ON t1.c1 = t3.c1; 842c1 c1 8431 1 8443 3 8455 5 8467 7 8479 9 848SELECT t1.c1,t3.c1 FROM t1 STRAIGHT_JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 <= 5; 849c1 c1 8501 1 8513 3 8525 5 853DROP TABLE t1,t2,t3,t4,t5,t6; 854CREATE TABLE t1 (c1 MEDIUMINT NOT NULL); 855CREATE TABLE t2 (c1 MEDIUMINT NOT NULL); 856CREATE TABLE t3 (c1 MEDIUMINT NOT NULL); 857CREATE TABLE t4 (c1 MEDIUMINT NOT NULL); 858CREATE TABLE t5 (c1 MEDIUMINT NOT NULL); 859CREATE TABLE t6 (c1 MEDIUMINT NOT NULL); 860INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 861INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 862INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 863INSERT INTO t4 (c1) VALUES(10); 864INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 865SELECT t1.c1,t3.c1 FROM t1 STRAIGHT_JOIN t3 ON t1.c1 = t3.c1; 866c1 c1 8671 1 8683 3 8695 5 8707 7 8719 9 872SELECT t1.c1,t3.c1 FROM t1 STRAIGHT_JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 <= 5; 873c1 c1 8741 1 8753 3 8765 5 877DROP TABLE t1,t2,t3,t4,t5,t6; 878CREATE TABLE t1 (c1 INT NOT NULL); 879CREATE TABLE t2 (c1 INT NOT NULL); 880CREATE TABLE t3 (c1 INT NOT NULL); 881CREATE TABLE t4 (c1 INT NOT NULL); 882CREATE TABLE t5 (c1 INT NOT NULL); 883CREATE TABLE t6 (c1 INT NOT NULL); 884INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 885INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 886INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 887INSERT INTO t4 (c1) VALUES(10); 888INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 889SELECT t1.c1,t3.c1 FROM t1 STRAIGHT_JOIN t3 ON t1.c1 = t3.c1; 890c1 c1 8911 1 8923 3 8935 5 8947 7 8959 9 896SELECT t1.c1,t3.c1 FROM t1 STRAIGHT_JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 <= 5; 897c1 c1 8981 1 8993 3 9005 5 901DROP TABLE t1,t2,t3,t4,t5,t6; 902CREATE TABLE t1 (c1 INTEGER NOT NULL); 903CREATE TABLE t2 (c1 INTEGER NOT NULL); 904CREATE TABLE t3 (c1 INTEGER NOT NULL); 905CREATE TABLE t4 (c1 INTEGER NOT NULL); 906CREATE TABLE t5 (c1 INTEGER NOT NULL); 907CREATE TABLE t6 (c1 INTEGER NOT NULL); 908INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 909INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 910INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 911INSERT INTO t4 (c1) VALUES(10); 912INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 913SELECT t1.c1,t3.c1 FROM t1 STRAIGHT_JOIN t3 ON t1.c1 = t3.c1; 914c1 c1 9151 1 9163 3 9175 5 9187 7 9199 9 920SELECT t1.c1,t3.c1 FROM t1 STRAIGHT_JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 <= 5; 921c1 c1 9221 1 9233 3 9245 5 925DROP TABLE t1,t2,t3,t4,t5,t6; 926CREATE TABLE t1 (c1 BIGINT NOT NULL); 927CREATE TABLE t2 (c1 BIGINT NOT NULL); 928CREATE TABLE t3 (c1 BIGINT NOT NULL); 929CREATE TABLE t4 (c1 BIGINT NOT NULL); 930CREATE TABLE t5 (c1 BIGINT NOT NULL); 931CREATE TABLE t6 (c1 BIGINT NOT NULL); 932INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 933INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 934INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 935INSERT INTO t4 (c1) VALUES(10); 936INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 937SELECT t1.c1,t3.c1 FROM t1 STRAIGHT_JOIN t3 ON t1.c1 = t3.c1; 938c1 c1 9391 1 9403 3 9415 5 9427 7 9439 9 944SELECT t1.c1,t3.c1 FROM t1 STRAIGHT_JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 <= 5; 945c1 c1 9461 1 9473 3 9485 5 949DROP TABLE t1,t2,t3,t4,t5,t6; 950CREATE TABLE t1 (c1 TINYINT NOT NULL); 951CREATE TABLE t2 (c1 TINYINT NOT NULL); 952CREATE TABLE t3 (c1 TINYINT NOT NULL); 953CREATE TABLE t4 (c1 TINYINT NOT NULL); 954CREATE TABLE t5 (c1 TINYINT NOT NULL); 955CREATE TABLE t6 (c1 TINYINT NOT NULL); 956INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 957INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 958INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 959INSERT INTO t4 (c1) VALUES(10); 960INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 961SELECT t1.c1,t4.c1 FROM t1 STRAIGHT_JOIN t4 ON t1.c1 = t4.c1; 962c1 c1 963SELECT t1.c1,t4.c1 FROM t1 STRAIGHT_JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 <= 5; 964c1 c1 965DROP TABLE t1,t2,t3,t4,t5,t6; 966CREATE TABLE t1 (c1 SMALLINT NOT NULL); 967CREATE TABLE t2 (c1 SMALLINT NOT NULL); 968CREATE TABLE t3 (c1 SMALLINT NOT NULL); 969CREATE TABLE t4 (c1 SMALLINT NOT NULL); 970CREATE TABLE t5 (c1 SMALLINT NOT NULL); 971CREATE TABLE t6 (c1 SMALLINT NOT NULL); 972INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 973INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 974INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 975INSERT INTO t4 (c1) VALUES(10); 976INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 977SELECT t1.c1,t4.c1 FROM t1 STRAIGHT_JOIN t4 ON t1.c1 = t4.c1; 978c1 c1 979SELECT t1.c1,t4.c1 FROM t1 STRAIGHT_JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 <= 5; 980c1 c1 981DROP TABLE t1,t2,t3,t4,t5,t6; 982CREATE TABLE t1 (c1 MEDIUMINT NOT NULL); 983CREATE TABLE t2 (c1 MEDIUMINT NOT NULL); 984CREATE TABLE t3 (c1 MEDIUMINT NOT NULL); 985CREATE TABLE t4 (c1 MEDIUMINT NOT NULL); 986CREATE TABLE t5 (c1 MEDIUMINT NOT NULL); 987CREATE TABLE t6 (c1 MEDIUMINT NOT NULL); 988INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 989INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 990INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 991INSERT INTO t4 (c1) VALUES(10); 992INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 993SELECT t1.c1,t4.c1 FROM t1 STRAIGHT_JOIN t4 ON t1.c1 = t4.c1; 994c1 c1 995SELECT t1.c1,t4.c1 FROM t1 STRAIGHT_JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 <= 5; 996c1 c1 997DROP TABLE t1,t2,t3,t4,t5,t6; 998CREATE TABLE t1 (c1 INT NOT NULL); 999CREATE TABLE t2 (c1 INT NOT NULL); 1000CREATE TABLE t3 (c1 INT NOT NULL); 1001CREATE TABLE t4 (c1 INT NOT NULL); 1002CREATE TABLE t5 (c1 INT NOT NULL); 1003CREATE TABLE t6 (c1 INT NOT NULL); 1004INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1005INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1006INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 1007INSERT INTO t4 (c1) VALUES(10); 1008INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 1009SELECT t1.c1,t4.c1 FROM t1 STRAIGHT_JOIN t4 ON t1.c1 = t4.c1; 1010c1 c1 1011SELECT t1.c1,t4.c1 FROM t1 STRAIGHT_JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 <= 5; 1012c1 c1 1013DROP TABLE t1,t2,t3,t4,t5,t6; 1014CREATE TABLE t1 (c1 INTEGER NOT NULL); 1015CREATE TABLE t2 (c1 INTEGER NOT NULL); 1016CREATE TABLE t3 (c1 INTEGER NOT NULL); 1017CREATE TABLE t4 (c1 INTEGER NOT NULL); 1018CREATE TABLE t5 (c1 INTEGER NOT NULL); 1019CREATE TABLE t6 (c1 INTEGER NOT NULL); 1020INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1021INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1022INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 1023INSERT INTO t4 (c1) VALUES(10); 1024INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 1025SELECT t1.c1,t4.c1 FROM t1 STRAIGHT_JOIN t4 ON t1.c1 = t4.c1; 1026c1 c1 1027SELECT t1.c1,t4.c1 FROM t1 STRAIGHT_JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 <= 5; 1028c1 c1 1029DROP TABLE t1,t2,t3,t4,t5,t6; 1030CREATE TABLE t1 (c1 BIGINT NOT NULL); 1031CREATE TABLE t2 (c1 BIGINT NOT NULL); 1032CREATE TABLE t3 (c1 BIGINT NOT NULL); 1033CREATE TABLE t4 (c1 BIGINT NOT NULL); 1034CREATE TABLE t5 (c1 BIGINT NOT NULL); 1035CREATE TABLE t6 (c1 BIGINT NOT NULL); 1036INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1037INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1038INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 1039INSERT INTO t4 (c1) VALUES(10); 1040INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 1041SELECT t1.c1,t4.c1 FROM t1 STRAIGHT_JOIN t4 ON t1.c1 = t4.c1; 1042c1 c1 1043SELECT t1.c1,t4.c1 FROM t1 STRAIGHT_JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 <= 5; 1044c1 c1 1045DROP TABLE t1,t2,t3,t4,t5,t6; 1046CREATE TABLE t1 (c1 TINYINT NOT NULL); 1047CREATE TABLE t2 (c1 TINYINT NOT NULL); 1048CREATE TABLE t3 (c1 TINYINT NOT NULL); 1049CREATE TABLE t4 (c1 TINYINT NOT NULL); 1050CREATE TABLE t5 (c1 TINYINT NOT NULL); 1051CREATE TABLE t6 (c1 TINYINT NOT NULL); 1052INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1053INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1054INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 1055INSERT INTO t4 (c1) VALUES(10); 1056INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 1057SELECT t1.c1,t5.c1 FROM t1 STRAIGHT_JOIN t5 ON t1.c1 = t5.c1; 1058c1 c1 1059SELECT t1.c1,t5.c1 FROM t1 STRAIGHT_JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 <= 5; 1060c1 c1 1061DROP TABLE t1,t2,t3,t4,t5,t6; 1062CREATE TABLE t1 (c1 SMALLINT NOT NULL); 1063CREATE TABLE t2 (c1 SMALLINT NOT NULL); 1064CREATE TABLE t3 (c1 SMALLINT NOT NULL); 1065CREATE TABLE t4 (c1 SMALLINT NOT NULL); 1066CREATE TABLE t5 (c1 SMALLINT NOT NULL); 1067CREATE TABLE t6 (c1 SMALLINT NOT NULL); 1068INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1069INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1070INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 1071INSERT INTO t4 (c1) VALUES(10); 1072INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 1073SELECT t1.c1,t5.c1 FROM t1 STRAIGHT_JOIN t5 ON t1.c1 = t5.c1; 1074c1 c1 1075SELECT t1.c1,t5.c1 FROM t1 STRAIGHT_JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 <= 5; 1076c1 c1 1077DROP TABLE t1,t2,t3,t4,t5,t6; 1078CREATE TABLE t1 (c1 MEDIUMINT NOT NULL); 1079CREATE TABLE t2 (c1 MEDIUMINT NOT NULL); 1080CREATE TABLE t3 (c1 MEDIUMINT NOT NULL); 1081CREATE TABLE t4 (c1 MEDIUMINT NOT NULL); 1082CREATE TABLE t5 (c1 MEDIUMINT NOT NULL); 1083CREATE TABLE t6 (c1 MEDIUMINT NOT NULL); 1084INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1085INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1086INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 1087INSERT INTO t4 (c1) VALUES(10); 1088INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 1089SELECT t1.c1,t5.c1 FROM t1 STRAIGHT_JOIN t5 ON t1.c1 = t5.c1; 1090c1 c1 1091SELECT t1.c1,t5.c1 FROM t1 STRAIGHT_JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 <= 5; 1092c1 c1 1093DROP TABLE t1,t2,t3,t4,t5,t6; 1094CREATE TABLE t1 (c1 INT NOT NULL); 1095CREATE TABLE t2 (c1 INT NOT NULL); 1096CREATE TABLE t3 (c1 INT NOT NULL); 1097CREATE TABLE t4 (c1 INT NOT NULL); 1098CREATE TABLE t5 (c1 INT NOT NULL); 1099CREATE TABLE t6 (c1 INT NOT NULL); 1100INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1101INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1102INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 1103INSERT INTO t4 (c1) VALUES(10); 1104INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 1105SELECT t1.c1,t5.c1 FROM t1 STRAIGHT_JOIN t5 ON t1.c1 = t5.c1; 1106c1 c1 1107SELECT t1.c1,t5.c1 FROM t1 STRAIGHT_JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 <= 5; 1108c1 c1 1109DROP TABLE t1,t2,t3,t4,t5,t6; 1110CREATE TABLE t1 (c1 INTEGER NOT NULL); 1111CREATE TABLE t2 (c1 INTEGER NOT NULL); 1112CREATE TABLE t3 (c1 INTEGER NOT NULL); 1113CREATE TABLE t4 (c1 INTEGER NOT NULL); 1114CREATE TABLE t5 (c1 INTEGER NOT NULL); 1115CREATE TABLE t6 (c1 INTEGER NOT NULL); 1116INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1117INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1118INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 1119INSERT INTO t4 (c1) VALUES(10); 1120INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 1121SELECT t1.c1,t5.c1 FROM t1 STRAIGHT_JOIN t5 ON t1.c1 = t5.c1; 1122c1 c1 1123SELECT t1.c1,t5.c1 FROM t1 STRAIGHT_JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 <= 5; 1124c1 c1 1125DROP TABLE t1,t2,t3,t4,t5,t6; 1126CREATE TABLE t1 (c1 BIGINT NOT NULL); 1127CREATE TABLE t2 (c1 BIGINT NOT NULL); 1128CREATE TABLE t3 (c1 BIGINT NOT NULL); 1129CREATE TABLE t4 (c1 BIGINT NOT NULL); 1130CREATE TABLE t5 (c1 BIGINT NOT NULL); 1131CREATE TABLE t6 (c1 BIGINT NOT NULL); 1132INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1133INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1134INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 1135INSERT INTO t4 (c1) VALUES(10); 1136INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 1137SELECT t1.c1,t5.c1 FROM t1 STRAIGHT_JOIN t5 ON t1.c1 = t5.c1; 1138c1 c1 1139SELECT t1.c1,t5.c1 FROM t1 STRAIGHT_JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 <= 5; 1140c1 c1 1141DROP TABLE t1,t2,t3,t4,t5,t6; 1142CREATE TABLE t1 (c1 TINYINT NOT NULL); 1143CREATE TABLE t2 (c1 TINYINT NOT NULL); 1144CREATE TABLE t3 (c1 TINYINT NOT NULL); 1145CREATE TABLE t4 (c1 TINYINT NOT NULL); 1146CREATE TABLE t5 (c1 TINYINT NOT NULL); 1147CREATE TABLE t6 (c1 TINYINT NOT NULL); 1148INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1149INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1150INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 1151INSERT INTO t4 (c1) VALUES(10); 1152INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 1153SELECT t1.c1,t6.c1 FROM t1 STRAIGHT_JOIN t6 ON t1.c1 = t6.c1; 1154c1 c1 1155SELECT t1.c1,t6.c1 FROM t1 STRAIGHT_JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 <= 5; 1156c1 c1 1157DROP TABLE t1,t2,t3,t4,t5,t6; 1158CREATE TABLE t1 (c1 SMALLINT NOT NULL); 1159CREATE TABLE t2 (c1 SMALLINT NOT NULL); 1160CREATE TABLE t3 (c1 SMALLINT NOT NULL); 1161CREATE TABLE t4 (c1 SMALLINT NOT NULL); 1162CREATE TABLE t5 (c1 SMALLINT NOT NULL); 1163CREATE TABLE t6 (c1 SMALLINT NOT NULL); 1164INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1165INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1166INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 1167INSERT INTO t4 (c1) VALUES(10); 1168INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 1169SELECT t1.c1,t6.c1 FROM t1 STRAIGHT_JOIN t6 ON t1.c1 = t6.c1; 1170c1 c1 1171SELECT t1.c1,t6.c1 FROM t1 STRAIGHT_JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 <= 5; 1172c1 c1 1173DROP TABLE t1,t2,t3,t4,t5,t6; 1174CREATE TABLE t1 (c1 MEDIUMINT NOT NULL); 1175CREATE TABLE t2 (c1 MEDIUMINT NOT NULL); 1176CREATE TABLE t3 (c1 MEDIUMINT NOT NULL); 1177CREATE TABLE t4 (c1 MEDIUMINT NOT NULL); 1178CREATE TABLE t5 (c1 MEDIUMINT NOT NULL); 1179CREATE TABLE t6 (c1 MEDIUMINT NOT NULL); 1180INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1181INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1182INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 1183INSERT INTO t4 (c1) VALUES(10); 1184INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 1185SELECT t1.c1,t6.c1 FROM t1 STRAIGHT_JOIN t6 ON t1.c1 = t6.c1; 1186c1 c1 1187SELECT t1.c1,t6.c1 FROM t1 STRAIGHT_JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 <= 5; 1188c1 c1 1189DROP TABLE t1,t2,t3,t4,t5,t6; 1190CREATE TABLE t1 (c1 INT NOT NULL); 1191CREATE TABLE t2 (c1 INT NOT NULL); 1192CREATE TABLE t3 (c1 INT NOT NULL); 1193CREATE TABLE t4 (c1 INT NOT NULL); 1194CREATE TABLE t5 (c1 INT NOT NULL); 1195CREATE TABLE t6 (c1 INT NOT NULL); 1196INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1197INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1198INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 1199INSERT INTO t4 (c1) VALUES(10); 1200INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 1201SELECT t1.c1,t6.c1 FROM t1 STRAIGHT_JOIN t6 ON t1.c1 = t6.c1; 1202c1 c1 1203SELECT t1.c1,t6.c1 FROM t1 STRAIGHT_JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 <= 5; 1204c1 c1 1205DROP TABLE t1,t2,t3,t4,t5,t6; 1206CREATE TABLE t1 (c1 INTEGER NOT NULL); 1207CREATE TABLE t2 (c1 INTEGER NOT NULL); 1208CREATE TABLE t3 (c1 INTEGER NOT NULL); 1209CREATE TABLE t4 (c1 INTEGER NOT NULL); 1210CREATE TABLE t5 (c1 INTEGER NOT NULL); 1211CREATE TABLE t6 (c1 INTEGER NOT NULL); 1212INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1213INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1214INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 1215INSERT INTO t4 (c1) VALUES(10); 1216INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 1217SELECT t1.c1,t6.c1 FROM t1 STRAIGHT_JOIN t6 ON t1.c1 = t6.c1; 1218c1 c1 1219SELECT t1.c1,t6.c1 FROM t1 STRAIGHT_JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 <= 5; 1220c1 c1 1221DROP TABLE t1,t2,t3,t4,t5,t6; 1222CREATE TABLE t1 (c1 BIGINT NOT NULL); 1223CREATE TABLE t2 (c1 BIGINT NOT NULL); 1224CREATE TABLE t3 (c1 BIGINT NOT NULL); 1225CREATE TABLE t4 (c1 BIGINT NOT NULL); 1226CREATE TABLE t5 (c1 BIGINT NOT NULL); 1227CREATE TABLE t6 (c1 BIGINT NOT NULL); 1228INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1229INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1230INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 1231INSERT INTO t4 (c1) VALUES(10); 1232INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 1233SELECT t1.c1,t6.c1 FROM t1 STRAIGHT_JOIN t6 ON t1.c1 = t6.c1; 1234c1 c1 1235SELECT t1.c1,t6.c1 FROM t1 STRAIGHT_JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 <= 5; 1236c1 c1 1237DROP TABLE t1,t2,t3,t4,t5,t6; 1238CREATE TABLE t1 (c1 TINYINT NOT NULL); 1239CREATE TABLE t2 (c1 TINYINT NOT NULL); 1240CREATE TABLE t3 (c1 TINYINT NOT NULL); 1241CREATE TABLE t4 (c1 TINYINT NOT NULL); 1242CREATE TABLE t5 (c1 TINYINT NOT NULL); 1243CREATE TABLE t6 (c1 TINYINT NOT NULL); 1244INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1245INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1246INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 1247INSERT INTO t4 (c1) VALUES(10); 1248INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 1249SELECT t1.c1,t2.c1 FROM t1 STRAIGHT_JOIN t2 ON t1.c1 = t2.c1; 1250c1 c1 12510 0 12521 1 12532 2 12543 3 12554 4 12565 5 12576 6 12587 7 12598 8 12609 9 1261SELECT t1.c1,t2.c1 FROM t1 STRAIGHT_JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 = 5; 1262c1 c1 12635 5 1264DROP TABLE t1,t2,t3,t4,t5,t6; 1265CREATE TABLE t1 (c1 SMALLINT NOT NULL); 1266CREATE TABLE t2 (c1 SMALLINT NOT NULL); 1267CREATE TABLE t3 (c1 SMALLINT NOT NULL); 1268CREATE TABLE t4 (c1 SMALLINT NOT NULL); 1269CREATE TABLE t5 (c1 SMALLINT NOT NULL); 1270CREATE TABLE t6 (c1 SMALLINT NOT NULL); 1271INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1272INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1273INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 1274INSERT INTO t4 (c1) VALUES(10); 1275INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 1276SELECT t1.c1,t2.c1 FROM t1 STRAIGHT_JOIN t2 ON t1.c1 = t2.c1; 1277c1 c1 12780 0 12791 1 12802 2 12813 3 12824 4 12835 5 12846 6 12857 7 12868 8 12879 9 1288SELECT t1.c1,t2.c1 FROM t1 STRAIGHT_JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 = 5; 1289c1 c1 12905 5 1291DROP TABLE t1,t2,t3,t4,t5,t6; 1292CREATE TABLE t1 (c1 MEDIUMINT NOT NULL); 1293CREATE TABLE t2 (c1 MEDIUMINT NOT NULL); 1294CREATE TABLE t3 (c1 MEDIUMINT NOT NULL); 1295CREATE TABLE t4 (c1 MEDIUMINT NOT NULL); 1296CREATE TABLE t5 (c1 MEDIUMINT NOT NULL); 1297CREATE TABLE t6 (c1 MEDIUMINT NOT NULL); 1298INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1299INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1300INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 1301INSERT INTO t4 (c1) VALUES(10); 1302INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 1303SELECT t1.c1,t2.c1 FROM t1 STRAIGHT_JOIN t2 ON t1.c1 = t2.c1; 1304c1 c1 13050 0 13061 1 13072 2 13083 3 13094 4 13105 5 13116 6 13127 7 13138 8 13149 9 1315SELECT t1.c1,t2.c1 FROM t1 STRAIGHT_JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 = 5; 1316c1 c1 13175 5 1318DROP TABLE t1,t2,t3,t4,t5,t6; 1319CREATE TABLE t1 (c1 INT NOT NULL); 1320CREATE TABLE t2 (c1 INT NOT NULL); 1321CREATE TABLE t3 (c1 INT NOT NULL); 1322CREATE TABLE t4 (c1 INT NOT NULL); 1323CREATE TABLE t5 (c1 INT NOT NULL); 1324CREATE TABLE t6 (c1 INT NOT NULL); 1325INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1326INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1327INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 1328INSERT INTO t4 (c1) VALUES(10); 1329INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 1330SELECT t1.c1,t2.c1 FROM t1 STRAIGHT_JOIN t2 ON t1.c1 = t2.c1; 1331c1 c1 13320 0 13331 1 13342 2 13353 3 13364 4 13375 5 13386 6 13397 7 13408 8 13419 9 1342SELECT t1.c1,t2.c1 FROM t1 STRAIGHT_JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 = 5; 1343c1 c1 13445 5 1345DROP TABLE t1,t2,t3,t4,t5,t6; 1346CREATE TABLE t1 (c1 INTEGER NOT NULL); 1347CREATE TABLE t2 (c1 INTEGER NOT NULL); 1348CREATE TABLE t3 (c1 INTEGER NOT NULL); 1349CREATE TABLE t4 (c1 INTEGER NOT NULL); 1350CREATE TABLE t5 (c1 INTEGER NOT NULL); 1351CREATE TABLE t6 (c1 INTEGER NOT NULL); 1352INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1353INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1354INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 1355INSERT INTO t4 (c1) VALUES(10); 1356INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 1357SELECT t1.c1,t2.c1 FROM t1 STRAIGHT_JOIN t2 ON t1.c1 = t2.c1; 1358c1 c1 13590 0 13601 1 13612 2 13623 3 13634 4 13645 5 13656 6 13667 7 13678 8 13689 9 1369SELECT t1.c1,t2.c1 FROM t1 STRAIGHT_JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 = 5; 1370c1 c1 13715 5 1372DROP TABLE t1,t2,t3,t4,t5,t6; 1373CREATE TABLE t1 (c1 BIGINT NOT NULL); 1374CREATE TABLE t2 (c1 BIGINT NOT NULL); 1375CREATE TABLE t3 (c1 BIGINT NOT NULL); 1376CREATE TABLE t4 (c1 BIGINT NOT NULL); 1377CREATE TABLE t5 (c1 BIGINT NOT NULL); 1378CREATE TABLE t6 (c1 BIGINT NOT NULL); 1379INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1380INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1381INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 1382INSERT INTO t4 (c1) VALUES(10); 1383INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 1384SELECT t1.c1,t2.c1 FROM t1 STRAIGHT_JOIN t2 ON t1.c1 = t2.c1; 1385c1 c1 13860 0 13871 1 13882 2 13893 3 13904 4 13915 5 13926 6 13937 7 13948 8 13959 9 1396SELECT t1.c1,t2.c1 FROM t1 STRAIGHT_JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 = 5; 1397c1 c1 13985 5 1399DROP TABLE t1,t2,t3,t4,t5,t6; 1400CREATE TABLE t1 (c1 TINYINT NOT NULL); 1401CREATE TABLE t2 (c1 TINYINT NOT NULL); 1402CREATE TABLE t3 (c1 TINYINT NOT NULL); 1403CREATE TABLE t4 (c1 TINYINT NOT NULL); 1404CREATE TABLE t5 (c1 TINYINT NOT NULL); 1405CREATE TABLE t6 (c1 TINYINT NOT NULL); 1406INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1407INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1408INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 1409INSERT INTO t4 (c1) VALUES(10); 1410INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 1411SELECT t1.c1,t3.c1 FROM t1 STRAIGHT_JOIN t3 ON t1.c1 = t3.c1; 1412c1 c1 14131 1 14143 3 14155 5 14167 7 14179 9 1418SELECT t1.c1,t3.c1 FROM t1 STRAIGHT_JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 = 5; 1419c1 c1 14205 5 1421DROP TABLE t1,t2,t3,t4,t5,t6; 1422CREATE TABLE t1 (c1 SMALLINT NOT NULL); 1423CREATE TABLE t2 (c1 SMALLINT NOT NULL); 1424CREATE TABLE t3 (c1 SMALLINT NOT NULL); 1425CREATE TABLE t4 (c1 SMALLINT NOT NULL); 1426CREATE TABLE t5 (c1 SMALLINT NOT NULL); 1427CREATE TABLE t6 (c1 SMALLINT NOT NULL); 1428INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1429INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1430INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 1431INSERT INTO t4 (c1) VALUES(10); 1432INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 1433SELECT t1.c1,t3.c1 FROM t1 STRAIGHT_JOIN t3 ON t1.c1 = t3.c1; 1434c1 c1 14351 1 14363 3 14375 5 14387 7 14399 9 1440SELECT t1.c1,t3.c1 FROM t1 STRAIGHT_JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 = 5; 1441c1 c1 14425 5 1443DROP TABLE t1,t2,t3,t4,t5,t6; 1444CREATE TABLE t1 (c1 MEDIUMINT NOT NULL); 1445CREATE TABLE t2 (c1 MEDIUMINT NOT NULL); 1446CREATE TABLE t3 (c1 MEDIUMINT NOT NULL); 1447CREATE TABLE t4 (c1 MEDIUMINT NOT NULL); 1448CREATE TABLE t5 (c1 MEDIUMINT NOT NULL); 1449CREATE TABLE t6 (c1 MEDIUMINT NOT NULL); 1450INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1451INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1452INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 1453INSERT INTO t4 (c1) VALUES(10); 1454INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 1455SELECT t1.c1,t3.c1 FROM t1 STRAIGHT_JOIN t3 ON t1.c1 = t3.c1; 1456c1 c1 14571 1 14583 3 14595 5 14607 7 14619 9 1462SELECT t1.c1,t3.c1 FROM t1 STRAIGHT_JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 = 5; 1463c1 c1 14645 5 1465DROP TABLE t1,t2,t3,t4,t5,t6; 1466CREATE TABLE t1 (c1 INT NOT NULL); 1467CREATE TABLE t2 (c1 INT NOT NULL); 1468CREATE TABLE t3 (c1 INT NOT NULL); 1469CREATE TABLE t4 (c1 INT NOT NULL); 1470CREATE TABLE t5 (c1 INT NOT NULL); 1471CREATE TABLE t6 (c1 INT 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,t3.c1 FROM t1 STRAIGHT_JOIN t3 ON t1.c1 = t3.c1; 1478c1 c1 14791 1 14803 3 14815 5 14827 7 14839 9 1484SELECT t1.c1,t3.c1 FROM t1 STRAIGHT_JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 = 5; 1485c1 c1 14865 5 1487DROP TABLE t1,t2,t3,t4,t5,t6; 1488CREATE TABLE t1 (c1 INTEGER NOT NULL); 1489CREATE TABLE t2 (c1 INTEGER NOT NULL); 1490CREATE TABLE t3 (c1 INTEGER NOT NULL); 1491CREATE TABLE t4 (c1 INTEGER NOT NULL); 1492CREATE TABLE t5 (c1 INTEGER NOT NULL); 1493CREATE TABLE t6 (c1 INTEGER NOT NULL); 1494INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1495INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1496INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 1497INSERT INTO t4 (c1) VALUES(10); 1498INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 1499SELECT t1.c1,t3.c1 FROM t1 STRAIGHT_JOIN t3 ON t1.c1 = t3.c1; 1500c1 c1 15011 1 15023 3 15035 5 15047 7 15059 9 1506SELECT t1.c1,t3.c1 FROM t1 STRAIGHT_JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 = 5; 1507c1 c1 15085 5 1509DROP TABLE t1,t2,t3,t4,t5,t6; 1510CREATE TABLE t1 (c1 BIGINT NOT NULL); 1511CREATE TABLE t2 (c1 BIGINT NOT NULL); 1512CREATE TABLE t3 (c1 BIGINT NOT NULL); 1513CREATE TABLE t4 (c1 BIGINT NOT NULL); 1514CREATE TABLE t5 (c1 BIGINT NOT NULL); 1515CREATE TABLE t6 (c1 BIGINT NOT NULL); 1516INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1517INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1518INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 1519INSERT INTO t4 (c1) VALUES(10); 1520INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 1521SELECT t1.c1,t3.c1 FROM t1 STRAIGHT_JOIN t3 ON t1.c1 = t3.c1; 1522c1 c1 15231 1 15243 3 15255 5 15267 7 15279 9 1528SELECT t1.c1,t3.c1 FROM t1 STRAIGHT_JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 = 5; 1529c1 c1 15305 5 1531DROP TABLE t1,t2,t3,t4,t5,t6; 1532CREATE TABLE t1 (c1 TINYINT NOT NULL); 1533CREATE TABLE t2 (c1 TINYINT NOT NULL); 1534CREATE TABLE t3 (c1 TINYINT NOT NULL); 1535CREATE TABLE t4 (c1 TINYINT NOT NULL); 1536CREATE TABLE t5 (c1 TINYINT NOT NULL); 1537CREATE TABLE t6 (c1 TINYINT NOT NULL); 1538INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1539INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1540INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 1541INSERT INTO t4 (c1) VALUES(10); 1542INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 1543SELECT t1.c1,t4.c1 FROM t1 STRAIGHT_JOIN t4 ON t1.c1 = t4.c1; 1544c1 c1 1545SELECT t1.c1,t4.c1 FROM t1 STRAIGHT_JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 = 5; 1546c1 c1 1547DROP TABLE t1,t2,t3,t4,t5,t6; 1548CREATE TABLE t1 (c1 SMALLINT NOT NULL); 1549CREATE TABLE t2 (c1 SMALLINT NOT NULL); 1550CREATE TABLE t3 (c1 SMALLINT NOT NULL); 1551CREATE TABLE t4 (c1 SMALLINT NOT NULL); 1552CREATE TABLE t5 (c1 SMALLINT NOT NULL); 1553CREATE TABLE t6 (c1 SMALLINT NOT NULL); 1554INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1555INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1556INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 1557INSERT INTO t4 (c1) VALUES(10); 1558INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 1559SELECT t1.c1,t4.c1 FROM t1 STRAIGHT_JOIN t4 ON t1.c1 = t4.c1; 1560c1 c1 1561SELECT t1.c1,t4.c1 FROM t1 STRAIGHT_JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 = 5; 1562c1 c1 1563DROP TABLE t1,t2,t3,t4,t5,t6; 1564CREATE TABLE t1 (c1 MEDIUMINT NOT NULL); 1565CREATE TABLE t2 (c1 MEDIUMINT NOT NULL); 1566CREATE TABLE t3 (c1 MEDIUMINT NOT NULL); 1567CREATE TABLE t4 (c1 MEDIUMINT NOT NULL); 1568CREATE TABLE t5 (c1 MEDIUMINT NOT NULL); 1569CREATE TABLE t6 (c1 MEDIUMINT NOT NULL); 1570INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1571INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1572INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 1573INSERT INTO t4 (c1) VALUES(10); 1574INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 1575SELECT t1.c1,t4.c1 FROM t1 STRAIGHT_JOIN t4 ON t1.c1 = t4.c1; 1576c1 c1 1577SELECT t1.c1,t4.c1 FROM t1 STRAIGHT_JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 = 5; 1578c1 c1 1579DROP TABLE t1,t2,t3,t4,t5,t6; 1580CREATE TABLE t1 (c1 INT NOT NULL); 1581CREATE TABLE t2 (c1 INT NOT NULL); 1582CREATE TABLE t3 (c1 INT NOT NULL); 1583CREATE TABLE t4 (c1 INT NOT NULL); 1584CREATE TABLE t5 (c1 INT NOT NULL); 1585CREATE TABLE t6 (c1 INT NOT NULL); 1586INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1587INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1588INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 1589INSERT INTO t4 (c1) VALUES(10); 1590INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 1591SELECT t1.c1,t4.c1 FROM t1 STRAIGHT_JOIN t4 ON t1.c1 = t4.c1; 1592c1 c1 1593SELECT t1.c1,t4.c1 FROM t1 STRAIGHT_JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 = 5; 1594c1 c1 1595DROP TABLE t1,t2,t3,t4,t5,t6; 1596CREATE TABLE t1 (c1 INTEGER NOT NULL); 1597CREATE TABLE t2 (c1 INTEGER NOT NULL); 1598CREATE TABLE t3 (c1 INTEGER NOT NULL); 1599CREATE TABLE t4 (c1 INTEGER NOT NULL); 1600CREATE TABLE t5 (c1 INTEGER NOT NULL); 1601CREATE TABLE t6 (c1 INTEGER NOT NULL); 1602INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1603INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1604INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 1605INSERT INTO t4 (c1) VALUES(10); 1606INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 1607SELECT t1.c1,t4.c1 FROM t1 STRAIGHT_JOIN t4 ON t1.c1 = t4.c1; 1608c1 c1 1609SELECT t1.c1,t4.c1 FROM t1 STRAIGHT_JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 = 5; 1610c1 c1 1611DROP TABLE t1,t2,t3,t4,t5,t6; 1612CREATE TABLE t1 (c1 BIGINT NOT NULL); 1613CREATE TABLE t2 (c1 BIGINT NOT NULL); 1614CREATE TABLE t3 (c1 BIGINT NOT NULL); 1615CREATE TABLE t4 (c1 BIGINT NOT NULL); 1616CREATE TABLE t5 (c1 BIGINT NOT NULL); 1617CREATE TABLE t6 (c1 BIGINT NOT NULL); 1618INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1619INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1620INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 1621INSERT INTO t4 (c1) VALUES(10); 1622INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 1623SELECT t1.c1,t4.c1 FROM t1 STRAIGHT_JOIN t4 ON t1.c1 = t4.c1; 1624c1 c1 1625SELECT t1.c1,t4.c1 FROM t1 STRAIGHT_JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 = 5; 1626c1 c1 1627DROP TABLE t1,t2,t3,t4,t5,t6; 1628CREATE TABLE t1 (c1 TINYINT NOT NULL); 1629CREATE TABLE t2 (c1 TINYINT NOT NULL); 1630CREATE TABLE t3 (c1 TINYINT NOT NULL); 1631CREATE TABLE t4 (c1 TINYINT NOT NULL); 1632CREATE TABLE t5 (c1 TINYINT NOT NULL); 1633CREATE TABLE t6 (c1 TINYINT NOT NULL); 1634INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1635INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1636INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 1637INSERT INTO t4 (c1) VALUES(10); 1638INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 1639SELECT t1.c1,t5.c1 FROM t1 STRAIGHT_JOIN t5 ON t1.c1 = t5.c1; 1640c1 c1 1641SELECT t1.c1,t5.c1 FROM t1 STRAIGHT_JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 = 5; 1642c1 c1 1643DROP TABLE t1,t2,t3,t4,t5,t6; 1644CREATE TABLE t1 (c1 SMALLINT NOT NULL); 1645CREATE TABLE t2 (c1 SMALLINT NOT NULL); 1646CREATE TABLE t3 (c1 SMALLINT NOT NULL); 1647CREATE TABLE t4 (c1 SMALLINT NOT NULL); 1648CREATE TABLE t5 (c1 SMALLINT NOT NULL); 1649CREATE TABLE t6 (c1 SMALLINT NOT NULL); 1650INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1651INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1652INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 1653INSERT INTO t4 (c1) VALUES(10); 1654INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 1655SELECT t1.c1,t5.c1 FROM t1 STRAIGHT_JOIN t5 ON t1.c1 = t5.c1; 1656c1 c1 1657SELECT t1.c1,t5.c1 FROM t1 STRAIGHT_JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 = 5; 1658c1 c1 1659DROP TABLE t1,t2,t3,t4,t5,t6; 1660CREATE TABLE t1 (c1 MEDIUMINT NOT NULL); 1661CREATE TABLE t2 (c1 MEDIUMINT NOT NULL); 1662CREATE TABLE t3 (c1 MEDIUMINT NOT NULL); 1663CREATE TABLE t4 (c1 MEDIUMINT NOT NULL); 1664CREATE TABLE t5 (c1 MEDIUMINT NOT NULL); 1665CREATE TABLE t6 (c1 MEDIUMINT NOT NULL); 1666INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1667INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1668INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 1669INSERT INTO t4 (c1) VALUES(10); 1670INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 1671SELECT t1.c1,t5.c1 FROM t1 STRAIGHT_JOIN t5 ON t1.c1 = t5.c1; 1672c1 c1 1673SELECT t1.c1,t5.c1 FROM t1 STRAIGHT_JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 = 5; 1674c1 c1 1675DROP TABLE t1,t2,t3,t4,t5,t6; 1676CREATE TABLE t1 (c1 INT NOT NULL); 1677CREATE TABLE t2 (c1 INT NOT NULL); 1678CREATE TABLE t3 (c1 INT NOT NULL); 1679CREATE TABLE t4 (c1 INT NOT NULL); 1680CREATE TABLE t5 (c1 INT NOT NULL); 1681CREATE TABLE t6 (c1 INT NOT NULL); 1682INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1683INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1684INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 1685INSERT INTO t4 (c1) VALUES(10); 1686INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 1687SELECT t1.c1,t5.c1 FROM t1 STRAIGHT_JOIN t5 ON t1.c1 = t5.c1; 1688c1 c1 1689SELECT t1.c1,t5.c1 FROM t1 STRAIGHT_JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 = 5; 1690c1 c1 1691DROP TABLE t1,t2,t3,t4,t5,t6; 1692CREATE TABLE t1 (c1 INTEGER NOT NULL); 1693CREATE TABLE t2 (c1 INTEGER NOT NULL); 1694CREATE TABLE t3 (c1 INTEGER NOT NULL); 1695CREATE TABLE t4 (c1 INTEGER NOT NULL); 1696CREATE TABLE t5 (c1 INTEGER NOT NULL); 1697CREATE TABLE t6 (c1 INTEGER NOT NULL); 1698INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1699INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1700INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 1701INSERT INTO t4 (c1) VALUES(10); 1702INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 1703SELECT t1.c1,t5.c1 FROM t1 STRAIGHT_JOIN t5 ON t1.c1 = t5.c1; 1704c1 c1 1705SELECT t1.c1,t5.c1 FROM t1 STRAIGHT_JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 = 5; 1706c1 c1 1707DROP TABLE t1,t2,t3,t4,t5,t6; 1708CREATE TABLE t1 (c1 BIGINT NOT NULL); 1709CREATE TABLE t2 (c1 BIGINT NOT NULL); 1710CREATE TABLE t3 (c1 BIGINT NOT NULL); 1711CREATE TABLE t4 (c1 BIGINT NOT NULL); 1712CREATE TABLE t5 (c1 BIGINT NOT NULL); 1713CREATE TABLE t6 (c1 BIGINT NOT NULL); 1714INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1715INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1716INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 1717INSERT INTO t4 (c1) VALUES(10); 1718INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 1719SELECT t1.c1,t5.c1 FROM t1 STRAIGHT_JOIN t5 ON t1.c1 = t5.c1; 1720c1 c1 1721SELECT t1.c1,t5.c1 FROM t1 STRAIGHT_JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 = 5; 1722c1 c1 1723DROP TABLE t1,t2,t3,t4,t5,t6; 1724CREATE TABLE t1 (c1 TINYINT NOT NULL); 1725CREATE TABLE t2 (c1 TINYINT NOT NULL); 1726CREATE TABLE t3 (c1 TINYINT NOT NULL); 1727CREATE TABLE t4 (c1 TINYINT NOT NULL); 1728CREATE TABLE t5 (c1 TINYINT NOT NULL); 1729CREATE TABLE t6 (c1 TINYINT NOT NULL); 1730INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1731INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1732INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 1733INSERT INTO t4 (c1) VALUES(10); 1734INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 1735SELECT t1.c1,t6.c1 FROM t1 STRAIGHT_JOIN t6 ON t1.c1 = t6.c1; 1736c1 c1 1737SELECT t1.c1,t6.c1 FROM t1 STRAIGHT_JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 = 5; 1738c1 c1 1739DROP TABLE t1,t2,t3,t4,t5,t6; 1740CREATE TABLE t1 (c1 SMALLINT NOT NULL); 1741CREATE TABLE t2 (c1 SMALLINT NOT NULL); 1742CREATE TABLE t3 (c1 SMALLINT NOT NULL); 1743CREATE TABLE t4 (c1 SMALLINT NOT NULL); 1744CREATE TABLE t5 (c1 SMALLINT NOT NULL); 1745CREATE TABLE t6 (c1 SMALLINT NOT NULL); 1746INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1747INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1748INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 1749INSERT INTO t4 (c1) VALUES(10); 1750INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 1751SELECT t1.c1,t6.c1 FROM t1 STRAIGHT_JOIN t6 ON t1.c1 = t6.c1; 1752c1 c1 1753SELECT t1.c1,t6.c1 FROM t1 STRAIGHT_JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 = 5; 1754c1 c1 1755DROP TABLE t1,t2,t3,t4,t5,t6; 1756CREATE TABLE t1 (c1 MEDIUMINT NOT NULL); 1757CREATE TABLE t2 (c1 MEDIUMINT NOT NULL); 1758CREATE TABLE t3 (c1 MEDIUMINT NOT NULL); 1759CREATE TABLE t4 (c1 MEDIUMINT NOT NULL); 1760CREATE TABLE t5 (c1 MEDIUMINT NOT NULL); 1761CREATE TABLE t6 (c1 MEDIUMINT NOT NULL); 1762INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1763INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1764INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 1765INSERT INTO t4 (c1) VALUES(10); 1766INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 1767SELECT t1.c1,t6.c1 FROM t1 STRAIGHT_JOIN t6 ON t1.c1 = t6.c1; 1768c1 c1 1769SELECT t1.c1,t6.c1 FROM t1 STRAIGHT_JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 = 5; 1770c1 c1 1771DROP TABLE t1,t2,t3,t4,t5,t6; 1772CREATE TABLE t1 (c1 INT NOT NULL); 1773CREATE TABLE t2 (c1 INT NOT NULL); 1774CREATE TABLE t3 (c1 INT NOT NULL); 1775CREATE TABLE t4 (c1 INT NOT NULL); 1776CREATE TABLE t5 (c1 INT NOT NULL); 1777CREATE TABLE t6 (c1 INT 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,t6.c1 FROM t1 STRAIGHT_JOIN t6 ON t1.c1 = t6.c1; 1784c1 c1 1785SELECT t1.c1,t6.c1 FROM t1 STRAIGHT_JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 = 5; 1786c1 c1 1787DROP TABLE t1,t2,t3,t4,t5,t6; 1788CREATE TABLE t1 (c1 INTEGER NOT NULL); 1789CREATE TABLE t2 (c1 INTEGER NOT NULL); 1790CREATE TABLE t3 (c1 INTEGER NOT NULL); 1791CREATE TABLE t4 (c1 INTEGER NOT NULL); 1792CREATE TABLE t5 (c1 INTEGER NOT NULL); 1793CREATE TABLE t6 (c1 INTEGER NOT NULL); 1794INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1795INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1796INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 1797INSERT INTO t4 (c1) VALUES(10); 1798INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 1799SELECT t1.c1,t6.c1 FROM t1 STRAIGHT_JOIN t6 ON t1.c1 = t6.c1; 1800c1 c1 1801SELECT t1.c1,t6.c1 FROM t1 STRAIGHT_JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 = 5; 1802c1 c1 1803DROP TABLE t1,t2,t3,t4,t5,t6; 1804CREATE TABLE t1 (c1 BIGINT NOT NULL); 1805CREATE TABLE t2 (c1 BIGINT NOT NULL); 1806CREATE TABLE t3 (c1 BIGINT NOT NULL); 1807CREATE TABLE t4 (c1 BIGINT NOT NULL); 1808CREATE TABLE t5 (c1 BIGINT NOT NULL); 1809CREATE TABLE t6 (c1 BIGINT NOT NULL); 1810INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1811INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1812INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 1813INSERT INTO t4 (c1) VALUES(10); 1814INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 1815SELECT t1.c1,t6.c1 FROM t1 STRAIGHT_JOIN t6 ON t1.c1 = t6.c1; 1816c1 c1 1817SELECT t1.c1,t6.c1 FROM t1 STRAIGHT_JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 = 5; 1818c1 c1 1819DROP TABLE t1,t2,t3,t4,t5,t6; 1820CREATE TABLE t1 (c1 TINYINT NOT NULL); 1821CREATE TABLE t2 (c1 TINYINT NOT NULL); 1822CREATE TABLE t3 (c1 TINYINT NOT NULL); 1823CREATE TABLE t4 (c1 TINYINT NOT NULL); 1824CREATE TABLE t5 (c1 TINYINT NOT NULL); 1825CREATE TABLE t6 (c1 TINYINT NOT NULL); 1826INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1827INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1828INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 1829INSERT INTO t4 (c1) VALUES(10); 1830INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 1831SELECT t1.c1,t2.c1 FROM t1 STRAIGHT_JOIN t2 ON t1.c1 = t2.c1; 1832c1 c1 18330 0 18341 1 18352 2 18363 3 18374 4 18385 5 18396 6 18407 7 18418 8 18429 9 1843SELECT t1.c1,t2.c1 FROM t1 STRAIGHT_JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 >= 5; 1844c1 c1 18455 5 18466 6 18477 7 18488 8 18499 9 1850DROP TABLE t1,t2,t3,t4,t5,t6; 1851CREATE TABLE t1 (c1 SMALLINT NOT NULL); 1852CREATE TABLE t2 (c1 SMALLINT NOT NULL); 1853CREATE TABLE t3 (c1 SMALLINT NOT NULL); 1854CREATE TABLE t4 (c1 SMALLINT NOT NULL); 1855CREATE TABLE t5 (c1 SMALLINT NOT NULL); 1856CREATE TABLE t6 (c1 SMALLINT NOT NULL); 1857INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1858INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1859INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 1860INSERT INTO t4 (c1) VALUES(10); 1861INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 1862SELECT t1.c1,t2.c1 FROM t1 STRAIGHT_JOIN t2 ON t1.c1 = t2.c1; 1863c1 c1 18640 0 18651 1 18662 2 18673 3 18684 4 18695 5 18706 6 18717 7 18728 8 18739 9 1874SELECT t1.c1,t2.c1 FROM t1 STRAIGHT_JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 >= 5; 1875c1 c1 18765 5 18776 6 18787 7 18798 8 18809 9 1881DROP TABLE t1,t2,t3,t4,t5,t6; 1882CREATE TABLE t1 (c1 MEDIUMINT NOT NULL); 1883CREATE TABLE t2 (c1 MEDIUMINT NOT NULL); 1884CREATE TABLE t3 (c1 MEDIUMINT NOT NULL); 1885CREATE TABLE t4 (c1 MEDIUMINT NOT NULL); 1886CREATE TABLE t5 (c1 MEDIUMINT NOT NULL); 1887CREATE TABLE t6 (c1 MEDIUMINT NOT NULL); 1888INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1889INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1890INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 1891INSERT INTO t4 (c1) VALUES(10); 1892INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 1893SELECT t1.c1,t2.c1 FROM t1 STRAIGHT_JOIN t2 ON t1.c1 = t2.c1; 1894c1 c1 18950 0 18961 1 18972 2 18983 3 18994 4 19005 5 19016 6 19027 7 19038 8 19049 9 1905SELECT t1.c1,t2.c1 FROM t1 STRAIGHT_JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 >= 5; 1906c1 c1 19075 5 19086 6 19097 7 19108 8 19119 9 1912DROP TABLE t1,t2,t3,t4,t5,t6; 1913CREATE TABLE t1 (c1 INT NOT NULL); 1914CREATE TABLE t2 (c1 INT NOT NULL); 1915CREATE TABLE t3 (c1 INT NOT NULL); 1916CREATE TABLE t4 (c1 INT NOT NULL); 1917CREATE TABLE t5 (c1 INT NOT NULL); 1918CREATE TABLE t6 (c1 INT NOT NULL); 1919INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1920INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1921INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 1922INSERT INTO t4 (c1) VALUES(10); 1923INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 1924SELECT t1.c1,t2.c1 FROM t1 STRAIGHT_JOIN t2 ON t1.c1 = t2.c1; 1925c1 c1 19260 0 19271 1 19282 2 19293 3 19304 4 19315 5 19326 6 19337 7 19348 8 19359 9 1936SELECT t1.c1,t2.c1 FROM t1 STRAIGHT_JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 >= 5; 1937c1 c1 19385 5 19396 6 19407 7 19418 8 19429 9 1943DROP TABLE t1,t2,t3,t4,t5,t6; 1944CREATE TABLE t1 (c1 INTEGER NOT NULL); 1945CREATE TABLE t2 (c1 INTEGER NOT NULL); 1946CREATE TABLE t3 (c1 INTEGER NOT NULL); 1947CREATE TABLE t4 (c1 INTEGER NOT NULL); 1948CREATE TABLE t5 (c1 INTEGER NOT NULL); 1949CREATE TABLE t6 (c1 INTEGER NOT NULL); 1950INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1951INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1952INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 1953INSERT INTO t4 (c1) VALUES(10); 1954INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 1955SELECT t1.c1,t2.c1 FROM t1 STRAIGHT_JOIN t2 ON t1.c1 = t2.c1; 1956c1 c1 19570 0 19581 1 19592 2 19603 3 19614 4 19625 5 19636 6 19647 7 19658 8 19669 9 1967SELECT t1.c1,t2.c1 FROM t1 STRAIGHT_JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 >= 5; 1968c1 c1 19695 5 19706 6 19717 7 19728 8 19739 9 1974DROP TABLE t1,t2,t3,t4,t5,t6; 1975CREATE TABLE t1 (c1 BIGINT NOT NULL); 1976CREATE TABLE t2 (c1 BIGINT NOT NULL); 1977CREATE TABLE t3 (c1 BIGINT NOT NULL); 1978CREATE TABLE t4 (c1 BIGINT NOT NULL); 1979CREATE TABLE t5 (c1 BIGINT NOT NULL); 1980CREATE TABLE t6 (c1 BIGINT NOT NULL); 1981INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1982INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1983INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 1984INSERT INTO t4 (c1) VALUES(10); 1985INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 1986SELECT t1.c1,t2.c1 FROM t1 STRAIGHT_JOIN t2 ON t1.c1 = t2.c1; 1987c1 c1 19880 0 19891 1 19902 2 19913 3 19924 4 19935 5 19946 6 19957 7 19968 8 19979 9 1998SELECT t1.c1,t2.c1 FROM t1 STRAIGHT_JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 >= 5; 1999c1 c1 20005 5 20016 6 20027 7 20038 8 20049 9 2005DROP TABLE t1,t2,t3,t4,t5,t6; 2006CREATE TABLE t1 (c1 TINYINT NOT NULL); 2007CREATE TABLE t2 (c1 TINYINT NOT NULL); 2008CREATE TABLE t3 (c1 TINYINT NOT NULL); 2009CREATE TABLE t4 (c1 TINYINT NOT NULL); 2010CREATE TABLE t5 (c1 TINYINT NOT NULL); 2011CREATE TABLE t6 (c1 TINYINT NOT NULL); 2012INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2013INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2014INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 2015INSERT INTO t4 (c1) VALUES(10); 2016INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 2017SELECT t1.c1,t3.c1 FROM t1 STRAIGHT_JOIN t3 ON t1.c1 = t3.c1; 2018c1 c1 20191 1 20203 3 20215 5 20227 7 20239 9 2024SELECT t1.c1,t3.c1 FROM t1 STRAIGHT_JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 >= 5; 2025c1 c1 20265 5 20277 7 20289 9 2029DROP TABLE t1,t2,t3,t4,t5,t6; 2030CREATE TABLE t1 (c1 SMALLINT NOT NULL); 2031CREATE TABLE t2 (c1 SMALLINT NOT NULL); 2032CREATE TABLE t3 (c1 SMALLINT NOT NULL); 2033CREATE TABLE t4 (c1 SMALLINT NOT NULL); 2034CREATE TABLE t5 (c1 SMALLINT NOT NULL); 2035CREATE TABLE t6 (c1 SMALLINT NOT NULL); 2036INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2037INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2038INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 2039INSERT INTO t4 (c1) VALUES(10); 2040INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 2041SELECT t1.c1,t3.c1 FROM t1 STRAIGHT_JOIN t3 ON t1.c1 = t3.c1; 2042c1 c1 20431 1 20443 3 20455 5 20467 7 20479 9 2048SELECT t1.c1,t3.c1 FROM t1 STRAIGHT_JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 >= 5; 2049c1 c1 20505 5 20517 7 20529 9 2053DROP TABLE t1,t2,t3,t4,t5,t6; 2054CREATE TABLE t1 (c1 MEDIUMINT NOT NULL); 2055CREATE TABLE t2 (c1 MEDIUMINT NOT NULL); 2056CREATE TABLE t3 (c1 MEDIUMINT NOT NULL); 2057CREATE TABLE t4 (c1 MEDIUMINT NOT NULL); 2058CREATE TABLE t5 (c1 MEDIUMINT NOT NULL); 2059CREATE TABLE t6 (c1 MEDIUMINT NOT NULL); 2060INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2061INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2062INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 2063INSERT INTO t4 (c1) VALUES(10); 2064INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 2065SELECT t1.c1,t3.c1 FROM t1 STRAIGHT_JOIN t3 ON t1.c1 = t3.c1; 2066c1 c1 20671 1 20683 3 20695 5 20707 7 20719 9 2072SELECT t1.c1,t3.c1 FROM t1 STRAIGHT_JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 >= 5; 2073c1 c1 20745 5 20757 7 20769 9 2077DROP TABLE t1,t2,t3,t4,t5,t6; 2078CREATE TABLE t1 (c1 INT NOT NULL); 2079CREATE TABLE t2 (c1 INT NOT NULL); 2080CREATE TABLE t3 (c1 INT NOT NULL); 2081CREATE TABLE t4 (c1 INT NOT NULL); 2082CREATE TABLE t5 (c1 INT NOT NULL); 2083CREATE TABLE t6 (c1 INT NOT NULL); 2084INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2085INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2086INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 2087INSERT INTO t4 (c1) VALUES(10); 2088INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 2089SELECT t1.c1,t3.c1 FROM t1 STRAIGHT_JOIN t3 ON t1.c1 = t3.c1; 2090c1 c1 20911 1 20923 3 20935 5 20947 7 20959 9 2096SELECT t1.c1,t3.c1 FROM t1 STRAIGHT_JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 >= 5; 2097c1 c1 20985 5 20997 7 21009 9 2101DROP TABLE t1,t2,t3,t4,t5,t6; 2102CREATE TABLE t1 (c1 INTEGER NOT NULL); 2103CREATE TABLE t2 (c1 INTEGER NOT NULL); 2104CREATE TABLE t3 (c1 INTEGER NOT NULL); 2105CREATE TABLE t4 (c1 INTEGER NOT NULL); 2106CREATE TABLE t5 (c1 INTEGER NOT NULL); 2107CREATE TABLE t6 (c1 INTEGER NOT NULL); 2108INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2109INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2110INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 2111INSERT INTO t4 (c1) VALUES(10); 2112INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 2113SELECT t1.c1,t3.c1 FROM t1 STRAIGHT_JOIN t3 ON t1.c1 = t3.c1; 2114c1 c1 21151 1 21163 3 21175 5 21187 7 21199 9 2120SELECT t1.c1,t3.c1 FROM t1 STRAIGHT_JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 >= 5; 2121c1 c1 21225 5 21237 7 21249 9 2125DROP TABLE t1,t2,t3,t4,t5,t6; 2126CREATE TABLE t1 (c1 BIGINT NOT NULL); 2127CREATE TABLE t2 (c1 BIGINT NOT NULL); 2128CREATE TABLE t3 (c1 BIGINT NOT NULL); 2129CREATE TABLE t4 (c1 BIGINT NOT NULL); 2130CREATE TABLE t5 (c1 BIGINT NOT NULL); 2131CREATE TABLE t6 (c1 BIGINT 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,t3.c1 FROM t1 STRAIGHT_JOIN t3 ON t1.c1 = t3.c1; 2138c1 c1 21391 1 21403 3 21415 5 21427 7 21439 9 2144SELECT t1.c1,t3.c1 FROM t1 STRAIGHT_JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 >= 5; 2145c1 c1 21465 5 21477 7 21489 9 2149DROP TABLE t1,t2,t3,t4,t5,t6; 2150CREATE TABLE t1 (c1 TINYINT NOT NULL); 2151CREATE TABLE t2 (c1 TINYINT NOT NULL); 2152CREATE TABLE t3 (c1 TINYINT NOT NULL); 2153CREATE TABLE t4 (c1 TINYINT NOT NULL); 2154CREATE TABLE t5 (c1 TINYINT NOT NULL); 2155CREATE TABLE t6 (c1 TINYINT NOT NULL); 2156INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2157INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2158INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 2159INSERT INTO t4 (c1) VALUES(10); 2160INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 2161SELECT t1.c1,t4.c1 FROM t1 STRAIGHT_JOIN t4 ON t1.c1 = t4.c1; 2162c1 c1 2163SELECT t1.c1,t4.c1 FROM t1 STRAIGHT_JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 >= 5; 2164c1 c1 2165DROP TABLE t1,t2,t3,t4,t5,t6; 2166CREATE TABLE t1 (c1 SMALLINT NOT NULL); 2167CREATE TABLE t2 (c1 SMALLINT NOT NULL); 2168CREATE TABLE t3 (c1 SMALLINT NOT NULL); 2169CREATE TABLE t4 (c1 SMALLINT NOT NULL); 2170CREATE TABLE t5 (c1 SMALLINT NOT NULL); 2171CREATE TABLE t6 (c1 SMALLINT NOT NULL); 2172INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2173INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2174INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 2175INSERT INTO t4 (c1) VALUES(10); 2176INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 2177SELECT t1.c1,t4.c1 FROM t1 STRAIGHT_JOIN t4 ON t1.c1 = t4.c1; 2178c1 c1 2179SELECT t1.c1,t4.c1 FROM t1 STRAIGHT_JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 >= 5; 2180c1 c1 2181DROP TABLE t1,t2,t3,t4,t5,t6; 2182CREATE TABLE t1 (c1 MEDIUMINT NOT NULL); 2183CREATE TABLE t2 (c1 MEDIUMINT NOT NULL); 2184CREATE TABLE t3 (c1 MEDIUMINT NOT NULL); 2185CREATE TABLE t4 (c1 MEDIUMINT NOT NULL); 2186CREATE TABLE t5 (c1 MEDIUMINT NOT NULL); 2187CREATE TABLE t6 (c1 MEDIUMINT NOT NULL); 2188INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2189INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2190INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 2191INSERT INTO t4 (c1) VALUES(10); 2192INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 2193SELECT t1.c1,t4.c1 FROM t1 STRAIGHT_JOIN t4 ON t1.c1 = t4.c1; 2194c1 c1 2195SELECT t1.c1,t4.c1 FROM t1 STRAIGHT_JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 >= 5; 2196c1 c1 2197DROP TABLE t1,t2,t3,t4,t5,t6; 2198CREATE TABLE t1 (c1 INT NOT NULL); 2199CREATE TABLE t2 (c1 INT NOT NULL); 2200CREATE TABLE t3 (c1 INT NOT NULL); 2201CREATE TABLE t4 (c1 INT NOT NULL); 2202CREATE TABLE t5 (c1 INT NOT NULL); 2203CREATE TABLE t6 (c1 INT 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,t4.c1 FROM t1 STRAIGHT_JOIN t4 ON t1.c1 = t4.c1; 2210c1 c1 2211SELECT t1.c1,t4.c1 FROM t1 STRAIGHT_JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 >= 5; 2212c1 c1 2213DROP TABLE t1,t2,t3,t4,t5,t6; 2214CREATE TABLE t1 (c1 INTEGER NOT NULL); 2215CREATE TABLE t2 (c1 INTEGER NOT NULL); 2216CREATE TABLE t3 (c1 INTEGER NOT NULL); 2217CREATE TABLE t4 (c1 INTEGER NOT NULL); 2218CREATE TABLE t5 (c1 INTEGER NOT NULL); 2219CREATE TABLE t6 (c1 INTEGER NOT NULL); 2220INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2221INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2222INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 2223INSERT INTO t4 (c1) VALUES(10); 2224INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 2225SELECT t1.c1,t4.c1 FROM t1 STRAIGHT_JOIN t4 ON t1.c1 = t4.c1; 2226c1 c1 2227SELECT t1.c1,t4.c1 FROM t1 STRAIGHT_JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 >= 5; 2228c1 c1 2229DROP TABLE t1,t2,t3,t4,t5,t6; 2230CREATE TABLE t1 (c1 BIGINT NOT NULL); 2231CREATE TABLE t2 (c1 BIGINT NOT NULL); 2232CREATE TABLE t3 (c1 BIGINT NOT NULL); 2233CREATE TABLE t4 (c1 BIGINT NOT NULL); 2234CREATE TABLE t5 (c1 BIGINT NOT NULL); 2235CREATE TABLE t6 (c1 BIGINT NOT NULL); 2236INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2237INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2238INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 2239INSERT INTO t4 (c1) VALUES(10); 2240INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 2241SELECT t1.c1,t4.c1 FROM t1 STRAIGHT_JOIN t4 ON t1.c1 = t4.c1; 2242c1 c1 2243SELECT t1.c1,t4.c1 FROM t1 STRAIGHT_JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 >= 5; 2244c1 c1 2245DROP TABLE t1,t2,t3,t4,t5,t6; 2246CREATE TABLE t1 (c1 TINYINT NOT NULL); 2247CREATE TABLE t2 (c1 TINYINT NOT NULL); 2248CREATE TABLE t3 (c1 TINYINT NOT NULL); 2249CREATE TABLE t4 (c1 TINYINT NOT NULL); 2250CREATE TABLE t5 (c1 TINYINT NOT NULL); 2251CREATE TABLE t6 (c1 TINYINT NOT NULL); 2252INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2253INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2254INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 2255INSERT INTO t4 (c1) VALUES(10); 2256INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 2257SELECT t1.c1,t5.c1 FROM t1 STRAIGHT_JOIN t5 ON t1.c1 = t5.c1; 2258c1 c1 2259SELECT t1.c1,t5.c1 FROM t1 STRAIGHT_JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 >= 5; 2260c1 c1 2261DROP TABLE t1,t2,t3,t4,t5,t6; 2262CREATE TABLE t1 (c1 SMALLINT NOT NULL); 2263CREATE TABLE t2 (c1 SMALLINT NOT NULL); 2264CREATE TABLE t3 (c1 SMALLINT NOT NULL); 2265CREATE TABLE t4 (c1 SMALLINT NOT NULL); 2266CREATE TABLE t5 (c1 SMALLINT NOT NULL); 2267CREATE TABLE t6 (c1 SMALLINT NOT NULL); 2268INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2269INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2270INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 2271INSERT INTO t4 (c1) VALUES(10); 2272INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 2273SELECT t1.c1,t5.c1 FROM t1 STRAIGHT_JOIN t5 ON t1.c1 = t5.c1; 2274c1 c1 2275SELECT t1.c1,t5.c1 FROM t1 STRAIGHT_JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 >= 5; 2276c1 c1 2277DROP TABLE t1,t2,t3,t4,t5,t6; 2278CREATE TABLE t1 (c1 MEDIUMINT NOT NULL); 2279CREATE TABLE t2 (c1 MEDIUMINT NOT NULL); 2280CREATE TABLE t3 (c1 MEDIUMINT NOT NULL); 2281CREATE TABLE t4 (c1 MEDIUMINT NOT NULL); 2282CREATE TABLE t5 (c1 MEDIUMINT NOT NULL); 2283CREATE TABLE t6 (c1 MEDIUMINT NOT NULL); 2284INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2285INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2286INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 2287INSERT INTO t4 (c1) VALUES(10); 2288INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 2289SELECT t1.c1,t5.c1 FROM t1 STRAIGHT_JOIN t5 ON t1.c1 = t5.c1; 2290c1 c1 2291SELECT t1.c1,t5.c1 FROM t1 STRAIGHT_JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 >= 5; 2292c1 c1 2293DROP TABLE t1,t2,t3,t4,t5,t6; 2294CREATE TABLE t1 (c1 INT NOT NULL); 2295CREATE TABLE t2 (c1 INT NOT NULL); 2296CREATE TABLE t3 (c1 INT NOT NULL); 2297CREATE TABLE t4 (c1 INT NOT NULL); 2298CREATE TABLE t5 (c1 INT NOT NULL); 2299CREATE TABLE t6 (c1 INT NOT NULL); 2300INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2301INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2302INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 2303INSERT INTO t4 (c1) VALUES(10); 2304INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 2305SELECT t1.c1,t5.c1 FROM t1 STRAIGHT_JOIN t5 ON t1.c1 = t5.c1; 2306c1 c1 2307SELECT t1.c1,t5.c1 FROM t1 STRAIGHT_JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 >= 5; 2308c1 c1 2309DROP TABLE t1,t2,t3,t4,t5,t6; 2310CREATE TABLE t1 (c1 INTEGER NOT NULL); 2311CREATE TABLE t2 (c1 INTEGER NOT NULL); 2312CREATE TABLE t3 (c1 INTEGER NOT NULL); 2313CREATE TABLE t4 (c1 INTEGER NOT NULL); 2314CREATE TABLE t5 (c1 INTEGER NOT NULL); 2315CREATE TABLE t6 (c1 INTEGER NOT NULL); 2316INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2317INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2318INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 2319INSERT INTO t4 (c1) VALUES(10); 2320INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 2321SELECT t1.c1,t5.c1 FROM t1 STRAIGHT_JOIN t5 ON t1.c1 = t5.c1; 2322c1 c1 2323SELECT t1.c1,t5.c1 FROM t1 STRAIGHT_JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 >= 5; 2324c1 c1 2325DROP TABLE t1,t2,t3,t4,t5,t6; 2326CREATE TABLE t1 (c1 BIGINT NOT NULL); 2327CREATE TABLE t2 (c1 BIGINT NOT NULL); 2328CREATE TABLE t3 (c1 BIGINT NOT NULL); 2329CREATE TABLE t4 (c1 BIGINT NOT NULL); 2330CREATE TABLE t5 (c1 BIGINT NOT NULL); 2331CREATE TABLE t6 (c1 BIGINT NOT NULL); 2332INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2333INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2334INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 2335INSERT INTO t4 (c1) VALUES(10); 2336INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 2337SELECT t1.c1,t5.c1 FROM t1 STRAIGHT_JOIN t5 ON t1.c1 = t5.c1; 2338c1 c1 2339SELECT t1.c1,t5.c1 FROM t1 STRAIGHT_JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 >= 5; 2340c1 c1 2341DROP TABLE t1,t2,t3,t4,t5,t6; 2342CREATE TABLE t1 (c1 TINYINT NOT NULL); 2343CREATE TABLE t2 (c1 TINYINT NOT NULL); 2344CREATE TABLE t3 (c1 TINYINT NOT NULL); 2345CREATE TABLE t4 (c1 TINYINT NOT NULL); 2346CREATE TABLE t5 (c1 TINYINT NOT NULL); 2347CREATE TABLE t6 (c1 TINYINT NOT NULL); 2348INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2349INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2350INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 2351INSERT INTO t4 (c1) VALUES(10); 2352INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 2353SELECT t1.c1,t6.c1 FROM t1 STRAIGHT_JOIN t6 ON t1.c1 = t6.c1; 2354c1 c1 2355SELECT t1.c1,t6.c1 FROM t1 STRAIGHT_JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 >= 5; 2356c1 c1 2357DROP TABLE t1,t2,t3,t4,t5,t6; 2358CREATE TABLE t1 (c1 SMALLINT NOT NULL); 2359CREATE TABLE t2 (c1 SMALLINT NOT NULL); 2360CREATE TABLE t3 (c1 SMALLINT NOT NULL); 2361CREATE TABLE t4 (c1 SMALLINT NOT NULL); 2362CREATE TABLE t5 (c1 SMALLINT NOT NULL); 2363CREATE TABLE t6 (c1 SMALLINT NOT NULL); 2364INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2365INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2366INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 2367INSERT INTO t4 (c1) VALUES(10); 2368INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 2369SELECT t1.c1,t6.c1 FROM t1 STRAIGHT_JOIN t6 ON t1.c1 = t6.c1; 2370c1 c1 2371SELECT t1.c1,t6.c1 FROM t1 STRAIGHT_JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 >= 5; 2372c1 c1 2373DROP TABLE t1,t2,t3,t4,t5,t6; 2374CREATE TABLE t1 (c1 MEDIUMINT NOT NULL); 2375CREATE TABLE t2 (c1 MEDIUMINT NOT NULL); 2376CREATE TABLE t3 (c1 MEDIUMINT NOT NULL); 2377CREATE TABLE t4 (c1 MEDIUMINT NOT NULL); 2378CREATE TABLE t5 (c1 MEDIUMINT NOT NULL); 2379CREATE TABLE t6 (c1 MEDIUMINT NOT NULL); 2380INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2381INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2382INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 2383INSERT INTO t4 (c1) VALUES(10); 2384INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 2385SELECT t1.c1,t6.c1 FROM t1 STRAIGHT_JOIN t6 ON t1.c1 = t6.c1; 2386c1 c1 2387SELECT t1.c1,t6.c1 FROM t1 STRAIGHT_JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 >= 5; 2388c1 c1 2389DROP TABLE t1,t2,t3,t4,t5,t6; 2390CREATE TABLE t1 (c1 INT NOT NULL); 2391CREATE TABLE t2 (c1 INT NOT NULL); 2392CREATE TABLE t3 (c1 INT NOT NULL); 2393CREATE TABLE t4 (c1 INT NOT NULL); 2394CREATE TABLE t5 (c1 INT NOT NULL); 2395CREATE TABLE t6 (c1 INT NOT NULL); 2396INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2397INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2398INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 2399INSERT INTO t4 (c1) VALUES(10); 2400INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 2401SELECT t1.c1,t6.c1 FROM t1 STRAIGHT_JOIN t6 ON t1.c1 = t6.c1; 2402c1 c1 2403SELECT t1.c1,t6.c1 FROM t1 STRAIGHT_JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 >= 5; 2404c1 c1 2405DROP TABLE t1,t2,t3,t4,t5,t6; 2406CREATE TABLE t1 (c1 INTEGER NOT NULL); 2407CREATE TABLE t2 (c1 INTEGER NOT NULL); 2408CREATE TABLE t3 (c1 INTEGER NOT NULL); 2409CREATE TABLE t4 (c1 INTEGER NOT NULL); 2410CREATE TABLE t5 (c1 INTEGER NOT NULL); 2411CREATE TABLE t6 (c1 INTEGER NOT NULL); 2412INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2413INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2414INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 2415INSERT INTO t4 (c1) VALUES(10); 2416INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 2417SELECT t1.c1,t6.c1 FROM t1 STRAIGHT_JOIN t6 ON t1.c1 = t6.c1; 2418c1 c1 2419SELECT t1.c1,t6.c1 FROM t1 STRAIGHT_JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 >= 5; 2420c1 c1 2421DROP TABLE t1,t2,t3,t4,t5,t6; 2422CREATE TABLE t1 (c1 BIGINT NOT NULL); 2423CREATE TABLE t2 (c1 BIGINT NOT NULL); 2424CREATE TABLE t3 (c1 BIGINT NOT NULL); 2425CREATE TABLE t4 (c1 BIGINT NOT NULL); 2426CREATE TABLE t5 (c1 BIGINT NOT NULL); 2427CREATE TABLE t6 (c1 BIGINT NOT NULL); 2428INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2429INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2430INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 2431INSERT INTO t4 (c1) VALUES(10); 2432INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 2433SELECT t1.c1,t6.c1 FROM t1 STRAIGHT_JOIN t6 ON t1.c1 = t6.c1; 2434c1 c1 2435SELECT t1.c1,t6.c1 FROM t1 STRAIGHT_JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 >= 5; 2436c1 c1 2437DROP TABLE t1,t2,t3,t4,t5,t6; 2438CREATE TABLE t1 (c1 TINYINT NOT NULL); 2439CREATE TABLE t2 (c1 TINYINT NOT NULL); 2440CREATE TABLE t3 (c1 TINYINT NOT NULL); 2441CREATE TABLE t4 (c1 TINYINT NOT NULL); 2442CREATE TABLE t5 (c1 TINYINT NOT NULL); 2443CREATE TABLE t6 (c1 TINYINT NOT NULL); 2444INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2445INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2446INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 2447INSERT INTO t4 (c1) VALUES(10); 2448INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 2449SELECT t1.c1,t2.c1 FROM t1 STRAIGHT_JOIN t2 ON t1.c1 = t2.c1; 2450c1 c1 24510 0 24521 1 24532 2 24543 3 24554 4 24565 5 24576 6 24587 7 24598 8 24609 9 2461SELECT t1.c1,t2.c1 FROM t1 STRAIGHT_JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 != 5; 2462c1 c1 24630 0 24641 1 24652 2 24663 3 24674 4 24686 6 24697 7 24708 8 24719 9 2472DROP TABLE t1,t2,t3,t4,t5,t6; 2473CREATE TABLE t1 (c1 SMALLINT NOT NULL); 2474CREATE TABLE t2 (c1 SMALLINT NOT NULL); 2475CREATE TABLE t3 (c1 SMALLINT NOT NULL); 2476CREATE TABLE t4 (c1 SMALLINT NOT NULL); 2477CREATE TABLE t5 (c1 SMALLINT NOT NULL); 2478CREATE TABLE t6 (c1 SMALLINT NOT NULL); 2479INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2480INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2481INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 2482INSERT INTO t4 (c1) VALUES(10); 2483INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 2484SELECT t1.c1,t2.c1 FROM t1 STRAIGHT_JOIN t2 ON t1.c1 = t2.c1; 2485c1 c1 24860 0 24871 1 24882 2 24893 3 24904 4 24915 5 24926 6 24937 7 24948 8 24959 9 2496SELECT t1.c1,t2.c1 FROM t1 STRAIGHT_JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 != 5; 2497c1 c1 24980 0 24991 1 25002 2 25013 3 25024 4 25036 6 25047 7 25058 8 25069 9 2507DROP TABLE t1,t2,t3,t4,t5,t6; 2508CREATE TABLE t1 (c1 MEDIUMINT NOT NULL); 2509CREATE TABLE t2 (c1 MEDIUMINT NOT NULL); 2510CREATE TABLE t3 (c1 MEDIUMINT NOT NULL); 2511CREATE TABLE t4 (c1 MEDIUMINT NOT NULL); 2512CREATE TABLE t5 (c1 MEDIUMINT NOT NULL); 2513CREATE TABLE t6 (c1 MEDIUMINT NOT NULL); 2514INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2515INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2516INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 2517INSERT INTO t4 (c1) VALUES(10); 2518INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 2519SELECT t1.c1,t2.c1 FROM t1 STRAIGHT_JOIN t2 ON t1.c1 = t2.c1; 2520c1 c1 25210 0 25221 1 25232 2 25243 3 25254 4 25265 5 25276 6 25287 7 25298 8 25309 9 2531SELECT t1.c1,t2.c1 FROM t1 STRAIGHT_JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 != 5; 2532c1 c1 25330 0 25341 1 25352 2 25363 3 25374 4 25386 6 25397 7 25408 8 25419 9 2542DROP TABLE t1,t2,t3,t4,t5,t6; 2543CREATE TABLE t1 (c1 INT NOT NULL); 2544CREATE TABLE t2 (c1 INT NOT NULL); 2545CREATE TABLE t3 (c1 INT NOT NULL); 2546CREATE TABLE t4 (c1 INT NOT NULL); 2547CREATE TABLE t5 (c1 INT NOT NULL); 2548CREATE TABLE t6 (c1 INT NOT NULL); 2549INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2550INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2551INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 2552INSERT INTO t4 (c1) VALUES(10); 2553INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 2554SELECT t1.c1,t2.c1 FROM t1 STRAIGHT_JOIN t2 ON t1.c1 = t2.c1; 2555c1 c1 25560 0 25571 1 25582 2 25593 3 25604 4 25615 5 25626 6 25637 7 25648 8 25659 9 2566SELECT t1.c1,t2.c1 FROM t1 STRAIGHT_JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 != 5; 2567c1 c1 25680 0 25691 1 25702 2 25713 3 25724 4 25736 6 25747 7 25758 8 25769 9 2577DROP TABLE t1,t2,t3,t4,t5,t6; 2578CREATE TABLE t1 (c1 INTEGER NOT NULL); 2579CREATE TABLE t2 (c1 INTEGER NOT NULL); 2580CREATE TABLE t3 (c1 INTEGER NOT NULL); 2581CREATE TABLE t4 (c1 INTEGER NOT NULL); 2582CREATE TABLE t5 (c1 INTEGER NOT NULL); 2583CREATE TABLE t6 (c1 INTEGER NOT NULL); 2584INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2585INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2586INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 2587INSERT INTO t4 (c1) VALUES(10); 2588INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 2589SELECT t1.c1,t2.c1 FROM t1 STRAIGHT_JOIN t2 ON t1.c1 = t2.c1; 2590c1 c1 25910 0 25921 1 25932 2 25943 3 25954 4 25965 5 25976 6 25987 7 25998 8 26009 9 2601SELECT t1.c1,t2.c1 FROM t1 STRAIGHT_JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 != 5; 2602c1 c1 26030 0 26041 1 26052 2 26063 3 26074 4 26086 6 26097 7 26108 8 26119 9 2612DROP TABLE t1,t2,t3,t4,t5,t6; 2613CREATE TABLE t1 (c1 BIGINT NOT NULL); 2614CREATE TABLE t2 (c1 BIGINT NOT NULL); 2615CREATE TABLE t3 (c1 BIGINT NOT NULL); 2616CREATE TABLE t4 (c1 BIGINT NOT NULL); 2617CREATE TABLE t5 (c1 BIGINT NOT NULL); 2618CREATE TABLE t6 (c1 BIGINT NOT NULL); 2619INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2620INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2621INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 2622INSERT INTO t4 (c1) VALUES(10); 2623INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 2624SELECT t1.c1,t2.c1 FROM t1 STRAIGHT_JOIN t2 ON t1.c1 = t2.c1; 2625c1 c1 26260 0 26271 1 26282 2 26293 3 26304 4 26315 5 26326 6 26337 7 26348 8 26359 9 2636SELECT t1.c1,t2.c1 FROM t1 STRAIGHT_JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 != 5; 2637c1 c1 26380 0 26391 1 26402 2 26413 3 26424 4 26436 6 26447 7 26458 8 26469 9 2647DROP TABLE t1,t2,t3,t4,t5,t6; 2648CREATE TABLE t1 (c1 TINYINT NOT NULL); 2649CREATE TABLE t2 (c1 TINYINT NOT NULL); 2650CREATE TABLE t3 (c1 TINYINT NOT NULL); 2651CREATE TABLE t4 (c1 TINYINT NOT NULL); 2652CREATE TABLE t5 (c1 TINYINT NOT NULL); 2653CREATE TABLE t6 (c1 TINYINT NOT NULL); 2654INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2655INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2656INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 2657INSERT INTO t4 (c1) VALUES(10); 2658INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 2659SELECT t1.c1,t3.c1 FROM t1 STRAIGHT_JOIN t3 ON t1.c1 = t3.c1; 2660c1 c1 26611 1 26623 3 26635 5 26647 7 26659 9 2666SELECT t1.c1,t3.c1 FROM t1 STRAIGHT_JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 != 5; 2667c1 c1 26681 1 26693 3 26707 7 26719 9 2672DROP TABLE t1,t2,t3,t4,t5,t6; 2673CREATE TABLE t1 (c1 SMALLINT NOT NULL); 2674CREATE TABLE t2 (c1 SMALLINT NOT NULL); 2675CREATE TABLE t3 (c1 SMALLINT NOT NULL); 2676CREATE TABLE t4 (c1 SMALLINT NOT NULL); 2677CREATE TABLE t5 (c1 SMALLINT NOT NULL); 2678CREATE TABLE t6 (c1 SMALLINT NOT NULL); 2679INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2680INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2681INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 2682INSERT INTO t4 (c1) VALUES(10); 2683INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 2684SELECT t1.c1,t3.c1 FROM t1 STRAIGHT_JOIN t3 ON t1.c1 = t3.c1; 2685c1 c1 26861 1 26873 3 26885 5 26897 7 26909 9 2691SELECT t1.c1,t3.c1 FROM t1 STRAIGHT_JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 != 5; 2692c1 c1 26931 1 26943 3 26957 7 26969 9 2697DROP TABLE t1,t2,t3,t4,t5,t6; 2698CREATE TABLE t1 (c1 MEDIUMINT NOT NULL); 2699CREATE TABLE t2 (c1 MEDIUMINT NOT NULL); 2700CREATE TABLE t3 (c1 MEDIUMINT NOT NULL); 2701CREATE TABLE t4 (c1 MEDIUMINT NOT NULL); 2702CREATE TABLE t5 (c1 MEDIUMINT NOT NULL); 2703CREATE TABLE t6 (c1 MEDIUMINT NOT NULL); 2704INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2705INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2706INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 2707INSERT INTO t4 (c1) VALUES(10); 2708INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 2709SELECT t1.c1,t3.c1 FROM t1 STRAIGHT_JOIN t3 ON t1.c1 = t3.c1; 2710c1 c1 27111 1 27123 3 27135 5 27147 7 27159 9 2716SELECT t1.c1,t3.c1 FROM t1 STRAIGHT_JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 != 5; 2717c1 c1 27181 1 27193 3 27207 7 27219 9 2722DROP TABLE t1,t2,t3,t4,t5,t6; 2723CREATE TABLE t1 (c1 INT NOT NULL); 2724CREATE TABLE t2 (c1 INT NOT NULL); 2725CREATE TABLE t3 (c1 INT NOT NULL); 2726CREATE TABLE t4 (c1 INT NOT NULL); 2727CREATE TABLE t5 (c1 INT NOT NULL); 2728CREATE TABLE t6 (c1 INT NOT NULL); 2729INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2730INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2731INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 2732INSERT INTO t4 (c1) VALUES(10); 2733INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 2734SELECT t1.c1,t3.c1 FROM t1 STRAIGHT_JOIN t3 ON t1.c1 = t3.c1; 2735c1 c1 27361 1 27373 3 27385 5 27397 7 27409 9 2741SELECT t1.c1,t3.c1 FROM t1 STRAIGHT_JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 != 5; 2742c1 c1 27431 1 27443 3 27457 7 27469 9 2747DROP TABLE t1,t2,t3,t4,t5,t6; 2748CREATE TABLE t1 (c1 INTEGER NOT NULL); 2749CREATE TABLE t2 (c1 INTEGER NOT NULL); 2750CREATE TABLE t3 (c1 INTEGER NOT NULL); 2751CREATE TABLE t4 (c1 INTEGER NOT NULL); 2752CREATE TABLE t5 (c1 INTEGER NOT NULL); 2753CREATE TABLE t6 (c1 INTEGER NOT NULL); 2754INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2755INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2756INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 2757INSERT INTO t4 (c1) VALUES(10); 2758INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 2759SELECT t1.c1,t3.c1 FROM t1 STRAIGHT_JOIN t3 ON t1.c1 = t3.c1; 2760c1 c1 27611 1 27623 3 27635 5 27647 7 27659 9 2766SELECT t1.c1,t3.c1 FROM t1 STRAIGHT_JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 != 5; 2767c1 c1 27681 1 27693 3 27707 7 27719 9 2772DROP TABLE t1,t2,t3,t4,t5,t6; 2773CREATE TABLE t1 (c1 BIGINT NOT NULL); 2774CREATE TABLE t2 (c1 BIGINT NOT NULL); 2775CREATE TABLE t3 (c1 BIGINT NOT NULL); 2776CREATE TABLE t4 (c1 BIGINT NOT NULL); 2777CREATE TABLE t5 (c1 BIGINT NOT NULL); 2778CREATE TABLE t6 (c1 BIGINT NOT NULL); 2779INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2780INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2781INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 2782INSERT INTO t4 (c1) VALUES(10); 2783INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 2784SELECT t1.c1,t3.c1 FROM t1 STRAIGHT_JOIN t3 ON t1.c1 = t3.c1; 2785c1 c1 27861 1 27873 3 27885 5 27897 7 27909 9 2791SELECT t1.c1,t3.c1 FROM t1 STRAIGHT_JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 != 5; 2792c1 c1 27931 1 27943 3 27957 7 27969 9 2797DROP TABLE t1,t2,t3,t4,t5,t6; 2798CREATE TABLE t1 (c1 TINYINT NOT NULL); 2799CREATE TABLE t2 (c1 TINYINT NOT NULL); 2800CREATE TABLE t3 (c1 TINYINT NOT NULL); 2801CREATE TABLE t4 (c1 TINYINT NOT NULL); 2802CREATE TABLE t5 (c1 TINYINT NOT NULL); 2803CREATE TABLE t6 (c1 TINYINT NOT NULL); 2804INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2805INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2806INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 2807INSERT INTO t4 (c1) VALUES(10); 2808INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 2809SELECT t1.c1,t4.c1 FROM t1 STRAIGHT_JOIN t4 ON t1.c1 = t4.c1; 2810c1 c1 2811SELECT t1.c1,t4.c1 FROM t1 STRAIGHT_JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 != 5; 2812c1 c1 2813DROP TABLE t1,t2,t3,t4,t5,t6; 2814CREATE TABLE t1 (c1 SMALLINT NOT NULL); 2815CREATE TABLE t2 (c1 SMALLINT NOT NULL); 2816CREATE TABLE t3 (c1 SMALLINT NOT NULL); 2817CREATE TABLE t4 (c1 SMALLINT NOT NULL); 2818CREATE TABLE t5 (c1 SMALLINT NOT NULL); 2819CREATE TABLE t6 (c1 SMALLINT NOT NULL); 2820INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2821INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2822INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 2823INSERT INTO t4 (c1) VALUES(10); 2824INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 2825SELECT t1.c1,t4.c1 FROM t1 STRAIGHT_JOIN t4 ON t1.c1 = t4.c1; 2826c1 c1 2827SELECT t1.c1,t4.c1 FROM t1 STRAIGHT_JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 != 5; 2828c1 c1 2829DROP TABLE t1,t2,t3,t4,t5,t6; 2830CREATE TABLE t1 (c1 MEDIUMINT NOT NULL); 2831CREATE TABLE t2 (c1 MEDIUMINT NOT NULL); 2832CREATE TABLE t3 (c1 MEDIUMINT NOT NULL); 2833CREATE TABLE t4 (c1 MEDIUMINT NOT NULL); 2834CREATE TABLE t5 (c1 MEDIUMINT NOT NULL); 2835CREATE TABLE t6 (c1 MEDIUMINT NOT NULL); 2836INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2837INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2838INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 2839INSERT INTO t4 (c1) VALUES(10); 2840INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 2841SELECT t1.c1,t4.c1 FROM t1 STRAIGHT_JOIN t4 ON t1.c1 = t4.c1; 2842c1 c1 2843SELECT t1.c1,t4.c1 FROM t1 STRAIGHT_JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 != 5; 2844c1 c1 2845DROP TABLE t1,t2,t3,t4,t5,t6; 2846CREATE TABLE t1 (c1 INT NOT NULL); 2847CREATE TABLE t2 (c1 INT NOT NULL); 2848CREATE TABLE t3 (c1 INT NOT NULL); 2849CREATE TABLE t4 (c1 INT NOT NULL); 2850CREATE TABLE t5 (c1 INT NOT NULL); 2851CREATE TABLE t6 (c1 INT NOT NULL); 2852INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2853INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2854INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 2855INSERT INTO t4 (c1) VALUES(10); 2856INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 2857SELECT t1.c1,t4.c1 FROM t1 STRAIGHT_JOIN t4 ON t1.c1 = t4.c1; 2858c1 c1 2859SELECT t1.c1,t4.c1 FROM t1 STRAIGHT_JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 != 5; 2860c1 c1 2861DROP TABLE t1,t2,t3,t4,t5,t6; 2862CREATE TABLE t1 (c1 INTEGER NOT NULL); 2863CREATE TABLE t2 (c1 INTEGER NOT NULL); 2864CREATE TABLE t3 (c1 INTEGER NOT NULL); 2865CREATE TABLE t4 (c1 INTEGER NOT NULL); 2866CREATE TABLE t5 (c1 INTEGER NOT NULL); 2867CREATE TABLE t6 (c1 INTEGER NOT NULL); 2868INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2869INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2870INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 2871INSERT INTO t4 (c1) VALUES(10); 2872INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 2873SELECT t1.c1,t4.c1 FROM t1 STRAIGHT_JOIN t4 ON t1.c1 = t4.c1; 2874c1 c1 2875SELECT t1.c1,t4.c1 FROM t1 STRAIGHT_JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 != 5; 2876c1 c1 2877DROP TABLE t1,t2,t3,t4,t5,t6; 2878CREATE TABLE t1 (c1 BIGINT NOT NULL); 2879CREATE TABLE t2 (c1 BIGINT NOT NULL); 2880CREATE TABLE t3 (c1 BIGINT NOT NULL); 2881CREATE TABLE t4 (c1 BIGINT NOT NULL); 2882CREATE TABLE t5 (c1 BIGINT NOT NULL); 2883CREATE TABLE t6 (c1 BIGINT NOT NULL); 2884INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2885INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2886INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 2887INSERT INTO t4 (c1) VALUES(10); 2888INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 2889SELECT t1.c1,t4.c1 FROM t1 STRAIGHT_JOIN t4 ON t1.c1 = t4.c1; 2890c1 c1 2891SELECT t1.c1,t4.c1 FROM t1 STRAIGHT_JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 != 5; 2892c1 c1 2893DROP TABLE t1,t2,t3,t4,t5,t6; 2894CREATE TABLE t1 (c1 TINYINT NOT NULL); 2895CREATE TABLE t2 (c1 TINYINT NOT NULL); 2896CREATE TABLE t3 (c1 TINYINT NOT NULL); 2897CREATE TABLE t4 (c1 TINYINT NOT NULL); 2898CREATE TABLE t5 (c1 TINYINT NOT NULL); 2899CREATE TABLE t6 (c1 TINYINT 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 STRAIGHT_JOIN t5 ON t1.c1 = t5.c1; 2906c1 c1 2907SELECT t1.c1,t5.c1 FROM t1 STRAIGHT_JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 != 5; 2908c1 c1 2909DROP TABLE t1,t2,t3,t4,t5,t6; 2910CREATE TABLE t1 (c1 SMALLINT NOT NULL); 2911CREATE TABLE t2 (c1 SMALLINT NOT NULL); 2912CREATE TABLE t3 (c1 SMALLINT NOT NULL); 2913CREATE TABLE t4 (c1 SMALLINT NOT NULL); 2914CREATE TABLE t5 (c1 SMALLINT NOT NULL); 2915CREATE TABLE t6 (c1 SMALLINT NOT NULL); 2916INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2917INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2918INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 2919INSERT INTO t4 (c1) VALUES(10); 2920INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 2921SELECT t1.c1,t5.c1 FROM t1 STRAIGHT_JOIN t5 ON t1.c1 = t5.c1; 2922c1 c1 2923SELECT t1.c1,t5.c1 FROM t1 STRAIGHT_JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 != 5; 2924c1 c1 2925DROP TABLE t1,t2,t3,t4,t5,t6; 2926CREATE TABLE t1 (c1 MEDIUMINT NOT NULL); 2927CREATE TABLE t2 (c1 MEDIUMINT NOT NULL); 2928CREATE TABLE t3 (c1 MEDIUMINT NOT NULL); 2929CREATE TABLE t4 (c1 MEDIUMINT NOT NULL); 2930CREATE TABLE t5 (c1 MEDIUMINT NOT NULL); 2931CREATE TABLE t6 (c1 MEDIUMINT NOT NULL); 2932INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2933INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2934INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 2935INSERT INTO t4 (c1) VALUES(10); 2936INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 2937SELECT t1.c1,t5.c1 FROM t1 STRAIGHT_JOIN t5 ON t1.c1 = t5.c1; 2938c1 c1 2939SELECT t1.c1,t5.c1 FROM t1 STRAIGHT_JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 != 5; 2940c1 c1 2941DROP TABLE t1,t2,t3,t4,t5,t6; 2942CREATE TABLE t1 (c1 INT NOT NULL); 2943CREATE TABLE t2 (c1 INT NOT NULL); 2944CREATE TABLE t3 (c1 INT NOT NULL); 2945CREATE TABLE t4 (c1 INT NOT NULL); 2946CREATE TABLE t5 (c1 INT NOT NULL); 2947CREATE TABLE t6 (c1 INT NOT NULL); 2948INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2949INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2950INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 2951INSERT INTO t4 (c1) VALUES(10); 2952INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 2953SELECT t1.c1,t5.c1 FROM t1 STRAIGHT_JOIN t5 ON t1.c1 = t5.c1; 2954c1 c1 2955SELECT t1.c1,t5.c1 FROM t1 STRAIGHT_JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 != 5; 2956c1 c1 2957DROP TABLE t1,t2,t3,t4,t5,t6; 2958CREATE TABLE t1 (c1 INTEGER NOT NULL); 2959CREATE TABLE t2 (c1 INTEGER NOT NULL); 2960CREATE TABLE t3 (c1 INTEGER NOT NULL); 2961CREATE TABLE t4 (c1 INTEGER NOT NULL); 2962CREATE TABLE t5 (c1 INTEGER NOT NULL); 2963CREATE TABLE t6 (c1 INTEGER NOT NULL); 2964INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2965INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2966INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 2967INSERT INTO t4 (c1) VALUES(10); 2968INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 2969SELECT t1.c1,t5.c1 FROM t1 STRAIGHT_JOIN t5 ON t1.c1 = t5.c1; 2970c1 c1 2971SELECT t1.c1,t5.c1 FROM t1 STRAIGHT_JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 != 5; 2972c1 c1 2973DROP TABLE t1,t2,t3,t4,t5,t6; 2974CREATE TABLE t1 (c1 BIGINT NOT NULL); 2975CREATE TABLE t2 (c1 BIGINT NOT NULL); 2976CREATE TABLE t3 (c1 BIGINT NOT NULL); 2977CREATE TABLE t4 (c1 BIGINT NOT NULL); 2978CREATE TABLE t5 (c1 BIGINT NOT NULL); 2979CREATE TABLE t6 (c1 BIGINT NOT NULL); 2980INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2981INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2982INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 2983INSERT INTO t4 (c1) VALUES(10); 2984INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 2985SELECT t1.c1,t5.c1 FROM t1 STRAIGHT_JOIN t5 ON t1.c1 = t5.c1; 2986c1 c1 2987SELECT t1.c1,t5.c1 FROM t1 STRAIGHT_JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 != 5; 2988c1 c1 2989DROP TABLE t1,t2,t3,t4,t5,t6; 2990CREATE TABLE t1 (c1 TINYINT NOT NULL); 2991CREATE TABLE t2 (c1 TINYINT NOT NULL); 2992CREATE TABLE t3 (c1 TINYINT NOT NULL); 2993CREATE TABLE t4 (c1 TINYINT NOT NULL); 2994CREATE TABLE t5 (c1 TINYINT NOT NULL); 2995CREATE TABLE t6 (c1 TINYINT NOT NULL); 2996INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2997INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2998INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 2999INSERT INTO t4 (c1) VALUES(10); 3000INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 3001SELECT t1.c1,t6.c1 FROM t1 STRAIGHT_JOIN t6 ON t1.c1 = t6.c1; 3002c1 c1 3003SELECT t1.c1,t6.c1 FROM t1 STRAIGHT_JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 != 5; 3004c1 c1 3005DROP TABLE t1,t2,t3,t4,t5,t6; 3006CREATE TABLE t1 (c1 SMALLINT NOT NULL); 3007CREATE TABLE t2 (c1 SMALLINT NOT NULL); 3008CREATE TABLE t3 (c1 SMALLINT NOT NULL); 3009CREATE TABLE t4 (c1 SMALLINT NOT NULL); 3010CREATE TABLE t5 (c1 SMALLINT NOT NULL); 3011CREATE TABLE t6 (c1 SMALLINT NOT NULL); 3012INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3013INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3014INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 3015INSERT INTO t4 (c1) VALUES(10); 3016INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 3017SELECT t1.c1,t6.c1 FROM t1 STRAIGHT_JOIN t6 ON t1.c1 = t6.c1; 3018c1 c1 3019SELECT t1.c1,t6.c1 FROM t1 STRAIGHT_JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 != 5; 3020c1 c1 3021DROP TABLE t1,t2,t3,t4,t5,t6; 3022CREATE TABLE t1 (c1 MEDIUMINT NOT NULL); 3023CREATE TABLE t2 (c1 MEDIUMINT NOT NULL); 3024CREATE TABLE t3 (c1 MEDIUMINT NOT NULL); 3025CREATE TABLE t4 (c1 MEDIUMINT NOT NULL); 3026CREATE TABLE t5 (c1 MEDIUMINT NOT NULL); 3027CREATE TABLE t6 (c1 MEDIUMINT NOT NULL); 3028INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3029INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3030INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 3031INSERT INTO t4 (c1) VALUES(10); 3032INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 3033SELECT t1.c1,t6.c1 FROM t1 STRAIGHT_JOIN t6 ON t1.c1 = t6.c1; 3034c1 c1 3035SELECT t1.c1,t6.c1 FROM t1 STRAIGHT_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 INT NOT NULL); 3039CREATE TABLE t2 (c1 INT NOT NULL); 3040CREATE TABLE t3 (c1 INT NOT NULL); 3041CREATE TABLE t4 (c1 INT NOT NULL); 3042CREATE TABLE t5 (c1 INT NOT NULL); 3043CREATE TABLE t6 (c1 INT 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,t6.c1 FROM t1 STRAIGHT_JOIN t6 ON t1.c1 = t6.c1; 3050c1 c1 3051SELECT t1.c1,t6.c1 FROM t1 STRAIGHT_JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 != 5; 3052c1 c1 3053DROP TABLE t1,t2,t3,t4,t5,t6; 3054CREATE TABLE t1 (c1 INTEGER NOT NULL); 3055CREATE TABLE t2 (c1 INTEGER NOT NULL); 3056CREATE TABLE t3 (c1 INTEGER NOT NULL); 3057CREATE TABLE t4 (c1 INTEGER NOT NULL); 3058CREATE TABLE t5 (c1 INTEGER NOT NULL); 3059CREATE TABLE t6 (c1 INTEGER NOT NULL); 3060INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3061INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3062INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 3063INSERT INTO t4 (c1) VALUES(10); 3064INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 3065SELECT t1.c1,t6.c1 FROM t1 STRAIGHT_JOIN t6 ON t1.c1 = t6.c1; 3066c1 c1 3067SELECT t1.c1,t6.c1 FROM t1 STRAIGHT_JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 != 5; 3068c1 c1 3069DROP TABLE t1,t2,t3,t4,t5,t6; 3070CREATE TABLE t1 (c1 BIGINT NOT NULL); 3071CREATE TABLE t2 (c1 BIGINT NOT NULL); 3072CREATE TABLE t3 (c1 BIGINT NOT NULL); 3073CREATE TABLE t4 (c1 BIGINT NOT NULL); 3074CREATE TABLE t5 (c1 BIGINT NOT NULL); 3075CREATE TABLE t6 (c1 BIGINT NOT NULL); 3076INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3077INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3078INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 3079INSERT INTO t4 (c1) VALUES(10); 3080INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 3081SELECT t1.c1,t6.c1 FROM t1 STRAIGHT_JOIN t6 ON t1.c1 = t6.c1; 3082c1 c1 3083SELECT t1.c1,t6.c1 FROM t1 STRAIGHT_JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 != 5; 3084c1 c1 3085DROP TABLE t1,t2,t3,t4,t5,t6; 3086CREATE TABLE t1 (c1 TINYINT NOT NULL); 3087CREATE TABLE t2 (c1 TINYINT NOT NULL); 3088CREATE TABLE t3 (c1 TINYINT NOT NULL); 3089CREATE TABLE t4 (c1 TINYINT NOT NULL); 3090CREATE TABLE t5 (c1 TINYINT NOT NULL); 3091CREATE TABLE t6 (c1 TINYINT NOT NULL); 3092INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3093INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3094INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 3095INSERT INTO t4 (c1) VALUES(10); 3096INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 3097SELECT t1.c1,t2.c1 FROM t1 STRAIGHT_JOIN t2 ON t1.c1 = t2.c1; 3098c1 c1 30990 0 31001 1 31012 2 31023 3 31034 4 31045 5 31056 6 31067 7 31078 8 31089 9 3109SELECT t1.c1,t2.c1 FROM t1 STRAIGHT_JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 <> 5; 3110c1 c1 31110 0 31121 1 31132 2 31143 3 31154 4 31166 6 31177 7 31188 8 31199 9 3120DROP TABLE t1,t2,t3,t4,t5,t6; 3121CREATE TABLE t1 (c1 SMALLINT NOT NULL); 3122CREATE TABLE t2 (c1 SMALLINT NOT NULL); 3123CREATE TABLE t3 (c1 SMALLINT NOT NULL); 3124CREATE TABLE t4 (c1 SMALLINT NOT NULL); 3125CREATE TABLE t5 (c1 SMALLINT NOT NULL); 3126CREATE TABLE t6 (c1 SMALLINT NOT NULL); 3127INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3128INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3129INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 3130INSERT INTO t4 (c1) VALUES(10); 3131INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 3132SELECT t1.c1,t2.c1 FROM t1 STRAIGHT_JOIN t2 ON t1.c1 = t2.c1; 3133c1 c1 31340 0 31351 1 31362 2 31373 3 31384 4 31395 5 31406 6 31417 7 31428 8 31439 9 3144SELECT t1.c1,t2.c1 FROM t1 STRAIGHT_JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 <> 5; 3145c1 c1 31460 0 31471 1 31482 2 31493 3 31504 4 31516 6 31527 7 31538 8 31549 9 3155DROP TABLE t1,t2,t3,t4,t5,t6; 3156CREATE TABLE t1 (c1 MEDIUMINT NOT NULL); 3157CREATE TABLE t2 (c1 MEDIUMINT NOT NULL); 3158CREATE TABLE t3 (c1 MEDIUMINT NOT NULL); 3159CREATE TABLE t4 (c1 MEDIUMINT NOT NULL); 3160CREATE TABLE t5 (c1 MEDIUMINT NOT NULL); 3161CREATE TABLE t6 (c1 MEDIUMINT NOT NULL); 3162INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3163INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3164INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 3165INSERT INTO t4 (c1) VALUES(10); 3166INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 3167SELECT t1.c1,t2.c1 FROM t1 STRAIGHT_JOIN t2 ON t1.c1 = t2.c1; 3168c1 c1 31690 0 31701 1 31712 2 31723 3 31734 4 31745 5 31756 6 31767 7 31778 8 31789 9 3179SELECT t1.c1,t2.c1 FROM t1 STRAIGHT_JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 <> 5; 3180c1 c1 31810 0 31821 1 31832 2 31843 3 31854 4 31866 6 31877 7 31888 8 31899 9 3190DROP TABLE t1,t2,t3,t4,t5,t6; 3191CREATE TABLE t1 (c1 INT NOT NULL); 3192CREATE TABLE t2 (c1 INT NOT NULL); 3193CREATE TABLE t3 (c1 INT NOT NULL); 3194CREATE TABLE t4 (c1 INT NOT NULL); 3195CREATE TABLE t5 (c1 INT NOT NULL); 3196CREATE TABLE t6 (c1 INT NOT NULL); 3197INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3198INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3199INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 3200INSERT INTO t4 (c1) VALUES(10); 3201INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 3202SELECT t1.c1,t2.c1 FROM t1 STRAIGHT_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 STRAIGHT_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 STRAIGHT_JOIN t2 ON t1.c1 = t2.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 STRAIGHT_JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 <> 5; 3250c1 c1 32510 0 32521 1 32532 2 32543 3 32554 4 32566 6 32577 7 32588 8 32599 9 3260DROP TABLE t1,t2,t3,t4,t5,t6; 3261CREATE TABLE t1 (c1 BIGINT NOT NULL); 3262CREATE TABLE t2 (c1 BIGINT NOT NULL); 3263CREATE TABLE t3 (c1 BIGINT NOT NULL); 3264CREATE TABLE t4 (c1 BIGINT NOT NULL); 3265CREATE TABLE t5 (c1 BIGINT NOT NULL); 3266CREATE TABLE t6 (c1 BIGINT NOT NULL); 3267INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3268INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3269INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 3270INSERT INTO t4 (c1) VALUES(10); 3271INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 3272SELECT t1.c1,t2.c1 FROM t1 STRAIGHT_JOIN t2 ON t1.c1 = t2.c1; 3273c1 c1 32740 0 32751 1 32762 2 32773 3 32784 4 32795 5 32806 6 32817 7 32828 8 32839 9 3284SELECT t1.c1,t2.c1 FROM t1 STRAIGHT_JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 <> 5; 3285c1 c1 32860 0 32871 1 32882 2 32893 3 32904 4 32916 6 32927 7 32938 8 32949 9 3295DROP TABLE t1,t2,t3,t4,t5,t6; 3296CREATE TABLE t1 (c1 TINYINT NOT NULL); 3297CREATE TABLE t2 (c1 TINYINT NOT NULL); 3298CREATE TABLE t3 (c1 TINYINT NOT NULL); 3299CREATE TABLE t4 (c1 TINYINT NOT NULL); 3300CREATE TABLE t5 (c1 TINYINT NOT NULL); 3301CREATE TABLE t6 (c1 TINYINT NOT NULL); 3302INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3303INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3304INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 3305INSERT INTO t4 (c1) VALUES(10); 3306INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 3307SELECT t1.c1,t3.c1 FROM t1 STRAIGHT_JOIN t3 ON t1.c1 = t3.c1; 3308c1 c1 33091 1 33103 3 33115 5 33127 7 33139 9 3314SELECT t1.c1,t3.c1 FROM t1 STRAIGHT_JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 <> 5; 3315c1 c1 33161 1 33173 3 33187 7 33199 9 3320DROP TABLE t1,t2,t3,t4,t5,t6; 3321CREATE TABLE t1 (c1 SMALLINT NOT NULL); 3322CREATE TABLE t2 (c1 SMALLINT NOT NULL); 3323CREATE TABLE t3 (c1 SMALLINT NOT NULL); 3324CREATE TABLE t4 (c1 SMALLINT NOT NULL); 3325CREATE TABLE t5 (c1 SMALLINT NOT NULL); 3326CREATE TABLE t6 (c1 SMALLINT NOT NULL); 3327INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3328INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3329INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 3330INSERT INTO t4 (c1) VALUES(10); 3331INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 3332SELECT t1.c1,t3.c1 FROM t1 STRAIGHT_JOIN t3 ON t1.c1 = t3.c1; 3333c1 c1 33341 1 33353 3 33365 5 33377 7 33389 9 3339SELECT t1.c1,t3.c1 FROM t1 STRAIGHT_JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 <> 5; 3340c1 c1 33411 1 33423 3 33437 7 33449 9 3345DROP TABLE t1,t2,t3,t4,t5,t6; 3346CREATE TABLE t1 (c1 MEDIUMINT NOT NULL); 3347CREATE TABLE t2 (c1 MEDIUMINT NOT NULL); 3348CREATE TABLE t3 (c1 MEDIUMINT NOT NULL); 3349CREATE TABLE t4 (c1 MEDIUMINT NOT NULL); 3350CREATE TABLE t5 (c1 MEDIUMINT NOT NULL); 3351CREATE TABLE t6 (c1 MEDIUMINT NOT NULL); 3352INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3353INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3354INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 3355INSERT INTO t4 (c1) VALUES(10); 3356INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 3357SELECT t1.c1,t3.c1 FROM t1 STRAIGHT_JOIN t3 ON t1.c1 = t3.c1; 3358c1 c1 33591 1 33603 3 33615 5 33627 7 33639 9 3364SELECT t1.c1,t3.c1 FROM t1 STRAIGHT_JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 <> 5; 3365c1 c1 33661 1 33673 3 33687 7 33699 9 3370DROP TABLE t1,t2,t3,t4,t5,t6; 3371CREATE TABLE t1 (c1 INT NOT NULL); 3372CREATE TABLE t2 (c1 INT NOT NULL); 3373CREATE TABLE t3 (c1 INT NOT NULL); 3374CREATE TABLE t4 (c1 INT NOT NULL); 3375CREATE TABLE t5 (c1 INT NOT NULL); 3376CREATE TABLE t6 (c1 INT NOT NULL); 3377INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3378INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3379INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 3380INSERT INTO t4 (c1) VALUES(10); 3381INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 3382SELECT t1.c1,t3.c1 FROM t1 STRAIGHT_JOIN t3 ON t1.c1 = t3.c1; 3383c1 c1 33841 1 33853 3 33865 5 33877 7 33889 9 3389SELECT t1.c1,t3.c1 FROM t1 STRAIGHT_JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 <> 5; 3390c1 c1 33911 1 33923 3 33937 7 33949 9 3395DROP TABLE t1,t2,t3,t4,t5,t6; 3396CREATE TABLE t1 (c1 INTEGER NOT NULL); 3397CREATE TABLE t2 (c1 INTEGER NOT NULL); 3398CREATE TABLE t3 (c1 INTEGER NOT NULL); 3399CREATE TABLE t4 (c1 INTEGER NOT NULL); 3400CREATE TABLE t5 (c1 INTEGER NOT NULL); 3401CREATE TABLE t6 (c1 INTEGER NOT NULL); 3402INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3403INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3404INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 3405INSERT INTO t4 (c1) VALUES(10); 3406INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 3407SELECT t1.c1,t3.c1 FROM t1 STRAIGHT_JOIN t3 ON t1.c1 = t3.c1; 3408c1 c1 34091 1 34103 3 34115 5 34127 7 34139 9 3414SELECT t1.c1,t3.c1 FROM t1 STRAIGHT_JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 <> 5; 3415c1 c1 34161 1 34173 3 34187 7 34199 9 3420DROP TABLE t1,t2,t3,t4,t5,t6; 3421CREATE TABLE t1 (c1 BIGINT NOT NULL); 3422CREATE TABLE t2 (c1 BIGINT NOT NULL); 3423CREATE TABLE t3 (c1 BIGINT NOT NULL); 3424CREATE TABLE t4 (c1 BIGINT NOT NULL); 3425CREATE TABLE t5 (c1 BIGINT NOT NULL); 3426CREATE TABLE t6 (c1 BIGINT NOT NULL); 3427INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3428INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3429INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 3430INSERT INTO t4 (c1) VALUES(10); 3431INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 3432SELECT t1.c1,t3.c1 FROM t1 STRAIGHT_JOIN t3 ON t1.c1 = t3.c1; 3433c1 c1 34341 1 34353 3 34365 5 34377 7 34389 9 3439SELECT t1.c1,t3.c1 FROM t1 STRAIGHT_JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 <> 5; 3440c1 c1 34411 1 34423 3 34437 7 34449 9 3445DROP TABLE t1,t2,t3,t4,t5,t6; 3446CREATE TABLE t1 (c1 TINYINT NOT NULL); 3447CREATE TABLE t2 (c1 TINYINT NOT NULL); 3448CREATE TABLE t3 (c1 TINYINT NOT NULL); 3449CREATE TABLE t4 (c1 TINYINT NOT NULL); 3450CREATE TABLE t5 (c1 TINYINT NOT NULL); 3451CREATE TABLE t6 (c1 TINYINT NOT NULL); 3452INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3453INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3454INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 3455INSERT INTO t4 (c1) VALUES(10); 3456INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 3457SELECT t1.c1,t4.c1 FROM t1 STRAIGHT_JOIN t4 ON t1.c1 = t4.c1; 3458c1 c1 3459SELECT t1.c1,t4.c1 FROM t1 STRAIGHT_JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 <> 5; 3460c1 c1 3461DROP TABLE t1,t2,t3,t4,t5,t6; 3462CREATE TABLE t1 (c1 SMALLINT NOT NULL); 3463CREATE TABLE t2 (c1 SMALLINT NOT NULL); 3464CREATE TABLE t3 (c1 SMALLINT NOT NULL); 3465CREATE TABLE t4 (c1 SMALLINT NOT NULL); 3466CREATE TABLE t5 (c1 SMALLINT NOT NULL); 3467CREATE TABLE t6 (c1 SMALLINT NOT NULL); 3468INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3469INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3470INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 3471INSERT INTO t4 (c1) VALUES(10); 3472INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 3473SELECT t1.c1,t4.c1 FROM t1 STRAIGHT_JOIN t4 ON t1.c1 = t4.c1; 3474c1 c1 3475SELECT t1.c1,t4.c1 FROM t1 STRAIGHT_JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 <> 5; 3476c1 c1 3477DROP TABLE t1,t2,t3,t4,t5,t6; 3478CREATE TABLE t1 (c1 MEDIUMINT NOT NULL); 3479CREATE TABLE t2 (c1 MEDIUMINT NOT NULL); 3480CREATE TABLE t3 (c1 MEDIUMINT NOT NULL); 3481CREATE TABLE t4 (c1 MEDIUMINT NOT NULL); 3482CREATE TABLE t5 (c1 MEDIUMINT NOT NULL); 3483CREATE TABLE t6 (c1 MEDIUMINT NOT NULL); 3484INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3485INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3486INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 3487INSERT INTO t4 (c1) VALUES(10); 3488INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 3489SELECT t1.c1,t4.c1 FROM t1 STRAIGHT_JOIN t4 ON t1.c1 = t4.c1; 3490c1 c1 3491SELECT t1.c1,t4.c1 FROM t1 STRAIGHT_JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 <> 5; 3492c1 c1 3493DROP TABLE t1,t2,t3,t4,t5,t6; 3494CREATE TABLE t1 (c1 INT NOT NULL); 3495CREATE TABLE t2 (c1 INT NOT NULL); 3496CREATE TABLE t3 (c1 INT NOT NULL); 3497CREATE TABLE t4 (c1 INT NOT NULL); 3498CREATE TABLE t5 (c1 INT NOT NULL); 3499CREATE TABLE t6 (c1 INT NOT NULL); 3500INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3501INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3502INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 3503INSERT INTO t4 (c1) VALUES(10); 3504INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 3505SELECT t1.c1,t4.c1 FROM t1 STRAIGHT_JOIN t4 ON t1.c1 = t4.c1; 3506c1 c1 3507SELECT t1.c1,t4.c1 FROM t1 STRAIGHT_JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 <> 5; 3508c1 c1 3509DROP TABLE t1,t2,t3,t4,t5,t6; 3510CREATE TABLE t1 (c1 INTEGER NOT NULL); 3511CREATE TABLE t2 (c1 INTEGER NOT NULL); 3512CREATE TABLE t3 (c1 INTEGER NOT NULL); 3513CREATE TABLE t4 (c1 INTEGER NOT NULL); 3514CREATE TABLE t5 (c1 INTEGER NOT NULL); 3515CREATE TABLE t6 (c1 INTEGER NOT NULL); 3516INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3517INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3518INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 3519INSERT INTO t4 (c1) VALUES(10); 3520INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 3521SELECT t1.c1,t4.c1 FROM t1 STRAIGHT_JOIN t4 ON t1.c1 = t4.c1; 3522c1 c1 3523SELECT t1.c1,t4.c1 FROM t1 STRAIGHT_JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 <> 5; 3524c1 c1 3525DROP TABLE t1,t2,t3,t4,t5,t6; 3526CREATE TABLE t1 (c1 BIGINT NOT NULL); 3527CREATE TABLE t2 (c1 BIGINT NOT NULL); 3528CREATE TABLE t3 (c1 BIGINT NOT NULL); 3529CREATE TABLE t4 (c1 BIGINT NOT NULL); 3530CREATE TABLE t5 (c1 BIGINT NOT NULL); 3531CREATE TABLE t6 (c1 BIGINT NOT NULL); 3532INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3533INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3534INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 3535INSERT INTO t4 (c1) VALUES(10); 3536INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 3537SELECT t1.c1,t4.c1 FROM t1 STRAIGHT_JOIN t4 ON t1.c1 = t4.c1; 3538c1 c1 3539SELECT t1.c1,t4.c1 FROM t1 STRAIGHT_JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 <> 5; 3540c1 c1 3541DROP TABLE t1,t2,t3,t4,t5,t6; 3542CREATE TABLE t1 (c1 TINYINT NOT NULL); 3543CREATE TABLE t2 (c1 TINYINT NOT NULL); 3544CREATE TABLE t3 (c1 TINYINT NOT NULL); 3545CREATE TABLE t4 (c1 TINYINT NOT NULL); 3546CREATE TABLE t5 (c1 TINYINT NOT NULL); 3547CREATE TABLE t6 (c1 TINYINT NOT NULL); 3548INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3549INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3550INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 3551INSERT INTO t4 (c1) VALUES(10); 3552INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 3553SELECT t1.c1,t5.c1 FROM t1 STRAIGHT_JOIN t5 ON t1.c1 = t5.c1; 3554c1 c1 3555SELECT t1.c1,t5.c1 FROM t1 STRAIGHT_JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 <> 5; 3556c1 c1 3557DROP TABLE t1,t2,t3,t4,t5,t6; 3558CREATE TABLE t1 (c1 SMALLINT NOT NULL); 3559CREATE TABLE t2 (c1 SMALLINT NOT NULL); 3560CREATE TABLE t3 (c1 SMALLINT NOT NULL); 3561CREATE TABLE t4 (c1 SMALLINT NOT NULL); 3562CREATE TABLE t5 (c1 SMALLINT NOT NULL); 3563CREATE TABLE t6 (c1 SMALLINT NOT NULL); 3564INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3565INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3566INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 3567INSERT INTO t4 (c1) VALUES(10); 3568INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 3569SELECT t1.c1,t5.c1 FROM t1 STRAIGHT_JOIN t5 ON t1.c1 = t5.c1; 3570c1 c1 3571SELECT t1.c1,t5.c1 FROM t1 STRAIGHT_JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 <> 5; 3572c1 c1 3573DROP TABLE t1,t2,t3,t4,t5,t6; 3574CREATE TABLE t1 (c1 MEDIUMINT NOT NULL); 3575CREATE TABLE t2 (c1 MEDIUMINT NOT NULL); 3576CREATE TABLE t3 (c1 MEDIUMINT NOT NULL); 3577CREATE TABLE t4 (c1 MEDIUMINT NOT NULL); 3578CREATE TABLE t5 (c1 MEDIUMINT NOT NULL); 3579CREATE TABLE t6 (c1 MEDIUMINT NOT NULL); 3580INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3581INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3582INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 3583INSERT INTO t4 (c1) VALUES(10); 3584INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 3585SELECT t1.c1,t5.c1 FROM t1 STRAIGHT_JOIN t5 ON t1.c1 = t5.c1; 3586c1 c1 3587SELECT t1.c1,t5.c1 FROM t1 STRAIGHT_JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 <> 5; 3588c1 c1 3589DROP TABLE t1,t2,t3,t4,t5,t6; 3590CREATE TABLE t1 (c1 INT NOT NULL); 3591CREATE TABLE t2 (c1 INT NOT NULL); 3592CREATE TABLE t3 (c1 INT NOT NULL); 3593CREATE TABLE t4 (c1 INT NOT NULL); 3594CREATE TABLE t5 (c1 INT NOT NULL); 3595CREATE TABLE t6 (c1 INT NOT NULL); 3596INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3597INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3598INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 3599INSERT INTO t4 (c1) VALUES(10); 3600INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 3601SELECT t1.c1,t5.c1 FROM t1 STRAIGHT_JOIN t5 ON t1.c1 = t5.c1; 3602c1 c1 3603SELECT t1.c1,t5.c1 FROM t1 STRAIGHT_JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 <> 5; 3604c1 c1 3605DROP TABLE t1,t2,t3,t4,t5,t6; 3606CREATE TABLE t1 (c1 INTEGER NOT NULL); 3607CREATE TABLE t2 (c1 INTEGER NOT NULL); 3608CREATE TABLE t3 (c1 INTEGER NOT NULL); 3609CREATE TABLE t4 (c1 INTEGER NOT NULL); 3610CREATE TABLE t5 (c1 INTEGER NOT NULL); 3611CREATE TABLE t6 (c1 INTEGER NOT NULL); 3612INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3613INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3614INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 3615INSERT INTO t4 (c1) VALUES(10); 3616INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 3617SELECT t1.c1,t5.c1 FROM t1 STRAIGHT_JOIN t5 ON t1.c1 = t5.c1; 3618c1 c1 3619SELECT t1.c1,t5.c1 FROM t1 STRAIGHT_JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 <> 5; 3620c1 c1 3621DROP TABLE t1,t2,t3,t4,t5,t6; 3622CREATE TABLE t1 (c1 BIGINT NOT NULL); 3623CREATE TABLE t2 (c1 BIGINT NOT NULL); 3624CREATE TABLE t3 (c1 BIGINT NOT NULL); 3625CREATE TABLE t4 (c1 BIGINT NOT NULL); 3626CREATE TABLE t5 (c1 BIGINT NOT NULL); 3627CREATE TABLE t6 (c1 BIGINT NOT NULL); 3628INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3629INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3630INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 3631INSERT INTO t4 (c1) VALUES(10); 3632INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 3633SELECT t1.c1,t5.c1 FROM t1 STRAIGHT_JOIN t5 ON t1.c1 = t5.c1; 3634c1 c1 3635SELECT t1.c1,t5.c1 FROM t1 STRAIGHT_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 TINYINT NOT NULL); 3639CREATE TABLE t2 (c1 TINYINT NOT NULL); 3640CREATE TABLE t3 (c1 TINYINT NOT NULL); 3641CREATE TABLE t4 (c1 TINYINT NOT NULL); 3642CREATE TABLE t5 (c1 TINYINT NOT NULL); 3643CREATE TABLE t6 (c1 TINYINT 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,t6.c1 FROM t1 STRAIGHT_JOIN t6 ON t1.c1 = t6.c1; 3650c1 c1 3651SELECT t1.c1,t6.c1 FROM t1 STRAIGHT_JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 <> 5; 3652c1 c1 3653DROP TABLE t1,t2,t3,t4,t5,t6; 3654CREATE TABLE t1 (c1 SMALLINT NOT NULL); 3655CREATE TABLE t2 (c1 SMALLINT NOT NULL); 3656CREATE TABLE t3 (c1 SMALLINT NOT NULL); 3657CREATE TABLE t4 (c1 SMALLINT NOT NULL); 3658CREATE TABLE t5 (c1 SMALLINT NOT NULL); 3659CREATE TABLE t6 (c1 SMALLINT NOT NULL); 3660INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3661INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3662INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 3663INSERT INTO t4 (c1) VALUES(10); 3664INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 3665SELECT t1.c1,t6.c1 FROM t1 STRAIGHT_JOIN t6 ON t1.c1 = t6.c1; 3666c1 c1 3667SELECT t1.c1,t6.c1 FROM t1 STRAIGHT_JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 <> 5; 3668c1 c1 3669DROP TABLE t1,t2,t3,t4,t5,t6; 3670CREATE TABLE t1 (c1 MEDIUMINT NOT NULL); 3671CREATE TABLE t2 (c1 MEDIUMINT NOT NULL); 3672CREATE TABLE t3 (c1 MEDIUMINT NOT NULL); 3673CREATE TABLE t4 (c1 MEDIUMINT NOT NULL); 3674CREATE TABLE t5 (c1 MEDIUMINT NOT NULL); 3675CREATE TABLE t6 (c1 MEDIUMINT NOT NULL); 3676INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3677INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3678INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 3679INSERT INTO t4 (c1) VALUES(10); 3680INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 3681SELECT t1.c1,t6.c1 FROM t1 STRAIGHT_JOIN t6 ON t1.c1 = t6.c1; 3682c1 c1 3683SELECT t1.c1,t6.c1 FROM t1 STRAIGHT_JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 <> 5; 3684c1 c1 3685DROP TABLE t1,t2,t3,t4,t5,t6; 3686CREATE TABLE t1 (c1 INT NOT NULL); 3687CREATE TABLE t2 (c1 INT NOT NULL); 3688CREATE TABLE t3 (c1 INT NOT NULL); 3689CREATE TABLE t4 (c1 INT NOT NULL); 3690CREATE TABLE t5 (c1 INT NOT NULL); 3691CREATE TABLE t6 (c1 INT NOT NULL); 3692INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3693INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3694INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 3695INSERT INTO t4 (c1) VALUES(10); 3696INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 3697SELECT t1.c1,t6.c1 FROM t1 STRAIGHT_JOIN t6 ON t1.c1 = t6.c1; 3698c1 c1 3699SELECT t1.c1,t6.c1 FROM t1 STRAIGHT_JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 <> 5; 3700c1 c1 3701DROP TABLE t1,t2,t3,t4,t5,t6; 3702CREATE TABLE t1 (c1 INTEGER NOT NULL); 3703CREATE TABLE t2 (c1 INTEGER NOT NULL); 3704CREATE TABLE t3 (c1 INTEGER NOT NULL); 3705CREATE TABLE t4 (c1 INTEGER NOT NULL); 3706CREATE TABLE t5 (c1 INTEGER NOT NULL); 3707CREATE TABLE t6 (c1 INTEGER NOT NULL); 3708INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3709INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3710INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 3711INSERT INTO t4 (c1) VALUES(10); 3712INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 3713SELECT t1.c1,t6.c1 FROM t1 STRAIGHT_JOIN t6 ON t1.c1 = t6.c1; 3714c1 c1 3715SELECT t1.c1,t6.c1 FROM t1 STRAIGHT_JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 <> 5; 3716c1 c1 3717DROP TABLE t1,t2,t3,t4,t5,t6; 3718CREATE TABLE t1 (c1 BIGINT NOT NULL); 3719CREATE TABLE t2 (c1 BIGINT NOT NULL); 3720CREATE TABLE t3 (c1 BIGINT NOT NULL); 3721CREATE TABLE t4 (c1 BIGINT NOT NULL); 3722CREATE TABLE t5 (c1 BIGINT NOT NULL); 3723CREATE TABLE t6 (c1 BIGINT NOT NULL); 3724INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3725INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3726INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 3727INSERT INTO t4 (c1) VALUES(10); 3728INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 3729SELECT t1.c1,t6.c1 FROM t1 STRAIGHT_JOIN t6 ON t1.c1 = t6.c1; 3730c1 c1 3731SELECT t1.c1,t6.c1 FROM t1 STRAIGHT_JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 <> 5; 3732c1 c1 3733DROP TABLE t1,t2,t3,t4,t5,t6; 3734CREATE TABLE t1 (c1 TINYINT NOT NULL); 3735CREATE TABLE t2 (c1 TINYINT NOT NULL); 3736CREATE TABLE t3 (c1 TINYINT NOT NULL); 3737CREATE TABLE t4 (c1 TINYINT NOT NULL); 3738CREATE TABLE t5 (c1 TINYINT NOT NULL); 3739CREATE TABLE t6 (c1 TINYINT NOT NULL); 3740INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3741INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3742INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 3743INSERT INTO t4 (c1) VALUES(10); 3744INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 3745SELECT t1.c1,t2.c1 FROM t1 STRAIGHT_JOIN t2 ON t1.c1 = t2.c1; 3746c1 c1 37470 0 37481 1 37492 2 37503 3 37514 4 37525 5 37536 6 37547 7 37558 8 37569 9 3757SELECT t1.c1,t2.c1 FROM t1 STRAIGHT_JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 <=> 5; 3758c1 c1 37595 5 3760DROP TABLE t1,t2,t3,t4,t5,t6; 3761CREATE TABLE t1 (c1 SMALLINT NOT NULL); 3762CREATE TABLE t2 (c1 SMALLINT NOT NULL); 3763CREATE TABLE t3 (c1 SMALLINT NOT NULL); 3764CREATE TABLE t4 (c1 SMALLINT NOT NULL); 3765CREATE TABLE t5 (c1 SMALLINT NOT NULL); 3766CREATE TABLE t6 (c1 SMALLINT NOT NULL); 3767INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3768INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3769INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 3770INSERT INTO t4 (c1) VALUES(10); 3771INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 3772SELECT t1.c1,t2.c1 FROM t1 STRAIGHT_JOIN t2 ON t1.c1 = t2.c1; 3773c1 c1 37740 0 37751 1 37762 2 37773 3 37784 4 37795 5 37806 6 37817 7 37828 8 37839 9 3784SELECT t1.c1,t2.c1 FROM t1 STRAIGHT_JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 <=> 5; 3785c1 c1 37865 5 3787DROP TABLE t1,t2,t3,t4,t5,t6; 3788CREATE TABLE t1 (c1 MEDIUMINT NOT NULL); 3789CREATE TABLE t2 (c1 MEDIUMINT NOT NULL); 3790CREATE TABLE t3 (c1 MEDIUMINT NOT NULL); 3791CREATE TABLE t4 (c1 MEDIUMINT NOT NULL); 3792CREATE TABLE t5 (c1 MEDIUMINT NOT NULL); 3793CREATE TABLE t6 (c1 MEDIUMINT NOT NULL); 3794INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3795INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3796INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 3797INSERT INTO t4 (c1) VALUES(10); 3798INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 3799SELECT t1.c1,t2.c1 FROM t1 STRAIGHT_JOIN t2 ON t1.c1 = t2.c1; 3800c1 c1 38010 0 38021 1 38032 2 38043 3 38054 4 38065 5 38076 6 38087 7 38098 8 38109 9 3811SELECT t1.c1,t2.c1 FROM t1 STRAIGHT_JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 <=> 5; 3812c1 c1 38135 5 3814DROP TABLE t1,t2,t3,t4,t5,t6; 3815CREATE TABLE t1 (c1 INT NOT NULL); 3816CREATE TABLE t2 (c1 INT NOT NULL); 3817CREATE TABLE t3 (c1 INT NOT NULL); 3818CREATE TABLE t4 (c1 INT NOT NULL); 3819CREATE TABLE t5 (c1 INT NOT NULL); 3820CREATE TABLE t6 (c1 INT NOT NULL); 3821INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3822INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3823INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 3824INSERT INTO t4 (c1) VALUES(10); 3825INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 3826SELECT t1.c1,t2.c1 FROM t1 STRAIGHT_JOIN t2 ON t1.c1 = t2.c1; 3827c1 c1 38280 0 38291 1 38302 2 38313 3 38324 4 38335 5 38346 6 38357 7 38368 8 38379 9 3838SELECT t1.c1,t2.c1 FROM t1 STRAIGHT_JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 <=> 5; 3839c1 c1 38405 5 3841DROP TABLE t1,t2,t3,t4,t5,t6; 3842CREATE TABLE t1 (c1 INTEGER NOT NULL); 3843CREATE TABLE t2 (c1 INTEGER NOT NULL); 3844CREATE TABLE t3 (c1 INTEGER NOT NULL); 3845CREATE TABLE t4 (c1 INTEGER NOT NULL); 3846CREATE TABLE t5 (c1 INTEGER NOT NULL); 3847CREATE TABLE t6 (c1 INTEGER NOT NULL); 3848INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3849INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3850INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 3851INSERT INTO t4 (c1) VALUES(10); 3852INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 3853SELECT t1.c1,t2.c1 FROM t1 STRAIGHT_JOIN t2 ON t1.c1 = t2.c1; 3854c1 c1 38550 0 38561 1 38572 2 38583 3 38594 4 38605 5 38616 6 38627 7 38638 8 38649 9 3865SELECT t1.c1,t2.c1 FROM t1 STRAIGHT_JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 <=> 5; 3866c1 c1 38675 5 3868DROP TABLE t1,t2,t3,t4,t5,t6; 3869CREATE TABLE t1 (c1 BIGINT NOT NULL); 3870CREATE TABLE t2 (c1 BIGINT NOT NULL); 3871CREATE TABLE t3 (c1 BIGINT NOT NULL); 3872CREATE TABLE t4 (c1 BIGINT NOT NULL); 3873CREATE TABLE t5 (c1 BIGINT NOT NULL); 3874CREATE TABLE t6 (c1 BIGINT NOT NULL); 3875INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3876INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3877INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 3878INSERT INTO t4 (c1) VALUES(10); 3879INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 3880SELECT t1.c1,t2.c1 FROM t1 STRAIGHT_JOIN t2 ON t1.c1 = t2.c1; 3881c1 c1 38820 0 38831 1 38842 2 38853 3 38864 4 38875 5 38886 6 38897 7 38908 8 38919 9 3892SELECT t1.c1,t2.c1 FROM t1 STRAIGHT_JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 <=> 5; 3893c1 c1 38945 5 3895DROP TABLE t1,t2,t3,t4,t5,t6; 3896CREATE TABLE t1 (c1 TINYINT NOT NULL); 3897CREATE TABLE t2 (c1 TINYINT NOT NULL); 3898CREATE TABLE t3 (c1 TINYINT NOT NULL); 3899CREATE TABLE t4 (c1 TINYINT NOT NULL); 3900CREATE TABLE t5 (c1 TINYINT NOT NULL); 3901CREATE TABLE t6 (c1 TINYINT NOT NULL); 3902INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3903INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3904INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 3905INSERT INTO t4 (c1) VALUES(10); 3906INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 3907SELECT t1.c1,t3.c1 FROM t1 STRAIGHT_JOIN t3 ON t1.c1 = t3.c1; 3908c1 c1 39091 1 39103 3 39115 5 39127 7 39139 9 3914SELECT t1.c1,t3.c1 FROM t1 STRAIGHT_JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 <=> 5; 3915c1 c1 39165 5 3917DROP TABLE t1,t2,t3,t4,t5,t6; 3918CREATE TABLE t1 (c1 SMALLINT NOT NULL); 3919CREATE TABLE t2 (c1 SMALLINT NOT NULL); 3920CREATE TABLE t3 (c1 SMALLINT NOT NULL); 3921CREATE TABLE t4 (c1 SMALLINT NOT NULL); 3922CREATE TABLE t5 (c1 SMALLINT NOT NULL); 3923CREATE TABLE t6 (c1 SMALLINT NOT NULL); 3924INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3925INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3926INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 3927INSERT INTO t4 (c1) VALUES(10); 3928INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 3929SELECT t1.c1,t3.c1 FROM t1 STRAIGHT_JOIN t3 ON t1.c1 = t3.c1; 3930c1 c1 39311 1 39323 3 39335 5 39347 7 39359 9 3936SELECT t1.c1,t3.c1 FROM t1 STRAIGHT_JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 <=> 5; 3937c1 c1 39385 5 3939DROP TABLE t1,t2,t3,t4,t5,t6; 3940CREATE TABLE t1 (c1 MEDIUMINT NOT NULL); 3941CREATE TABLE t2 (c1 MEDIUMINT NOT NULL); 3942CREATE TABLE t3 (c1 MEDIUMINT NOT NULL); 3943CREATE TABLE t4 (c1 MEDIUMINT NOT NULL); 3944CREATE TABLE t5 (c1 MEDIUMINT NOT NULL); 3945CREATE TABLE t6 (c1 MEDIUMINT NOT NULL); 3946INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3947INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3948INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 3949INSERT INTO t4 (c1) VALUES(10); 3950INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 3951SELECT t1.c1,t3.c1 FROM t1 STRAIGHT_JOIN t3 ON t1.c1 = t3.c1; 3952c1 c1 39531 1 39543 3 39555 5 39567 7 39579 9 3958SELECT t1.c1,t3.c1 FROM t1 STRAIGHT_JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 <=> 5; 3959c1 c1 39605 5 3961DROP TABLE t1,t2,t3,t4,t5,t6; 3962CREATE TABLE t1 (c1 INT NOT NULL); 3963CREATE TABLE t2 (c1 INT NOT NULL); 3964CREATE TABLE t3 (c1 INT NOT NULL); 3965CREATE TABLE t4 (c1 INT NOT NULL); 3966CREATE TABLE t5 (c1 INT NOT NULL); 3967CREATE TABLE t6 (c1 INT NOT NULL); 3968INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3969INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3970INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 3971INSERT INTO t4 (c1) VALUES(10); 3972INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 3973SELECT t1.c1,t3.c1 FROM t1 STRAIGHT_JOIN t3 ON t1.c1 = t3.c1; 3974c1 c1 39751 1 39763 3 39775 5 39787 7 39799 9 3980SELECT t1.c1,t3.c1 FROM t1 STRAIGHT_JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 <=> 5; 3981c1 c1 39825 5 3983DROP TABLE t1,t2,t3,t4,t5,t6; 3984CREATE TABLE t1 (c1 INTEGER NOT NULL); 3985CREATE TABLE t2 (c1 INTEGER NOT NULL); 3986CREATE TABLE t3 (c1 INTEGER NOT NULL); 3987CREATE TABLE t4 (c1 INTEGER NOT NULL); 3988CREATE TABLE t5 (c1 INTEGER NOT NULL); 3989CREATE TABLE t6 (c1 INTEGER NOT NULL); 3990INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3991INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3992INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 3993INSERT INTO t4 (c1) VALUES(10); 3994INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 3995SELECT t1.c1,t3.c1 FROM t1 STRAIGHT_JOIN t3 ON t1.c1 = t3.c1; 3996c1 c1 39971 1 39983 3 39995 5 40007 7 40019 9 4002SELECT t1.c1,t3.c1 FROM t1 STRAIGHT_JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 <=> 5; 4003c1 c1 40045 5 4005DROP TABLE t1,t2,t3,t4,t5,t6; 4006CREATE TABLE t1 (c1 BIGINT NOT NULL); 4007CREATE TABLE t2 (c1 BIGINT NOT NULL); 4008CREATE TABLE t3 (c1 BIGINT NOT NULL); 4009CREATE TABLE t4 (c1 BIGINT NOT NULL); 4010CREATE TABLE t5 (c1 BIGINT NOT NULL); 4011CREATE TABLE t6 (c1 BIGINT NOT NULL); 4012INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 4013INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 4014INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 4015INSERT INTO t4 (c1) VALUES(10); 4016INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 4017SELECT t1.c1,t3.c1 FROM t1 STRAIGHT_JOIN t3 ON t1.c1 = t3.c1; 4018c1 c1 40191 1 40203 3 40215 5 40227 7 40239 9 4024SELECT t1.c1,t3.c1 FROM t1 STRAIGHT_JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 <=> 5; 4025c1 c1 40265 5 4027DROP TABLE t1,t2,t3,t4,t5,t6; 4028CREATE TABLE t1 (c1 TINYINT NOT NULL); 4029CREATE TABLE t2 (c1 TINYINT NOT NULL); 4030CREATE TABLE t3 (c1 TINYINT NOT NULL); 4031CREATE TABLE t4 (c1 TINYINT NOT NULL); 4032CREATE TABLE t5 (c1 TINYINT NOT NULL); 4033CREATE TABLE t6 (c1 TINYINT NOT NULL); 4034INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 4035INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 4036INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 4037INSERT INTO t4 (c1) VALUES(10); 4038INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 4039SELECT t1.c1,t4.c1 FROM t1 STRAIGHT_JOIN t4 ON t1.c1 = t4.c1; 4040c1 c1 4041SELECT t1.c1,t4.c1 FROM t1 STRAIGHT_JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 <=> 5; 4042c1 c1 4043DROP TABLE t1,t2,t3,t4,t5,t6; 4044CREATE TABLE t1 (c1 SMALLINT NOT NULL); 4045CREATE TABLE t2 (c1 SMALLINT NOT NULL); 4046CREATE TABLE t3 (c1 SMALLINT NOT NULL); 4047CREATE TABLE t4 (c1 SMALLINT NOT NULL); 4048CREATE TABLE t5 (c1 SMALLINT NOT NULL); 4049CREATE TABLE t6 (c1 SMALLINT NOT NULL); 4050INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 4051INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 4052INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 4053INSERT INTO t4 (c1) VALUES(10); 4054INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 4055SELECT t1.c1,t4.c1 FROM t1 STRAIGHT_JOIN t4 ON t1.c1 = t4.c1; 4056c1 c1 4057SELECT t1.c1,t4.c1 FROM t1 STRAIGHT_JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 <=> 5; 4058c1 c1 4059DROP TABLE t1,t2,t3,t4,t5,t6; 4060CREATE TABLE t1 (c1 MEDIUMINT NOT NULL); 4061CREATE TABLE t2 (c1 MEDIUMINT NOT NULL); 4062CREATE TABLE t3 (c1 MEDIUMINT NOT NULL); 4063CREATE TABLE t4 (c1 MEDIUMINT NOT NULL); 4064CREATE TABLE t5 (c1 MEDIUMINT NOT NULL); 4065CREATE TABLE t6 (c1 MEDIUMINT NOT NULL); 4066INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 4067INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 4068INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 4069INSERT INTO t4 (c1) VALUES(10); 4070INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 4071SELECT t1.c1,t4.c1 FROM t1 STRAIGHT_JOIN t4 ON t1.c1 = t4.c1; 4072c1 c1 4073SELECT t1.c1,t4.c1 FROM t1 STRAIGHT_JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 <=> 5; 4074c1 c1 4075DROP TABLE t1,t2,t3,t4,t5,t6; 4076CREATE TABLE t1 (c1 INT NOT NULL); 4077CREATE TABLE t2 (c1 INT NOT NULL); 4078CREATE TABLE t3 (c1 INT NOT NULL); 4079CREATE TABLE t4 (c1 INT NOT NULL); 4080CREATE TABLE t5 (c1 INT NOT NULL); 4081CREATE TABLE t6 (c1 INT NOT NULL); 4082INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 4083INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 4084INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 4085INSERT INTO t4 (c1) VALUES(10); 4086INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 4087SELECT t1.c1,t4.c1 FROM t1 STRAIGHT_JOIN t4 ON t1.c1 = t4.c1; 4088c1 c1 4089SELECT t1.c1,t4.c1 FROM t1 STRAIGHT_JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 <=> 5; 4090c1 c1 4091DROP TABLE t1,t2,t3,t4,t5,t6; 4092CREATE TABLE t1 (c1 INTEGER NOT NULL); 4093CREATE TABLE t2 (c1 INTEGER NOT NULL); 4094CREATE TABLE t3 (c1 INTEGER NOT NULL); 4095CREATE TABLE t4 (c1 INTEGER NOT NULL); 4096CREATE TABLE t5 (c1 INTEGER NOT NULL); 4097CREATE TABLE t6 (c1 INTEGER NOT NULL); 4098INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 4099INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 4100INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 4101INSERT INTO t4 (c1) VALUES(10); 4102INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 4103SELECT t1.c1,t4.c1 FROM t1 STRAIGHT_JOIN t4 ON t1.c1 = t4.c1; 4104c1 c1 4105SELECT t1.c1,t4.c1 FROM t1 STRAIGHT_JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 <=> 5; 4106c1 c1 4107DROP TABLE t1,t2,t3,t4,t5,t6; 4108CREATE TABLE t1 (c1 BIGINT NOT NULL); 4109CREATE TABLE t2 (c1 BIGINT NOT NULL); 4110CREATE TABLE t3 (c1 BIGINT NOT NULL); 4111CREATE TABLE t4 (c1 BIGINT NOT NULL); 4112CREATE TABLE t5 (c1 BIGINT NOT NULL); 4113CREATE TABLE t6 (c1 BIGINT NOT NULL); 4114INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 4115INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 4116INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 4117INSERT INTO t4 (c1) VALUES(10); 4118INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 4119SELECT t1.c1,t4.c1 FROM t1 STRAIGHT_JOIN t4 ON t1.c1 = t4.c1; 4120c1 c1 4121SELECT t1.c1,t4.c1 FROM t1 STRAIGHT_JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 <=> 5; 4122c1 c1 4123DROP TABLE t1,t2,t3,t4,t5,t6; 4124CREATE TABLE t1 (c1 TINYINT NOT NULL); 4125CREATE TABLE t2 (c1 TINYINT NOT NULL); 4126CREATE TABLE t3 (c1 TINYINT NOT NULL); 4127CREATE TABLE t4 (c1 TINYINT NOT NULL); 4128CREATE TABLE t5 (c1 TINYINT NOT NULL); 4129CREATE TABLE t6 (c1 TINYINT NOT NULL); 4130INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 4131INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 4132INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 4133INSERT INTO t4 (c1) VALUES(10); 4134INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 4135SELECT t1.c1,t5.c1 FROM t1 STRAIGHT_JOIN t5 ON t1.c1 = t5.c1; 4136c1 c1 4137SELECT t1.c1,t5.c1 FROM t1 STRAIGHT_JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 <=> 5; 4138c1 c1 4139DROP TABLE t1,t2,t3,t4,t5,t6; 4140CREATE TABLE t1 (c1 SMALLINT NOT NULL); 4141CREATE TABLE t2 (c1 SMALLINT NOT NULL); 4142CREATE TABLE t3 (c1 SMALLINT NOT NULL); 4143CREATE TABLE t4 (c1 SMALLINT NOT NULL); 4144CREATE TABLE t5 (c1 SMALLINT NOT NULL); 4145CREATE TABLE t6 (c1 SMALLINT NOT NULL); 4146INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 4147INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 4148INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 4149INSERT INTO t4 (c1) VALUES(10); 4150INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 4151SELECT t1.c1,t5.c1 FROM t1 STRAIGHT_JOIN t5 ON t1.c1 = t5.c1; 4152c1 c1 4153SELECT t1.c1,t5.c1 FROM t1 STRAIGHT_JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 <=> 5; 4154c1 c1 4155DROP TABLE t1,t2,t3,t4,t5,t6; 4156CREATE TABLE t1 (c1 MEDIUMINT NOT NULL); 4157CREATE TABLE t2 (c1 MEDIUMINT NOT NULL); 4158CREATE TABLE t3 (c1 MEDIUMINT NOT NULL); 4159CREATE TABLE t4 (c1 MEDIUMINT NOT NULL); 4160CREATE TABLE t5 (c1 MEDIUMINT NOT NULL); 4161CREATE TABLE t6 (c1 MEDIUMINT NOT NULL); 4162INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 4163INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 4164INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 4165INSERT INTO t4 (c1) VALUES(10); 4166INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 4167SELECT t1.c1,t5.c1 FROM t1 STRAIGHT_JOIN t5 ON t1.c1 = t5.c1; 4168c1 c1 4169SELECT t1.c1,t5.c1 FROM t1 STRAIGHT_JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 <=> 5; 4170c1 c1 4171DROP TABLE t1,t2,t3,t4,t5,t6; 4172CREATE TABLE t1 (c1 INT NOT NULL); 4173CREATE TABLE t2 (c1 INT NOT NULL); 4174CREATE TABLE t3 (c1 INT NOT NULL); 4175CREATE TABLE t4 (c1 INT NOT NULL); 4176CREATE TABLE t5 (c1 INT NOT NULL); 4177CREATE TABLE t6 (c1 INT NOT NULL); 4178INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 4179INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 4180INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 4181INSERT INTO t4 (c1) VALUES(10); 4182INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 4183SELECT t1.c1,t5.c1 FROM t1 STRAIGHT_JOIN t5 ON t1.c1 = t5.c1; 4184c1 c1 4185SELECT t1.c1,t5.c1 FROM t1 STRAIGHT_JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 <=> 5; 4186c1 c1 4187DROP TABLE t1,t2,t3,t4,t5,t6; 4188CREATE TABLE t1 (c1 INTEGER NOT NULL); 4189CREATE TABLE t2 (c1 INTEGER NOT NULL); 4190CREATE TABLE t3 (c1 INTEGER NOT NULL); 4191CREATE TABLE t4 (c1 INTEGER NOT NULL); 4192CREATE TABLE t5 (c1 INTEGER NOT NULL); 4193CREATE TABLE t6 (c1 INTEGER NOT NULL); 4194INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 4195INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 4196INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 4197INSERT INTO t4 (c1) VALUES(10); 4198INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 4199SELECT t1.c1,t5.c1 FROM t1 STRAIGHT_JOIN t5 ON t1.c1 = t5.c1; 4200c1 c1 4201SELECT t1.c1,t5.c1 FROM t1 STRAIGHT_JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 <=> 5; 4202c1 c1 4203DROP TABLE t1,t2,t3,t4,t5,t6; 4204CREATE TABLE t1 (c1 BIGINT NOT NULL); 4205CREATE TABLE t2 (c1 BIGINT NOT NULL); 4206CREATE TABLE t3 (c1 BIGINT NOT NULL); 4207CREATE TABLE t4 (c1 BIGINT NOT NULL); 4208CREATE TABLE t5 (c1 BIGINT NOT NULL); 4209CREATE TABLE t6 (c1 BIGINT NOT NULL); 4210INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 4211INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 4212INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 4213INSERT INTO t4 (c1) VALUES(10); 4214INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 4215SELECT t1.c1,t5.c1 FROM t1 STRAIGHT_JOIN t5 ON t1.c1 = t5.c1; 4216c1 c1 4217SELECT t1.c1,t5.c1 FROM t1 STRAIGHT_JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 <=> 5; 4218c1 c1 4219DROP TABLE t1,t2,t3,t4,t5,t6; 4220CREATE TABLE t1 (c1 TINYINT NOT NULL); 4221CREATE TABLE t2 (c1 TINYINT NOT NULL); 4222CREATE TABLE t3 (c1 TINYINT NOT NULL); 4223CREATE TABLE t4 (c1 TINYINT NOT NULL); 4224CREATE TABLE t5 (c1 TINYINT NOT NULL); 4225CREATE TABLE t6 (c1 TINYINT NOT NULL); 4226INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 4227INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 4228INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 4229INSERT INTO t4 (c1) VALUES(10); 4230INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 4231SELECT t1.c1,t6.c1 FROM t1 STRAIGHT_JOIN t6 ON t1.c1 = t6.c1; 4232c1 c1 4233SELECT t1.c1,t6.c1 FROM t1 STRAIGHT_JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 <=> 5; 4234c1 c1 4235DROP TABLE t1,t2,t3,t4,t5,t6; 4236CREATE TABLE t1 (c1 SMALLINT NOT NULL); 4237CREATE TABLE t2 (c1 SMALLINT NOT NULL); 4238CREATE TABLE t3 (c1 SMALLINT NOT NULL); 4239CREATE TABLE t4 (c1 SMALLINT NOT NULL); 4240CREATE TABLE t5 (c1 SMALLINT NOT NULL); 4241CREATE TABLE t6 (c1 SMALLINT NOT NULL); 4242INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 4243INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 4244INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 4245INSERT INTO t4 (c1) VALUES(10); 4246INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 4247SELECT t1.c1,t6.c1 FROM t1 STRAIGHT_JOIN t6 ON t1.c1 = t6.c1; 4248c1 c1 4249SELECT t1.c1,t6.c1 FROM t1 STRAIGHT_JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 <=> 5; 4250c1 c1 4251DROP TABLE t1,t2,t3,t4,t5,t6; 4252CREATE TABLE t1 (c1 MEDIUMINT NOT NULL); 4253CREATE TABLE t2 (c1 MEDIUMINT NOT NULL); 4254CREATE TABLE t3 (c1 MEDIUMINT NOT NULL); 4255CREATE TABLE t4 (c1 MEDIUMINT NOT NULL); 4256CREATE TABLE t5 (c1 MEDIUMINT NOT NULL); 4257CREATE TABLE t6 (c1 MEDIUMINT NOT NULL); 4258INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 4259INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 4260INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 4261INSERT INTO t4 (c1) VALUES(10); 4262INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 4263SELECT t1.c1,t6.c1 FROM t1 STRAIGHT_JOIN t6 ON t1.c1 = t6.c1; 4264c1 c1 4265SELECT t1.c1,t6.c1 FROM t1 STRAIGHT_JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 <=> 5; 4266c1 c1 4267DROP TABLE t1,t2,t3,t4,t5,t6; 4268CREATE TABLE t1 (c1 INT NOT NULL); 4269CREATE TABLE t2 (c1 INT NOT NULL); 4270CREATE TABLE t3 (c1 INT NOT NULL); 4271CREATE TABLE t4 (c1 INT NOT NULL); 4272CREATE TABLE t5 (c1 INT NOT NULL); 4273CREATE TABLE t6 (c1 INT NOT NULL); 4274INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 4275INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 4276INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 4277INSERT INTO t4 (c1) VALUES(10); 4278INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 4279SELECT t1.c1,t6.c1 FROM t1 STRAIGHT_JOIN t6 ON t1.c1 = t6.c1; 4280c1 c1 4281SELECT t1.c1,t6.c1 FROM t1 STRAIGHT_JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 <=> 5; 4282c1 c1 4283DROP TABLE t1,t2,t3,t4,t5,t6; 4284CREATE TABLE t1 (c1 INTEGER NOT NULL); 4285CREATE TABLE t2 (c1 INTEGER NOT NULL); 4286CREATE TABLE t3 (c1 INTEGER NOT NULL); 4287CREATE TABLE t4 (c1 INTEGER NOT NULL); 4288CREATE TABLE t5 (c1 INTEGER NOT NULL); 4289CREATE TABLE t6 (c1 INTEGER NOT NULL); 4290INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 4291INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 4292INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 4293INSERT INTO t4 (c1) VALUES(10); 4294INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 4295SELECT t1.c1,t6.c1 FROM t1 STRAIGHT_JOIN t6 ON t1.c1 = t6.c1; 4296c1 c1 4297SELECT t1.c1,t6.c1 FROM t1 STRAIGHT_JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 <=> 5; 4298c1 c1 4299DROP TABLE t1,t2,t3,t4,t5,t6; 4300CREATE TABLE t1 (c1 BIGINT NOT NULL); 4301CREATE TABLE t2 (c1 BIGINT NOT NULL); 4302CREATE TABLE t3 (c1 BIGINT NOT NULL); 4303CREATE TABLE t4 (c1 BIGINT NOT NULL); 4304CREATE TABLE t5 (c1 BIGINT NOT NULL); 4305CREATE TABLE t6 (c1 BIGINT NOT NULL); 4306INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 4307INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 4308INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 4309INSERT INTO t4 (c1) VALUES(10); 4310INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 4311SELECT t1.c1,t6.c1 FROM t1 STRAIGHT_JOIN t6 ON t1.c1 = t6.c1; 4312c1 c1 4313SELECT t1.c1,t6.c1 FROM t1 STRAIGHT_JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 <=> 5; 4314c1 c1 4315DROP TABLE t1,t2,t3,t4,t5,t6; 4316