1# 2022-04-19 2# 3# The author disclaims copyright to this source code. In place of 4# a legal notice, here is a blessing: 5# 6# May you do good and not evil. 7# May you find forgiveness for yourself and forgive others. 8# May you share freely, never taking more than you give. 9# 10#*********************************************************************** 11# 12# This file implements tests for JOINs. 13# 14# The test case output is all generated by PostgreSQL 14. This test module 15# was created as follows: 16# 17# 1. Run a TCL script (included at the bottom of this file) that 18# generates an input script for "psql" that will run man 19# diverse tests on joins. 20# 21# 2. Run the script from step (1) through psql and collect the 22# output. 23# 24# 3. Make a few minor global search-and-replace operations to convert 25# the psql output into a form suitable for this test module. 26# 27# 4. Add this header, and the script content at the footer. 28# 29set testdir [file dirname $argv0] 30source $testdir/tester.tcl 31db nullvalue - 32db eval { 33 DROP TABLE IF EXISTS t1; 34 DROP TABLE IF EXISTS t2; 35 DROP TABLE IF EXISTS t3; 36 DROP TABLE IF EXISTS t4; 37 DROP TABLE IF EXISTS t5; 38 CREATE TABLE t1(a INT, b INT, c INT); 39 CREATE TABLE t2(a INT, b INT, d INT); 40 CREATE TABLE t3(a INT, b INT, e INT); 41 CREATE TABLE t4(a INT, b INT, f INT); 42 CREATE TABLE t5(a INT, b INT, g INT); 43 INSERT INTO t1 VALUES(11,21,31),(12,22,32),(15,25,35),(17,27,37); 44 INSERT INTO t2 VALUES(12,22,32),(13,23,33),(15,25,35),(18,28,38), 45 (NULL,NULL,36); 46 INSERT INTO t4 VALUES(11,21,31),(13,23,33),(15,25,35),(19,29,39); 47 INSERT INTO t3 SELECT * FROM t1 UNION SELECT * FROM t2 UNION SELECT * FROM t4; 48 INSERT INTO t5 SELECT * FROM t3 WHERE a>=15; 49} 50do_execsql_test joinC-1 { 51 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 52 FROM t1 INNER JOIN ( 53 t2 INNER JOIN ( 54 t3 INNER JOIN ( 55 t4 INNER JOIN t5 USING(a) 56 ) USING(a) 57 ) USING(a) 58 ) USING(a) 59 ORDER BY 1 NULLS FIRST; 60} { 61 15 15 15 15 15 15 62 63} 64do_execsql_test joinC-2 { 65 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 66 FROM t1 INNER JOIN ( 67 t2 INNER JOIN ( 68 t3 INNER JOIN ( 69 t4 LEFT JOIN t5 USING(a) 70 ) USING(a) 71 ) USING(a) 72 ) USING(a) 73 ORDER BY 1 NULLS FIRST; 74} { 75 15 15 15 15 15 15 76 77} 78do_execsql_test joinC-3 { 79 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 80 FROM t1 INNER JOIN ( 81 t2 INNER JOIN ( 82 t3 INNER JOIN ( 83 t4 RIGHT JOIN t5 USING(a) 84 ) USING(a) 85 ) USING(a) 86 ) USING(a) 87 ORDER BY 1 NULLS FIRST; 88} { 89 15 15 15 15 15 15 90 91} 92do_execsql_test joinC-4 { 93 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 94 FROM t1 INNER JOIN ( 95 t2 INNER JOIN ( 96 t3 INNER JOIN ( 97 t4 FULL JOIN t5 USING(a) 98 ) USING(a) 99 ) USING(a) 100 ) USING(a) 101 ORDER BY 1 NULLS FIRST; 102} { 103 15 15 15 15 15 15 104 105} 106do_execsql_test joinC-5 { 107 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 108 FROM t1 INNER JOIN ( 109 t2 INNER JOIN ( 110 t3 LEFT JOIN ( 111 t4 INNER JOIN t5 USING(a) 112 ) USING(a) 113 ) USING(a) 114 ) USING(a) 115 ORDER BY 1 NULLS FIRST; 116} { 117 12 12 12 12 - - 118 15 15 15 15 15 15 119 120} 121do_execsql_test joinC-6 { 122 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 123 FROM t1 INNER JOIN ( 124 t2 INNER JOIN ( 125 t3 LEFT JOIN ( 126 t4 LEFT JOIN t5 USING(a) 127 ) USING(a) 128 ) USING(a) 129 ) USING(a) 130 ORDER BY 1 NULLS FIRST; 131} { 132 12 12 12 12 - - 133 15 15 15 15 15 15 134 135} 136do_execsql_test joinC-7 { 137 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 138 FROM t1 INNER JOIN ( 139 t2 INNER JOIN ( 140 t3 LEFT JOIN ( 141 t4 RIGHT JOIN t5 USING(a) 142 ) USING(a) 143 ) USING(a) 144 ) USING(a) 145 ORDER BY 1 NULLS FIRST; 146} { 147 12 12 12 12 - - 148 15 15 15 15 15 15 149 150} 151do_execsql_test joinC-8 { 152 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 153 FROM t1 INNER JOIN ( 154 t2 INNER JOIN ( 155 t3 LEFT JOIN ( 156 t4 FULL JOIN t5 USING(a) 157 ) USING(a) 158 ) USING(a) 159 ) USING(a) 160 ORDER BY 1 NULLS FIRST; 161} { 162 12 12 12 12 - - 163 15 15 15 15 15 15 164 165} 166do_execsql_test joinC-9 { 167 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 168 FROM t1 INNER JOIN ( 169 t2 INNER JOIN ( 170 t3 RIGHT JOIN ( 171 t4 INNER JOIN t5 USING(a) 172 ) USING(a) 173 ) USING(a) 174 ) USING(a) 175 ORDER BY 1 NULLS FIRST; 176} { 177 15 15 15 15 15 15 178 179} 180do_execsql_test joinC-10 { 181 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 182 FROM t1 INNER JOIN ( 183 t2 INNER JOIN ( 184 t3 RIGHT JOIN ( 185 t4 LEFT JOIN t5 USING(a) 186 ) USING(a) 187 ) USING(a) 188 ) USING(a) 189 ORDER BY 1 NULLS FIRST; 190} { 191 15 15 15 15 15 15 192 193} 194do_execsql_test joinC-11 { 195 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 196 FROM t1 INNER JOIN ( 197 t2 INNER JOIN ( 198 t3 RIGHT JOIN ( 199 t4 RIGHT JOIN t5 USING(a) 200 ) USING(a) 201 ) USING(a) 202 ) USING(a) 203 ORDER BY 1 NULLS FIRST; 204} { 205 15 15 15 15 15 15 206 207} 208do_execsql_test joinC-12 { 209 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 210 FROM t1 INNER JOIN ( 211 t2 INNER JOIN ( 212 t3 RIGHT JOIN ( 213 t4 FULL JOIN t5 USING(a) 214 ) USING(a) 215 ) USING(a) 216 ) USING(a) 217 ORDER BY 1 NULLS FIRST; 218} { 219 15 15 15 15 15 15 220 221} 222do_execsql_test joinC-13 { 223 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 224 FROM t1 INNER JOIN ( 225 t2 INNER JOIN ( 226 t3 FULL JOIN ( 227 t4 INNER JOIN t5 USING(a) 228 ) USING(a) 229 ) USING(a) 230 ) USING(a) 231 ORDER BY 1 NULLS FIRST; 232} { 233 12 12 12 12 - - 234 15 15 15 15 15 15 235 236} 237do_execsql_test joinC-14 { 238 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 239 FROM t1 INNER JOIN ( 240 t2 INNER JOIN ( 241 t3 FULL JOIN ( 242 t4 LEFT JOIN t5 USING(a) 243 ) USING(a) 244 ) USING(a) 245 ) USING(a) 246 ORDER BY 1 NULLS FIRST; 247} { 248 12 12 12 12 - - 249 15 15 15 15 15 15 250 251} 252do_execsql_test joinC-15 { 253 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 254 FROM t1 INNER JOIN ( 255 t2 INNER JOIN ( 256 t3 FULL JOIN ( 257 t4 RIGHT JOIN t5 USING(a) 258 ) USING(a) 259 ) USING(a) 260 ) USING(a) 261 ORDER BY 1 NULLS FIRST; 262} { 263 12 12 12 12 - - 264 15 15 15 15 15 15 265 266} 267do_execsql_test joinC-16 { 268 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 269 FROM t1 INNER JOIN ( 270 t2 INNER JOIN ( 271 t3 FULL JOIN ( 272 t4 FULL JOIN t5 USING(a) 273 ) USING(a) 274 ) USING(a) 275 ) USING(a) 276 ORDER BY 1 NULLS FIRST; 277} { 278 12 12 12 12 - - 279 15 15 15 15 15 15 280 281} 282do_execsql_test joinC-17 { 283 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 284 FROM t1 INNER JOIN ( 285 t2 LEFT JOIN ( 286 t3 INNER JOIN ( 287 t4 INNER JOIN t5 USING(a) 288 ) USING(a) 289 ) USING(a) 290 ) USING(a) 291 ORDER BY 1 NULLS FIRST; 292} { 293 12 12 12 - - - 294 15 15 15 15 15 15 295 296} 297do_execsql_test joinC-18 { 298 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 299 FROM t1 INNER JOIN ( 300 t2 LEFT JOIN ( 301 t3 INNER JOIN ( 302 t4 LEFT JOIN t5 USING(a) 303 ) USING(a) 304 ) USING(a) 305 ) USING(a) 306 ORDER BY 1 NULLS FIRST; 307} { 308 12 12 12 - - - 309 15 15 15 15 15 15 310 311} 312do_execsql_test joinC-19 { 313 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 314 FROM t1 INNER JOIN ( 315 t2 LEFT JOIN ( 316 t3 INNER JOIN ( 317 t4 RIGHT JOIN t5 USING(a) 318 ) USING(a) 319 ) USING(a) 320 ) USING(a) 321 ORDER BY 1 NULLS FIRST; 322} { 323 12 12 12 - - - 324 15 15 15 15 15 15 325 326} 327do_execsql_test joinC-20 { 328 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 329 FROM t1 INNER JOIN ( 330 t2 LEFT JOIN ( 331 t3 INNER JOIN ( 332 t4 FULL JOIN t5 USING(a) 333 ) USING(a) 334 ) USING(a) 335 ) USING(a) 336 ORDER BY 1 NULLS FIRST; 337} { 338 12 12 12 - - - 339 15 15 15 15 15 15 340 341} 342do_execsql_test joinC-21 { 343 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 344 FROM t1 INNER JOIN ( 345 t2 LEFT JOIN ( 346 t3 LEFT JOIN ( 347 t4 INNER JOIN t5 USING(a) 348 ) USING(a) 349 ) USING(a) 350 ) USING(a) 351 ORDER BY 1 NULLS FIRST; 352} { 353 12 12 12 12 - - 354 15 15 15 15 15 15 355 356} 357do_execsql_test joinC-22 { 358 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 359 FROM t1 INNER JOIN ( 360 t2 LEFT JOIN ( 361 t3 LEFT JOIN ( 362 t4 LEFT JOIN t5 USING(a) 363 ) USING(a) 364 ) USING(a) 365 ) USING(a) 366 ORDER BY 1 NULLS FIRST; 367} { 368 12 12 12 12 - - 369 15 15 15 15 15 15 370 371} 372do_execsql_test joinC-23 { 373 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 374 FROM t1 INNER JOIN ( 375 t2 LEFT JOIN ( 376 t3 LEFT JOIN ( 377 t4 RIGHT JOIN t5 USING(a) 378 ) USING(a) 379 ) USING(a) 380 ) USING(a) 381 ORDER BY 1 NULLS FIRST; 382} { 383 12 12 12 12 - - 384 15 15 15 15 15 15 385 386} 387do_execsql_test joinC-24 { 388 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 389 FROM t1 INNER JOIN ( 390 t2 LEFT JOIN ( 391 t3 LEFT JOIN ( 392 t4 FULL JOIN t5 USING(a) 393 ) USING(a) 394 ) USING(a) 395 ) USING(a) 396 ORDER BY 1 NULLS FIRST; 397} { 398 12 12 12 12 - - 399 15 15 15 15 15 15 400 401} 402do_execsql_test joinC-25 { 403 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 404 FROM t1 INNER JOIN ( 405 t2 LEFT JOIN ( 406 t3 RIGHT JOIN ( 407 t4 INNER JOIN t5 USING(a) 408 ) USING(a) 409 ) USING(a) 410 ) USING(a) 411 ORDER BY 1 NULLS FIRST; 412} { 413 12 12 12 - - - 414 15 15 15 15 15 15 415 416} 417do_execsql_test joinC-26 { 418 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 419 FROM t1 INNER JOIN ( 420 t2 LEFT JOIN ( 421 t3 RIGHT JOIN ( 422 t4 LEFT JOIN t5 USING(a) 423 ) USING(a) 424 ) USING(a) 425 ) USING(a) 426 ORDER BY 1 NULLS FIRST; 427} { 428 12 12 12 - - - 429 15 15 15 15 15 15 430 431} 432do_execsql_test joinC-27 { 433 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 434 FROM t1 INNER JOIN ( 435 t2 LEFT JOIN ( 436 t3 RIGHT JOIN ( 437 t4 RIGHT JOIN t5 USING(a) 438 ) USING(a) 439 ) USING(a) 440 ) USING(a) 441 ORDER BY 1 NULLS FIRST; 442} { 443 12 12 12 - - - 444 15 15 15 15 15 15 445 446} 447do_execsql_test joinC-28 { 448 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 449 FROM t1 INNER JOIN ( 450 t2 LEFT JOIN ( 451 t3 RIGHT JOIN ( 452 t4 FULL JOIN t5 USING(a) 453 ) USING(a) 454 ) USING(a) 455 ) USING(a) 456 ORDER BY 1 NULLS FIRST; 457} { 458 12 12 12 - - - 459 15 15 15 15 15 15 460 461} 462do_execsql_test joinC-29 { 463 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 464 FROM t1 INNER JOIN ( 465 t2 LEFT JOIN ( 466 t3 FULL JOIN ( 467 t4 INNER JOIN t5 USING(a) 468 ) USING(a) 469 ) USING(a) 470 ) USING(a) 471 ORDER BY 1 NULLS FIRST; 472} { 473 12 12 12 12 - - 474 15 15 15 15 15 15 475 476} 477do_execsql_test joinC-30 { 478 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 479 FROM t1 INNER JOIN ( 480 t2 LEFT JOIN ( 481 t3 FULL JOIN ( 482 t4 LEFT JOIN t5 USING(a) 483 ) USING(a) 484 ) USING(a) 485 ) USING(a) 486 ORDER BY 1 NULLS FIRST; 487} { 488 12 12 12 12 - - 489 15 15 15 15 15 15 490 491} 492do_execsql_test joinC-31 { 493 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 494 FROM t1 INNER JOIN ( 495 t2 LEFT JOIN ( 496 t3 FULL JOIN ( 497 t4 RIGHT JOIN t5 USING(a) 498 ) USING(a) 499 ) USING(a) 500 ) USING(a) 501 ORDER BY 1 NULLS FIRST; 502} { 503 12 12 12 12 - - 504 15 15 15 15 15 15 505 506} 507do_execsql_test joinC-32 { 508 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 509 FROM t1 INNER JOIN ( 510 t2 LEFT JOIN ( 511 t3 FULL JOIN ( 512 t4 FULL JOIN t5 USING(a) 513 ) USING(a) 514 ) USING(a) 515 ) USING(a) 516 ORDER BY 1 NULLS FIRST; 517} { 518 12 12 12 12 - - 519 15 15 15 15 15 15 520 521} 522do_execsql_test joinC-33 { 523 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 524 FROM t1 INNER JOIN ( 525 t2 RIGHT JOIN ( 526 t3 INNER JOIN ( 527 t4 INNER JOIN t5 USING(a) 528 ) USING(a) 529 ) USING(a) 530 ) USING(a) 531 ORDER BY 1 NULLS FIRST; 532} { 533 15 15 15 15 15 15 534 535} 536do_execsql_test joinC-34 { 537 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 538 FROM t1 INNER JOIN ( 539 t2 RIGHT JOIN ( 540 t3 INNER JOIN ( 541 t4 LEFT JOIN t5 USING(a) 542 ) USING(a) 543 ) USING(a) 544 ) USING(a) 545 ORDER BY 1 NULLS FIRST; 546} { 547 11 11 - 11 11 - 548 15 15 15 15 15 15 549 550} 551do_execsql_test joinC-35 { 552 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 553 FROM t1 INNER JOIN ( 554 t2 RIGHT JOIN ( 555 t3 INNER JOIN ( 556 t4 RIGHT JOIN t5 USING(a) 557 ) USING(a) 558 ) USING(a) 559 ) USING(a) 560 ORDER BY 1 NULLS FIRST; 561} { 562 15 15 15 15 15 15 563 17 17 - 17 - 17 564 565} 566do_execsql_test joinC-36 { 567 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 568 FROM t1 INNER JOIN ( 569 t2 RIGHT JOIN ( 570 t3 INNER JOIN ( 571 t4 FULL JOIN t5 USING(a) 572 ) USING(a) 573 ) USING(a) 574 ) USING(a) 575 ORDER BY 1 NULLS FIRST; 576} { 577 11 11 - 11 11 - 578 15 15 15 15 15 15 579 17 17 - 17 - 17 580 581} 582do_execsql_test joinC-37 { 583 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 584 FROM t1 INNER JOIN ( 585 t2 RIGHT JOIN ( 586 t3 LEFT JOIN ( 587 t4 INNER JOIN t5 USING(a) 588 ) USING(a) 589 ) USING(a) 590 ) USING(a) 591 ORDER BY 1 NULLS FIRST; 592} { 593 11 11 - 11 - - 594 12 12 12 12 - - 595 15 15 15 15 15 15 596 17 17 - 17 - - 597 598} 599do_execsql_test joinC-38 { 600 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 601 FROM t1 INNER JOIN ( 602 t2 RIGHT JOIN ( 603 t3 LEFT JOIN ( 604 t4 LEFT JOIN t5 USING(a) 605 ) USING(a) 606 ) USING(a) 607 ) USING(a) 608 ORDER BY 1 NULLS FIRST; 609} { 610 11 11 - 11 11 - 611 12 12 12 12 - - 612 15 15 15 15 15 15 613 17 17 - 17 - - 614 615} 616do_execsql_test joinC-39 { 617 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 618 FROM t1 INNER JOIN ( 619 t2 RIGHT JOIN ( 620 t3 LEFT JOIN ( 621 t4 RIGHT JOIN t5 USING(a) 622 ) USING(a) 623 ) USING(a) 624 ) USING(a) 625 ORDER BY 1 NULLS FIRST; 626} { 627 11 11 - 11 - - 628 12 12 12 12 - - 629 15 15 15 15 15 15 630 17 17 - 17 - 17 631 632} 633do_execsql_test joinC-40 { 634 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 635 FROM t1 INNER JOIN ( 636 t2 RIGHT JOIN ( 637 t3 LEFT JOIN ( 638 t4 FULL JOIN t5 USING(a) 639 ) USING(a) 640 ) USING(a) 641 ) USING(a) 642 ORDER BY 1 NULLS FIRST; 643} { 644 11 11 - 11 11 - 645 12 12 12 12 - - 646 15 15 15 15 15 15 647 17 17 - 17 - 17 648 649} 650do_execsql_test joinC-41 { 651 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 652 FROM t1 INNER JOIN ( 653 t2 RIGHT JOIN ( 654 t3 RIGHT JOIN ( 655 t4 INNER JOIN t5 USING(a) 656 ) USING(a) 657 ) USING(a) 658 ) USING(a) 659 ORDER BY 1 NULLS FIRST; 660} { 661 15 15 15 15 15 15 662 663} 664do_execsql_test joinC-42 { 665 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 666 FROM t1 INNER JOIN ( 667 t2 RIGHT JOIN ( 668 t3 RIGHT JOIN ( 669 t4 LEFT JOIN t5 USING(a) 670 ) USING(a) 671 ) USING(a) 672 ) USING(a) 673 ORDER BY 1 NULLS FIRST; 674} { 675 11 11 - 11 11 - 676 15 15 15 15 15 15 677 678} 679do_execsql_test joinC-43 { 680 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 681 FROM t1 INNER JOIN ( 682 t2 RIGHT JOIN ( 683 t3 RIGHT JOIN ( 684 t4 RIGHT JOIN t5 USING(a) 685 ) USING(a) 686 ) USING(a) 687 ) USING(a) 688 ORDER BY 1 NULLS FIRST; 689} { 690 15 15 15 15 15 15 691 17 17 - 17 - 17 692 693} 694do_execsql_test joinC-44 { 695 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 696 FROM t1 INNER JOIN ( 697 t2 RIGHT JOIN ( 698 t3 RIGHT JOIN ( 699 t4 FULL JOIN t5 USING(a) 700 ) USING(a) 701 ) USING(a) 702 ) USING(a) 703 ORDER BY 1 NULLS FIRST; 704} { 705 11 11 - 11 11 - 706 15 15 15 15 15 15 707 17 17 - 17 - 17 708 709} 710do_execsql_test joinC-45 { 711 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 712 FROM t1 INNER JOIN ( 713 t2 RIGHT JOIN ( 714 t3 FULL JOIN ( 715 t4 INNER JOIN t5 USING(a) 716 ) USING(a) 717 ) USING(a) 718 ) USING(a) 719 ORDER BY 1 NULLS FIRST; 720} { 721 11 11 - 11 - - 722 12 12 12 12 - - 723 15 15 15 15 15 15 724 17 17 - 17 - - 725 726} 727do_execsql_test joinC-46 { 728 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 729 FROM t1 INNER JOIN ( 730 t2 RIGHT JOIN ( 731 t3 FULL JOIN ( 732 t4 LEFT JOIN t5 USING(a) 733 ) USING(a) 734 ) USING(a) 735 ) USING(a) 736 ORDER BY 1 NULLS FIRST; 737} { 738 11 11 - 11 11 - 739 12 12 12 12 - - 740 15 15 15 15 15 15 741 17 17 - 17 - - 742 743} 744do_execsql_test joinC-47 { 745 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 746 FROM t1 INNER JOIN ( 747 t2 RIGHT JOIN ( 748 t3 FULL JOIN ( 749 t4 RIGHT JOIN t5 USING(a) 750 ) USING(a) 751 ) USING(a) 752 ) USING(a) 753 ORDER BY 1 NULLS FIRST; 754} { 755 11 11 - 11 - - 756 12 12 12 12 - - 757 15 15 15 15 15 15 758 17 17 - 17 - 17 759 760} 761do_execsql_test joinC-48 { 762 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 763 FROM t1 INNER JOIN ( 764 t2 RIGHT JOIN ( 765 t3 FULL JOIN ( 766 t4 FULL JOIN t5 USING(a) 767 ) USING(a) 768 ) USING(a) 769 ) USING(a) 770 ORDER BY 1 NULLS FIRST; 771} { 772 11 11 - 11 11 - 773 12 12 12 12 - - 774 15 15 15 15 15 15 775 17 17 - 17 - 17 776 777} 778do_execsql_test joinC-49 { 779 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 780 FROM t1 INNER JOIN ( 781 t2 FULL JOIN ( 782 t3 INNER JOIN ( 783 t4 INNER JOIN t5 USING(a) 784 ) USING(a) 785 ) USING(a) 786 ) USING(a) 787 ORDER BY 1 NULLS FIRST; 788} { 789 12 12 12 - - - 790 15 15 15 15 15 15 791 792} 793do_execsql_test joinC-50 { 794 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 795 FROM t1 INNER JOIN ( 796 t2 FULL JOIN ( 797 t3 INNER JOIN ( 798 t4 LEFT JOIN t5 USING(a) 799 ) USING(a) 800 ) USING(a) 801 ) USING(a) 802 ORDER BY 1 NULLS FIRST; 803} { 804 11 11 - 11 11 - 805 12 12 12 - - - 806 15 15 15 15 15 15 807 808} 809do_execsql_test joinC-51 { 810 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 811 FROM t1 INNER JOIN ( 812 t2 FULL JOIN ( 813 t3 INNER JOIN ( 814 t4 RIGHT JOIN t5 USING(a) 815 ) USING(a) 816 ) USING(a) 817 ) USING(a) 818 ORDER BY 1 NULLS FIRST; 819} { 820 12 12 12 - - - 821 15 15 15 15 15 15 822 17 17 - 17 - 17 823 824} 825do_execsql_test joinC-52 { 826 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 827 FROM t1 INNER JOIN ( 828 t2 FULL JOIN ( 829 t3 INNER JOIN ( 830 t4 FULL JOIN t5 USING(a) 831 ) USING(a) 832 ) USING(a) 833 ) USING(a) 834 ORDER BY 1 NULLS FIRST; 835} { 836 11 11 - 11 11 - 837 12 12 12 - - - 838 15 15 15 15 15 15 839 17 17 - 17 - 17 840 841} 842do_execsql_test joinC-53 { 843 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 844 FROM t1 INNER JOIN ( 845 t2 FULL JOIN ( 846 t3 LEFT JOIN ( 847 t4 INNER JOIN t5 USING(a) 848 ) USING(a) 849 ) USING(a) 850 ) USING(a) 851 ORDER BY 1 NULLS FIRST; 852} { 853 11 11 - 11 - - 854 12 12 12 12 - - 855 15 15 15 15 15 15 856 17 17 - 17 - - 857 858} 859do_execsql_test joinC-54 { 860 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 861 FROM t1 INNER JOIN ( 862 t2 FULL JOIN ( 863 t3 LEFT JOIN ( 864 t4 LEFT JOIN t5 USING(a) 865 ) USING(a) 866 ) USING(a) 867 ) USING(a) 868 ORDER BY 1 NULLS FIRST; 869} { 870 11 11 - 11 11 - 871 12 12 12 12 - - 872 15 15 15 15 15 15 873 17 17 - 17 - - 874 875} 876do_execsql_test joinC-55 { 877 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 878 FROM t1 INNER JOIN ( 879 t2 FULL JOIN ( 880 t3 LEFT JOIN ( 881 t4 RIGHT JOIN t5 USING(a) 882 ) USING(a) 883 ) USING(a) 884 ) USING(a) 885 ORDER BY 1 NULLS FIRST; 886} { 887 11 11 - 11 - - 888 12 12 12 12 - - 889 15 15 15 15 15 15 890 17 17 - 17 - 17 891 892} 893do_execsql_test joinC-56 { 894 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 895 FROM t1 INNER JOIN ( 896 t2 FULL JOIN ( 897 t3 LEFT JOIN ( 898 t4 FULL JOIN t5 USING(a) 899 ) USING(a) 900 ) USING(a) 901 ) USING(a) 902 ORDER BY 1 NULLS FIRST; 903} { 904 11 11 - 11 11 - 905 12 12 12 12 - - 906 15 15 15 15 15 15 907 17 17 - 17 - 17 908 909} 910do_execsql_test joinC-57 { 911 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 912 FROM t1 INNER JOIN ( 913 t2 FULL JOIN ( 914 t3 RIGHT JOIN ( 915 t4 INNER JOIN t5 USING(a) 916 ) USING(a) 917 ) USING(a) 918 ) USING(a) 919 ORDER BY 1 NULLS FIRST; 920} { 921 12 12 12 - - - 922 15 15 15 15 15 15 923 924} 925do_execsql_test joinC-58 { 926 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 927 FROM t1 INNER JOIN ( 928 t2 FULL JOIN ( 929 t3 RIGHT JOIN ( 930 t4 LEFT JOIN t5 USING(a) 931 ) USING(a) 932 ) USING(a) 933 ) USING(a) 934 ORDER BY 1 NULLS FIRST; 935} { 936 11 11 - 11 11 - 937 12 12 12 - - - 938 15 15 15 15 15 15 939 940} 941do_execsql_test joinC-59 { 942 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 943 FROM t1 INNER JOIN ( 944 t2 FULL JOIN ( 945 t3 RIGHT JOIN ( 946 t4 RIGHT JOIN t5 USING(a) 947 ) USING(a) 948 ) USING(a) 949 ) USING(a) 950 ORDER BY 1 NULLS FIRST; 951} { 952 12 12 12 - - - 953 15 15 15 15 15 15 954 17 17 - 17 - 17 955 956} 957do_execsql_test joinC-60 { 958 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 959 FROM t1 INNER JOIN ( 960 t2 FULL JOIN ( 961 t3 RIGHT JOIN ( 962 t4 FULL JOIN t5 USING(a) 963 ) USING(a) 964 ) USING(a) 965 ) USING(a) 966 ORDER BY 1 NULLS FIRST; 967} { 968 11 11 - 11 11 - 969 12 12 12 - - - 970 15 15 15 15 15 15 971 17 17 - 17 - 17 972 973} 974do_execsql_test joinC-61 { 975 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 976 FROM t1 INNER JOIN ( 977 t2 FULL JOIN ( 978 t3 FULL JOIN ( 979 t4 INNER JOIN t5 USING(a) 980 ) USING(a) 981 ) USING(a) 982 ) USING(a) 983 ORDER BY 1 NULLS FIRST; 984} { 985 11 11 - 11 - - 986 12 12 12 12 - - 987 15 15 15 15 15 15 988 17 17 - 17 - - 989 990} 991do_execsql_test joinC-62 { 992 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 993 FROM t1 INNER JOIN ( 994 t2 FULL JOIN ( 995 t3 FULL JOIN ( 996 t4 LEFT JOIN t5 USING(a) 997 ) USING(a) 998 ) USING(a) 999 ) USING(a) 1000 ORDER BY 1 NULLS FIRST; 1001} { 1002 11 11 - 11 11 - 1003 12 12 12 12 - - 1004 15 15 15 15 15 15 1005 17 17 - 17 - - 1006 1007} 1008do_execsql_test joinC-63 { 1009 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 1010 FROM t1 INNER JOIN ( 1011 t2 FULL JOIN ( 1012 t3 FULL JOIN ( 1013 t4 RIGHT JOIN t5 USING(a) 1014 ) USING(a) 1015 ) USING(a) 1016 ) USING(a) 1017 ORDER BY 1 NULLS FIRST; 1018} { 1019 11 11 - 11 - - 1020 12 12 12 12 - - 1021 15 15 15 15 15 15 1022 17 17 - 17 - 17 1023 1024} 1025do_execsql_test joinC-64 { 1026 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 1027 FROM t1 INNER JOIN ( 1028 t2 FULL JOIN ( 1029 t3 FULL JOIN ( 1030 t4 FULL JOIN t5 USING(a) 1031 ) USING(a) 1032 ) USING(a) 1033 ) USING(a) 1034 ORDER BY 1 NULLS FIRST; 1035} { 1036 11 11 - 11 11 - 1037 12 12 12 12 - - 1038 15 15 15 15 15 15 1039 17 17 - 17 - 17 1040 1041} 1042do_execsql_test joinC-65 { 1043 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 1044 FROM t1 LEFT JOIN ( 1045 t2 INNER JOIN ( 1046 t3 INNER JOIN ( 1047 t4 INNER JOIN t5 USING(a) 1048 ) USING(a) 1049 ) USING(a) 1050 ) USING(a) 1051 ORDER BY 1 NULLS FIRST; 1052} { 1053 11 11 - - - - 1054 12 12 - - - - 1055 15 15 15 15 15 15 1056 17 17 - - - - 1057 1058} 1059do_execsql_test joinC-66 { 1060 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 1061 FROM t1 LEFT JOIN ( 1062 t2 INNER JOIN ( 1063 t3 INNER JOIN ( 1064 t4 LEFT JOIN t5 USING(a) 1065 ) USING(a) 1066 ) USING(a) 1067 ) USING(a) 1068 ORDER BY 1 NULLS FIRST; 1069} { 1070 11 11 - - - - 1071 12 12 - - - - 1072 15 15 15 15 15 15 1073 17 17 - - - - 1074 1075} 1076do_execsql_test joinC-67 { 1077 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 1078 FROM t1 LEFT JOIN ( 1079 t2 INNER JOIN ( 1080 t3 INNER JOIN ( 1081 t4 RIGHT JOIN t5 USING(a) 1082 ) USING(a) 1083 ) USING(a) 1084 ) USING(a) 1085 ORDER BY 1 NULLS FIRST; 1086} { 1087 11 11 - - - - 1088 12 12 - - - - 1089 15 15 15 15 15 15 1090 17 17 - - - - 1091 1092} 1093do_execsql_test joinC-68 { 1094 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 1095 FROM t1 LEFT JOIN ( 1096 t2 INNER JOIN ( 1097 t3 INNER JOIN ( 1098 t4 FULL JOIN t5 USING(a) 1099 ) USING(a) 1100 ) USING(a) 1101 ) USING(a) 1102 ORDER BY 1 NULLS FIRST; 1103} { 1104 11 11 - - - - 1105 12 12 - - - - 1106 15 15 15 15 15 15 1107 17 17 - - - - 1108 1109} 1110do_execsql_test joinC-69 { 1111 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 1112 FROM t1 LEFT JOIN ( 1113 t2 INNER JOIN ( 1114 t3 LEFT JOIN ( 1115 t4 INNER JOIN t5 USING(a) 1116 ) USING(a) 1117 ) USING(a) 1118 ) USING(a) 1119 ORDER BY 1 NULLS FIRST; 1120} { 1121 11 11 - - - - 1122 12 12 12 12 - - 1123 15 15 15 15 15 15 1124 17 17 - - - - 1125 1126} 1127do_execsql_test joinC-70 { 1128 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 1129 FROM t1 LEFT JOIN ( 1130 t2 INNER JOIN ( 1131 t3 LEFT JOIN ( 1132 t4 LEFT JOIN t5 USING(a) 1133 ) USING(a) 1134 ) USING(a) 1135 ) USING(a) 1136 ORDER BY 1 NULLS FIRST; 1137} { 1138 11 11 - - - - 1139 12 12 12 12 - - 1140 15 15 15 15 15 15 1141 17 17 - - - - 1142 1143} 1144do_execsql_test joinC-71 { 1145 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 1146 FROM t1 LEFT JOIN ( 1147 t2 INNER JOIN ( 1148 t3 LEFT JOIN ( 1149 t4 RIGHT JOIN t5 USING(a) 1150 ) USING(a) 1151 ) USING(a) 1152 ) USING(a) 1153 ORDER BY 1 NULLS FIRST; 1154} { 1155 11 11 - - - - 1156 12 12 12 12 - - 1157 15 15 15 15 15 15 1158 17 17 - - - - 1159 1160} 1161do_execsql_test joinC-72 { 1162 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 1163 FROM t1 LEFT JOIN ( 1164 t2 INNER JOIN ( 1165 t3 LEFT JOIN ( 1166 t4 FULL JOIN t5 USING(a) 1167 ) USING(a) 1168 ) USING(a) 1169 ) USING(a) 1170 ORDER BY 1 NULLS FIRST; 1171} { 1172 11 11 - - - - 1173 12 12 12 12 - - 1174 15 15 15 15 15 15 1175 17 17 - - - - 1176 1177} 1178do_execsql_test joinC-73 { 1179 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 1180 FROM t1 LEFT JOIN ( 1181 t2 INNER JOIN ( 1182 t3 RIGHT JOIN ( 1183 t4 INNER JOIN t5 USING(a) 1184 ) USING(a) 1185 ) USING(a) 1186 ) USING(a) 1187 ORDER BY 1 NULLS FIRST; 1188} { 1189 11 11 - - - - 1190 12 12 - - - - 1191 15 15 15 15 15 15 1192 17 17 - - - - 1193 1194} 1195do_execsql_test joinC-74 { 1196 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 1197 FROM t1 LEFT JOIN ( 1198 t2 INNER JOIN ( 1199 t3 RIGHT JOIN ( 1200 t4 LEFT JOIN t5 USING(a) 1201 ) USING(a) 1202 ) USING(a) 1203 ) USING(a) 1204 ORDER BY 1 NULLS FIRST; 1205} { 1206 11 11 - - - - 1207 12 12 - - - - 1208 15 15 15 15 15 15 1209 17 17 - - - - 1210 1211} 1212do_execsql_test joinC-75 { 1213 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 1214 FROM t1 LEFT JOIN ( 1215 t2 INNER JOIN ( 1216 t3 RIGHT JOIN ( 1217 t4 RIGHT JOIN t5 USING(a) 1218 ) USING(a) 1219 ) USING(a) 1220 ) USING(a) 1221 ORDER BY 1 NULLS FIRST; 1222} { 1223 11 11 - - - - 1224 12 12 - - - - 1225 15 15 15 15 15 15 1226 17 17 - - - - 1227 1228} 1229do_execsql_test joinC-76 { 1230 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 1231 FROM t1 LEFT JOIN ( 1232 t2 INNER JOIN ( 1233 t3 RIGHT JOIN ( 1234 t4 FULL JOIN t5 USING(a) 1235 ) USING(a) 1236 ) USING(a) 1237 ) USING(a) 1238 ORDER BY 1 NULLS FIRST; 1239} { 1240 11 11 - - - - 1241 12 12 - - - - 1242 15 15 15 15 15 15 1243 17 17 - - - - 1244 1245} 1246do_execsql_test joinC-77 { 1247 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 1248 FROM t1 LEFT JOIN ( 1249 t2 INNER JOIN ( 1250 t3 FULL JOIN ( 1251 t4 INNER JOIN t5 USING(a) 1252 ) USING(a) 1253 ) USING(a) 1254 ) USING(a) 1255 ORDER BY 1 NULLS FIRST; 1256} { 1257 11 11 - - - - 1258 12 12 12 12 - - 1259 15 15 15 15 15 15 1260 17 17 - - - - 1261 1262} 1263do_execsql_test joinC-78 { 1264 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 1265 FROM t1 LEFT JOIN ( 1266 t2 INNER JOIN ( 1267 t3 FULL JOIN ( 1268 t4 LEFT JOIN t5 USING(a) 1269 ) USING(a) 1270 ) USING(a) 1271 ) USING(a) 1272 ORDER BY 1 NULLS FIRST; 1273} { 1274 11 11 - - - - 1275 12 12 12 12 - - 1276 15 15 15 15 15 15 1277 17 17 - - - - 1278 1279} 1280do_execsql_test joinC-79 { 1281 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 1282 FROM t1 LEFT JOIN ( 1283 t2 INNER JOIN ( 1284 t3 FULL JOIN ( 1285 t4 RIGHT JOIN t5 USING(a) 1286 ) USING(a) 1287 ) USING(a) 1288 ) USING(a) 1289 ORDER BY 1 NULLS FIRST; 1290} { 1291 11 11 - - - - 1292 12 12 12 12 - - 1293 15 15 15 15 15 15 1294 17 17 - - - - 1295 1296} 1297do_execsql_test joinC-80 { 1298 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 1299 FROM t1 LEFT JOIN ( 1300 t2 INNER JOIN ( 1301 t3 FULL JOIN ( 1302 t4 FULL JOIN t5 USING(a) 1303 ) USING(a) 1304 ) USING(a) 1305 ) USING(a) 1306 ORDER BY 1 NULLS FIRST; 1307} { 1308 11 11 - - - - 1309 12 12 12 12 - - 1310 15 15 15 15 15 15 1311 17 17 - - - - 1312 1313} 1314do_execsql_test joinC-81 { 1315 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 1316 FROM t1 LEFT JOIN ( 1317 t2 LEFT JOIN ( 1318 t3 INNER JOIN ( 1319 t4 INNER JOIN t5 USING(a) 1320 ) USING(a) 1321 ) USING(a) 1322 ) USING(a) 1323 ORDER BY 1 NULLS FIRST; 1324} { 1325 11 11 - - - - 1326 12 12 12 - - - 1327 15 15 15 15 15 15 1328 17 17 - - - - 1329 1330} 1331do_execsql_test joinC-82 { 1332 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 1333 FROM t1 LEFT JOIN ( 1334 t2 LEFT JOIN ( 1335 t3 INNER JOIN ( 1336 t4 LEFT JOIN t5 USING(a) 1337 ) USING(a) 1338 ) USING(a) 1339 ) USING(a) 1340 ORDER BY 1 NULLS FIRST; 1341} { 1342 11 11 - - - - 1343 12 12 12 - - - 1344 15 15 15 15 15 15 1345 17 17 - - - - 1346 1347} 1348do_execsql_test joinC-83 { 1349 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 1350 FROM t1 LEFT JOIN ( 1351 t2 LEFT JOIN ( 1352 t3 INNER JOIN ( 1353 t4 RIGHT JOIN t5 USING(a) 1354 ) USING(a) 1355 ) USING(a) 1356 ) USING(a) 1357 ORDER BY 1 NULLS FIRST; 1358} { 1359 11 11 - - - - 1360 12 12 12 - - - 1361 15 15 15 15 15 15 1362 17 17 - - - - 1363 1364} 1365do_execsql_test joinC-84 { 1366 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 1367 FROM t1 LEFT JOIN ( 1368 t2 LEFT JOIN ( 1369 t3 INNER JOIN ( 1370 t4 FULL JOIN t5 USING(a) 1371 ) USING(a) 1372 ) USING(a) 1373 ) USING(a) 1374 ORDER BY 1 NULLS FIRST; 1375} { 1376 11 11 - - - - 1377 12 12 12 - - - 1378 15 15 15 15 15 15 1379 17 17 - - - - 1380 1381} 1382do_execsql_test joinC-85 { 1383 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 1384 FROM t1 LEFT JOIN ( 1385 t2 LEFT JOIN ( 1386 t3 LEFT JOIN ( 1387 t4 INNER JOIN t5 USING(a) 1388 ) USING(a) 1389 ) USING(a) 1390 ) USING(a) 1391 ORDER BY 1 NULLS FIRST; 1392} { 1393 11 11 - - - - 1394 12 12 12 12 - - 1395 15 15 15 15 15 15 1396 17 17 - - - - 1397 1398} 1399do_execsql_test joinC-86 { 1400 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 1401 FROM t1 LEFT JOIN ( 1402 t2 LEFT JOIN ( 1403 t3 LEFT JOIN ( 1404 t4 LEFT JOIN t5 USING(a) 1405 ) USING(a) 1406 ) USING(a) 1407 ) USING(a) 1408 ORDER BY 1 NULLS FIRST; 1409} { 1410 11 11 - - - - 1411 12 12 12 12 - - 1412 15 15 15 15 15 15 1413 17 17 - - - - 1414 1415} 1416do_execsql_test joinC-87 { 1417 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 1418 FROM t1 LEFT JOIN ( 1419 t2 LEFT JOIN ( 1420 t3 LEFT JOIN ( 1421 t4 RIGHT JOIN t5 USING(a) 1422 ) USING(a) 1423 ) USING(a) 1424 ) USING(a) 1425 ORDER BY 1 NULLS FIRST; 1426} { 1427 11 11 - - - - 1428 12 12 12 12 - - 1429 15 15 15 15 15 15 1430 17 17 - - - - 1431 1432} 1433do_execsql_test joinC-88 { 1434 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 1435 FROM t1 LEFT JOIN ( 1436 t2 LEFT JOIN ( 1437 t3 LEFT JOIN ( 1438 t4 FULL JOIN t5 USING(a) 1439 ) USING(a) 1440 ) USING(a) 1441 ) USING(a) 1442 ORDER BY 1 NULLS FIRST; 1443} { 1444 11 11 - - - - 1445 12 12 12 12 - - 1446 15 15 15 15 15 15 1447 17 17 - - - - 1448 1449} 1450do_execsql_test joinC-89 { 1451 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 1452 FROM t1 LEFT JOIN ( 1453 t2 LEFT JOIN ( 1454 t3 RIGHT JOIN ( 1455 t4 INNER JOIN t5 USING(a) 1456 ) USING(a) 1457 ) USING(a) 1458 ) USING(a) 1459 ORDER BY 1 NULLS FIRST; 1460} { 1461 11 11 - - - - 1462 12 12 12 - - - 1463 15 15 15 15 15 15 1464 17 17 - - - - 1465 1466} 1467do_execsql_test joinC-90 { 1468 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 1469 FROM t1 LEFT JOIN ( 1470 t2 LEFT JOIN ( 1471 t3 RIGHT JOIN ( 1472 t4 LEFT JOIN t5 USING(a) 1473 ) USING(a) 1474 ) USING(a) 1475 ) USING(a) 1476 ORDER BY 1 NULLS FIRST; 1477} { 1478 11 11 - - - - 1479 12 12 12 - - - 1480 15 15 15 15 15 15 1481 17 17 - - - - 1482 1483} 1484do_execsql_test joinC-91 { 1485 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 1486 FROM t1 LEFT JOIN ( 1487 t2 LEFT JOIN ( 1488 t3 RIGHT JOIN ( 1489 t4 RIGHT JOIN t5 USING(a) 1490 ) USING(a) 1491 ) USING(a) 1492 ) USING(a) 1493 ORDER BY 1 NULLS FIRST; 1494} { 1495 11 11 - - - - 1496 12 12 12 - - - 1497 15 15 15 15 15 15 1498 17 17 - - - - 1499 1500} 1501do_execsql_test joinC-92 { 1502 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 1503 FROM t1 LEFT JOIN ( 1504 t2 LEFT JOIN ( 1505 t3 RIGHT JOIN ( 1506 t4 FULL JOIN t5 USING(a) 1507 ) USING(a) 1508 ) USING(a) 1509 ) USING(a) 1510 ORDER BY 1 NULLS FIRST; 1511} { 1512 11 11 - - - - 1513 12 12 12 - - - 1514 15 15 15 15 15 15 1515 17 17 - - - - 1516 1517} 1518do_execsql_test joinC-93 { 1519 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 1520 FROM t1 LEFT JOIN ( 1521 t2 LEFT JOIN ( 1522 t3 FULL JOIN ( 1523 t4 INNER JOIN t5 USING(a) 1524 ) USING(a) 1525 ) USING(a) 1526 ) USING(a) 1527 ORDER BY 1 NULLS FIRST; 1528} { 1529 11 11 - - - - 1530 12 12 12 12 - - 1531 15 15 15 15 15 15 1532 17 17 - - - - 1533 1534} 1535do_execsql_test joinC-94 { 1536 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 1537 FROM t1 LEFT JOIN ( 1538 t2 LEFT JOIN ( 1539 t3 FULL JOIN ( 1540 t4 LEFT JOIN t5 USING(a) 1541 ) USING(a) 1542 ) USING(a) 1543 ) USING(a) 1544 ORDER BY 1 NULLS FIRST; 1545} { 1546 11 11 - - - - 1547 12 12 12 12 - - 1548 15 15 15 15 15 15 1549 17 17 - - - - 1550 1551} 1552do_execsql_test joinC-95 { 1553 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 1554 FROM t1 LEFT JOIN ( 1555 t2 LEFT JOIN ( 1556 t3 FULL JOIN ( 1557 t4 RIGHT JOIN t5 USING(a) 1558 ) USING(a) 1559 ) USING(a) 1560 ) USING(a) 1561 ORDER BY 1 NULLS FIRST; 1562} { 1563 11 11 - - - - 1564 12 12 12 12 - - 1565 15 15 15 15 15 15 1566 17 17 - - - - 1567 1568} 1569do_execsql_test joinC-96 { 1570 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 1571 FROM t1 LEFT JOIN ( 1572 t2 LEFT JOIN ( 1573 t3 FULL JOIN ( 1574 t4 FULL JOIN t5 USING(a) 1575 ) USING(a) 1576 ) USING(a) 1577 ) USING(a) 1578 ORDER BY 1 NULLS FIRST; 1579} { 1580 11 11 - - - - 1581 12 12 12 12 - - 1582 15 15 15 15 15 15 1583 17 17 - - - - 1584 1585} 1586do_execsql_test joinC-97 { 1587 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 1588 FROM t1 LEFT JOIN ( 1589 t2 RIGHT JOIN ( 1590 t3 INNER JOIN ( 1591 t4 INNER JOIN t5 USING(a) 1592 ) USING(a) 1593 ) USING(a) 1594 ) USING(a) 1595 ORDER BY 1 NULLS FIRST; 1596} { 1597 11 11 - - - - 1598 12 12 - - - - 1599 15 15 15 15 15 15 1600 17 17 - - - - 1601 1602} 1603do_execsql_test joinC-98 { 1604 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 1605 FROM t1 LEFT JOIN ( 1606 t2 RIGHT JOIN ( 1607 t3 INNER JOIN ( 1608 t4 LEFT JOIN t5 USING(a) 1609 ) USING(a) 1610 ) USING(a) 1611 ) USING(a) 1612 ORDER BY 1 NULLS FIRST; 1613} { 1614 11 11 - 11 11 - 1615 12 12 - - - - 1616 15 15 15 15 15 15 1617 17 17 - - - - 1618 1619} 1620do_execsql_test joinC-99 { 1621 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 1622 FROM t1 LEFT JOIN ( 1623 t2 RIGHT JOIN ( 1624 t3 INNER JOIN ( 1625 t4 RIGHT JOIN t5 USING(a) 1626 ) USING(a) 1627 ) USING(a) 1628 ) USING(a) 1629 ORDER BY 1 NULLS FIRST; 1630} { 1631 11 11 - - - - 1632 12 12 - - - - 1633 15 15 15 15 15 15 1634 17 17 - 17 - 17 1635 1636} 1637do_execsql_test joinC-100 { 1638 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 1639 FROM t1 LEFT JOIN ( 1640 t2 RIGHT JOIN ( 1641 t3 INNER JOIN ( 1642 t4 FULL JOIN t5 USING(a) 1643 ) USING(a) 1644 ) USING(a) 1645 ) USING(a) 1646 ORDER BY 1 NULLS FIRST; 1647} { 1648 11 11 - 11 11 - 1649 12 12 - - - - 1650 15 15 15 15 15 15 1651 17 17 - 17 - 17 1652 1653} 1654do_execsql_test joinC-101 { 1655 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 1656 FROM t1 LEFT JOIN ( 1657 t2 RIGHT JOIN ( 1658 t3 LEFT JOIN ( 1659 t4 INNER JOIN t5 USING(a) 1660 ) USING(a) 1661 ) USING(a) 1662 ) USING(a) 1663 ORDER BY 1 NULLS FIRST; 1664} { 1665 11 11 - 11 - - 1666 12 12 12 12 - - 1667 15 15 15 15 15 15 1668 17 17 - 17 - - 1669 1670} 1671do_execsql_test joinC-102 { 1672 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 1673 FROM t1 LEFT JOIN ( 1674 t2 RIGHT JOIN ( 1675 t3 LEFT JOIN ( 1676 t4 LEFT JOIN t5 USING(a) 1677 ) USING(a) 1678 ) USING(a) 1679 ) USING(a) 1680 ORDER BY 1 NULLS FIRST; 1681} { 1682 11 11 - 11 11 - 1683 12 12 12 12 - - 1684 15 15 15 15 15 15 1685 17 17 - 17 - - 1686 1687} 1688do_execsql_test joinC-103 { 1689 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 1690 FROM t1 LEFT JOIN ( 1691 t2 RIGHT JOIN ( 1692 t3 LEFT JOIN ( 1693 t4 RIGHT JOIN t5 USING(a) 1694 ) USING(a) 1695 ) USING(a) 1696 ) USING(a) 1697 ORDER BY 1 NULLS FIRST; 1698} { 1699 11 11 - 11 - - 1700 12 12 12 12 - - 1701 15 15 15 15 15 15 1702 17 17 - 17 - 17 1703 1704} 1705do_execsql_test joinC-104 { 1706 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 1707 FROM t1 LEFT JOIN ( 1708 t2 RIGHT JOIN ( 1709 t3 LEFT JOIN ( 1710 t4 FULL JOIN t5 USING(a) 1711 ) USING(a) 1712 ) USING(a) 1713 ) USING(a) 1714 ORDER BY 1 NULLS FIRST; 1715} { 1716 11 11 - 11 11 - 1717 12 12 12 12 - - 1718 15 15 15 15 15 15 1719 17 17 - 17 - 17 1720 1721} 1722do_execsql_test joinC-105 { 1723 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 1724 FROM t1 LEFT JOIN ( 1725 t2 RIGHT JOIN ( 1726 t3 RIGHT JOIN ( 1727 t4 INNER JOIN t5 USING(a) 1728 ) USING(a) 1729 ) USING(a) 1730 ) USING(a) 1731 ORDER BY 1 NULLS FIRST; 1732} { 1733 11 11 - - - - 1734 12 12 - - - - 1735 15 15 15 15 15 15 1736 17 17 - - - - 1737 1738} 1739do_execsql_test joinC-106 { 1740 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 1741 FROM t1 LEFT JOIN ( 1742 t2 RIGHT JOIN ( 1743 t3 RIGHT JOIN ( 1744 t4 LEFT JOIN t5 USING(a) 1745 ) USING(a) 1746 ) USING(a) 1747 ) USING(a) 1748 ORDER BY 1 NULLS FIRST; 1749} { 1750 11 11 - 11 11 - 1751 12 12 - - - - 1752 15 15 15 15 15 15 1753 17 17 - - - - 1754 1755} 1756do_execsql_test joinC-107 { 1757 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 1758 FROM t1 LEFT JOIN ( 1759 t2 RIGHT JOIN ( 1760 t3 RIGHT JOIN ( 1761 t4 RIGHT JOIN t5 USING(a) 1762 ) USING(a) 1763 ) USING(a) 1764 ) USING(a) 1765 ORDER BY 1 NULLS FIRST; 1766} { 1767 11 11 - - - - 1768 12 12 - - - - 1769 15 15 15 15 15 15 1770 17 17 - 17 - 17 1771 1772} 1773do_execsql_test joinC-108 { 1774 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 1775 FROM t1 LEFT JOIN ( 1776 t2 RIGHT JOIN ( 1777 t3 RIGHT JOIN ( 1778 t4 FULL JOIN t5 USING(a) 1779 ) USING(a) 1780 ) USING(a) 1781 ) USING(a) 1782 ORDER BY 1 NULLS FIRST; 1783} { 1784 11 11 - 11 11 - 1785 12 12 - - - - 1786 15 15 15 15 15 15 1787 17 17 - 17 - 17 1788 1789} 1790do_execsql_test joinC-109 { 1791 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 1792 FROM t1 LEFT JOIN ( 1793 t2 RIGHT JOIN ( 1794 t3 FULL JOIN ( 1795 t4 INNER JOIN t5 USING(a) 1796 ) USING(a) 1797 ) USING(a) 1798 ) USING(a) 1799 ORDER BY 1 NULLS FIRST; 1800} { 1801 11 11 - 11 - - 1802 12 12 12 12 - - 1803 15 15 15 15 15 15 1804 17 17 - 17 - - 1805 1806} 1807do_execsql_test joinC-110 { 1808 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 1809 FROM t1 LEFT JOIN ( 1810 t2 RIGHT JOIN ( 1811 t3 FULL JOIN ( 1812 t4 LEFT JOIN t5 USING(a) 1813 ) USING(a) 1814 ) USING(a) 1815 ) USING(a) 1816 ORDER BY 1 NULLS FIRST; 1817} { 1818 11 11 - 11 11 - 1819 12 12 12 12 - - 1820 15 15 15 15 15 15 1821 17 17 - 17 - - 1822 1823} 1824do_execsql_test joinC-111 { 1825 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 1826 FROM t1 LEFT JOIN ( 1827 t2 RIGHT JOIN ( 1828 t3 FULL JOIN ( 1829 t4 RIGHT JOIN t5 USING(a) 1830 ) USING(a) 1831 ) USING(a) 1832 ) USING(a) 1833 ORDER BY 1 NULLS FIRST; 1834} { 1835 11 11 - 11 - - 1836 12 12 12 12 - - 1837 15 15 15 15 15 15 1838 17 17 - 17 - 17 1839 1840} 1841do_execsql_test joinC-112 { 1842 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 1843 FROM t1 LEFT JOIN ( 1844 t2 RIGHT JOIN ( 1845 t3 FULL JOIN ( 1846 t4 FULL JOIN t5 USING(a) 1847 ) USING(a) 1848 ) USING(a) 1849 ) USING(a) 1850 ORDER BY 1 NULLS FIRST; 1851} { 1852 11 11 - 11 11 - 1853 12 12 12 12 - - 1854 15 15 15 15 15 15 1855 17 17 - 17 - 17 1856 1857} 1858do_execsql_test joinC-113 { 1859 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 1860 FROM t1 LEFT JOIN ( 1861 t2 FULL JOIN ( 1862 t3 INNER JOIN ( 1863 t4 INNER JOIN t5 USING(a) 1864 ) USING(a) 1865 ) USING(a) 1866 ) USING(a) 1867 ORDER BY 1 NULLS FIRST; 1868} { 1869 11 11 - - - - 1870 12 12 12 - - - 1871 15 15 15 15 15 15 1872 17 17 - - - - 1873 1874} 1875do_execsql_test joinC-114 { 1876 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 1877 FROM t1 LEFT JOIN ( 1878 t2 FULL JOIN ( 1879 t3 INNER JOIN ( 1880 t4 LEFT JOIN t5 USING(a) 1881 ) USING(a) 1882 ) USING(a) 1883 ) USING(a) 1884 ORDER BY 1 NULLS FIRST; 1885} { 1886 11 11 - 11 11 - 1887 12 12 12 - - - 1888 15 15 15 15 15 15 1889 17 17 - - - - 1890 1891} 1892do_execsql_test joinC-115 { 1893 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 1894 FROM t1 LEFT JOIN ( 1895 t2 FULL JOIN ( 1896 t3 INNER JOIN ( 1897 t4 RIGHT JOIN t5 USING(a) 1898 ) USING(a) 1899 ) USING(a) 1900 ) USING(a) 1901 ORDER BY 1 NULLS FIRST; 1902} { 1903 11 11 - - - - 1904 12 12 12 - - - 1905 15 15 15 15 15 15 1906 17 17 - 17 - 17 1907 1908} 1909do_execsql_test joinC-116 { 1910 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 1911 FROM t1 LEFT JOIN ( 1912 t2 FULL JOIN ( 1913 t3 INNER JOIN ( 1914 t4 FULL JOIN t5 USING(a) 1915 ) USING(a) 1916 ) USING(a) 1917 ) USING(a) 1918 ORDER BY 1 NULLS FIRST; 1919} { 1920 11 11 - 11 11 - 1921 12 12 12 - - - 1922 15 15 15 15 15 15 1923 17 17 - 17 - 17 1924 1925} 1926do_execsql_test joinC-117 { 1927 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 1928 FROM t1 LEFT JOIN ( 1929 t2 FULL JOIN ( 1930 t3 LEFT JOIN ( 1931 t4 INNER JOIN t5 USING(a) 1932 ) USING(a) 1933 ) USING(a) 1934 ) USING(a) 1935 ORDER BY 1 NULLS FIRST; 1936} { 1937 11 11 - 11 - - 1938 12 12 12 12 - - 1939 15 15 15 15 15 15 1940 17 17 - 17 - - 1941 1942} 1943do_execsql_test joinC-118 { 1944 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 1945 FROM t1 LEFT JOIN ( 1946 t2 FULL JOIN ( 1947 t3 LEFT JOIN ( 1948 t4 LEFT JOIN t5 USING(a) 1949 ) USING(a) 1950 ) USING(a) 1951 ) USING(a) 1952 ORDER BY 1 NULLS FIRST; 1953} { 1954 11 11 - 11 11 - 1955 12 12 12 12 - - 1956 15 15 15 15 15 15 1957 17 17 - 17 - - 1958 1959} 1960do_execsql_test joinC-119 { 1961 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 1962 FROM t1 LEFT JOIN ( 1963 t2 FULL JOIN ( 1964 t3 LEFT JOIN ( 1965 t4 RIGHT JOIN t5 USING(a) 1966 ) USING(a) 1967 ) USING(a) 1968 ) USING(a) 1969 ORDER BY 1 NULLS FIRST; 1970} { 1971 11 11 - 11 - - 1972 12 12 12 12 - - 1973 15 15 15 15 15 15 1974 17 17 - 17 - 17 1975 1976} 1977do_execsql_test joinC-120 { 1978 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 1979 FROM t1 LEFT JOIN ( 1980 t2 FULL JOIN ( 1981 t3 LEFT JOIN ( 1982 t4 FULL JOIN t5 USING(a) 1983 ) USING(a) 1984 ) USING(a) 1985 ) USING(a) 1986 ORDER BY 1 NULLS FIRST; 1987} { 1988 11 11 - 11 11 - 1989 12 12 12 12 - - 1990 15 15 15 15 15 15 1991 17 17 - 17 - 17 1992 1993} 1994do_execsql_test joinC-121 { 1995 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 1996 FROM t1 LEFT JOIN ( 1997 t2 FULL JOIN ( 1998 t3 RIGHT JOIN ( 1999 t4 INNER JOIN t5 USING(a) 2000 ) USING(a) 2001 ) USING(a) 2002 ) USING(a) 2003 ORDER BY 1 NULLS FIRST; 2004} { 2005 11 11 - - - - 2006 12 12 12 - - - 2007 15 15 15 15 15 15 2008 17 17 - - - - 2009 2010} 2011do_execsql_test joinC-122 { 2012 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 2013 FROM t1 LEFT JOIN ( 2014 t2 FULL JOIN ( 2015 t3 RIGHT JOIN ( 2016 t4 LEFT JOIN t5 USING(a) 2017 ) USING(a) 2018 ) USING(a) 2019 ) USING(a) 2020 ORDER BY 1 NULLS FIRST; 2021} { 2022 11 11 - 11 11 - 2023 12 12 12 - - - 2024 15 15 15 15 15 15 2025 17 17 - - - - 2026 2027} 2028do_execsql_test joinC-123 { 2029 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 2030 FROM t1 LEFT JOIN ( 2031 t2 FULL JOIN ( 2032 t3 RIGHT JOIN ( 2033 t4 RIGHT JOIN t5 USING(a) 2034 ) USING(a) 2035 ) USING(a) 2036 ) USING(a) 2037 ORDER BY 1 NULLS FIRST; 2038} { 2039 11 11 - - - - 2040 12 12 12 - - - 2041 15 15 15 15 15 15 2042 17 17 - 17 - 17 2043 2044} 2045do_execsql_test joinC-124 { 2046 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 2047 FROM t1 LEFT JOIN ( 2048 t2 FULL JOIN ( 2049 t3 RIGHT JOIN ( 2050 t4 FULL JOIN t5 USING(a) 2051 ) USING(a) 2052 ) USING(a) 2053 ) USING(a) 2054 ORDER BY 1 NULLS FIRST; 2055} { 2056 11 11 - 11 11 - 2057 12 12 12 - - - 2058 15 15 15 15 15 15 2059 17 17 - 17 - 17 2060 2061} 2062do_execsql_test joinC-125 { 2063 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 2064 FROM t1 LEFT JOIN ( 2065 t2 FULL JOIN ( 2066 t3 FULL JOIN ( 2067 t4 INNER JOIN t5 USING(a) 2068 ) USING(a) 2069 ) USING(a) 2070 ) USING(a) 2071 ORDER BY 1 NULLS FIRST; 2072} { 2073 11 11 - 11 - - 2074 12 12 12 12 - - 2075 15 15 15 15 15 15 2076 17 17 - 17 - - 2077 2078} 2079do_execsql_test joinC-126 { 2080 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 2081 FROM t1 LEFT JOIN ( 2082 t2 FULL JOIN ( 2083 t3 FULL JOIN ( 2084 t4 LEFT JOIN t5 USING(a) 2085 ) USING(a) 2086 ) USING(a) 2087 ) USING(a) 2088 ORDER BY 1 NULLS FIRST; 2089} { 2090 11 11 - 11 11 - 2091 12 12 12 12 - - 2092 15 15 15 15 15 15 2093 17 17 - 17 - - 2094 2095} 2096do_execsql_test joinC-127 { 2097 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 2098 FROM t1 LEFT JOIN ( 2099 t2 FULL JOIN ( 2100 t3 FULL JOIN ( 2101 t4 RIGHT JOIN t5 USING(a) 2102 ) USING(a) 2103 ) USING(a) 2104 ) USING(a) 2105 ORDER BY 1 NULLS FIRST; 2106} { 2107 11 11 - 11 - - 2108 12 12 12 12 - - 2109 15 15 15 15 15 15 2110 17 17 - 17 - 17 2111 2112} 2113do_execsql_test joinC-128 { 2114 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 2115 FROM t1 LEFT JOIN ( 2116 t2 FULL JOIN ( 2117 t3 FULL JOIN ( 2118 t4 FULL JOIN t5 USING(a) 2119 ) USING(a) 2120 ) USING(a) 2121 ) USING(a) 2122 ORDER BY 1 NULLS FIRST; 2123} { 2124 11 11 - 11 11 - 2125 12 12 12 12 - - 2126 15 15 15 15 15 15 2127 17 17 - 17 - 17 2128 2129} 2130do_execsql_test joinC-129 { 2131 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 2132 FROM t1 RIGHT JOIN ( 2133 t2 INNER JOIN ( 2134 t3 INNER JOIN ( 2135 t4 INNER JOIN t5 USING(a) 2136 ) USING(a) 2137 ) USING(a) 2138 ) USING(a) 2139 ORDER BY 1 NULLS FIRST; 2140} { 2141 15 15 15 15 15 15 2142 2143} 2144do_execsql_test joinC-130 { 2145 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 2146 FROM t1 RIGHT JOIN ( 2147 t2 INNER JOIN ( 2148 t3 INNER JOIN ( 2149 t4 LEFT JOIN t5 USING(a) 2150 ) USING(a) 2151 ) USING(a) 2152 ) USING(a) 2153 ORDER BY 1 NULLS FIRST; 2154} { 2155 13 - 13 13 13 - 2156 15 15 15 15 15 15 2157 2158} 2159do_execsql_test joinC-131 { 2160 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 2161 FROM t1 RIGHT JOIN ( 2162 t2 INNER JOIN ( 2163 t3 INNER JOIN ( 2164 t4 RIGHT JOIN t5 USING(a) 2165 ) USING(a) 2166 ) USING(a) 2167 ) USING(a) 2168 ORDER BY 1 NULLS FIRST; 2169} { 2170 15 15 15 15 15 15 2171 18 - 18 18 - 18 2172 2173} 2174do_execsql_test joinC-132 { 2175 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 2176 FROM t1 RIGHT JOIN ( 2177 t2 INNER JOIN ( 2178 t3 INNER JOIN ( 2179 t4 FULL JOIN t5 USING(a) 2180 ) USING(a) 2181 ) USING(a) 2182 ) USING(a) 2183 ORDER BY 1 NULLS FIRST; 2184} { 2185 13 - 13 13 13 - 2186 15 15 15 15 15 15 2187 18 - 18 18 - 18 2188 2189} 2190do_execsql_test joinC-133 { 2191 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 2192 FROM t1 RIGHT JOIN ( 2193 t2 INNER JOIN ( 2194 t3 LEFT JOIN ( 2195 t4 INNER JOIN t5 USING(a) 2196 ) USING(a) 2197 ) USING(a) 2198 ) USING(a) 2199 ORDER BY 1 NULLS FIRST; 2200} { 2201 12 12 12 12 - - 2202 13 - 13 13 - - 2203 15 15 15 15 15 15 2204 18 - 18 18 - - 2205 2206} 2207do_execsql_test joinC-134 { 2208 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 2209 FROM t1 RIGHT JOIN ( 2210 t2 INNER JOIN ( 2211 t3 LEFT JOIN ( 2212 t4 LEFT JOIN t5 USING(a) 2213 ) USING(a) 2214 ) USING(a) 2215 ) USING(a) 2216 ORDER BY 1 NULLS FIRST; 2217} { 2218 12 12 12 12 - - 2219 13 - 13 13 13 - 2220 15 15 15 15 15 15 2221 18 - 18 18 - - 2222 2223} 2224do_execsql_test joinC-135 { 2225 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 2226 FROM t1 RIGHT JOIN ( 2227 t2 INNER JOIN ( 2228 t3 LEFT JOIN ( 2229 t4 RIGHT JOIN t5 USING(a) 2230 ) USING(a) 2231 ) USING(a) 2232 ) USING(a) 2233 ORDER BY 1 NULLS FIRST; 2234} { 2235 12 12 12 12 - - 2236 13 - 13 13 - - 2237 15 15 15 15 15 15 2238 18 - 18 18 - 18 2239 2240} 2241do_execsql_test joinC-136 { 2242 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 2243 FROM t1 RIGHT JOIN ( 2244 t2 INNER JOIN ( 2245 t3 LEFT JOIN ( 2246 t4 FULL JOIN t5 USING(a) 2247 ) USING(a) 2248 ) USING(a) 2249 ) USING(a) 2250 ORDER BY 1 NULLS FIRST; 2251} { 2252 12 12 12 12 - - 2253 13 - 13 13 13 - 2254 15 15 15 15 15 15 2255 18 - 18 18 - 18 2256 2257} 2258do_execsql_test joinC-137 { 2259 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 2260 FROM t1 RIGHT JOIN ( 2261 t2 INNER JOIN ( 2262 t3 RIGHT JOIN ( 2263 t4 INNER JOIN t5 USING(a) 2264 ) USING(a) 2265 ) USING(a) 2266 ) USING(a) 2267 ORDER BY 1 NULLS FIRST; 2268} { 2269 15 15 15 15 15 15 2270 2271} 2272do_execsql_test joinC-138 { 2273 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 2274 FROM t1 RIGHT JOIN ( 2275 t2 INNER JOIN ( 2276 t3 RIGHT JOIN ( 2277 t4 LEFT JOIN t5 USING(a) 2278 ) USING(a) 2279 ) USING(a) 2280 ) USING(a) 2281 ORDER BY 1 NULLS FIRST; 2282} { 2283 13 - 13 13 13 - 2284 15 15 15 15 15 15 2285 2286} 2287do_execsql_test joinC-139 { 2288 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 2289 FROM t1 RIGHT JOIN ( 2290 t2 INNER JOIN ( 2291 t3 RIGHT JOIN ( 2292 t4 RIGHT JOIN t5 USING(a) 2293 ) USING(a) 2294 ) USING(a) 2295 ) USING(a) 2296 ORDER BY 1 NULLS FIRST; 2297} { 2298 15 15 15 15 15 15 2299 18 - 18 18 - 18 2300 2301} 2302do_execsql_test joinC-140 { 2303 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 2304 FROM t1 RIGHT JOIN ( 2305 t2 INNER JOIN ( 2306 t3 RIGHT JOIN ( 2307 t4 FULL JOIN t5 USING(a) 2308 ) USING(a) 2309 ) USING(a) 2310 ) USING(a) 2311 ORDER BY 1 NULLS FIRST; 2312} { 2313 13 - 13 13 13 - 2314 15 15 15 15 15 15 2315 18 - 18 18 - 18 2316 2317} 2318do_execsql_test joinC-141 { 2319 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 2320 FROM t1 RIGHT JOIN ( 2321 t2 INNER JOIN ( 2322 t3 FULL JOIN ( 2323 t4 INNER JOIN t5 USING(a) 2324 ) USING(a) 2325 ) USING(a) 2326 ) USING(a) 2327 ORDER BY 1 NULLS FIRST; 2328} { 2329 12 12 12 12 - - 2330 13 - 13 13 - - 2331 15 15 15 15 15 15 2332 18 - 18 18 - - 2333 2334} 2335do_execsql_test joinC-142 { 2336 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 2337 FROM t1 RIGHT JOIN ( 2338 t2 INNER JOIN ( 2339 t3 FULL JOIN ( 2340 t4 LEFT JOIN t5 USING(a) 2341 ) USING(a) 2342 ) USING(a) 2343 ) USING(a) 2344 ORDER BY 1 NULLS FIRST; 2345} { 2346 12 12 12 12 - - 2347 13 - 13 13 13 - 2348 15 15 15 15 15 15 2349 18 - 18 18 - - 2350 2351} 2352do_execsql_test joinC-143 { 2353 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 2354 FROM t1 RIGHT JOIN ( 2355 t2 INNER JOIN ( 2356 t3 FULL JOIN ( 2357 t4 RIGHT JOIN t5 USING(a) 2358 ) USING(a) 2359 ) USING(a) 2360 ) USING(a) 2361 ORDER BY 1 NULLS FIRST; 2362} { 2363 12 12 12 12 - - 2364 13 - 13 13 - - 2365 15 15 15 15 15 15 2366 18 - 18 18 - 18 2367 2368} 2369do_execsql_test joinC-144 { 2370 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 2371 FROM t1 RIGHT JOIN ( 2372 t2 INNER JOIN ( 2373 t3 FULL JOIN ( 2374 t4 FULL JOIN t5 USING(a) 2375 ) USING(a) 2376 ) USING(a) 2377 ) USING(a) 2378 ORDER BY 1 NULLS FIRST; 2379} { 2380 12 12 12 12 - - 2381 13 - 13 13 13 - 2382 15 15 15 15 15 15 2383 18 - 18 18 - 18 2384 2385} 2386do_execsql_test joinC-145 { 2387 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 2388 FROM t1 RIGHT JOIN ( 2389 t2 LEFT JOIN ( 2390 t3 INNER JOIN ( 2391 t4 INNER JOIN t5 USING(a) 2392 ) USING(a) 2393 ) USING(a) 2394 ) USING(a) 2395 ORDER BY 1 NULLS FIRST; 2396} { 2397 - - - - - - 2398 12 12 12 - - - 2399 13 - 13 - - - 2400 15 15 15 15 15 15 2401 18 - 18 - - - 2402 2403} 2404do_execsql_test joinC-146 { 2405 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 2406 FROM t1 RIGHT JOIN ( 2407 t2 LEFT JOIN ( 2408 t3 INNER JOIN ( 2409 t4 LEFT JOIN t5 USING(a) 2410 ) USING(a) 2411 ) USING(a) 2412 ) USING(a) 2413 ORDER BY 1 NULLS FIRST; 2414} { 2415 - - - - - - 2416 12 12 12 - - - 2417 13 - 13 13 13 - 2418 15 15 15 15 15 15 2419 18 - 18 - - - 2420 2421} 2422do_execsql_test joinC-147 { 2423 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 2424 FROM t1 RIGHT JOIN ( 2425 t2 LEFT JOIN ( 2426 t3 INNER JOIN ( 2427 t4 RIGHT JOIN t5 USING(a) 2428 ) USING(a) 2429 ) USING(a) 2430 ) USING(a) 2431 ORDER BY 1 NULLS FIRST; 2432} { 2433 - - - - - - 2434 12 12 12 - - - 2435 13 - 13 - - - 2436 15 15 15 15 15 15 2437 18 - 18 18 - 18 2438 2439} 2440do_execsql_test joinC-148 { 2441 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 2442 FROM t1 RIGHT JOIN ( 2443 t2 LEFT JOIN ( 2444 t3 INNER JOIN ( 2445 t4 FULL JOIN t5 USING(a) 2446 ) USING(a) 2447 ) USING(a) 2448 ) USING(a) 2449 ORDER BY 1 NULLS FIRST; 2450} { 2451 - - - - - - 2452 12 12 12 - - - 2453 13 - 13 13 13 - 2454 15 15 15 15 15 15 2455 18 - 18 18 - 18 2456 2457} 2458do_execsql_test joinC-149 { 2459 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 2460 FROM t1 RIGHT JOIN ( 2461 t2 LEFT JOIN ( 2462 t3 LEFT JOIN ( 2463 t4 INNER JOIN t5 USING(a) 2464 ) USING(a) 2465 ) USING(a) 2466 ) USING(a) 2467 ORDER BY 1 NULLS FIRST; 2468} { 2469 - - - - - - 2470 12 12 12 12 - - 2471 13 - 13 13 - - 2472 15 15 15 15 15 15 2473 18 - 18 18 - - 2474 2475} 2476do_execsql_test joinC-150 { 2477 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 2478 FROM t1 RIGHT JOIN ( 2479 t2 LEFT JOIN ( 2480 t3 LEFT JOIN ( 2481 t4 LEFT JOIN t5 USING(a) 2482 ) USING(a) 2483 ) USING(a) 2484 ) USING(a) 2485 ORDER BY 1 NULLS FIRST; 2486} { 2487 - - - - - - 2488 12 12 12 12 - - 2489 13 - 13 13 13 - 2490 15 15 15 15 15 15 2491 18 - 18 18 - - 2492 2493} 2494do_execsql_test joinC-151 { 2495 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 2496 FROM t1 RIGHT JOIN ( 2497 t2 LEFT JOIN ( 2498 t3 LEFT JOIN ( 2499 t4 RIGHT JOIN t5 USING(a) 2500 ) USING(a) 2501 ) USING(a) 2502 ) USING(a) 2503 ORDER BY 1 NULLS FIRST; 2504} { 2505 - - - - - - 2506 12 12 12 12 - - 2507 13 - 13 13 - - 2508 15 15 15 15 15 15 2509 18 - 18 18 - 18 2510 2511} 2512do_execsql_test joinC-152 { 2513 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 2514 FROM t1 RIGHT JOIN ( 2515 t2 LEFT JOIN ( 2516 t3 LEFT JOIN ( 2517 t4 FULL JOIN t5 USING(a) 2518 ) USING(a) 2519 ) USING(a) 2520 ) USING(a) 2521 ORDER BY 1 NULLS FIRST; 2522} { 2523 - - - - - - 2524 12 12 12 12 - - 2525 13 - 13 13 13 - 2526 15 15 15 15 15 15 2527 18 - 18 18 - 18 2528 2529} 2530do_execsql_test joinC-153 { 2531 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 2532 FROM t1 RIGHT JOIN ( 2533 t2 LEFT JOIN ( 2534 t3 RIGHT JOIN ( 2535 t4 INNER JOIN t5 USING(a) 2536 ) USING(a) 2537 ) USING(a) 2538 ) USING(a) 2539 ORDER BY 1 NULLS FIRST; 2540} { 2541 - - - - - - 2542 12 12 12 - - - 2543 13 - 13 - - - 2544 15 15 15 15 15 15 2545 18 - 18 - - - 2546 2547} 2548do_execsql_test joinC-154 { 2549 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 2550 FROM t1 RIGHT JOIN ( 2551 t2 LEFT JOIN ( 2552 t3 RIGHT JOIN ( 2553 t4 LEFT JOIN t5 USING(a) 2554 ) USING(a) 2555 ) USING(a) 2556 ) USING(a) 2557 ORDER BY 1 NULLS FIRST; 2558} { 2559 - - - - - - 2560 12 12 12 - - - 2561 13 - 13 13 13 - 2562 15 15 15 15 15 15 2563 18 - 18 - - - 2564 2565} 2566do_execsql_test joinC-155 { 2567 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 2568 FROM t1 RIGHT JOIN ( 2569 t2 LEFT JOIN ( 2570 t3 RIGHT JOIN ( 2571 t4 RIGHT JOIN t5 USING(a) 2572 ) USING(a) 2573 ) USING(a) 2574 ) USING(a) 2575 ORDER BY 1 NULLS FIRST; 2576} { 2577 - - - - - - 2578 12 12 12 - - - 2579 13 - 13 - - - 2580 15 15 15 15 15 15 2581 18 - 18 18 - 18 2582 2583} 2584do_execsql_test joinC-156 { 2585 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 2586 FROM t1 RIGHT JOIN ( 2587 t2 LEFT JOIN ( 2588 t3 RIGHT JOIN ( 2589 t4 FULL JOIN t5 USING(a) 2590 ) USING(a) 2591 ) USING(a) 2592 ) USING(a) 2593 ORDER BY 1 NULLS FIRST; 2594} { 2595 - - - - - - 2596 12 12 12 - - - 2597 13 - 13 13 13 - 2598 15 15 15 15 15 15 2599 18 - 18 18 - 18 2600 2601} 2602do_execsql_test joinC-157 { 2603 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 2604 FROM t1 RIGHT JOIN ( 2605 t2 LEFT JOIN ( 2606 t3 FULL JOIN ( 2607 t4 INNER JOIN t5 USING(a) 2608 ) USING(a) 2609 ) USING(a) 2610 ) USING(a) 2611 ORDER BY 1 NULLS FIRST; 2612} { 2613 - - - - - - 2614 12 12 12 12 - - 2615 13 - 13 13 - - 2616 15 15 15 15 15 15 2617 18 - 18 18 - - 2618 2619} 2620do_execsql_test joinC-158 { 2621 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 2622 FROM t1 RIGHT JOIN ( 2623 t2 LEFT JOIN ( 2624 t3 FULL JOIN ( 2625 t4 LEFT JOIN t5 USING(a) 2626 ) USING(a) 2627 ) USING(a) 2628 ) USING(a) 2629 ORDER BY 1 NULLS FIRST; 2630} { 2631 - - - - - - 2632 12 12 12 12 - - 2633 13 - 13 13 13 - 2634 15 15 15 15 15 15 2635 18 - 18 18 - - 2636 2637} 2638do_execsql_test joinC-159 { 2639 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 2640 FROM t1 RIGHT JOIN ( 2641 t2 LEFT JOIN ( 2642 t3 FULL JOIN ( 2643 t4 RIGHT JOIN t5 USING(a) 2644 ) USING(a) 2645 ) USING(a) 2646 ) USING(a) 2647 ORDER BY 1 NULLS FIRST; 2648} { 2649 - - - - - - 2650 12 12 12 12 - - 2651 13 - 13 13 - - 2652 15 15 15 15 15 15 2653 18 - 18 18 - 18 2654 2655} 2656do_execsql_test joinC-160 { 2657 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 2658 FROM t1 RIGHT JOIN ( 2659 t2 LEFT JOIN ( 2660 t3 FULL JOIN ( 2661 t4 FULL JOIN t5 USING(a) 2662 ) USING(a) 2663 ) USING(a) 2664 ) USING(a) 2665 ORDER BY 1 NULLS FIRST; 2666} { 2667 - - - - - - 2668 12 12 12 12 - - 2669 13 - 13 13 13 - 2670 15 15 15 15 15 15 2671 18 - 18 18 - 18 2672 2673} 2674do_execsql_test joinC-161 { 2675 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 2676 FROM t1 RIGHT JOIN ( 2677 t2 RIGHT JOIN ( 2678 t3 INNER JOIN ( 2679 t4 INNER JOIN t5 USING(a) 2680 ) USING(a) 2681 ) USING(a) 2682 ) USING(a) 2683 ORDER BY 1 NULLS FIRST; 2684} { 2685 15 15 15 15 15 15 2686 19 - - 19 19 19 2687 2688} 2689do_execsql_test joinC-162 { 2690 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 2691 FROM t1 RIGHT JOIN ( 2692 t2 RIGHT JOIN ( 2693 t3 INNER JOIN ( 2694 t4 LEFT JOIN t5 USING(a) 2695 ) USING(a) 2696 ) USING(a) 2697 ) USING(a) 2698 ORDER BY 1 NULLS FIRST; 2699} { 2700 11 11 - 11 11 - 2701 13 - 13 13 13 - 2702 15 15 15 15 15 15 2703 19 - - 19 19 19 2704 2705} 2706do_execsql_test joinC-163 { 2707 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 2708 FROM t1 RIGHT JOIN ( 2709 t2 RIGHT JOIN ( 2710 t3 INNER JOIN ( 2711 t4 RIGHT JOIN t5 USING(a) 2712 ) USING(a) 2713 ) USING(a) 2714 ) USING(a) 2715 ORDER BY 1 NULLS FIRST; 2716} { 2717 15 15 15 15 15 15 2718 17 17 - 17 - 17 2719 18 - 18 18 - 18 2720 19 - - 19 19 19 2721 2722} 2723do_execsql_test joinC-164 { 2724 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 2725 FROM t1 RIGHT JOIN ( 2726 t2 RIGHT JOIN ( 2727 t3 INNER JOIN ( 2728 t4 FULL JOIN t5 USING(a) 2729 ) USING(a) 2730 ) USING(a) 2731 ) USING(a) 2732 ORDER BY 1 NULLS FIRST; 2733} { 2734 11 11 - 11 11 - 2735 13 - 13 13 13 - 2736 15 15 15 15 15 15 2737 17 17 - 17 - 17 2738 18 - 18 18 - 18 2739 19 - - 19 19 19 2740 2741} 2742do_execsql_test joinC-165 { 2743 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 2744 FROM t1 RIGHT JOIN ( 2745 t2 RIGHT JOIN ( 2746 t3 LEFT JOIN ( 2747 t4 INNER JOIN t5 USING(a) 2748 ) USING(a) 2749 ) USING(a) 2750 ) USING(a) 2751 ORDER BY 1 NULLS FIRST; 2752} { 2753 - - - - - - 2754 11 11 - 11 - - 2755 12 12 12 12 - - 2756 13 - 13 13 - - 2757 15 15 15 15 15 15 2758 17 17 - 17 - - 2759 18 - 18 18 - - 2760 19 - - 19 19 19 2761 2762} 2763do_execsql_test joinC-166 { 2764 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 2765 FROM t1 RIGHT JOIN ( 2766 t2 RIGHT JOIN ( 2767 t3 LEFT JOIN ( 2768 t4 LEFT JOIN t5 USING(a) 2769 ) USING(a) 2770 ) USING(a) 2771 ) USING(a) 2772 ORDER BY 1 NULLS FIRST; 2773} { 2774 - - - - - - 2775 11 11 - 11 11 - 2776 12 12 12 12 - - 2777 13 - 13 13 13 - 2778 15 15 15 15 15 15 2779 17 17 - 17 - - 2780 18 - 18 18 - - 2781 19 - - 19 19 19 2782 2783} 2784do_execsql_test joinC-167 { 2785 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 2786 FROM t1 RIGHT JOIN ( 2787 t2 RIGHT JOIN ( 2788 t3 LEFT JOIN ( 2789 t4 RIGHT JOIN t5 USING(a) 2790 ) USING(a) 2791 ) USING(a) 2792 ) USING(a) 2793 ORDER BY 1 NULLS FIRST; 2794} { 2795 - - - - - - 2796 11 11 - 11 - - 2797 12 12 12 12 - - 2798 13 - 13 13 - - 2799 15 15 15 15 15 15 2800 17 17 - 17 - 17 2801 18 - 18 18 - 18 2802 19 - - 19 19 19 2803 2804} 2805do_execsql_test joinC-168 { 2806 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 2807 FROM t1 RIGHT JOIN ( 2808 t2 RIGHT JOIN ( 2809 t3 LEFT JOIN ( 2810 t4 FULL JOIN t5 USING(a) 2811 ) USING(a) 2812 ) USING(a) 2813 ) USING(a) 2814 ORDER BY 1 NULLS FIRST; 2815} { 2816 - - - - - - 2817 11 11 - 11 11 - 2818 12 12 12 12 - - 2819 13 - 13 13 13 - 2820 15 15 15 15 15 15 2821 17 17 - 17 - 17 2822 18 - 18 18 - 18 2823 19 - - 19 19 19 2824 2825} 2826do_execsql_test joinC-169 { 2827 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 2828 FROM t1 RIGHT JOIN ( 2829 t2 RIGHT JOIN ( 2830 t3 RIGHT JOIN ( 2831 t4 INNER JOIN t5 USING(a) 2832 ) USING(a) 2833 ) USING(a) 2834 ) USING(a) 2835 ORDER BY 1 NULLS FIRST; 2836} { 2837 15 15 15 15 15 15 2838 19 - - 19 19 19 2839 2840} 2841do_execsql_test joinC-170 { 2842 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 2843 FROM t1 RIGHT JOIN ( 2844 t2 RIGHT JOIN ( 2845 t3 RIGHT JOIN ( 2846 t4 LEFT JOIN t5 USING(a) 2847 ) USING(a) 2848 ) USING(a) 2849 ) USING(a) 2850 ORDER BY 1 NULLS FIRST; 2851} { 2852 11 11 - 11 11 - 2853 13 - 13 13 13 - 2854 15 15 15 15 15 15 2855 19 - - 19 19 19 2856 2857} 2858do_execsql_test joinC-171 { 2859 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 2860 FROM t1 RIGHT JOIN ( 2861 t2 RIGHT JOIN ( 2862 t3 RIGHT JOIN ( 2863 t4 RIGHT JOIN t5 USING(a) 2864 ) USING(a) 2865 ) USING(a) 2866 ) USING(a) 2867 ORDER BY 1 NULLS FIRST; 2868} { 2869 15 15 15 15 15 15 2870 17 17 - 17 - 17 2871 18 - 18 18 - 18 2872 19 - - 19 19 19 2873 2874} 2875do_execsql_test joinC-172 { 2876 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 2877 FROM t1 RIGHT JOIN ( 2878 t2 RIGHT JOIN ( 2879 t3 RIGHT JOIN ( 2880 t4 FULL JOIN t5 USING(a) 2881 ) USING(a) 2882 ) USING(a) 2883 ) USING(a) 2884 ORDER BY 1 NULLS FIRST; 2885} { 2886 11 11 - 11 11 - 2887 13 - 13 13 13 - 2888 15 15 15 15 15 15 2889 17 17 - 17 - 17 2890 18 - 18 18 - 18 2891 19 - - 19 19 19 2892 2893} 2894do_execsql_test joinC-173 { 2895 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 2896 FROM t1 RIGHT JOIN ( 2897 t2 RIGHT JOIN ( 2898 t3 FULL JOIN ( 2899 t4 INNER JOIN t5 USING(a) 2900 ) USING(a) 2901 ) USING(a) 2902 ) USING(a) 2903 ORDER BY 1 NULLS FIRST; 2904} { 2905 - - - - - - 2906 11 11 - 11 - - 2907 12 12 12 12 - - 2908 13 - 13 13 - - 2909 15 15 15 15 15 15 2910 17 17 - 17 - - 2911 18 - 18 18 - - 2912 19 - - 19 19 19 2913 2914} 2915do_execsql_test joinC-174 { 2916 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 2917 FROM t1 RIGHT JOIN ( 2918 t2 RIGHT JOIN ( 2919 t3 FULL JOIN ( 2920 t4 LEFT JOIN t5 USING(a) 2921 ) USING(a) 2922 ) USING(a) 2923 ) USING(a) 2924 ORDER BY 1 NULLS FIRST; 2925} { 2926 - - - - - - 2927 11 11 - 11 11 - 2928 12 12 12 12 - - 2929 13 - 13 13 13 - 2930 15 15 15 15 15 15 2931 17 17 - 17 - - 2932 18 - 18 18 - - 2933 19 - - 19 19 19 2934 2935} 2936do_execsql_test joinC-175 { 2937 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 2938 FROM t1 RIGHT JOIN ( 2939 t2 RIGHT JOIN ( 2940 t3 FULL JOIN ( 2941 t4 RIGHT JOIN t5 USING(a) 2942 ) USING(a) 2943 ) USING(a) 2944 ) USING(a) 2945 ORDER BY 1 NULLS FIRST; 2946} { 2947 - - - - - - 2948 11 11 - 11 - - 2949 12 12 12 12 - - 2950 13 - 13 13 - - 2951 15 15 15 15 15 15 2952 17 17 - 17 - 17 2953 18 - 18 18 - 18 2954 19 - - 19 19 19 2955 2956} 2957do_execsql_test joinC-176 { 2958 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 2959 FROM t1 RIGHT JOIN ( 2960 t2 RIGHT JOIN ( 2961 t3 FULL JOIN ( 2962 t4 FULL JOIN t5 USING(a) 2963 ) USING(a) 2964 ) USING(a) 2965 ) USING(a) 2966 ORDER BY 1 NULLS FIRST; 2967} { 2968 - - - - - - 2969 11 11 - 11 11 - 2970 12 12 12 12 - - 2971 13 - 13 13 13 - 2972 15 15 15 15 15 15 2973 17 17 - 17 - 17 2974 18 - 18 18 - 18 2975 19 - - 19 19 19 2976 2977} 2978do_execsql_test joinC-177 { 2979 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 2980 FROM t1 RIGHT JOIN ( 2981 t2 FULL JOIN ( 2982 t3 INNER JOIN ( 2983 t4 INNER JOIN t5 USING(a) 2984 ) USING(a) 2985 ) USING(a) 2986 ) USING(a) 2987 ORDER BY 1 NULLS FIRST; 2988} { 2989 - - - - - - 2990 12 12 12 - - - 2991 13 - 13 - - - 2992 15 15 15 15 15 15 2993 18 - 18 - - - 2994 19 - - 19 19 19 2995 2996} 2997do_execsql_test joinC-178 { 2998 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 2999 FROM t1 RIGHT JOIN ( 3000 t2 FULL JOIN ( 3001 t3 INNER JOIN ( 3002 t4 LEFT JOIN t5 USING(a) 3003 ) USING(a) 3004 ) USING(a) 3005 ) USING(a) 3006 ORDER BY 1 NULLS FIRST; 3007} { 3008 - - - - - - 3009 11 11 - 11 11 - 3010 12 12 12 - - - 3011 13 - 13 13 13 - 3012 15 15 15 15 15 15 3013 18 - 18 - - - 3014 19 - - 19 19 19 3015 3016} 3017do_execsql_test joinC-179 { 3018 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 3019 FROM t1 RIGHT JOIN ( 3020 t2 FULL JOIN ( 3021 t3 INNER JOIN ( 3022 t4 RIGHT JOIN t5 USING(a) 3023 ) USING(a) 3024 ) USING(a) 3025 ) USING(a) 3026 ORDER BY 1 NULLS FIRST; 3027} { 3028 - - - - - - 3029 12 12 12 - - - 3030 13 - 13 - - - 3031 15 15 15 15 15 15 3032 17 17 - 17 - 17 3033 18 - 18 18 - 18 3034 19 - - 19 19 19 3035 3036} 3037do_execsql_test joinC-180 { 3038 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 3039 FROM t1 RIGHT JOIN ( 3040 t2 FULL JOIN ( 3041 t3 INNER JOIN ( 3042 t4 FULL JOIN t5 USING(a) 3043 ) USING(a) 3044 ) USING(a) 3045 ) USING(a) 3046 ORDER BY 1 NULLS FIRST; 3047} { 3048 - - - - - - 3049 11 11 - 11 11 - 3050 12 12 12 - - - 3051 13 - 13 13 13 - 3052 15 15 15 15 15 15 3053 17 17 - 17 - 17 3054 18 - 18 18 - 18 3055 19 - - 19 19 19 3056 3057} 3058do_execsql_test joinC-181 { 3059 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 3060 FROM t1 RIGHT JOIN ( 3061 t2 FULL JOIN ( 3062 t3 LEFT JOIN ( 3063 t4 INNER JOIN t5 USING(a) 3064 ) USING(a) 3065 ) USING(a) 3066 ) USING(a) 3067 ORDER BY 1 NULLS FIRST; 3068} { 3069 - - - - - - 3070 - - - - - - 3071 11 11 - 11 - - 3072 12 12 12 12 - - 3073 13 - 13 13 - - 3074 15 15 15 15 15 15 3075 17 17 - 17 - - 3076 18 - 18 18 - - 3077 19 - - 19 19 19 3078 3079} 3080do_execsql_test joinC-182 { 3081 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 3082 FROM t1 RIGHT JOIN ( 3083 t2 FULL JOIN ( 3084 t3 LEFT JOIN ( 3085 t4 LEFT JOIN t5 USING(a) 3086 ) USING(a) 3087 ) USING(a) 3088 ) USING(a) 3089 ORDER BY 1 NULLS FIRST; 3090} { 3091 - - - - - - 3092 - - - - - - 3093 11 11 - 11 11 - 3094 12 12 12 12 - - 3095 13 - 13 13 13 - 3096 15 15 15 15 15 15 3097 17 17 - 17 - - 3098 18 - 18 18 - - 3099 19 - - 19 19 19 3100 3101} 3102do_execsql_test joinC-183 { 3103 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 3104 FROM t1 RIGHT JOIN ( 3105 t2 FULL JOIN ( 3106 t3 LEFT JOIN ( 3107 t4 RIGHT JOIN t5 USING(a) 3108 ) USING(a) 3109 ) USING(a) 3110 ) USING(a) 3111 ORDER BY 1 NULLS FIRST; 3112} { 3113 - - - - - - 3114 - - - - - - 3115 11 11 - 11 - - 3116 12 12 12 12 - - 3117 13 - 13 13 - - 3118 15 15 15 15 15 15 3119 17 17 - 17 - 17 3120 18 - 18 18 - 18 3121 19 - - 19 19 19 3122 3123} 3124do_execsql_test joinC-184 { 3125 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 3126 FROM t1 RIGHT JOIN ( 3127 t2 FULL JOIN ( 3128 t3 LEFT JOIN ( 3129 t4 FULL JOIN t5 USING(a) 3130 ) USING(a) 3131 ) USING(a) 3132 ) USING(a) 3133 ORDER BY 1 NULLS FIRST; 3134} { 3135 - - - - - - 3136 - - - - - - 3137 11 11 - 11 11 - 3138 12 12 12 12 - - 3139 13 - 13 13 13 - 3140 15 15 15 15 15 15 3141 17 17 - 17 - 17 3142 18 - 18 18 - 18 3143 19 - - 19 19 19 3144 3145} 3146do_execsql_test joinC-185 { 3147 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 3148 FROM t1 RIGHT JOIN ( 3149 t2 FULL JOIN ( 3150 t3 RIGHT JOIN ( 3151 t4 INNER JOIN t5 USING(a) 3152 ) USING(a) 3153 ) USING(a) 3154 ) USING(a) 3155 ORDER BY 1 NULLS FIRST; 3156} { 3157 - - - - - - 3158 12 12 12 - - - 3159 13 - 13 - - - 3160 15 15 15 15 15 15 3161 18 - 18 - - - 3162 19 - - 19 19 19 3163 3164} 3165do_execsql_test joinC-186 { 3166 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 3167 FROM t1 RIGHT JOIN ( 3168 t2 FULL JOIN ( 3169 t3 RIGHT JOIN ( 3170 t4 LEFT JOIN t5 USING(a) 3171 ) USING(a) 3172 ) USING(a) 3173 ) USING(a) 3174 ORDER BY 1 NULLS FIRST; 3175} { 3176 - - - - - - 3177 11 11 - 11 11 - 3178 12 12 12 - - - 3179 13 - 13 13 13 - 3180 15 15 15 15 15 15 3181 18 - 18 - - - 3182 19 - - 19 19 19 3183 3184} 3185do_execsql_test joinC-187 { 3186 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 3187 FROM t1 RIGHT JOIN ( 3188 t2 FULL JOIN ( 3189 t3 RIGHT JOIN ( 3190 t4 RIGHT JOIN t5 USING(a) 3191 ) USING(a) 3192 ) USING(a) 3193 ) USING(a) 3194 ORDER BY 1 NULLS FIRST; 3195} { 3196 - - - - - - 3197 12 12 12 - - - 3198 13 - 13 - - - 3199 15 15 15 15 15 15 3200 17 17 - 17 - 17 3201 18 - 18 18 - 18 3202 19 - - 19 19 19 3203 3204} 3205do_execsql_test joinC-188 { 3206 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 3207 FROM t1 RIGHT JOIN ( 3208 t2 FULL JOIN ( 3209 t3 RIGHT JOIN ( 3210 t4 FULL JOIN t5 USING(a) 3211 ) USING(a) 3212 ) USING(a) 3213 ) USING(a) 3214 ORDER BY 1 NULLS FIRST; 3215} { 3216 - - - - - - 3217 11 11 - 11 11 - 3218 12 12 12 - - - 3219 13 - 13 13 13 - 3220 15 15 15 15 15 15 3221 17 17 - 17 - 17 3222 18 - 18 18 - 18 3223 19 - - 19 19 19 3224 3225} 3226do_execsql_test joinC-189 { 3227 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 3228 FROM t1 RIGHT JOIN ( 3229 t2 FULL JOIN ( 3230 t3 FULL JOIN ( 3231 t4 INNER JOIN t5 USING(a) 3232 ) USING(a) 3233 ) USING(a) 3234 ) USING(a) 3235 ORDER BY 1 NULLS FIRST; 3236} { 3237 - - - - - - 3238 - - - - - - 3239 11 11 - 11 - - 3240 12 12 12 12 - - 3241 13 - 13 13 - - 3242 15 15 15 15 15 15 3243 17 17 - 17 - - 3244 18 - 18 18 - - 3245 19 - - 19 19 19 3246 3247} 3248do_execsql_test joinC-190 { 3249 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 3250 FROM t1 RIGHT JOIN ( 3251 t2 FULL JOIN ( 3252 t3 FULL JOIN ( 3253 t4 LEFT JOIN t5 USING(a) 3254 ) USING(a) 3255 ) USING(a) 3256 ) USING(a) 3257 ORDER BY 1 NULLS FIRST; 3258} { 3259 - - - - - - 3260 - - - - - - 3261 11 11 - 11 11 - 3262 12 12 12 12 - - 3263 13 - 13 13 13 - 3264 15 15 15 15 15 15 3265 17 17 - 17 - - 3266 18 - 18 18 - - 3267 19 - - 19 19 19 3268 3269} 3270do_execsql_test joinC-191 { 3271 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 3272 FROM t1 RIGHT JOIN ( 3273 t2 FULL JOIN ( 3274 t3 FULL JOIN ( 3275 t4 RIGHT JOIN t5 USING(a) 3276 ) USING(a) 3277 ) USING(a) 3278 ) USING(a) 3279 ORDER BY 1 NULLS FIRST; 3280} { 3281 - - - - - - 3282 - - - - - - 3283 11 11 - 11 - - 3284 12 12 12 12 - - 3285 13 - 13 13 - - 3286 15 15 15 15 15 15 3287 17 17 - 17 - 17 3288 18 - 18 18 - 18 3289 19 - - 19 19 19 3290 3291} 3292do_execsql_test joinC-192 { 3293 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 3294 FROM t1 RIGHT JOIN ( 3295 t2 FULL JOIN ( 3296 t3 FULL JOIN ( 3297 t4 FULL JOIN t5 USING(a) 3298 ) USING(a) 3299 ) USING(a) 3300 ) USING(a) 3301 ORDER BY 1 NULLS FIRST; 3302} { 3303 - - - - - - 3304 - - - - - - 3305 11 11 - 11 11 - 3306 12 12 12 12 - - 3307 13 - 13 13 13 - 3308 15 15 15 15 15 15 3309 17 17 - 17 - 17 3310 18 - 18 18 - 18 3311 19 - - 19 19 19 3312 3313} 3314do_execsql_test joinC-193 { 3315 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 3316 FROM t1 FULL JOIN ( 3317 t2 INNER JOIN ( 3318 t3 INNER JOIN ( 3319 t4 INNER JOIN t5 USING(a) 3320 ) USING(a) 3321 ) USING(a) 3322 ) USING(a) 3323 ORDER BY 1 NULLS FIRST; 3324} { 3325 11 11 - - - - 3326 12 12 - - - - 3327 15 15 15 15 15 15 3328 17 17 - - - - 3329 3330} 3331do_execsql_test joinC-194 { 3332 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 3333 FROM t1 FULL JOIN ( 3334 t2 INNER JOIN ( 3335 t3 INNER JOIN ( 3336 t4 LEFT JOIN t5 USING(a) 3337 ) USING(a) 3338 ) USING(a) 3339 ) USING(a) 3340 ORDER BY 1 NULLS FIRST; 3341} { 3342 11 11 - - - - 3343 12 12 - - - - 3344 13 - 13 13 13 - 3345 15 15 15 15 15 15 3346 17 17 - - - - 3347 3348} 3349do_execsql_test joinC-195 { 3350 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 3351 FROM t1 FULL JOIN ( 3352 t2 INNER JOIN ( 3353 t3 INNER JOIN ( 3354 t4 RIGHT JOIN t5 USING(a) 3355 ) USING(a) 3356 ) USING(a) 3357 ) USING(a) 3358 ORDER BY 1 NULLS FIRST; 3359} { 3360 11 11 - - - - 3361 12 12 - - - - 3362 15 15 15 15 15 15 3363 17 17 - - - - 3364 18 - 18 18 - 18 3365 3366} 3367do_execsql_test joinC-196 { 3368 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 3369 FROM t1 FULL JOIN ( 3370 t2 INNER JOIN ( 3371 t3 INNER JOIN ( 3372 t4 FULL JOIN t5 USING(a) 3373 ) USING(a) 3374 ) USING(a) 3375 ) USING(a) 3376 ORDER BY 1 NULLS FIRST; 3377} { 3378 11 11 - - - - 3379 12 12 - - - - 3380 13 - 13 13 13 - 3381 15 15 15 15 15 15 3382 17 17 - - - - 3383 18 - 18 18 - 18 3384 3385} 3386do_execsql_test joinC-197 { 3387 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 3388 FROM t1 FULL JOIN ( 3389 t2 INNER JOIN ( 3390 t3 LEFT JOIN ( 3391 t4 INNER JOIN t5 USING(a) 3392 ) USING(a) 3393 ) USING(a) 3394 ) USING(a) 3395 ORDER BY 1 NULLS FIRST; 3396} { 3397 11 11 - - - - 3398 12 12 12 12 - - 3399 13 - 13 13 - - 3400 15 15 15 15 15 15 3401 17 17 - - - - 3402 18 - 18 18 - - 3403 3404} 3405do_execsql_test joinC-198 { 3406 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 3407 FROM t1 FULL JOIN ( 3408 t2 INNER JOIN ( 3409 t3 LEFT JOIN ( 3410 t4 LEFT JOIN t5 USING(a) 3411 ) USING(a) 3412 ) USING(a) 3413 ) USING(a) 3414 ORDER BY 1 NULLS FIRST; 3415} { 3416 11 11 - - - - 3417 12 12 12 12 - - 3418 13 - 13 13 13 - 3419 15 15 15 15 15 15 3420 17 17 - - - - 3421 18 - 18 18 - - 3422 3423} 3424do_execsql_test joinC-199 { 3425 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 3426 FROM t1 FULL JOIN ( 3427 t2 INNER JOIN ( 3428 t3 LEFT JOIN ( 3429 t4 RIGHT JOIN t5 USING(a) 3430 ) USING(a) 3431 ) USING(a) 3432 ) USING(a) 3433 ORDER BY 1 NULLS FIRST; 3434} { 3435 11 11 - - - - 3436 12 12 12 12 - - 3437 13 - 13 13 - - 3438 15 15 15 15 15 15 3439 17 17 - - - - 3440 18 - 18 18 - 18 3441 3442} 3443do_execsql_test joinC-200 { 3444 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 3445 FROM t1 FULL JOIN ( 3446 t2 INNER JOIN ( 3447 t3 LEFT JOIN ( 3448 t4 FULL JOIN t5 USING(a) 3449 ) USING(a) 3450 ) USING(a) 3451 ) USING(a) 3452 ORDER BY 1 NULLS FIRST; 3453} { 3454 11 11 - - - - 3455 12 12 12 12 - - 3456 13 - 13 13 13 - 3457 15 15 15 15 15 15 3458 17 17 - - - - 3459 18 - 18 18 - 18 3460 3461} 3462do_execsql_test joinC-201 { 3463 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 3464 FROM t1 FULL JOIN ( 3465 t2 INNER JOIN ( 3466 t3 RIGHT JOIN ( 3467 t4 INNER JOIN t5 USING(a) 3468 ) USING(a) 3469 ) USING(a) 3470 ) USING(a) 3471 ORDER BY 1 NULLS FIRST; 3472} { 3473 11 11 - - - - 3474 12 12 - - - - 3475 15 15 15 15 15 15 3476 17 17 - - - - 3477 3478} 3479do_execsql_test joinC-202 { 3480 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 3481 FROM t1 FULL JOIN ( 3482 t2 INNER JOIN ( 3483 t3 RIGHT JOIN ( 3484 t4 LEFT JOIN t5 USING(a) 3485 ) USING(a) 3486 ) USING(a) 3487 ) USING(a) 3488 ORDER BY 1 NULLS FIRST; 3489} { 3490 11 11 - - - - 3491 12 12 - - - - 3492 13 - 13 13 13 - 3493 15 15 15 15 15 15 3494 17 17 - - - - 3495 3496} 3497do_execsql_test joinC-203 { 3498 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 3499 FROM t1 FULL JOIN ( 3500 t2 INNER JOIN ( 3501 t3 RIGHT JOIN ( 3502 t4 RIGHT JOIN t5 USING(a) 3503 ) USING(a) 3504 ) USING(a) 3505 ) USING(a) 3506 ORDER BY 1 NULLS FIRST; 3507} { 3508 11 11 - - - - 3509 12 12 - - - - 3510 15 15 15 15 15 15 3511 17 17 - - - - 3512 18 - 18 18 - 18 3513 3514} 3515do_execsql_test joinC-204 { 3516 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 3517 FROM t1 FULL JOIN ( 3518 t2 INNER JOIN ( 3519 t3 RIGHT JOIN ( 3520 t4 FULL JOIN t5 USING(a) 3521 ) USING(a) 3522 ) USING(a) 3523 ) USING(a) 3524 ORDER BY 1 NULLS FIRST; 3525} { 3526 11 11 - - - - 3527 12 12 - - - - 3528 13 - 13 13 13 - 3529 15 15 15 15 15 15 3530 17 17 - - - - 3531 18 - 18 18 - 18 3532 3533} 3534do_execsql_test joinC-205 { 3535 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 3536 FROM t1 FULL JOIN ( 3537 t2 INNER JOIN ( 3538 t3 FULL JOIN ( 3539 t4 INNER JOIN t5 USING(a) 3540 ) USING(a) 3541 ) USING(a) 3542 ) USING(a) 3543 ORDER BY 1 NULLS FIRST; 3544} { 3545 11 11 - - - - 3546 12 12 12 12 - - 3547 13 - 13 13 - - 3548 15 15 15 15 15 15 3549 17 17 - - - - 3550 18 - 18 18 - - 3551 3552} 3553do_execsql_test joinC-206 { 3554 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 3555 FROM t1 FULL JOIN ( 3556 t2 INNER JOIN ( 3557 t3 FULL JOIN ( 3558 t4 LEFT JOIN t5 USING(a) 3559 ) USING(a) 3560 ) USING(a) 3561 ) USING(a) 3562 ORDER BY 1 NULLS FIRST; 3563} { 3564 11 11 - - - - 3565 12 12 12 12 - - 3566 13 - 13 13 13 - 3567 15 15 15 15 15 15 3568 17 17 - - - - 3569 18 - 18 18 - - 3570 3571} 3572do_execsql_test joinC-207 { 3573 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 3574 FROM t1 FULL JOIN ( 3575 t2 INNER JOIN ( 3576 t3 FULL JOIN ( 3577 t4 RIGHT JOIN t5 USING(a) 3578 ) USING(a) 3579 ) USING(a) 3580 ) USING(a) 3581 ORDER BY 1 NULLS FIRST; 3582} { 3583 11 11 - - - - 3584 12 12 12 12 - - 3585 13 - 13 13 - - 3586 15 15 15 15 15 15 3587 17 17 - - - - 3588 18 - 18 18 - 18 3589 3590} 3591do_execsql_test joinC-208 { 3592 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 3593 FROM t1 FULL JOIN ( 3594 t2 INNER JOIN ( 3595 t3 FULL JOIN ( 3596 t4 FULL JOIN t5 USING(a) 3597 ) USING(a) 3598 ) USING(a) 3599 ) USING(a) 3600 ORDER BY 1 NULLS FIRST; 3601} { 3602 11 11 - - - - 3603 12 12 12 12 - - 3604 13 - 13 13 13 - 3605 15 15 15 15 15 15 3606 17 17 - - - - 3607 18 - 18 18 - 18 3608 3609} 3610do_execsql_test joinC-209 { 3611 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 3612 FROM t1 FULL JOIN ( 3613 t2 LEFT JOIN ( 3614 t3 INNER JOIN ( 3615 t4 INNER JOIN t5 USING(a) 3616 ) USING(a) 3617 ) USING(a) 3618 ) USING(a) 3619 ORDER BY 1 NULLS FIRST; 3620} { 3621 - - - - - - 3622 11 11 - - - - 3623 12 12 12 - - - 3624 13 - 13 - - - 3625 15 15 15 15 15 15 3626 17 17 - - - - 3627 18 - 18 - - - 3628 3629} 3630do_execsql_test joinC-210 { 3631 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 3632 FROM t1 FULL JOIN ( 3633 t2 LEFT JOIN ( 3634 t3 INNER JOIN ( 3635 t4 LEFT JOIN t5 USING(a) 3636 ) USING(a) 3637 ) USING(a) 3638 ) USING(a) 3639 ORDER BY 1 NULLS FIRST; 3640} { 3641 - - - - - - 3642 11 11 - - - - 3643 12 12 12 - - - 3644 13 - 13 13 13 - 3645 15 15 15 15 15 15 3646 17 17 - - - - 3647 18 - 18 - - - 3648 3649} 3650do_execsql_test joinC-211 { 3651 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 3652 FROM t1 FULL JOIN ( 3653 t2 LEFT JOIN ( 3654 t3 INNER JOIN ( 3655 t4 RIGHT JOIN t5 USING(a) 3656 ) USING(a) 3657 ) USING(a) 3658 ) USING(a) 3659 ORDER BY 1 NULLS FIRST; 3660} { 3661 - - - - - - 3662 11 11 - - - - 3663 12 12 12 - - - 3664 13 - 13 - - - 3665 15 15 15 15 15 15 3666 17 17 - - - - 3667 18 - 18 18 - 18 3668 3669} 3670do_execsql_test joinC-212 { 3671 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 3672 FROM t1 FULL JOIN ( 3673 t2 LEFT JOIN ( 3674 t3 INNER JOIN ( 3675 t4 FULL JOIN t5 USING(a) 3676 ) USING(a) 3677 ) USING(a) 3678 ) USING(a) 3679 ORDER BY 1 NULLS FIRST; 3680} { 3681 - - - - - - 3682 11 11 - - - - 3683 12 12 12 - - - 3684 13 - 13 13 13 - 3685 15 15 15 15 15 15 3686 17 17 - - - - 3687 18 - 18 18 - 18 3688 3689} 3690do_execsql_test joinC-213 { 3691 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 3692 FROM t1 FULL JOIN ( 3693 t2 LEFT JOIN ( 3694 t3 LEFT JOIN ( 3695 t4 INNER JOIN t5 USING(a) 3696 ) USING(a) 3697 ) USING(a) 3698 ) USING(a) 3699 ORDER BY 1 NULLS FIRST; 3700} { 3701 - - - - - - 3702 11 11 - - - - 3703 12 12 12 12 - - 3704 13 - 13 13 - - 3705 15 15 15 15 15 15 3706 17 17 - - - - 3707 18 - 18 18 - - 3708 3709} 3710do_execsql_test joinC-214 { 3711 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 3712 FROM t1 FULL JOIN ( 3713 t2 LEFT JOIN ( 3714 t3 LEFT JOIN ( 3715 t4 LEFT JOIN t5 USING(a) 3716 ) USING(a) 3717 ) USING(a) 3718 ) USING(a) 3719 ORDER BY 1 NULLS FIRST; 3720} { 3721 - - - - - - 3722 11 11 - - - - 3723 12 12 12 12 - - 3724 13 - 13 13 13 - 3725 15 15 15 15 15 15 3726 17 17 - - - - 3727 18 - 18 18 - - 3728 3729} 3730do_execsql_test joinC-215 { 3731 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 3732 FROM t1 FULL JOIN ( 3733 t2 LEFT JOIN ( 3734 t3 LEFT JOIN ( 3735 t4 RIGHT JOIN t5 USING(a) 3736 ) USING(a) 3737 ) USING(a) 3738 ) USING(a) 3739 ORDER BY 1 NULLS FIRST; 3740} { 3741 - - - - - - 3742 11 11 - - - - 3743 12 12 12 12 - - 3744 13 - 13 13 - - 3745 15 15 15 15 15 15 3746 17 17 - - - - 3747 18 - 18 18 - 18 3748 3749} 3750do_execsql_test joinC-216 { 3751 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 3752 FROM t1 FULL JOIN ( 3753 t2 LEFT JOIN ( 3754 t3 LEFT JOIN ( 3755 t4 FULL JOIN t5 USING(a) 3756 ) USING(a) 3757 ) USING(a) 3758 ) USING(a) 3759 ORDER BY 1 NULLS FIRST; 3760} { 3761 - - - - - - 3762 11 11 - - - - 3763 12 12 12 12 - - 3764 13 - 13 13 13 - 3765 15 15 15 15 15 15 3766 17 17 - - - - 3767 18 - 18 18 - 18 3768 3769} 3770do_execsql_test joinC-217 { 3771 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 3772 FROM t1 FULL JOIN ( 3773 t2 LEFT JOIN ( 3774 t3 RIGHT JOIN ( 3775 t4 INNER JOIN t5 USING(a) 3776 ) USING(a) 3777 ) USING(a) 3778 ) USING(a) 3779 ORDER BY 1 NULLS FIRST; 3780} { 3781 - - - - - - 3782 11 11 - - - - 3783 12 12 12 - - - 3784 13 - 13 - - - 3785 15 15 15 15 15 15 3786 17 17 - - - - 3787 18 - 18 - - - 3788 3789} 3790do_execsql_test joinC-218 { 3791 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 3792 FROM t1 FULL JOIN ( 3793 t2 LEFT JOIN ( 3794 t3 RIGHT JOIN ( 3795 t4 LEFT JOIN t5 USING(a) 3796 ) USING(a) 3797 ) USING(a) 3798 ) USING(a) 3799 ORDER BY 1 NULLS FIRST; 3800} { 3801 - - - - - - 3802 11 11 - - - - 3803 12 12 12 - - - 3804 13 - 13 13 13 - 3805 15 15 15 15 15 15 3806 17 17 - - - - 3807 18 - 18 - - - 3808 3809} 3810do_execsql_test joinC-219 { 3811 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 3812 FROM t1 FULL JOIN ( 3813 t2 LEFT JOIN ( 3814 t3 RIGHT JOIN ( 3815 t4 RIGHT JOIN t5 USING(a) 3816 ) USING(a) 3817 ) USING(a) 3818 ) USING(a) 3819 ORDER BY 1 NULLS FIRST; 3820} { 3821 - - - - - - 3822 11 11 - - - - 3823 12 12 12 - - - 3824 13 - 13 - - - 3825 15 15 15 15 15 15 3826 17 17 - - - - 3827 18 - 18 18 - 18 3828 3829} 3830do_execsql_test joinC-220 { 3831 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 3832 FROM t1 FULL JOIN ( 3833 t2 LEFT JOIN ( 3834 t3 RIGHT JOIN ( 3835 t4 FULL JOIN t5 USING(a) 3836 ) USING(a) 3837 ) USING(a) 3838 ) USING(a) 3839 ORDER BY 1 NULLS FIRST; 3840} { 3841 - - - - - - 3842 11 11 - - - - 3843 12 12 12 - - - 3844 13 - 13 13 13 - 3845 15 15 15 15 15 15 3846 17 17 - - - - 3847 18 - 18 18 - 18 3848 3849} 3850do_execsql_test joinC-221 { 3851 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 3852 FROM t1 FULL JOIN ( 3853 t2 LEFT JOIN ( 3854 t3 FULL JOIN ( 3855 t4 INNER JOIN t5 USING(a) 3856 ) USING(a) 3857 ) USING(a) 3858 ) USING(a) 3859 ORDER BY 1 NULLS FIRST; 3860} { 3861 - - - - - - 3862 11 11 - - - - 3863 12 12 12 12 - - 3864 13 - 13 13 - - 3865 15 15 15 15 15 15 3866 17 17 - - - - 3867 18 - 18 18 - - 3868 3869} 3870do_execsql_test joinC-222 { 3871 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 3872 FROM t1 FULL JOIN ( 3873 t2 LEFT JOIN ( 3874 t3 FULL JOIN ( 3875 t4 LEFT JOIN t5 USING(a) 3876 ) USING(a) 3877 ) USING(a) 3878 ) USING(a) 3879 ORDER BY 1 NULLS FIRST; 3880} { 3881 - - - - - - 3882 11 11 - - - - 3883 12 12 12 12 - - 3884 13 - 13 13 13 - 3885 15 15 15 15 15 15 3886 17 17 - - - - 3887 18 - 18 18 - - 3888 3889} 3890do_execsql_test joinC-223 { 3891 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 3892 FROM t1 FULL JOIN ( 3893 t2 LEFT JOIN ( 3894 t3 FULL JOIN ( 3895 t4 RIGHT JOIN t5 USING(a) 3896 ) USING(a) 3897 ) USING(a) 3898 ) USING(a) 3899 ORDER BY 1 NULLS FIRST; 3900} { 3901 - - - - - - 3902 11 11 - - - - 3903 12 12 12 12 - - 3904 13 - 13 13 - - 3905 15 15 15 15 15 15 3906 17 17 - - - - 3907 18 - 18 18 - 18 3908 3909} 3910do_execsql_test joinC-224 { 3911 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 3912 FROM t1 FULL JOIN ( 3913 t2 LEFT JOIN ( 3914 t3 FULL JOIN ( 3915 t4 FULL JOIN t5 USING(a) 3916 ) USING(a) 3917 ) USING(a) 3918 ) USING(a) 3919 ORDER BY 1 NULLS FIRST; 3920} { 3921 - - - - - - 3922 11 11 - - - - 3923 12 12 12 12 - - 3924 13 - 13 13 13 - 3925 15 15 15 15 15 15 3926 17 17 - - - - 3927 18 - 18 18 - 18 3928 3929} 3930do_execsql_test joinC-225 { 3931 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 3932 FROM t1 FULL JOIN ( 3933 t2 RIGHT JOIN ( 3934 t3 INNER JOIN ( 3935 t4 INNER JOIN t5 USING(a) 3936 ) USING(a) 3937 ) USING(a) 3938 ) USING(a) 3939 ORDER BY 1 NULLS FIRST; 3940} { 3941 11 11 - - - - 3942 12 12 - - - - 3943 15 15 15 15 15 15 3944 17 17 - - - - 3945 19 - - 19 19 19 3946 3947} 3948do_execsql_test joinC-226 { 3949 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 3950 FROM t1 FULL JOIN ( 3951 t2 RIGHT JOIN ( 3952 t3 INNER JOIN ( 3953 t4 LEFT JOIN t5 USING(a) 3954 ) USING(a) 3955 ) USING(a) 3956 ) USING(a) 3957 ORDER BY 1 NULLS FIRST; 3958} { 3959 11 11 - 11 11 - 3960 12 12 - - - - 3961 13 - 13 13 13 - 3962 15 15 15 15 15 15 3963 17 17 - - - - 3964 19 - - 19 19 19 3965 3966} 3967do_execsql_test joinC-227 { 3968 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 3969 FROM t1 FULL JOIN ( 3970 t2 RIGHT JOIN ( 3971 t3 INNER JOIN ( 3972 t4 RIGHT JOIN t5 USING(a) 3973 ) USING(a) 3974 ) USING(a) 3975 ) USING(a) 3976 ORDER BY 1 NULLS FIRST; 3977} { 3978 11 11 - - - - 3979 12 12 - - - - 3980 15 15 15 15 15 15 3981 17 17 - 17 - 17 3982 18 - 18 18 - 18 3983 19 - - 19 19 19 3984 3985} 3986do_execsql_test joinC-228 { 3987 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 3988 FROM t1 FULL JOIN ( 3989 t2 RIGHT JOIN ( 3990 t3 INNER JOIN ( 3991 t4 FULL JOIN t5 USING(a) 3992 ) USING(a) 3993 ) USING(a) 3994 ) USING(a) 3995 ORDER BY 1 NULLS FIRST; 3996} { 3997 11 11 - 11 11 - 3998 12 12 - - - - 3999 13 - 13 13 13 - 4000 15 15 15 15 15 15 4001 17 17 - 17 - 17 4002 18 - 18 18 - 18 4003 19 - - 19 19 19 4004 4005} 4006do_execsql_test joinC-229 { 4007 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 4008 FROM t1 FULL JOIN ( 4009 t2 RIGHT JOIN ( 4010 t3 LEFT JOIN ( 4011 t4 INNER JOIN t5 USING(a) 4012 ) USING(a) 4013 ) USING(a) 4014 ) USING(a) 4015 ORDER BY 1 NULLS FIRST; 4016} { 4017 - - - - - - 4018 11 11 - 11 - - 4019 12 12 12 12 - - 4020 13 - 13 13 - - 4021 15 15 15 15 15 15 4022 17 17 - 17 - - 4023 18 - 18 18 - - 4024 19 - - 19 19 19 4025 4026} 4027do_execsql_test joinC-230 { 4028 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 4029 FROM t1 FULL JOIN ( 4030 t2 RIGHT JOIN ( 4031 t3 LEFT JOIN ( 4032 t4 LEFT JOIN t5 USING(a) 4033 ) USING(a) 4034 ) USING(a) 4035 ) USING(a) 4036 ORDER BY 1 NULLS FIRST; 4037} { 4038 - - - - - - 4039 11 11 - 11 11 - 4040 12 12 12 12 - - 4041 13 - 13 13 13 - 4042 15 15 15 15 15 15 4043 17 17 - 17 - - 4044 18 - 18 18 - - 4045 19 - - 19 19 19 4046 4047} 4048do_execsql_test joinC-231 { 4049 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 4050 FROM t1 FULL JOIN ( 4051 t2 RIGHT JOIN ( 4052 t3 LEFT JOIN ( 4053 t4 RIGHT JOIN t5 USING(a) 4054 ) USING(a) 4055 ) USING(a) 4056 ) USING(a) 4057 ORDER BY 1 NULLS FIRST; 4058} { 4059 - - - - - - 4060 11 11 - 11 - - 4061 12 12 12 12 - - 4062 13 - 13 13 - - 4063 15 15 15 15 15 15 4064 17 17 - 17 - 17 4065 18 - 18 18 - 18 4066 19 - - 19 19 19 4067 4068} 4069do_execsql_test joinC-232 { 4070 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 4071 FROM t1 FULL JOIN ( 4072 t2 RIGHT JOIN ( 4073 t3 LEFT JOIN ( 4074 t4 FULL JOIN t5 USING(a) 4075 ) USING(a) 4076 ) USING(a) 4077 ) USING(a) 4078 ORDER BY 1 NULLS FIRST; 4079} { 4080 - - - - - - 4081 11 11 - 11 11 - 4082 12 12 12 12 - - 4083 13 - 13 13 13 - 4084 15 15 15 15 15 15 4085 17 17 - 17 - 17 4086 18 - 18 18 - 18 4087 19 - - 19 19 19 4088 4089} 4090do_execsql_test joinC-233 { 4091 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 4092 FROM t1 FULL JOIN ( 4093 t2 RIGHT JOIN ( 4094 t3 RIGHT JOIN ( 4095 t4 INNER JOIN t5 USING(a) 4096 ) USING(a) 4097 ) USING(a) 4098 ) USING(a) 4099 ORDER BY 1 NULLS FIRST; 4100} { 4101 11 11 - - - - 4102 12 12 - - - - 4103 15 15 15 15 15 15 4104 17 17 - - - - 4105 19 - - 19 19 19 4106 4107} 4108do_execsql_test joinC-234 { 4109 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 4110 FROM t1 FULL JOIN ( 4111 t2 RIGHT JOIN ( 4112 t3 RIGHT JOIN ( 4113 t4 LEFT JOIN t5 USING(a) 4114 ) USING(a) 4115 ) USING(a) 4116 ) USING(a) 4117 ORDER BY 1 NULLS FIRST; 4118} { 4119 11 11 - 11 11 - 4120 12 12 - - - - 4121 13 - 13 13 13 - 4122 15 15 15 15 15 15 4123 17 17 - - - - 4124 19 - - 19 19 19 4125 4126} 4127do_execsql_test joinC-235 { 4128 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 4129 FROM t1 FULL JOIN ( 4130 t2 RIGHT JOIN ( 4131 t3 RIGHT JOIN ( 4132 t4 RIGHT JOIN t5 USING(a) 4133 ) USING(a) 4134 ) USING(a) 4135 ) USING(a) 4136 ORDER BY 1 NULLS FIRST; 4137} { 4138 11 11 - - - - 4139 12 12 - - - - 4140 15 15 15 15 15 15 4141 17 17 - 17 - 17 4142 18 - 18 18 - 18 4143 19 - - 19 19 19 4144 4145} 4146do_execsql_test joinC-236 { 4147 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 4148 FROM t1 FULL JOIN ( 4149 t2 RIGHT JOIN ( 4150 t3 RIGHT JOIN ( 4151 t4 FULL JOIN t5 USING(a) 4152 ) USING(a) 4153 ) USING(a) 4154 ) USING(a) 4155 ORDER BY 1 NULLS FIRST; 4156} { 4157 11 11 - 11 11 - 4158 12 12 - - - - 4159 13 - 13 13 13 - 4160 15 15 15 15 15 15 4161 17 17 - 17 - 17 4162 18 - 18 18 - 18 4163 19 - - 19 19 19 4164 4165} 4166do_execsql_test joinC-237 { 4167 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 4168 FROM t1 FULL JOIN ( 4169 t2 RIGHT JOIN ( 4170 t3 FULL JOIN ( 4171 t4 INNER JOIN t5 USING(a) 4172 ) USING(a) 4173 ) USING(a) 4174 ) USING(a) 4175 ORDER BY 1 NULLS FIRST; 4176} { 4177 - - - - - - 4178 11 11 - 11 - - 4179 12 12 12 12 - - 4180 13 - 13 13 - - 4181 15 15 15 15 15 15 4182 17 17 - 17 - - 4183 18 - 18 18 - - 4184 19 - - 19 19 19 4185 4186} 4187do_execsql_test joinC-238 { 4188 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 4189 FROM t1 FULL JOIN ( 4190 t2 RIGHT JOIN ( 4191 t3 FULL JOIN ( 4192 t4 LEFT JOIN t5 USING(a) 4193 ) USING(a) 4194 ) USING(a) 4195 ) USING(a) 4196 ORDER BY 1 NULLS FIRST; 4197} { 4198 - - - - - - 4199 11 11 - 11 11 - 4200 12 12 12 12 - - 4201 13 - 13 13 13 - 4202 15 15 15 15 15 15 4203 17 17 - 17 - - 4204 18 - 18 18 - - 4205 19 - - 19 19 19 4206 4207} 4208do_execsql_test joinC-239 { 4209 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 4210 FROM t1 FULL JOIN ( 4211 t2 RIGHT JOIN ( 4212 t3 FULL JOIN ( 4213 t4 RIGHT JOIN t5 USING(a) 4214 ) USING(a) 4215 ) USING(a) 4216 ) USING(a) 4217 ORDER BY 1 NULLS FIRST; 4218} { 4219 - - - - - - 4220 11 11 - 11 - - 4221 12 12 12 12 - - 4222 13 - 13 13 - - 4223 15 15 15 15 15 15 4224 17 17 - 17 - 17 4225 18 - 18 18 - 18 4226 19 - - 19 19 19 4227 4228} 4229do_execsql_test joinC-240 { 4230 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 4231 FROM t1 FULL JOIN ( 4232 t2 RIGHT JOIN ( 4233 t3 FULL JOIN ( 4234 t4 FULL JOIN t5 USING(a) 4235 ) USING(a) 4236 ) USING(a) 4237 ) USING(a) 4238 ORDER BY 1 NULLS FIRST; 4239} { 4240 - - - - - - 4241 11 11 - 11 11 - 4242 12 12 12 12 - - 4243 13 - 13 13 13 - 4244 15 15 15 15 15 15 4245 17 17 - 17 - 17 4246 18 - 18 18 - 18 4247 19 - - 19 19 19 4248 4249} 4250do_execsql_test joinC-241 { 4251 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 4252 FROM t1 FULL JOIN ( 4253 t2 FULL JOIN ( 4254 t3 INNER JOIN ( 4255 t4 INNER JOIN t5 USING(a) 4256 ) USING(a) 4257 ) USING(a) 4258 ) USING(a) 4259 ORDER BY 1 NULLS FIRST; 4260} { 4261 - - - - - - 4262 11 11 - - - - 4263 12 12 12 - - - 4264 13 - 13 - - - 4265 15 15 15 15 15 15 4266 17 17 - - - - 4267 18 - 18 - - - 4268 19 - - 19 19 19 4269 4270} 4271do_execsql_test joinC-242 { 4272 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 4273 FROM t1 FULL JOIN ( 4274 t2 FULL JOIN ( 4275 t3 INNER JOIN ( 4276 t4 LEFT JOIN t5 USING(a) 4277 ) USING(a) 4278 ) USING(a) 4279 ) USING(a) 4280 ORDER BY 1 NULLS FIRST; 4281} { 4282 - - - - - - 4283 11 11 - 11 11 - 4284 12 12 12 - - - 4285 13 - 13 13 13 - 4286 15 15 15 15 15 15 4287 17 17 - - - - 4288 18 - 18 - - - 4289 19 - - 19 19 19 4290 4291} 4292do_execsql_test joinC-243 { 4293 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 4294 FROM t1 FULL JOIN ( 4295 t2 FULL JOIN ( 4296 t3 INNER JOIN ( 4297 t4 RIGHT JOIN t5 USING(a) 4298 ) USING(a) 4299 ) USING(a) 4300 ) USING(a) 4301 ORDER BY 1 NULLS FIRST; 4302} { 4303 - - - - - - 4304 11 11 - - - - 4305 12 12 12 - - - 4306 13 - 13 - - - 4307 15 15 15 15 15 15 4308 17 17 - 17 - 17 4309 18 - 18 18 - 18 4310 19 - - 19 19 19 4311 4312} 4313do_execsql_test joinC-244 { 4314 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 4315 FROM t1 FULL JOIN ( 4316 t2 FULL JOIN ( 4317 t3 INNER JOIN ( 4318 t4 FULL JOIN t5 USING(a) 4319 ) USING(a) 4320 ) USING(a) 4321 ) USING(a) 4322 ORDER BY 1 NULLS FIRST; 4323} { 4324 - - - - - - 4325 11 11 - 11 11 - 4326 12 12 12 - - - 4327 13 - 13 13 13 - 4328 15 15 15 15 15 15 4329 17 17 - 17 - 17 4330 18 - 18 18 - 18 4331 19 - - 19 19 19 4332 4333} 4334do_execsql_test joinC-245 { 4335 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 4336 FROM t1 FULL JOIN ( 4337 t2 FULL JOIN ( 4338 t3 LEFT JOIN ( 4339 t4 INNER JOIN t5 USING(a) 4340 ) USING(a) 4341 ) USING(a) 4342 ) USING(a) 4343 ORDER BY 1 NULLS FIRST; 4344} { 4345 - - - - - - 4346 - - - - - - 4347 11 11 - 11 - - 4348 12 12 12 12 - - 4349 13 - 13 13 - - 4350 15 15 15 15 15 15 4351 17 17 - 17 - - 4352 18 - 18 18 - - 4353 19 - - 19 19 19 4354 4355} 4356do_execsql_test joinC-246 { 4357 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 4358 FROM t1 FULL JOIN ( 4359 t2 FULL JOIN ( 4360 t3 LEFT JOIN ( 4361 t4 LEFT JOIN t5 USING(a) 4362 ) USING(a) 4363 ) USING(a) 4364 ) USING(a) 4365 ORDER BY 1 NULLS FIRST; 4366} { 4367 - - - - - - 4368 - - - - - - 4369 11 11 - 11 11 - 4370 12 12 12 12 - - 4371 13 - 13 13 13 - 4372 15 15 15 15 15 15 4373 17 17 - 17 - - 4374 18 - 18 18 - - 4375 19 - - 19 19 19 4376 4377} 4378do_execsql_test joinC-247 { 4379 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 4380 FROM t1 FULL JOIN ( 4381 t2 FULL JOIN ( 4382 t3 LEFT JOIN ( 4383 t4 RIGHT JOIN t5 USING(a) 4384 ) USING(a) 4385 ) USING(a) 4386 ) USING(a) 4387 ORDER BY 1 NULLS FIRST; 4388} { 4389 - - - - - - 4390 - - - - - - 4391 11 11 - 11 - - 4392 12 12 12 12 - - 4393 13 - 13 13 - - 4394 15 15 15 15 15 15 4395 17 17 - 17 - 17 4396 18 - 18 18 - 18 4397 19 - - 19 19 19 4398 4399} 4400do_execsql_test joinC-248 { 4401 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 4402 FROM t1 FULL JOIN ( 4403 t2 FULL JOIN ( 4404 t3 LEFT JOIN ( 4405 t4 FULL JOIN t5 USING(a) 4406 ) USING(a) 4407 ) USING(a) 4408 ) USING(a) 4409 ORDER BY 1 NULLS FIRST; 4410} { 4411 - - - - - - 4412 - - - - - - 4413 11 11 - 11 11 - 4414 12 12 12 12 - - 4415 13 - 13 13 13 - 4416 15 15 15 15 15 15 4417 17 17 - 17 - 17 4418 18 - 18 18 - 18 4419 19 - - 19 19 19 4420 4421} 4422do_execsql_test joinC-249 { 4423 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 4424 FROM t1 FULL JOIN ( 4425 t2 FULL JOIN ( 4426 t3 RIGHT JOIN ( 4427 t4 INNER JOIN t5 USING(a) 4428 ) USING(a) 4429 ) USING(a) 4430 ) USING(a) 4431 ORDER BY 1 NULLS FIRST; 4432} { 4433 - - - - - - 4434 11 11 - - - - 4435 12 12 12 - - - 4436 13 - 13 - - - 4437 15 15 15 15 15 15 4438 17 17 - - - - 4439 18 - 18 - - - 4440 19 - - 19 19 19 4441 4442} 4443do_execsql_test joinC-250 { 4444 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 4445 FROM t1 FULL JOIN ( 4446 t2 FULL JOIN ( 4447 t3 RIGHT JOIN ( 4448 t4 LEFT JOIN t5 USING(a) 4449 ) USING(a) 4450 ) USING(a) 4451 ) USING(a) 4452 ORDER BY 1 NULLS FIRST; 4453} { 4454 - - - - - - 4455 11 11 - 11 11 - 4456 12 12 12 - - - 4457 13 - 13 13 13 - 4458 15 15 15 15 15 15 4459 17 17 - - - - 4460 18 - 18 - - - 4461 19 - - 19 19 19 4462 4463} 4464do_execsql_test joinC-251 { 4465 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 4466 FROM t1 FULL JOIN ( 4467 t2 FULL JOIN ( 4468 t3 RIGHT JOIN ( 4469 t4 RIGHT JOIN t5 USING(a) 4470 ) USING(a) 4471 ) USING(a) 4472 ) USING(a) 4473 ORDER BY 1 NULLS FIRST; 4474} { 4475 - - - - - - 4476 11 11 - - - - 4477 12 12 12 - - - 4478 13 - 13 - - - 4479 15 15 15 15 15 15 4480 17 17 - 17 - 17 4481 18 - 18 18 - 18 4482 19 - - 19 19 19 4483 4484} 4485do_execsql_test joinC-252 { 4486 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 4487 FROM t1 FULL JOIN ( 4488 t2 FULL JOIN ( 4489 t3 RIGHT JOIN ( 4490 t4 FULL JOIN t5 USING(a) 4491 ) USING(a) 4492 ) USING(a) 4493 ) USING(a) 4494 ORDER BY 1 NULLS FIRST; 4495} { 4496 - - - - - - 4497 11 11 - 11 11 - 4498 12 12 12 - - - 4499 13 - 13 13 13 - 4500 15 15 15 15 15 15 4501 17 17 - 17 - 17 4502 18 - 18 18 - 18 4503 19 - - 19 19 19 4504 4505} 4506do_execsql_test joinC-253 { 4507 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 4508 FROM t1 FULL JOIN ( 4509 t2 FULL JOIN ( 4510 t3 FULL JOIN ( 4511 t4 INNER JOIN t5 USING(a) 4512 ) USING(a) 4513 ) USING(a) 4514 ) USING(a) 4515 ORDER BY 1 NULLS FIRST; 4516} { 4517 - - - - - - 4518 - - - - - - 4519 11 11 - 11 - - 4520 12 12 12 12 - - 4521 13 - 13 13 - - 4522 15 15 15 15 15 15 4523 17 17 - 17 - - 4524 18 - 18 18 - - 4525 19 - - 19 19 19 4526 4527} 4528do_execsql_test joinC-254 { 4529 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 4530 FROM t1 FULL JOIN ( 4531 t2 FULL JOIN ( 4532 t3 FULL JOIN ( 4533 t4 LEFT JOIN t5 USING(a) 4534 ) USING(a) 4535 ) USING(a) 4536 ) USING(a) 4537 ORDER BY 1 NULLS FIRST; 4538} { 4539 - - - - - - 4540 - - - - - - 4541 11 11 - 11 11 - 4542 12 12 12 12 - - 4543 13 - 13 13 13 - 4544 15 15 15 15 15 15 4545 17 17 - 17 - - 4546 18 - 18 18 - - 4547 19 - - 19 19 19 4548 4549} 4550do_execsql_test joinC-255 { 4551 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 4552 FROM t1 FULL JOIN ( 4553 t2 FULL JOIN ( 4554 t3 FULL JOIN ( 4555 t4 RIGHT JOIN t5 USING(a) 4556 ) USING(a) 4557 ) USING(a) 4558 ) USING(a) 4559 ORDER BY 1 NULLS FIRST; 4560} { 4561 - - - - - - 4562 - - - - - - 4563 11 11 - 11 - - 4564 12 12 12 12 - - 4565 13 - 13 13 - - 4566 15 15 15 15 15 15 4567 17 17 - 17 - 17 4568 18 - 18 18 - 18 4569 19 - - 19 19 19 4570 4571} 4572do_execsql_test joinC-256 { 4573 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a 4574 FROM t1 FULL JOIN ( 4575 t2 FULL JOIN ( 4576 t3 FULL JOIN ( 4577 t4 FULL JOIN t5 USING(a) 4578 ) USING(a) 4579 ) USING(a) 4580 ) USING(a) 4581 ORDER BY 1 NULLS FIRST; 4582} { 4583 - - - - - - 4584 - - - - - - 4585 11 11 - 11 11 - 4586 12 12 12 12 - - 4587 13 - 13 13 13 - 4588 15 15 15 15 15 15 4589 17 17 - 17 - 17 4590 18 - 18 18 - 18 4591 19 - - 19 19 19 4592 4593} 4594finish_test 4595