1#Want to skip this test from daily Valgrind execution 2--source include/no_valgrind_without_big.inc 3--disable_warnings 4DROP TABLE IF EXISTS t1,t2,t3,t4,t5,t6; 5--enable_warnings 6CREATE TABLE t1 (c1 TINYINT NOT NULL); 7CREATE TABLE t2 (c1 TINYINT NOT NULL); 8CREATE TABLE t3 (c1 TINYINT NOT NULL); 9CREATE TABLE t4 (c1 TINYINT NOT NULL); 10CREATE TABLE t5 (c1 TINYINT NOT NULL); 11CREATE TABLE t6 (c1 TINYINT NOT NULL); 12INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 13INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 14INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 15INSERT INTO t4 (c1) VALUES(10); 16INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 17-- sorted_result 18SELECT t1.c1,t2.c1 FROM t1 NATURAL LEFT OUTER JOIN t2 ORDER BY t1.c1,t2.c1; 19-- sorted_result 20SELECT t1.c1,t2.c1 FROM t1 NATURAL LEFT OUTER JOIN t2 WHERE t1.c1 < 5 ORDER BY t1.c1,t2.c1; 21DROP TABLE t1,t2,t3,t4,t5,t6; 22CREATE TABLE t1 (c1 SMALLINT NOT NULL); 23CREATE TABLE t2 (c1 SMALLINT NOT NULL); 24CREATE TABLE t3 (c1 SMALLINT NOT NULL); 25CREATE TABLE t4 (c1 SMALLINT NOT NULL); 26CREATE TABLE t5 (c1 SMALLINT NOT NULL); 27CREATE TABLE t6 (c1 SMALLINT NOT NULL); 28INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 29INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 30INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 31INSERT INTO t4 (c1) VALUES(10); 32INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 33-- sorted_result 34SELECT t1.c1,t2.c1 FROM t1 NATURAL LEFT OUTER JOIN t2 ORDER BY t1.c1,t2.c1; 35-- sorted_result 36SELECT t1.c1,t2.c1 FROM t1 NATURAL LEFT OUTER JOIN t2 WHERE t1.c1 < 5 ORDER BY t1.c1,t2.c1; 37DROP TABLE t1,t2,t3,t4,t5,t6; 38CREATE TABLE t1 (c1 MEDIUMINT NOT NULL); 39CREATE TABLE t2 (c1 MEDIUMINT NOT NULL); 40CREATE TABLE t3 (c1 MEDIUMINT NOT NULL); 41CREATE TABLE t4 (c1 MEDIUMINT NOT NULL); 42CREATE TABLE t5 (c1 MEDIUMINT NOT NULL); 43CREATE TABLE t6 (c1 MEDIUMINT NOT NULL); 44INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 45INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 46INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 47INSERT INTO t4 (c1) VALUES(10); 48INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 49-- sorted_result 50SELECT t1.c1,t2.c1 FROM t1 NATURAL LEFT OUTER JOIN t2 ORDER BY t1.c1,t2.c1; 51-- sorted_result 52SELECT t1.c1,t2.c1 FROM t1 NATURAL LEFT OUTER JOIN t2 WHERE t1.c1 < 5 ORDER BY t1.c1,t2.c1; 53DROP TABLE t1,t2,t3,t4,t5,t6; 54CREATE TABLE t1 (c1 INT NOT NULL); 55CREATE TABLE t2 (c1 INT NOT NULL); 56CREATE TABLE t3 (c1 INT NOT NULL); 57CREATE TABLE t4 (c1 INT NOT NULL); 58CREATE TABLE t5 (c1 INT NOT NULL); 59CREATE TABLE t6 (c1 INT NOT NULL); 60INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 61INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 62INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 63INSERT INTO t4 (c1) VALUES(10); 64INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 65-- sorted_result 66SELECT t1.c1,t2.c1 FROM t1 NATURAL LEFT OUTER JOIN t2 ORDER BY t1.c1,t2.c1; 67-- sorted_result 68SELECT t1.c1,t2.c1 FROM t1 NATURAL LEFT OUTER JOIN t2 WHERE t1.c1 < 5 ORDER BY t1.c1,t2.c1; 69DROP TABLE t1,t2,t3,t4,t5,t6; 70CREATE TABLE t1 (c1 INTEGER NOT NULL); 71CREATE TABLE t2 (c1 INTEGER NOT NULL); 72CREATE TABLE t3 (c1 INTEGER NOT NULL); 73CREATE TABLE t4 (c1 INTEGER NOT NULL); 74CREATE TABLE t5 (c1 INTEGER NOT NULL); 75CREATE TABLE t6 (c1 INTEGER NOT NULL); 76INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 77INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 78INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 79INSERT INTO t4 (c1) VALUES(10); 80INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 81-- sorted_result 82SELECT t1.c1,t2.c1 FROM t1 NATURAL LEFT OUTER JOIN t2 ORDER BY t1.c1,t2.c1; 83-- sorted_result 84SELECT t1.c1,t2.c1 FROM t1 NATURAL LEFT OUTER JOIN t2 WHERE t1.c1 < 5 ORDER BY t1.c1,t2.c1; 85DROP TABLE t1,t2,t3,t4,t5,t6; 86CREATE TABLE t1 (c1 BIGINT NOT NULL); 87CREATE TABLE t2 (c1 BIGINT NOT NULL); 88CREATE TABLE t3 (c1 BIGINT NOT NULL); 89CREATE TABLE t4 (c1 BIGINT NOT NULL); 90CREATE TABLE t5 (c1 BIGINT NOT NULL); 91CREATE TABLE t6 (c1 BIGINT NOT NULL); 92INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 93INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 94INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 95INSERT INTO t4 (c1) VALUES(10); 96INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 97-- sorted_result 98SELECT t1.c1,t2.c1 FROM t1 NATURAL LEFT OUTER JOIN t2 ORDER BY t1.c1,t2.c1; 99-- sorted_result 100SELECT t1.c1,t2.c1 FROM t1 NATURAL LEFT OUTER JOIN t2 WHERE t1.c1 < 5 ORDER BY t1.c1,t2.c1; 101DROP TABLE t1,t2,t3,t4,t5,t6; 102CREATE TABLE t1 (c1 TINYINT NOT NULL); 103CREATE TABLE t2 (c1 TINYINT NOT NULL); 104CREATE TABLE t3 (c1 TINYINT NOT NULL); 105CREATE TABLE t4 (c1 TINYINT NOT NULL); 106CREATE TABLE t5 (c1 TINYINT NOT NULL); 107CREATE TABLE t6 (c1 TINYINT NOT NULL); 108INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 109INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 110INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 111INSERT INTO t4 (c1) VALUES(10); 112INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 113-- sorted_result 114SELECT t1.c1,t3.c1 FROM t1 NATURAL LEFT OUTER JOIN t3 ORDER BY t1.c1,t3.c1; 115-- sorted_result 116SELECT t1.c1,t3.c1 FROM t1 NATURAL LEFT OUTER JOIN t3 WHERE t1.c1 < 5 ORDER BY t1.c1,t3.c1; 117DROP TABLE t1,t2,t3,t4,t5,t6; 118CREATE TABLE t1 (c1 SMALLINT NOT NULL); 119CREATE TABLE t2 (c1 SMALLINT NOT NULL); 120CREATE TABLE t3 (c1 SMALLINT NOT NULL); 121CREATE TABLE t4 (c1 SMALLINT NOT NULL); 122CREATE TABLE t5 (c1 SMALLINT NOT NULL); 123CREATE TABLE t6 (c1 SMALLINT NOT NULL); 124INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 125INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 126INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 127INSERT INTO t4 (c1) VALUES(10); 128INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 129-- sorted_result 130SELECT t1.c1,t3.c1 FROM t1 NATURAL LEFT OUTER JOIN t3 ORDER BY t1.c1,t3.c1; 131-- sorted_result 132SELECT t1.c1,t3.c1 FROM t1 NATURAL LEFT OUTER JOIN t3 WHERE t1.c1 < 5 ORDER BY t1.c1,t3.c1; 133DROP TABLE t1,t2,t3,t4,t5,t6; 134CREATE TABLE t1 (c1 MEDIUMINT NOT NULL); 135CREATE TABLE t2 (c1 MEDIUMINT NOT NULL); 136CREATE TABLE t3 (c1 MEDIUMINT NOT NULL); 137CREATE TABLE t4 (c1 MEDIUMINT NOT NULL); 138CREATE TABLE t5 (c1 MEDIUMINT NOT NULL); 139CREATE TABLE t6 (c1 MEDIUMINT NOT NULL); 140INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 141INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 142INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 143INSERT INTO t4 (c1) VALUES(10); 144INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 145-- sorted_result 146SELECT t1.c1,t3.c1 FROM t1 NATURAL LEFT OUTER JOIN t3 ORDER BY t1.c1,t3.c1; 147-- sorted_result 148SELECT t1.c1,t3.c1 FROM t1 NATURAL LEFT OUTER JOIN t3 WHERE t1.c1 < 5 ORDER BY t1.c1,t3.c1; 149DROP TABLE t1,t2,t3,t4,t5,t6; 150CREATE TABLE t1 (c1 INT NOT NULL); 151CREATE TABLE t2 (c1 INT NOT NULL); 152CREATE TABLE t3 (c1 INT NOT NULL); 153CREATE TABLE t4 (c1 INT NOT NULL); 154CREATE TABLE t5 (c1 INT NOT NULL); 155CREATE TABLE t6 (c1 INT NOT NULL); 156INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 157INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 158INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 159INSERT INTO t4 (c1) VALUES(10); 160INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 161-- sorted_result 162SELECT t1.c1,t3.c1 FROM t1 NATURAL LEFT OUTER JOIN t3 ORDER BY t1.c1,t3.c1; 163-- sorted_result 164SELECT t1.c1,t3.c1 FROM t1 NATURAL LEFT OUTER JOIN t3 WHERE t1.c1 < 5 ORDER BY t1.c1,t3.c1; 165DROP TABLE t1,t2,t3,t4,t5,t6; 166CREATE TABLE t1 (c1 INTEGER NOT NULL); 167CREATE TABLE t2 (c1 INTEGER NOT NULL); 168CREATE TABLE t3 (c1 INTEGER NOT NULL); 169CREATE TABLE t4 (c1 INTEGER NOT NULL); 170CREATE TABLE t5 (c1 INTEGER NOT NULL); 171CREATE TABLE t6 (c1 INTEGER NOT NULL); 172INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 173INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 174INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 175INSERT INTO t4 (c1) VALUES(10); 176INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 177-- sorted_result 178SELECT t1.c1,t3.c1 FROM t1 NATURAL LEFT OUTER JOIN t3 ORDER BY t1.c1,t3.c1; 179-- sorted_result 180SELECT t1.c1,t3.c1 FROM t1 NATURAL LEFT OUTER JOIN t3 WHERE t1.c1 < 5 ORDER BY t1.c1,t3.c1; 181DROP TABLE t1,t2,t3,t4,t5,t6; 182CREATE TABLE t1 (c1 BIGINT NOT NULL); 183CREATE TABLE t2 (c1 BIGINT NOT NULL); 184CREATE TABLE t3 (c1 BIGINT NOT NULL); 185CREATE TABLE t4 (c1 BIGINT NOT NULL); 186CREATE TABLE t5 (c1 BIGINT NOT NULL); 187CREATE TABLE t6 (c1 BIGINT NOT NULL); 188INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 189INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 190INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 191INSERT INTO t4 (c1) VALUES(10); 192INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 193-- sorted_result 194SELECT t1.c1,t3.c1 FROM t1 NATURAL LEFT OUTER JOIN t3 ORDER BY t1.c1,t3.c1; 195-- sorted_result 196SELECT t1.c1,t3.c1 FROM t1 NATURAL LEFT OUTER JOIN t3 WHERE t1.c1 < 5 ORDER BY t1.c1,t3.c1; 197DROP TABLE t1,t2,t3,t4,t5,t6; 198CREATE TABLE t1 (c1 TINYINT NOT NULL); 199CREATE TABLE t2 (c1 TINYINT NOT NULL); 200CREATE TABLE t3 (c1 TINYINT NOT NULL); 201CREATE TABLE t4 (c1 TINYINT NOT NULL); 202CREATE TABLE t5 (c1 TINYINT NOT NULL); 203CREATE TABLE t6 (c1 TINYINT NOT NULL); 204INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 205INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 206INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 207INSERT INTO t4 (c1) VALUES(10); 208INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 209-- sorted_result 210SELECT t1.c1,t4.c1 FROM t1 NATURAL LEFT OUTER JOIN t4 ORDER BY t1.c1,t4.c1; 211-- sorted_result 212SELECT t1.c1,t4.c1 FROM t1 NATURAL LEFT OUTER JOIN t4 WHERE t1.c1 < 5 ORDER BY t1.c1,t4.c1; 213DROP TABLE t1,t2,t3,t4,t5,t6; 214CREATE TABLE t1 (c1 SMALLINT NOT NULL); 215CREATE TABLE t2 (c1 SMALLINT NOT NULL); 216CREATE TABLE t3 (c1 SMALLINT NOT NULL); 217CREATE TABLE t4 (c1 SMALLINT NOT NULL); 218CREATE TABLE t5 (c1 SMALLINT NOT NULL); 219CREATE TABLE t6 (c1 SMALLINT NOT NULL); 220INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 221INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 222INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 223INSERT INTO t4 (c1) VALUES(10); 224INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 225-- sorted_result 226SELECT t1.c1,t4.c1 FROM t1 NATURAL LEFT OUTER JOIN t4 ORDER BY t1.c1,t4.c1; 227-- sorted_result 228SELECT t1.c1,t4.c1 FROM t1 NATURAL LEFT OUTER JOIN t4 WHERE t1.c1 < 5 ORDER BY t1.c1,t4.c1; 229DROP TABLE t1,t2,t3,t4,t5,t6; 230CREATE TABLE t1 (c1 MEDIUMINT NOT NULL); 231CREATE TABLE t2 (c1 MEDIUMINT NOT NULL); 232CREATE TABLE t3 (c1 MEDIUMINT NOT NULL); 233CREATE TABLE t4 (c1 MEDIUMINT NOT NULL); 234CREATE TABLE t5 (c1 MEDIUMINT NOT NULL); 235CREATE TABLE t6 (c1 MEDIUMINT NOT NULL); 236INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 237INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 238INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 239INSERT INTO t4 (c1) VALUES(10); 240INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 241-- sorted_result 242SELECT t1.c1,t4.c1 FROM t1 NATURAL LEFT OUTER JOIN t4 ORDER BY t1.c1,t4.c1; 243-- sorted_result 244SELECT t1.c1,t4.c1 FROM t1 NATURAL LEFT OUTER JOIN t4 WHERE t1.c1 < 5 ORDER BY t1.c1,t4.c1; 245DROP TABLE t1,t2,t3,t4,t5,t6; 246CREATE TABLE t1 (c1 INT NOT NULL); 247CREATE TABLE t2 (c1 INT NOT NULL); 248CREATE TABLE t3 (c1 INT NOT NULL); 249CREATE TABLE t4 (c1 INT NOT NULL); 250CREATE TABLE t5 (c1 INT NOT NULL); 251CREATE TABLE t6 (c1 INT NOT NULL); 252INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 253INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 254INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 255INSERT INTO t4 (c1) VALUES(10); 256INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 257-- sorted_result 258SELECT t1.c1,t4.c1 FROM t1 NATURAL LEFT OUTER JOIN t4 ORDER BY t1.c1,t4.c1; 259-- sorted_result 260SELECT t1.c1,t4.c1 FROM t1 NATURAL LEFT OUTER JOIN t4 WHERE t1.c1 < 5 ORDER BY t1.c1,t4.c1; 261DROP TABLE t1,t2,t3,t4,t5,t6; 262CREATE TABLE t1 (c1 INTEGER NOT NULL); 263CREATE TABLE t2 (c1 INTEGER NOT NULL); 264CREATE TABLE t3 (c1 INTEGER NOT NULL); 265CREATE TABLE t4 (c1 INTEGER NOT NULL); 266CREATE TABLE t5 (c1 INTEGER NOT NULL); 267CREATE TABLE t6 (c1 INTEGER NOT NULL); 268INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 269INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 270INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 271INSERT INTO t4 (c1) VALUES(10); 272INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 273-- sorted_result 274SELECT t1.c1,t4.c1 FROM t1 NATURAL LEFT OUTER JOIN t4 ORDER BY t1.c1,t4.c1; 275-- sorted_result 276SELECT t1.c1,t4.c1 FROM t1 NATURAL LEFT OUTER JOIN t4 WHERE t1.c1 < 5 ORDER BY t1.c1,t4.c1; 277DROP TABLE t1,t2,t3,t4,t5,t6; 278CREATE TABLE t1 (c1 BIGINT NOT NULL); 279CREATE TABLE t2 (c1 BIGINT NOT NULL); 280CREATE TABLE t3 (c1 BIGINT NOT NULL); 281CREATE TABLE t4 (c1 BIGINT NOT NULL); 282CREATE TABLE t5 (c1 BIGINT NOT NULL); 283CREATE TABLE t6 (c1 BIGINT NOT NULL); 284INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 285INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 286INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 287INSERT INTO t4 (c1) VALUES(10); 288INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 289-- sorted_result 290SELECT t1.c1,t4.c1 FROM t1 NATURAL LEFT OUTER JOIN t4 ORDER BY t1.c1,t4.c1; 291-- sorted_result 292SELECT t1.c1,t4.c1 FROM t1 NATURAL LEFT OUTER JOIN t4 WHERE t1.c1 < 5 ORDER BY t1.c1,t4.c1; 293DROP TABLE t1,t2,t3,t4,t5,t6; 294CREATE TABLE t1 (c1 TINYINT NOT NULL); 295CREATE TABLE t2 (c1 TINYINT NOT NULL); 296CREATE TABLE t3 (c1 TINYINT NOT NULL); 297CREATE TABLE t4 (c1 TINYINT NOT NULL); 298CREATE TABLE t5 (c1 TINYINT NOT NULL); 299CREATE TABLE t6 (c1 TINYINT NOT NULL); 300INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 301INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 302INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 303INSERT INTO t4 (c1) VALUES(10); 304INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 305-- sorted_result 306SELECT t1.c1,t5.c1 FROM t1 NATURAL LEFT OUTER JOIN t5 ORDER BY t1.c1,t5.c1; 307-- sorted_result 308SELECT t1.c1,t5.c1 FROM t1 NATURAL LEFT OUTER JOIN t5 WHERE t1.c1 < 5 ORDER BY t1.c1,t5.c1; 309DROP TABLE t1,t2,t3,t4,t5,t6; 310CREATE TABLE t1 (c1 SMALLINT NOT NULL); 311CREATE TABLE t2 (c1 SMALLINT NOT NULL); 312CREATE TABLE t3 (c1 SMALLINT NOT NULL); 313CREATE TABLE t4 (c1 SMALLINT NOT NULL); 314CREATE TABLE t5 (c1 SMALLINT NOT NULL); 315CREATE TABLE t6 (c1 SMALLINT NOT NULL); 316INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 317INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 318INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 319INSERT INTO t4 (c1) VALUES(10); 320INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 321-- sorted_result 322SELECT t1.c1,t5.c1 FROM t1 NATURAL LEFT OUTER JOIN t5 ORDER BY t1.c1,t5.c1; 323-- sorted_result 324SELECT t1.c1,t5.c1 FROM t1 NATURAL LEFT OUTER JOIN t5 WHERE t1.c1 < 5 ORDER BY t1.c1,t5.c1; 325DROP TABLE t1,t2,t3,t4,t5,t6; 326CREATE TABLE t1 (c1 MEDIUMINT NOT NULL); 327CREATE TABLE t2 (c1 MEDIUMINT NOT NULL); 328CREATE TABLE t3 (c1 MEDIUMINT NOT NULL); 329CREATE TABLE t4 (c1 MEDIUMINT NOT NULL); 330CREATE TABLE t5 (c1 MEDIUMINT NOT NULL); 331CREATE TABLE t6 (c1 MEDIUMINT 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); 337-- sorted_result 338SELECT t1.c1,t5.c1 FROM t1 NATURAL LEFT OUTER JOIN t5 ORDER BY t1.c1,t5.c1; 339-- sorted_result 340SELECT t1.c1,t5.c1 FROM t1 NATURAL LEFT OUTER JOIN t5 WHERE t1.c1 < 5 ORDER BY t1.c1,t5.c1; 341DROP TABLE t1,t2,t3,t4,t5,t6; 342CREATE TABLE t1 (c1 INT NOT NULL); 343CREATE TABLE t2 (c1 INT NOT NULL); 344CREATE TABLE t3 (c1 INT NOT NULL); 345CREATE TABLE t4 (c1 INT NOT NULL); 346CREATE TABLE t5 (c1 INT NOT NULL); 347CREATE TABLE t6 (c1 INT 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); 353-- sorted_result 354SELECT t1.c1,t5.c1 FROM t1 NATURAL LEFT OUTER JOIN t5 ORDER BY t1.c1,t5.c1; 355-- sorted_result 356SELECT t1.c1,t5.c1 FROM t1 NATURAL LEFT OUTER JOIN t5 WHERE t1.c1 < 5 ORDER BY t1.c1,t5.c1; 357DROP TABLE t1,t2,t3,t4,t5,t6; 358CREATE TABLE t1 (c1 INTEGER NOT NULL); 359CREATE TABLE t2 (c1 INTEGER NOT NULL); 360CREATE TABLE t3 (c1 INTEGER NOT NULL); 361CREATE TABLE t4 (c1 INTEGER NOT NULL); 362CREATE TABLE t5 (c1 INTEGER NOT NULL); 363CREATE TABLE t6 (c1 INTEGER 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); 369-- sorted_result 370SELECT t1.c1,t5.c1 FROM t1 NATURAL LEFT OUTER JOIN t5 ORDER BY t1.c1,t5.c1; 371-- sorted_result 372SELECT t1.c1,t5.c1 FROM t1 NATURAL LEFT OUTER JOIN t5 WHERE t1.c1 < 5 ORDER BY t1.c1,t5.c1; 373DROP TABLE t1,t2,t3,t4,t5,t6; 374CREATE TABLE t1 (c1 BIGINT NOT NULL); 375CREATE TABLE t2 (c1 BIGINT NOT NULL); 376CREATE TABLE t3 (c1 BIGINT NOT NULL); 377CREATE TABLE t4 (c1 BIGINT NOT NULL); 378CREATE TABLE t5 (c1 BIGINT NOT NULL); 379CREATE TABLE t6 (c1 BIGINT 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); 385-- sorted_result 386SELECT t1.c1,t5.c1 FROM t1 NATURAL LEFT OUTER JOIN t5 ORDER BY t1.c1,t5.c1; 387-- sorted_result 388SELECT t1.c1,t5.c1 FROM t1 NATURAL LEFT OUTER JOIN t5 WHERE t1.c1 < 5 ORDER BY t1.c1,t5.c1; 389DROP TABLE t1,t2,t3,t4,t5,t6; 390CREATE TABLE t1 (c1 TINYINT NOT NULL); 391CREATE TABLE t2 (c1 TINYINT NOT NULL); 392CREATE TABLE t3 (c1 TINYINT NOT NULL); 393CREATE TABLE t4 (c1 TINYINT NOT NULL); 394CREATE TABLE t5 (c1 TINYINT NOT NULL); 395CREATE TABLE t6 (c1 TINYINT 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); 401-- sorted_result 402SELECT t1.c1,t6.c1 FROM t1 NATURAL LEFT OUTER JOIN t6 ORDER BY t1.c1,t6.c1; 403-- sorted_result 404SELECT t1.c1,t6.c1 FROM t1 NATURAL LEFT OUTER JOIN t6 WHERE t1.c1 < 5 ORDER BY t1.c1,t6.c1; 405DROP TABLE t1,t2,t3,t4,t5,t6; 406CREATE TABLE t1 (c1 SMALLINT NOT NULL); 407CREATE TABLE t2 (c1 SMALLINT NOT NULL); 408CREATE TABLE t3 (c1 SMALLINT NOT NULL); 409CREATE TABLE t4 (c1 SMALLINT NOT NULL); 410CREATE TABLE t5 (c1 SMALLINT NOT NULL); 411CREATE TABLE t6 (c1 SMALLINT 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); 417-- sorted_result 418SELECT t1.c1,t6.c1 FROM t1 NATURAL LEFT OUTER JOIN t6 ORDER BY t1.c1,t6.c1; 419-- sorted_result 420SELECT t1.c1,t6.c1 FROM t1 NATURAL LEFT OUTER JOIN t6 WHERE t1.c1 < 5 ORDER BY t1.c1,t6.c1; 421DROP TABLE t1,t2,t3,t4,t5,t6; 422CREATE TABLE t1 (c1 MEDIUMINT NOT NULL); 423CREATE TABLE t2 (c1 MEDIUMINT NOT NULL); 424CREATE TABLE t3 (c1 MEDIUMINT NOT NULL); 425CREATE TABLE t4 (c1 MEDIUMINT NOT NULL); 426CREATE TABLE t5 (c1 MEDIUMINT NOT NULL); 427CREATE TABLE t6 (c1 MEDIUMINT 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); 433-- sorted_result 434SELECT t1.c1,t6.c1 FROM t1 NATURAL LEFT OUTER JOIN t6 ORDER BY t1.c1,t6.c1; 435-- sorted_result 436SELECT t1.c1,t6.c1 FROM t1 NATURAL LEFT OUTER JOIN t6 WHERE t1.c1 < 5 ORDER BY t1.c1,t6.c1; 437DROP TABLE t1,t2,t3,t4,t5,t6; 438CREATE TABLE t1 (c1 INT NOT NULL); 439CREATE TABLE t2 (c1 INT NOT NULL); 440CREATE TABLE t3 (c1 INT NOT NULL); 441CREATE TABLE t4 (c1 INT NOT NULL); 442CREATE TABLE t5 (c1 INT NOT NULL); 443CREATE TABLE t6 (c1 INT 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); 449-- sorted_result 450SELECT t1.c1,t6.c1 FROM t1 NATURAL LEFT OUTER JOIN t6 ORDER BY t1.c1,t6.c1; 451-- sorted_result 452SELECT t1.c1,t6.c1 FROM t1 NATURAL LEFT OUTER JOIN t6 WHERE t1.c1 < 5 ORDER BY t1.c1,t6.c1; 453DROP TABLE t1,t2,t3,t4,t5,t6; 454CREATE TABLE t1 (c1 INTEGER NOT NULL); 455CREATE TABLE t2 (c1 INTEGER NOT NULL); 456CREATE TABLE t3 (c1 INTEGER NOT NULL); 457CREATE TABLE t4 (c1 INTEGER NOT NULL); 458CREATE TABLE t5 (c1 INTEGER NOT NULL); 459CREATE TABLE t6 (c1 INTEGER 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); 465-- sorted_result 466SELECT t1.c1,t6.c1 FROM t1 NATURAL LEFT OUTER JOIN t6 ORDER BY t1.c1,t6.c1; 467-- sorted_result 468SELECT t1.c1,t6.c1 FROM t1 NATURAL LEFT OUTER JOIN t6 WHERE t1.c1 < 5 ORDER BY t1.c1,t6.c1; 469DROP TABLE t1,t2,t3,t4,t5,t6; 470CREATE TABLE t1 (c1 BIGINT NOT NULL); 471CREATE TABLE t2 (c1 BIGINT NOT NULL); 472CREATE TABLE t3 (c1 BIGINT NOT NULL); 473CREATE TABLE t4 (c1 BIGINT NOT NULL); 474CREATE TABLE t5 (c1 BIGINT NOT NULL); 475CREATE TABLE t6 (c1 BIGINT 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); 481-- sorted_result 482SELECT t1.c1,t6.c1 FROM t1 NATURAL LEFT OUTER JOIN t6 ORDER BY t1.c1,t6.c1; 483-- sorted_result 484SELECT t1.c1,t6.c1 FROM t1 NATURAL LEFT OUTER JOIN t6 WHERE t1.c1 < 5 ORDER BY t1.c1,t6.c1; 485DROP TABLE t1,t2,t3,t4,t5,t6; 486CREATE TABLE t1 (c1 TINYINT NOT NULL); 487CREATE TABLE t2 (c1 TINYINT NOT NULL); 488CREATE TABLE t3 (c1 TINYINT NOT NULL); 489CREATE TABLE t4 (c1 TINYINT NOT NULL); 490CREATE TABLE t5 (c1 TINYINT NOT NULL); 491CREATE TABLE t6 (c1 TINYINT 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); 497-- sorted_result 498SELECT t1.c1,t2.c1 FROM t1 NATURAL LEFT OUTER JOIN t2 ORDER BY t1.c1,t2.c1; 499-- sorted_result 500SELECT t1.c1,t2.c1 FROM t1 NATURAL LEFT OUTER JOIN t2 WHERE t1.c1 <= 5 ORDER BY t1.c1,t2.c1; 501DROP TABLE t1,t2,t3,t4,t5,t6; 502CREATE TABLE t1 (c1 SMALLINT NOT NULL); 503CREATE TABLE t2 (c1 SMALLINT NOT NULL); 504CREATE TABLE t3 (c1 SMALLINT NOT NULL); 505CREATE TABLE t4 (c1 SMALLINT NOT NULL); 506CREATE TABLE t5 (c1 SMALLINT NOT NULL); 507CREATE TABLE t6 (c1 SMALLINT 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); 513-- sorted_result 514SELECT t1.c1,t2.c1 FROM t1 NATURAL LEFT OUTER JOIN t2 ORDER BY t1.c1,t2.c1; 515-- sorted_result 516SELECT t1.c1,t2.c1 FROM t1 NATURAL LEFT OUTER JOIN t2 WHERE t1.c1 <= 5 ORDER BY t1.c1,t2.c1; 517DROP TABLE t1,t2,t3,t4,t5,t6; 518CREATE TABLE t1 (c1 MEDIUMINT NOT NULL); 519CREATE TABLE t2 (c1 MEDIUMINT NOT NULL); 520CREATE TABLE t3 (c1 MEDIUMINT NOT NULL); 521CREATE TABLE t4 (c1 MEDIUMINT NOT NULL); 522CREATE TABLE t5 (c1 MEDIUMINT NOT NULL); 523CREATE TABLE t6 (c1 MEDIUMINT 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); 529-- sorted_result 530SELECT t1.c1,t2.c1 FROM t1 NATURAL LEFT OUTER JOIN t2 ORDER BY t1.c1,t2.c1; 531-- sorted_result 532SELECT t1.c1,t2.c1 FROM t1 NATURAL LEFT OUTER JOIN t2 WHERE t1.c1 <= 5 ORDER BY t1.c1,t2.c1; 533DROP TABLE t1,t2,t3,t4,t5,t6; 534CREATE TABLE t1 (c1 INT NOT NULL); 535CREATE TABLE t2 (c1 INT NOT NULL); 536CREATE TABLE t3 (c1 INT NOT NULL); 537CREATE TABLE t4 (c1 INT NOT NULL); 538CREATE TABLE t5 (c1 INT NOT NULL); 539CREATE TABLE t6 (c1 INT 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); 545-- sorted_result 546SELECT t1.c1,t2.c1 FROM t1 NATURAL LEFT OUTER JOIN t2 ORDER BY t1.c1,t2.c1; 547-- sorted_result 548SELECT t1.c1,t2.c1 FROM t1 NATURAL LEFT OUTER JOIN t2 WHERE t1.c1 <= 5 ORDER BY t1.c1,t2.c1; 549DROP TABLE t1,t2,t3,t4,t5,t6; 550CREATE TABLE t1 (c1 INTEGER NOT NULL); 551CREATE TABLE t2 (c1 INTEGER NOT NULL); 552CREATE TABLE t3 (c1 INTEGER NOT NULL); 553CREATE TABLE t4 (c1 INTEGER NOT NULL); 554CREATE TABLE t5 (c1 INTEGER NOT NULL); 555CREATE TABLE t6 (c1 INTEGER 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); 561-- sorted_result 562SELECT t1.c1,t2.c1 FROM t1 NATURAL LEFT OUTER JOIN t2 ORDER BY t1.c1,t2.c1; 563-- sorted_result 564SELECT t1.c1,t2.c1 FROM t1 NATURAL LEFT OUTER JOIN t2 WHERE t1.c1 <= 5 ORDER BY t1.c1,t2.c1; 565DROP TABLE t1,t2,t3,t4,t5,t6; 566CREATE TABLE t1 (c1 BIGINT NOT NULL); 567CREATE TABLE t2 (c1 BIGINT NOT NULL); 568CREATE TABLE t3 (c1 BIGINT NOT NULL); 569CREATE TABLE t4 (c1 BIGINT NOT NULL); 570CREATE TABLE t5 (c1 BIGINT NOT NULL); 571CREATE TABLE t6 (c1 BIGINT 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); 577-- sorted_result 578SELECT t1.c1,t2.c1 FROM t1 NATURAL LEFT OUTER JOIN t2 ORDER BY t1.c1,t2.c1; 579-- sorted_result 580SELECT t1.c1,t2.c1 FROM t1 NATURAL LEFT OUTER JOIN t2 WHERE t1.c1 <= 5 ORDER BY t1.c1,t2.c1; 581DROP TABLE t1,t2,t3,t4,t5,t6; 582CREATE TABLE t1 (c1 TINYINT NOT NULL); 583CREATE TABLE t2 (c1 TINYINT NOT NULL); 584CREATE TABLE t3 (c1 TINYINT NOT NULL); 585CREATE TABLE t4 (c1 TINYINT NOT NULL); 586CREATE TABLE t5 (c1 TINYINT NOT NULL); 587CREATE TABLE t6 (c1 TINYINT 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); 593-- sorted_result 594SELECT t1.c1,t3.c1 FROM t1 NATURAL LEFT OUTER JOIN t3 ORDER BY t1.c1,t3.c1; 595-- sorted_result 596SELECT t1.c1,t3.c1 FROM t1 NATURAL LEFT OUTER JOIN t3 WHERE t1.c1 <= 5 ORDER BY t1.c1,t3.c1; 597DROP TABLE t1,t2,t3,t4,t5,t6; 598CREATE TABLE t1 (c1 SMALLINT NOT NULL); 599CREATE TABLE t2 (c1 SMALLINT NOT NULL); 600CREATE TABLE t3 (c1 SMALLINT NOT NULL); 601CREATE TABLE t4 (c1 SMALLINT NOT NULL); 602CREATE TABLE t5 (c1 SMALLINT NOT NULL); 603CREATE TABLE t6 (c1 SMALLINT 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); 609-- sorted_result 610SELECT t1.c1,t3.c1 FROM t1 NATURAL LEFT OUTER JOIN t3 ORDER BY t1.c1,t3.c1; 611-- sorted_result 612SELECT t1.c1,t3.c1 FROM t1 NATURAL LEFT OUTER JOIN t3 WHERE t1.c1 <= 5 ORDER BY t1.c1,t3.c1; 613DROP TABLE t1,t2,t3,t4,t5,t6; 614CREATE TABLE t1 (c1 MEDIUMINT NOT NULL); 615CREATE TABLE t2 (c1 MEDIUMINT NOT NULL); 616CREATE TABLE t3 (c1 MEDIUMINT NOT NULL); 617CREATE TABLE t4 (c1 MEDIUMINT NOT NULL); 618CREATE TABLE t5 (c1 MEDIUMINT NOT NULL); 619CREATE TABLE t6 (c1 MEDIUMINT 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); 625-- sorted_result 626SELECT t1.c1,t3.c1 FROM t1 NATURAL LEFT OUTER JOIN t3 ORDER BY t1.c1,t3.c1; 627-- sorted_result 628SELECT t1.c1,t3.c1 FROM t1 NATURAL LEFT OUTER JOIN t3 WHERE t1.c1 <= 5 ORDER BY t1.c1,t3.c1; 629DROP TABLE t1,t2,t3,t4,t5,t6; 630CREATE TABLE t1 (c1 INT NOT NULL); 631CREATE TABLE t2 (c1 INT NOT NULL); 632CREATE TABLE t3 (c1 INT NOT NULL); 633CREATE TABLE t4 (c1 INT NOT NULL); 634CREATE TABLE t5 (c1 INT NOT NULL); 635CREATE TABLE t6 (c1 INT NOT NULL); 636INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 637INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 638INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 639INSERT INTO t4 (c1) VALUES(10); 640INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 641-- sorted_result 642SELECT t1.c1,t3.c1 FROM t1 NATURAL LEFT OUTER JOIN t3 ORDER BY t1.c1,t3.c1; 643-- sorted_result 644SELECT t1.c1,t3.c1 FROM t1 NATURAL LEFT OUTER JOIN t3 WHERE t1.c1 <= 5 ORDER BY t1.c1,t3.c1; 645DROP TABLE t1,t2,t3,t4,t5,t6; 646CREATE TABLE t1 (c1 INTEGER NOT NULL); 647CREATE TABLE t2 (c1 INTEGER NOT NULL); 648CREATE TABLE t3 (c1 INTEGER NOT NULL); 649CREATE TABLE t4 (c1 INTEGER NOT NULL); 650CREATE TABLE t5 (c1 INTEGER NOT NULL); 651CREATE TABLE t6 (c1 INTEGER 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); 657-- sorted_result 658SELECT t1.c1,t3.c1 FROM t1 NATURAL LEFT OUTER JOIN t3 ORDER BY t1.c1,t3.c1; 659-- sorted_result 660SELECT t1.c1,t3.c1 FROM t1 NATURAL LEFT OUTER JOIN t3 WHERE t1.c1 <= 5 ORDER BY t1.c1,t3.c1; 661DROP TABLE t1,t2,t3,t4,t5,t6; 662CREATE TABLE t1 (c1 BIGINT NOT NULL); 663CREATE TABLE t2 (c1 BIGINT NOT NULL); 664CREATE TABLE t3 (c1 BIGINT NOT NULL); 665CREATE TABLE t4 (c1 BIGINT NOT NULL); 666CREATE TABLE t5 (c1 BIGINT NOT NULL); 667CREATE TABLE t6 (c1 BIGINT NOT NULL); 668INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 669INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 670INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 671INSERT INTO t4 (c1) VALUES(10); 672INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 673-- sorted_result 674SELECT t1.c1,t3.c1 FROM t1 NATURAL LEFT OUTER JOIN t3 ORDER BY t1.c1,t3.c1; 675-- sorted_result 676SELECT t1.c1,t3.c1 FROM t1 NATURAL LEFT OUTER JOIN t3 WHERE t1.c1 <= 5 ORDER BY t1.c1,t3.c1; 677DROP TABLE t1,t2,t3,t4,t5,t6; 678CREATE TABLE t1 (c1 TINYINT NOT NULL); 679CREATE TABLE t2 (c1 TINYINT NOT NULL); 680CREATE TABLE t3 (c1 TINYINT NOT NULL); 681CREATE TABLE t4 (c1 TINYINT NOT NULL); 682CREATE TABLE t5 (c1 TINYINT NOT NULL); 683CREATE TABLE t6 (c1 TINYINT 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); 689-- sorted_result 690SELECT t1.c1,t4.c1 FROM t1 NATURAL LEFT OUTER JOIN t4 ORDER BY t1.c1,t4.c1; 691-- sorted_result 692SELECT t1.c1,t4.c1 FROM t1 NATURAL LEFT OUTER JOIN t4 WHERE t1.c1 <= 5 ORDER BY t1.c1,t4.c1; 693DROP TABLE t1,t2,t3,t4,t5,t6; 694CREATE TABLE t1 (c1 SMALLINT NOT NULL); 695CREATE TABLE t2 (c1 SMALLINT NOT NULL); 696CREATE TABLE t3 (c1 SMALLINT NOT NULL); 697CREATE TABLE t4 (c1 SMALLINT NOT NULL); 698CREATE TABLE t5 (c1 SMALLINT NOT NULL); 699CREATE TABLE t6 (c1 SMALLINT NOT NULL); 700INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 701INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 702INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 703INSERT INTO t4 (c1) VALUES(10); 704INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 705-- sorted_result 706SELECT t1.c1,t4.c1 FROM t1 NATURAL LEFT OUTER JOIN t4 ORDER BY t1.c1,t4.c1; 707-- sorted_result 708SELECT t1.c1,t4.c1 FROM t1 NATURAL LEFT OUTER JOIN t4 WHERE t1.c1 <= 5 ORDER BY t1.c1,t4.c1; 709DROP TABLE t1,t2,t3,t4,t5,t6; 710CREATE TABLE t1 (c1 MEDIUMINT NOT NULL); 711CREATE TABLE t2 (c1 MEDIUMINT NOT NULL); 712CREATE TABLE t3 (c1 MEDIUMINT NOT NULL); 713CREATE TABLE t4 (c1 MEDIUMINT NOT NULL); 714CREATE TABLE t5 (c1 MEDIUMINT NOT NULL); 715CREATE TABLE t6 (c1 MEDIUMINT 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); 721-- sorted_result 722SELECT t1.c1,t4.c1 FROM t1 NATURAL LEFT OUTER JOIN t4 ORDER BY t1.c1,t4.c1; 723-- sorted_result 724SELECT t1.c1,t4.c1 FROM t1 NATURAL LEFT OUTER JOIN t4 WHERE t1.c1 <= 5 ORDER BY t1.c1,t4.c1; 725DROP TABLE t1,t2,t3,t4,t5,t6; 726CREATE TABLE t1 (c1 INT NOT NULL); 727CREATE TABLE t2 (c1 INT NOT NULL); 728CREATE TABLE t3 (c1 INT NOT NULL); 729CREATE TABLE t4 (c1 INT NOT NULL); 730CREATE TABLE t5 (c1 INT NOT NULL); 731CREATE TABLE t6 (c1 INT NOT NULL); 732INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 733INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 734INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 735INSERT INTO t4 (c1) VALUES(10); 736INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 737-- sorted_result 738SELECT t1.c1,t4.c1 FROM t1 NATURAL LEFT OUTER JOIN t4 ORDER BY t1.c1,t4.c1; 739-- sorted_result 740SELECT t1.c1,t4.c1 FROM t1 NATURAL LEFT OUTER JOIN t4 WHERE t1.c1 <= 5 ORDER BY t1.c1,t4.c1; 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); 753-- sorted_result 754SELECT t1.c1,t4.c1 FROM t1 NATURAL LEFT OUTER JOIN t4 ORDER BY t1.c1,t4.c1; 755-- sorted_result 756SELECT t1.c1,t4.c1 FROM t1 NATURAL LEFT OUTER JOIN t4 WHERE t1.c1 <= 5 ORDER BY t1.c1,t4.c1; 757DROP TABLE t1,t2,t3,t4,t5,t6; 758CREATE TABLE t1 (c1 BIGINT NOT NULL); 759CREATE TABLE t2 (c1 BIGINT NOT NULL); 760CREATE TABLE t3 (c1 BIGINT NOT NULL); 761CREATE TABLE t4 (c1 BIGINT NOT NULL); 762CREATE TABLE t5 (c1 BIGINT NOT NULL); 763CREATE TABLE t6 (c1 BIGINT NOT NULL); 764INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 765INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 766INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 767INSERT INTO t4 (c1) VALUES(10); 768INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 769-- sorted_result 770SELECT t1.c1,t4.c1 FROM t1 NATURAL LEFT OUTER JOIN t4 ORDER BY t1.c1,t4.c1; 771-- sorted_result 772SELECT t1.c1,t4.c1 FROM t1 NATURAL LEFT OUTER JOIN t4 WHERE t1.c1 <= 5 ORDER BY t1.c1,t4.c1; 773DROP TABLE t1,t2,t3,t4,t5,t6; 774CREATE TABLE t1 (c1 TINYINT NOT NULL); 775CREATE TABLE t2 (c1 TINYINT NOT NULL); 776CREATE TABLE t3 (c1 TINYINT NOT NULL); 777CREATE TABLE t4 (c1 TINYINT NOT NULL); 778CREATE TABLE t5 (c1 TINYINT NOT NULL); 779CREATE TABLE t6 (c1 TINYINT 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); 785-- sorted_result 786SELECT t1.c1,t5.c1 FROM t1 NATURAL LEFT OUTER JOIN t5 ORDER BY t1.c1,t5.c1; 787-- sorted_result 788SELECT t1.c1,t5.c1 FROM t1 NATURAL LEFT OUTER JOIN t5 WHERE t1.c1 <= 5 ORDER BY t1.c1,t5.c1; 789DROP TABLE t1,t2,t3,t4,t5,t6; 790CREATE TABLE t1 (c1 SMALLINT NOT NULL); 791CREATE TABLE t2 (c1 SMALLINT NOT NULL); 792CREATE TABLE t3 (c1 SMALLINT NOT NULL); 793CREATE TABLE t4 (c1 SMALLINT NOT NULL); 794CREATE TABLE t5 (c1 SMALLINT NOT NULL); 795CREATE TABLE t6 (c1 SMALLINT NOT NULL); 796INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 797INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 798INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 799INSERT INTO t4 (c1) VALUES(10); 800INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 801-- sorted_result 802SELECT t1.c1,t5.c1 FROM t1 NATURAL LEFT OUTER JOIN t5 ORDER BY t1.c1,t5.c1; 803-- sorted_result 804SELECT t1.c1,t5.c1 FROM t1 NATURAL LEFT OUTER JOIN t5 WHERE t1.c1 <= 5 ORDER BY t1.c1,t5.c1; 805DROP TABLE t1,t2,t3,t4,t5,t6; 806CREATE TABLE t1 (c1 MEDIUMINT NOT NULL); 807CREATE TABLE t2 (c1 MEDIUMINT NOT NULL); 808CREATE TABLE t3 (c1 MEDIUMINT NOT NULL); 809CREATE TABLE t4 (c1 MEDIUMINT NOT NULL); 810CREATE TABLE t5 (c1 MEDIUMINT NOT NULL); 811CREATE TABLE t6 (c1 MEDIUMINT 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); 817-- sorted_result 818SELECT t1.c1,t5.c1 FROM t1 NATURAL LEFT OUTER JOIN t5 ORDER BY t1.c1,t5.c1; 819-- sorted_result 820SELECT t1.c1,t5.c1 FROM t1 NATURAL LEFT OUTER JOIN t5 WHERE t1.c1 <= 5 ORDER BY t1.c1,t5.c1; 821DROP TABLE t1,t2,t3,t4,t5,t6; 822CREATE TABLE t1 (c1 INT NOT NULL); 823CREATE TABLE t2 (c1 INT NOT NULL); 824CREATE TABLE t3 (c1 INT NOT NULL); 825CREATE TABLE t4 (c1 INT NOT NULL); 826CREATE TABLE t5 (c1 INT NOT NULL); 827CREATE TABLE t6 (c1 INT NOT NULL); 828INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 829INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 830INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 831INSERT INTO t4 (c1) VALUES(10); 832INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 833-- sorted_result 834SELECT t1.c1,t5.c1 FROM t1 NATURAL LEFT OUTER JOIN t5 ORDER BY t1.c1,t5.c1; 835-- sorted_result 836SELECT t1.c1,t5.c1 FROM t1 NATURAL LEFT OUTER JOIN t5 WHERE t1.c1 <= 5 ORDER BY t1.c1,t5.c1; 837DROP TABLE t1,t2,t3,t4,t5,t6; 838CREATE TABLE t1 (c1 INTEGER NOT NULL); 839CREATE TABLE t2 (c1 INTEGER NOT NULL); 840CREATE TABLE t3 (c1 INTEGER NOT NULL); 841CREATE TABLE t4 (c1 INTEGER NOT NULL); 842CREATE TABLE t5 (c1 INTEGER NOT NULL); 843CREATE TABLE t6 (c1 INTEGER NOT NULL); 844INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 845INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 846INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 847INSERT INTO t4 (c1) VALUES(10); 848INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 849-- sorted_result 850SELECT t1.c1,t5.c1 FROM t1 NATURAL LEFT OUTER JOIN t5 ORDER BY t1.c1,t5.c1; 851-- sorted_result 852SELECT t1.c1,t5.c1 FROM t1 NATURAL LEFT OUTER JOIN t5 WHERE t1.c1 <= 5 ORDER BY t1.c1,t5.c1; 853DROP TABLE t1,t2,t3,t4,t5,t6; 854CREATE TABLE t1 (c1 BIGINT NOT NULL); 855CREATE TABLE t2 (c1 BIGINT NOT NULL); 856CREATE TABLE t3 (c1 BIGINT NOT NULL); 857CREATE TABLE t4 (c1 BIGINT NOT NULL); 858CREATE TABLE t5 (c1 BIGINT NOT NULL); 859CREATE TABLE t6 (c1 BIGINT 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); 865-- sorted_result 866SELECT t1.c1,t5.c1 FROM t1 NATURAL LEFT OUTER JOIN t5 ORDER BY t1.c1,t5.c1; 867-- sorted_result 868SELECT t1.c1,t5.c1 FROM t1 NATURAL LEFT OUTER JOIN t5 WHERE t1.c1 <= 5 ORDER BY t1.c1,t5.c1; 869DROP TABLE t1,t2,t3,t4,t5,t6; 870CREATE TABLE t1 (c1 TINYINT NOT NULL); 871CREATE TABLE t2 (c1 TINYINT NOT NULL); 872CREATE TABLE t3 (c1 TINYINT NOT NULL); 873CREATE TABLE t4 (c1 TINYINT NOT NULL); 874CREATE TABLE t5 (c1 TINYINT NOT NULL); 875CREATE TABLE t6 (c1 TINYINT NOT NULL); 876INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 877INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 878INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 879INSERT INTO t4 (c1) VALUES(10); 880INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 881-- sorted_result 882SELECT t1.c1,t6.c1 FROM t1 NATURAL LEFT OUTER JOIN t6 ORDER BY t1.c1,t6.c1; 883-- sorted_result 884SELECT t1.c1,t6.c1 FROM t1 NATURAL LEFT OUTER JOIN t6 WHERE t1.c1 <= 5 ORDER BY t1.c1,t6.c1; 885DROP TABLE t1,t2,t3,t4,t5,t6; 886CREATE TABLE t1 (c1 SMALLINT NOT NULL); 887CREATE TABLE t2 (c1 SMALLINT NOT NULL); 888CREATE TABLE t3 (c1 SMALLINT NOT NULL); 889CREATE TABLE t4 (c1 SMALLINT NOT NULL); 890CREATE TABLE t5 (c1 SMALLINT NOT NULL); 891CREATE TABLE t6 (c1 SMALLINT NOT NULL); 892INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 893INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 894INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 895INSERT INTO t4 (c1) VALUES(10); 896INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 897-- sorted_result 898SELECT t1.c1,t6.c1 FROM t1 NATURAL LEFT OUTER JOIN t6 ORDER BY t1.c1,t6.c1; 899-- sorted_result 900SELECT t1.c1,t6.c1 FROM t1 NATURAL LEFT OUTER JOIN t6 WHERE t1.c1 <= 5 ORDER BY t1.c1,t6.c1; 901DROP TABLE t1,t2,t3,t4,t5,t6; 902CREATE TABLE t1 (c1 MEDIUMINT NOT NULL); 903CREATE TABLE t2 (c1 MEDIUMINT NOT NULL); 904CREATE TABLE t3 (c1 MEDIUMINT NOT NULL); 905CREATE TABLE t4 (c1 MEDIUMINT NOT NULL); 906CREATE TABLE t5 (c1 MEDIUMINT NOT NULL); 907CREATE TABLE t6 (c1 MEDIUMINT 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); 913-- sorted_result 914SELECT t1.c1,t6.c1 FROM t1 NATURAL LEFT OUTER JOIN t6 ORDER BY t1.c1,t6.c1; 915-- sorted_result 916SELECT t1.c1,t6.c1 FROM t1 NATURAL LEFT OUTER JOIN t6 WHERE t1.c1 <= 5 ORDER BY t1.c1,t6.c1; 917DROP TABLE t1,t2,t3,t4,t5,t6; 918CREATE TABLE t1 (c1 INT NOT NULL); 919CREATE TABLE t2 (c1 INT NOT NULL); 920CREATE TABLE t3 (c1 INT NOT NULL); 921CREATE TABLE t4 (c1 INT NOT NULL); 922CREATE TABLE t5 (c1 INT NOT NULL); 923CREATE TABLE t6 (c1 INT NOT NULL); 924INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 925INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 926INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 927INSERT INTO t4 (c1) VALUES(10); 928INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 929-- sorted_result 930SELECT t1.c1,t6.c1 FROM t1 NATURAL LEFT OUTER JOIN t6 ORDER BY t1.c1,t6.c1; 931-- sorted_result 932SELECT t1.c1,t6.c1 FROM t1 NATURAL LEFT OUTER JOIN t6 WHERE t1.c1 <= 5 ORDER BY t1.c1,t6.c1; 933DROP TABLE t1,t2,t3,t4,t5,t6; 934CREATE TABLE t1 (c1 INTEGER NOT NULL); 935CREATE TABLE t2 (c1 INTEGER NOT NULL); 936CREATE TABLE t3 (c1 INTEGER NOT NULL); 937CREATE TABLE t4 (c1 INTEGER NOT NULL); 938CREATE TABLE t5 (c1 INTEGER NOT NULL); 939CREATE TABLE t6 (c1 INTEGER NOT NULL); 940INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 941INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 942INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 943INSERT INTO t4 (c1) VALUES(10); 944INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 945-- sorted_result 946SELECT t1.c1,t6.c1 FROM t1 NATURAL LEFT OUTER JOIN t6 ORDER BY t1.c1,t6.c1; 947-- sorted_result 948SELECT t1.c1,t6.c1 FROM t1 NATURAL LEFT OUTER JOIN t6 WHERE t1.c1 <= 5 ORDER BY t1.c1,t6.c1; 949DROP TABLE t1,t2,t3,t4,t5,t6; 950CREATE TABLE t1 (c1 BIGINT NOT NULL); 951CREATE TABLE t2 (c1 BIGINT NOT NULL); 952CREATE TABLE t3 (c1 BIGINT NOT NULL); 953CREATE TABLE t4 (c1 BIGINT NOT NULL); 954CREATE TABLE t5 (c1 BIGINT NOT NULL); 955CREATE TABLE t6 (c1 BIGINT 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); 961-- sorted_result 962SELECT t1.c1,t6.c1 FROM t1 NATURAL LEFT OUTER JOIN t6 ORDER BY t1.c1,t6.c1; 963-- sorted_result 964SELECT t1.c1,t6.c1 FROM t1 NATURAL LEFT OUTER JOIN t6 WHERE t1.c1 <= 5 ORDER BY t1.c1,t6.c1; 965DROP TABLE t1,t2,t3,t4,t5,t6; 966CREATE TABLE t1 (c1 TINYINT NOT NULL); 967CREATE TABLE t2 (c1 TINYINT NOT NULL); 968CREATE TABLE t3 (c1 TINYINT NOT NULL); 969CREATE TABLE t4 (c1 TINYINT NOT NULL); 970CREATE TABLE t5 (c1 TINYINT NOT NULL); 971CREATE TABLE t6 (c1 TINYINT 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); 977-- sorted_result 978SELECT t1.c1,t2.c1 FROM t1 NATURAL LEFT OUTER JOIN t2 ORDER BY t1.c1,t2.c1; 979-- sorted_result 980SELECT t1.c1,t2.c1 FROM t1 NATURAL LEFT OUTER JOIN t2 WHERE t1.c1 = 5 ORDER BY t1.c1,t2.c1; 981DROP TABLE t1,t2,t3,t4,t5,t6; 982CREATE TABLE t1 (c1 SMALLINT NOT NULL); 983CREATE TABLE t2 (c1 SMALLINT NOT NULL); 984CREATE TABLE t3 (c1 SMALLINT NOT NULL); 985CREATE TABLE t4 (c1 SMALLINT NOT NULL); 986CREATE TABLE t5 (c1 SMALLINT NOT NULL); 987CREATE TABLE t6 (c1 SMALLINT 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); 993-- sorted_result 994SELECT t1.c1,t2.c1 FROM t1 NATURAL LEFT OUTER JOIN t2 ORDER BY t1.c1,t2.c1; 995-- sorted_result 996SELECT t1.c1,t2.c1 FROM t1 NATURAL LEFT OUTER JOIN t2 WHERE t1.c1 = 5 ORDER BY t1.c1,t2.c1; 997DROP TABLE t1,t2,t3,t4,t5,t6; 998CREATE TABLE t1 (c1 MEDIUMINT NOT NULL); 999CREATE TABLE t2 (c1 MEDIUMINT NOT NULL); 1000CREATE TABLE t3 (c1 MEDIUMINT NOT NULL); 1001CREATE TABLE t4 (c1 MEDIUMINT NOT NULL); 1002CREATE TABLE t5 (c1 MEDIUMINT NOT NULL); 1003CREATE TABLE t6 (c1 MEDIUMINT 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); 1009-- sorted_result 1010SELECT t1.c1,t2.c1 FROM t1 NATURAL LEFT OUTER JOIN t2 ORDER BY t1.c1,t2.c1; 1011-- sorted_result 1012SELECT t1.c1,t2.c1 FROM t1 NATURAL LEFT OUTER JOIN t2 WHERE t1.c1 = 5 ORDER BY t1.c1,t2.c1; 1013DROP TABLE t1,t2,t3,t4,t5,t6; 1014CREATE TABLE t1 (c1 INT NOT NULL); 1015CREATE TABLE t2 (c1 INT NOT NULL); 1016CREATE TABLE t3 (c1 INT NOT NULL); 1017CREATE TABLE t4 (c1 INT NOT NULL); 1018CREATE TABLE t5 (c1 INT NOT NULL); 1019CREATE TABLE t6 (c1 INT 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); 1025-- sorted_result 1026SELECT t1.c1,t2.c1 FROM t1 NATURAL LEFT OUTER JOIN t2 ORDER BY t1.c1,t2.c1; 1027-- sorted_result 1028SELECT t1.c1,t2.c1 FROM t1 NATURAL LEFT OUTER JOIN t2 WHERE t1.c1 = 5 ORDER BY t1.c1,t2.c1; 1029DROP TABLE t1,t2,t3,t4,t5,t6; 1030CREATE TABLE t1 (c1 INTEGER NOT NULL); 1031CREATE TABLE t2 (c1 INTEGER NOT NULL); 1032CREATE TABLE t3 (c1 INTEGER NOT NULL); 1033CREATE TABLE t4 (c1 INTEGER NOT NULL); 1034CREATE TABLE t5 (c1 INTEGER NOT NULL); 1035CREATE TABLE t6 (c1 INTEGER 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); 1041-- sorted_result 1042SELECT t1.c1,t2.c1 FROM t1 NATURAL LEFT OUTER JOIN t2 ORDER BY t1.c1,t2.c1; 1043-- sorted_result 1044SELECT t1.c1,t2.c1 FROM t1 NATURAL LEFT OUTER JOIN t2 WHERE t1.c1 = 5 ORDER BY t1.c1,t2.c1; 1045DROP TABLE t1,t2,t3,t4,t5,t6; 1046CREATE TABLE t1 (c1 BIGINT NOT NULL); 1047CREATE TABLE t2 (c1 BIGINT NOT NULL); 1048CREATE TABLE t3 (c1 BIGINT NOT NULL); 1049CREATE TABLE t4 (c1 BIGINT NOT NULL); 1050CREATE TABLE t5 (c1 BIGINT NOT NULL); 1051CREATE TABLE t6 (c1 BIGINT 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); 1057-- sorted_result 1058SELECT t1.c1,t2.c1 FROM t1 NATURAL LEFT OUTER JOIN t2 ORDER BY t1.c1,t2.c1; 1059-- sorted_result 1060SELECT t1.c1,t2.c1 FROM t1 NATURAL LEFT OUTER JOIN t2 WHERE t1.c1 = 5 ORDER BY t1.c1,t2.c1; 1061DROP TABLE t1,t2,t3,t4,t5,t6; 1062CREATE TABLE t1 (c1 TINYINT NOT NULL); 1063CREATE TABLE t2 (c1 TINYINT NOT NULL); 1064CREATE TABLE t3 (c1 TINYINT NOT NULL); 1065CREATE TABLE t4 (c1 TINYINT NOT NULL); 1066CREATE TABLE t5 (c1 TINYINT NOT NULL); 1067CREATE TABLE t6 (c1 TINYINT 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); 1073-- sorted_result 1074SELECT t1.c1,t3.c1 FROM t1 NATURAL LEFT OUTER JOIN t3 ORDER BY t1.c1,t3.c1; 1075-- sorted_result 1076SELECT t1.c1,t3.c1 FROM t1 NATURAL LEFT OUTER JOIN t3 WHERE t1.c1 = 5 ORDER BY t1.c1,t3.c1; 1077DROP TABLE t1,t2,t3,t4,t5,t6; 1078CREATE TABLE t1 (c1 SMALLINT NOT NULL); 1079CREATE TABLE t2 (c1 SMALLINT NOT NULL); 1080CREATE TABLE t3 (c1 SMALLINT NOT NULL); 1081CREATE TABLE t4 (c1 SMALLINT NOT NULL); 1082CREATE TABLE t5 (c1 SMALLINT NOT NULL); 1083CREATE TABLE t6 (c1 SMALLINT 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); 1089-- sorted_result 1090SELECT t1.c1,t3.c1 FROM t1 NATURAL LEFT OUTER JOIN t3 ORDER BY t1.c1,t3.c1; 1091-- sorted_result 1092SELECT t1.c1,t3.c1 FROM t1 NATURAL LEFT OUTER JOIN t3 WHERE t1.c1 = 5 ORDER BY t1.c1,t3.c1; 1093DROP TABLE t1,t2,t3,t4,t5,t6; 1094CREATE TABLE t1 (c1 MEDIUMINT NOT NULL); 1095CREATE TABLE t2 (c1 MEDIUMINT NOT NULL); 1096CREATE TABLE t3 (c1 MEDIUMINT NOT NULL); 1097CREATE TABLE t4 (c1 MEDIUMINT NOT NULL); 1098CREATE TABLE t5 (c1 MEDIUMINT NOT NULL); 1099CREATE TABLE t6 (c1 MEDIUMINT 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); 1105-- sorted_result 1106SELECT t1.c1,t3.c1 FROM t1 NATURAL LEFT OUTER JOIN t3 ORDER BY t1.c1,t3.c1; 1107-- sorted_result 1108SELECT t1.c1,t3.c1 FROM t1 NATURAL LEFT OUTER JOIN t3 WHERE t1.c1 = 5 ORDER BY t1.c1,t3.c1; 1109DROP TABLE t1,t2,t3,t4,t5,t6; 1110CREATE TABLE t1 (c1 INT NOT NULL); 1111CREATE TABLE t2 (c1 INT NOT NULL); 1112CREATE TABLE t3 (c1 INT NOT NULL); 1113CREATE TABLE t4 (c1 INT NOT NULL); 1114CREATE TABLE t5 (c1 INT NOT NULL); 1115CREATE TABLE t6 (c1 INT 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); 1121-- sorted_result 1122SELECT t1.c1,t3.c1 FROM t1 NATURAL LEFT OUTER JOIN t3 ORDER BY t1.c1,t3.c1; 1123-- sorted_result 1124SELECT t1.c1,t3.c1 FROM t1 NATURAL LEFT OUTER JOIN t3 WHERE t1.c1 = 5 ORDER BY t1.c1,t3.c1; 1125DROP TABLE t1,t2,t3,t4,t5,t6; 1126CREATE TABLE t1 (c1 INTEGER NOT NULL); 1127CREATE TABLE t2 (c1 INTEGER NOT NULL); 1128CREATE TABLE t3 (c1 INTEGER NOT NULL); 1129CREATE TABLE t4 (c1 INTEGER NOT NULL); 1130CREATE TABLE t5 (c1 INTEGER NOT NULL); 1131CREATE TABLE t6 (c1 INTEGER 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); 1137-- sorted_result 1138SELECT t1.c1,t3.c1 FROM t1 NATURAL LEFT OUTER JOIN t3 ORDER BY t1.c1,t3.c1; 1139-- sorted_result 1140SELECT t1.c1,t3.c1 FROM t1 NATURAL LEFT OUTER JOIN t3 WHERE t1.c1 = 5 ORDER BY t1.c1,t3.c1; 1141DROP TABLE t1,t2,t3,t4,t5,t6; 1142CREATE TABLE t1 (c1 BIGINT NOT NULL); 1143CREATE TABLE t2 (c1 BIGINT NOT NULL); 1144CREATE TABLE t3 (c1 BIGINT NOT NULL); 1145CREATE TABLE t4 (c1 BIGINT NOT NULL); 1146CREATE TABLE t5 (c1 BIGINT NOT NULL); 1147CREATE TABLE t6 (c1 BIGINT 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); 1153-- sorted_result 1154SELECT t1.c1,t3.c1 FROM t1 NATURAL LEFT OUTER JOIN t3 ORDER BY t1.c1,t3.c1; 1155-- sorted_result 1156SELECT t1.c1,t3.c1 FROM t1 NATURAL LEFT OUTER JOIN t3 WHERE t1.c1 = 5 ORDER BY t1.c1,t3.c1; 1157DROP TABLE t1,t2,t3,t4,t5,t6; 1158CREATE TABLE t1 (c1 TINYINT NOT NULL); 1159CREATE TABLE t2 (c1 TINYINT NOT NULL); 1160CREATE TABLE t3 (c1 TINYINT NOT NULL); 1161CREATE TABLE t4 (c1 TINYINT NOT NULL); 1162CREATE TABLE t5 (c1 TINYINT NOT NULL); 1163CREATE TABLE t6 (c1 TINYINT 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); 1169-- sorted_result 1170SELECT t1.c1,t4.c1 FROM t1 NATURAL LEFT OUTER JOIN t4 ORDER BY t1.c1,t4.c1; 1171-- sorted_result 1172SELECT t1.c1,t4.c1 FROM t1 NATURAL LEFT OUTER JOIN t4 WHERE t1.c1 = 5 ORDER BY t1.c1,t4.c1; 1173DROP TABLE t1,t2,t3,t4,t5,t6; 1174CREATE TABLE t1 (c1 SMALLINT NOT NULL); 1175CREATE TABLE t2 (c1 SMALLINT NOT NULL); 1176CREATE TABLE t3 (c1 SMALLINT NOT NULL); 1177CREATE TABLE t4 (c1 SMALLINT NOT NULL); 1178CREATE TABLE t5 (c1 SMALLINT NOT NULL); 1179CREATE TABLE t6 (c1 SMALLINT 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); 1185-- sorted_result 1186SELECT t1.c1,t4.c1 FROM t1 NATURAL LEFT OUTER JOIN t4 ORDER BY t1.c1,t4.c1; 1187-- sorted_result 1188SELECT t1.c1,t4.c1 FROM t1 NATURAL LEFT OUTER JOIN t4 WHERE t1.c1 = 5 ORDER BY t1.c1,t4.c1; 1189DROP TABLE t1,t2,t3,t4,t5,t6; 1190CREATE TABLE t1 (c1 MEDIUMINT NOT NULL); 1191CREATE TABLE t2 (c1 MEDIUMINT NOT NULL); 1192CREATE TABLE t3 (c1 MEDIUMINT NOT NULL); 1193CREATE TABLE t4 (c1 MEDIUMINT NOT NULL); 1194CREATE TABLE t5 (c1 MEDIUMINT NOT NULL); 1195CREATE TABLE t6 (c1 MEDIUMINT 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); 1201-- sorted_result 1202SELECT t1.c1,t4.c1 FROM t1 NATURAL LEFT OUTER JOIN t4 ORDER BY t1.c1,t4.c1; 1203-- sorted_result 1204SELECT t1.c1,t4.c1 FROM t1 NATURAL LEFT OUTER JOIN t4 WHERE t1.c1 = 5 ORDER BY t1.c1,t4.c1; 1205DROP TABLE t1,t2,t3,t4,t5,t6; 1206CREATE TABLE t1 (c1 INT NOT NULL); 1207CREATE TABLE t2 (c1 INT NOT NULL); 1208CREATE TABLE t3 (c1 INT NOT NULL); 1209CREATE TABLE t4 (c1 INT NOT NULL); 1210CREATE TABLE t5 (c1 INT NOT NULL); 1211CREATE TABLE t6 (c1 INT 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); 1217-- sorted_result 1218SELECT t1.c1,t4.c1 FROM t1 NATURAL LEFT OUTER JOIN t4 ORDER BY t1.c1,t4.c1; 1219-- sorted_result 1220SELECT t1.c1,t4.c1 FROM t1 NATURAL LEFT OUTER JOIN t4 WHERE t1.c1 = 5 ORDER BY t1.c1,t4.c1; 1221DROP TABLE t1,t2,t3,t4,t5,t6; 1222CREATE TABLE t1 (c1 INTEGER NOT NULL); 1223CREATE TABLE t2 (c1 INTEGER NOT NULL); 1224CREATE TABLE t3 (c1 INTEGER NOT NULL); 1225CREATE TABLE t4 (c1 INTEGER NOT NULL); 1226CREATE TABLE t5 (c1 INTEGER NOT NULL); 1227CREATE TABLE t6 (c1 INTEGER 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); 1233-- sorted_result 1234SELECT t1.c1,t4.c1 FROM t1 NATURAL LEFT OUTER JOIN t4 ORDER BY t1.c1,t4.c1; 1235-- sorted_result 1236SELECT t1.c1,t4.c1 FROM t1 NATURAL LEFT OUTER JOIN t4 WHERE t1.c1 = 5 ORDER BY t1.c1,t4.c1; 1237DROP TABLE t1,t2,t3,t4,t5,t6; 1238CREATE TABLE t1 (c1 BIGINT NOT NULL); 1239CREATE TABLE t2 (c1 BIGINT NOT NULL); 1240CREATE TABLE t3 (c1 BIGINT NOT NULL); 1241CREATE TABLE t4 (c1 BIGINT NOT NULL); 1242CREATE TABLE t5 (c1 BIGINT NOT NULL); 1243CREATE TABLE t6 (c1 BIGINT 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); 1249-- sorted_result 1250SELECT t1.c1,t4.c1 FROM t1 NATURAL LEFT OUTER JOIN t4 ORDER BY t1.c1,t4.c1; 1251-- sorted_result 1252SELECT t1.c1,t4.c1 FROM t1 NATURAL LEFT OUTER JOIN t4 WHERE t1.c1 = 5 ORDER BY t1.c1,t4.c1; 1253DROP TABLE t1,t2,t3,t4,t5,t6; 1254CREATE TABLE t1 (c1 TINYINT NOT NULL); 1255CREATE TABLE t2 (c1 TINYINT NOT NULL); 1256CREATE TABLE t3 (c1 TINYINT NOT NULL); 1257CREATE TABLE t4 (c1 TINYINT NOT NULL); 1258CREATE TABLE t5 (c1 TINYINT NOT NULL); 1259CREATE TABLE t6 (c1 TINYINT NOT NULL); 1260INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1261INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1262INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 1263INSERT INTO t4 (c1) VALUES(10); 1264INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 1265-- sorted_result 1266SELECT t1.c1,t5.c1 FROM t1 NATURAL LEFT OUTER JOIN t5 ORDER BY t1.c1,t5.c1; 1267-- sorted_result 1268SELECT t1.c1,t5.c1 FROM t1 NATURAL LEFT OUTER JOIN t5 WHERE t1.c1 = 5 ORDER BY t1.c1,t5.c1; 1269DROP TABLE t1,t2,t3,t4,t5,t6; 1270CREATE TABLE t1 (c1 SMALLINT NOT NULL); 1271CREATE TABLE t2 (c1 SMALLINT NOT NULL); 1272CREATE TABLE t3 (c1 SMALLINT NOT NULL); 1273CREATE TABLE t4 (c1 SMALLINT NOT NULL); 1274CREATE TABLE t5 (c1 SMALLINT NOT NULL); 1275CREATE TABLE t6 (c1 SMALLINT NOT NULL); 1276INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1277INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1278INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 1279INSERT INTO t4 (c1) VALUES(10); 1280INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 1281-- sorted_result 1282SELECT t1.c1,t5.c1 FROM t1 NATURAL LEFT OUTER JOIN t5 ORDER BY t1.c1,t5.c1; 1283-- sorted_result 1284SELECT t1.c1,t5.c1 FROM t1 NATURAL LEFT OUTER JOIN t5 WHERE t1.c1 = 5 ORDER BY t1.c1,t5.c1; 1285DROP TABLE t1,t2,t3,t4,t5,t6; 1286CREATE TABLE t1 (c1 MEDIUMINT NOT NULL); 1287CREATE TABLE t2 (c1 MEDIUMINT NOT NULL); 1288CREATE TABLE t3 (c1 MEDIUMINT NOT NULL); 1289CREATE TABLE t4 (c1 MEDIUMINT NOT NULL); 1290CREATE TABLE t5 (c1 MEDIUMINT NOT NULL); 1291CREATE TABLE t6 (c1 MEDIUMINT NOT NULL); 1292INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1293INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1294INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 1295INSERT INTO t4 (c1) VALUES(10); 1296INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 1297-- sorted_result 1298SELECT t1.c1,t5.c1 FROM t1 NATURAL LEFT OUTER JOIN t5 ORDER BY t1.c1,t5.c1; 1299-- sorted_result 1300SELECT t1.c1,t5.c1 FROM t1 NATURAL LEFT OUTER JOIN t5 WHERE t1.c1 = 5 ORDER BY t1.c1,t5.c1; 1301DROP TABLE t1,t2,t3,t4,t5,t6; 1302CREATE TABLE t1 (c1 INT NOT NULL); 1303CREATE TABLE t2 (c1 INT NOT NULL); 1304CREATE TABLE t3 (c1 INT NOT NULL); 1305CREATE TABLE t4 (c1 INT NOT NULL); 1306CREATE TABLE t5 (c1 INT NOT NULL); 1307CREATE TABLE t6 (c1 INT NOT NULL); 1308INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1309INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1310INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 1311INSERT INTO t4 (c1) VALUES(10); 1312INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 1313-- sorted_result 1314SELECT t1.c1,t5.c1 FROM t1 NATURAL LEFT OUTER JOIN t5 ORDER BY t1.c1,t5.c1; 1315-- sorted_result 1316SELECT t1.c1,t5.c1 FROM t1 NATURAL LEFT OUTER JOIN t5 WHERE t1.c1 = 5 ORDER BY t1.c1,t5.c1; 1317DROP TABLE t1,t2,t3,t4,t5,t6; 1318CREATE TABLE t1 (c1 INTEGER NOT NULL); 1319CREATE TABLE t2 (c1 INTEGER NOT NULL); 1320CREATE TABLE t3 (c1 INTEGER NOT NULL); 1321CREATE TABLE t4 (c1 INTEGER NOT NULL); 1322CREATE TABLE t5 (c1 INTEGER NOT NULL); 1323CREATE TABLE t6 (c1 INTEGER NOT NULL); 1324INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1325INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1326INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 1327INSERT INTO t4 (c1) VALUES(10); 1328INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 1329-- sorted_result 1330SELECT t1.c1,t5.c1 FROM t1 NATURAL LEFT OUTER JOIN t5 ORDER BY t1.c1,t5.c1; 1331-- sorted_result 1332SELECT t1.c1,t5.c1 FROM t1 NATURAL LEFT OUTER JOIN t5 WHERE t1.c1 = 5 ORDER BY t1.c1,t5.c1; 1333DROP TABLE t1,t2,t3,t4,t5,t6; 1334CREATE TABLE t1 (c1 BIGINT NOT NULL); 1335CREATE TABLE t2 (c1 BIGINT NOT NULL); 1336CREATE TABLE t3 (c1 BIGINT NOT NULL); 1337CREATE TABLE t4 (c1 BIGINT NOT NULL); 1338CREATE TABLE t5 (c1 BIGINT NOT NULL); 1339CREATE TABLE t6 (c1 BIGINT NOT NULL); 1340INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1341INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1342INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 1343INSERT INTO t4 (c1) VALUES(10); 1344INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 1345-- sorted_result 1346SELECT t1.c1,t5.c1 FROM t1 NATURAL LEFT OUTER JOIN t5 ORDER BY t1.c1,t5.c1; 1347-- sorted_result 1348SELECT t1.c1,t5.c1 FROM t1 NATURAL LEFT OUTER JOIN t5 WHERE t1.c1 = 5 ORDER BY t1.c1,t5.c1; 1349DROP TABLE t1,t2,t3,t4,t5,t6; 1350CREATE TABLE t1 (c1 TINYINT NOT NULL); 1351CREATE TABLE t2 (c1 TINYINT NOT NULL); 1352CREATE TABLE t3 (c1 TINYINT NOT NULL); 1353CREATE TABLE t4 (c1 TINYINT NOT NULL); 1354CREATE TABLE t5 (c1 TINYINT NOT NULL); 1355CREATE TABLE t6 (c1 TINYINT NOT NULL); 1356INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1357INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1358INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 1359INSERT INTO t4 (c1) VALUES(10); 1360INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 1361-- sorted_result 1362SELECT t1.c1,t6.c1 FROM t1 NATURAL LEFT OUTER JOIN t6 ORDER BY t1.c1,t6.c1; 1363-- sorted_result 1364SELECT t1.c1,t6.c1 FROM t1 NATURAL LEFT OUTER JOIN t6 WHERE t1.c1 = 5 ORDER BY t1.c1,t6.c1; 1365DROP TABLE t1,t2,t3,t4,t5,t6; 1366CREATE TABLE t1 (c1 SMALLINT NOT NULL); 1367CREATE TABLE t2 (c1 SMALLINT NOT NULL); 1368CREATE TABLE t3 (c1 SMALLINT NOT NULL); 1369CREATE TABLE t4 (c1 SMALLINT NOT NULL); 1370CREATE TABLE t5 (c1 SMALLINT NOT NULL); 1371CREATE TABLE t6 (c1 SMALLINT NOT NULL); 1372INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1373INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1374INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 1375INSERT INTO t4 (c1) VALUES(10); 1376INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 1377-- sorted_result 1378SELECT t1.c1,t6.c1 FROM t1 NATURAL LEFT OUTER JOIN t6 ORDER BY t1.c1,t6.c1; 1379-- sorted_result 1380SELECT t1.c1,t6.c1 FROM t1 NATURAL LEFT OUTER JOIN t6 WHERE t1.c1 = 5 ORDER BY t1.c1,t6.c1; 1381DROP TABLE t1,t2,t3,t4,t5,t6; 1382CREATE TABLE t1 (c1 MEDIUMINT NOT NULL); 1383CREATE TABLE t2 (c1 MEDIUMINT NOT NULL); 1384CREATE TABLE t3 (c1 MEDIUMINT NOT NULL); 1385CREATE TABLE t4 (c1 MEDIUMINT NOT NULL); 1386CREATE TABLE t5 (c1 MEDIUMINT NOT NULL); 1387CREATE TABLE t6 (c1 MEDIUMINT NOT NULL); 1388INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1389INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1390INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 1391INSERT INTO t4 (c1) VALUES(10); 1392INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 1393-- sorted_result 1394SELECT t1.c1,t6.c1 FROM t1 NATURAL LEFT OUTER JOIN t6 ORDER BY t1.c1,t6.c1; 1395-- sorted_result 1396SELECT t1.c1,t6.c1 FROM t1 NATURAL LEFT OUTER JOIN t6 WHERE t1.c1 = 5 ORDER BY t1.c1,t6.c1; 1397DROP TABLE t1,t2,t3,t4,t5,t6; 1398CREATE TABLE t1 (c1 INT NOT NULL); 1399CREATE TABLE t2 (c1 INT NOT NULL); 1400CREATE TABLE t3 (c1 INT NOT NULL); 1401CREATE TABLE t4 (c1 INT NOT NULL); 1402CREATE TABLE t5 (c1 INT NOT NULL); 1403CREATE TABLE t6 (c1 INT NOT NULL); 1404INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1405INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1406INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 1407INSERT INTO t4 (c1) VALUES(10); 1408INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 1409-- sorted_result 1410SELECT t1.c1,t6.c1 FROM t1 NATURAL LEFT OUTER JOIN t6 ORDER BY t1.c1,t6.c1; 1411-- sorted_result 1412SELECT t1.c1,t6.c1 FROM t1 NATURAL LEFT OUTER JOIN t6 WHERE t1.c1 = 5 ORDER BY t1.c1,t6.c1; 1413DROP TABLE t1,t2,t3,t4,t5,t6; 1414CREATE TABLE t1 (c1 INTEGER NOT NULL); 1415CREATE TABLE t2 (c1 INTEGER NOT NULL); 1416CREATE TABLE t3 (c1 INTEGER NOT NULL); 1417CREATE TABLE t4 (c1 INTEGER NOT NULL); 1418CREATE TABLE t5 (c1 INTEGER NOT NULL); 1419CREATE TABLE t6 (c1 INTEGER NOT NULL); 1420INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1421INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1422INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 1423INSERT INTO t4 (c1) VALUES(10); 1424INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 1425-- sorted_result 1426SELECT t1.c1,t6.c1 FROM t1 NATURAL LEFT OUTER JOIN t6 ORDER BY t1.c1,t6.c1; 1427-- sorted_result 1428SELECT t1.c1,t6.c1 FROM t1 NATURAL LEFT OUTER JOIN t6 WHERE t1.c1 = 5 ORDER BY t1.c1,t6.c1; 1429DROP TABLE t1,t2,t3,t4,t5,t6; 1430CREATE TABLE t1 (c1 BIGINT NOT NULL); 1431CREATE TABLE t2 (c1 BIGINT NOT NULL); 1432CREATE TABLE t3 (c1 BIGINT NOT NULL); 1433CREATE TABLE t4 (c1 BIGINT NOT NULL); 1434CREATE TABLE t5 (c1 BIGINT NOT NULL); 1435CREATE TABLE t6 (c1 BIGINT NOT NULL); 1436INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1437INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1438INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 1439INSERT INTO t4 (c1) VALUES(10); 1440INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 1441-- sorted_result 1442SELECT t1.c1,t6.c1 FROM t1 NATURAL LEFT OUTER JOIN t6 ORDER BY t1.c1,t6.c1; 1443-- sorted_result 1444SELECT t1.c1,t6.c1 FROM t1 NATURAL LEFT OUTER JOIN t6 WHERE t1.c1 = 5 ORDER BY t1.c1,t6.c1; 1445DROP TABLE t1,t2,t3,t4,t5,t6; 1446CREATE TABLE t1 (c1 TINYINT NOT NULL); 1447CREATE TABLE t2 (c1 TINYINT NOT NULL); 1448CREATE TABLE t3 (c1 TINYINT NOT NULL); 1449CREATE TABLE t4 (c1 TINYINT NOT NULL); 1450CREATE TABLE t5 (c1 TINYINT NOT NULL); 1451CREATE TABLE t6 (c1 TINYINT NOT NULL); 1452INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1453INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1454INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 1455INSERT INTO t4 (c1) VALUES(10); 1456INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 1457-- sorted_result 1458SELECT t1.c1,t2.c1 FROM t1 NATURAL LEFT OUTER JOIN t2 ORDER BY t1.c1,t2.c1; 1459-- sorted_result 1460SELECT t1.c1,t2.c1 FROM t1 NATURAL LEFT OUTER JOIN t2 WHERE t1.c1 >= 5 ORDER BY t1.c1,t2.c1; 1461DROP TABLE t1,t2,t3,t4,t5,t6; 1462CREATE TABLE t1 (c1 SMALLINT NOT NULL); 1463CREATE TABLE t2 (c1 SMALLINT NOT NULL); 1464CREATE TABLE t3 (c1 SMALLINT NOT NULL); 1465CREATE TABLE t4 (c1 SMALLINT NOT NULL); 1466CREATE TABLE t5 (c1 SMALLINT NOT NULL); 1467CREATE TABLE t6 (c1 SMALLINT NOT NULL); 1468INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1469INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1470INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 1471INSERT INTO t4 (c1) VALUES(10); 1472INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 1473-- sorted_result 1474SELECT t1.c1,t2.c1 FROM t1 NATURAL LEFT OUTER JOIN t2 ORDER BY t1.c1,t2.c1; 1475-- sorted_result 1476SELECT t1.c1,t2.c1 FROM t1 NATURAL LEFT OUTER JOIN t2 WHERE t1.c1 >= 5 ORDER BY t1.c1,t2.c1; 1477DROP TABLE t1,t2,t3,t4,t5,t6; 1478CREATE TABLE t1 (c1 MEDIUMINT NOT NULL); 1479CREATE TABLE t2 (c1 MEDIUMINT NOT NULL); 1480CREATE TABLE t3 (c1 MEDIUMINT NOT NULL); 1481CREATE TABLE t4 (c1 MEDIUMINT NOT NULL); 1482CREATE TABLE t5 (c1 MEDIUMINT NOT NULL); 1483CREATE TABLE t6 (c1 MEDIUMINT NOT NULL); 1484INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1485INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1486INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 1487INSERT INTO t4 (c1) VALUES(10); 1488INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 1489-- sorted_result 1490SELECT t1.c1,t2.c1 FROM t1 NATURAL LEFT OUTER JOIN t2 ORDER BY t1.c1,t2.c1; 1491-- sorted_result 1492SELECT t1.c1,t2.c1 FROM t1 NATURAL LEFT OUTER JOIN t2 WHERE t1.c1 >= 5 ORDER BY t1.c1,t2.c1; 1493DROP TABLE t1,t2,t3,t4,t5,t6; 1494CREATE TABLE t1 (c1 INT NOT NULL); 1495CREATE TABLE t2 (c1 INT NOT NULL); 1496CREATE TABLE t3 (c1 INT NOT NULL); 1497CREATE TABLE t4 (c1 INT NOT NULL); 1498CREATE TABLE t5 (c1 INT NOT NULL); 1499CREATE TABLE t6 (c1 INT NOT NULL); 1500INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1501INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1502INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 1503INSERT INTO t4 (c1) VALUES(10); 1504INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 1505-- sorted_result 1506SELECT t1.c1,t2.c1 FROM t1 NATURAL LEFT OUTER JOIN t2 ORDER BY t1.c1,t2.c1; 1507-- sorted_result 1508SELECT t1.c1,t2.c1 FROM t1 NATURAL LEFT OUTER JOIN t2 WHERE t1.c1 >= 5 ORDER BY t1.c1,t2.c1; 1509DROP TABLE t1,t2,t3,t4,t5,t6; 1510CREATE TABLE t1 (c1 INTEGER NOT NULL); 1511CREATE TABLE t2 (c1 INTEGER NOT NULL); 1512CREATE TABLE t3 (c1 INTEGER NOT NULL); 1513CREATE TABLE t4 (c1 INTEGER NOT NULL); 1514CREATE TABLE t5 (c1 INTEGER NOT NULL); 1515CREATE TABLE t6 (c1 INTEGER 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); 1521-- sorted_result 1522SELECT t1.c1,t2.c1 FROM t1 NATURAL LEFT OUTER JOIN t2 ORDER BY t1.c1,t2.c1; 1523-- sorted_result 1524SELECT t1.c1,t2.c1 FROM t1 NATURAL LEFT OUTER JOIN t2 WHERE t1.c1 >= 5 ORDER BY t1.c1,t2.c1; 1525DROP TABLE t1,t2,t3,t4,t5,t6; 1526CREATE TABLE t1 (c1 BIGINT NOT NULL); 1527CREATE TABLE t2 (c1 BIGINT NOT NULL); 1528CREATE TABLE t3 (c1 BIGINT NOT NULL); 1529CREATE TABLE t4 (c1 BIGINT NOT NULL); 1530CREATE TABLE t5 (c1 BIGINT NOT NULL); 1531CREATE TABLE t6 (c1 BIGINT NOT NULL); 1532INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1533INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1534INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 1535INSERT INTO t4 (c1) VALUES(10); 1536INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 1537-- sorted_result 1538SELECT t1.c1,t2.c1 FROM t1 NATURAL LEFT OUTER JOIN t2 ORDER BY t1.c1,t2.c1; 1539-- sorted_result 1540SELECT t1.c1,t2.c1 FROM t1 NATURAL LEFT OUTER JOIN t2 WHERE t1.c1 >= 5 ORDER BY t1.c1,t2.c1; 1541DROP TABLE t1,t2,t3,t4,t5,t6; 1542CREATE TABLE t1 (c1 TINYINT NOT NULL); 1543CREATE TABLE t2 (c1 TINYINT NOT NULL); 1544CREATE TABLE t3 (c1 TINYINT NOT NULL); 1545CREATE TABLE t4 (c1 TINYINT NOT NULL); 1546CREATE TABLE t5 (c1 TINYINT NOT NULL); 1547CREATE TABLE t6 (c1 TINYINT NOT NULL); 1548INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1549INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1550INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 1551INSERT INTO t4 (c1) VALUES(10); 1552INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 1553-- sorted_result 1554SELECT t1.c1,t3.c1 FROM t1 NATURAL LEFT OUTER JOIN t3 ORDER BY t1.c1,t3.c1; 1555-- sorted_result 1556SELECT t1.c1,t3.c1 FROM t1 NATURAL LEFT OUTER JOIN t3 WHERE t1.c1 >= 5 ORDER BY t1.c1,t3.c1; 1557DROP TABLE t1,t2,t3,t4,t5,t6; 1558CREATE TABLE t1 (c1 SMALLINT NOT NULL); 1559CREATE TABLE t2 (c1 SMALLINT NOT NULL); 1560CREATE TABLE t3 (c1 SMALLINT NOT NULL); 1561CREATE TABLE t4 (c1 SMALLINT NOT NULL); 1562CREATE TABLE t5 (c1 SMALLINT NOT NULL); 1563CREATE TABLE t6 (c1 SMALLINT NOT NULL); 1564INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1565INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1566INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 1567INSERT INTO t4 (c1) VALUES(10); 1568INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 1569-- sorted_result 1570SELECT t1.c1,t3.c1 FROM t1 NATURAL LEFT OUTER JOIN t3 ORDER BY t1.c1,t3.c1; 1571-- sorted_result 1572SELECT t1.c1,t3.c1 FROM t1 NATURAL LEFT OUTER JOIN t3 WHERE t1.c1 >= 5 ORDER BY t1.c1,t3.c1; 1573DROP TABLE t1,t2,t3,t4,t5,t6; 1574CREATE TABLE t1 (c1 MEDIUMINT NOT NULL); 1575CREATE TABLE t2 (c1 MEDIUMINT NOT NULL); 1576CREATE TABLE t3 (c1 MEDIUMINT NOT NULL); 1577CREATE TABLE t4 (c1 MEDIUMINT NOT NULL); 1578CREATE TABLE t5 (c1 MEDIUMINT NOT NULL); 1579CREATE TABLE t6 (c1 MEDIUMINT NOT NULL); 1580INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1581INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1582INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 1583INSERT INTO t4 (c1) VALUES(10); 1584INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 1585-- sorted_result 1586SELECT t1.c1,t3.c1 FROM t1 NATURAL LEFT OUTER JOIN t3 ORDER BY t1.c1,t3.c1; 1587-- sorted_result 1588SELECT t1.c1,t3.c1 FROM t1 NATURAL LEFT OUTER JOIN t3 WHERE t1.c1 >= 5 ORDER BY t1.c1,t3.c1; 1589DROP TABLE t1,t2,t3,t4,t5,t6; 1590CREATE TABLE t1 (c1 INT NOT NULL); 1591CREATE TABLE t2 (c1 INT NOT NULL); 1592CREATE TABLE t3 (c1 INT NOT NULL); 1593CREATE TABLE t4 (c1 INT NOT NULL); 1594CREATE TABLE t5 (c1 INT NOT NULL); 1595CREATE TABLE t6 (c1 INT NOT NULL); 1596INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1597INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1598INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 1599INSERT INTO t4 (c1) VALUES(10); 1600INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 1601-- sorted_result 1602SELECT t1.c1,t3.c1 FROM t1 NATURAL LEFT OUTER JOIN t3 ORDER BY t1.c1,t3.c1; 1603-- sorted_result 1604SELECT t1.c1,t3.c1 FROM t1 NATURAL LEFT OUTER JOIN t3 WHERE t1.c1 >= 5 ORDER BY t1.c1,t3.c1; 1605DROP TABLE t1,t2,t3,t4,t5,t6; 1606CREATE TABLE t1 (c1 INTEGER NOT NULL); 1607CREATE TABLE t2 (c1 INTEGER NOT NULL); 1608CREATE TABLE t3 (c1 INTEGER NOT NULL); 1609CREATE TABLE t4 (c1 INTEGER NOT NULL); 1610CREATE TABLE t5 (c1 INTEGER NOT NULL); 1611CREATE TABLE t6 (c1 INTEGER NOT NULL); 1612INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1613INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1614INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 1615INSERT INTO t4 (c1) VALUES(10); 1616INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 1617-- sorted_result 1618SELECT t1.c1,t3.c1 FROM t1 NATURAL LEFT OUTER JOIN t3 ORDER BY t1.c1,t3.c1; 1619-- sorted_result 1620SELECT t1.c1,t3.c1 FROM t1 NATURAL LEFT OUTER JOIN t3 WHERE t1.c1 >= 5 ORDER BY t1.c1,t3.c1; 1621DROP TABLE t1,t2,t3,t4,t5,t6; 1622CREATE TABLE t1 (c1 BIGINT NOT NULL); 1623CREATE TABLE t2 (c1 BIGINT NOT NULL); 1624CREATE TABLE t3 (c1 BIGINT NOT NULL); 1625CREATE TABLE t4 (c1 BIGINT NOT NULL); 1626CREATE TABLE t5 (c1 BIGINT NOT NULL); 1627CREATE TABLE t6 (c1 BIGINT NOT NULL); 1628INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1629INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1630INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 1631INSERT INTO t4 (c1) VALUES(10); 1632INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 1633-- sorted_result 1634SELECT t1.c1,t3.c1 FROM t1 NATURAL LEFT OUTER JOIN t3 ORDER BY t1.c1,t3.c1; 1635-- sorted_result 1636SELECT t1.c1,t3.c1 FROM t1 NATURAL LEFT OUTER JOIN t3 WHERE t1.c1 >= 5 ORDER BY t1.c1,t3.c1; 1637DROP TABLE t1,t2,t3,t4,t5,t6; 1638CREATE TABLE t1 (c1 TINYINT NOT NULL); 1639CREATE TABLE t2 (c1 TINYINT NOT NULL); 1640CREATE TABLE t3 (c1 TINYINT NOT NULL); 1641CREATE TABLE t4 (c1 TINYINT NOT NULL); 1642CREATE TABLE t5 (c1 TINYINT NOT NULL); 1643CREATE TABLE t6 (c1 TINYINT NOT NULL); 1644INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1645INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1646INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 1647INSERT INTO t4 (c1) VALUES(10); 1648INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 1649-- sorted_result 1650SELECT t1.c1,t4.c1 FROM t1 NATURAL LEFT OUTER JOIN t4 ORDER BY t1.c1,t4.c1; 1651-- sorted_result 1652SELECT t1.c1,t4.c1 FROM t1 NATURAL LEFT OUTER JOIN t4 WHERE t1.c1 >= 5 ORDER BY t1.c1,t4.c1; 1653DROP TABLE t1,t2,t3,t4,t5,t6; 1654CREATE TABLE t1 (c1 SMALLINT NOT NULL); 1655CREATE TABLE t2 (c1 SMALLINT NOT NULL); 1656CREATE TABLE t3 (c1 SMALLINT NOT NULL); 1657CREATE TABLE t4 (c1 SMALLINT NOT NULL); 1658CREATE TABLE t5 (c1 SMALLINT NOT NULL); 1659CREATE TABLE t6 (c1 SMALLINT NOT NULL); 1660INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1661INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1662INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 1663INSERT INTO t4 (c1) VALUES(10); 1664INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 1665-- sorted_result 1666SELECT t1.c1,t4.c1 FROM t1 NATURAL LEFT OUTER JOIN t4 ORDER BY t1.c1,t4.c1; 1667-- sorted_result 1668SELECT t1.c1,t4.c1 FROM t1 NATURAL LEFT OUTER JOIN t4 WHERE t1.c1 >= 5 ORDER BY t1.c1,t4.c1; 1669DROP TABLE t1,t2,t3,t4,t5,t6; 1670CREATE TABLE t1 (c1 MEDIUMINT NOT NULL); 1671CREATE TABLE t2 (c1 MEDIUMINT NOT NULL); 1672CREATE TABLE t3 (c1 MEDIUMINT NOT NULL); 1673CREATE TABLE t4 (c1 MEDIUMINT NOT NULL); 1674CREATE TABLE t5 (c1 MEDIUMINT NOT NULL); 1675CREATE TABLE t6 (c1 MEDIUMINT NOT NULL); 1676INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1677INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1678INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 1679INSERT INTO t4 (c1) VALUES(10); 1680INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 1681-- sorted_result 1682SELECT t1.c1,t4.c1 FROM t1 NATURAL LEFT OUTER JOIN t4 ORDER BY t1.c1,t4.c1; 1683-- sorted_result 1684SELECT t1.c1,t4.c1 FROM t1 NATURAL LEFT OUTER JOIN t4 WHERE t1.c1 >= 5 ORDER BY t1.c1,t4.c1; 1685DROP TABLE t1,t2,t3,t4,t5,t6; 1686CREATE TABLE t1 (c1 INT NOT NULL); 1687CREATE TABLE t2 (c1 INT NOT NULL); 1688CREATE TABLE t3 (c1 INT NOT NULL); 1689CREATE TABLE t4 (c1 INT NOT NULL); 1690CREATE TABLE t5 (c1 INT NOT NULL); 1691CREATE TABLE t6 (c1 INT NOT NULL); 1692INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1693INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1694INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 1695INSERT INTO t4 (c1) VALUES(10); 1696INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 1697-- sorted_result 1698SELECT t1.c1,t4.c1 FROM t1 NATURAL LEFT OUTER JOIN t4 ORDER BY t1.c1,t4.c1; 1699-- sorted_result 1700SELECT t1.c1,t4.c1 FROM t1 NATURAL LEFT OUTER JOIN t4 WHERE t1.c1 >= 5 ORDER BY t1.c1,t4.c1; 1701DROP TABLE t1,t2,t3,t4,t5,t6; 1702CREATE TABLE t1 (c1 INTEGER NOT NULL); 1703CREATE TABLE t2 (c1 INTEGER NOT NULL); 1704CREATE TABLE t3 (c1 INTEGER NOT NULL); 1705CREATE TABLE t4 (c1 INTEGER NOT NULL); 1706CREATE TABLE t5 (c1 INTEGER NOT NULL); 1707CREATE TABLE t6 (c1 INTEGER NOT NULL); 1708INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1709INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1710INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 1711INSERT INTO t4 (c1) VALUES(10); 1712INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 1713-- sorted_result 1714SELECT t1.c1,t4.c1 FROM t1 NATURAL LEFT OUTER JOIN t4 ORDER BY t1.c1,t4.c1; 1715-- sorted_result 1716SELECT t1.c1,t4.c1 FROM t1 NATURAL LEFT OUTER JOIN t4 WHERE t1.c1 >= 5 ORDER BY t1.c1,t4.c1; 1717DROP TABLE t1,t2,t3,t4,t5,t6; 1718CREATE TABLE t1 (c1 BIGINT NOT NULL); 1719CREATE TABLE t2 (c1 BIGINT NOT NULL); 1720CREATE TABLE t3 (c1 BIGINT NOT NULL); 1721CREATE TABLE t4 (c1 BIGINT NOT NULL); 1722CREATE TABLE t5 (c1 BIGINT NOT NULL); 1723CREATE TABLE t6 (c1 BIGINT NOT NULL); 1724INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1725INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1726INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 1727INSERT INTO t4 (c1) VALUES(10); 1728INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 1729-- sorted_result 1730SELECT t1.c1,t4.c1 FROM t1 NATURAL LEFT OUTER JOIN t4 ORDER BY t1.c1,t4.c1; 1731-- sorted_result 1732SELECT t1.c1,t4.c1 FROM t1 NATURAL LEFT OUTER JOIN t4 WHERE t1.c1 >= 5 ORDER BY t1.c1,t4.c1; 1733DROP TABLE t1,t2,t3,t4,t5,t6; 1734CREATE TABLE t1 (c1 TINYINT NOT NULL); 1735CREATE TABLE t2 (c1 TINYINT NOT NULL); 1736CREATE TABLE t3 (c1 TINYINT NOT NULL); 1737CREATE TABLE t4 (c1 TINYINT NOT NULL); 1738CREATE TABLE t5 (c1 TINYINT NOT NULL); 1739CREATE TABLE t6 (c1 TINYINT NOT NULL); 1740INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1741INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1742INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 1743INSERT INTO t4 (c1) VALUES(10); 1744INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 1745-- sorted_result 1746SELECT t1.c1,t5.c1 FROM t1 NATURAL LEFT OUTER JOIN t5 ORDER BY t1.c1,t5.c1; 1747-- sorted_result 1748SELECT t1.c1,t5.c1 FROM t1 NATURAL LEFT OUTER JOIN t5 WHERE t1.c1 >= 5 ORDER BY t1.c1,t5.c1; 1749DROP TABLE t1,t2,t3,t4,t5,t6; 1750CREATE TABLE t1 (c1 SMALLINT NOT NULL); 1751CREATE TABLE t2 (c1 SMALLINT NOT NULL); 1752CREATE TABLE t3 (c1 SMALLINT NOT NULL); 1753CREATE TABLE t4 (c1 SMALLINT NOT NULL); 1754CREATE TABLE t5 (c1 SMALLINT NOT NULL); 1755CREATE TABLE t6 (c1 SMALLINT NOT NULL); 1756INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1757INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1758INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 1759INSERT INTO t4 (c1) VALUES(10); 1760INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 1761-- sorted_result 1762SELECT t1.c1,t5.c1 FROM t1 NATURAL LEFT OUTER JOIN t5 ORDER BY t1.c1,t5.c1; 1763-- sorted_result 1764SELECT t1.c1,t5.c1 FROM t1 NATURAL LEFT OUTER JOIN t5 WHERE t1.c1 >= 5 ORDER BY t1.c1,t5.c1; 1765DROP TABLE t1,t2,t3,t4,t5,t6; 1766CREATE TABLE t1 (c1 MEDIUMINT NOT NULL); 1767CREATE TABLE t2 (c1 MEDIUMINT NOT NULL); 1768CREATE TABLE t3 (c1 MEDIUMINT NOT NULL); 1769CREATE TABLE t4 (c1 MEDIUMINT NOT NULL); 1770CREATE TABLE t5 (c1 MEDIUMINT NOT NULL); 1771CREATE TABLE t6 (c1 MEDIUMINT NOT NULL); 1772INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1773INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1774INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 1775INSERT INTO t4 (c1) VALUES(10); 1776INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 1777-- sorted_result 1778SELECT t1.c1,t5.c1 FROM t1 NATURAL LEFT OUTER JOIN t5 ORDER BY t1.c1,t5.c1; 1779-- sorted_result 1780SELECT t1.c1,t5.c1 FROM t1 NATURAL LEFT OUTER JOIN t5 WHERE t1.c1 >= 5 ORDER BY t1.c1,t5.c1; 1781DROP TABLE t1,t2,t3,t4,t5,t6; 1782CREATE TABLE t1 (c1 INT NOT NULL); 1783CREATE TABLE t2 (c1 INT NOT NULL); 1784CREATE TABLE t3 (c1 INT NOT NULL); 1785CREATE TABLE t4 (c1 INT NOT NULL); 1786CREATE TABLE t5 (c1 INT NOT NULL); 1787CREATE TABLE t6 (c1 INT NOT NULL); 1788INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1789INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1790INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 1791INSERT INTO t4 (c1) VALUES(10); 1792INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 1793-- sorted_result 1794SELECT t1.c1,t5.c1 FROM t1 NATURAL LEFT OUTER JOIN t5 ORDER BY t1.c1,t5.c1; 1795-- sorted_result 1796SELECT t1.c1,t5.c1 FROM t1 NATURAL LEFT OUTER JOIN t5 WHERE t1.c1 >= 5 ORDER BY t1.c1,t5.c1; 1797DROP TABLE t1,t2,t3,t4,t5,t6; 1798CREATE TABLE t1 (c1 INTEGER NOT NULL); 1799CREATE TABLE t2 (c1 INTEGER NOT NULL); 1800CREATE TABLE t3 (c1 INTEGER NOT NULL); 1801CREATE TABLE t4 (c1 INTEGER NOT NULL); 1802CREATE TABLE t5 (c1 INTEGER NOT NULL); 1803CREATE TABLE t6 (c1 INTEGER NOT NULL); 1804INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1805INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1806INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 1807INSERT INTO t4 (c1) VALUES(10); 1808INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 1809-- sorted_result 1810SELECT t1.c1,t5.c1 FROM t1 NATURAL LEFT OUTER JOIN t5 ORDER BY t1.c1,t5.c1; 1811-- sorted_result 1812SELECT t1.c1,t5.c1 FROM t1 NATURAL LEFT OUTER JOIN t5 WHERE t1.c1 >= 5 ORDER BY t1.c1,t5.c1; 1813DROP TABLE t1,t2,t3,t4,t5,t6; 1814CREATE TABLE t1 (c1 BIGINT NOT NULL); 1815CREATE TABLE t2 (c1 BIGINT NOT NULL); 1816CREATE TABLE t3 (c1 BIGINT NOT NULL); 1817CREATE TABLE t4 (c1 BIGINT NOT NULL); 1818CREATE TABLE t5 (c1 BIGINT NOT NULL); 1819CREATE TABLE t6 (c1 BIGINT NOT NULL); 1820INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1821INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1822INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 1823INSERT INTO t4 (c1) VALUES(10); 1824INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 1825-- sorted_result 1826SELECT t1.c1,t5.c1 FROM t1 NATURAL LEFT OUTER JOIN t5 ORDER BY t1.c1,t5.c1; 1827-- sorted_result 1828SELECT t1.c1,t5.c1 FROM t1 NATURAL LEFT OUTER JOIN t5 WHERE t1.c1 >= 5 ORDER BY t1.c1,t5.c1; 1829DROP TABLE t1,t2,t3,t4,t5,t6; 1830CREATE TABLE t1 (c1 TINYINT NOT NULL); 1831CREATE TABLE t2 (c1 TINYINT NOT NULL); 1832CREATE TABLE t3 (c1 TINYINT NOT NULL); 1833CREATE TABLE t4 (c1 TINYINT NOT NULL); 1834CREATE TABLE t5 (c1 TINYINT NOT NULL); 1835CREATE TABLE t6 (c1 TINYINT NOT NULL); 1836INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1837INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1838INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 1839INSERT INTO t4 (c1) VALUES(10); 1840INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 1841-- sorted_result 1842SELECT t1.c1,t6.c1 FROM t1 NATURAL LEFT OUTER JOIN t6 ORDER BY t1.c1,t6.c1; 1843-- sorted_result 1844SELECT t1.c1,t6.c1 FROM t1 NATURAL LEFT OUTER JOIN t6 WHERE t1.c1 >= 5 ORDER BY t1.c1,t6.c1; 1845DROP TABLE t1,t2,t3,t4,t5,t6; 1846CREATE TABLE t1 (c1 SMALLINT NOT NULL); 1847CREATE TABLE t2 (c1 SMALLINT NOT NULL); 1848CREATE TABLE t3 (c1 SMALLINT NOT NULL); 1849CREATE TABLE t4 (c1 SMALLINT NOT NULL); 1850CREATE TABLE t5 (c1 SMALLINT NOT NULL); 1851CREATE TABLE t6 (c1 SMALLINT NOT NULL); 1852INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1853INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1854INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 1855INSERT INTO t4 (c1) VALUES(10); 1856INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 1857-- sorted_result 1858SELECT t1.c1,t6.c1 FROM t1 NATURAL LEFT OUTER JOIN t6 ORDER BY t1.c1,t6.c1; 1859-- sorted_result 1860SELECT t1.c1,t6.c1 FROM t1 NATURAL LEFT OUTER JOIN t6 WHERE t1.c1 >= 5 ORDER BY t1.c1,t6.c1; 1861DROP TABLE t1,t2,t3,t4,t5,t6; 1862CREATE TABLE t1 (c1 MEDIUMINT NOT NULL); 1863CREATE TABLE t2 (c1 MEDIUMINT NOT NULL); 1864CREATE TABLE t3 (c1 MEDIUMINT NOT NULL); 1865CREATE TABLE t4 (c1 MEDIUMINT NOT NULL); 1866CREATE TABLE t5 (c1 MEDIUMINT NOT NULL); 1867CREATE TABLE t6 (c1 MEDIUMINT NOT NULL); 1868INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1869INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1870INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 1871INSERT INTO t4 (c1) VALUES(10); 1872INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 1873-- sorted_result 1874SELECT t1.c1,t6.c1 FROM t1 NATURAL LEFT OUTER JOIN t6 ORDER BY t1.c1,t6.c1; 1875-- sorted_result 1876SELECT t1.c1,t6.c1 FROM t1 NATURAL LEFT OUTER JOIN t6 WHERE t1.c1 >= 5 ORDER BY t1.c1,t6.c1; 1877DROP TABLE t1,t2,t3,t4,t5,t6; 1878CREATE TABLE t1 (c1 INT NOT NULL); 1879CREATE TABLE t2 (c1 INT NOT NULL); 1880CREATE TABLE t3 (c1 INT NOT NULL); 1881CREATE TABLE t4 (c1 INT NOT NULL); 1882CREATE TABLE t5 (c1 INT NOT NULL); 1883CREATE TABLE t6 (c1 INT NOT NULL); 1884INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1885INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1886INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 1887INSERT INTO t4 (c1) VALUES(10); 1888INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 1889-- sorted_result 1890SELECT t1.c1,t6.c1 FROM t1 NATURAL LEFT OUTER JOIN t6 ORDER BY t1.c1,t6.c1; 1891-- sorted_result 1892SELECT t1.c1,t6.c1 FROM t1 NATURAL LEFT OUTER JOIN t6 WHERE t1.c1 >= 5 ORDER BY t1.c1,t6.c1; 1893DROP TABLE t1,t2,t3,t4,t5,t6; 1894CREATE TABLE t1 (c1 INTEGER NOT NULL); 1895CREATE TABLE t2 (c1 INTEGER NOT NULL); 1896CREATE TABLE t3 (c1 INTEGER NOT NULL); 1897CREATE TABLE t4 (c1 INTEGER NOT NULL); 1898CREATE TABLE t5 (c1 INTEGER NOT NULL); 1899CREATE TABLE t6 (c1 INTEGER NOT NULL); 1900INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1901INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1902INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 1903INSERT INTO t4 (c1) VALUES(10); 1904INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 1905-- sorted_result 1906SELECT t1.c1,t6.c1 FROM t1 NATURAL LEFT OUTER JOIN t6 ORDER BY t1.c1,t6.c1; 1907-- sorted_result 1908SELECT t1.c1,t6.c1 FROM t1 NATURAL LEFT OUTER JOIN t6 WHERE t1.c1 >= 5 ORDER BY t1.c1,t6.c1; 1909DROP TABLE t1,t2,t3,t4,t5,t6; 1910CREATE TABLE t1 (c1 BIGINT NOT NULL); 1911CREATE TABLE t2 (c1 BIGINT NOT NULL); 1912CREATE TABLE t3 (c1 BIGINT NOT NULL); 1913CREATE TABLE t4 (c1 BIGINT NOT NULL); 1914CREATE TABLE t5 (c1 BIGINT NOT NULL); 1915CREATE TABLE t6 (c1 BIGINT NOT NULL); 1916INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1917INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1918INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 1919INSERT INTO t4 (c1) VALUES(10); 1920INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 1921-- sorted_result 1922SELECT t1.c1,t6.c1 FROM t1 NATURAL LEFT OUTER JOIN t6 ORDER BY t1.c1,t6.c1; 1923-- sorted_result 1924SELECT t1.c1,t6.c1 FROM t1 NATURAL LEFT OUTER JOIN t6 WHERE t1.c1 >= 5 ORDER BY t1.c1,t6.c1; 1925DROP TABLE t1,t2,t3,t4,t5,t6; 1926CREATE TABLE t1 (c1 TINYINT NOT NULL); 1927CREATE TABLE t2 (c1 TINYINT NOT NULL); 1928CREATE TABLE t3 (c1 TINYINT NOT NULL); 1929CREATE TABLE t4 (c1 TINYINT NOT NULL); 1930CREATE TABLE t5 (c1 TINYINT NOT NULL); 1931CREATE TABLE t6 (c1 TINYINT NOT NULL); 1932INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1933INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1934INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 1935INSERT INTO t4 (c1) VALUES(10); 1936INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 1937-- sorted_result 1938SELECT t1.c1,t2.c1 FROM t1 NATURAL LEFT OUTER JOIN t2 ORDER BY t1.c1,t2.c1; 1939-- sorted_result 1940SELECT t1.c1,t2.c1 FROM t1 NATURAL LEFT OUTER JOIN t2 WHERE t1.c1 != 5 ORDER BY t1.c1,t2.c1; 1941DROP TABLE t1,t2,t3,t4,t5,t6; 1942CREATE TABLE t1 (c1 SMALLINT NOT NULL); 1943CREATE TABLE t2 (c1 SMALLINT NOT NULL); 1944CREATE TABLE t3 (c1 SMALLINT NOT NULL); 1945CREATE TABLE t4 (c1 SMALLINT NOT NULL); 1946CREATE TABLE t5 (c1 SMALLINT NOT NULL); 1947CREATE TABLE t6 (c1 SMALLINT NOT NULL); 1948INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1949INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1950INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 1951INSERT INTO t4 (c1) VALUES(10); 1952INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 1953-- sorted_result 1954SELECT t1.c1,t2.c1 FROM t1 NATURAL LEFT OUTER JOIN t2 ORDER BY t1.c1,t2.c1; 1955-- sorted_result 1956SELECT t1.c1,t2.c1 FROM t1 NATURAL LEFT OUTER JOIN t2 WHERE t1.c1 != 5 ORDER BY t1.c1,t2.c1; 1957DROP TABLE t1,t2,t3,t4,t5,t6; 1958CREATE TABLE t1 (c1 MEDIUMINT NOT NULL); 1959CREATE TABLE t2 (c1 MEDIUMINT NOT NULL); 1960CREATE TABLE t3 (c1 MEDIUMINT NOT NULL); 1961CREATE TABLE t4 (c1 MEDIUMINT NOT NULL); 1962CREATE TABLE t5 (c1 MEDIUMINT NOT NULL); 1963CREATE TABLE t6 (c1 MEDIUMINT NOT NULL); 1964INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1965INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1966INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 1967INSERT INTO t4 (c1) VALUES(10); 1968INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 1969-- sorted_result 1970SELECT t1.c1,t2.c1 FROM t1 NATURAL LEFT OUTER JOIN t2 ORDER BY t1.c1,t2.c1; 1971-- sorted_result 1972SELECT t1.c1,t2.c1 FROM t1 NATURAL LEFT OUTER JOIN t2 WHERE t1.c1 != 5 ORDER BY t1.c1,t2.c1; 1973DROP TABLE t1,t2,t3,t4,t5,t6; 1974CREATE TABLE t1 (c1 INT NOT NULL); 1975CREATE TABLE t2 (c1 INT NOT NULL); 1976CREATE TABLE t3 (c1 INT NOT NULL); 1977CREATE TABLE t4 (c1 INT NOT NULL); 1978CREATE TABLE t5 (c1 INT NOT NULL); 1979CREATE TABLE t6 (c1 INT NOT NULL); 1980INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1981INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1982INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 1983INSERT INTO t4 (c1) VALUES(10); 1984INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 1985-- sorted_result 1986SELECT t1.c1,t2.c1 FROM t1 NATURAL LEFT OUTER JOIN t2 ORDER BY t1.c1,t2.c1; 1987-- sorted_result 1988SELECT t1.c1,t2.c1 FROM t1 NATURAL LEFT OUTER JOIN t2 WHERE t1.c1 != 5 ORDER BY t1.c1,t2.c1; 1989DROP TABLE t1,t2,t3,t4,t5,t6; 1990CREATE TABLE t1 (c1 INTEGER NOT NULL); 1991CREATE TABLE t2 (c1 INTEGER NOT NULL); 1992CREATE TABLE t3 (c1 INTEGER NOT NULL); 1993CREATE TABLE t4 (c1 INTEGER NOT NULL); 1994CREATE TABLE t5 (c1 INTEGER NOT NULL); 1995CREATE TABLE t6 (c1 INTEGER NOT NULL); 1996INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1997INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1998INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 1999INSERT INTO t4 (c1) VALUES(10); 2000INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 2001-- sorted_result 2002SELECT t1.c1,t2.c1 FROM t1 NATURAL LEFT OUTER JOIN t2 ORDER BY t1.c1,t2.c1; 2003-- sorted_result 2004SELECT t1.c1,t2.c1 FROM t1 NATURAL LEFT OUTER JOIN t2 WHERE t1.c1 != 5 ORDER BY t1.c1,t2.c1; 2005DROP TABLE t1,t2,t3,t4,t5,t6; 2006CREATE TABLE t1 (c1 BIGINT NOT NULL); 2007CREATE TABLE t2 (c1 BIGINT NOT NULL); 2008CREATE TABLE t3 (c1 BIGINT NOT NULL); 2009CREATE TABLE t4 (c1 BIGINT NOT NULL); 2010CREATE TABLE t5 (c1 BIGINT NOT NULL); 2011CREATE TABLE t6 (c1 BIGINT 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); 2017-- sorted_result 2018SELECT t1.c1,t2.c1 FROM t1 NATURAL LEFT OUTER JOIN t2 ORDER BY t1.c1,t2.c1; 2019-- sorted_result 2020SELECT t1.c1,t2.c1 FROM t1 NATURAL LEFT OUTER JOIN t2 WHERE t1.c1 != 5 ORDER BY t1.c1,t2.c1; 2021DROP TABLE t1,t2,t3,t4,t5,t6; 2022CREATE TABLE t1 (c1 TINYINT NOT NULL); 2023CREATE TABLE t2 (c1 TINYINT NOT NULL); 2024CREATE TABLE t3 (c1 TINYINT NOT NULL); 2025CREATE TABLE t4 (c1 TINYINT NOT NULL); 2026CREATE TABLE t5 (c1 TINYINT NOT NULL); 2027CREATE TABLE t6 (c1 TINYINT NOT NULL); 2028INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2029INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2030INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 2031INSERT INTO t4 (c1) VALUES(10); 2032INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 2033-- sorted_result 2034SELECT t1.c1,t3.c1 FROM t1 NATURAL LEFT OUTER JOIN t3 ORDER BY t1.c1,t3.c1; 2035-- sorted_result 2036SELECT t1.c1,t3.c1 FROM t1 NATURAL LEFT OUTER JOIN t3 WHERE t1.c1 != 5 ORDER BY t1.c1,t3.c1; 2037DROP TABLE t1,t2,t3,t4,t5,t6; 2038CREATE TABLE t1 (c1 SMALLINT NOT NULL); 2039CREATE TABLE t2 (c1 SMALLINT NOT NULL); 2040CREATE TABLE t3 (c1 SMALLINT NOT NULL); 2041CREATE TABLE t4 (c1 SMALLINT NOT NULL); 2042CREATE TABLE t5 (c1 SMALLINT NOT NULL); 2043CREATE TABLE t6 (c1 SMALLINT NOT NULL); 2044INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2045INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2046INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 2047INSERT INTO t4 (c1) VALUES(10); 2048INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 2049-- sorted_result 2050SELECT t1.c1,t3.c1 FROM t1 NATURAL LEFT OUTER JOIN t3 ORDER BY t1.c1,t3.c1; 2051-- sorted_result 2052SELECT t1.c1,t3.c1 FROM t1 NATURAL LEFT OUTER JOIN t3 WHERE t1.c1 != 5 ORDER BY t1.c1,t3.c1; 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); 2065-- sorted_result 2066SELECT t1.c1,t3.c1 FROM t1 NATURAL LEFT OUTER JOIN t3 ORDER BY t1.c1,t3.c1; 2067-- sorted_result 2068SELECT t1.c1,t3.c1 FROM t1 NATURAL LEFT OUTER JOIN t3 WHERE t1.c1 != 5 ORDER BY t1.c1,t3.c1; 2069DROP TABLE t1,t2,t3,t4,t5,t6; 2070CREATE TABLE t1 (c1 INT NOT NULL); 2071CREATE TABLE t2 (c1 INT NOT NULL); 2072CREATE TABLE t3 (c1 INT NOT NULL); 2073CREATE TABLE t4 (c1 INT NOT NULL); 2074CREATE TABLE t5 (c1 INT NOT NULL); 2075CREATE TABLE t6 (c1 INT NOT NULL); 2076INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2077INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2078INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 2079INSERT INTO t4 (c1) VALUES(10); 2080INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 2081-- sorted_result 2082SELECT t1.c1,t3.c1 FROM t1 NATURAL LEFT OUTER JOIN t3 ORDER BY t1.c1,t3.c1; 2083-- sorted_result 2084SELECT t1.c1,t3.c1 FROM t1 NATURAL LEFT OUTER JOIN t3 WHERE t1.c1 != 5 ORDER BY t1.c1,t3.c1; 2085DROP TABLE t1,t2,t3,t4,t5,t6; 2086CREATE TABLE t1 (c1 INTEGER NOT NULL); 2087CREATE TABLE t2 (c1 INTEGER NOT NULL); 2088CREATE TABLE t3 (c1 INTEGER NOT NULL); 2089CREATE TABLE t4 (c1 INTEGER NOT NULL); 2090CREATE TABLE t5 (c1 INTEGER NOT NULL); 2091CREATE TABLE t6 (c1 INTEGER NOT NULL); 2092INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2093INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2094INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 2095INSERT INTO t4 (c1) VALUES(10); 2096INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 2097-- sorted_result 2098SELECT t1.c1,t3.c1 FROM t1 NATURAL LEFT OUTER JOIN t3 ORDER BY t1.c1,t3.c1; 2099-- sorted_result 2100SELECT t1.c1,t3.c1 FROM t1 NATURAL LEFT OUTER JOIN t3 WHERE t1.c1 != 5 ORDER BY t1.c1,t3.c1; 2101DROP TABLE t1,t2,t3,t4,t5,t6; 2102CREATE TABLE t1 (c1 BIGINT NOT NULL); 2103CREATE TABLE t2 (c1 BIGINT NOT NULL); 2104CREATE TABLE t3 (c1 BIGINT NOT NULL); 2105CREATE TABLE t4 (c1 BIGINT NOT NULL); 2106CREATE TABLE t5 (c1 BIGINT NOT NULL); 2107CREATE TABLE t6 (c1 BIGINT 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); 2113-- sorted_result 2114SELECT t1.c1,t3.c1 FROM t1 NATURAL LEFT OUTER JOIN t3 ORDER BY t1.c1,t3.c1; 2115-- sorted_result 2116SELECT t1.c1,t3.c1 FROM t1 NATURAL LEFT OUTER JOIN t3 WHERE t1.c1 != 5 ORDER BY t1.c1,t3.c1; 2117DROP TABLE t1,t2,t3,t4,t5,t6; 2118CREATE TABLE t1 (c1 TINYINT NOT NULL); 2119CREATE TABLE t2 (c1 TINYINT NOT NULL); 2120CREATE TABLE t3 (c1 TINYINT NOT NULL); 2121CREATE TABLE t4 (c1 TINYINT NOT NULL); 2122CREATE TABLE t5 (c1 TINYINT NOT NULL); 2123CREATE TABLE t6 (c1 TINYINT NOT NULL); 2124INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2125INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2126INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 2127INSERT INTO t4 (c1) VALUES(10); 2128INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 2129-- sorted_result 2130SELECT t1.c1,t4.c1 FROM t1 NATURAL LEFT OUTER JOIN t4 ORDER BY t1.c1,t4.c1; 2131-- sorted_result 2132SELECT t1.c1,t4.c1 FROM t1 NATURAL LEFT OUTER JOIN t4 WHERE t1.c1 != 5 ORDER BY t1.c1,t4.c1; 2133DROP TABLE t1,t2,t3,t4,t5,t6; 2134CREATE TABLE t1 (c1 SMALLINT NOT NULL); 2135CREATE TABLE t2 (c1 SMALLINT NOT NULL); 2136CREATE TABLE t3 (c1 SMALLINT NOT NULL); 2137CREATE TABLE t4 (c1 SMALLINT NOT NULL); 2138CREATE TABLE t5 (c1 SMALLINT NOT NULL); 2139CREATE TABLE t6 (c1 SMALLINT NOT NULL); 2140INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2141INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2142INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 2143INSERT INTO t4 (c1) VALUES(10); 2144INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 2145-- sorted_result 2146SELECT t1.c1,t4.c1 FROM t1 NATURAL LEFT OUTER JOIN t4 ORDER BY t1.c1,t4.c1; 2147-- sorted_result 2148SELECT t1.c1,t4.c1 FROM t1 NATURAL LEFT OUTER JOIN t4 WHERE t1.c1 != 5 ORDER BY t1.c1,t4.c1; 2149DROP TABLE t1,t2,t3,t4,t5,t6; 2150CREATE TABLE t1 (c1 MEDIUMINT NOT NULL); 2151CREATE TABLE t2 (c1 MEDIUMINT NOT NULL); 2152CREATE TABLE t3 (c1 MEDIUMINT NOT NULL); 2153CREATE TABLE t4 (c1 MEDIUMINT NOT NULL); 2154CREATE TABLE t5 (c1 MEDIUMINT NOT NULL); 2155CREATE TABLE t6 (c1 MEDIUMINT 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); 2161-- sorted_result 2162SELECT t1.c1,t4.c1 FROM t1 NATURAL LEFT OUTER JOIN t4 ORDER BY t1.c1,t4.c1; 2163-- sorted_result 2164SELECT t1.c1,t4.c1 FROM t1 NATURAL LEFT OUTER JOIN t4 WHERE t1.c1 != 5 ORDER BY t1.c1,t4.c1; 2165DROP TABLE t1,t2,t3,t4,t5,t6; 2166CREATE TABLE t1 (c1 INT NOT NULL); 2167CREATE TABLE t2 (c1 INT NOT NULL); 2168CREATE TABLE t3 (c1 INT NOT NULL); 2169CREATE TABLE t4 (c1 INT NOT NULL); 2170CREATE TABLE t5 (c1 INT NOT NULL); 2171CREATE TABLE t6 (c1 INT 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); 2177-- sorted_result 2178SELECT t1.c1,t4.c1 FROM t1 NATURAL LEFT OUTER JOIN t4 ORDER BY t1.c1,t4.c1; 2179-- sorted_result 2180SELECT t1.c1,t4.c1 FROM t1 NATURAL LEFT OUTER JOIN t4 WHERE t1.c1 != 5 ORDER BY t1.c1,t4.c1; 2181DROP TABLE t1,t2,t3,t4,t5,t6; 2182CREATE TABLE t1 (c1 INTEGER NOT NULL); 2183CREATE TABLE t2 (c1 INTEGER NOT NULL); 2184CREATE TABLE t3 (c1 INTEGER NOT NULL); 2185CREATE TABLE t4 (c1 INTEGER NOT NULL); 2186CREATE TABLE t5 (c1 INTEGER NOT NULL); 2187CREATE TABLE t6 (c1 INTEGER 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); 2193-- sorted_result 2194SELECT t1.c1,t4.c1 FROM t1 NATURAL LEFT OUTER JOIN t4 ORDER BY t1.c1,t4.c1; 2195-- sorted_result 2196SELECT t1.c1,t4.c1 FROM t1 NATURAL LEFT OUTER JOIN t4 WHERE t1.c1 != 5 ORDER BY t1.c1,t4.c1; 2197DROP TABLE t1,t2,t3,t4,t5,t6; 2198CREATE TABLE t1 (c1 BIGINT NOT NULL); 2199CREATE TABLE t2 (c1 BIGINT NOT NULL); 2200CREATE TABLE t3 (c1 BIGINT NOT NULL); 2201CREATE TABLE t4 (c1 BIGINT NOT NULL); 2202CREATE TABLE t5 (c1 BIGINT NOT NULL); 2203CREATE TABLE t6 (c1 BIGINT 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); 2209-- sorted_result 2210SELECT t1.c1,t4.c1 FROM t1 NATURAL LEFT OUTER JOIN t4 ORDER BY t1.c1,t4.c1; 2211-- sorted_result 2212SELECT t1.c1,t4.c1 FROM t1 NATURAL LEFT OUTER JOIN t4 WHERE t1.c1 != 5 ORDER BY t1.c1,t4.c1; 2213DROP TABLE t1,t2,t3,t4,t5,t6; 2214CREATE TABLE t1 (c1 TINYINT NOT NULL); 2215CREATE TABLE t2 (c1 TINYINT NOT NULL); 2216CREATE TABLE t3 (c1 TINYINT NOT NULL); 2217CREATE TABLE t4 (c1 TINYINT NOT NULL); 2218CREATE TABLE t5 (c1 TINYINT NOT NULL); 2219CREATE TABLE t6 (c1 TINYINT 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); 2225-- sorted_result 2226SELECT t1.c1,t5.c1 FROM t1 NATURAL LEFT OUTER JOIN t5 ORDER BY t1.c1,t5.c1; 2227-- sorted_result 2228SELECT t1.c1,t5.c1 FROM t1 NATURAL LEFT OUTER JOIN t5 WHERE t1.c1 != 5 ORDER BY t1.c1,t5.c1; 2229DROP TABLE t1,t2,t3,t4,t5,t6; 2230CREATE TABLE t1 (c1 SMALLINT NOT NULL); 2231CREATE TABLE t2 (c1 SMALLINT NOT NULL); 2232CREATE TABLE t3 (c1 SMALLINT NOT NULL); 2233CREATE TABLE t4 (c1 SMALLINT NOT NULL); 2234CREATE TABLE t5 (c1 SMALLINT NOT NULL); 2235CREATE TABLE t6 (c1 SMALLINT 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); 2241-- sorted_result 2242SELECT t1.c1,t5.c1 FROM t1 NATURAL LEFT OUTER JOIN t5 ORDER BY t1.c1,t5.c1; 2243-- sorted_result 2244SELECT t1.c1,t5.c1 FROM t1 NATURAL LEFT OUTER JOIN t5 WHERE t1.c1 != 5 ORDER BY t1.c1,t5.c1; 2245DROP TABLE t1,t2,t3,t4,t5,t6; 2246CREATE TABLE t1 (c1 MEDIUMINT NOT NULL); 2247CREATE TABLE t2 (c1 MEDIUMINT NOT NULL); 2248CREATE TABLE t3 (c1 MEDIUMINT NOT NULL); 2249CREATE TABLE t4 (c1 MEDIUMINT NOT NULL); 2250CREATE TABLE t5 (c1 MEDIUMINT NOT NULL); 2251CREATE TABLE t6 (c1 MEDIUMINT 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); 2257-- sorted_result 2258SELECT t1.c1,t5.c1 FROM t1 NATURAL LEFT OUTER JOIN t5 ORDER BY t1.c1,t5.c1; 2259-- sorted_result 2260SELECT t1.c1,t5.c1 FROM t1 NATURAL LEFT OUTER JOIN t5 WHERE t1.c1 != 5 ORDER BY t1.c1,t5.c1; 2261DROP TABLE t1,t2,t3,t4,t5,t6; 2262CREATE TABLE t1 (c1 INT NOT NULL); 2263CREATE TABLE t2 (c1 INT NOT NULL); 2264CREATE TABLE t3 (c1 INT NOT NULL); 2265CREATE TABLE t4 (c1 INT NOT NULL); 2266CREATE TABLE t5 (c1 INT NOT NULL); 2267CREATE TABLE t6 (c1 INT 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); 2273-- sorted_result 2274SELECT t1.c1,t5.c1 FROM t1 NATURAL LEFT OUTER JOIN t5 ORDER BY t1.c1,t5.c1; 2275-- sorted_result 2276SELECT t1.c1,t5.c1 FROM t1 NATURAL LEFT OUTER JOIN t5 WHERE t1.c1 != 5 ORDER BY t1.c1,t5.c1; 2277DROP TABLE t1,t2,t3,t4,t5,t6; 2278CREATE TABLE t1 (c1 INTEGER NOT NULL); 2279CREATE TABLE t2 (c1 INTEGER NOT NULL); 2280CREATE TABLE t3 (c1 INTEGER NOT NULL); 2281CREATE TABLE t4 (c1 INTEGER NOT NULL); 2282CREATE TABLE t5 (c1 INTEGER NOT NULL); 2283CREATE TABLE t6 (c1 INTEGER 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); 2289-- sorted_result 2290SELECT t1.c1,t5.c1 FROM t1 NATURAL LEFT OUTER JOIN t5 ORDER BY t1.c1,t5.c1; 2291-- sorted_result 2292SELECT t1.c1,t5.c1 FROM t1 NATURAL LEFT OUTER JOIN t5 WHERE t1.c1 != 5 ORDER BY t1.c1,t5.c1; 2293DROP TABLE t1,t2,t3,t4,t5,t6; 2294CREATE TABLE t1 (c1 BIGINT NOT NULL); 2295CREATE TABLE t2 (c1 BIGINT NOT NULL); 2296CREATE TABLE t3 (c1 BIGINT NOT NULL); 2297CREATE TABLE t4 (c1 BIGINT NOT NULL); 2298CREATE TABLE t5 (c1 BIGINT NOT NULL); 2299CREATE TABLE t6 (c1 BIGINT 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); 2305-- sorted_result 2306SELECT t1.c1,t5.c1 FROM t1 NATURAL LEFT OUTER JOIN t5 ORDER BY t1.c1,t5.c1; 2307-- sorted_result 2308SELECT t1.c1,t5.c1 FROM t1 NATURAL LEFT OUTER JOIN t5 WHERE t1.c1 != 5 ORDER BY t1.c1,t5.c1; 2309DROP TABLE t1,t2,t3,t4,t5,t6; 2310CREATE TABLE t1 (c1 TINYINT NOT NULL); 2311CREATE TABLE t2 (c1 TINYINT NOT NULL); 2312CREATE TABLE t3 (c1 TINYINT NOT NULL); 2313CREATE TABLE t4 (c1 TINYINT NOT NULL); 2314CREATE TABLE t5 (c1 TINYINT NOT NULL); 2315CREATE TABLE t6 (c1 TINYINT 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); 2321-- sorted_result 2322SELECT t1.c1,t6.c1 FROM t1 NATURAL LEFT OUTER JOIN t6 ORDER BY t1.c1,t6.c1; 2323-- sorted_result 2324SELECT t1.c1,t6.c1 FROM t1 NATURAL LEFT OUTER JOIN t6 WHERE t1.c1 != 5 ORDER BY t1.c1,t6.c1; 2325DROP TABLE t1,t2,t3,t4,t5,t6; 2326CREATE TABLE t1 (c1 SMALLINT NOT NULL); 2327CREATE TABLE t2 (c1 SMALLINT NOT NULL); 2328CREATE TABLE t3 (c1 SMALLINT NOT NULL); 2329CREATE TABLE t4 (c1 SMALLINT NOT NULL); 2330CREATE TABLE t5 (c1 SMALLINT NOT NULL); 2331CREATE TABLE t6 (c1 SMALLINT 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); 2337-- sorted_result 2338SELECT t1.c1,t6.c1 FROM t1 NATURAL LEFT OUTER JOIN t6 ORDER BY t1.c1,t6.c1; 2339-- sorted_result 2340SELECT t1.c1,t6.c1 FROM t1 NATURAL LEFT OUTER JOIN t6 WHERE t1.c1 != 5 ORDER BY t1.c1,t6.c1; 2341DROP TABLE t1,t2,t3,t4,t5,t6; 2342CREATE TABLE t1 (c1 MEDIUMINT NOT NULL); 2343CREATE TABLE t2 (c1 MEDIUMINT NOT NULL); 2344CREATE TABLE t3 (c1 MEDIUMINT NOT NULL); 2345CREATE TABLE t4 (c1 MEDIUMINT NOT NULL); 2346CREATE TABLE t5 (c1 MEDIUMINT NOT NULL); 2347CREATE TABLE t6 (c1 MEDIUMINT 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); 2353-- sorted_result 2354SELECT t1.c1,t6.c1 FROM t1 NATURAL LEFT OUTER JOIN t6 ORDER BY t1.c1,t6.c1; 2355-- sorted_result 2356SELECT t1.c1,t6.c1 FROM t1 NATURAL LEFT OUTER JOIN t6 WHERE t1.c1 != 5 ORDER BY t1.c1,t6.c1; 2357DROP TABLE t1,t2,t3,t4,t5,t6; 2358CREATE TABLE t1 (c1 INT NOT NULL); 2359CREATE TABLE t2 (c1 INT NOT NULL); 2360CREATE TABLE t3 (c1 INT NOT NULL); 2361CREATE TABLE t4 (c1 INT NOT NULL); 2362CREATE TABLE t5 (c1 INT NOT NULL); 2363CREATE TABLE t6 (c1 INT 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); 2369-- sorted_result 2370SELECT t1.c1,t6.c1 FROM t1 NATURAL LEFT OUTER JOIN t6 ORDER BY t1.c1,t6.c1; 2371-- sorted_result 2372SELECT t1.c1,t6.c1 FROM t1 NATURAL LEFT OUTER JOIN t6 WHERE t1.c1 != 5 ORDER BY t1.c1,t6.c1; 2373DROP TABLE t1,t2,t3,t4,t5,t6; 2374CREATE TABLE t1 (c1 INTEGER NOT NULL); 2375CREATE TABLE t2 (c1 INTEGER NOT NULL); 2376CREATE TABLE t3 (c1 INTEGER NOT NULL); 2377CREATE TABLE t4 (c1 INTEGER NOT NULL); 2378CREATE TABLE t5 (c1 INTEGER NOT NULL); 2379CREATE TABLE t6 (c1 INTEGER 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); 2385-- sorted_result 2386SELECT t1.c1,t6.c1 FROM t1 NATURAL LEFT OUTER JOIN t6 ORDER BY t1.c1,t6.c1; 2387-- sorted_result 2388SELECT t1.c1,t6.c1 FROM t1 NATURAL LEFT OUTER JOIN t6 WHERE t1.c1 != 5 ORDER BY t1.c1,t6.c1; 2389DROP TABLE t1,t2,t3,t4,t5,t6; 2390CREATE TABLE t1 (c1 BIGINT NOT NULL); 2391CREATE TABLE t2 (c1 BIGINT NOT NULL); 2392CREATE TABLE t3 (c1 BIGINT NOT NULL); 2393CREATE TABLE t4 (c1 BIGINT NOT NULL); 2394CREATE TABLE t5 (c1 BIGINT NOT NULL); 2395CREATE TABLE t6 (c1 BIGINT 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); 2401-- sorted_result 2402SELECT t1.c1,t6.c1 FROM t1 NATURAL LEFT OUTER JOIN t6 ORDER BY t1.c1,t6.c1; 2403-- sorted_result 2404SELECT t1.c1,t6.c1 FROM t1 NATURAL LEFT OUTER JOIN t6 WHERE t1.c1 != 5 ORDER BY t1.c1,t6.c1; 2405DROP TABLE t1,t2,t3,t4,t5,t6; 2406CREATE TABLE t1 (c1 TINYINT NOT NULL); 2407CREATE TABLE t2 (c1 TINYINT NOT NULL); 2408CREATE TABLE t3 (c1 TINYINT NOT NULL); 2409CREATE TABLE t4 (c1 TINYINT NOT NULL); 2410CREATE TABLE t5 (c1 TINYINT NOT NULL); 2411CREATE TABLE t6 (c1 TINYINT 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); 2417-- sorted_result 2418SELECT t1.c1,t2.c1 FROM t1 NATURAL LEFT OUTER JOIN t2 ORDER BY t1.c1,t2.c1; 2419-- sorted_result 2420SELECT t1.c1,t2.c1 FROM t1 NATURAL LEFT OUTER JOIN t2 WHERE t1.c1 <> 5 ORDER BY t1.c1,t2.c1; 2421DROP TABLE t1,t2,t3,t4,t5,t6; 2422CREATE TABLE t1 (c1 SMALLINT NOT NULL); 2423CREATE TABLE t2 (c1 SMALLINT NOT NULL); 2424CREATE TABLE t3 (c1 SMALLINT NOT NULL); 2425CREATE TABLE t4 (c1 SMALLINT NOT NULL); 2426CREATE TABLE t5 (c1 SMALLINT NOT NULL); 2427CREATE TABLE t6 (c1 SMALLINT 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); 2433-- sorted_result 2434SELECT t1.c1,t2.c1 FROM t1 NATURAL LEFT OUTER JOIN t2 ORDER BY t1.c1,t2.c1; 2435-- sorted_result 2436SELECT t1.c1,t2.c1 FROM t1 NATURAL LEFT OUTER JOIN t2 WHERE t1.c1 <> 5 ORDER BY t1.c1,t2.c1; 2437DROP TABLE t1,t2,t3,t4,t5,t6; 2438CREATE TABLE t1 (c1 MEDIUMINT NOT NULL); 2439CREATE TABLE t2 (c1 MEDIUMINT NOT NULL); 2440CREATE TABLE t3 (c1 MEDIUMINT NOT NULL); 2441CREATE TABLE t4 (c1 MEDIUMINT NOT NULL); 2442CREATE TABLE t5 (c1 MEDIUMINT NOT NULL); 2443CREATE TABLE t6 (c1 MEDIUMINT 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); 2449-- sorted_result 2450SELECT t1.c1,t2.c1 FROM t1 NATURAL LEFT OUTER JOIN t2 ORDER BY t1.c1,t2.c1; 2451-- sorted_result 2452SELECT t1.c1,t2.c1 FROM t1 NATURAL LEFT OUTER JOIN t2 WHERE t1.c1 <> 5 ORDER BY t1.c1,t2.c1; 2453DROP TABLE t1,t2,t3,t4,t5,t6; 2454CREATE TABLE t1 (c1 INT NOT NULL); 2455CREATE TABLE t2 (c1 INT NOT NULL); 2456CREATE TABLE t3 (c1 INT NOT NULL); 2457CREATE TABLE t4 (c1 INT NOT NULL); 2458CREATE TABLE t5 (c1 INT NOT NULL); 2459CREATE TABLE t6 (c1 INT NOT NULL); 2460INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2461INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2462INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 2463INSERT INTO t4 (c1) VALUES(10); 2464INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 2465-- sorted_result 2466SELECT t1.c1,t2.c1 FROM t1 NATURAL LEFT OUTER JOIN t2 ORDER BY t1.c1,t2.c1; 2467-- sorted_result 2468SELECT t1.c1,t2.c1 FROM t1 NATURAL LEFT OUTER JOIN t2 WHERE t1.c1 <> 5 ORDER BY t1.c1,t2.c1; 2469DROP TABLE t1,t2,t3,t4,t5,t6; 2470CREATE TABLE t1 (c1 INTEGER NOT NULL); 2471CREATE TABLE t2 (c1 INTEGER NOT NULL); 2472CREATE TABLE t3 (c1 INTEGER NOT NULL); 2473CREATE TABLE t4 (c1 INTEGER NOT NULL); 2474CREATE TABLE t5 (c1 INTEGER NOT NULL); 2475CREATE TABLE t6 (c1 INTEGER NOT NULL); 2476INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2477INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2478INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 2479INSERT INTO t4 (c1) VALUES(10); 2480INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 2481-- sorted_result 2482SELECT t1.c1,t2.c1 FROM t1 NATURAL LEFT OUTER JOIN t2 ORDER BY t1.c1,t2.c1; 2483-- sorted_result 2484SELECT t1.c1,t2.c1 FROM t1 NATURAL LEFT OUTER JOIN t2 WHERE t1.c1 <> 5 ORDER BY t1.c1,t2.c1; 2485DROP TABLE t1,t2,t3,t4,t5,t6; 2486CREATE TABLE t1 (c1 BIGINT NOT NULL); 2487CREATE TABLE t2 (c1 BIGINT NOT NULL); 2488CREATE TABLE t3 (c1 BIGINT NOT NULL); 2489CREATE TABLE t4 (c1 BIGINT NOT NULL); 2490CREATE TABLE t5 (c1 BIGINT NOT NULL); 2491CREATE TABLE t6 (c1 BIGINT NOT NULL); 2492INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2493INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2494INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 2495INSERT INTO t4 (c1) VALUES(10); 2496INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 2497-- sorted_result 2498SELECT t1.c1,t2.c1 FROM t1 NATURAL LEFT OUTER JOIN t2 ORDER BY t1.c1,t2.c1; 2499-- sorted_result 2500SELECT t1.c1,t2.c1 FROM t1 NATURAL LEFT OUTER JOIN t2 WHERE t1.c1 <> 5 ORDER BY t1.c1,t2.c1; 2501DROP TABLE t1,t2,t3,t4,t5,t6; 2502CREATE TABLE t1 (c1 TINYINT NOT NULL); 2503CREATE TABLE t2 (c1 TINYINT NOT NULL); 2504CREATE TABLE t3 (c1 TINYINT NOT NULL); 2505CREATE TABLE t4 (c1 TINYINT NOT NULL); 2506CREATE TABLE t5 (c1 TINYINT NOT NULL); 2507CREATE TABLE t6 (c1 TINYINT NOT NULL); 2508INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2509INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2510INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 2511INSERT INTO t4 (c1) VALUES(10); 2512INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 2513-- sorted_result 2514SELECT t1.c1,t3.c1 FROM t1 NATURAL LEFT OUTER JOIN t3 ORDER BY t1.c1,t3.c1; 2515-- sorted_result 2516SELECT t1.c1,t3.c1 FROM t1 NATURAL LEFT OUTER JOIN t3 WHERE t1.c1 <> 5 ORDER BY t1.c1,t3.c1; 2517DROP TABLE t1,t2,t3,t4,t5,t6; 2518CREATE TABLE t1 (c1 SMALLINT NOT NULL); 2519CREATE TABLE t2 (c1 SMALLINT NOT NULL); 2520CREATE TABLE t3 (c1 SMALLINT NOT NULL); 2521CREATE TABLE t4 (c1 SMALLINT NOT NULL); 2522CREATE TABLE t5 (c1 SMALLINT NOT NULL); 2523CREATE TABLE t6 (c1 SMALLINT NOT NULL); 2524INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2525INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2526INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 2527INSERT INTO t4 (c1) VALUES(10); 2528INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 2529-- sorted_result 2530SELECT t1.c1,t3.c1 FROM t1 NATURAL LEFT OUTER JOIN t3 ORDER BY t1.c1,t3.c1; 2531-- sorted_result 2532SELECT t1.c1,t3.c1 FROM t1 NATURAL LEFT OUTER JOIN t3 WHERE t1.c1 <> 5 ORDER BY t1.c1,t3.c1; 2533DROP TABLE t1,t2,t3,t4,t5,t6; 2534CREATE TABLE t1 (c1 MEDIUMINT NOT NULL); 2535CREATE TABLE t2 (c1 MEDIUMINT NOT NULL); 2536CREATE TABLE t3 (c1 MEDIUMINT NOT NULL); 2537CREATE TABLE t4 (c1 MEDIUMINT NOT NULL); 2538CREATE TABLE t5 (c1 MEDIUMINT NOT NULL); 2539CREATE TABLE t6 (c1 MEDIUMINT NOT NULL); 2540INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2541INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2542INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 2543INSERT INTO t4 (c1) VALUES(10); 2544INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 2545-- sorted_result 2546SELECT t1.c1,t3.c1 FROM t1 NATURAL LEFT OUTER JOIN t3 ORDER BY t1.c1,t3.c1; 2547-- sorted_result 2548SELECT t1.c1,t3.c1 FROM t1 NATURAL LEFT OUTER JOIN t3 WHERE t1.c1 <> 5 ORDER BY t1.c1,t3.c1; 2549DROP TABLE t1,t2,t3,t4,t5,t6; 2550CREATE TABLE t1 (c1 INT NOT NULL); 2551CREATE TABLE t2 (c1 INT NOT NULL); 2552CREATE TABLE t3 (c1 INT NOT NULL); 2553CREATE TABLE t4 (c1 INT NOT NULL); 2554CREATE TABLE t5 (c1 INT NOT NULL); 2555CREATE TABLE t6 (c1 INT NOT NULL); 2556INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2557INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2558INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 2559INSERT INTO t4 (c1) VALUES(10); 2560INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 2561-- sorted_result 2562SELECT t1.c1,t3.c1 FROM t1 NATURAL LEFT OUTER JOIN t3 ORDER BY t1.c1,t3.c1; 2563-- sorted_result 2564SELECT t1.c1,t3.c1 FROM t1 NATURAL LEFT OUTER JOIN t3 WHERE t1.c1 <> 5 ORDER BY t1.c1,t3.c1; 2565DROP TABLE t1,t2,t3,t4,t5,t6; 2566CREATE TABLE t1 (c1 INTEGER NOT NULL); 2567CREATE TABLE t2 (c1 INTEGER NOT NULL); 2568CREATE TABLE t3 (c1 INTEGER NOT NULL); 2569CREATE TABLE t4 (c1 INTEGER NOT NULL); 2570CREATE TABLE t5 (c1 INTEGER NOT NULL); 2571CREATE TABLE t6 (c1 INTEGER NOT NULL); 2572INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2573INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2574INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 2575INSERT INTO t4 (c1) VALUES(10); 2576INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 2577-- sorted_result 2578SELECT t1.c1,t3.c1 FROM t1 NATURAL LEFT OUTER JOIN t3 ORDER BY t1.c1,t3.c1; 2579-- sorted_result 2580SELECT t1.c1,t3.c1 FROM t1 NATURAL LEFT OUTER JOIN t3 WHERE t1.c1 <> 5 ORDER BY t1.c1,t3.c1; 2581DROP TABLE t1,t2,t3,t4,t5,t6; 2582CREATE TABLE t1 (c1 BIGINT NOT NULL); 2583CREATE TABLE t2 (c1 BIGINT NOT NULL); 2584CREATE TABLE t3 (c1 BIGINT NOT NULL); 2585CREATE TABLE t4 (c1 BIGINT NOT NULL); 2586CREATE TABLE t5 (c1 BIGINT NOT NULL); 2587CREATE TABLE t6 (c1 BIGINT NOT NULL); 2588INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2589INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2590INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 2591INSERT INTO t4 (c1) VALUES(10); 2592INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 2593-- sorted_result 2594SELECT t1.c1,t3.c1 FROM t1 NATURAL LEFT OUTER JOIN t3 ORDER BY t1.c1,t3.c1; 2595-- sorted_result 2596SELECT t1.c1,t3.c1 FROM t1 NATURAL LEFT OUTER JOIN t3 WHERE t1.c1 <> 5 ORDER BY t1.c1,t3.c1; 2597DROP TABLE t1,t2,t3,t4,t5,t6; 2598CREATE TABLE t1 (c1 TINYINT NOT NULL); 2599CREATE TABLE t2 (c1 TINYINT NOT NULL); 2600CREATE TABLE t3 (c1 TINYINT NOT NULL); 2601CREATE TABLE t4 (c1 TINYINT NOT NULL); 2602CREATE TABLE t5 (c1 TINYINT NOT NULL); 2603CREATE TABLE t6 (c1 TINYINT NOT NULL); 2604INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2605INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2606INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 2607INSERT INTO t4 (c1) VALUES(10); 2608INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 2609-- sorted_result 2610SELECT t1.c1,t4.c1 FROM t1 NATURAL LEFT OUTER JOIN t4 ORDER BY t1.c1,t4.c1; 2611-- sorted_result 2612SELECT t1.c1,t4.c1 FROM t1 NATURAL LEFT OUTER JOIN t4 WHERE t1.c1 <> 5 ORDER BY t1.c1,t4.c1; 2613DROP TABLE t1,t2,t3,t4,t5,t6; 2614CREATE TABLE t1 (c1 SMALLINT NOT NULL); 2615CREATE TABLE t2 (c1 SMALLINT NOT NULL); 2616CREATE TABLE t3 (c1 SMALLINT NOT NULL); 2617CREATE TABLE t4 (c1 SMALLINT NOT NULL); 2618CREATE TABLE t5 (c1 SMALLINT NOT NULL); 2619CREATE TABLE t6 (c1 SMALLINT NOT NULL); 2620INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2621INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2622INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 2623INSERT INTO t4 (c1) VALUES(10); 2624INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 2625-- sorted_result 2626SELECT t1.c1,t4.c1 FROM t1 NATURAL LEFT OUTER JOIN t4 ORDER BY t1.c1,t4.c1; 2627-- sorted_result 2628SELECT t1.c1,t4.c1 FROM t1 NATURAL LEFT OUTER JOIN t4 WHERE t1.c1 <> 5 ORDER BY t1.c1,t4.c1; 2629DROP TABLE t1,t2,t3,t4,t5,t6; 2630CREATE TABLE t1 (c1 MEDIUMINT NOT NULL); 2631CREATE TABLE t2 (c1 MEDIUMINT NOT NULL); 2632CREATE TABLE t3 (c1 MEDIUMINT NOT NULL); 2633CREATE TABLE t4 (c1 MEDIUMINT NOT NULL); 2634CREATE TABLE t5 (c1 MEDIUMINT NOT NULL); 2635CREATE TABLE t6 (c1 MEDIUMINT NOT NULL); 2636INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2637INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2638INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 2639INSERT INTO t4 (c1) VALUES(10); 2640INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 2641-- sorted_result 2642SELECT t1.c1,t4.c1 FROM t1 NATURAL LEFT OUTER JOIN t4 ORDER BY t1.c1,t4.c1; 2643-- sorted_result 2644SELECT t1.c1,t4.c1 FROM t1 NATURAL LEFT OUTER JOIN t4 WHERE t1.c1 <> 5 ORDER BY t1.c1,t4.c1; 2645DROP TABLE t1,t2,t3,t4,t5,t6; 2646CREATE TABLE t1 (c1 INT NOT NULL); 2647CREATE TABLE t2 (c1 INT NOT NULL); 2648CREATE TABLE t3 (c1 INT NOT NULL); 2649CREATE TABLE t4 (c1 INT NOT NULL); 2650CREATE TABLE t5 (c1 INT NOT NULL); 2651CREATE TABLE t6 (c1 INT NOT NULL); 2652INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2653INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2654INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 2655INSERT INTO t4 (c1) VALUES(10); 2656INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 2657-- sorted_result 2658SELECT t1.c1,t4.c1 FROM t1 NATURAL LEFT OUTER JOIN t4 ORDER BY t1.c1,t4.c1; 2659-- sorted_result 2660SELECT t1.c1,t4.c1 FROM t1 NATURAL LEFT OUTER JOIN t4 WHERE t1.c1 <> 5 ORDER BY t1.c1,t4.c1; 2661DROP TABLE t1,t2,t3,t4,t5,t6; 2662CREATE TABLE t1 (c1 INTEGER NOT NULL); 2663CREATE TABLE t2 (c1 INTEGER NOT NULL); 2664CREATE TABLE t3 (c1 INTEGER NOT NULL); 2665CREATE TABLE t4 (c1 INTEGER NOT NULL); 2666CREATE TABLE t5 (c1 INTEGER NOT NULL); 2667CREATE TABLE t6 (c1 INTEGER NOT NULL); 2668INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2669INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2670INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 2671INSERT INTO t4 (c1) VALUES(10); 2672INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 2673-- sorted_result 2674SELECT t1.c1,t4.c1 FROM t1 NATURAL LEFT OUTER JOIN t4 ORDER BY t1.c1,t4.c1; 2675-- sorted_result 2676SELECT t1.c1,t4.c1 FROM t1 NATURAL LEFT OUTER JOIN t4 WHERE t1.c1 <> 5 ORDER BY t1.c1,t4.c1; 2677DROP TABLE t1,t2,t3,t4,t5,t6; 2678CREATE TABLE t1 (c1 BIGINT NOT NULL); 2679CREATE TABLE t2 (c1 BIGINT NOT NULL); 2680CREATE TABLE t3 (c1 BIGINT NOT NULL); 2681CREATE TABLE t4 (c1 BIGINT NOT NULL); 2682CREATE TABLE t5 (c1 BIGINT NOT NULL); 2683CREATE TABLE t6 (c1 BIGINT NOT NULL); 2684INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2685INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2686INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 2687INSERT INTO t4 (c1) VALUES(10); 2688INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 2689-- sorted_result 2690SELECT t1.c1,t4.c1 FROM t1 NATURAL LEFT OUTER JOIN t4 ORDER BY t1.c1,t4.c1; 2691-- sorted_result 2692SELECT t1.c1,t4.c1 FROM t1 NATURAL LEFT OUTER JOIN t4 WHERE t1.c1 <> 5 ORDER BY t1.c1,t4.c1; 2693DROP TABLE t1,t2,t3,t4,t5,t6; 2694CREATE TABLE t1 (c1 TINYINT NOT NULL); 2695CREATE TABLE t2 (c1 TINYINT NOT NULL); 2696CREATE TABLE t3 (c1 TINYINT NOT NULL); 2697CREATE TABLE t4 (c1 TINYINT NOT NULL); 2698CREATE TABLE t5 (c1 TINYINT NOT NULL); 2699CREATE TABLE t6 (c1 TINYINT NOT NULL); 2700INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2701INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2702INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 2703INSERT INTO t4 (c1) VALUES(10); 2704INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 2705-- sorted_result 2706SELECT t1.c1,t5.c1 FROM t1 NATURAL LEFT OUTER JOIN t5 ORDER BY t1.c1,t5.c1; 2707-- sorted_result 2708SELECT t1.c1,t5.c1 FROM t1 NATURAL LEFT OUTER JOIN t5 WHERE t1.c1 <> 5 ORDER BY t1.c1,t5.c1; 2709DROP TABLE t1,t2,t3,t4,t5,t6; 2710CREATE TABLE t1 (c1 SMALLINT NOT NULL); 2711CREATE TABLE t2 (c1 SMALLINT NOT NULL); 2712CREATE TABLE t3 (c1 SMALLINT NOT NULL); 2713CREATE TABLE t4 (c1 SMALLINT NOT NULL); 2714CREATE TABLE t5 (c1 SMALLINT NOT NULL); 2715CREATE TABLE t6 (c1 SMALLINT NOT NULL); 2716INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2717INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2718INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 2719INSERT INTO t4 (c1) VALUES(10); 2720INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 2721-- sorted_result 2722SELECT t1.c1,t5.c1 FROM t1 NATURAL LEFT OUTER JOIN t5 ORDER BY t1.c1,t5.c1; 2723-- sorted_result 2724SELECT t1.c1,t5.c1 FROM t1 NATURAL LEFT OUTER JOIN t5 WHERE t1.c1 <> 5 ORDER BY t1.c1,t5.c1; 2725DROP TABLE t1,t2,t3,t4,t5,t6; 2726CREATE TABLE t1 (c1 MEDIUMINT NOT NULL); 2727CREATE TABLE t2 (c1 MEDIUMINT NOT NULL); 2728CREATE TABLE t3 (c1 MEDIUMINT NOT NULL); 2729CREATE TABLE t4 (c1 MEDIUMINT NOT NULL); 2730CREATE TABLE t5 (c1 MEDIUMINT NOT NULL); 2731CREATE TABLE t6 (c1 MEDIUMINT NOT NULL); 2732INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2733INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2734INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 2735INSERT INTO t4 (c1) VALUES(10); 2736INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 2737-- sorted_result 2738SELECT t1.c1,t5.c1 FROM t1 NATURAL LEFT OUTER JOIN t5 ORDER BY t1.c1,t5.c1; 2739-- sorted_result 2740SELECT t1.c1,t5.c1 FROM t1 NATURAL LEFT OUTER JOIN t5 WHERE t1.c1 <> 5 ORDER BY t1.c1,t5.c1; 2741DROP TABLE t1,t2,t3,t4,t5,t6; 2742CREATE TABLE t1 (c1 INT NOT NULL); 2743CREATE TABLE t2 (c1 INT NOT NULL); 2744CREATE TABLE t3 (c1 INT NOT NULL); 2745CREATE TABLE t4 (c1 INT NOT NULL); 2746CREATE TABLE t5 (c1 INT NOT NULL); 2747CREATE TABLE t6 (c1 INT NOT NULL); 2748INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2749INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2750INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 2751INSERT INTO t4 (c1) VALUES(10); 2752INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 2753-- sorted_result 2754SELECT t1.c1,t5.c1 FROM t1 NATURAL LEFT OUTER JOIN t5 ORDER BY t1.c1,t5.c1; 2755-- sorted_result 2756SELECT t1.c1,t5.c1 FROM t1 NATURAL LEFT OUTER JOIN t5 WHERE t1.c1 <> 5 ORDER BY t1.c1,t5.c1; 2757DROP TABLE t1,t2,t3,t4,t5,t6; 2758CREATE TABLE t1 (c1 INTEGER NOT NULL); 2759CREATE TABLE t2 (c1 INTEGER NOT NULL); 2760CREATE TABLE t3 (c1 INTEGER NOT NULL); 2761CREATE TABLE t4 (c1 INTEGER NOT NULL); 2762CREATE TABLE t5 (c1 INTEGER NOT NULL); 2763CREATE TABLE t6 (c1 INTEGER NOT NULL); 2764INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2765INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2766INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 2767INSERT INTO t4 (c1) VALUES(10); 2768INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 2769-- sorted_result 2770SELECT t1.c1,t5.c1 FROM t1 NATURAL LEFT OUTER JOIN t5 ORDER BY t1.c1,t5.c1; 2771-- sorted_result 2772SELECT t1.c1,t5.c1 FROM t1 NATURAL LEFT OUTER JOIN t5 WHERE t1.c1 <> 5 ORDER BY t1.c1,t5.c1; 2773DROP TABLE t1,t2,t3,t4,t5,t6; 2774CREATE TABLE t1 (c1 BIGINT NOT NULL); 2775CREATE TABLE t2 (c1 BIGINT NOT NULL); 2776CREATE TABLE t3 (c1 BIGINT NOT NULL); 2777CREATE TABLE t4 (c1 BIGINT NOT NULL); 2778CREATE TABLE t5 (c1 BIGINT NOT NULL); 2779CREATE TABLE t6 (c1 BIGINT NOT NULL); 2780INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2781INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2782INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 2783INSERT INTO t4 (c1) VALUES(10); 2784INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 2785-- sorted_result 2786SELECT t1.c1,t5.c1 FROM t1 NATURAL LEFT OUTER JOIN t5 ORDER BY t1.c1,t5.c1; 2787-- sorted_result 2788SELECT t1.c1,t5.c1 FROM t1 NATURAL LEFT OUTER JOIN t5 WHERE t1.c1 <> 5 ORDER BY t1.c1,t5.c1; 2789DROP TABLE t1,t2,t3,t4,t5,t6; 2790CREATE TABLE t1 (c1 TINYINT NOT NULL); 2791CREATE TABLE t2 (c1 TINYINT NOT NULL); 2792CREATE TABLE t3 (c1 TINYINT NOT NULL); 2793CREATE TABLE t4 (c1 TINYINT NOT NULL); 2794CREATE TABLE t5 (c1 TINYINT NOT NULL); 2795CREATE TABLE t6 (c1 TINYINT NOT NULL); 2796INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2797INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2798INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 2799INSERT INTO t4 (c1) VALUES(10); 2800INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 2801-- sorted_result 2802SELECT t1.c1,t6.c1 FROM t1 NATURAL LEFT OUTER JOIN t6 ORDER BY t1.c1,t6.c1; 2803-- sorted_result 2804SELECT t1.c1,t6.c1 FROM t1 NATURAL LEFT OUTER JOIN t6 WHERE t1.c1 <> 5 ORDER BY t1.c1,t6.c1; 2805DROP TABLE t1,t2,t3,t4,t5,t6; 2806CREATE TABLE t1 (c1 SMALLINT NOT NULL); 2807CREATE TABLE t2 (c1 SMALLINT NOT NULL); 2808CREATE TABLE t3 (c1 SMALLINT NOT NULL); 2809CREATE TABLE t4 (c1 SMALLINT NOT NULL); 2810CREATE TABLE t5 (c1 SMALLINT NOT NULL); 2811CREATE TABLE t6 (c1 SMALLINT NOT NULL); 2812INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2813INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2814INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 2815INSERT INTO t4 (c1) VALUES(10); 2816INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 2817-- sorted_result 2818SELECT t1.c1,t6.c1 FROM t1 NATURAL LEFT OUTER JOIN t6 ORDER BY t1.c1,t6.c1; 2819-- sorted_result 2820SELECT t1.c1,t6.c1 FROM t1 NATURAL LEFT OUTER JOIN t6 WHERE t1.c1 <> 5 ORDER BY t1.c1,t6.c1; 2821DROP TABLE t1,t2,t3,t4,t5,t6; 2822CREATE TABLE t1 (c1 MEDIUMINT NOT NULL); 2823CREATE TABLE t2 (c1 MEDIUMINT NOT NULL); 2824CREATE TABLE t3 (c1 MEDIUMINT NOT NULL); 2825CREATE TABLE t4 (c1 MEDIUMINT NOT NULL); 2826CREATE TABLE t5 (c1 MEDIUMINT NOT NULL); 2827CREATE TABLE t6 (c1 MEDIUMINT NOT NULL); 2828INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2829INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2830INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 2831INSERT INTO t4 (c1) VALUES(10); 2832INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 2833-- sorted_result 2834SELECT t1.c1,t6.c1 FROM t1 NATURAL LEFT OUTER JOIN t6 ORDER BY t1.c1,t6.c1; 2835-- sorted_result 2836SELECT t1.c1,t6.c1 FROM t1 NATURAL LEFT OUTER JOIN t6 WHERE t1.c1 <> 5 ORDER BY t1.c1,t6.c1; 2837DROP TABLE t1,t2,t3,t4,t5,t6; 2838CREATE TABLE t1 (c1 INT NOT NULL); 2839CREATE TABLE t2 (c1 INT NOT NULL); 2840CREATE TABLE t3 (c1 INT NOT NULL); 2841CREATE TABLE t4 (c1 INT NOT NULL); 2842CREATE TABLE t5 (c1 INT NOT NULL); 2843CREATE TABLE t6 (c1 INT NOT NULL); 2844INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2845INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2846INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 2847INSERT INTO t4 (c1) VALUES(10); 2848INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 2849-- sorted_result 2850SELECT t1.c1,t6.c1 FROM t1 NATURAL LEFT OUTER JOIN t6 ORDER BY t1.c1,t6.c1; 2851-- sorted_result 2852SELECT t1.c1,t6.c1 FROM t1 NATURAL LEFT OUTER JOIN t6 WHERE t1.c1 <> 5 ORDER BY t1.c1,t6.c1; 2853DROP TABLE t1,t2,t3,t4,t5,t6; 2854CREATE TABLE t1 (c1 INTEGER NOT NULL); 2855CREATE TABLE t2 (c1 INTEGER NOT NULL); 2856CREATE TABLE t3 (c1 INTEGER NOT NULL); 2857CREATE TABLE t4 (c1 INTEGER NOT NULL); 2858CREATE TABLE t5 (c1 INTEGER NOT NULL); 2859CREATE TABLE t6 (c1 INTEGER NOT NULL); 2860INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2861INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2862INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 2863INSERT INTO t4 (c1) VALUES(10); 2864INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 2865-- sorted_result 2866SELECT t1.c1,t6.c1 FROM t1 NATURAL LEFT OUTER JOIN t6 ORDER BY t1.c1,t6.c1; 2867-- sorted_result 2868SELECT t1.c1,t6.c1 FROM t1 NATURAL LEFT OUTER JOIN t6 WHERE t1.c1 <> 5 ORDER BY t1.c1,t6.c1; 2869DROP TABLE t1,t2,t3,t4,t5,t6; 2870CREATE TABLE t1 (c1 BIGINT NOT NULL); 2871CREATE TABLE t2 (c1 BIGINT NOT NULL); 2872CREATE TABLE t3 (c1 BIGINT NOT NULL); 2873CREATE TABLE t4 (c1 BIGINT NOT NULL); 2874CREATE TABLE t5 (c1 BIGINT NOT NULL); 2875CREATE TABLE t6 (c1 BIGINT NOT NULL); 2876INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2877INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2878INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 2879INSERT INTO t4 (c1) VALUES(10); 2880INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 2881-- sorted_result 2882SELECT t1.c1,t6.c1 FROM t1 NATURAL LEFT OUTER JOIN t6 ORDER BY t1.c1,t6.c1; 2883-- sorted_result 2884SELECT t1.c1,t6.c1 FROM t1 NATURAL LEFT OUTER JOIN t6 WHERE t1.c1 <> 5 ORDER BY t1.c1,t6.c1; 2885DROP TABLE t1,t2,t3,t4,t5,t6; 2886CREATE TABLE t1 (c1 TINYINT NOT NULL); 2887CREATE TABLE t2 (c1 TINYINT NOT NULL); 2888CREATE TABLE t3 (c1 TINYINT NOT NULL); 2889CREATE TABLE t4 (c1 TINYINT NOT NULL); 2890CREATE TABLE t5 (c1 TINYINT NOT NULL); 2891CREATE TABLE t6 (c1 TINYINT NOT NULL); 2892INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2893INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2894INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 2895INSERT INTO t4 (c1) VALUES(10); 2896INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 2897-- sorted_result 2898SELECT t1.c1,t2.c1 FROM t1 NATURAL LEFT OUTER JOIN t2 ORDER BY t1.c1,t2.c1; 2899-- sorted_result 2900SELECT t1.c1,t2.c1 FROM t1 NATURAL LEFT OUTER JOIN t2 WHERE t1.c1 <=> 5 ORDER BY t1.c1,t2.c1; 2901DROP TABLE t1,t2,t3,t4,t5,t6; 2902CREATE TABLE t1 (c1 SMALLINT NOT NULL); 2903CREATE TABLE t2 (c1 SMALLINT NOT NULL); 2904CREATE TABLE t3 (c1 SMALLINT NOT NULL); 2905CREATE TABLE t4 (c1 SMALLINT NOT NULL); 2906CREATE TABLE t5 (c1 SMALLINT NOT NULL); 2907CREATE TABLE t6 (c1 SMALLINT NOT NULL); 2908INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2909INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2910INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 2911INSERT INTO t4 (c1) VALUES(10); 2912INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 2913-- sorted_result 2914SELECT t1.c1,t2.c1 FROM t1 NATURAL LEFT OUTER JOIN t2 ORDER BY t1.c1,t2.c1; 2915-- sorted_result 2916SELECT t1.c1,t2.c1 FROM t1 NATURAL LEFT OUTER JOIN t2 WHERE t1.c1 <=> 5 ORDER BY t1.c1,t2.c1; 2917DROP TABLE t1,t2,t3,t4,t5,t6; 2918CREATE TABLE t1 (c1 MEDIUMINT NOT NULL); 2919CREATE TABLE t2 (c1 MEDIUMINT NOT NULL); 2920CREATE TABLE t3 (c1 MEDIUMINT NOT NULL); 2921CREATE TABLE t4 (c1 MEDIUMINT NOT NULL); 2922CREATE TABLE t5 (c1 MEDIUMINT NOT NULL); 2923CREATE TABLE t6 (c1 MEDIUMINT NOT NULL); 2924INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2925INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2926INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 2927INSERT INTO t4 (c1) VALUES(10); 2928INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 2929-- sorted_result 2930SELECT t1.c1,t2.c1 FROM t1 NATURAL LEFT OUTER JOIN t2 ORDER BY t1.c1,t2.c1; 2931-- sorted_result 2932SELECT t1.c1,t2.c1 FROM t1 NATURAL LEFT OUTER JOIN t2 WHERE t1.c1 <=> 5 ORDER BY t1.c1,t2.c1; 2933DROP TABLE t1,t2,t3,t4,t5,t6; 2934CREATE TABLE t1 (c1 INT NOT NULL); 2935CREATE TABLE t2 (c1 INT NOT NULL); 2936CREATE TABLE t3 (c1 INT NOT NULL); 2937CREATE TABLE t4 (c1 INT NOT NULL); 2938CREATE TABLE t5 (c1 INT NOT NULL); 2939CREATE TABLE t6 (c1 INT NOT NULL); 2940INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2941INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2942INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 2943INSERT INTO t4 (c1) VALUES(10); 2944INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 2945-- sorted_result 2946SELECT t1.c1,t2.c1 FROM t1 NATURAL LEFT OUTER JOIN t2 ORDER BY t1.c1,t2.c1; 2947-- sorted_result 2948SELECT t1.c1,t2.c1 FROM t1 NATURAL LEFT OUTER JOIN t2 WHERE t1.c1 <=> 5 ORDER BY t1.c1,t2.c1; 2949DROP TABLE t1,t2,t3,t4,t5,t6; 2950CREATE TABLE t1 (c1 INTEGER NOT NULL); 2951CREATE TABLE t2 (c1 INTEGER NOT NULL); 2952CREATE TABLE t3 (c1 INTEGER NOT NULL); 2953CREATE TABLE t4 (c1 INTEGER NOT NULL); 2954CREATE TABLE t5 (c1 INTEGER NOT NULL); 2955CREATE TABLE t6 (c1 INTEGER NOT NULL); 2956INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2957INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2958INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 2959INSERT INTO t4 (c1) VALUES(10); 2960INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 2961-- sorted_result 2962SELECT t1.c1,t2.c1 FROM t1 NATURAL LEFT OUTER JOIN t2 ORDER BY t1.c1,t2.c1; 2963-- sorted_result 2964SELECT t1.c1,t2.c1 FROM t1 NATURAL LEFT OUTER JOIN t2 WHERE t1.c1 <=> 5 ORDER BY t1.c1,t2.c1; 2965DROP TABLE t1,t2,t3,t4,t5,t6; 2966CREATE TABLE t1 (c1 BIGINT NOT NULL); 2967CREATE TABLE t2 (c1 BIGINT NOT NULL); 2968CREATE TABLE t3 (c1 BIGINT NOT NULL); 2969CREATE TABLE t4 (c1 BIGINT NOT NULL); 2970CREATE TABLE t5 (c1 BIGINT NOT NULL); 2971CREATE TABLE t6 (c1 BIGINT NOT NULL); 2972INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2973INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2974INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 2975INSERT INTO t4 (c1) VALUES(10); 2976INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 2977-- sorted_result 2978SELECT t1.c1,t2.c1 FROM t1 NATURAL LEFT OUTER JOIN t2 ORDER BY t1.c1,t2.c1; 2979-- sorted_result 2980SELECT t1.c1,t2.c1 FROM t1 NATURAL LEFT OUTER JOIN t2 WHERE t1.c1 <=> 5 ORDER BY t1.c1,t2.c1; 2981DROP TABLE t1,t2,t3,t4,t5,t6; 2982CREATE TABLE t1 (c1 TINYINT NOT NULL); 2983CREATE TABLE t2 (c1 TINYINT NOT NULL); 2984CREATE TABLE t3 (c1 TINYINT NOT NULL); 2985CREATE TABLE t4 (c1 TINYINT NOT NULL); 2986CREATE TABLE t5 (c1 TINYINT NOT NULL); 2987CREATE TABLE t6 (c1 TINYINT NOT NULL); 2988INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2989INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2990INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 2991INSERT INTO t4 (c1) VALUES(10); 2992INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 2993-- sorted_result 2994SELECT t1.c1,t3.c1 FROM t1 NATURAL LEFT OUTER JOIN t3 ORDER BY t1.c1,t3.c1; 2995-- sorted_result 2996SELECT t1.c1,t3.c1 FROM t1 NATURAL LEFT OUTER JOIN t3 WHERE t1.c1 <=> 5 ORDER BY t1.c1,t3.c1; 2997DROP TABLE t1,t2,t3,t4,t5,t6; 2998CREATE TABLE t1 (c1 SMALLINT NOT NULL); 2999CREATE TABLE t2 (c1 SMALLINT NOT NULL); 3000CREATE TABLE t3 (c1 SMALLINT NOT NULL); 3001CREATE TABLE t4 (c1 SMALLINT NOT NULL); 3002CREATE TABLE t5 (c1 SMALLINT NOT NULL); 3003CREATE TABLE t6 (c1 SMALLINT NOT NULL); 3004INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3005INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3006INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 3007INSERT INTO t4 (c1) VALUES(10); 3008INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 3009-- sorted_result 3010SELECT t1.c1,t3.c1 FROM t1 NATURAL LEFT OUTER JOIN t3 ORDER BY t1.c1,t3.c1; 3011-- sorted_result 3012SELECT t1.c1,t3.c1 FROM t1 NATURAL LEFT OUTER JOIN t3 WHERE t1.c1 <=> 5 ORDER BY t1.c1,t3.c1; 3013DROP TABLE t1,t2,t3,t4,t5,t6; 3014CREATE TABLE t1 (c1 MEDIUMINT NOT NULL); 3015CREATE TABLE t2 (c1 MEDIUMINT NOT NULL); 3016CREATE TABLE t3 (c1 MEDIUMINT NOT NULL); 3017CREATE TABLE t4 (c1 MEDIUMINT NOT NULL); 3018CREATE TABLE t5 (c1 MEDIUMINT NOT NULL); 3019CREATE TABLE t6 (c1 MEDIUMINT NOT NULL); 3020INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3021INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3022INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 3023INSERT INTO t4 (c1) VALUES(10); 3024INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 3025-- sorted_result 3026SELECT t1.c1,t3.c1 FROM t1 NATURAL LEFT OUTER JOIN t3 ORDER BY t1.c1,t3.c1; 3027-- sorted_result 3028SELECT t1.c1,t3.c1 FROM t1 NATURAL LEFT OUTER JOIN t3 WHERE t1.c1 <=> 5 ORDER BY t1.c1,t3.c1; 3029DROP TABLE t1,t2,t3,t4,t5,t6; 3030CREATE TABLE t1 (c1 INT NOT NULL); 3031CREATE TABLE t2 (c1 INT NOT NULL); 3032CREATE TABLE t3 (c1 INT NOT NULL); 3033CREATE TABLE t4 (c1 INT NOT NULL); 3034CREATE TABLE t5 (c1 INT NOT NULL); 3035CREATE TABLE t6 (c1 INT NOT NULL); 3036INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3037INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3038INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 3039INSERT INTO t4 (c1) VALUES(10); 3040INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 3041-- sorted_result 3042SELECT t1.c1,t3.c1 FROM t1 NATURAL LEFT OUTER JOIN t3 ORDER BY t1.c1,t3.c1; 3043-- sorted_result 3044SELECT t1.c1,t3.c1 FROM t1 NATURAL LEFT OUTER JOIN t3 WHERE t1.c1 <=> 5 ORDER BY t1.c1,t3.c1; 3045DROP TABLE t1,t2,t3,t4,t5,t6; 3046CREATE TABLE t1 (c1 INTEGER NOT NULL); 3047CREATE TABLE t2 (c1 INTEGER NOT NULL); 3048CREATE TABLE t3 (c1 INTEGER NOT NULL); 3049CREATE TABLE t4 (c1 INTEGER NOT NULL); 3050CREATE TABLE t5 (c1 INTEGER NOT NULL); 3051CREATE TABLE t6 (c1 INTEGER NOT NULL); 3052INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3053INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3054INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 3055INSERT INTO t4 (c1) VALUES(10); 3056INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 3057-- sorted_result 3058SELECT t1.c1,t3.c1 FROM t1 NATURAL LEFT OUTER JOIN t3 ORDER BY t1.c1,t3.c1; 3059-- sorted_result 3060SELECT t1.c1,t3.c1 FROM t1 NATURAL LEFT OUTER JOIN t3 WHERE t1.c1 <=> 5 ORDER BY t1.c1,t3.c1; 3061DROP TABLE t1,t2,t3,t4,t5,t6; 3062CREATE TABLE t1 (c1 BIGINT NOT NULL); 3063CREATE TABLE t2 (c1 BIGINT NOT NULL); 3064CREATE TABLE t3 (c1 BIGINT NOT NULL); 3065CREATE TABLE t4 (c1 BIGINT NOT NULL); 3066CREATE TABLE t5 (c1 BIGINT NOT NULL); 3067CREATE TABLE t6 (c1 BIGINT NOT NULL); 3068INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3069INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3070INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 3071INSERT INTO t4 (c1) VALUES(10); 3072INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 3073-- sorted_result 3074SELECT t1.c1,t3.c1 FROM t1 NATURAL LEFT OUTER JOIN t3 ORDER BY t1.c1,t3.c1; 3075-- sorted_result 3076SELECT t1.c1,t3.c1 FROM t1 NATURAL LEFT OUTER JOIN t3 WHERE t1.c1 <=> 5 ORDER BY t1.c1,t3.c1; 3077DROP TABLE t1,t2,t3,t4,t5,t6; 3078CREATE TABLE t1 (c1 TINYINT NOT NULL); 3079CREATE TABLE t2 (c1 TINYINT NOT NULL); 3080CREATE TABLE t3 (c1 TINYINT NOT NULL); 3081CREATE TABLE t4 (c1 TINYINT NOT NULL); 3082CREATE TABLE t5 (c1 TINYINT NOT NULL); 3083CREATE TABLE t6 (c1 TINYINT NOT NULL); 3084INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3085INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3086INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 3087INSERT INTO t4 (c1) VALUES(10); 3088INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 3089-- sorted_result 3090SELECT t1.c1,t4.c1 FROM t1 NATURAL LEFT OUTER JOIN t4 ORDER BY t1.c1,t4.c1; 3091-- sorted_result 3092SELECT t1.c1,t4.c1 FROM t1 NATURAL LEFT OUTER JOIN t4 WHERE t1.c1 <=> 5 ORDER BY t1.c1,t4.c1; 3093DROP TABLE t1,t2,t3,t4,t5,t6; 3094CREATE TABLE t1 (c1 SMALLINT NOT NULL); 3095CREATE TABLE t2 (c1 SMALLINT NOT NULL); 3096CREATE TABLE t3 (c1 SMALLINT NOT NULL); 3097CREATE TABLE t4 (c1 SMALLINT NOT NULL); 3098CREATE TABLE t5 (c1 SMALLINT NOT NULL); 3099CREATE TABLE t6 (c1 SMALLINT NOT NULL); 3100INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3101INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3102INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 3103INSERT INTO t4 (c1) VALUES(10); 3104INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 3105-- sorted_result 3106SELECT t1.c1,t4.c1 FROM t1 NATURAL LEFT OUTER JOIN t4 ORDER BY t1.c1,t4.c1; 3107-- sorted_result 3108SELECT t1.c1,t4.c1 FROM t1 NATURAL LEFT OUTER JOIN t4 WHERE t1.c1 <=> 5 ORDER BY t1.c1,t4.c1; 3109DROP TABLE t1,t2,t3,t4,t5,t6; 3110CREATE TABLE t1 (c1 MEDIUMINT NOT NULL); 3111CREATE TABLE t2 (c1 MEDIUMINT NOT NULL); 3112CREATE TABLE t3 (c1 MEDIUMINT NOT NULL); 3113CREATE TABLE t4 (c1 MEDIUMINT NOT NULL); 3114CREATE TABLE t5 (c1 MEDIUMINT NOT NULL); 3115CREATE TABLE t6 (c1 MEDIUMINT NOT NULL); 3116INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3117INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3118INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 3119INSERT INTO t4 (c1) VALUES(10); 3120INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 3121-- sorted_result 3122SELECT t1.c1,t4.c1 FROM t1 NATURAL LEFT OUTER JOIN t4 ORDER BY t1.c1,t4.c1; 3123-- sorted_result 3124SELECT t1.c1,t4.c1 FROM t1 NATURAL LEFT OUTER JOIN t4 WHERE t1.c1 <=> 5 ORDER BY t1.c1,t4.c1; 3125DROP TABLE t1,t2,t3,t4,t5,t6; 3126CREATE TABLE t1 (c1 INT NOT NULL); 3127CREATE TABLE t2 (c1 INT NOT NULL); 3128CREATE TABLE t3 (c1 INT NOT NULL); 3129CREATE TABLE t4 (c1 INT NOT NULL); 3130CREATE TABLE t5 (c1 INT NOT NULL); 3131CREATE TABLE t6 (c1 INT NOT NULL); 3132INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3133INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3134INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 3135INSERT INTO t4 (c1) VALUES(10); 3136INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 3137-- sorted_result 3138SELECT t1.c1,t4.c1 FROM t1 NATURAL LEFT OUTER JOIN t4 ORDER BY t1.c1,t4.c1; 3139-- sorted_result 3140SELECT t1.c1,t4.c1 FROM t1 NATURAL LEFT OUTER JOIN t4 WHERE t1.c1 <=> 5 ORDER BY t1.c1,t4.c1; 3141DROP TABLE t1,t2,t3,t4,t5,t6; 3142CREATE TABLE t1 (c1 INTEGER NOT NULL); 3143CREATE TABLE t2 (c1 INTEGER NOT NULL); 3144CREATE TABLE t3 (c1 INTEGER NOT NULL); 3145CREATE TABLE t4 (c1 INTEGER NOT NULL); 3146CREATE TABLE t5 (c1 INTEGER NOT NULL); 3147CREATE TABLE t6 (c1 INTEGER NOT NULL); 3148INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3149INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3150INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 3151INSERT INTO t4 (c1) VALUES(10); 3152INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 3153-- sorted_result 3154SELECT t1.c1,t4.c1 FROM t1 NATURAL LEFT OUTER JOIN t4 ORDER BY t1.c1,t4.c1; 3155-- sorted_result 3156SELECT t1.c1,t4.c1 FROM t1 NATURAL LEFT OUTER JOIN t4 WHERE t1.c1 <=> 5 ORDER BY t1.c1,t4.c1; 3157DROP TABLE t1,t2,t3,t4,t5,t6; 3158CREATE TABLE t1 (c1 BIGINT NOT NULL); 3159CREATE TABLE t2 (c1 BIGINT NOT NULL); 3160CREATE TABLE t3 (c1 BIGINT NOT NULL); 3161CREATE TABLE t4 (c1 BIGINT NOT NULL); 3162CREATE TABLE t5 (c1 BIGINT NOT NULL); 3163CREATE TABLE t6 (c1 BIGINT NOT NULL); 3164INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3165INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3166INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 3167INSERT INTO t4 (c1) VALUES(10); 3168INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 3169-- sorted_result 3170SELECT t1.c1,t4.c1 FROM t1 NATURAL LEFT OUTER JOIN t4 ORDER BY t1.c1,t4.c1; 3171-- sorted_result 3172SELECT t1.c1,t4.c1 FROM t1 NATURAL LEFT OUTER JOIN t4 WHERE t1.c1 <=> 5 ORDER BY t1.c1,t4.c1; 3173DROP TABLE t1,t2,t3,t4,t5,t6; 3174CREATE TABLE t1 (c1 TINYINT NOT NULL); 3175CREATE TABLE t2 (c1 TINYINT NOT NULL); 3176CREATE TABLE t3 (c1 TINYINT NOT NULL); 3177CREATE TABLE t4 (c1 TINYINT NOT NULL); 3178CREATE TABLE t5 (c1 TINYINT NOT NULL); 3179CREATE TABLE t6 (c1 TINYINT NOT NULL); 3180INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3181INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3182INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 3183INSERT INTO t4 (c1) VALUES(10); 3184INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 3185-- sorted_result 3186SELECT t1.c1,t5.c1 FROM t1 NATURAL LEFT OUTER JOIN t5 ORDER BY t1.c1,t5.c1; 3187-- sorted_result 3188SELECT t1.c1,t5.c1 FROM t1 NATURAL LEFT OUTER JOIN t5 WHERE t1.c1 <=> 5 ORDER BY t1.c1,t5.c1; 3189DROP TABLE t1,t2,t3,t4,t5,t6; 3190CREATE TABLE t1 (c1 SMALLINT NOT NULL); 3191CREATE TABLE t2 (c1 SMALLINT NOT NULL); 3192CREATE TABLE t3 (c1 SMALLINT NOT NULL); 3193CREATE TABLE t4 (c1 SMALLINT NOT NULL); 3194CREATE TABLE t5 (c1 SMALLINT NOT NULL); 3195CREATE TABLE t6 (c1 SMALLINT NOT NULL); 3196INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3197INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3198INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 3199INSERT INTO t4 (c1) VALUES(10); 3200INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 3201-- sorted_result 3202SELECT t1.c1,t5.c1 FROM t1 NATURAL LEFT OUTER JOIN t5 ORDER BY t1.c1,t5.c1; 3203-- sorted_result 3204SELECT t1.c1,t5.c1 FROM t1 NATURAL LEFT OUTER JOIN t5 WHERE t1.c1 <=> 5 ORDER BY t1.c1,t5.c1; 3205DROP TABLE t1,t2,t3,t4,t5,t6; 3206CREATE TABLE t1 (c1 MEDIUMINT NOT NULL); 3207CREATE TABLE t2 (c1 MEDIUMINT NOT NULL); 3208CREATE TABLE t3 (c1 MEDIUMINT NOT NULL); 3209CREATE TABLE t4 (c1 MEDIUMINT NOT NULL); 3210CREATE TABLE t5 (c1 MEDIUMINT NOT NULL); 3211CREATE TABLE t6 (c1 MEDIUMINT NOT NULL); 3212INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3213INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3214INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 3215INSERT INTO t4 (c1) VALUES(10); 3216INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 3217-- sorted_result 3218SELECT t1.c1,t5.c1 FROM t1 NATURAL LEFT OUTER JOIN t5 ORDER BY t1.c1,t5.c1; 3219-- sorted_result 3220SELECT t1.c1,t5.c1 FROM t1 NATURAL LEFT OUTER JOIN t5 WHERE t1.c1 <=> 5 ORDER BY t1.c1,t5.c1; 3221DROP TABLE t1,t2,t3,t4,t5,t6; 3222CREATE TABLE t1 (c1 INT NOT NULL); 3223CREATE TABLE t2 (c1 INT NOT NULL); 3224CREATE TABLE t3 (c1 INT NOT NULL); 3225CREATE TABLE t4 (c1 INT NOT NULL); 3226CREATE TABLE t5 (c1 INT NOT NULL); 3227CREATE TABLE t6 (c1 INT NOT NULL); 3228INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3229INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3230INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 3231INSERT INTO t4 (c1) VALUES(10); 3232INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 3233-- sorted_result 3234SELECT t1.c1,t5.c1 FROM t1 NATURAL LEFT OUTER JOIN t5 ORDER BY t1.c1,t5.c1; 3235-- sorted_result 3236SELECT t1.c1,t5.c1 FROM t1 NATURAL LEFT OUTER JOIN t5 WHERE t1.c1 <=> 5 ORDER BY t1.c1,t5.c1; 3237DROP TABLE t1,t2,t3,t4,t5,t6; 3238CREATE TABLE t1 (c1 INTEGER NOT NULL); 3239CREATE TABLE t2 (c1 INTEGER NOT NULL); 3240CREATE TABLE t3 (c1 INTEGER NOT NULL); 3241CREATE TABLE t4 (c1 INTEGER NOT NULL); 3242CREATE TABLE t5 (c1 INTEGER NOT NULL); 3243CREATE TABLE t6 (c1 INTEGER NOT NULL); 3244INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3245INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3246INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 3247INSERT INTO t4 (c1) VALUES(10); 3248INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 3249-- sorted_result 3250SELECT t1.c1,t5.c1 FROM t1 NATURAL LEFT OUTER JOIN t5 ORDER BY t1.c1,t5.c1; 3251-- sorted_result 3252SELECT t1.c1,t5.c1 FROM t1 NATURAL LEFT OUTER JOIN t5 WHERE t1.c1 <=> 5 ORDER BY t1.c1,t5.c1; 3253DROP TABLE t1,t2,t3,t4,t5,t6; 3254CREATE TABLE t1 (c1 BIGINT NOT NULL); 3255CREATE TABLE t2 (c1 BIGINT NOT NULL); 3256CREATE TABLE t3 (c1 BIGINT NOT NULL); 3257CREATE TABLE t4 (c1 BIGINT NOT NULL); 3258CREATE TABLE t5 (c1 BIGINT NOT NULL); 3259CREATE TABLE t6 (c1 BIGINT NOT NULL); 3260INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3261INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3262INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 3263INSERT INTO t4 (c1) VALUES(10); 3264INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 3265-- sorted_result 3266SELECT t1.c1,t5.c1 FROM t1 NATURAL LEFT OUTER JOIN t5 ORDER BY t1.c1,t5.c1; 3267-- sorted_result 3268SELECT t1.c1,t5.c1 FROM t1 NATURAL LEFT OUTER JOIN t5 WHERE t1.c1 <=> 5 ORDER BY t1.c1,t5.c1; 3269DROP TABLE t1,t2,t3,t4,t5,t6; 3270CREATE TABLE t1 (c1 TINYINT NOT NULL); 3271CREATE TABLE t2 (c1 TINYINT NOT NULL); 3272CREATE TABLE t3 (c1 TINYINT NOT NULL); 3273CREATE TABLE t4 (c1 TINYINT NOT NULL); 3274CREATE TABLE t5 (c1 TINYINT NOT NULL); 3275CREATE TABLE t6 (c1 TINYINT NOT NULL); 3276INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3277INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3278INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 3279INSERT INTO t4 (c1) VALUES(10); 3280INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 3281-- sorted_result 3282SELECT t1.c1,t6.c1 FROM t1 NATURAL LEFT OUTER JOIN t6 ORDER BY t1.c1,t6.c1; 3283-- sorted_result 3284SELECT t1.c1,t6.c1 FROM t1 NATURAL LEFT OUTER JOIN t6 WHERE t1.c1 <=> 5 ORDER BY t1.c1,t6.c1; 3285DROP TABLE t1,t2,t3,t4,t5,t6; 3286CREATE TABLE t1 (c1 SMALLINT NOT NULL); 3287CREATE TABLE t2 (c1 SMALLINT NOT NULL); 3288CREATE TABLE t3 (c1 SMALLINT NOT NULL); 3289CREATE TABLE t4 (c1 SMALLINT NOT NULL); 3290CREATE TABLE t5 (c1 SMALLINT NOT NULL); 3291CREATE TABLE t6 (c1 SMALLINT NOT NULL); 3292INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3293INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3294INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 3295INSERT INTO t4 (c1) VALUES(10); 3296INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 3297-- sorted_result 3298SELECT t1.c1,t6.c1 FROM t1 NATURAL LEFT OUTER JOIN t6 ORDER BY t1.c1,t6.c1; 3299-- sorted_result 3300SELECT t1.c1,t6.c1 FROM t1 NATURAL LEFT OUTER JOIN t6 WHERE t1.c1 <=> 5 ORDER BY t1.c1,t6.c1; 3301DROP TABLE t1,t2,t3,t4,t5,t6; 3302CREATE TABLE t1 (c1 MEDIUMINT NOT NULL); 3303CREATE TABLE t2 (c1 MEDIUMINT NOT NULL); 3304CREATE TABLE t3 (c1 MEDIUMINT NOT NULL); 3305CREATE TABLE t4 (c1 MEDIUMINT NOT NULL); 3306CREATE TABLE t5 (c1 MEDIUMINT NOT NULL); 3307CREATE TABLE t6 (c1 MEDIUMINT NOT NULL); 3308INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3309INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3310INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 3311INSERT INTO t4 (c1) VALUES(10); 3312INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 3313-- sorted_result 3314SELECT t1.c1,t6.c1 FROM t1 NATURAL LEFT OUTER JOIN t6 ORDER BY t1.c1,t6.c1; 3315-- sorted_result 3316SELECT t1.c1,t6.c1 FROM t1 NATURAL LEFT OUTER JOIN t6 WHERE t1.c1 <=> 5 ORDER BY t1.c1,t6.c1; 3317DROP TABLE t1,t2,t3,t4,t5,t6; 3318CREATE TABLE t1 (c1 INT NOT NULL); 3319CREATE TABLE t2 (c1 INT NOT NULL); 3320CREATE TABLE t3 (c1 INT NOT NULL); 3321CREATE TABLE t4 (c1 INT NOT NULL); 3322CREATE TABLE t5 (c1 INT NOT NULL); 3323CREATE TABLE t6 (c1 INT NOT NULL); 3324INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3325INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3326INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 3327INSERT INTO t4 (c1) VALUES(10); 3328INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 3329-- sorted_result 3330SELECT t1.c1,t6.c1 FROM t1 NATURAL LEFT OUTER JOIN t6 ORDER BY t1.c1,t6.c1; 3331-- sorted_result 3332SELECT t1.c1,t6.c1 FROM t1 NATURAL LEFT OUTER JOIN t6 WHERE t1.c1 <=> 5 ORDER BY t1.c1,t6.c1; 3333DROP TABLE t1,t2,t3,t4,t5,t6; 3334CREATE TABLE t1 (c1 INTEGER NOT NULL); 3335CREATE TABLE t2 (c1 INTEGER NOT NULL); 3336CREATE TABLE t3 (c1 INTEGER NOT NULL); 3337CREATE TABLE t4 (c1 INTEGER NOT NULL); 3338CREATE TABLE t5 (c1 INTEGER NOT NULL); 3339CREATE TABLE t6 (c1 INTEGER NOT NULL); 3340INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3341INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3342INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 3343INSERT INTO t4 (c1) VALUES(10); 3344INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 3345-- sorted_result 3346SELECT t1.c1,t6.c1 FROM t1 NATURAL LEFT OUTER JOIN t6 ORDER BY t1.c1,t6.c1; 3347-- sorted_result 3348SELECT t1.c1,t6.c1 FROM t1 NATURAL LEFT OUTER JOIN t6 WHERE t1.c1 <=> 5 ORDER BY t1.c1,t6.c1; 3349DROP TABLE t1,t2,t3,t4,t5,t6; 3350CREATE TABLE t1 (c1 BIGINT NOT NULL); 3351CREATE TABLE t2 (c1 BIGINT NOT NULL); 3352CREATE TABLE t3 (c1 BIGINT NOT NULL); 3353CREATE TABLE t4 (c1 BIGINT NOT NULL); 3354CREATE TABLE t5 (c1 BIGINT NOT NULL); 3355CREATE TABLE t6 (c1 BIGINT NOT NULL); 3356INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3357INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 3358INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9); 3359INSERT INTO t4 (c1) VALUES(10); 3360INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14); 3361-- sorted_result 3362SELECT t1.c1,t6.c1 FROM t1 NATURAL LEFT OUTER JOIN t6 ORDER BY t1.c1,t6.c1; 3363-- sorted_result 3364SELECT t1.c1,t6.c1 FROM t1 NATURAL LEFT OUTER JOIN t6 WHERE t1.c1 <=> 5 ORDER BY t1.c1,t6.c1; 3365DROP TABLE t1,t2,t3,t4,t5,t6; 3366 3367