test/joinB.test - master - AlexanderLukyanov/sqlite2

test/joinB.test
7 252 строки149 KB
drh
Add 512 new join test cases derived from PostgreSQL output.
19 апр 2022, 18:01
19 апр 2022, 18:01de75638
set testdir [file dirname $argv0]
# 2022-04-19
#
# The author disclaims copyright to this source code.  In place of
# a legal notice, here is a blessing:
#
#    May you do good and not evil.
#    May you find forgiveness for yourself and forgive others.
#    May you share freely, never taking more than you give.
#
#***********************************************************************
#
# This file implements tests for JOINs.
#
# The test case output is all generated by PostgreSQL 14.  This test module
# was created as follows:
#
#   1.   Run a TCL script (included at the bottom of this file) that
#        generates an input script for "psql" that will run man
#        diverse tests on joins.
#
#   2.   Run the script from step (1) through psql and collect the
#        output.
#
#   3.   Make a few minor global search-and-replace operations to convert
#        the psql output into a form suitable for this test module.
#
#   4.   Add this header, and the script content at the footer.
#
source $testdir/tester.tcl
db nullvalue -
db eval {
  DROP TABLE IF EXISTS t1;
  DROP TABLE IF EXISTS t2;
  DROP TABLE IF EXISTS t3;
  DROP TABLE IF EXISTS t4;
  DROP TABLE IF EXISTS t5;
  CREATE TABLE t1(a INT, b INT, c INT);
  CREATE TABLE t2(a INT, b INT, d INT);
  CREATE TABLE t3(a INT, b INT, e INT);
  CREATE TABLE t4(a INT, b INT, f INT);
  CREATE TABLE t5(a INT, b INT, g INT);
  INSERT INTO t1 VALUES(11,21,31),(12,22,32),(15,25,35),(17,27,37);
  INSERT INTO t2 VALUES(12,22,32),(13,23,33),(15,25,35),(18,28,38),
                       (NULL,NULL,36);
  INSERT INTO t4 VALUES(11,21,31),(13,23,33),(15,25,35),(19,29,39);
  INSERT INTO t3 SELECT * FROM t1 UNION SELECT * FROM t2 UNION SELECT * FROM t4;
  INSERT INTO t5 SELECT * FROM t3 WHERE a>=15;
}
do_execsql_test joinB-1 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  INNER JOIN t2 USING(a)
  INNER JOIN t3 USING(a)
  INNER JOIN t4 USING(a)
  INNER JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  15 15 15 15 15 15
}
do_execsql_test joinB-2 {
  SELECT a, c, d, e, f, g
  FROM t1
  INNER JOIN t2 USING(a,b)
  INNER JOIN t3 USING(a,b)
  INNER JOIN t4 USING(a,b)
  INNER JOIN t5 USING(a,b)
  WHERE a<>13
  ORDER BY 1 NULLS FIRST;
} {
  15 35 35 35 35 35
}
do_execsql_test joinB-3 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  INNER JOIN t2 USING(a)
  INNER JOIN t3 USING(a)
  INNER JOIN t4 USING(a)
  LEFT JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  15 15 15 15 15 15
}
do_execsql_test joinB-4 {
  SELECT a, c, d, e, f, g
  FROM t1
  INNER JOIN (t2 INNER JOIN t3 USING(a)) USING(a)
  INNER JOIN (t4 LEFT JOIN t5 USING(a)) USING(a)
  WHERE a<=18
  ORDER BY 1 NULLS FIRST;
} {
  15 35 35 35 35 35
}
do_execsql_test joinB-5 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  INNER JOIN t2 USING(a)
  INNER JOIN t3 USING(a)
  INNER JOIN t4 USING(a)
  RIGHT JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  15 15 15 15 15 15
  17  -  -  -  - 17
  18  -  -  -  - 18
  19  -  -  -  - 19
}
do_execsql_test joinB-6 {
  SELECT a, b, c, d, e, f, g
  FROM t1
  INNER JOIN t2 USING(a,b)
  INNER JOIN t3 USING(a,b)
  INNER JOIN t4 USING(a,b)
  RIGHT JOIN t5 USING(a,b)
  WHERE d<>33 OR d IS NULL
  ORDER BY 1 NULLS FIRST;
} {
  15 25 35 35 35 35 35
  17 27  -  -  -  - 37
  18 28  -  -  -  - 38
  19 29  -  -  -  - 39
}
do_execsql_test joinB-7 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  INNER JOIN t2 USING(a)
  INNER JOIN t3 USING(a)
  INNER JOIN t4 USING(a)
  FULL JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  15 15 15 15 15 15
  17  -  -  -  - 17
  18  -  -  -  - 18
  19  -  -  -  - 19
}
do_execsql_test joinB-8 {
  SELECT b, c, d, e, f, g
  FROM t1
  NATURAL INNER JOIN t2
  NATURAL INNER JOIN t3
  NATURAL INNER JOIN t4
  NATURAL FULL JOIN t5
  WHERE b BETWEEN 12 AND 17
  ORDER BY 1 NULLS FIRST;
} {
}
do_execsql_test joinB-9 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  INNER JOIN t2 USING(a)
  INNER JOIN t3 USING(a)
  LEFT JOIN t4 USING(a)
  INNER JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  15 15 15 15 15 15
}
do_execsql_test joinB-10 {
  SELECT a, c, d, e, f, g
  FROM t1
  INNER JOIN t2 USING(a,b)
  INNER JOIN t3 USING(a,b)
  LEFT JOIN t4 USING(a,b)
  INNER JOIN t5 USING(a,b)
  WHERE a<>13
  ORDER BY 1 NULLS FIRST;
} {
  15 35 35 35 35 35
}
do_execsql_test joinB-11 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  INNER JOIN t2 USING(a)
  INNER JOIN t3 USING(a)
  LEFT JOIN t4 USING(a)
  LEFT JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  12 12 12 12  -  -
  15 15 15 15 15 15
}
do_execsql_test joinB-12 {
  SELECT a, c, d, e, f, g
  FROM t1
  INNER JOIN (t2 INNER JOIN t3 USING(a)) USING(a)
  LEFT JOIN (t4 LEFT JOIN t5 USING(a)) USING(a)
  WHERE a<=18
  ORDER BY 1 NULLS FIRST;
} {
  12 32 32 32  -  -
  15 35 35 35 35 35
}
do_execsql_test joinB-13 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  INNER JOIN t2 USING(a)
  INNER JOIN t3 USING(a)
  LEFT JOIN t4 USING(a)
  RIGHT JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  15 15 15 15 15 15
  17  -  -  -  - 17
  18  -  -  -  - 18
  19  -  -  -  - 19
}
do_execsql_test joinB-14 {
  SELECT a, b, c, d, e, f, g
  FROM t1
  INNER JOIN t2 USING(a,b)
  INNER JOIN t3 USING(a,b)
  LEFT JOIN t4 USING(a,b)
  RIGHT JOIN t5 USING(a,b)
  WHERE d<>33 OR d IS NULL
  ORDER BY 1 NULLS FIRST;
} {
  15 25 35 35 35 35 35
  17 27  -  -  -  - 37
  18 28  -  -  -  - 38
  19 29  -  -  -  - 39
}
do_execsql_test joinB-15 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  INNER JOIN t2 USING(a)
  INNER JOIN t3 USING(a)
  LEFT JOIN t4 USING(a)
  FULL JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  12 12 12 12  -  -
  15 15 15 15 15 15
  17  -  -  -  - 17
  18  -  -  -  - 18
  19  -  -  -  - 19
}
do_execsql_test joinB-16 {
  SELECT b, c, d, e, f, g
  FROM t1
  NATURAL INNER JOIN t2
  NATURAL INNER JOIN t3
  NATURAL LEFT JOIN t4
  NATURAL FULL JOIN t5
  WHERE b BETWEEN 12 AND 17
  ORDER BY 1 NULLS FIRST;
} {
}
do_execsql_test joinB-17 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  INNER JOIN t2 USING(a)
  INNER JOIN t3 USING(a)
  RIGHT JOIN t4 USING(a)
  INNER JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  15 15 15 15 15 15
  19  -  -  - 19 19
}
do_execsql_test joinB-18 {
  SELECT a, c, d, e, f, g
  FROM t1
  INNER JOIN t2 USING(a,b)
  INNER JOIN t3 USING(a,b)
  RIGHT JOIN t4 USING(a,b)
  INNER JOIN t5 USING(a,b)
  WHERE a<>13
  ORDER BY 1 NULLS FIRST;
} {
  15 35 35 35 35 35
  19  -  -  - 39 39
}
do_execsql_test joinB-19 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  INNER JOIN t2 USING(a)
  INNER JOIN t3 USING(a)
  RIGHT JOIN t4 USING(a)
  LEFT JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  11  -  -  - 11  -
  13  -  -  - 13  -
  15 15 15 15 15 15
  19  -  -  - 19 19
}
do_execsql_test joinB-20 {
  SELECT a, c, d, e, f, g
  FROM t1
  INNER JOIN (t2 INNER JOIN t3 USING(a)) USING(a)
  RIGHT JOIN (t4 LEFT JOIN t5 USING(a)) USING(a)
  WHERE a<=18
  ORDER BY 1 NULLS FIRST;
} {
  11  -  -  - 31  -
  13  -  -  - 33  -
  15 35 35 35 35 35
}
do_execsql_test joinB-21 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  INNER JOIN t2 USING(a)
  INNER JOIN t3 USING(a)
  RIGHT JOIN t4 USING(a)
  RIGHT JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  15 15 15 15 15 15
  17  -  -  -  - 17
  18  -  -  -  - 18
  19  -  -  - 19 19
}
do_execsql_test joinB-22 {
  SELECT a, b, c, d, e, f, g
  FROM t1
  INNER JOIN t2 USING(a,b)
  INNER JOIN t3 USING(a,b)
  RIGHT JOIN t4 USING(a,b)
  RIGHT JOIN t5 USING(a,b)
  WHERE d<>33 OR d IS NULL
  ORDER BY 1 NULLS FIRST;
} {
  15 25 35 35 35 35 35
  17 27  -  -  -  - 37
  18 28  -  -  -  - 38
  19 29  -  -  - 39 39
}
do_execsql_test joinB-23 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  INNER JOIN t2 USING(a)
  INNER JOIN t3 USING(a)
  RIGHT JOIN t4 USING(a)
  FULL JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  11  -  -  - 11  -
  13  -  -  - 13  -
  15 15 15 15 15 15
  17  -  -  -  - 17
  18  -  -  -  - 18
  19  -  -  - 19 19
}
do_execsql_test joinB-24 {
  SELECT b, c, d, e, f, g
  FROM t1
  NATURAL INNER JOIN t2
  NATURAL INNER JOIN t3
  NATURAL RIGHT JOIN t4
  NATURAL FULL JOIN t5
  WHERE b BETWEEN 12 AND 17
  ORDER BY 1 NULLS FIRST;
} {
}
do_execsql_test joinB-25 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  INNER JOIN t2 USING(a)
  INNER JOIN t3 USING(a)
  FULL JOIN t4 USING(a)
  INNER JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  15 15 15 15 15 15
  19  -  -  - 19 19
}
do_execsql_test joinB-26 {
  SELECT a, c, d, e, f, g
  FROM t1
  INNER JOIN t2 USING(a,b)
  INNER JOIN t3 USING(a,b)
  FULL JOIN t4 USING(a,b)
  INNER JOIN t5 USING(a,b)
  WHERE a<>13
  ORDER BY 1 NULLS FIRST;
} {
  15 35 35 35 35 35
  19  -  -  - 39 39
}
do_execsql_test joinB-27 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  INNER JOIN t2 USING(a)
  INNER JOIN t3 USING(a)
  FULL JOIN t4 USING(a)
  LEFT JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  11  -  -  - 11  -
  12 12 12 12  -  -
  13  -  -  - 13  -
  15 15 15 15 15 15
  19  -  -  - 19 19
}
do_execsql_test joinB-28 {
  SELECT a, c, d, e, f, g
  FROM t1
  INNER JOIN (t2 INNER JOIN t3 USING(a)) USING(a)
  FULL JOIN (t4 LEFT JOIN t5 USING(a)) USING(a)
  WHERE a<=18
  ORDER BY 1 NULLS FIRST;
} {
  11  -  -  - 31  -
  12 32 32 32  -  -
  13  -  -  - 33  -
  15 35 35 35 35 35
}
do_execsql_test joinB-29 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  INNER JOIN t2 USING(a)
  INNER JOIN t3 USING(a)
  FULL JOIN t4 USING(a)
  RIGHT JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  15 15 15 15 15 15
  17  -  -  -  - 17
  18  -  -  -  - 18
  19  -  -  - 19 19
}
do_execsql_test joinB-30 {
  SELECT a, b, c, d, e, f, g
  FROM t1
  INNER JOIN t2 USING(a,b)
  INNER JOIN t3 USING(a,b)
  FULL JOIN t4 USING(a,b)
  RIGHT JOIN t5 USING(a,b)
  WHERE d<>33 OR d IS NULL
  ORDER BY 1 NULLS FIRST;
} {
  15 25 35 35 35 35 35
  17 27  -  -  -  - 37
  18 28  -  -  -  - 38
  19 29  -  -  - 39 39
}
do_execsql_test joinB-31 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  INNER JOIN t2 USING(a)
  INNER JOIN t3 USING(a)
  FULL JOIN t4 USING(a)
  FULL JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  11  -  -  - 11  -
  12 12 12 12  -  -
  13  -  -  - 13  -
  15 15 15 15 15 15
  17  -  -  -  - 17
  18  -  -  -  - 18
  19  -  -  - 19 19
}
do_execsql_test joinB-32 {
  SELECT b, c, d, e, f, g
  FROM t1
  NATURAL INNER JOIN t2
  NATURAL INNER JOIN t3
  NATURAL FULL JOIN t4
  NATURAL FULL JOIN t5
  WHERE b BETWEEN 12 AND 17
  ORDER BY 1 NULLS FIRST;
} {
}
do_execsql_test joinB-33 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  INNER JOIN t2 USING(a)
  LEFT JOIN t3 USING(a)
  INNER JOIN t4 USING(a)
  INNER JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  15 15 15 15 15 15
}
do_execsql_test joinB-34 {
  SELECT a, c, d, e, f, g
  FROM t1
  INNER JOIN t2 USING(a,b)
  LEFT JOIN t3 USING(a,b)
  INNER JOIN t4 USING(a,b)
  INNER JOIN t5 USING(a,b)
  WHERE a<>13
  ORDER BY 1 NULLS FIRST;
} {
  15 35 35 35 35 35
}
do_execsql_test joinB-35 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  INNER JOIN t2 USING(a)
  LEFT JOIN t3 USING(a)
  INNER JOIN t4 USING(a)
  LEFT JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  15 15 15 15 15 15
}
do_execsql_test joinB-36 {
  SELECT a, c, d, e, f, g
  FROM t1
  INNER JOIN (t2 LEFT JOIN t3 USING(a)) USING(a)
  INNER JOIN (t4 LEFT JOIN t5 USING(a)) USING(a)
  WHERE a<=18
  ORDER BY 1 NULLS FIRST;
} {
  15 35 35 35 35 35
}
do_execsql_test joinB-37 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  INNER JOIN t2 USING(a)
  LEFT JOIN t3 USING(a)
  INNER JOIN t4 USING(a)
  RIGHT JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  15 15 15 15 15 15
  17  -  -  -  - 17
  18  -  -  -  - 18
  19  -  -  -  - 19
}
do_execsql_test joinB-38 {
  SELECT a, b, c, d, e, f, g
  FROM t1
  INNER JOIN t2 USING(a,b)
  LEFT JOIN t3 USING(a,b)
  INNER JOIN t4 USING(a,b)
  RIGHT JOIN t5 USING(a,b)
  WHERE d<>33 OR d IS NULL
  ORDER BY 1 NULLS FIRST;
} {
  15 25 35 35 35 35 35
  17 27  -  -  -  - 37
  18 28  -  -  -  - 38
  19 29  -  -  -  - 39
}
do_execsql_test joinB-39 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  INNER JOIN t2 USING(a)
  LEFT JOIN t3 USING(a)
  INNER JOIN t4 USING(a)
  FULL JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  15 15 15 15 15 15
  17  -  -  -  - 17
  18  -  -  -  - 18
  19  -  -  -  - 19
}
do_execsql_test joinB-40 {
  SELECT b, c, d, e, f, g
  FROM t1
  NATURAL INNER JOIN t2
  NATURAL LEFT JOIN t3
  NATURAL INNER JOIN t4
  NATURAL FULL JOIN t5
  WHERE b BETWEEN 12 AND 17
  ORDER BY 1 NULLS FIRST;
} {
}
do_execsql_test joinB-41 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  INNER JOIN t2 USING(a)
  LEFT JOIN t3 USING(a)
  LEFT JOIN t4 USING(a)
  INNER JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  15 15 15 15 15 15
}
do_execsql_test joinB-42 {
  SELECT a, c, d, e, f, g
  FROM t1
  INNER JOIN t2 USING(a,b)
  LEFT JOIN t3 USING(a,b)
  LEFT JOIN t4 USING(a,b)
  INNER JOIN t5 USING(a,b)
  WHERE a<>13
  ORDER BY 1 NULLS FIRST;
} {
  15 35 35 35 35 35
}
do_execsql_test joinB-43 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  INNER JOIN t2 USING(a)
  LEFT JOIN t3 USING(a)
  LEFT JOIN t4 USING(a)
  LEFT JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  12 12 12 12  -  -
  15 15 15 15 15 15
}
do_execsql_test joinB-44 {
  SELECT a, c, d, e, f, g
  FROM t1
  INNER JOIN (t2 LEFT JOIN t3 USING(a)) USING(a)
  LEFT JOIN (t4 LEFT JOIN t5 USING(a)) USING(a)
  WHERE a<=18
  ORDER BY 1 NULLS FIRST;
} {
  12 32 32 32  -  -
  15 35 35 35 35 35
}
do_execsql_test joinB-45 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  INNER JOIN t2 USING(a)
  LEFT JOIN t3 USING(a)
  LEFT JOIN t4 USING(a)
  RIGHT JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  15 15 15 15 15 15
  17  -  -  -  - 17
  18  -  -  -  - 18
  19  -  -  -  - 19
}
do_execsql_test joinB-46 {
  SELECT a, b, c, d, e, f, g
  FROM t1
  INNER JOIN t2 USING(a,b)
  LEFT JOIN t3 USING(a,b)
  LEFT JOIN t4 USING(a,b)
  RIGHT JOIN t5 USING(a,b)
  WHERE d<>33 OR d IS NULL
  ORDER BY 1 NULLS FIRST;
} {
  15 25 35 35 35 35 35
  17 27  -  -  -  - 37
  18 28  -  -  -  - 38
  19 29  -  -  -  - 39
}
do_execsql_test joinB-47 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  INNER JOIN t2 USING(a)
  LEFT JOIN t3 USING(a)
  LEFT JOIN t4 USING(a)
  FULL JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  12 12 12 12  -  -
  15 15 15 15 15 15
  17  -  -  -  - 17
  18  -  -  -  - 18
  19  -  -  -  - 19
}
do_execsql_test joinB-48 {
  SELECT b, c, d, e, f, g
  FROM t1
  NATURAL INNER JOIN t2
  NATURAL LEFT JOIN t3
  NATURAL LEFT JOIN t4
  NATURAL FULL JOIN t5
  WHERE b BETWEEN 12 AND 17
  ORDER BY 1 NULLS FIRST;
} {
}
do_execsql_test joinB-49 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  INNER JOIN t2 USING(a)
  LEFT JOIN t3 USING(a)
  RIGHT JOIN t4 USING(a)
  INNER JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  15 15 15 15 15 15
  19  -  -  - 19 19
}
do_execsql_test joinB-50 {
  SELECT a, c, d, e, f, g
  FROM t1
  INNER JOIN t2 USING(a,b)
  LEFT JOIN t3 USING(a,b)
  RIGHT JOIN t4 USING(a,b)
  INNER JOIN t5 USING(a,b)
  WHERE a<>13
  ORDER BY 1 NULLS FIRST;
} {
  15 35 35 35 35 35
  19  -  -  - 39 39
}
do_execsql_test joinB-51 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  INNER JOIN t2 USING(a)
  LEFT JOIN t3 USING(a)
  RIGHT JOIN t4 USING(a)
  LEFT JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  11  -  -  - 11  -
  13  -  -  - 13  -
  15 15 15 15 15 15
  19  -  -  - 19 19
}
do_execsql_test joinB-52 {
  SELECT a, c, d, e, f, g
  FROM t1
  INNER JOIN (t2 LEFT JOIN t3 USING(a)) USING(a)
  RIGHT JOIN (t4 LEFT JOIN t5 USING(a)) USING(a)
  WHERE a<=18
  ORDER BY 1 NULLS FIRST;
} {
  11  -  -  - 31  -
  13  -  -  - 33  -
  15 35 35 35 35 35
}
do_execsql_test joinB-53 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  INNER JOIN t2 USING(a)
  LEFT JOIN t3 USING(a)
  RIGHT JOIN t4 USING(a)
  RIGHT JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  15 15 15 15 15 15
  17  -  -  -  - 17
  18  -  -  -  - 18
  19  -  -  - 19 19
}
do_execsql_test joinB-54 {
  SELECT a, b, c, d, e, f, g
  FROM t1
  INNER JOIN t2 USING(a,b)
  LEFT JOIN t3 USING(a,b)
  RIGHT JOIN t4 USING(a,b)
  RIGHT JOIN t5 USING(a,b)
  WHERE d<>33 OR d IS NULL
  ORDER BY 1 NULLS FIRST;
} {
  15 25 35 35 35 35 35
  17 27  -  -  -  - 37
  18 28  -  -  -  - 38
  19 29  -  -  - 39 39
}
do_execsql_test joinB-55 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  INNER JOIN t2 USING(a)
  LEFT JOIN t3 USING(a)
  RIGHT JOIN t4 USING(a)
  FULL JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  11  -  -  - 11  -
  13  -  -  - 13  -
  15 15 15 15 15 15
  17  -  -  -  - 17
  18  -  -  -  - 18
  19  -  -  - 19 19
}
do_execsql_test joinB-56 {
  SELECT b, c, d, e, f, g
  FROM t1
  NATURAL INNER JOIN t2
  NATURAL LEFT JOIN t3
  NATURAL RIGHT JOIN t4
  NATURAL FULL JOIN t5
  WHERE b BETWEEN 12 AND 17
  ORDER BY 1 NULLS FIRST;
} {
}
do_execsql_test joinB-57 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  INNER JOIN t2 USING(a)
  LEFT JOIN t3 USING(a)
  FULL JOIN t4 USING(a)
  INNER JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  15 15 15 15 15 15
  19  -  -  - 19 19
}
do_execsql_test joinB-58 {
  SELECT a, c, d, e, f, g
  FROM t1
  INNER JOIN t2 USING(a,b)
  LEFT JOIN t3 USING(a,b)
  FULL JOIN t4 USING(a,b)
  INNER JOIN t5 USING(a,b)
  WHERE a<>13
  ORDER BY 1 NULLS FIRST;
} {
  15 35 35 35 35 35
  19  -  -  - 39 39
}
do_execsql_test joinB-59 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  INNER JOIN t2 USING(a)
  LEFT JOIN t3 USING(a)
  FULL JOIN t4 USING(a)
  LEFT JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  11  -  -  - 11  -
  12 12 12 12  -  -
  13  -  -  - 13  -
  15 15 15 15 15 15
  19  -  -  - 19 19
}
do_execsql_test joinB-60 {
  SELECT a, c, d, e, f, g
  FROM t1
  INNER JOIN (t2 LEFT JOIN t3 USING(a)) USING(a)
  FULL JOIN (t4 LEFT JOIN t5 USING(a)) USING(a)
  WHERE a<=18
  ORDER BY 1 NULLS FIRST;
} {
  11  -  -  - 31  -
  12 32 32 32  -  -
  13  -  -  - 33  -
  15 35 35 35 35 35
}
do_execsql_test joinB-61 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  INNER JOIN t2 USING(a)
  LEFT JOIN t3 USING(a)
  FULL JOIN t4 USING(a)
  RIGHT JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  15 15 15 15 15 15
  17  -  -  -  - 17
  18  -  -  -  - 18
  19  -  -  - 19 19
}
do_execsql_test joinB-62 {
  SELECT a, b, c, d, e, f, g
  FROM t1
  INNER JOIN t2 USING(a,b)
  LEFT JOIN t3 USING(a,b)
  FULL JOIN t4 USING(a,b)
  RIGHT JOIN t5 USING(a,b)
  WHERE d<>33 OR d IS NULL
  ORDER BY 1 NULLS FIRST;
} {
  15 25 35 35 35 35 35
  17 27  -  -  -  - 37
  18 28  -  -  -  - 38
  19 29  -  -  - 39 39
}
do_execsql_test joinB-63 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  INNER JOIN t2 USING(a)
  LEFT JOIN t3 USING(a)
  FULL JOIN t4 USING(a)
  FULL JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  11  -  -  - 11  -
  12 12 12 12  -  -
  13  -  -  - 13  -
  15 15 15 15 15 15
  17  -  -  -  - 17
  18  -  -  -  - 18
  19  -  -  - 19 19
}
do_execsql_test joinB-64 {
  SELECT b, c, d, e, f, g
  FROM t1
  NATURAL INNER JOIN t2
  NATURAL LEFT JOIN t3
  NATURAL FULL JOIN t4
  NATURAL FULL JOIN t5
  WHERE b BETWEEN 12 AND 17
  ORDER BY 1 NULLS FIRST;
} {
}
do_execsql_test joinB-65 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  INNER JOIN t2 USING(a)
  RIGHT JOIN t3 USING(a)
  INNER JOIN t4 USING(a)
  INNER JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  15 15 15 15 15 15
  19  -  - 19 19 19
}
do_execsql_test joinB-66 {
  SELECT a, c, d, e, f, g
  FROM t1
  INNER JOIN t2 USING(a,b)
  RIGHT JOIN t3 USING(a,b)
  INNER JOIN t4 USING(a,b)
  INNER JOIN t5 USING(a,b)
  WHERE a<>13
  ORDER BY 1 NULLS FIRST;
} {
  15 35 35 35 35 35
  19  -  - 39 39 39
}
do_execsql_test joinB-67 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  INNER JOIN t2 USING(a)
  RIGHT JOIN t3 USING(a)
  INNER JOIN t4 USING(a)
  LEFT JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  11  -  - 11 11  -
  13  -  - 13 13  -
  15 15 15 15 15 15
  19  -  - 19 19 19
}
do_execsql_test joinB-68 {
  SELECT a, c, d, e, f, g
  FROM t1
  INNER JOIN (t2 RIGHT JOIN t3 USING(a)) USING(a)
  INNER JOIN (t4 LEFT JOIN t5 USING(a)) USING(a)
  WHERE a<=18
  ORDER BY 1 NULLS FIRST;
} {
  11 31  - 31 31  -
  15 35 35 35 35 35
}
do_execsql_test joinB-69 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  INNER JOIN t2 USING(a)
  RIGHT JOIN t3 USING(a)
  INNER JOIN t4 USING(a)
  RIGHT JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  15 15 15 15 15 15
  17  -  -  -  - 17
  18  -  -  -  - 18
  19  -  - 19 19 19
}
do_execsql_test joinB-70 {
  SELECT a, b, c, d, e, f, g
  FROM t1
  INNER JOIN t2 USING(a,b)
  RIGHT JOIN t3 USING(a,b)
  INNER JOIN t4 USING(a,b)
  RIGHT JOIN t5 USING(a,b)
  WHERE d<>33 OR d IS NULL
  ORDER BY 1 NULLS FIRST;
} {
  15 25 35 35 35 35 35
  17 27  -  -  -  - 37
  18 28  -  -  -  - 38
  19 29  -  - 39 39 39
}
do_execsql_test joinB-71 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  INNER JOIN t2 USING(a)
  RIGHT JOIN t3 USING(a)
  INNER JOIN t4 USING(a)
  FULL JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  11  -  - 11 11  -
  13  -  - 13 13  -
  15 15 15 15 15 15
  17  -  -  -  - 17
  18  -  -  -  - 18
  19  -  - 19 19 19
}
do_execsql_test joinB-72 {
  SELECT b, c, d, e, f, g
  FROM t1
  NATURAL INNER JOIN t2
  NATURAL RIGHT JOIN t3
  NATURAL INNER JOIN t4
  NATURAL FULL JOIN t5
  WHERE b BETWEEN 12 AND 17
  ORDER BY 1 NULLS FIRST;
} {
}
do_execsql_test joinB-73 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  INNER JOIN t2 USING(a)
  RIGHT JOIN t3 USING(a)
  LEFT JOIN t4 USING(a)
  INNER JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  15 15 15 15 15 15
  17  -  - 17  - 17
  18  -  - 18  - 18
  19  -  - 19 19 19
}
do_execsql_test joinB-74 {
  SELECT a, c, d, e, f, g
  FROM t1
  INNER JOIN t2 USING(a,b)
  RIGHT JOIN t3 USING(a,b)
  LEFT JOIN t4 USING(a,b)
  INNER JOIN t5 USING(a,b)
  WHERE a<>13
  ORDER BY 1 NULLS FIRST;
} {
  15 35 35 35 35 35
  17  -  - 37  - 37
  18  -  - 38  - 38
  19  -  - 39 39 39
}
do_execsql_test joinB-75 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  INNER JOIN t2 USING(a)
  RIGHT JOIN t3 USING(a)
  LEFT JOIN t4 USING(a)
  LEFT JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
   -  -  -  -  -  -
  11  -  - 11 11  -
  12 12 12 12  -  -
  13  -  - 13 13  -
  15 15 15 15 15 15
  17  -  - 17  - 17
  18  -  - 18  - 18
  19  -  - 19 19 19
}
do_execsql_test joinB-76 {
  SELECT a, c, d, e, f, g
  FROM t1
  INNER JOIN (t2 RIGHT JOIN t3 USING(a)) USING(a)
  LEFT JOIN (t4 LEFT JOIN t5 USING(a)) USING(a)
  WHERE a<=18
  ORDER BY 1 NULLS FIRST;
} {
  11 31  - 31 31  -
  12 32 32 32  -  -
  15 35 35 35 35 35
  17 37  - 37  -  -
}
do_execsql_test joinB-77 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  INNER JOIN t2 USING(a)
  RIGHT JOIN t3 USING(a)
  LEFT JOIN t4 USING(a)
  RIGHT JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  15 15 15 15 15 15
  17  -  - 17  - 17
  18  -  - 18  - 18
  19  -  - 19 19 19
}
do_execsql_test joinB-78 {
  SELECT a, b, c, d, e, f, g
  FROM t1
  INNER JOIN t2 USING(a,b)
  RIGHT JOIN t3 USING(a,b)
  LEFT JOIN t4 USING(a,b)
  RIGHT JOIN t5 USING(a,b)
  WHERE d<>33 OR d IS NULL
  ORDER BY 1 NULLS FIRST;
} {
  15 25 35 35 35 35 35
  17 27  -  - 37  - 37
  18 28  -  - 38  - 38
  19 29  -  - 39 39 39
}
do_execsql_test joinB-79 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  INNER JOIN t2 USING(a)
  RIGHT JOIN t3 USING(a)
  LEFT JOIN t4 USING(a)
  FULL JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
   -  -  -  -  -  -
  11  -  - 11 11  -
  12 12 12 12  -  -
  13  -  - 13 13  -
  15 15 15 15 15 15
  17  -  - 17  - 17
  18  -  - 18  - 18
  19  -  - 19 19 19
}
do_execsql_test joinB-80 {
  SELECT b, c, d, e, f, g
  FROM t1
  NATURAL INNER JOIN t2
  NATURAL RIGHT JOIN t3
  NATURAL LEFT JOIN t4
  NATURAL FULL JOIN t5
  WHERE b BETWEEN 12 AND 17
  ORDER BY 1 NULLS FIRST;
} {
}
do_execsql_test joinB-81 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  INNER JOIN t2 USING(a)
  RIGHT JOIN t3 USING(a)
  RIGHT JOIN t4 USING(a)
  INNER JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  15 15 15 15 15 15
  19  -  - 19 19 19
}
do_execsql_test joinB-82 {
  SELECT a, c, d, e, f, g
  FROM t1
  INNER JOIN t2 USING(a,b)
  RIGHT JOIN t3 USING(a,b)
  RIGHT JOIN t4 USING(a,b)
  INNER JOIN t5 USING(a,b)
  WHERE a<>13
  ORDER BY 1 NULLS FIRST;
} {
  15 35 35 35 35 35
  19  -  - 39 39 39
}
do_execsql_test joinB-83 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  INNER JOIN t2 USING(a)
  RIGHT JOIN t3 USING(a)
  RIGHT JOIN t4 USING(a)
  LEFT JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  11  -  - 11 11  -
  13  -  - 13 13  -
  15 15 15 15 15 15
  19  -  - 19 19 19
}
do_execsql_test joinB-84 {
  SELECT a, c, d, e, f, g
  FROM t1
  INNER JOIN (t2 RIGHT JOIN t3 USING(a)) USING(a)
  RIGHT JOIN (t4 LEFT JOIN t5 USING(a)) USING(a)
  WHERE a<=18
  ORDER BY 1 NULLS FIRST;
} {
  11 31  - 31 31  -
  13  -  -  - 33  -
  15 35 35 35 35 35
}
do_execsql_test joinB-85 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  INNER JOIN t2 USING(a)
  RIGHT JOIN t3 USING(a)
  RIGHT JOIN t4 USING(a)
  RIGHT JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  15 15 15 15 15 15
  17  -  -  -  - 17
  18  -  -  -  - 18
  19  -  - 19 19 19
}
do_execsql_test joinB-86 {
  SELECT a, b, c, d, e, f, g
  FROM t1
  INNER JOIN t2 USING(a,b)
  RIGHT JOIN t3 USING(a,b)
  RIGHT JOIN t4 USING(a,b)
  RIGHT JOIN t5 USING(a,b)
  WHERE d<>33 OR d IS NULL
  ORDER BY 1 NULLS FIRST;
} {
  15 25 35 35 35 35 35
  17 27  -  -  -  - 37
  18 28  -  -  -  - 38
  19 29  -  - 39 39 39
}
do_execsql_test joinB-87 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  INNER JOIN t2 USING(a)
  RIGHT JOIN t3 USING(a)
  RIGHT JOIN t4 USING(a)
  FULL JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  11  -  - 11 11  -
  13  -  - 13 13  -
  15 15 15 15 15 15
  17  -  -  -  - 17
  18  -  -  -  - 18
  19  -  - 19 19 19
}
do_execsql_test joinB-88 {
  SELECT b, c, d, e, f, g
  FROM t1
  NATURAL INNER JOIN t2
  NATURAL RIGHT JOIN t3
  NATURAL RIGHT JOIN t4
  NATURAL FULL JOIN t5
  WHERE b BETWEEN 12 AND 17
  ORDER BY 1 NULLS FIRST;
} {
}
do_execsql_test joinB-89 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  INNER JOIN t2 USING(a)
  RIGHT JOIN t3 USING(a)
  FULL JOIN t4 USING(a)
  INNER JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  15 15 15 15 15 15
  17  -  - 17  - 17
  18  -  - 18  - 18
  19  -  - 19 19 19
}
do_execsql_test joinB-90 {
  SELECT a, c, d, e, f, g
  FROM t1
  INNER JOIN t2 USING(a,b)
  RIGHT JOIN t3 USING(a,b)
  FULL JOIN t4 USING(a,b)
  INNER JOIN t5 USING(a,b)
  WHERE a<>13
  ORDER BY 1 NULLS FIRST;
} {
  15 35 35 35 35 35
  17  -  - 37  - 37
  18  -  - 38  - 38
  19  -  - 39 39 39
}
do_execsql_test joinB-91 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  INNER JOIN t2 USING(a)
  RIGHT JOIN t3 USING(a)
  FULL JOIN t4 USING(a)
  LEFT JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
   -  -  -  -  -  -
  11  -  - 11 11  -
  12 12 12 12  -  -
  13  -  - 13 13  -
  15 15 15 15 15 15
  17  -  - 17  - 17
  18  -  - 18  - 18
  19  -  - 19 19 19
}
do_execsql_test joinB-92 {
  SELECT a, c, d, e, f, g
  FROM t1
  INNER JOIN (t2 RIGHT JOIN t3 USING(a)) USING(a)
  FULL JOIN (t4 LEFT JOIN t5 USING(a)) USING(a)
  WHERE a<=18
  ORDER BY 1 NULLS FIRST;
} {
  11 31  - 31 31  -
  12 32 32 32  -  -
  13  -  -  - 33  -
  15 35 35 35 35 35
  17 37  - 37  -  -
}
do_execsql_test joinB-93 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  INNER JOIN t2 USING(a)
  RIGHT JOIN t3 USING(a)
  FULL JOIN t4 USING(a)
  RIGHT JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  15 15 15 15 15 15
  17  -  - 17  - 17
  18  -  - 18  - 18
  19  -  - 19 19 19
}
do_execsql_test joinB-94 {
  SELECT a, b, c, d, e, f, g
  FROM t1
  INNER JOIN t2 USING(a,b)
  RIGHT JOIN t3 USING(a,b)
  FULL JOIN t4 USING(a,b)
  RIGHT JOIN t5 USING(a,b)
  WHERE d<>33 OR d IS NULL
  ORDER BY 1 NULLS FIRST;
} {
  15 25 35 35 35 35 35
  17 27  -  - 37  - 37
  18 28  -  - 38  - 38
  19 29  -  - 39 39 39
}
do_execsql_test joinB-95 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  INNER JOIN t2 USING(a)
  RIGHT JOIN t3 USING(a)
  FULL JOIN t4 USING(a)
  FULL JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
   -  -  -  -  -  -
  11  -  - 11 11  -
  12 12 12 12  -  -
  13  -  - 13 13  -
  15 15 15 15 15 15
  17  -  - 17  - 17
  18  -  - 18  - 18
  19  -  - 19 19 19
}
do_execsql_test joinB-96 {
  SELECT b, c, d, e, f, g
  FROM t1
  NATURAL INNER JOIN t2
  NATURAL RIGHT JOIN t3
  NATURAL FULL JOIN t4
  NATURAL FULL JOIN t5
  WHERE b BETWEEN 12 AND 17
  ORDER BY 1 NULLS FIRST;
} {
}
do_execsql_test joinB-97 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  INNER JOIN t2 USING(a)
  FULL JOIN t3 USING(a)
  INNER JOIN t4 USING(a)
  INNER JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  15 15 15 15 15 15
  19  -  - 19 19 19
}
do_execsql_test joinB-98 {
  SELECT a, c, d, e, f, g
  FROM t1
  INNER JOIN t2 USING(a,b)
  FULL JOIN t3 USING(a,b)
  INNER JOIN t4 USING(a,b)
  INNER JOIN t5 USING(a,b)
  WHERE a<>13
  ORDER BY 1 NULLS FIRST;
} {
  15 35 35 35 35 35
  19  -  - 39 39 39
}
do_execsql_test joinB-99 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  INNER JOIN t2 USING(a)
  FULL JOIN t3 USING(a)
  INNER JOIN t4 USING(a)
  LEFT JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  11  -  - 11 11  -
  13  -  - 13 13  -
  15 15 15 15 15 15
  19  -  - 19 19 19
}
do_execsql_test joinB-100 {
  SELECT a, c, d, e, f, g
  FROM t1
  INNER JOIN (t2 FULL JOIN t3 USING(a)) USING(a)
  INNER JOIN (t4 LEFT JOIN t5 USING(a)) USING(a)
  WHERE a<=18
  ORDER BY 1 NULLS FIRST;
} {
  11 31  - 31 31  -
  15 35 35 35 35 35
}
do_execsql_test joinB-101 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  INNER JOIN t2 USING(a)
  FULL JOIN t3 USING(a)
  INNER JOIN t4 USING(a)
  RIGHT JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  15 15 15 15 15 15
  17  -  -  -  - 17
  18  -  -  -  - 18
  19  -  - 19 19 19
}
do_execsql_test joinB-102 {
  SELECT a, b, c, d, e, f, g
  FROM t1
  INNER JOIN t2 USING(a,b)
  FULL JOIN t3 USING(a,b)
  INNER JOIN t4 USING(a,b)
  RIGHT JOIN t5 USING(a,b)
  WHERE d<>33 OR d IS NULL
  ORDER BY 1 NULLS FIRST;
} {
  15 25 35 35 35 35 35
  17 27  -  -  -  - 37
  18 28  -  -  -  - 38
  19 29  -  - 39 39 39
}
do_execsql_test joinB-103 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  INNER JOIN t2 USING(a)
  FULL JOIN t3 USING(a)
  INNER JOIN t4 USING(a)
  FULL JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  11  -  - 11 11  -
  13  -  - 13 13  -
  15 15 15 15 15 15
  17  -  -  -  - 17
  18  -  -  -  - 18
  19  -  - 19 19 19
}
do_execsql_test joinB-104 {
  SELECT b, c, d, e, f, g
  FROM t1
  NATURAL INNER JOIN t2
  NATURAL FULL JOIN t3
  NATURAL INNER JOIN t4
  NATURAL FULL JOIN t5
  WHERE b BETWEEN 12 AND 17
  ORDER BY 1 NULLS FIRST;
} {
}
do_execsql_test joinB-105 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  INNER JOIN t2 USING(a)
  FULL JOIN t3 USING(a)
  LEFT JOIN t4 USING(a)
  INNER JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  15 15 15 15 15 15
  17  -  - 17  - 17
  18  -  - 18  - 18
  19  -  - 19 19 19
}
do_execsql_test joinB-106 {
  SELECT a, c, d, e, f, g
  FROM t1
  INNER JOIN t2 USING(a,b)
  FULL JOIN t3 USING(a,b)
  LEFT JOIN t4 USING(a,b)
  INNER JOIN t5 USING(a,b)
  WHERE a<>13
  ORDER BY 1 NULLS FIRST;
} {
  15 35 35 35 35 35
  17  -  - 37  - 37
  18  -  - 38  - 38
  19  -  - 39 39 39
}
do_execsql_test joinB-107 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  INNER JOIN t2 USING(a)
  FULL JOIN t3 USING(a)
  LEFT JOIN t4 USING(a)
  LEFT JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
   -  -  -  -  -  -
  11  -  - 11 11  -
  12 12 12 12  -  -
  13  -  - 13 13  -
  15 15 15 15 15 15
  17  -  - 17  - 17
  18  -  - 18  - 18
  19  -  - 19 19 19
}
do_execsql_test joinB-108 {
  SELECT a, c, d, e, f, g
  FROM t1
  INNER JOIN (t2 FULL JOIN t3 USING(a)) USING(a)
  LEFT JOIN (t4 LEFT JOIN t5 USING(a)) USING(a)
  WHERE a<=18
  ORDER BY 1 NULLS FIRST;
} {
  11 31  - 31 31  -
  12 32 32 32  -  -
  15 35 35 35 35 35
  17 37  - 37  -  -
}
do_execsql_test joinB-109 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  INNER JOIN t2 USING(a)
  FULL JOIN t3 USING(a)
  LEFT JOIN t4 USING(a)
  RIGHT JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  15 15 15 15 15 15
  17  -  - 17  - 17
  18  -  - 18  - 18
  19  -  - 19 19 19
}
do_execsql_test joinB-110 {
  SELECT a, b, c, d, e, f, g
  FROM t1
  INNER JOIN t2 USING(a,b)
  FULL JOIN t3 USING(a,b)
  LEFT JOIN t4 USING(a,b)
  RIGHT JOIN t5 USING(a,b)
  WHERE d<>33 OR d IS NULL
  ORDER BY 1 NULLS FIRST;
} {
  15 25 35 35 35 35 35
  17 27  -  - 37  - 37
  18 28  -  - 38  - 38
  19 29  -  - 39 39 39
}
do_execsql_test joinB-111 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  INNER JOIN t2 USING(a)
  FULL JOIN t3 USING(a)
  LEFT JOIN t4 USING(a)
  FULL JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
   -  -  -  -  -  -
  11  -  - 11 11  -
  12 12 12 12  -  -
  13  -  - 13 13  -
  15 15 15 15 15 15
  17  -  - 17  - 17
  18  -  - 18  - 18
  19  -  - 19 19 19
}
do_execsql_test joinB-112 {
  SELECT b, c, d, e, f, g
  FROM t1
  NATURAL INNER JOIN t2
  NATURAL FULL JOIN t3
  NATURAL LEFT JOIN t4
  NATURAL FULL JOIN t5
  WHERE b BETWEEN 12 AND 17
  ORDER BY 1 NULLS FIRST;
} {
}
do_execsql_test joinB-113 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  INNER JOIN t2 USING(a)
  FULL JOIN t3 USING(a)
  RIGHT JOIN t4 USING(a)
  INNER JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  15 15 15 15 15 15
  19  -  - 19 19 19
}
do_execsql_test joinB-114 {
  SELECT a, c, d, e, f, g
  FROM t1
  INNER JOIN t2 USING(a,b)
  FULL JOIN t3 USING(a,b)
  RIGHT JOIN t4 USING(a,b)
  INNER JOIN t5 USING(a,b)
  WHERE a<>13
  ORDER BY 1 NULLS FIRST;
} {
  15 35 35 35 35 35
  19  -  - 39 39 39
}
do_execsql_test joinB-115 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  INNER JOIN t2 USING(a)
  FULL JOIN t3 USING(a)
  RIGHT JOIN t4 USING(a)
  LEFT JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  11  -  - 11 11  -
  13  -  - 13 13  -
  15 15 15 15 15 15
  19  -  - 19 19 19
}
do_execsql_test joinB-116 {
  SELECT a, c, d, e, f, g
  FROM t1
  INNER JOIN (t2 FULL JOIN t3 USING(a)) USING(a)
  RIGHT JOIN (t4 LEFT JOIN t5 USING(a)) USING(a)
  WHERE a<=18
  ORDER BY 1 NULLS FIRST;
} {
  11 31  - 31 31  -
  13  -  -  - 33  -
  15 35 35 35 35 35
}
do_execsql_test joinB-117 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  INNER JOIN t2 USING(a)
  FULL JOIN t3 USING(a)
  RIGHT JOIN t4 USING(a)
  RIGHT JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  15 15 15 15 15 15
  17  -  -  -  - 17
  18  -  -  -  - 18
  19  -  - 19 19 19
}
do_execsql_test joinB-118 {
  SELECT a, b, c, d, e, f, g
  FROM t1
  INNER JOIN t2 USING(a,b)
  FULL JOIN t3 USING(a,b)
  RIGHT JOIN t4 USING(a,b)
  RIGHT JOIN t5 USING(a,b)
  WHERE d<>33 OR d IS NULL
  ORDER BY 1 NULLS FIRST;
} {
  15 25 35 35 35 35 35
  17 27  -  -  -  - 37
  18 28  -  -  -  - 38
  19 29  -  - 39 39 39
}
do_execsql_test joinB-119 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  INNER JOIN t2 USING(a)
  FULL JOIN t3 USING(a)
  RIGHT JOIN t4 USING(a)
  FULL JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  11  -  - 11 11  -
  13  -  - 13 13  -
  15 15 15 15 15 15
  17  -  -  -  - 17
  18  -  -  -  - 18
  19  -  - 19 19 19
}
do_execsql_test joinB-120 {
  SELECT b, c, d, e, f, g
  FROM t1
  NATURAL INNER JOIN t2
  NATURAL FULL JOIN t3
  NATURAL RIGHT JOIN t4
  NATURAL FULL JOIN t5
  WHERE b BETWEEN 12 AND 17
  ORDER BY 1 NULLS FIRST;
} {
}
do_execsql_test joinB-121 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  INNER JOIN t2 USING(a)
  FULL JOIN t3 USING(a)
  FULL JOIN t4 USING(a)
  INNER JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  15 15 15 15 15 15
  17  -  - 17  - 17
  18  -  - 18  - 18
  19  -  - 19 19 19
}
do_execsql_test joinB-122 {
  SELECT a, c, d, e, f, g
  FROM t1
  INNER JOIN t2 USING(a,b)
  FULL JOIN t3 USING(a,b)
  FULL JOIN t4 USING(a,b)
  INNER JOIN t5 USING(a,b)
  WHERE a<>13
  ORDER BY 1 NULLS FIRST;
} {
  15 35 35 35 35 35
  17  -  - 37  - 37
  18  -  - 38  - 38
  19  -  - 39 39 39
}
do_execsql_test joinB-123 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  INNER JOIN t2 USING(a)
  FULL JOIN t3 USING(a)
  FULL JOIN t4 USING(a)
  LEFT JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
   -  -  -  -  -  -
  11  -  - 11 11  -
  12 12 12 12  -  -
  13  -  - 13 13  -
  15 15 15 15 15 15
  17  -  - 17  - 17
  18  -  - 18  - 18
  19  -  - 19 19 19
}
do_execsql_test joinB-124 {
  SELECT a, c, d, e, f, g
  FROM t1
  INNER JOIN (t2 FULL JOIN t3 USING(a)) USING(a)
  FULL JOIN (t4 LEFT JOIN t5 USING(a)) USING(a)
  WHERE a<=18
  ORDER BY 1 NULLS FIRST;
} {
  11 31  - 31 31  -
  12 32 32 32  -  -
  13  -  -  - 33  -
  15 35 35 35 35 35
  17 37  - 37  -  -
}
do_execsql_test joinB-125 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  INNER JOIN t2 USING(a)
  FULL JOIN t3 USING(a)
  FULL JOIN t4 USING(a)
  RIGHT JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  15 15 15 15 15 15
  17  -  - 17  - 17
  18  -  - 18  - 18
  19  -  - 19 19 19
}
do_execsql_test joinB-126 {
  SELECT a, b, c, d, e, f, g
  FROM t1
  INNER JOIN t2 USING(a,b)
  FULL JOIN t3 USING(a,b)
  FULL JOIN t4 USING(a,b)
  RIGHT JOIN t5 USING(a,b)
  WHERE d<>33 OR d IS NULL
  ORDER BY 1 NULLS FIRST;
} {
  15 25 35 35 35 35 35
  17 27  -  - 37  - 37
  18 28  -  - 38  - 38
  19 29  -  - 39 39 39
}
do_execsql_test joinB-127 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  INNER JOIN t2 USING(a)
  FULL JOIN t3 USING(a)
  FULL JOIN t4 USING(a)
  FULL JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
   -  -  -  -  -  -
  11  -  - 11 11  -
  12 12 12 12  -  -
  13  -  - 13 13  -
  15 15 15 15 15 15
  17  -  - 17  - 17
  18  -  - 18  - 18
  19  -  - 19 19 19
}
do_execsql_test joinB-128 {
  SELECT b, c, d, e, f, g
  FROM t1
  NATURAL INNER JOIN t2
  NATURAL FULL JOIN t3
  NATURAL FULL JOIN t4
  NATURAL FULL JOIN t5
  WHERE b BETWEEN 12 AND 17
  ORDER BY 1 NULLS FIRST;
} {
}
do_execsql_test joinB-129 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  LEFT JOIN t2 USING(a)
  INNER JOIN t3 USING(a)
  INNER JOIN t4 USING(a)
  INNER JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  15 15 15 15 15 15
}
do_execsql_test joinB-130 {
  SELECT a, c, d, e, f, g
  FROM t1
  LEFT JOIN t2 USING(a,b)
  INNER JOIN t3 USING(a,b)
  INNER JOIN t4 USING(a,b)
  INNER JOIN t5 USING(a,b)
  WHERE a<>13
  ORDER BY 1 NULLS FIRST;
} {
  15 35 35 35 35 35
}
do_execsql_test joinB-131 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  LEFT JOIN t2 USING(a)
  INNER JOIN t3 USING(a)
  INNER JOIN t4 USING(a)
  LEFT JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  11 11  - 11 11  -
  15 15 15 15 15 15
}
do_execsql_test joinB-132 {
  SELECT a, c, d, e, f, g
  FROM t1
  LEFT JOIN (t2 INNER JOIN t3 USING(a)) USING(a)
  INNER JOIN (t4 LEFT JOIN t5 USING(a)) USING(a)
  WHERE a<=18
  ORDER BY 1 NULLS FIRST;
} {
  11 31  -  - 31  -
  15 35 35 35 35 35
}
do_execsql_test joinB-133 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  LEFT JOIN t2 USING(a)
  INNER JOIN t3 USING(a)
  INNER JOIN t4 USING(a)
  RIGHT JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  15 15 15 15 15 15
  17  -  -  -  - 17
  18  -  -  -  - 18
  19  -  -  -  - 19
}
do_execsql_test joinB-134 {
  SELECT a, b, c, d, e, f, g
  FROM t1
  LEFT JOIN t2 USING(a,b)
  INNER JOIN t3 USING(a,b)
  INNER JOIN t4 USING(a,b)
  RIGHT JOIN t5 USING(a,b)
  WHERE d<>33 OR d IS NULL
  ORDER BY 1 NULLS FIRST;
} {
  15 25 35 35 35 35 35
  17 27  -  -  -  - 37
  18 28  -  -  -  - 38
  19 29  -  -  -  - 39
}
do_execsql_test joinB-135 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  LEFT JOIN t2 USING(a)
  INNER JOIN t3 USING(a)
  INNER JOIN t4 USING(a)
  FULL JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  11 11  - 11 11  -
  15 15 15 15 15 15
  17  -  -  -  - 17
  18  -  -  -  - 18
  19  -  -  -  - 19
}
do_execsql_test joinB-136 {
  SELECT b, c, d, e, f, g
  FROM t1
  NATURAL LEFT JOIN t2
  NATURAL INNER JOIN t3
  NATURAL INNER JOIN t4
  NATURAL FULL JOIN t5
  WHERE b BETWEEN 12 AND 17
  ORDER BY 1 NULLS FIRST;
} {
}
do_execsql_test joinB-137 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  LEFT JOIN t2 USING(a)
  INNER JOIN t3 USING(a)
  LEFT JOIN t4 USING(a)
  INNER JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  15 15 15 15 15 15
  17 17  - 17  - 17
}
do_execsql_test joinB-138 {
  SELECT a, c, d, e, f, g
  FROM t1
  LEFT JOIN t2 USING(a,b)
  INNER JOIN t3 USING(a,b)
  LEFT JOIN t4 USING(a,b)
  INNER JOIN t5 USING(a,b)
  WHERE a<>13
  ORDER BY 1 NULLS FIRST;
} {
  15 35 35 35 35 35
  17 37  - 37  - 37
}
do_execsql_test joinB-139 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  LEFT JOIN t2 USING(a)
  INNER JOIN t3 USING(a)
  LEFT JOIN t4 USING(a)
  LEFT JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  11 11  - 11 11  -
  12 12 12 12  -  -
  15 15 15 15 15 15
  17 17  - 17  - 17
}
do_execsql_test joinB-140 {
  SELECT a, c, d, e, f, g
  FROM t1
  LEFT JOIN (t2 INNER JOIN t3 USING(a)) USING(a)
  LEFT JOIN (t4 LEFT JOIN t5 USING(a)) USING(a)
  WHERE a<=18
  ORDER BY 1 NULLS FIRST;
} {
  11 31  -  - 31  -
  12 32 32 32  -  -
  15 35 35 35 35 35
  17 37  -  -  -  -
}
do_execsql_test joinB-141 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  LEFT JOIN t2 USING(a)
  INNER JOIN t3 USING(a)
  LEFT JOIN t4 USING(a)
  RIGHT JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  15 15 15 15 15 15
  17 17  - 17  - 17
  18  -  -  -  - 18
  19  -  -  -  - 19
}
do_execsql_test joinB-142 {
  SELECT a, b, c, d, e, f, g
  FROM t1
  LEFT JOIN t2 USING(a,b)
  INNER JOIN t3 USING(a,b)
  LEFT JOIN t4 USING(a,b)
  RIGHT JOIN t5 USING(a,b)
  WHERE d<>33 OR d IS NULL
  ORDER BY 1 NULLS FIRST;
} {
  15 25 35 35 35 35 35
  17 27 37  - 37  - 37
  18 28  -  -  -  - 38
  19 29  -  -  -  - 39
}
do_execsql_test joinB-143 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  LEFT JOIN t2 USING(a)
  INNER JOIN t3 USING(a)
  LEFT JOIN t4 USING(a)
  FULL JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  11 11  - 11 11  -
  12 12 12 12  -  -
  15 15 15 15 15 15
  17 17  - 17  - 17
  18  -  -  -  - 18
  19  -  -  -  - 19
}
do_execsql_test joinB-144 {
  SELECT b, c, d, e, f, g
  FROM t1
  NATURAL LEFT JOIN t2
  NATURAL INNER JOIN t3
  NATURAL LEFT JOIN t4
  NATURAL FULL JOIN t5
  WHERE b BETWEEN 12 AND 17
  ORDER BY 1 NULLS FIRST;
} {
}
do_execsql_test joinB-145 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  LEFT JOIN t2 USING(a)
  INNER JOIN t3 USING(a)
  RIGHT JOIN t4 USING(a)
  INNER JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  15 15 15 15 15 15
  19  -  -  - 19 19
}
do_execsql_test joinB-146 {
  SELECT a, c, d, e, f, g
  FROM t1
  LEFT JOIN t2 USING(a,b)
  INNER JOIN t3 USING(a,b)
  RIGHT JOIN t4 USING(a,b)
  INNER JOIN t5 USING(a,b)
  WHERE a<>13
  ORDER BY 1 NULLS FIRST;
} {
  15 35 35 35 35 35
  19  -  -  - 39 39
}
do_execsql_test joinB-147 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  LEFT JOIN t2 USING(a)
  INNER JOIN t3 USING(a)
  RIGHT JOIN t4 USING(a)
  LEFT JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  11 11  - 11 11  -
  13  -  -  - 13  -
  15 15 15 15 15 15
  19  -  -  - 19 19
}
do_execsql_test joinB-148 {
  SELECT a, c, d, e, f, g
  FROM t1
  LEFT JOIN (t2 INNER JOIN t3 USING(a)) USING(a)
  RIGHT JOIN (t4 LEFT JOIN t5 USING(a)) USING(a)
  WHERE a<=18
  ORDER BY 1 NULLS FIRST;
} {
  11 31  -  - 31  -
  13  -  -  - 33  -
  15 35 35 35 35 35
}
do_execsql_test joinB-149 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  LEFT JOIN t2 USING(a)
  INNER JOIN t3 USING(a)
  RIGHT JOIN t4 USING(a)
  RIGHT JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  15 15 15 15 15 15
  17  -  -  -  - 17
  18  -  -  -  - 18
  19  -  -  - 19 19
}
do_execsql_test joinB-150 {
  SELECT a, b, c, d, e, f, g
  FROM t1
  LEFT JOIN t2 USING(a,b)
  INNER JOIN t3 USING(a,b)
  RIGHT JOIN t4 USING(a,b)
  RIGHT JOIN t5 USING(a,b)
  WHERE d<>33 OR d IS NULL
  ORDER BY 1 NULLS FIRST;
} {
  15 25 35 35 35 35 35
  17 27  -  -  -  - 37
  18 28  -  -  -  - 38
  19 29  -  -  - 39 39
}
do_execsql_test joinB-151 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  LEFT JOIN t2 USING(a)
  INNER JOIN t3 USING(a)
  RIGHT JOIN t4 USING(a)
  FULL JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  11 11  - 11 11  -
  13  -  -  - 13  -
  15 15 15 15 15 15
  17  -  -  -  - 17
  18  -  -  -  - 18
  19  -  -  - 19 19
}
do_execsql_test joinB-152 {
  SELECT b, c, d, e, f, g
  FROM t1
  NATURAL LEFT JOIN t2
  NATURAL INNER JOIN t3
  NATURAL RIGHT JOIN t4
  NATURAL FULL JOIN t5
  WHERE b BETWEEN 12 AND 17
  ORDER BY 1 NULLS FIRST;
} {
}
do_execsql_test joinB-153 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  LEFT JOIN t2 USING(a)
  INNER JOIN t3 USING(a)
  FULL JOIN t4 USING(a)
  INNER JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  15 15 15 15 15 15
  17 17  - 17  - 17
  19  -  -  - 19 19
}
do_execsql_test joinB-154 {
  SELECT a, c, d, e, f, g
  FROM t1
  LEFT JOIN t2 USING(a,b)
  INNER JOIN t3 USING(a,b)
  FULL JOIN t4 USING(a,b)
  INNER JOIN t5 USING(a,b)
  WHERE a<>13
  ORDER BY 1 NULLS FIRST;
} {
  15 35 35 35 35 35
  17 37  - 37  - 37
  19  -  -  - 39 39
}
do_execsql_test joinB-155 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  LEFT JOIN t2 USING(a)
  INNER JOIN t3 USING(a)
  FULL JOIN t4 USING(a)
  LEFT JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  11 11  - 11 11  -
  12 12 12 12  -  -
  13  -  -  - 13  -
  15 15 15 15 15 15
  17 17  - 17  - 17
  19  -  -  - 19 19
}
do_execsql_test joinB-156 {
  SELECT a, c, d, e, f, g
  FROM t1
  LEFT JOIN (t2 INNER JOIN t3 USING(a)) USING(a)
  FULL JOIN (t4 LEFT JOIN t5 USING(a)) USING(a)
  WHERE a<=18
  ORDER BY 1 NULLS FIRST;
} {
  11 31  -  - 31  -
  12 32 32 32  -  -
  13  -  -  - 33  -
  15 35 35 35 35 35
  17 37  -  -  -  -
}
do_execsql_test joinB-157 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  LEFT JOIN t2 USING(a)
  INNER JOIN t3 USING(a)
  FULL JOIN t4 USING(a)
  RIGHT JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  15 15 15 15 15 15
  17 17  - 17  - 17
  18  -  -  -  - 18
  19  -  -  - 19 19
}
do_execsql_test joinB-158 {
  SELECT a, b, c, d, e, f, g
  FROM t1
  LEFT JOIN t2 USING(a,b)
  INNER JOIN t3 USING(a,b)
  FULL JOIN t4 USING(a,b)
  RIGHT JOIN t5 USING(a,b)
  WHERE d<>33 OR d IS NULL
  ORDER BY 1 NULLS FIRST;
} {
  15 25 35 35 35 35 35
  17 27 37  - 37  - 37
  18 28  -  -  -  - 38
  19 29  -  -  - 39 39
}
do_execsql_test joinB-159 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  LEFT JOIN t2 USING(a)
  INNER JOIN t3 USING(a)
  FULL JOIN t4 USING(a)
  FULL JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  11 11  - 11 11  -
  12 12 12 12  -  -
  13  -  -  - 13  -
  15 15 15 15 15 15
  17 17  - 17  - 17
  18  -  -  -  - 18
  19  -  -  - 19 19
}
do_execsql_test joinB-160 {
  SELECT b, c, d, e, f, g
  FROM t1
  NATURAL LEFT JOIN t2
  NATURAL INNER JOIN t3
  NATURAL FULL JOIN t4
  NATURAL FULL JOIN t5
  WHERE b BETWEEN 12 AND 17
  ORDER BY 1 NULLS FIRST;
} {
}
do_execsql_test joinB-161 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  LEFT JOIN t2 USING(a)
  LEFT JOIN t3 USING(a)
  INNER JOIN t4 USING(a)
  INNER JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  15 15 15 15 15 15
}
do_execsql_test joinB-162 {
  SELECT a, c, d, e, f, g
  FROM t1
  LEFT JOIN t2 USING(a,b)
  LEFT JOIN t3 USING(a,b)
  INNER JOIN t4 USING(a,b)
  INNER JOIN t5 USING(a,b)
  WHERE a<>13
  ORDER BY 1 NULLS FIRST;
} {
  15 35 35 35 35 35
}
do_execsql_test joinB-163 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  LEFT JOIN t2 USING(a)
  LEFT JOIN t3 USING(a)
  INNER JOIN t4 USING(a)
  LEFT JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  11 11  - 11 11  -
  15 15 15 15 15 15
}
do_execsql_test joinB-164 {
  SELECT a, c, d, e, f, g
  FROM t1
  LEFT JOIN (t2 LEFT JOIN t3 USING(a)) USING(a)
  INNER JOIN (t4 LEFT JOIN t5 USING(a)) USING(a)
  WHERE a<=18
  ORDER BY 1 NULLS FIRST;
} {
  11 31  -  - 31  -
  15 35 35 35 35 35
}
do_execsql_test joinB-165 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  LEFT JOIN t2 USING(a)
  LEFT JOIN t3 USING(a)
  INNER JOIN t4 USING(a)
  RIGHT JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  15 15 15 15 15 15
  17  -  -  -  - 17
  18  -  -  -  - 18
  19  -  -  -  - 19
}
do_execsql_test joinB-166 {
  SELECT a, b, c, d, e, f, g
  FROM t1
  LEFT JOIN t2 USING(a,b)
  LEFT JOIN t3 USING(a,b)
  INNER JOIN t4 USING(a,b)
  RIGHT JOIN t5 USING(a,b)
  WHERE d<>33 OR d IS NULL
  ORDER BY 1 NULLS FIRST;
} {
  15 25 35 35 35 35 35
  17 27  -  -  -  - 37
  18 28  -  -  -  - 38
  19 29  -  -  -  - 39
}
do_execsql_test joinB-167 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  LEFT JOIN t2 USING(a)
  LEFT JOIN t3 USING(a)
  INNER JOIN t4 USING(a)
  FULL JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  11 11  - 11 11  -
  15 15 15 15 15 15
  17  -  -  -  - 17
  18  -  -  -  - 18
  19  -  -  -  - 19
}
do_execsql_test joinB-168 {
  SELECT b, c, d, e, f, g
  FROM t1
  NATURAL LEFT JOIN t2
  NATURAL LEFT JOIN t3
  NATURAL INNER JOIN t4
  NATURAL FULL JOIN t5
  WHERE b BETWEEN 12 AND 17
  ORDER BY 1 NULLS FIRST;
} {
}
do_execsql_test joinB-169 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  LEFT JOIN t2 USING(a)
  LEFT JOIN t3 USING(a)
  LEFT JOIN t4 USING(a)
  INNER JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  15 15 15 15 15 15
  17 17  - 17  - 17
}
do_execsql_test joinB-170 {
  SELECT a, c, d, e, f, g
  FROM t1
  LEFT JOIN t2 USING(a,b)
  LEFT JOIN t3 USING(a,b)
  LEFT JOIN t4 USING(a,b)
  INNER JOIN t5 USING(a,b)
  WHERE a<>13
  ORDER BY 1 NULLS FIRST;
} {
  15 35 35 35 35 35
  17 37  - 37  - 37
}
do_execsql_test joinB-171 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  LEFT JOIN t2 USING(a)
  LEFT JOIN t3 USING(a)
  LEFT JOIN t4 USING(a)
  LEFT JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  11 11  - 11 11  -
  12 12 12 12  -  -
  15 15 15 15 15 15
  17 17  - 17  - 17
}
do_execsql_test joinB-172 {
  SELECT a, c, d, e, f, g
  FROM t1
  LEFT JOIN (t2 LEFT JOIN t3 USING(a)) USING(a)
  LEFT JOIN (t4 LEFT JOIN t5 USING(a)) USING(a)
  WHERE a<=18
  ORDER BY 1 NULLS FIRST;
} {
  11 31  -  - 31  -
  12 32 32 32  -  -
  15 35 35 35 35 35
  17 37  -  -  -  -
}
do_execsql_test joinB-173 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  LEFT JOIN t2 USING(a)
  LEFT JOIN t3 USING(a)
  LEFT JOIN t4 USING(a)
  RIGHT JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  15 15 15 15 15 15
  17 17  - 17  - 17
  18  -  -  -  - 18
  19  -  -  -  - 19
}
do_execsql_test joinB-174 {
  SELECT a, b, c, d, e, f, g
  FROM t1
  LEFT JOIN t2 USING(a,b)
  LEFT JOIN t3 USING(a,b)
  LEFT JOIN t4 USING(a,b)
  RIGHT JOIN t5 USING(a,b)
  WHERE d<>33 OR d IS NULL
  ORDER BY 1 NULLS FIRST;
} {
  15 25 35 35 35 35 35
  17 27 37  - 37  - 37
  18 28  -  -  -  - 38
  19 29  -  -  -  - 39
}
do_execsql_test joinB-175 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  LEFT JOIN t2 USING(a)
  LEFT JOIN t3 USING(a)
  LEFT JOIN t4 USING(a)
  FULL JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  11 11  - 11 11  -
  12 12 12 12  -  -
  15 15 15 15 15 15
  17 17  - 17  - 17
  18  -  -  -  - 18
  19  -  -  -  - 19
}
do_execsql_test joinB-176 {
  SELECT b, c, d, e, f, g
  FROM t1
  NATURAL LEFT JOIN t2
  NATURAL LEFT JOIN t3
  NATURAL LEFT JOIN t4
  NATURAL FULL JOIN t5
  WHERE b BETWEEN 12 AND 17
  ORDER BY 1 NULLS FIRST;
} {
}
do_execsql_test joinB-177 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  LEFT JOIN t2 USING(a)
  LEFT JOIN t3 USING(a)
  RIGHT JOIN t4 USING(a)
  INNER JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  15 15 15 15 15 15
  19  -  -  - 19 19
}
do_execsql_test joinB-178 {
  SELECT a, c, d, e, f, g
  FROM t1
  LEFT JOIN t2 USING(a,b)
  LEFT JOIN t3 USING(a,b)
  RIGHT JOIN t4 USING(a,b)
  INNER JOIN t5 USING(a,b)
  WHERE a<>13
  ORDER BY 1 NULLS FIRST;
} {
  15 35 35 35 35 35
  19  -  -  - 39 39
}
do_execsql_test joinB-179 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  LEFT JOIN t2 USING(a)
  LEFT JOIN t3 USING(a)
  RIGHT JOIN t4 USING(a)
  LEFT JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  11 11  - 11 11  -
  13  -  -  - 13  -
  15 15 15 15 15 15
  19  -  -  - 19 19
}
do_execsql_test joinB-180 {
  SELECT a, c, d, e, f, g
  FROM t1
  LEFT JOIN (t2 LEFT JOIN t3 USING(a)) USING(a)
  RIGHT JOIN (t4 LEFT JOIN t5 USING(a)) USING(a)
  WHERE a<=18
  ORDER BY 1 NULLS FIRST;
} {
  11 31  -  - 31  -
  13  -  -  - 33  -
  15 35 35 35 35 35
}
do_execsql_test joinB-181 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  LEFT JOIN t2 USING(a)
  LEFT JOIN t3 USING(a)
  RIGHT JOIN t4 USING(a)
  RIGHT JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  15 15 15 15 15 15
  17  -  -  -  - 17
  18  -  -  -  - 18
  19  -  -  - 19 19
}
do_execsql_test joinB-182 {
  SELECT a, b, c, d, e, f, g
  FROM t1
  LEFT JOIN t2 USING(a,b)
  LEFT JOIN t3 USING(a,b)
  RIGHT JOIN t4 USING(a,b)
  RIGHT JOIN t5 USING(a,b)
  WHERE d<>33 OR d IS NULL
  ORDER BY 1 NULLS FIRST;
} {
  15 25 35 35 35 35 35
  17 27  -  -  -  - 37
  18 28  -  -  -  - 38
  19 29  -  -  - 39 39
}
do_execsql_test joinB-183 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  LEFT JOIN t2 USING(a)
  LEFT JOIN t3 USING(a)
  RIGHT JOIN t4 USING(a)
  FULL JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  11 11  - 11 11  -
  13  -  -  - 13  -
  15 15 15 15 15 15
  17  -  -  -  - 17
  18  -  -  -  - 18
  19  -  -  - 19 19
}
do_execsql_test joinB-184 {
  SELECT b, c, d, e, f, g
  FROM t1
  NATURAL LEFT JOIN t2
  NATURAL LEFT JOIN t3
  NATURAL RIGHT JOIN t4
  NATURAL FULL JOIN t5
  WHERE b BETWEEN 12 AND 17
  ORDER BY 1 NULLS FIRST;
} {
}
do_execsql_test joinB-185 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  LEFT JOIN t2 USING(a)
  LEFT JOIN t3 USING(a)
  FULL JOIN t4 USING(a)
  INNER JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  15 15 15 15 15 15
  17 17  - 17  - 17
  19  -  -  - 19 19
}
do_execsql_test joinB-186 {
  SELECT a, c, d, e, f, g
  FROM t1
  LEFT JOIN t2 USING(a,b)
  LEFT JOIN t3 USING(a,b)
  FULL JOIN t4 USING(a,b)
  INNER JOIN t5 USING(a,b)
  WHERE a<>13
  ORDER BY 1 NULLS FIRST;
} {
  15 35 35 35 35 35
  17 37  - 37  - 37
  19  -  -  - 39 39
}
do_execsql_test joinB-187 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  LEFT JOIN t2 USING(a)
  LEFT JOIN t3 USING(a)
  FULL JOIN t4 USING(a)
  LEFT JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  11 11  - 11 11  -
  12 12 12 12  -  -
  13  -  -  - 13  -
  15 15 15 15 15 15
  17 17  - 17  - 17
  19  -  -  - 19 19
}
do_execsql_test joinB-188 {
  SELECT a, c, d, e, f, g
  FROM t1
  LEFT JOIN (t2 LEFT JOIN t3 USING(a)) USING(a)
  FULL JOIN (t4 LEFT JOIN t5 USING(a)) USING(a)
  WHERE a<=18
  ORDER BY 1 NULLS FIRST;
} {
  11 31  -  - 31  -
  12 32 32 32  -  -
  13  -  -  - 33  -
  15 35 35 35 35 35
  17 37  -  -  -  -
}
do_execsql_test joinB-189 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  LEFT JOIN t2 USING(a)
  LEFT JOIN t3 USING(a)
  FULL JOIN t4 USING(a)
  RIGHT JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  15 15 15 15 15 15
  17 17  - 17  - 17
  18  -  -  -  - 18
  19  -  -  - 19 19
}
do_execsql_test joinB-190 {
  SELECT a, b, c, d, e, f, g
  FROM t1
  LEFT JOIN t2 USING(a,b)
  LEFT JOIN t3 USING(a,b)
  FULL JOIN t4 USING(a,b)
  RIGHT JOIN t5 USING(a,b)
  WHERE d<>33 OR d IS NULL
  ORDER BY 1 NULLS FIRST;
} {
  15 25 35 35 35 35 35
  17 27 37  - 37  - 37
  18 28  -  -  -  - 38
  19 29  -  -  - 39 39
}
do_execsql_test joinB-191 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  LEFT JOIN t2 USING(a)
  LEFT JOIN t3 USING(a)
  FULL JOIN t4 USING(a)
  FULL JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  11 11  - 11 11  -
  12 12 12 12  -  -
  13  -  -  - 13  -
  15 15 15 15 15 15
  17 17  - 17  - 17
  18  -  -  -  - 18
  19  -  -  - 19 19
}
do_execsql_test joinB-192 {
  SELECT b, c, d, e, f, g
  FROM t1
  NATURAL LEFT JOIN t2
  NATURAL LEFT JOIN t3
  NATURAL FULL JOIN t4
  NATURAL FULL JOIN t5
  WHERE b BETWEEN 12 AND 17
  ORDER BY 1 NULLS FIRST;
} {
}
do_execsql_test joinB-193 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  LEFT JOIN t2 USING(a)
  RIGHT JOIN t3 USING(a)
  INNER JOIN t4 USING(a)
  INNER JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  15 15 15 15 15 15
  19  -  - 19 19 19
}
do_execsql_test joinB-194 {
  SELECT a, c, d, e, f, g
  FROM t1
  LEFT JOIN t2 USING(a,b)
  RIGHT JOIN t3 USING(a,b)
  INNER JOIN t4 USING(a,b)
  INNER JOIN t5 USING(a,b)
  WHERE a<>13
  ORDER BY 1 NULLS FIRST;
} {
  15 35 35 35 35 35
  19  -  - 39 39 39
}
do_execsql_test joinB-195 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  LEFT JOIN t2 USING(a)
  RIGHT JOIN t3 USING(a)
  INNER JOIN t4 USING(a)
  LEFT JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  11 11  - 11 11  -
  13  -  - 13 13  -
  15 15 15 15 15 15
  19  -  - 19 19 19
}
do_execsql_test joinB-196 {
  SELECT a, c, d, e, f, g
  FROM t1
  LEFT JOIN (t2 RIGHT JOIN t3 USING(a)) USING(a)
  INNER JOIN (t4 LEFT JOIN t5 USING(a)) USING(a)
  WHERE a<=18
  ORDER BY 1 NULLS FIRST;
} {
  11 31  - 31 31  -
  15 35 35 35 35 35
}
do_execsql_test joinB-197 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  LEFT JOIN t2 USING(a)
  RIGHT JOIN t3 USING(a)
  INNER JOIN t4 USING(a)
  RIGHT JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  15 15 15 15 15 15
  17  -  -  -  - 17
  18  -  -  -  - 18
  19  -  - 19 19 19
}
do_execsql_test joinB-198 {
  SELECT a, b, c, d, e, f, g
  FROM t1
  LEFT JOIN t2 USING(a,b)
  RIGHT JOIN t3 USING(a,b)
  INNER JOIN t4 USING(a,b)
  RIGHT JOIN t5 USING(a,b)
  WHERE d<>33 OR d IS NULL
  ORDER BY 1 NULLS FIRST;
} {
  15 25 35 35 35 35 35
  17 27  -  -  -  - 37
  18 28  -  -  -  - 38
  19 29  -  - 39 39 39
}
do_execsql_test joinB-199 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  LEFT JOIN t2 USING(a)
  RIGHT JOIN t3 USING(a)
  INNER JOIN t4 USING(a)
  FULL JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  11 11  - 11 11  -
  13  -  - 13 13  -
  15 15 15 15 15 15
  17  -  -  -  - 17
  18  -  -  -  - 18
  19  -  - 19 19 19
}
do_execsql_test joinB-200 {
  SELECT b, c, d, e, f, g
  FROM t1
  NATURAL LEFT JOIN t2
  NATURAL RIGHT JOIN t3
  NATURAL INNER JOIN t4
  NATURAL FULL JOIN t5
  WHERE b BETWEEN 12 AND 17
  ORDER BY 1 NULLS FIRST;
} {
}
do_execsql_test joinB-201 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  LEFT JOIN t2 USING(a)
  RIGHT JOIN t3 USING(a)
  LEFT JOIN t4 USING(a)
  INNER JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  15 15 15 15 15 15
  17 17  - 17  - 17
  18  -  - 18  - 18
  19  -  - 19 19 19
}
do_execsql_test joinB-202 {
  SELECT a, c, d, e, f, g
  FROM t1
  LEFT JOIN t2 USING(a,b)
  RIGHT JOIN t3 USING(a,b)
  LEFT JOIN t4 USING(a,b)
  INNER JOIN t5 USING(a,b)
  WHERE a<>13
  ORDER BY 1 NULLS FIRST;
} {
  15 35 35 35 35 35
  17 37  - 37  - 37
  18  -  - 38  - 38
  19  -  - 39 39 39
}
do_execsql_test joinB-203 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  LEFT JOIN t2 USING(a)
  RIGHT JOIN t3 USING(a)
  LEFT JOIN t4 USING(a)
  LEFT JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
   -  -  -  -  -  -
  11 11  - 11 11  -
  12 12 12 12  -  -
  13  -  - 13 13  -
  15 15 15 15 15 15
  17 17  - 17  - 17
  18  -  - 18  - 18
  19  -  - 19 19 19
}
do_execsql_test joinB-204 {
  SELECT a, c, d, e, f, g
  FROM t1
  LEFT JOIN (t2 RIGHT JOIN t3 USING(a)) USING(a)
  LEFT JOIN (t4 LEFT JOIN t5 USING(a)) USING(a)
  WHERE a<=18
  ORDER BY 1 NULLS FIRST;
} {
  11 31  - 31 31  -
  12 32 32 32  -  -
  15 35 35 35 35 35
  17 37  - 37  -  -
}
do_execsql_test joinB-205 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  LEFT JOIN t2 USING(a)
  RIGHT JOIN t3 USING(a)
  LEFT JOIN t4 USING(a)
  RIGHT JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  15 15 15 15 15 15
  17 17  - 17  - 17
  18  -  - 18  - 18
  19  -  - 19 19 19
}
do_execsql_test joinB-206 {
  SELECT a, b, c, d, e, f, g
  FROM t1
  LEFT JOIN t2 USING(a,b)
  RIGHT JOIN t3 USING(a,b)
  LEFT JOIN t4 USING(a,b)
  RIGHT JOIN t5 USING(a,b)
  WHERE d<>33 OR d IS NULL
  ORDER BY 1 NULLS FIRST;
} {
  15 25 35 35 35 35 35
  17 27 37  - 37  - 37
  18 28  -  - 38  - 38
  19 29  -  - 39 39 39
}
do_execsql_test joinB-207 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  LEFT JOIN t2 USING(a)
  RIGHT JOIN t3 USING(a)
  LEFT JOIN t4 USING(a)
  FULL JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
   -  -  -  -  -  -
  11 11  - 11 11  -
  12 12 12 12  -  -
  13  -  - 13 13  -
  15 15 15 15 15 15
  17 17  - 17  - 17
  18  -  - 18  - 18
  19  -  - 19 19 19
}
do_execsql_test joinB-208 {
  SELECT b, c, d, e, f, g
  FROM t1
  NATURAL LEFT JOIN t2
  NATURAL RIGHT JOIN t3
  NATURAL LEFT JOIN t4
  NATURAL FULL JOIN t5
  WHERE b BETWEEN 12 AND 17
  ORDER BY 1 NULLS FIRST;
} {
}
do_execsql_test joinB-209 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  LEFT JOIN t2 USING(a)
  RIGHT JOIN t3 USING(a)
  RIGHT JOIN t4 USING(a)
  INNER JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  15 15 15 15 15 15
  19  -  - 19 19 19
}
do_execsql_test joinB-210 {
  SELECT a, c, d, e, f, g
  FROM t1
  LEFT JOIN t2 USING(a,b)
  RIGHT JOIN t3 USING(a,b)
  RIGHT JOIN t4 USING(a,b)
  INNER JOIN t5 USING(a,b)
  WHERE a<>13
  ORDER BY 1 NULLS FIRST;
} {
  15 35 35 35 35 35
  19  -  - 39 39 39
}
do_execsql_test joinB-211 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  LEFT JOIN t2 USING(a)
  RIGHT JOIN t3 USING(a)
  RIGHT JOIN t4 USING(a)
  LEFT JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  11 11  - 11 11  -
  13  -  - 13 13  -
  15 15 15 15 15 15
  19  -  - 19 19 19
}
do_execsql_test joinB-212 {
  SELECT a, c, d, e, f, g
  FROM t1
  LEFT JOIN (t2 RIGHT JOIN t3 USING(a)) USING(a)
  RIGHT JOIN (t4 LEFT JOIN t5 USING(a)) USING(a)
  WHERE a<=18
  ORDER BY 1 NULLS FIRST;
} {
  11 31  - 31 31  -
  13  -  -  - 33  -
  15 35 35 35 35 35
}
do_execsql_test joinB-213 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  LEFT JOIN t2 USING(a)
  RIGHT JOIN t3 USING(a)
  RIGHT JOIN t4 USING(a)
  RIGHT JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  15 15 15 15 15 15
  17  -  -  -  - 17
  18  -  -  -  - 18
  19  -  - 19 19 19
}
do_execsql_test joinB-214 {
  SELECT a, b, c, d, e, f, g
  FROM t1
  LEFT JOIN t2 USING(a,b)
  RIGHT JOIN t3 USING(a,b)
  RIGHT JOIN t4 USING(a,b)
  RIGHT JOIN t5 USING(a,b)
  WHERE d<>33 OR d IS NULL
  ORDER BY 1 NULLS FIRST;
} {
  15 25 35 35 35 35 35
  17 27  -  -  -  - 37
  18 28  -  -  -  - 38
  19 29  -  - 39 39 39
}
do_execsql_test joinB-215 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  LEFT JOIN t2 USING(a)
  RIGHT JOIN t3 USING(a)
  RIGHT JOIN t4 USING(a)
  FULL JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  11 11  - 11 11  -
  13  -  - 13 13  -
  15 15 15 15 15 15
  17  -  -  -  - 17
  18  -  -  -  - 18
  19  -  - 19 19 19
}
do_execsql_test joinB-216 {
  SELECT b, c, d, e, f, g
  FROM t1
  NATURAL LEFT JOIN t2
  NATURAL RIGHT JOIN t3
  NATURAL RIGHT JOIN t4
  NATURAL FULL JOIN t5
  WHERE b BETWEEN 12 AND 17
  ORDER BY 1 NULLS FIRST;
} {
}
do_execsql_test joinB-217 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  LEFT JOIN t2 USING(a)
  RIGHT JOIN t3 USING(a)
  FULL JOIN t4 USING(a)
  INNER JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  15 15 15 15 15 15
  17 17  - 17  - 17
  18  -  - 18  - 18
  19  -  - 19 19 19
}
do_execsql_test joinB-218 {
  SELECT a, c, d, e, f, g
  FROM t1
  LEFT JOIN t2 USING(a,b)
  RIGHT JOIN t3 USING(a,b)
  FULL JOIN t4 USING(a,b)
  INNER JOIN t5 USING(a,b)
  WHERE a<>13
  ORDER BY 1 NULLS FIRST;
} {
  15 35 35 35 35 35
  17 37  - 37  - 37
  18  -  - 38  - 38
  19  -  - 39 39 39
}
do_execsql_test joinB-219 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  LEFT JOIN t2 USING(a)
  RIGHT JOIN t3 USING(a)
  FULL JOIN t4 USING(a)
  LEFT JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
   -  -  -  -  -  -
  11 11  - 11 11  -
  12 12 12 12  -  -
  13  -  - 13 13  -
  15 15 15 15 15 15
  17 17  - 17  - 17
  18  -  - 18  - 18
  19  -  - 19 19 19
}
do_execsql_test joinB-220 {
  SELECT a, c, d, e, f, g
  FROM t1
  LEFT JOIN (t2 RIGHT JOIN t3 USING(a)) USING(a)
  FULL JOIN (t4 LEFT JOIN t5 USING(a)) USING(a)
  WHERE a<=18
  ORDER BY 1 NULLS FIRST;
} {
  11 31  - 31 31  -
  12 32 32 32  -  -
  13  -  -  - 33  -
  15 35 35 35 35 35
  17 37  - 37  -  -
}
do_execsql_test joinB-221 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  LEFT JOIN t2 USING(a)
  RIGHT JOIN t3 USING(a)
  FULL JOIN t4 USING(a)
  RIGHT JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  15 15 15 15 15 15
  17 17  - 17  - 17
  18  -  - 18  - 18
  19  -  - 19 19 19
}
do_execsql_test joinB-222 {
  SELECT a, b, c, d, e, f, g
  FROM t1
  LEFT JOIN t2 USING(a,b)
  RIGHT JOIN t3 USING(a,b)
  FULL JOIN t4 USING(a,b)
  RIGHT JOIN t5 USING(a,b)
  WHERE d<>33 OR d IS NULL
  ORDER BY 1 NULLS FIRST;
} {
  15 25 35 35 35 35 35
  17 27 37  - 37  - 37
  18 28  -  - 38  - 38
  19 29  -  - 39 39 39
}
do_execsql_test joinB-223 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  LEFT JOIN t2 USING(a)
  RIGHT JOIN t3 USING(a)
  FULL JOIN t4 USING(a)
  FULL JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
   -  -  -  -  -  -
  11 11  - 11 11  -
  12 12 12 12  -  -
  13  -  - 13 13  -
  15 15 15 15 15 15
  17 17  - 17  - 17
  18  -  - 18  - 18
  19  -  - 19 19 19
}
do_execsql_test joinB-224 {
  SELECT b, c, d, e, f, g
  FROM t1
  NATURAL LEFT JOIN t2
  NATURAL RIGHT JOIN t3
  NATURAL FULL JOIN t4
  NATURAL FULL JOIN t5
  WHERE b BETWEEN 12 AND 17
  ORDER BY 1 NULLS FIRST;
} {
}
do_execsql_test joinB-225 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  LEFT JOIN t2 USING(a)
  FULL JOIN t3 USING(a)
  INNER JOIN t4 USING(a)
  INNER JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  15 15 15 15 15 15
  19  -  - 19 19 19
}
do_execsql_test joinB-226 {
  SELECT a, c, d, e, f, g
  FROM t1
  LEFT JOIN t2 USING(a,b)
  FULL JOIN t3 USING(a,b)
  INNER JOIN t4 USING(a,b)
  INNER JOIN t5 USING(a,b)
  WHERE a<>13
  ORDER BY 1 NULLS FIRST;
} {
  15 35 35 35 35 35
  19  -  - 39 39 39
}
do_execsql_test joinB-227 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  LEFT JOIN t2 USING(a)
  FULL JOIN t3 USING(a)
  INNER JOIN t4 USING(a)
  LEFT JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  11 11  - 11 11  -
  13  -  - 13 13  -
  15 15 15 15 15 15
  19  -  - 19 19 19
}
do_execsql_test joinB-228 {
  SELECT a, c, d, e, f, g
  FROM t1
  LEFT JOIN (t2 FULL JOIN t3 USING(a)) USING(a)
  INNER JOIN (t4 LEFT JOIN t5 USING(a)) USING(a)
  WHERE a<=18
  ORDER BY 1 NULLS FIRST;
} {
  11 31  - 31 31  -
  15 35 35 35 35 35
}
do_execsql_test joinB-229 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  LEFT JOIN t2 USING(a)
  FULL JOIN t3 USING(a)
  INNER JOIN t4 USING(a)
  RIGHT JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  15 15 15 15 15 15
  17  -  -  -  - 17
  18  -  -  -  - 18
  19  -  - 19 19 19
}
do_execsql_test joinB-230 {
  SELECT a, b, c, d, e, f, g
  FROM t1
  LEFT JOIN t2 USING(a,b)
  FULL JOIN t3 USING(a,b)
  INNER JOIN t4 USING(a,b)
  RIGHT JOIN t5 USING(a,b)
  WHERE d<>33 OR d IS NULL
  ORDER BY 1 NULLS FIRST;
} {
  15 25 35 35 35 35 35
  17 27  -  -  -  - 37
  18 28  -  -  -  - 38
  19 29  -  - 39 39 39
}
do_execsql_test joinB-231 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  LEFT JOIN t2 USING(a)
  FULL JOIN t3 USING(a)
  INNER JOIN t4 USING(a)
  FULL JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  11 11  - 11 11  -
  13  -  - 13 13  -
  15 15 15 15 15 15
  17  -  -  -  - 17
  18  -  -  -  - 18
  19  -  - 19 19 19
}
do_execsql_test joinB-232 {
  SELECT b, c, d, e, f, g
  FROM t1
  NATURAL LEFT JOIN t2
  NATURAL FULL JOIN t3
  NATURAL INNER JOIN t4
  NATURAL FULL JOIN t5
  WHERE b BETWEEN 12 AND 17
  ORDER BY 1 NULLS FIRST;
} {
}
do_execsql_test joinB-233 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  LEFT JOIN t2 USING(a)
  FULL JOIN t3 USING(a)
  LEFT JOIN t4 USING(a)
  INNER JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  15 15 15 15 15 15
  17 17  - 17  - 17
  18  -  - 18  - 18
  19  -  - 19 19 19
}
do_execsql_test joinB-234 {
  SELECT a, c, d, e, f, g
  FROM t1
  LEFT JOIN t2 USING(a,b)
  FULL JOIN t3 USING(a,b)
  LEFT JOIN t4 USING(a,b)
  INNER JOIN t5 USING(a,b)
  WHERE a<>13
  ORDER BY 1 NULLS FIRST;
} {
  15 35 35 35 35 35
  17 37  - 37  - 37
  18  -  - 38  - 38
  19  -  - 39 39 39
}
do_execsql_test joinB-235 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  LEFT JOIN t2 USING(a)
  FULL JOIN t3 USING(a)
  LEFT JOIN t4 USING(a)
  LEFT JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
   -  -  -  -  -  -
  11 11  - 11 11  -
  12 12 12 12  -  -
  13  -  - 13 13  -
  15 15 15 15 15 15
  17 17  - 17  - 17
  18  -  - 18  - 18
  19  -  - 19 19 19
}
do_execsql_test joinB-236 {
  SELECT a, c, d, e, f, g
  FROM t1
  LEFT JOIN (t2 FULL JOIN t3 USING(a)) USING(a)
  LEFT JOIN (t4 LEFT JOIN t5 USING(a)) USING(a)
  WHERE a<=18
  ORDER BY 1 NULLS FIRST;
} {
  11 31  - 31 31  -
  12 32 32 32  -  -
  15 35 35 35 35 35
  17 37  - 37  -  -
}
do_execsql_test joinB-237 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  LEFT JOIN t2 USING(a)
  FULL JOIN t3 USING(a)
  LEFT JOIN t4 USING(a)
  RIGHT JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  15 15 15 15 15 15
  17 17  - 17  - 17
  18  -  - 18  - 18
  19  -  - 19 19 19
}
do_execsql_test joinB-238 {
  SELECT a, b, c, d, e, f, g
  FROM t1
  LEFT JOIN t2 USING(a,b)
  FULL JOIN t3 USING(a,b)
  LEFT JOIN t4 USING(a,b)
  RIGHT JOIN t5 USING(a,b)
  WHERE d<>33 OR d IS NULL
  ORDER BY 1 NULLS FIRST;
} {
  15 25 35 35 35 35 35
  17 27 37  - 37  - 37
  18 28  -  - 38  - 38
  19 29  -  - 39 39 39
}
do_execsql_test joinB-239 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  LEFT JOIN t2 USING(a)
  FULL JOIN t3 USING(a)
  LEFT JOIN t4 USING(a)
  FULL JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
   -  -  -  -  -  -
  11 11  - 11 11  -
  12 12 12 12  -  -
  13  -  - 13 13  -
  15 15 15 15 15 15
  17 17  - 17  - 17
  18  -  - 18  - 18
  19  -  - 19 19 19
}
do_execsql_test joinB-240 {
  SELECT b, c, d, e, f, g
  FROM t1
  NATURAL LEFT JOIN t2
  NATURAL FULL JOIN t3
  NATURAL LEFT JOIN t4
  NATURAL FULL JOIN t5
  WHERE b BETWEEN 12 AND 17
  ORDER BY 1 NULLS FIRST;
} {
}
do_execsql_test joinB-241 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  LEFT JOIN t2 USING(a)
  FULL JOIN t3 USING(a)
  RIGHT JOIN t4 USING(a)
  INNER JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  15 15 15 15 15 15
  19  -  - 19 19 19
}
do_execsql_test joinB-242 {
  SELECT a, c, d, e, f, g
  FROM t1
  LEFT JOIN t2 USING(a,b)
  FULL JOIN t3 USING(a,b)
  RIGHT JOIN t4 USING(a,b)
  INNER JOIN t5 USING(a,b)
  WHERE a<>13
  ORDER BY 1 NULLS FIRST;
} {
  15 35 35 35 35 35
  19  -  - 39 39 39
}
do_execsql_test joinB-243 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  LEFT JOIN t2 USING(a)
  FULL JOIN t3 USING(a)
  RIGHT JOIN t4 USING(a)
  LEFT JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  11 11  - 11 11  -
  13  -  - 13 13  -
  15 15 15 15 15 15
  19  -  - 19 19 19
}
do_execsql_test joinB-244 {
  SELECT a, c, d, e, f, g
  FROM t1
  LEFT JOIN (t2 FULL JOIN t3 USING(a)) USING(a)
  RIGHT JOIN (t4 LEFT JOIN t5 USING(a)) USING(a)
  WHERE a<=18
  ORDER BY 1 NULLS FIRST;
} {
  11 31  - 31 31  -
  13  -  -  - 33  -
  15 35 35 35 35 35
}
do_execsql_test joinB-245 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  LEFT JOIN t2 USING(a)
  FULL JOIN t3 USING(a)
  RIGHT JOIN t4 USING(a)
  RIGHT JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  15 15 15 15 15 15
  17  -  -  -  - 17
  18  -  -  -  - 18
  19  -  - 19 19 19
}
do_execsql_test joinB-246 {
  SELECT a, b, c, d, e, f, g
  FROM t1
  LEFT JOIN t2 USING(a,b)
  FULL JOIN t3 USING(a,b)
  RIGHT JOIN t4 USING(a,b)
  RIGHT JOIN t5 USING(a,b)
  WHERE d<>33 OR d IS NULL
  ORDER BY 1 NULLS FIRST;
} {
  15 25 35 35 35 35 35
  17 27  -  -  -  - 37
  18 28  -  -  -  - 38
  19 29  -  - 39 39 39
}
do_execsql_test joinB-247 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  LEFT JOIN t2 USING(a)
  FULL JOIN t3 USING(a)
  RIGHT JOIN t4 USING(a)
  FULL JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  11 11  - 11 11  -
  13  -  - 13 13  -
  15 15 15 15 15 15
  17  -  -  -  - 17
  18  -  -  -  - 18
  19  -  - 19 19 19
}
do_execsql_test joinB-248 {
  SELECT b, c, d, e, f, g
  FROM t1
  NATURAL LEFT JOIN t2
  NATURAL FULL JOIN t3
  NATURAL RIGHT JOIN t4
  NATURAL FULL JOIN t5
  WHERE b BETWEEN 12 AND 17
  ORDER BY 1 NULLS FIRST;
} {
}
do_execsql_test joinB-249 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  LEFT JOIN t2 USING(a)
  FULL JOIN t3 USING(a)
  FULL JOIN t4 USING(a)
  INNER JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  15 15 15 15 15 15
  17 17  - 17  - 17
  18  -  - 18  - 18
  19  -  - 19 19 19
}
do_execsql_test joinB-250 {
  SELECT a, c, d, e, f, g
  FROM t1
  LEFT JOIN t2 USING(a,b)
  FULL JOIN t3 USING(a,b)
  FULL JOIN t4 USING(a,b)
  INNER JOIN t5 USING(a,b)
  WHERE a<>13
  ORDER BY 1 NULLS FIRST;
} {
  15 35 35 35 35 35
  17 37  - 37  - 37
  18  -  - 38  - 38
  19  -  - 39 39 39
}
do_execsql_test joinB-251 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  LEFT JOIN t2 USING(a)
  FULL JOIN t3 USING(a)
  FULL JOIN t4 USING(a)
  LEFT JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
   -  -  -  -  -  -
  11 11  - 11 11  -
  12 12 12 12  -  -
  13  -  - 13 13  -
  15 15 15 15 15 15
  17 17  - 17  - 17
  18  -  - 18  - 18
  19  -  - 19 19 19
}
do_execsql_test joinB-252 {
  SELECT a, c, d, e, f, g
  FROM t1
  LEFT JOIN (t2 FULL JOIN t3 USING(a)) USING(a)
  FULL JOIN (t4 LEFT JOIN t5 USING(a)) USING(a)
  WHERE a<=18
  ORDER BY 1 NULLS FIRST;
} {
  11 31  - 31 31  -
  12 32 32 32  -  -
  13  -  -  - 33  -
  15 35 35 35 35 35
  17 37  - 37  -  -
}
do_execsql_test joinB-253 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  LEFT JOIN t2 USING(a)
  FULL JOIN t3 USING(a)
  FULL JOIN t4 USING(a)
  RIGHT JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  15 15 15 15 15 15
  17 17  - 17  - 17
  18  -  - 18  - 18
  19  -  - 19 19 19
}
do_execsql_test joinB-254 {
  SELECT a, b, c, d, e, f, g
  FROM t1
  LEFT JOIN t2 USING(a,b)
  FULL JOIN t3 USING(a,b)
  FULL JOIN t4 USING(a,b)
  RIGHT JOIN t5 USING(a,b)
  WHERE d<>33 OR d IS NULL
  ORDER BY 1 NULLS FIRST;
} {
  15 25 35 35 35 35 35
  17 27 37  - 37  - 37
  18 28  -  - 38  - 38
  19 29  -  - 39 39 39
}
do_execsql_test joinB-255 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  LEFT JOIN t2 USING(a)
  FULL JOIN t3 USING(a)
  FULL JOIN t4 USING(a)
  FULL JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
   -  -  -  -  -  -
  11 11  - 11 11  -
  12 12 12 12  -  -
  13  -  - 13 13  -
  15 15 15 15 15 15
  17 17  - 17  - 17
  18  -  - 18  - 18
  19  -  - 19 19 19
}
do_execsql_test joinB-256 {
  SELECT b, c, d, e, f, g
  FROM t1
  NATURAL LEFT JOIN t2
  NATURAL FULL JOIN t3
  NATURAL FULL JOIN t4
  NATURAL FULL JOIN t5
  WHERE b BETWEEN 12 AND 17
  ORDER BY 1 NULLS FIRST;
} {
}
do_execsql_test joinB-257 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  RIGHT JOIN t2 USING(a)
  INNER JOIN t3 USING(a)
  INNER JOIN t4 USING(a)
  INNER JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  15 15 15 15 15 15
}
do_execsql_test joinB-258 {
  SELECT a, c, d, e, f, g
  FROM t1
  RIGHT JOIN t2 USING(a,b)
  INNER JOIN t3 USING(a,b)
  INNER JOIN t4 USING(a,b)
  INNER JOIN t5 USING(a,b)
  WHERE a<>13
  ORDER BY 1 NULLS FIRST;
} {
  15 35 35 35 35 35
}
do_execsql_test joinB-259 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  RIGHT JOIN t2 USING(a)
  INNER JOIN t3 USING(a)
  INNER JOIN t4 USING(a)
  LEFT JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  13  - 13 13 13  -
  15 15 15 15 15 15
}
do_execsql_test joinB-260 {
  SELECT a, c, d, e, f, g
  FROM t1
  RIGHT JOIN (t2 INNER JOIN t3 USING(a)) USING(a)
  INNER JOIN (t4 LEFT JOIN t5 USING(a)) USING(a)
  WHERE a<=18
  ORDER BY 1 NULLS FIRST;
} {
  13  - 33 33 33  -
  15 35 35 35 35 35
}
do_execsql_test joinB-261 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  RIGHT JOIN t2 USING(a)
  INNER JOIN t3 USING(a)
  INNER JOIN t4 USING(a)
  RIGHT JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  15 15 15 15 15 15
  17  -  -  -  - 17
  18  -  -  -  - 18
  19  -  -  -  - 19
}
do_execsql_test joinB-262 {
  SELECT a, b, c, d, e, f, g
  FROM t1
  RIGHT JOIN t2 USING(a,b)
  INNER JOIN t3 USING(a,b)
  INNER JOIN t4 USING(a,b)
  RIGHT JOIN t5 USING(a,b)
  WHERE d<>33 OR d IS NULL
  ORDER BY 1 NULLS FIRST;
} {
  15 25 35 35 35 35 35
  17 27  -  -  -  - 37
  18 28  -  -  -  - 38
  19 29  -  -  -  - 39
}
do_execsql_test joinB-263 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  RIGHT JOIN t2 USING(a)
  INNER JOIN t3 USING(a)
  INNER JOIN t4 USING(a)
  FULL JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  13  - 13 13 13  -
  15 15 15 15 15 15
  17  -  -  -  - 17
  18  -  -  -  - 18
  19  -  -  -  - 19
}
do_execsql_test joinB-264 {
  SELECT b, c, d, e, f, g
  FROM t1
  NATURAL RIGHT JOIN t2
  NATURAL INNER JOIN t3
  NATURAL INNER JOIN t4
  NATURAL FULL JOIN t5
  WHERE b BETWEEN 12 AND 17
  ORDER BY 1 NULLS FIRST;
} {
}
do_execsql_test joinB-265 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  RIGHT JOIN t2 USING(a)
  INNER JOIN t3 USING(a)
  LEFT JOIN t4 USING(a)
  INNER JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  15 15 15 15 15 15
  18  - 18 18  - 18
}
do_execsql_test joinB-266 {
  SELECT a, c, d, e, f, g
  FROM t1
  RIGHT JOIN t2 USING(a,b)
  INNER JOIN t3 USING(a,b)
  LEFT JOIN t4 USING(a,b)
  INNER JOIN t5 USING(a,b)
  WHERE a<>13
  ORDER BY 1 NULLS FIRST;
} {
  15 35 35 35 35 35
  18  - 38 38  - 38
}
do_execsql_test joinB-267 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  RIGHT JOIN t2 USING(a)
  INNER JOIN t3 USING(a)
  LEFT JOIN t4 USING(a)
  LEFT JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  12 12 12 12  -  -
  13  - 13 13 13  -
  15 15 15 15 15 15
  18  - 18 18  - 18
}
do_execsql_test joinB-268 {
  SELECT a, c, d, e, f, g
  FROM t1
  RIGHT JOIN (t2 INNER JOIN t3 USING(a)) USING(a)
  LEFT JOIN (t4 LEFT JOIN t5 USING(a)) USING(a)
  WHERE a<=18
  ORDER BY 1 NULLS FIRST;
} {
  12 32 32 32  -  -
  13  - 33 33 33  -
  15 35 35 35 35 35
  18  - 38 38  -  -
}
do_execsql_test joinB-269 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  RIGHT JOIN t2 USING(a)
  INNER JOIN t3 USING(a)
  LEFT JOIN t4 USING(a)
  RIGHT JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  15 15 15 15 15 15
  17  -  -  -  - 17
  18  - 18 18  - 18
  19  -  -  -  - 19
}
do_execsql_test joinB-270 {
  SELECT a, b, c, d, e, f, g
  FROM t1
  RIGHT JOIN t2 USING(a,b)
  INNER JOIN t3 USING(a,b)
  LEFT JOIN t4 USING(a,b)
  RIGHT JOIN t5 USING(a,b)
  WHERE d<>33 OR d IS NULL
  ORDER BY 1 NULLS FIRST;
} {
  15 25 35 35 35 35 35
  17 27  -  -  -  - 37
  18 28  - 38 38  - 38
  19 29  -  -  -  - 39
}
do_execsql_test joinB-271 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  RIGHT JOIN t2 USING(a)
  INNER JOIN t3 USING(a)
  LEFT JOIN t4 USING(a)
  FULL JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  12 12 12 12  -  -
  13  - 13 13 13  -
  15 15 15 15 15 15
  17  -  -  -  - 17
  18  - 18 18  - 18
  19  -  -  -  - 19
}
do_execsql_test joinB-272 {
  SELECT b, c, d, e, f, g
  FROM t1
  NATURAL RIGHT JOIN t2
  NATURAL INNER JOIN t3
  NATURAL LEFT JOIN t4
  NATURAL FULL JOIN t5
  WHERE b BETWEEN 12 AND 17
  ORDER BY 1 NULLS FIRST;
} {
}
do_execsql_test joinB-273 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  RIGHT JOIN t2 USING(a)
  INNER JOIN t3 USING(a)
  RIGHT JOIN t4 USING(a)
  INNER JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  15 15 15 15 15 15
  19  -  -  - 19 19
}
do_execsql_test joinB-274 {
  SELECT a, c, d, e, f, g
  FROM t1
  RIGHT JOIN t2 USING(a,b)
  INNER JOIN t3 USING(a,b)
  RIGHT JOIN t4 USING(a,b)
  INNER JOIN t5 USING(a,b)
  WHERE a<>13
  ORDER BY 1 NULLS FIRST;
} {
  15 35 35 35 35 35
  19  -  -  - 39 39
}
do_execsql_test joinB-275 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  RIGHT JOIN t2 USING(a)
  INNER JOIN t3 USING(a)
  RIGHT JOIN t4 USING(a)
  LEFT JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  11  -  -  - 11  -
  13  - 13 13 13  -
  15 15 15 15 15 15
  19  -  -  - 19 19
}
do_execsql_test joinB-276 {
  SELECT a, c, d, e, f, g
  FROM t1
  RIGHT JOIN (t2 INNER JOIN t3 USING(a)) USING(a)
  RIGHT JOIN (t4 LEFT JOIN t5 USING(a)) USING(a)
  WHERE a<=18
  ORDER BY 1 NULLS FIRST;
} {
  11  -  -  - 31  -
  13  - 33 33 33  -
  15 35 35 35 35 35
}
do_execsql_test joinB-277 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  RIGHT JOIN t2 USING(a)
  INNER JOIN t3 USING(a)
  RIGHT JOIN t4 USING(a)
  RIGHT JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  15 15 15 15 15 15
  17  -  -  -  - 17
  18  -  -  -  - 18
  19  -  -  - 19 19
}
do_execsql_test joinB-278 {
  SELECT a, b, c, d, e, f, g
  FROM t1
  RIGHT JOIN t2 USING(a,b)
  INNER JOIN t3 USING(a,b)
  RIGHT JOIN t4 USING(a,b)
  RIGHT JOIN t5 USING(a,b)
  WHERE d<>33 OR d IS NULL
  ORDER BY 1 NULLS FIRST;
} {
  15 25 35 35 35 35 35
  17 27  -  -  -  - 37
  18 28  -  -  -  - 38
  19 29  -  -  - 39 39
}
do_execsql_test joinB-279 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  RIGHT JOIN t2 USING(a)
  INNER JOIN t3 USING(a)
  RIGHT JOIN t4 USING(a)
  FULL JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  11  -  -  - 11  -
  13  - 13 13 13  -
  15 15 15 15 15 15
  17  -  -  -  - 17
  18  -  -  -  - 18
  19  -  -  - 19 19
}
do_execsql_test joinB-280 {
  SELECT b, c, d, e, f, g
  FROM t1
  NATURAL RIGHT JOIN t2
  NATURAL INNER JOIN t3
  NATURAL RIGHT JOIN t4
  NATURAL FULL JOIN t5
  WHERE b BETWEEN 12 AND 17
  ORDER BY 1 NULLS FIRST;
} {
}
do_execsql_test joinB-281 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  RIGHT JOIN t2 USING(a)
  INNER JOIN t3 USING(a)
  FULL JOIN t4 USING(a)
  INNER JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  15 15 15 15 15 15
  18  - 18 18  - 18
  19  -  -  - 19 19
}
do_execsql_test joinB-282 {
  SELECT a, c, d, e, f, g
  FROM t1
  RIGHT JOIN t2 USING(a,b)
  INNER JOIN t3 USING(a,b)
  FULL JOIN t4 USING(a,b)
  INNER JOIN t5 USING(a,b)
  WHERE a<>13
  ORDER BY 1 NULLS FIRST;
} {
  15 35 35 35 35 35
  18  - 38 38  - 38
  19  -  -  - 39 39
}
do_execsql_test joinB-283 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  RIGHT JOIN t2 USING(a)
  INNER JOIN t3 USING(a)
  FULL JOIN t4 USING(a)
  LEFT JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  11  -  -  - 11  -
  12 12 12 12  -  -
  13  - 13 13 13  -
  15 15 15 15 15 15
  18  - 18 18  - 18
  19  -  -  - 19 19
}
do_execsql_test joinB-284 {
  SELECT a, c, d, e, f, g
  FROM t1
  RIGHT JOIN (t2 INNER JOIN t3 USING(a)) USING(a)
  FULL JOIN (t4 LEFT JOIN t5 USING(a)) USING(a)
  WHERE a<=18
  ORDER BY 1 NULLS FIRST;
} {
  11  -  -  - 31  -
  12 32 32 32  -  -
  13  - 33 33 33  -
  15 35 35 35 35 35
  18  - 38 38  -  -
}
do_execsql_test joinB-285 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  RIGHT JOIN t2 USING(a)
  INNER JOIN t3 USING(a)
  FULL JOIN t4 USING(a)
  RIGHT JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  15 15 15 15 15 15
  17  -  -  -  - 17
  18  - 18 18  - 18
  19  -  -  - 19 19
}
do_execsql_test joinB-286 {
  SELECT a, b, c, d, e, f, g
  FROM t1
  RIGHT JOIN t2 USING(a,b)
  INNER JOIN t3 USING(a,b)
  FULL JOIN t4 USING(a,b)
  RIGHT JOIN t5 USING(a,b)
  WHERE d<>33 OR d IS NULL
  ORDER BY 1 NULLS FIRST;
} {
  15 25 35 35 35 35 35
  17 27  -  -  -  - 37
  18 28  - 38 38  - 38
  19 29  -  -  - 39 39
}
do_execsql_test joinB-287 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  RIGHT JOIN t2 USING(a)
  INNER JOIN t3 USING(a)
  FULL JOIN t4 USING(a)
  FULL JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  11  -  -  - 11  -
  12 12 12 12  -  -
  13  - 13 13 13  -
  15 15 15 15 15 15
  17  -  -  -  - 17
  18  - 18 18  - 18
  19  -  -  - 19 19
}
do_execsql_test joinB-288 {
  SELECT b, c, d, e, f, g
  FROM t1
  NATURAL RIGHT JOIN t2
  NATURAL INNER JOIN t3
  NATURAL FULL JOIN t4
  NATURAL FULL JOIN t5
  WHERE b BETWEEN 12 AND 17
  ORDER BY 1 NULLS FIRST;
} {
}
do_execsql_test joinB-289 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  RIGHT JOIN t2 USING(a)
  LEFT JOIN t3 USING(a)
  INNER JOIN t4 USING(a)
  INNER JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  15 15 15 15 15 15
}
do_execsql_test joinB-290 {
  SELECT a, c, d, e, f, g
  FROM t1
  RIGHT JOIN t2 USING(a,b)
  LEFT JOIN t3 USING(a,b)
  INNER JOIN t4 USING(a,b)
  INNER JOIN t5 USING(a,b)
  WHERE a<>13
  ORDER BY 1 NULLS FIRST;
} {
  15 35 35 35 35 35
}
do_execsql_test joinB-291 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  RIGHT JOIN t2 USING(a)
  LEFT JOIN t3 USING(a)
  INNER JOIN t4 USING(a)
  LEFT JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  13  - 13 13 13  -
  15 15 15 15 15 15
}
do_execsql_test joinB-292 {
  SELECT a, c, d, e, f, g
  FROM t1
  RIGHT JOIN (t2 LEFT JOIN t3 USING(a)) USING(a)
  INNER JOIN (t4 LEFT JOIN t5 USING(a)) USING(a)
  WHERE a<=18
  ORDER BY 1 NULLS FIRST;
} {
  13  - 33 33 33  -
  15 35 35 35 35 35
}
do_execsql_test joinB-293 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  RIGHT JOIN t2 USING(a)
  LEFT JOIN t3 USING(a)
  INNER JOIN t4 USING(a)
  RIGHT JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  15 15 15 15 15 15
  17  -  -  -  - 17
  18  -  -  -  - 18
  19  -  -  -  - 19
}
do_execsql_test joinB-294 {
  SELECT a, b, c, d, e, f, g
  FROM t1
  RIGHT JOIN t2 USING(a,b)
  LEFT JOIN t3 USING(a,b)
  INNER JOIN t4 USING(a,b)
  RIGHT JOIN t5 USING(a,b)
  WHERE d<>33 OR d IS NULL
  ORDER BY 1 NULLS FIRST;
} {
  15 25 35 35 35 35 35
  17 27  -  -  -  - 37
  18 28  -  -  -  - 38
  19 29  -  -  -  - 39
}
do_execsql_test joinB-295 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  RIGHT JOIN t2 USING(a)
  LEFT JOIN t3 USING(a)
  INNER JOIN t4 USING(a)
  FULL JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  13  - 13 13 13  -
  15 15 15 15 15 15
  17  -  -  -  - 17
  18  -  -  -  - 18
  19  -  -  -  - 19
}
do_execsql_test joinB-296 {
  SELECT b, c, d, e, f, g
  FROM t1
  NATURAL RIGHT JOIN t2
  NATURAL LEFT JOIN t3
  NATURAL INNER JOIN t4
  NATURAL FULL JOIN t5
  WHERE b BETWEEN 12 AND 17
  ORDER BY 1 NULLS FIRST;
} {
}
do_execsql_test joinB-297 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  RIGHT JOIN t2 USING(a)
  LEFT JOIN t3 USING(a)
  LEFT JOIN t4 USING(a)
  INNER JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  15 15 15 15 15 15
  18  - 18 18  - 18
}
do_execsql_test joinB-298 {
  SELECT a, c, d, e, f, g
  FROM t1
  RIGHT JOIN t2 USING(a,b)
  LEFT JOIN t3 USING(a,b)
  LEFT JOIN t4 USING(a,b)
  INNER JOIN t5 USING(a,b)
  WHERE a<>13
  ORDER BY 1 NULLS FIRST;
} {
  15 35 35 35 35 35
  18  - 38 38  - 38
}
do_execsql_test joinB-299 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  RIGHT JOIN t2 USING(a)
  LEFT JOIN t3 USING(a)
  LEFT JOIN t4 USING(a)
  LEFT JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
   -  -  -  -  -  -
  12 12 12 12  -  -
  13  - 13 13 13  -
  15 15 15 15 15 15
  18  - 18 18  - 18
}
do_execsql_test joinB-300 {
  SELECT a, c, d, e, f, g
  FROM t1
  RIGHT JOIN (t2 LEFT JOIN t3 USING(a)) USING(a)
  LEFT JOIN (t4 LEFT JOIN t5 USING(a)) USING(a)
  WHERE a<=18
  ORDER BY 1 NULLS FIRST;
} {
  12 32 32 32  -  -
  13  - 33 33 33  -
  15 35 35 35 35 35
  18  - 38 38  -  -
}
do_execsql_test joinB-301 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  RIGHT JOIN t2 USING(a)
  LEFT JOIN t3 USING(a)
  LEFT JOIN t4 USING(a)
  RIGHT JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  15 15 15 15 15 15
  17  -  -  -  - 17
  18  - 18 18  - 18
  19  -  -  -  - 19
}
do_execsql_test joinB-302 {
  SELECT a, b, c, d, e, f, g
  FROM t1
  RIGHT JOIN t2 USING(a,b)
  LEFT JOIN t3 USING(a,b)
  LEFT JOIN t4 USING(a,b)
  RIGHT JOIN t5 USING(a,b)
  WHERE d<>33 OR d IS NULL
  ORDER BY 1 NULLS FIRST;
} {
  15 25 35 35 35 35 35
  17 27  -  -  -  - 37
  18 28  - 38 38  - 38
  19 29  -  -  -  - 39
}
do_execsql_test joinB-303 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  RIGHT JOIN t2 USING(a)
  LEFT JOIN t3 USING(a)
  LEFT JOIN t4 USING(a)
  FULL JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
   -  -  -  -  -  -
  12 12 12 12  -  -
  13  - 13 13 13  -
  15 15 15 15 15 15
  17  -  -  -  - 17
  18  - 18 18  - 18
  19  -  -  -  - 19
}
do_execsql_test joinB-304 {
  SELECT b, c, d, e, f, g
  FROM t1
  NATURAL RIGHT JOIN t2
  NATURAL LEFT JOIN t3
  NATURAL LEFT JOIN t4
  NATURAL FULL JOIN t5
  WHERE b BETWEEN 12 AND 17
  ORDER BY 1 NULLS FIRST;
} {
}
do_execsql_test joinB-305 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  RIGHT JOIN t2 USING(a)
  LEFT JOIN t3 USING(a)
  RIGHT JOIN t4 USING(a)
  INNER JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  15 15 15 15 15 15
  19  -  -  - 19 19
}
do_execsql_test joinB-306 {
  SELECT a, c, d, e, f, g
  FROM t1
  RIGHT JOIN t2 USING(a,b)
  LEFT JOIN t3 USING(a,b)
  RIGHT JOIN t4 USING(a,b)
  INNER JOIN t5 USING(a,b)
  WHERE a<>13
  ORDER BY 1 NULLS FIRST;
} {
  15 35 35 35 35 35
  19  -  -  - 39 39
}
do_execsql_test joinB-307 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  RIGHT JOIN t2 USING(a)
  LEFT JOIN t3 USING(a)
  RIGHT JOIN t4 USING(a)
  LEFT JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  11  -  -  - 11  -
  13  - 13 13 13  -
  15 15 15 15 15 15
  19  -  -  - 19 19
}
do_execsql_test joinB-308 {
  SELECT a, c, d, e, f, g
  FROM t1
  RIGHT JOIN (t2 LEFT JOIN t3 USING(a)) USING(a)
  RIGHT JOIN (t4 LEFT JOIN t5 USING(a)) USING(a)
  WHERE a<=18
  ORDER BY 1 NULLS FIRST;
} {
  11  -  -  - 31  -
  13  - 33 33 33  -
  15 35 35 35 35 35
}
do_execsql_test joinB-309 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  RIGHT JOIN t2 USING(a)
  LEFT JOIN t3 USING(a)
  RIGHT JOIN t4 USING(a)
  RIGHT JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  15 15 15 15 15 15
  17  -  -  -  - 17
  18  -  -  -  - 18
  19  -  -  - 19 19
}
do_execsql_test joinB-310 {
  SELECT a, b, c, d, e, f, g
  FROM t1
  RIGHT JOIN t2 USING(a,b)
  LEFT JOIN t3 USING(a,b)
  RIGHT JOIN t4 USING(a,b)
  RIGHT JOIN t5 USING(a,b)
  WHERE d<>33 OR d IS NULL
  ORDER BY 1 NULLS FIRST;
} {
  15 25 35 35 35 35 35
  17 27  -  -  -  - 37
  18 28  -  -  -  - 38
  19 29  -  -  - 39 39
}
do_execsql_test joinB-311 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  RIGHT JOIN t2 USING(a)
  LEFT JOIN t3 USING(a)
  RIGHT JOIN t4 USING(a)
  FULL JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  11  -  -  - 11  -
  13  - 13 13 13  -
  15 15 15 15 15 15
  17  -  -  -  - 17
  18  -  -  -  - 18
  19  -  -  - 19 19
}
do_execsql_test joinB-312 {
  SELECT b, c, d, e, f, g
  FROM t1
  NATURAL RIGHT JOIN t2
  NATURAL LEFT JOIN t3
  NATURAL RIGHT JOIN t4
  NATURAL FULL JOIN t5
  WHERE b BETWEEN 12 AND 17
  ORDER BY 1 NULLS FIRST;
} {
}
do_execsql_test joinB-313 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  RIGHT JOIN t2 USING(a)
  LEFT JOIN t3 USING(a)
  FULL JOIN t4 USING(a)
  INNER JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  15 15 15 15 15 15
  18  - 18 18  - 18
  19  -  -  - 19 19
}
do_execsql_test joinB-314 {
  SELECT a, c, d, e, f, g
  FROM t1
  RIGHT JOIN t2 USING(a,b)
  LEFT JOIN t3 USING(a,b)
  FULL JOIN t4 USING(a,b)
  INNER JOIN t5 USING(a,b)
  WHERE a<>13
  ORDER BY 1 NULLS FIRST;
} {
  15 35 35 35 35 35
  18  - 38 38  - 38
  19  -  -  - 39 39
}
do_execsql_test joinB-315 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  RIGHT JOIN t2 USING(a)
  LEFT JOIN t3 USING(a)
  FULL JOIN t4 USING(a)
  LEFT JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
   -  -  -  -  -  -
  11  -  -  - 11  -
  12 12 12 12  -  -
  13  - 13 13 13  -
  15 15 15 15 15 15
  18  - 18 18  - 18
  19  -  -  - 19 19
}
do_execsql_test joinB-316 {
  SELECT a, c, d, e, f, g
  FROM t1
  RIGHT JOIN (t2 LEFT JOIN t3 USING(a)) USING(a)
  FULL JOIN (t4 LEFT JOIN t5 USING(a)) USING(a)
  WHERE a<=18
  ORDER BY 1 NULLS FIRST;
} {
  11  -  -  - 31  -
  12 32 32 32  -  -
  13  - 33 33 33  -
  15 35 35 35 35 35
  18  - 38 38  -  -
}
do_execsql_test joinB-317 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  RIGHT JOIN t2 USING(a)
  LEFT JOIN t3 USING(a)
  FULL JOIN t4 USING(a)
  RIGHT JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  15 15 15 15 15 15
  17  -  -  -  - 17
  18  - 18 18  - 18
  19  -  -  - 19 19
}
do_execsql_test joinB-318 {
  SELECT a, b, c, d, e, f, g
  FROM t1
  RIGHT JOIN t2 USING(a,b)
  LEFT JOIN t3 USING(a,b)
  FULL JOIN t4 USING(a,b)
  RIGHT JOIN t5 USING(a,b)
  WHERE d<>33 OR d IS NULL
  ORDER BY 1 NULLS FIRST;
} {
  15 25 35 35 35 35 35
  17 27  -  -  -  - 37
  18 28  - 38 38  - 38
  19 29  -  -  - 39 39
}
do_execsql_test joinB-319 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  RIGHT JOIN t2 USING(a)
  LEFT JOIN t3 USING(a)
  FULL JOIN t4 USING(a)
  FULL JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
   -  -  -  -  -  -
  11  -  -  - 11  -
  12 12 12 12  -  -
  13  - 13 13 13  -
  15 15 15 15 15 15
  17  -  -  -  - 17
  18  - 18 18  - 18
  19  -  -  - 19 19
}
do_execsql_test joinB-320 {
  SELECT b, c, d, e, f, g
  FROM t1
  NATURAL RIGHT JOIN t2
  NATURAL LEFT JOIN t3
  NATURAL FULL JOIN t4
  NATURAL FULL JOIN t5
  WHERE b BETWEEN 12 AND 17
  ORDER BY 1 NULLS FIRST;
} {
}
do_execsql_test joinB-321 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  RIGHT JOIN t2 USING(a)
  RIGHT JOIN t3 USING(a)
  INNER JOIN t4 USING(a)
  INNER JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  15 15 15 15 15 15
  19  -  - 19 19 19
}
do_execsql_test joinB-322 {
  SELECT a, c, d, e, f, g
  FROM t1
  RIGHT JOIN t2 USING(a,b)
  RIGHT JOIN t3 USING(a,b)
  INNER JOIN t4 USING(a,b)
  INNER JOIN t5 USING(a,b)
  WHERE a<>13
  ORDER BY 1 NULLS FIRST;
} {
  15 35 35 35 35 35
  19  -  - 39 39 39
}
do_execsql_test joinB-323 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  RIGHT JOIN t2 USING(a)
  RIGHT JOIN t3 USING(a)
  INNER JOIN t4 USING(a)
  LEFT JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  11  -  - 11 11  -
  13  - 13 13 13  -
  15 15 15 15 15 15
  19  -  - 19 19 19
}
do_execsql_test joinB-324 {
  SELECT a, c, d, e, f, g
  FROM t1
  RIGHT JOIN (t2 RIGHT JOIN t3 USING(a)) USING(a)
  INNER JOIN (t4 LEFT JOIN t5 USING(a)) USING(a)
  WHERE a<=18
  ORDER BY 1 NULLS FIRST;
} {
  11 31  - 31 31  -
  13  - 33 33 33  -
  15 35 35 35 35 35
}
do_execsql_test joinB-325 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  RIGHT JOIN t2 USING(a)
  RIGHT JOIN t3 USING(a)
  INNER JOIN t4 USING(a)
  RIGHT JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  15 15 15 15 15 15
  17  -  -  -  - 17
  18  -  -  -  - 18
  19  -  - 19 19 19
}
do_execsql_test joinB-326 {
  SELECT a, b, c, d, e, f, g
  FROM t1
  RIGHT JOIN t2 USING(a,b)
  RIGHT JOIN t3 USING(a,b)
  INNER JOIN t4 USING(a,b)
  RIGHT JOIN t5 USING(a,b)
  WHERE d<>33 OR d IS NULL
  ORDER BY 1 NULLS FIRST;
} {
  15 25 35 35 35 35 35
  17 27  -  -  -  - 37
  18 28  -  -  -  - 38
  19 29  -  - 39 39 39
}
do_execsql_test joinB-327 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  RIGHT JOIN t2 USING(a)
  RIGHT JOIN t3 USING(a)
  INNER JOIN t4 USING(a)
  FULL JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  11  -  - 11 11  -
  13  - 13 13 13  -
  15 15 15 15 15 15
  17  -  -  -  - 17
  18  -  -  -  - 18
  19  -  - 19 19 19
}
do_execsql_test joinB-328 {
  SELECT b, c, d, e, f, g
  FROM t1
  NATURAL RIGHT JOIN t2
  NATURAL RIGHT JOIN t3
  NATURAL INNER JOIN t4
  NATURAL FULL JOIN t5
  WHERE b BETWEEN 12 AND 17
  ORDER BY 1 NULLS FIRST;
} {
}
do_execsql_test joinB-329 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  RIGHT JOIN t2 USING(a)
  RIGHT JOIN t3 USING(a)
  LEFT JOIN t4 USING(a)
  INNER JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  15 15 15 15 15 15
  17  -  - 17  - 17
  18  - 18 18  - 18
  19  -  - 19 19 19
}
do_execsql_test joinB-330 {
  SELECT a, c, d, e, f, g
  FROM t1
  RIGHT JOIN t2 USING(a,b)
  RIGHT JOIN t3 USING(a,b)
  LEFT JOIN t4 USING(a,b)
  INNER JOIN t5 USING(a,b)
  WHERE a<>13
  ORDER BY 1 NULLS FIRST;
} {
  15 35 35 35 35 35
  17  -  - 37  - 37
  18  - 38 38  - 38
  19  -  - 39 39 39
}
do_execsql_test joinB-331 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  RIGHT JOIN t2 USING(a)
  RIGHT JOIN t3 USING(a)
  LEFT JOIN t4 USING(a)
  LEFT JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
   -  -  -  -  -  -
  11  -  - 11 11  -
  12 12 12 12  -  -
  13  - 13 13 13  -
  15 15 15 15 15 15
  17  -  - 17  - 17
  18  - 18 18  - 18
  19  -  - 19 19 19
}
do_execsql_test joinB-332 {
  SELECT a, c, d, e, f, g
  FROM t1
  RIGHT JOIN (t2 RIGHT JOIN t3 USING(a)) USING(a)
  LEFT JOIN (t4 LEFT JOIN t5 USING(a)) USING(a)
  WHERE a<=18
  ORDER BY 1 NULLS FIRST;
} {
  11 31  - 31 31  -
  12 32 32 32  -  -
  13  - 33 33 33  -
  15 35 35 35 35 35
  17 37  - 37  -  -
  18  - 38 38  -  -
}
do_execsql_test joinB-333 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  RIGHT JOIN t2 USING(a)
  RIGHT JOIN t3 USING(a)
  LEFT JOIN t4 USING(a)
  RIGHT JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  15 15 15 15 15 15
  17  -  - 17  - 17
  18  - 18 18  - 18
  19  -  - 19 19 19
}
do_execsql_test joinB-334 {
  SELECT a, b, c, d, e, f, g
  FROM t1
  RIGHT JOIN t2 USING(a,b)
  RIGHT JOIN t3 USING(a,b)
  LEFT JOIN t4 USING(a,b)
  RIGHT JOIN t5 USING(a,b)
  WHERE d<>33 OR d IS NULL
  ORDER BY 1 NULLS FIRST;
} {
  15 25 35 35 35 35 35
  17 27  -  - 37  - 37
  18 28  - 38 38  - 38
  19 29  -  - 39 39 39
}
do_execsql_test joinB-335 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  RIGHT JOIN t2 USING(a)
  RIGHT JOIN t3 USING(a)
  LEFT JOIN t4 USING(a)
  FULL JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
   -  -  -  -  -  -
  11  -  - 11 11  -
  12 12 12 12  -  -
  13  - 13 13 13  -
  15 15 15 15 15 15
  17  -  - 17  - 17
  18  - 18 18  - 18
  19  -  - 19 19 19
}
do_execsql_test joinB-336 {
  SELECT b, c, d, e, f, g
  FROM t1
  NATURAL RIGHT JOIN t2
  NATURAL RIGHT JOIN t3
  NATURAL LEFT JOIN t4
  NATURAL FULL JOIN t5
  WHERE b BETWEEN 12 AND 17
  ORDER BY 1 NULLS FIRST;
} {
}
do_execsql_test joinB-337 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  RIGHT JOIN t2 USING(a)
  RIGHT JOIN t3 USING(a)
  RIGHT JOIN t4 USING(a)
  INNER JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  15 15 15 15 15 15
  19  -  - 19 19 19
}
do_execsql_test joinB-338 {
  SELECT a, c, d, e, f, g
  FROM t1
  RIGHT JOIN t2 USING(a,b)
  RIGHT JOIN t3 USING(a,b)
  RIGHT JOIN t4 USING(a,b)
  INNER JOIN t5 USING(a,b)
  WHERE a<>13
  ORDER BY 1 NULLS FIRST;
} {
  15 35 35 35 35 35
  19  -  - 39 39 39
}
do_execsql_test joinB-339 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  RIGHT JOIN t2 USING(a)
  RIGHT JOIN t3 USING(a)
  RIGHT JOIN t4 USING(a)
  LEFT JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  11  -  - 11 11  -
  13  - 13 13 13  -
  15 15 15 15 15 15
  19  -  - 19 19 19
}
do_execsql_test joinB-340 {
  SELECT a, c, d, e, f, g
  FROM t1
  RIGHT JOIN (t2 RIGHT JOIN t3 USING(a)) USING(a)
  RIGHT JOIN (t4 LEFT JOIN t5 USING(a)) USING(a)
  WHERE a<=18
  ORDER BY 1 NULLS FIRST;
} {
  11 31  - 31 31  -
  13  - 33 33 33  -
  15 35 35 35 35 35
}
do_execsql_test joinB-341 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  RIGHT JOIN t2 USING(a)
  RIGHT JOIN t3 USING(a)
  RIGHT JOIN t4 USING(a)
  RIGHT JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  15 15 15 15 15 15
  17  -  -  -  - 17
  18  -  -  -  - 18
  19  -  - 19 19 19
}
do_execsql_test joinB-342 {
  SELECT a, b, c, d, e, f, g
  FROM t1
  RIGHT JOIN t2 USING(a,b)
  RIGHT JOIN t3 USING(a,b)
  RIGHT JOIN t4 USING(a,b)
  RIGHT JOIN t5 USING(a,b)
  WHERE d<>33 OR d IS NULL
  ORDER BY 1 NULLS FIRST;
} {
  15 25 35 35 35 35 35
  17 27  -  -  -  - 37
  18 28  -  -  -  - 38
  19 29  -  - 39 39 39
}
do_execsql_test joinB-343 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  RIGHT JOIN t2 USING(a)
  RIGHT JOIN t3 USING(a)
  RIGHT JOIN t4 USING(a)
  FULL JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  11  -  - 11 11  -
  13  - 13 13 13  -
  15 15 15 15 15 15
  17  -  -  -  - 17
  18  -  -  -  - 18
  19  -  - 19 19 19
}
do_execsql_test joinB-344 {
  SELECT b, c, d, e, f, g
  FROM t1
  NATURAL RIGHT JOIN t2
  NATURAL RIGHT JOIN t3
  NATURAL RIGHT JOIN t4
  NATURAL FULL JOIN t5
  WHERE b BETWEEN 12 AND 17
  ORDER BY 1 NULLS FIRST;
} {
}
do_execsql_test joinB-345 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  RIGHT JOIN t2 USING(a)
  RIGHT JOIN t3 USING(a)
  FULL JOIN t4 USING(a)
  INNER JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  15 15 15 15 15 15
  17  -  - 17  - 17
  18  - 18 18  - 18
  19  -  - 19 19 19
}
do_execsql_test joinB-346 {
  SELECT a, c, d, e, f, g
  FROM t1
  RIGHT JOIN t2 USING(a,b)
  RIGHT JOIN t3 USING(a,b)
  FULL JOIN t4 USING(a,b)
  INNER JOIN t5 USING(a,b)
  WHERE a<>13
  ORDER BY 1 NULLS FIRST;
} {
  15 35 35 35 35 35
  17  -  - 37  - 37
  18  - 38 38  - 38
  19  -  - 39 39 39
}
do_execsql_test joinB-347 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  RIGHT JOIN t2 USING(a)
  RIGHT JOIN t3 USING(a)
  FULL JOIN t4 USING(a)
  LEFT JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
   -  -  -  -  -  -
  11  -  - 11 11  -
  12 12 12 12  -  -
  13  - 13 13 13  -
  15 15 15 15 15 15
  17  -  - 17  - 17
  18  - 18 18  - 18
  19  -  - 19 19 19
}
do_execsql_test joinB-348 {
  SELECT a, c, d, e, f, g
  FROM t1
  RIGHT JOIN (t2 RIGHT JOIN t3 USING(a)) USING(a)
  FULL JOIN (t4 LEFT JOIN t5 USING(a)) USING(a)
  WHERE a<=18
  ORDER BY 1 NULLS FIRST;
} {
  11 31  - 31 31  -
  12 32 32 32  -  -
  13  - 33 33 33  -
  15 35 35 35 35 35
  17 37  - 37  -  -
  18  - 38 38  -  -
}
do_execsql_test joinB-349 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  RIGHT JOIN t2 USING(a)
  RIGHT JOIN t3 USING(a)
  FULL JOIN t4 USING(a)
  RIGHT JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  15 15 15 15 15 15
  17  -  - 17  - 17
  18  - 18 18  - 18
  19  -  - 19 19 19
}
do_execsql_test joinB-350 {
  SELECT a, b, c, d, e, f, g
  FROM t1
  RIGHT JOIN t2 USING(a,b)
  RIGHT JOIN t3 USING(a,b)
  FULL JOIN t4 USING(a,b)
  RIGHT JOIN t5 USING(a,b)
  WHERE d<>33 OR d IS NULL
  ORDER BY 1 NULLS FIRST;
} {
  15 25 35 35 35 35 35
  17 27  -  - 37  - 37
  18 28  - 38 38  - 38
  19 29  -  - 39 39 39
}
do_execsql_test joinB-351 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  RIGHT JOIN t2 USING(a)
  RIGHT JOIN t3 USING(a)
  FULL JOIN t4 USING(a)
  FULL JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
   -  -  -  -  -  -
  11  -  - 11 11  -
  12 12 12 12  -  -
  13  - 13 13 13  -
  15 15 15 15 15 15
  17  -  - 17  - 17
  18  - 18 18  - 18
  19  -  - 19 19 19
}
do_execsql_test joinB-352 {
  SELECT b, c, d, e, f, g
  FROM t1
  NATURAL RIGHT JOIN t2
  NATURAL RIGHT JOIN t3
  NATURAL FULL JOIN t4
  NATURAL FULL JOIN t5
  WHERE b BETWEEN 12 AND 17
  ORDER BY 1 NULLS FIRST;
} {
}
do_execsql_test joinB-353 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  RIGHT JOIN t2 USING(a)
  FULL JOIN t3 USING(a)
  INNER JOIN t4 USING(a)
  INNER JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  15 15 15 15 15 15
  19  -  - 19 19 19
}
do_execsql_test joinB-354 {
  SELECT a, c, d, e, f, g
  FROM t1
  RIGHT JOIN t2 USING(a,b)
  FULL JOIN t3 USING(a,b)
  INNER JOIN t4 USING(a,b)
  INNER JOIN t5 USING(a,b)
  WHERE a<>13
  ORDER BY 1 NULLS FIRST;
} {
  15 35 35 35 35 35
  19  -  - 39 39 39
}
do_execsql_test joinB-355 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  RIGHT JOIN t2 USING(a)
  FULL JOIN t3 USING(a)
  INNER JOIN t4 USING(a)
  LEFT JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  11  -  - 11 11  -
  13  - 13 13 13  -
  15 15 15 15 15 15
  19  -  - 19 19 19
}
do_execsql_test joinB-356 {
  SELECT a, c, d, e, f, g
  FROM t1
  RIGHT JOIN (t2 FULL JOIN t3 USING(a)) USING(a)
  INNER JOIN (t4 LEFT JOIN t5 USING(a)) USING(a)
  WHERE a<=18
  ORDER BY 1 NULLS FIRST;
} {
  11 31  - 31 31  -
  13  - 33 33 33  -
  15 35 35 35 35 35
}
do_execsql_test joinB-357 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  RIGHT JOIN t2 USING(a)
  FULL JOIN t3 USING(a)
  INNER JOIN t4 USING(a)
  RIGHT JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  15 15 15 15 15 15
  17  -  -  -  - 17
  18  -  -  -  - 18
  19  -  - 19 19 19
}
do_execsql_test joinB-358 {
  SELECT a, b, c, d, e, f, g
  FROM t1
  RIGHT JOIN t2 USING(a,b)
  FULL JOIN t3 USING(a,b)
  INNER JOIN t4 USING(a,b)
  RIGHT JOIN t5 USING(a,b)
  WHERE d<>33 OR d IS NULL
  ORDER BY 1 NULLS FIRST;
} {
  15 25 35 35 35 35 35
  17 27  -  -  -  - 37
  18 28  -  -  -  - 38
  19 29  -  - 39 39 39
}
do_execsql_test joinB-359 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  RIGHT JOIN t2 USING(a)
  FULL JOIN t3 USING(a)
  INNER JOIN t4 USING(a)
  FULL JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  11  -  - 11 11  -
  13  - 13 13 13  -
  15 15 15 15 15 15
  17  -  -  -  - 17
  18  -  -  -  - 18
  19  -  - 19 19 19
}
do_execsql_test joinB-360 {
  SELECT b, c, d, e, f, g
  FROM t1
  NATURAL RIGHT JOIN t2
  NATURAL FULL JOIN t3
  NATURAL INNER JOIN t4
  NATURAL FULL JOIN t5
  WHERE b BETWEEN 12 AND 17
  ORDER BY 1 NULLS FIRST;
} {
}
do_execsql_test joinB-361 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  RIGHT JOIN t2 USING(a)
  FULL JOIN t3 USING(a)
  LEFT JOIN t4 USING(a)
  INNER JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  15 15 15 15 15 15
  17  -  - 17  - 17
  18  - 18 18  - 18
  19  -  - 19 19 19
}
do_execsql_test joinB-362 {
  SELECT a, c, d, e, f, g
  FROM t1
  RIGHT JOIN t2 USING(a,b)
  FULL JOIN t3 USING(a,b)
  LEFT JOIN t4 USING(a,b)
  INNER JOIN t5 USING(a,b)
  WHERE a<>13
  ORDER BY 1 NULLS FIRST;
} {
  15 35 35 35 35 35
  17  -  - 37  - 37
  18  - 38 38  - 38
  19  -  - 39 39 39
}
do_execsql_test joinB-363 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  RIGHT JOIN t2 USING(a)
  FULL JOIN t3 USING(a)
  LEFT JOIN t4 USING(a)
  LEFT JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
   -  -  -  -  -  -
   -  -  -  -  -  -
  11  -  - 11 11  -
  12 12 12 12  -  -
  13  - 13 13 13  -
  15 15 15 15 15 15
  17  -  - 17  - 17
  18  - 18 18  - 18
  19  -  - 19 19 19
}
do_execsql_test joinB-364 {
  SELECT a, c, d, e, f, g
  FROM t1
  RIGHT JOIN (t2 FULL JOIN t3 USING(a)) USING(a)
  LEFT JOIN (t4 LEFT JOIN t5 USING(a)) USING(a)
  WHERE a<=18
  ORDER BY 1 NULLS FIRST;
} {
  11 31  - 31 31  -
  12 32 32 32  -  -
  13  - 33 33 33  -
  15 35 35 35 35 35
  17 37  - 37  -  -
  18  - 38 38  -  -
}
do_execsql_test joinB-365 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  RIGHT JOIN t2 USING(a)
  FULL JOIN t3 USING(a)
  LEFT JOIN t4 USING(a)
  RIGHT JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  15 15 15 15 15 15
  17  -  - 17  - 17
  18  - 18 18  - 18
  19  -  - 19 19 19
}
do_execsql_test joinB-366 {
  SELECT a, b, c, d, e, f, g
  FROM t1
  RIGHT JOIN t2 USING(a,b)
  FULL JOIN t3 USING(a,b)
  LEFT JOIN t4 USING(a,b)
  RIGHT JOIN t5 USING(a,b)
  WHERE d<>33 OR d IS NULL
  ORDER BY 1 NULLS FIRST;
} {
  15 25 35 35 35 35 35
  17 27  -  - 37  - 37
  18 28  - 38 38  - 38
  19 29  -  - 39 39 39
}
do_execsql_test joinB-367 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  RIGHT JOIN t2 USING(a)
  FULL JOIN t3 USING(a)
  LEFT JOIN t4 USING(a)
  FULL JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
   -  -  -  -  -  -
   -  -  -  -  -  -
  11  -  - 11 11  -
  12 12 12 12  -  -
  13  - 13 13 13  -
  15 15 15 15 15 15
  17  -  - 17  - 17
  18  - 18 18  - 18
  19  -  - 19 19 19
}
do_execsql_test joinB-368 {
  SELECT b, c, d, e, f, g
  FROM t1
  NATURAL RIGHT JOIN t2
  NATURAL FULL JOIN t3
  NATURAL LEFT JOIN t4
  NATURAL FULL JOIN t5
  WHERE b BETWEEN 12 AND 17
  ORDER BY 1 NULLS FIRST;
} {
}
do_execsql_test joinB-369 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  RIGHT JOIN t2 USING(a)
  FULL JOIN t3 USING(a)
  RIGHT JOIN t4 USING(a)
  INNER JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  15 15 15 15 15 15
  19  -  - 19 19 19
}
do_execsql_test joinB-370 {
  SELECT a, c, d, e, f, g
  FROM t1
  RIGHT JOIN t2 USING(a,b)
  FULL JOIN t3 USING(a,b)
  RIGHT JOIN t4 USING(a,b)
  INNER JOIN t5 USING(a,b)
  WHERE a<>13
  ORDER BY 1 NULLS FIRST;
} {
  15 35 35 35 35 35
  19  -  - 39 39 39
}
do_execsql_test joinB-371 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  RIGHT JOIN t2 USING(a)
  FULL JOIN t3 USING(a)
  RIGHT JOIN t4 USING(a)
  LEFT JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  11  -  - 11 11  -
  13  - 13 13 13  -
  15 15 15 15 15 15
  19  -  - 19 19 19
}
do_execsql_test joinB-372 {
  SELECT a, c, d, e, f, g
  FROM t1
  RIGHT JOIN (t2 FULL JOIN t3 USING(a)) USING(a)
  RIGHT JOIN (t4 LEFT JOIN t5 USING(a)) USING(a)
  WHERE a<=18
  ORDER BY 1 NULLS FIRST;
} {
  11 31  - 31 31  -
  13  - 33 33 33  -
  15 35 35 35 35 35
}
do_execsql_test joinB-373 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  RIGHT JOIN t2 USING(a)
  FULL JOIN t3 USING(a)
  RIGHT JOIN t4 USING(a)
  RIGHT JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  15 15 15 15 15 15
  17  -  -  -  - 17
  18  -  -  -  - 18
  19  -  - 19 19 19
}
do_execsql_test joinB-374 {
  SELECT a, b, c, d, e, f, g
  FROM t1
  RIGHT JOIN t2 USING(a,b)
  FULL JOIN t3 USING(a,b)
  RIGHT JOIN t4 USING(a,b)
  RIGHT JOIN t5 USING(a,b)
  WHERE d<>33 OR d IS NULL
  ORDER BY 1 NULLS FIRST;
} {
  15 25 35 35 35 35 35
  17 27  -  -  -  - 37
  18 28  -  -  -  - 38
  19 29  -  - 39 39 39
}
do_execsql_test joinB-375 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  RIGHT JOIN t2 USING(a)
  FULL JOIN t3 USING(a)
  RIGHT JOIN t4 USING(a)
  FULL JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  11  -  - 11 11  -
  13  - 13 13 13  -
  15 15 15 15 15 15
  17  -  -  -  - 17
  18  -  -  -  - 18
  19  -  - 19 19 19
}
do_execsql_test joinB-376 {
  SELECT b, c, d, e, f, g
  FROM t1
  NATURAL RIGHT JOIN t2
  NATURAL FULL JOIN t3
  NATURAL RIGHT JOIN t4
  NATURAL FULL JOIN t5
  WHERE b BETWEEN 12 AND 17
  ORDER BY 1 NULLS FIRST;
} {
}
do_execsql_test joinB-377 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  RIGHT JOIN t2 USING(a)
  FULL JOIN t3 USING(a)
  FULL JOIN t4 USING(a)
  INNER JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  15 15 15 15 15 15
  17  -  - 17  - 17
  18  - 18 18  - 18
  19  -  - 19 19 19
}
do_execsql_test joinB-378 {
  SELECT a, c, d, e, f, g
  FROM t1
  RIGHT JOIN t2 USING(a,b)
  FULL JOIN t3 USING(a,b)
  FULL JOIN t4 USING(a,b)
  INNER JOIN t5 USING(a,b)
  WHERE a<>13
  ORDER BY 1 NULLS FIRST;
} {
  15 35 35 35 35 35
  17  -  - 37  - 37
  18  - 38 38  - 38
  19  -  - 39 39 39
}
do_execsql_test joinB-379 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  RIGHT JOIN t2 USING(a)
  FULL JOIN t3 USING(a)
  FULL JOIN t4 USING(a)
  LEFT JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
   -  -  -  -  -  -
   -  -  -  -  -  -
  11  -  - 11 11  -
  12 12 12 12  -  -
  13  - 13 13 13  -
  15 15 15 15 15 15
  17  -  - 17  - 17
  18  - 18 18  - 18
  19  -  - 19 19 19
}
do_execsql_test joinB-380 {
  SELECT a, c, d, e, f, g
  FROM t1
  RIGHT JOIN (t2 FULL JOIN t3 USING(a)) USING(a)
  FULL JOIN (t4 LEFT JOIN t5 USING(a)) USING(a)
  WHERE a<=18
  ORDER BY 1 NULLS FIRST;
} {
  11 31  - 31 31  -
  12 32 32 32  -  -
  13  - 33 33 33  -
  15 35 35 35 35 35
  17 37  - 37  -  -
  18  - 38 38  -  -
}
do_execsql_test joinB-381 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  RIGHT JOIN t2 USING(a)
  FULL JOIN t3 USING(a)
  FULL JOIN t4 USING(a)
  RIGHT JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  15 15 15 15 15 15
  17  -  - 17  - 17
  18  - 18 18  - 18
  19  -  - 19 19 19
}
do_execsql_test joinB-382 {
  SELECT a, b, c, d, e, f, g
  FROM t1
  RIGHT JOIN t2 USING(a,b)
  FULL JOIN t3 USING(a,b)
  FULL JOIN t4 USING(a,b)
  RIGHT JOIN t5 USING(a,b)
  WHERE d<>33 OR d IS NULL
  ORDER BY 1 NULLS FIRST;
} {
  15 25 35 35 35 35 35
  17 27  -  - 37  - 37
  18 28  - 38 38  - 38
  19 29  -  - 39 39 39
}
do_execsql_test joinB-383 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  RIGHT JOIN t2 USING(a)
  FULL JOIN t3 USING(a)
  FULL JOIN t4 USING(a)
  FULL JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
   -  -  -  -  -  -
   -  -  -  -  -  -
  11  -  - 11 11  -
  12 12 12 12  -  -
  13  - 13 13 13  -
  15 15 15 15 15 15
  17  -  - 17  - 17
  18  - 18 18  - 18
  19  -  - 19 19 19
}
do_execsql_test joinB-384 {
  SELECT b, c, d, e, f, g
  FROM t1
  NATURAL RIGHT JOIN t2
  NATURAL FULL JOIN t3
  NATURAL FULL JOIN t4
  NATURAL FULL JOIN t5
  WHERE b BETWEEN 12 AND 17
  ORDER BY 1 NULLS FIRST;
} {
}
do_execsql_test joinB-385 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  FULL JOIN t2 USING(a)
  INNER JOIN t3 USING(a)
  INNER JOIN t4 USING(a)
  INNER JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  15 15 15 15 15 15
}
do_execsql_test joinB-386 {
  SELECT a, c, d, e, f, g
  FROM t1
  FULL JOIN t2 USING(a,b)
  INNER JOIN t3 USING(a,b)
  INNER JOIN t4 USING(a,b)
  INNER JOIN t5 USING(a,b)
  WHERE a<>13
  ORDER BY 1 NULLS FIRST;
} {
  15 35 35 35 35 35
}
do_execsql_test joinB-387 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  FULL JOIN t2 USING(a)
  INNER JOIN t3 USING(a)
  INNER JOIN t4 USING(a)
  LEFT JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  11 11  - 11 11  -
  13  - 13 13 13  -
  15 15 15 15 15 15
}
do_execsql_test joinB-388 {
  SELECT a, c, d, e, f, g
  FROM t1
  FULL JOIN (t2 INNER JOIN t3 USING(a)) USING(a)
  INNER JOIN (t4 LEFT JOIN t5 USING(a)) USING(a)
  WHERE a<=18
  ORDER BY 1 NULLS FIRST;
} {
  11 31  -  - 31  -
  13  - 33 33 33  -
  15 35 35 35 35 35
}
do_execsql_test joinB-389 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  FULL JOIN t2 USING(a)
  INNER JOIN t3 USING(a)
  INNER JOIN t4 USING(a)
  RIGHT JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  15 15 15 15 15 15
  17  -  -  -  - 17
  18  -  -  -  - 18
  19  -  -  -  - 19
}
do_execsql_test joinB-390 {
  SELECT a, b, c, d, e, f, g
  FROM t1
  FULL JOIN t2 USING(a,b)
  INNER JOIN t3 USING(a,b)
  INNER JOIN t4 USING(a,b)
  RIGHT JOIN t5 USING(a,b)
  WHERE d<>33 OR d IS NULL
  ORDER BY 1 NULLS FIRST;
} {
  15 25 35 35 35 35 35
  17 27  -  -  -  - 37
  18 28  -  -  -  - 38
  19 29  -  -  -  - 39
}
do_execsql_test joinB-391 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  FULL JOIN t2 USING(a)
  INNER JOIN t3 USING(a)
  INNER JOIN t4 USING(a)
  FULL JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  11 11  - 11 11  -
  13  - 13 13 13  -
  15 15 15 15 15 15
  17  -  -  -  - 17
  18  -  -  -  - 18
  19  -  -  -  - 19
}
do_execsql_test joinB-392 {
  SELECT b, c, d, e, f, g
  FROM t1
  NATURAL FULL JOIN t2
  NATURAL INNER JOIN t3
  NATURAL INNER JOIN t4
  NATURAL FULL JOIN t5
  WHERE b BETWEEN 12 AND 17
  ORDER BY 1 NULLS FIRST;
} {
}
do_execsql_test joinB-393 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  FULL JOIN t2 USING(a)
  INNER JOIN t3 USING(a)
  LEFT JOIN t4 USING(a)
  INNER JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  15 15 15 15 15 15
  17 17  - 17  - 17
  18  - 18 18  - 18
}
do_execsql_test joinB-394 {
  SELECT a, c, d, e, f, g
  FROM t1
  FULL JOIN t2 USING(a,b)
  INNER JOIN t3 USING(a,b)
  LEFT JOIN t4 USING(a,b)
  INNER JOIN t5 USING(a,b)
  WHERE a<>13
  ORDER BY 1 NULLS FIRST;
} {
  15 35 35 35 35 35
  17 37  - 37  - 37
  18  - 38 38  - 38
}
do_execsql_test joinB-395 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  FULL JOIN t2 USING(a)
  INNER JOIN t3 USING(a)
  LEFT JOIN t4 USING(a)
  LEFT JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  11 11  - 11 11  -
  12 12 12 12  -  -
  13  - 13 13 13  -
  15 15 15 15 15 15
  17 17  - 17  - 17
  18  - 18 18  - 18
}
do_execsql_test joinB-396 {
  SELECT a, c, d, e, f, g
  FROM t1
  FULL JOIN (t2 INNER JOIN t3 USING(a)) USING(a)
  LEFT JOIN (t4 LEFT JOIN t5 USING(a)) USING(a)
  WHERE a<=18
  ORDER BY 1 NULLS FIRST;
} {
  11 31  -  - 31  -
  12 32 32 32  -  -
  13  - 33 33 33  -
  15 35 35 35 35 35
  17 37  -  -  -  -
  18  - 38 38  -  -
}
do_execsql_test joinB-397 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  FULL JOIN t2 USING(a)
  INNER JOIN t3 USING(a)
  LEFT JOIN t4 USING(a)
  RIGHT JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  15 15 15 15 15 15
  17 17  - 17  - 17
  18  - 18 18  - 18
  19  -  -  -  - 19
}
do_execsql_test joinB-398 {
  SELECT a, b, c, d, e, f, g
  FROM t1
  FULL JOIN t2 USING(a,b)
  INNER JOIN t3 USING(a,b)
  LEFT JOIN t4 USING(a,b)
  RIGHT JOIN t5 USING(a,b)
  WHERE d<>33 OR d IS NULL
  ORDER BY 1 NULLS FIRST;
} {
  15 25 35 35 35 35 35
  17 27 37  - 37  - 37
  18 28  - 38 38  - 38
  19 29  -  -  -  - 39
}
do_execsql_test joinB-399 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  FULL JOIN t2 USING(a)
  INNER JOIN t3 USING(a)
  LEFT JOIN t4 USING(a)
  FULL JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  11 11  - 11 11  -
  12 12 12 12  -  -
  13  - 13 13 13  -
  15 15 15 15 15 15
  17 17  - 17  - 17
  18  - 18 18  - 18
  19  -  -  -  - 19
}
do_execsql_test joinB-400 {
  SELECT b, c, d, e, f, g
  FROM t1
  NATURAL FULL JOIN t2
  NATURAL INNER JOIN t3
  NATURAL LEFT JOIN t4
  NATURAL FULL JOIN t5
  WHERE b BETWEEN 12 AND 17
  ORDER BY 1 NULLS FIRST;
} {
}
do_execsql_test joinB-401 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  FULL JOIN t2 USING(a)
  INNER JOIN t3 USING(a)
  RIGHT JOIN t4 USING(a)
  INNER JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  15 15 15 15 15 15
  19  -  -  - 19 19
}
do_execsql_test joinB-402 {
  SELECT a, c, d, e, f, g
  FROM t1
  FULL JOIN t2 USING(a,b)
  INNER JOIN t3 USING(a,b)
  RIGHT JOIN t4 USING(a,b)
  INNER JOIN t5 USING(a,b)
  WHERE a<>13
  ORDER BY 1 NULLS FIRST;
} {
  15 35 35 35 35 35
  19  -  -  - 39 39
}
do_execsql_test joinB-403 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  FULL JOIN t2 USING(a)
  INNER JOIN t3 USING(a)
  RIGHT JOIN t4 USING(a)
  LEFT JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  11 11  - 11 11  -
  13  - 13 13 13  -
  15 15 15 15 15 15
  19  -  -  - 19 19
}
do_execsql_test joinB-404 {
  SELECT a, c, d, e, f, g
  FROM t1
  FULL JOIN (t2 INNER JOIN t3 USING(a)) USING(a)
  RIGHT JOIN (t4 LEFT JOIN t5 USING(a)) USING(a)
  WHERE a<=18
  ORDER BY 1 NULLS FIRST;
} {
  11 31  -  - 31  -
  13  - 33 33 33  -
  15 35 35 35 35 35
}
do_execsql_test joinB-405 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  FULL JOIN t2 USING(a)
  INNER JOIN t3 USING(a)
  RIGHT JOIN t4 USING(a)
  RIGHT JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  15 15 15 15 15 15
  17  -  -  -  - 17
  18  -  -  -  - 18
  19  -  -  - 19 19
}
do_execsql_test joinB-406 {
  SELECT a, b, c, d, e, f, g
  FROM t1
  FULL JOIN t2 USING(a,b)
  INNER JOIN t3 USING(a,b)
  RIGHT JOIN t4 USING(a,b)
  RIGHT JOIN t5 USING(a,b)
  WHERE d<>33 OR d IS NULL
  ORDER BY 1 NULLS FIRST;
} {
  15 25 35 35 35 35 35
  17 27  -  -  -  - 37
  18 28  -  -  -  - 38
  19 29  -  -  - 39 39
}
do_execsql_test joinB-407 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  FULL JOIN t2 USING(a)
  INNER JOIN t3 USING(a)
  RIGHT JOIN t4 USING(a)
  FULL JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  11 11  - 11 11  -
  13  - 13 13 13  -
  15 15 15 15 15 15
  17  -  -  -  - 17
  18  -  -  -  - 18
  19  -  -  - 19 19
}
do_execsql_test joinB-408 {
  SELECT b, c, d, e, f, g
  FROM t1
  NATURAL FULL JOIN t2
  NATURAL INNER JOIN t3
  NATURAL RIGHT JOIN t4
  NATURAL FULL JOIN t5
  WHERE b BETWEEN 12 AND 17
  ORDER BY 1 NULLS FIRST;
} {
}
do_execsql_test joinB-409 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  FULL JOIN t2 USING(a)
  INNER JOIN t3 USING(a)
  FULL JOIN t4 USING(a)
  INNER JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  15 15 15 15 15 15
  17 17  - 17  - 17
  18  - 18 18  - 18
  19  -  -  - 19 19
}
do_execsql_test joinB-410 {
  SELECT a, c, d, e, f, g
  FROM t1
  FULL JOIN t2 USING(a,b)
  INNER JOIN t3 USING(a,b)
  FULL JOIN t4 USING(a,b)
  INNER JOIN t5 USING(a,b)
  WHERE a<>13
  ORDER BY 1 NULLS FIRST;
} {
  15 35 35 35 35 35
  17 37  - 37  - 37
  18  - 38 38  - 38
  19  -  -  - 39 39
}
do_execsql_test joinB-411 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  FULL JOIN t2 USING(a)
  INNER JOIN t3 USING(a)
  FULL JOIN t4 USING(a)
  LEFT JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  11 11  - 11 11  -
  12 12 12 12  -  -
  13  - 13 13 13  -
  15 15 15 15 15 15
  17 17  - 17  - 17
  18  - 18 18  - 18
  19  -  -  - 19 19
}
do_execsql_test joinB-412 {
  SELECT a, c, d, e, f, g
  FROM t1
  FULL JOIN (t2 INNER JOIN t3 USING(a)) USING(a)
  FULL JOIN (t4 LEFT JOIN t5 USING(a)) USING(a)
  WHERE a<=18
  ORDER BY 1 NULLS FIRST;
} {
  11 31  -  - 31  -
  12 32 32 32  -  -
  13  - 33 33 33  -
  15 35 35 35 35 35
  17 37  -  -  -  -
  18  - 38 38  -  -
}
do_execsql_test joinB-413 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  FULL JOIN t2 USING(a)
  INNER JOIN t3 USING(a)
  FULL JOIN t4 USING(a)
  RIGHT JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  15 15 15 15 15 15
  17 17  - 17  - 17
  18  - 18 18  - 18
  19  -  -  - 19 19
}
do_execsql_test joinB-414 {
  SELECT a, b, c, d, e, f, g
  FROM t1
  FULL JOIN t2 USING(a,b)
  INNER JOIN t3 USING(a,b)
  FULL JOIN t4 USING(a,b)
  RIGHT JOIN t5 USING(a,b)
  WHERE d<>33 OR d IS NULL
  ORDER BY 1 NULLS FIRST;
} {
  15 25 35 35 35 35 35
  17 27 37  - 37  - 37
  18 28  - 38 38  - 38
  19 29  -  -  - 39 39
}
do_execsql_test joinB-415 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  FULL JOIN t2 USING(a)
  INNER JOIN t3 USING(a)
  FULL JOIN t4 USING(a)
  FULL JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  11 11  - 11 11  -
  12 12 12 12  -  -
  13  - 13 13 13  -
  15 15 15 15 15 15
  17 17  - 17  - 17
  18  - 18 18  - 18
  19  -  -  - 19 19
}
do_execsql_test joinB-416 {
  SELECT b, c, d, e, f, g
  FROM t1
  NATURAL FULL JOIN t2
  NATURAL INNER JOIN t3
  NATURAL FULL JOIN t4
  NATURAL FULL JOIN t5
  WHERE b BETWEEN 12 AND 17
  ORDER BY 1 NULLS FIRST;
} {
}
do_execsql_test joinB-417 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  FULL JOIN t2 USING(a)
  LEFT JOIN t3 USING(a)
  INNER JOIN t4 USING(a)
  INNER JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  15 15 15 15 15 15
}
do_execsql_test joinB-418 {
  SELECT a, c, d, e, f, g
  FROM t1
  FULL JOIN t2 USING(a,b)
  LEFT JOIN t3 USING(a,b)
  INNER JOIN t4 USING(a,b)
  INNER JOIN t5 USING(a,b)
  WHERE a<>13
  ORDER BY 1 NULLS FIRST;
} {
  15 35 35 35 35 35
}
do_execsql_test joinB-419 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  FULL JOIN t2 USING(a)
  LEFT JOIN t3 USING(a)
  INNER JOIN t4 USING(a)
  LEFT JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  11 11  - 11 11  -
  13  - 13 13 13  -
  15 15 15 15 15 15
}
do_execsql_test joinB-420 {
  SELECT a, c, d, e, f, g
  FROM t1
  FULL JOIN (t2 LEFT JOIN t3 USING(a)) USING(a)
  INNER JOIN (t4 LEFT JOIN t5 USING(a)) USING(a)
  WHERE a<=18
  ORDER BY 1 NULLS FIRST;
} {
  11 31  -  - 31  -
  13  - 33 33 33  -
  15 35 35 35 35 35
}
do_execsql_test joinB-421 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  FULL JOIN t2 USING(a)
  LEFT JOIN t3 USING(a)
  INNER JOIN t4 USING(a)
  RIGHT JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  15 15 15 15 15 15
  17  -  -  -  - 17
  18  -  -  -  - 18
  19  -  -  -  - 19
}
do_execsql_test joinB-422 {
  SELECT a, b, c, d, e, f, g
  FROM t1
  FULL JOIN t2 USING(a,b)
  LEFT JOIN t3 USING(a,b)
  INNER JOIN t4 USING(a,b)
  RIGHT JOIN t5 USING(a,b)
  WHERE d<>33 OR d IS NULL
  ORDER BY 1 NULLS FIRST;
} {
  15 25 35 35 35 35 35
  17 27  -  -  -  - 37
  18 28  -  -  -  - 38
  19 29  -  -  -  - 39
}
do_execsql_test joinB-423 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  FULL JOIN t2 USING(a)
  LEFT JOIN t3 USING(a)
  INNER JOIN t4 USING(a)
  FULL JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  11 11  - 11 11  -
  13  - 13 13 13  -
  15 15 15 15 15 15
  17  -  -  -  - 17
  18  -  -  -  - 18
  19  -  -  -  - 19
}
do_execsql_test joinB-424 {
  SELECT b, c, d, e, f, g
  FROM t1
  NATURAL FULL JOIN t2
  NATURAL LEFT JOIN t3
  NATURAL INNER JOIN t4
  NATURAL FULL JOIN t5
  WHERE b BETWEEN 12 AND 17
  ORDER BY 1 NULLS FIRST;
} {
}
do_execsql_test joinB-425 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  FULL JOIN t2 USING(a)
  LEFT JOIN t3 USING(a)
  LEFT JOIN t4 USING(a)
  INNER JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  15 15 15 15 15 15
  17 17  - 17  - 17
  18  - 18 18  - 18
}
do_execsql_test joinB-426 {
  SELECT a, c, d, e, f, g
  FROM t1
  FULL JOIN t2 USING(a,b)
  LEFT JOIN t3 USING(a,b)
  LEFT JOIN t4 USING(a,b)
  INNER JOIN t5 USING(a,b)
  WHERE a<>13
  ORDER BY 1 NULLS FIRST;
} {
  15 35 35 35 35 35
  17 37  - 37  - 37
  18  - 38 38  - 38
}
do_execsql_test joinB-427 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  FULL JOIN t2 USING(a)
  LEFT JOIN t3 USING(a)
  LEFT JOIN t4 USING(a)
  LEFT JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
   -  -  -  -  -  -
  11 11  - 11 11  -
  12 12 12 12  -  -
  13  - 13 13 13  -
  15 15 15 15 15 15
  17 17  - 17  - 17
  18  - 18 18  - 18
}
do_execsql_test joinB-428 {
  SELECT a, c, d, e, f, g
  FROM t1
  FULL JOIN (t2 LEFT JOIN t3 USING(a)) USING(a)
  LEFT JOIN (t4 LEFT JOIN t5 USING(a)) USING(a)
  WHERE a<=18
  ORDER BY 1 NULLS FIRST;
} {
  11 31  -  - 31  -
  12 32 32 32  -  -
  13  - 33 33 33  -
  15 35 35 35 35 35
  17 37  -  -  -  -
  18  - 38 38  -  -
}
do_execsql_test joinB-429 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  FULL JOIN t2 USING(a)
  LEFT JOIN t3 USING(a)
  LEFT JOIN t4 USING(a)
  RIGHT JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  15 15 15 15 15 15
  17 17  - 17  - 17
  18  - 18 18  - 18
  19  -  -  -  - 19
}
do_execsql_test joinB-430 {
  SELECT a, b, c, d, e, f, g
  FROM t1
  FULL JOIN t2 USING(a,b)
  LEFT JOIN t3 USING(a,b)
  LEFT JOIN t4 USING(a,b)
  RIGHT JOIN t5 USING(a,b)
  WHERE d<>33 OR d IS NULL
  ORDER BY 1 NULLS FIRST;
} {
  15 25 35 35 35 35 35
  17 27 37  - 37  - 37
  18 28  - 38 38  - 38
  19 29  -  -  -  - 39
}
do_execsql_test joinB-431 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  FULL JOIN t2 USING(a)
  LEFT JOIN t3 USING(a)
  LEFT JOIN t4 USING(a)
  FULL JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
   -  -  -  -  -  -
  11 11  - 11 11  -
  12 12 12 12  -  -
  13  - 13 13 13  -
  15 15 15 15 15 15
  17 17  - 17  - 17
  18  - 18 18  - 18
  19  -  -  -  - 19
}
do_execsql_test joinB-432 {
  SELECT b, c, d, e, f, g
  FROM t1
  NATURAL FULL JOIN t2
  NATURAL LEFT JOIN t3
  NATURAL LEFT JOIN t4
  NATURAL FULL JOIN t5
  WHERE b BETWEEN 12 AND 17
  ORDER BY 1 NULLS FIRST;
} {
}
do_execsql_test joinB-433 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  FULL JOIN t2 USING(a)
  LEFT JOIN t3 USING(a)
  RIGHT JOIN t4 USING(a)
  INNER JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  15 15 15 15 15 15
  19  -  -  - 19 19
}
do_execsql_test joinB-434 {
  SELECT a, c, d, e, f, g
  FROM t1
  FULL JOIN t2 USING(a,b)
  LEFT JOIN t3 USING(a,b)
  RIGHT JOIN t4 USING(a,b)
  INNER JOIN t5 USING(a,b)
  WHERE a<>13
  ORDER BY 1 NULLS FIRST;
} {
  15 35 35 35 35 35
  19  -  -  - 39 39
}
do_execsql_test joinB-435 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  FULL JOIN t2 USING(a)
  LEFT JOIN t3 USING(a)
  RIGHT JOIN t4 USING(a)
  LEFT JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  11 11  - 11 11  -
  13  - 13 13 13  -
  15 15 15 15 15 15
  19  -  -  - 19 19
}
do_execsql_test joinB-436 {
  SELECT a, c, d, e, f, g
  FROM t1
  FULL JOIN (t2 LEFT JOIN t3 USING(a)) USING(a)
  RIGHT JOIN (t4 LEFT JOIN t5 USING(a)) USING(a)
  WHERE a<=18
  ORDER BY 1 NULLS FIRST;
} {
  11 31  -  - 31  -
  13  - 33 33 33  -
  15 35 35 35 35 35
}
do_execsql_test joinB-437 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  FULL JOIN t2 USING(a)
  LEFT JOIN t3 USING(a)
  RIGHT JOIN t4 USING(a)
  RIGHT JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  15 15 15 15 15 15
  17  -  -  -  - 17
  18  -  -  -  - 18
  19  -  -  - 19 19
}
do_execsql_test joinB-438 {
  SELECT a, b, c, d, e, f, g
  FROM t1
  FULL JOIN t2 USING(a,b)
  LEFT JOIN t3 USING(a,b)
  RIGHT JOIN t4 USING(a,b)
  RIGHT JOIN t5 USING(a,b)
  WHERE d<>33 OR d IS NULL
  ORDER BY 1 NULLS FIRST;
} {
  15 25 35 35 35 35 35
  17 27  -  -  -  - 37
  18 28  -  -  -  - 38
  19 29  -  -  - 39 39
}
do_execsql_test joinB-439 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  FULL JOIN t2 USING(a)
  LEFT JOIN t3 USING(a)
  RIGHT JOIN t4 USING(a)
  FULL JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  11 11  - 11 11  -
  13  - 13 13 13  -
  15 15 15 15 15 15
  17  -  -  -  - 17
  18  -  -  -  - 18
  19  -  -  - 19 19
}
do_execsql_test joinB-440 {
  SELECT b, c, d, e, f, g
  FROM t1
  NATURAL FULL JOIN t2
  NATURAL LEFT JOIN t3
  NATURAL RIGHT JOIN t4
  NATURAL FULL JOIN t5
  WHERE b BETWEEN 12 AND 17
  ORDER BY 1 NULLS FIRST;
} {
}
do_execsql_test joinB-441 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  FULL JOIN t2 USING(a)
  LEFT JOIN t3 USING(a)
  FULL JOIN t4 USING(a)
  INNER JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  15 15 15 15 15 15
  17 17  - 17  - 17
  18  - 18 18  - 18
  19  -  -  - 19 19
}
do_execsql_test joinB-442 {
  SELECT a, c, d, e, f, g
  FROM t1
  FULL JOIN t2 USING(a,b)
  LEFT JOIN t3 USING(a,b)
  FULL JOIN t4 USING(a,b)
  INNER JOIN t5 USING(a,b)
  WHERE a<>13
  ORDER BY 1 NULLS FIRST;
} {
  15 35 35 35 35 35
  17 37  - 37  - 37
  18  - 38 38  - 38
  19  -  -  - 39 39
}
do_execsql_test joinB-443 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  FULL JOIN t2 USING(a)
  LEFT JOIN t3 USING(a)
  FULL JOIN t4 USING(a)
  LEFT JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
   -  -  -  -  -  -
  11 11  - 11 11  -
  12 12 12 12  -  -
  13  - 13 13 13  -
  15 15 15 15 15 15
  17 17  - 17  - 17
  18  - 18 18  - 18
  19  -  -  - 19 19
}
do_execsql_test joinB-444 {
  SELECT a, c, d, e, f, g
  FROM t1
  FULL JOIN (t2 LEFT JOIN t3 USING(a)) USING(a)
  FULL JOIN (t4 LEFT JOIN t5 USING(a)) USING(a)
  WHERE a<=18
  ORDER BY 1 NULLS FIRST;
} {
  11 31  -  - 31  -
  12 32 32 32  -  -
  13  - 33 33 33  -
  15 35 35 35 35 35
  17 37  -  -  -  -
  18  - 38 38  -  -
}
do_execsql_test joinB-445 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  FULL JOIN t2 USING(a)
  LEFT JOIN t3 USING(a)
  FULL JOIN t4 USING(a)
  RIGHT JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  15 15 15 15 15 15
  17 17  - 17  - 17
  18  - 18 18  - 18
  19  -  -  - 19 19
}
do_execsql_test joinB-446 {
  SELECT a, b, c, d, e, f, g
  FROM t1
  FULL JOIN t2 USING(a,b)
  LEFT JOIN t3 USING(a,b)
  FULL JOIN t4 USING(a,b)
  RIGHT JOIN t5 USING(a,b)
  WHERE d<>33 OR d IS NULL
  ORDER BY 1 NULLS FIRST;
} {
  15 25 35 35 35 35 35
  17 27 37  - 37  - 37
  18 28  - 38 38  - 38
  19 29  -  -  - 39 39
}
do_execsql_test joinB-447 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  FULL JOIN t2 USING(a)
  LEFT JOIN t3 USING(a)
  FULL JOIN t4 USING(a)
  FULL JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
   -  -  -  -  -  -
  11 11  - 11 11  -
  12 12 12 12  -  -
  13  - 13 13 13  -
  15 15 15 15 15 15
  17 17  - 17  - 17
  18  - 18 18  - 18
  19  -  -  - 19 19
}
do_execsql_test joinB-448 {
  SELECT b, c, d, e, f, g
  FROM t1
  NATURAL FULL JOIN t2
  NATURAL LEFT JOIN t3
  NATURAL FULL JOIN t4
  NATURAL FULL JOIN t5
  WHERE b BETWEEN 12 AND 17
  ORDER BY 1 NULLS FIRST;
} {
}
do_execsql_test joinB-449 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  FULL JOIN t2 USING(a)
  RIGHT JOIN t3 USING(a)
  INNER JOIN t4 USING(a)
  INNER JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  15 15 15 15 15 15
  19  -  - 19 19 19
}
do_execsql_test joinB-450 {
  SELECT a, c, d, e, f, g
  FROM t1
  FULL JOIN t2 USING(a,b)
  RIGHT JOIN t3 USING(a,b)
  INNER JOIN t4 USING(a,b)
  INNER JOIN t5 USING(a,b)
  WHERE a<>13
  ORDER BY 1 NULLS FIRST;
} {
  15 35 35 35 35 35
  19  -  - 39 39 39
}
do_execsql_test joinB-451 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  FULL JOIN t2 USING(a)
  RIGHT JOIN t3 USING(a)
  INNER JOIN t4 USING(a)
  LEFT JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  11 11  - 11 11  -
  13  - 13 13 13  -
  15 15 15 15 15 15
  19  -  - 19 19 19
}
do_execsql_test joinB-452 {
  SELECT a, c, d, e, f, g
  FROM t1
  FULL JOIN (t2 RIGHT JOIN t3 USING(a)) USING(a)
  INNER JOIN (t4 LEFT JOIN t5 USING(a)) USING(a)
  WHERE a<=18
  ORDER BY 1 NULLS FIRST;
} {
  11 31  - 31 31  -
  13  - 33 33 33  -
  15 35 35 35 35 35
}
do_execsql_test joinB-453 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  FULL JOIN t2 USING(a)
  RIGHT JOIN t3 USING(a)
  INNER JOIN t4 USING(a)
  RIGHT JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  15 15 15 15 15 15
  17  -  -  -  - 17
  18  -  -  -  - 18
  19  -  - 19 19 19
}
do_execsql_test joinB-454 {
  SELECT a, b, c, d, e, f, g
  FROM t1
  FULL JOIN t2 USING(a,b)
  RIGHT JOIN t3 USING(a,b)
  INNER JOIN t4 USING(a,b)
  RIGHT JOIN t5 USING(a,b)
  WHERE d<>33 OR d IS NULL
  ORDER BY 1 NULLS FIRST;
} {
  15 25 35 35 35 35 35
  17 27  -  -  -  - 37
  18 28  -  -  -  - 38
  19 29  -  - 39 39 39
}
do_execsql_test joinB-455 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  FULL JOIN t2 USING(a)
  RIGHT JOIN t3 USING(a)
  INNER JOIN t4 USING(a)
  FULL JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  11 11  - 11 11  -
  13  - 13 13 13  -
  15 15 15 15 15 15
  17  -  -  -  - 17
  18  -  -  -  - 18
  19  -  - 19 19 19
}
do_execsql_test joinB-456 {
  SELECT b, c, d, e, f, g
  FROM t1
  NATURAL FULL JOIN t2
  NATURAL RIGHT JOIN t3
  NATURAL INNER JOIN t4
  NATURAL FULL JOIN t5
  WHERE b BETWEEN 12 AND 17
  ORDER BY 1 NULLS FIRST;
} {
}
do_execsql_test joinB-457 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  FULL JOIN t2 USING(a)
  RIGHT JOIN t3 USING(a)
  LEFT JOIN t4 USING(a)
  INNER JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  15 15 15 15 15 15
  17 17  - 17  - 17
  18  - 18 18  - 18
  19  -  - 19 19 19
}
do_execsql_test joinB-458 {
  SELECT a, c, d, e, f, g
  FROM t1
  FULL JOIN t2 USING(a,b)
  RIGHT JOIN t3 USING(a,b)
  LEFT JOIN t4 USING(a,b)
  INNER JOIN t5 USING(a,b)
  WHERE a<>13
  ORDER BY 1 NULLS FIRST;
} {
  15 35 35 35 35 35
  17 37  - 37  - 37
  18  - 38 38  - 38
  19  -  - 39 39 39
}
do_execsql_test joinB-459 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  FULL JOIN t2 USING(a)
  RIGHT JOIN t3 USING(a)
  LEFT JOIN t4 USING(a)
  LEFT JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
   -  -  -  -  -  -
  11 11  - 11 11  -
  12 12 12 12  -  -
  13  - 13 13 13  -
  15 15 15 15 15 15
  17 17  - 17  - 17
  18  - 18 18  - 18
  19  -  - 19 19 19
}
do_execsql_test joinB-460 {
  SELECT a, c, d, e, f, g
  FROM t1
  FULL JOIN (t2 RIGHT JOIN t3 USING(a)) USING(a)
  LEFT JOIN (t4 LEFT JOIN t5 USING(a)) USING(a)
  WHERE a<=18
  ORDER BY 1 NULLS FIRST;
} {
  11 31  - 31 31  -
  12 32 32 32  -  -
  13  - 33 33 33  -
  15 35 35 35 35 35
  17 37  - 37  -  -
  18  - 38 38  -  -
}
do_execsql_test joinB-461 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  FULL JOIN t2 USING(a)
  RIGHT JOIN t3 USING(a)
  LEFT JOIN t4 USING(a)
  RIGHT JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  15 15 15 15 15 15
  17 17  - 17  - 17
  18  - 18 18  - 18
  19  -  - 19 19 19
}
do_execsql_test joinB-462 {
  SELECT a, b, c, d, e, f, g
  FROM t1
  FULL JOIN t2 USING(a,b)
  RIGHT JOIN t3 USING(a,b)
  LEFT JOIN t4 USING(a,b)
  RIGHT JOIN t5 USING(a,b)
  WHERE d<>33 OR d IS NULL
  ORDER BY 1 NULLS FIRST;
} {
  15 25 35 35 35 35 35
  17 27 37  - 37  - 37
  18 28  - 38 38  - 38
  19 29  -  - 39 39 39
}
do_execsql_test joinB-463 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  FULL JOIN t2 USING(a)
  RIGHT JOIN t3 USING(a)
  LEFT JOIN t4 USING(a)
  FULL JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
   -  -  -  -  -  -
  11 11  - 11 11  -
  12 12 12 12  -  -
  13  - 13 13 13  -
  15 15 15 15 15 15
  17 17  - 17  - 17
  18  - 18 18  - 18
  19  -  - 19 19 19
}
do_execsql_test joinB-464 {
  SELECT b, c, d, e, f, g
  FROM t1
  NATURAL FULL JOIN t2
  NATURAL RIGHT JOIN t3
  NATURAL LEFT JOIN t4
  NATURAL FULL JOIN t5
  WHERE b BETWEEN 12 AND 17
  ORDER BY 1 NULLS FIRST;
} {
}
do_execsql_test joinB-465 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  FULL JOIN t2 USING(a)
  RIGHT JOIN t3 USING(a)
  RIGHT JOIN t4 USING(a)
  INNER JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  15 15 15 15 15 15
  19  -  - 19 19 19
}
do_execsql_test joinB-466 {
  SELECT a, c, d, e, f, g
  FROM t1
  FULL JOIN t2 USING(a,b)
  RIGHT JOIN t3 USING(a,b)
  RIGHT JOIN t4 USING(a,b)
  INNER JOIN t5 USING(a,b)
  WHERE a<>13
  ORDER BY 1 NULLS FIRST;
} {
  15 35 35 35 35 35
  19  -  - 39 39 39
}
do_execsql_test joinB-467 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  FULL JOIN t2 USING(a)
  RIGHT JOIN t3 USING(a)
  RIGHT JOIN t4 USING(a)
  LEFT JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  11 11  - 11 11  -
  13  - 13 13 13  -
  15 15 15 15 15 15
  19  -  - 19 19 19
}
do_execsql_test joinB-468 {
  SELECT a, c, d, e, f, g
  FROM t1
  FULL JOIN (t2 RIGHT JOIN t3 USING(a)) USING(a)
  RIGHT JOIN (t4 LEFT JOIN t5 USING(a)) USING(a)
  WHERE a<=18
  ORDER BY 1 NULLS FIRST;
} {
  11 31  - 31 31  -
  13  - 33 33 33  -
  15 35 35 35 35 35
}
do_execsql_test joinB-469 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  FULL JOIN t2 USING(a)
  RIGHT JOIN t3 USING(a)
  RIGHT JOIN t4 USING(a)
  RIGHT JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  15 15 15 15 15 15
  17  -  -  -  - 17
  18  -  -  -  - 18
  19  -  - 19 19 19
}
do_execsql_test joinB-470 {
  SELECT a, b, c, d, e, f, g
  FROM t1
  FULL JOIN t2 USING(a,b)
  RIGHT JOIN t3 USING(a,b)
  RIGHT JOIN t4 USING(a,b)
  RIGHT JOIN t5 USING(a,b)
  WHERE d<>33 OR d IS NULL
  ORDER BY 1 NULLS FIRST;
} {
  15 25 35 35 35 35 35
  17 27  -  -  -  - 37
  18 28  -  -  -  - 38
  19 29  -  - 39 39 39
}
do_execsql_test joinB-471 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  FULL JOIN t2 USING(a)
  RIGHT JOIN t3 USING(a)
  RIGHT JOIN t4 USING(a)
  FULL JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  11 11  - 11 11  -
  13  - 13 13 13  -
  15 15 15 15 15 15
  17  -  -  -  - 17
  18  -  -  -  - 18
  19  -  - 19 19 19
}
do_execsql_test joinB-472 {
  SELECT b, c, d, e, f, g
  FROM t1
  NATURAL FULL JOIN t2
  NATURAL RIGHT JOIN t3
  NATURAL RIGHT JOIN t4
  NATURAL FULL JOIN t5
  WHERE b BETWEEN 12 AND 17
  ORDER BY 1 NULLS FIRST;
} {
}
do_execsql_test joinB-473 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  FULL JOIN t2 USING(a)
  RIGHT JOIN t3 USING(a)
  FULL JOIN t4 USING(a)
  INNER JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  15 15 15 15 15 15
  17 17  - 17  - 17
  18  - 18 18  - 18
  19  -  - 19 19 19
}
do_execsql_test joinB-474 {
  SELECT a, c, d, e, f, g
  FROM t1
  FULL JOIN t2 USING(a,b)
  RIGHT JOIN t3 USING(a,b)
  FULL JOIN t4 USING(a,b)
  INNER JOIN t5 USING(a,b)
  WHERE a<>13
  ORDER BY 1 NULLS FIRST;
} {
  15 35 35 35 35 35
  17 37  - 37  - 37
  18  - 38 38  - 38
  19  -  - 39 39 39
}
do_execsql_test joinB-475 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  FULL JOIN t2 USING(a)
  RIGHT JOIN t3 USING(a)
  FULL JOIN t4 USING(a)
  LEFT JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
   -  -  -  -  -  -
  11 11  - 11 11  -
  12 12 12 12  -  -
  13  - 13 13 13  -
  15 15 15 15 15 15
  17 17  - 17  - 17
  18  - 18 18  - 18
  19  -  - 19 19 19
}
do_execsql_test joinB-476 {
  SELECT a, c, d, e, f, g
  FROM t1
  FULL JOIN (t2 RIGHT JOIN t3 USING(a)) USING(a)
  FULL JOIN (t4 LEFT JOIN t5 USING(a)) USING(a)
  WHERE a<=18
  ORDER BY 1 NULLS FIRST;
} {
  11 31  - 31 31  -
  12 32 32 32  -  -
  13  - 33 33 33  -
  15 35 35 35 35 35
  17 37  - 37  -  -
  18  - 38 38  -  -
}
do_execsql_test joinB-477 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  FULL JOIN t2 USING(a)
  RIGHT JOIN t3 USING(a)
  FULL JOIN t4 USING(a)
  RIGHT JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  15 15 15 15 15 15
  17 17  - 17  - 17
  18  - 18 18  - 18
  19  -  - 19 19 19
}
do_execsql_test joinB-478 {
  SELECT a, b, c, d, e, f, g
  FROM t1
  FULL JOIN t2 USING(a,b)
  RIGHT JOIN t3 USING(a,b)
  FULL JOIN t4 USING(a,b)
  RIGHT JOIN t5 USING(a,b)
  WHERE d<>33 OR d IS NULL
  ORDER BY 1 NULLS FIRST;
} {
  15 25 35 35 35 35 35
  17 27 37  - 37  - 37
  18 28  - 38 38  - 38
  19 29  -  - 39 39 39
}
do_execsql_test joinB-479 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  FULL JOIN t2 USING(a)
  RIGHT JOIN t3 USING(a)
  FULL JOIN t4 USING(a)
  FULL JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
   -  -  -  -  -  -
  11 11  - 11 11  -
  12 12 12 12  -  -
  13  - 13 13 13  -
  15 15 15 15 15 15
  17 17  - 17  - 17
  18  - 18 18  - 18
  19  -  - 19 19 19
}
do_execsql_test joinB-480 {
  SELECT b, c, d, e, f, g
  FROM t1
  NATURAL FULL JOIN t2
  NATURAL RIGHT JOIN t3
  NATURAL FULL JOIN t4
  NATURAL FULL JOIN t5
  WHERE b BETWEEN 12 AND 17
  ORDER BY 1 NULLS FIRST;
} {
}
do_execsql_test joinB-481 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  FULL JOIN t2 USING(a)
  FULL JOIN t3 USING(a)
  INNER JOIN t4 USING(a)
  INNER JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  15 15 15 15 15 15
  19  -  - 19 19 19
}
do_execsql_test joinB-482 {
  SELECT a, c, d, e, f, g
  FROM t1
  FULL JOIN t2 USING(a,b)
  FULL JOIN t3 USING(a,b)
  INNER JOIN t4 USING(a,b)
  INNER JOIN t5 USING(a,b)
  WHERE a<>13
  ORDER BY 1 NULLS FIRST;
} {
  15 35 35 35 35 35
  19  -  - 39 39 39
}
do_execsql_test joinB-483 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  FULL JOIN t2 USING(a)
  FULL JOIN t3 USING(a)
  INNER JOIN t4 USING(a)
  LEFT JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  11 11  - 11 11  -
  13  - 13 13 13  -
  15 15 15 15 15 15
  19  -  - 19 19 19
}
do_execsql_test joinB-484 {
  SELECT a, c, d, e, f, g
  FROM t1
  FULL JOIN (t2 FULL JOIN t3 USING(a)) USING(a)
  INNER JOIN (t4 LEFT JOIN t5 USING(a)) USING(a)
  WHERE a<=18
  ORDER BY 1 NULLS FIRST;
} {
  11 31  - 31 31  -
  13  - 33 33 33  -
  15 35 35 35 35 35
}
do_execsql_test joinB-485 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  FULL JOIN t2 USING(a)
  FULL JOIN t3 USING(a)
  INNER JOIN t4 USING(a)
  RIGHT JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  15 15 15 15 15 15
  17  -  -  -  - 17
  18  -  -  -  - 18
  19  -  - 19 19 19
}
do_execsql_test joinB-486 {
  SELECT a, b, c, d, e, f, g
  FROM t1
  FULL JOIN t2 USING(a,b)
  FULL JOIN t3 USING(a,b)
  INNER JOIN t4 USING(a,b)
  RIGHT JOIN t5 USING(a,b)
  WHERE d<>33 OR d IS NULL
  ORDER BY 1 NULLS FIRST;
} {
  15 25 35 35 35 35 35
  17 27  -  -  -  - 37
  18 28  -  -  -  - 38
  19 29  -  - 39 39 39
}
do_execsql_test joinB-487 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  FULL JOIN t2 USING(a)
  FULL JOIN t3 USING(a)
  INNER JOIN t4 USING(a)
  FULL JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  11 11  - 11 11  -
  13  - 13 13 13  -
  15 15 15 15 15 15
  17  -  -  -  - 17
  18  -  -  -  - 18
  19  -  - 19 19 19
}
do_execsql_test joinB-488 {
  SELECT b, c, d, e, f, g
  FROM t1
  NATURAL FULL JOIN t2
  NATURAL FULL JOIN t3
  NATURAL INNER JOIN t4
  NATURAL FULL JOIN t5
  WHERE b BETWEEN 12 AND 17
  ORDER BY 1 NULLS FIRST;
} {
}
do_execsql_test joinB-489 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  FULL JOIN t2 USING(a)
  FULL JOIN t3 USING(a)
  LEFT JOIN t4 USING(a)
  INNER JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  15 15 15 15 15 15
  17 17  - 17  - 17
  18  - 18 18  - 18
  19  -  - 19 19 19
}
do_execsql_test joinB-490 {
  SELECT a, c, d, e, f, g
  FROM t1
  FULL JOIN t2 USING(a,b)
  FULL JOIN t3 USING(a,b)
  LEFT JOIN t4 USING(a,b)
  INNER JOIN t5 USING(a,b)
  WHERE a<>13
  ORDER BY 1 NULLS FIRST;
} {
  15 35 35 35 35 35
  17 37  - 37  - 37
  18  - 38 38  - 38
  19  -  - 39 39 39
}
do_execsql_test joinB-491 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  FULL JOIN t2 USING(a)
  FULL JOIN t3 USING(a)
  LEFT JOIN t4 USING(a)
  LEFT JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
   -  -  -  -  -  -
   -  -  -  -  -  -
  11 11  - 11 11  -
  12 12 12 12  -  -
  13  - 13 13 13  -
  15 15 15 15 15 15
  17 17  - 17  - 17
  18  - 18 18  - 18
  19  -  - 19 19 19
}
do_execsql_test joinB-492 {
  SELECT a, c, d, e, f, g
  FROM t1
  FULL JOIN (t2 FULL JOIN t3 USING(a)) USING(a)
  LEFT JOIN (t4 LEFT JOIN t5 USING(a)) USING(a)
  WHERE a<=18
  ORDER BY 1 NULLS FIRST;
} {
  11 31  - 31 31  -
  12 32 32 32  -  -
  13  - 33 33 33  -
  15 35 35 35 35 35
  17 37  - 37  -  -
  18  - 38 38  -  -
}
do_execsql_test joinB-493 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  FULL JOIN t2 USING(a)
  FULL JOIN t3 USING(a)
  LEFT JOIN t4 USING(a)
  RIGHT JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  15 15 15 15 15 15
  17 17  - 17  - 17
  18  - 18 18  - 18
  19  -  - 19 19 19
}
do_execsql_test joinB-494 {
  SELECT a, b, c, d, e, f, g
  FROM t1
  FULL JOIN t2 USING(a,b)
  FULL JOIN t3 USING(a,b)
  LEFT JOIN t4 USING(a,b)
  RIGHT JOIN t5 USING(a,b)
  WHERE d<>33 OR d IS NULL
  ORDER BY 1 NULLS FIRST;
} {
  15 25 35 35 35 35 35
  17 27 37  - 37  - 37
  18 28  - 38 38  - 38
  19 29  -  - 39 39 39
}
do_execsql_test joinB-495 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  FULL JOIN t2 USING(a)
  FULL JOIN t3 USING(a)
  LEFT JOIN t4 USING(a)
  FULL JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
   -  -  -  -  -  -
   -  -  -  -  -  -
  11 11  - 11 11  -
  12 12 12 12  -  -
  13  - 13 13 13  -
  15 15 15 15 15 15
  17 17  - 17  - 17
  18  - 18 18  - 18
  19  -  - 19 19 19
}
do_execsql_test joinB-496 {
  SELECT b, c, d, e, f, g
  FROM t1
  NATURAL FULL JOIN t2
  NATURAL FULL JOIN t3
  NATURAL LEFT JOIN t4
  NATURAL FULL JOIN t5
  WHERE b BETWEEN 12 AND 17
  ORDER BY 1 NULLS FIRST;
} {
}
do_execsql_test joinB-497 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  FULL JOIN t2 USING(a)
  FULL JOIN t3 USING(a)
  RIGHT JOIN t4 USING(a)
  INNER JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  15 15 15 15 15 15
  19  -  - 19 19 19
}
do_execsql_test joinB-498 {
  SELECT a, c, d, e, f, g
  FROM t1
  FULL JOIN t2 USING(a,b)
  FULL JOIN t3 USING(a,b)
  RIGHT JOIN t4 USING(a,b)
  INNER JOIN t5 USING(a,b)
  WHERE a<>13
  ORDER BY 1 NULLS FIRST;
} {
  15 35 35 35 35 35
  19  -  - 39 39 39
}
do_execsql_test joinB-499 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  FULL JOIN t2 USING(a)
  FULL JOIN t3 USING(a)
  RIGHT JOIN t4 USING(a)
  LEFT JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  11 11  - 11 11  -
  13  - 13 13 13  -
  15 15 15 15 15 15
  19  -  - 19 19 19
}
do_execsql_test joinB-500 {
  SELECT a, c, d, e, f, g
  FROM t1
  FULL JOIN (t2 FULL JOIN t3 USING(a)) USING(a)
  RIGHT JOIN (t4 LEFT JOIN t5 USING(a)) USING(a)
  WHERE a<=18
  ORDER BY 1 NULLS FIRST;
} {
  11 31  - 31 31  -
  13  - 33 33 33  -
  15 35 35 35 35 35
}
do_execsql_test joinB-501 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  FULL JOIN t2 USING(a)
  FULL JOIN t3 USING(a)
  RIGHT JOIN t4 USING(a)
  RIGHT JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  15 15 15 15 15 15
  17  -  -  -  - 17
  18  -  -  -  - 18
  19  -  - 19 19 19
}
do_execsql_test joinB-502 {
  SELECT a, b, c, d, e, f, g
  FROM t1
  FULL JOIN t2 USING(a,b)
  FULL JOIN t3 USING(a,b)
  RIGHT JOIN t4 USING(a,b)
  RIGHT JOIN t5 USING(a,b)
  WHERE d<>33 OR d IS NULL
  ORDER BY 1 NULLS FIRST;
} {
  15 25 35 35 35 35 35
  17 27  -  -  -  - 37
  18 28  -  -  -  - 38
  19 29  -  - 39 39 39
}
do_execsql_test joinB-503 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  FULL JOIN t2 USING(a)
  FULL JOIN t3 USING(a)
  RIGHT JOIN t4 USING(a)
  FULL JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  11 11  - 11 11  -
  13  - 13 13 13  -
  15 15 15 15 15 15
  17  -  -  -  - 17
  18  -  -  -  - 18
  19  -  - 19 19 19
}
do_execsql_test joinB-504 {
  SELECT b, c, d, e, f, g
  FROM t1
  NATURAL FULL JOIN t2
  NATURAL FULL JOIN t3
  NATURAL RIGHT JOIN t4
  NATURAL FULL JOIN t5
  WHERE b BETWEEN 12 AND 17
  ORDER BY 1 NULLS FIRST;
} {
}
do_execsql_test joinB-505 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  FULL JOIN t2 USING(a)
  FULL JOIN t3 USING(a)
  FULL JOIN t4 USING(a)
  INNER JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  15 15 15 15 15 15
  17 17  - 17  - 17
  18  - 18 18  - 18
  19  -  - 19 19 19
}
do_execsql_test joinB-506 {
  SELECT a, c, d, e, f, g
  FROM t1
  FULL JOIN t2 USING(a,b)
  FULL JOIN t3 USING(a,b)
  FULL JOIN t4 USING(a,b)
  INNER JOIN t5 USING(a,b)
  WHERE a<>13
  ORDER BY 1 NULLS FIRST;
} {
  15 35 35 35 35 35
  17 37  - 37  - 37
  18  - 38 38  - 38
  19  -  - 39 39 39
}
do_execsql_test joinB-507 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  FULL JOIN t2 USING(a)
  FULL JOIN t3 USING(a)
  FULL JOIN t4 USING(a)
  LEFT JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
   -  -  -  -  -  -
   -  -  -  -  -  -
  11 11  - 11 11  -
  12 12 12 12  -  -
  13  - 13 13 13  -
  15 15 15 15 15 15
  17 17  - 17  - 17
  18  - 18 18  - 18
  19  -  - 19 19 19
}
do_execsql_test joinB-508 {
  SELECT a, c, d, e, f, g
  FROM t1
  FULL JOIN (t2 FULL JOIN t3 USING(a)) USING(a)
  FULL JOIN (t4 LEFT JOIN t5 USING(a)) USING(a)
  WHERE a<=18
  ORDER BY 1 NULLS FIRST;
} {
  11 31  - 31 31  -
  12 32 32 32  -  -
  13  - 33 33 33  -
  15 35 35 35 35 35
  17 37  - 37  -  -
  18  - 38 38  -  -
}
do_execsql_test joinB-509 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  FULL JOIN t2 USING(a)
  FULL JOIN t3 USING(a)
  FULL JOIN t4 USING(a)
  RIGHT JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
  15 15 15 15 15 15
  17 17  - 17  - 17
  18  - 18 18  - 18
  19  -  - 19 19 19
}
do_execsql_test joinB-510 {
  SELECT a, b, c, d, e, f, g
  FROM t1
  FULL JOIN t2 USING(a,b)
  FULL JOIN t3 USING(a,b)
  FULL JOIN t4 USING(a,b)
  RIGHT JOIN t5 USING(a,b)
  WHERE d<>33 OR d IS NULL
  ORDER BY 1 NULLS FIRST;
} {
  15 25 35 35 35 35 35
  17 27 37  - 37  - 37
  18 28  - 38 38  - 38
  19 29  -  - 39 39 39
}
do_execsql_test joinB-511 {
  SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
  FROM t1
  FULL JOIN t2 USING(a)
  FULL JOIN t3 USING(a)
  FULL JOIN t4 USING(a)
  FULL JOIN t5 USING(a)
  ORDER BY 1 NULLS FIRST;
} {
   -  -  -  -  -  -
   -  -  -  -  -  -
  11 11  - 11 11  -
  12 12 12 12  -  -
  13  - 13 13 13  -
  15 15 15 15 15 15
  17 17  - 17  - 17
  18  - 18 18  - 18
  19  -  - 19 19 19
}
do_execsql_test joinB-512 {
  SELECT b, c, d, e, f, g
  FROM t1
  NATURAL FULL JOIN t2
  NATURAL FULL JOIN t3
  NATURAL FULL JOIN t4
  NATURAL FULL JOIN t5
  WHERE b BETWEEN 12 AND 17
  ORDER BY 1 NULLS FIRST;
} {
}
finish_test

##############################################################################
# Here is the original TCL script that generated the psql input file:
#
# 
# puts "
# \\pset border off
# \\pset tuples_only on
# \\pset null -
# 
# DROP TABLE IF EXISTS t1;
# DROP TABLE IF EXISTS t2;
# DROP TABLE IF EXISTS t3;
# DROP TABLE IF EXISTS t4;
# DROP TABLE IF EXISTS t5;
# CREATE TABLE t1(a INT, b INT, c INT);
# CREATE TABLE t2(a INT, b INT, d INT);
# CREATE TABLE t3(a INT, b INT, e INT);
# CREATE TABLE t4(a INT, b INT, f INT);
# CREATE TABLE t5(a INT, b INT, g INT);
# INSERT INTO t1 VALUES(11,21,31),(12,22,32),(15,25,35),(17,27,37);
# INSERT INTO t2 VALUES(12,22,32),(13,23,33),(15,25,35),(18,28,38),(NULL,NULL,36);
# INSERT INTO t4 VALUES(11,21,31),(13,23,33),(15,25,35),(19,29,39);
# INSERT INTO t3 SELECT * FROM t1 UNION SELECT * FROM t2 UNION SELECT * FROM t4;
# INSERT INTO t5 SELECT * FROM t3 WHERE a>=15;
# "
# 
# proc echo {prefix txt} {
#   regsub -all {\n} $txt \n$prefix txt
#   puts "$prefix$txt"
# }
# 
# set n 0
# set k 0
# foreach j1 {INNER LEFT RIGHT FULL} {
#   foreach j2 {INNER LEFT RIGHT FULL} {
#     foreach j3 {INNER LEFT RIGHT FULL} {
#       foreach j4 {INNER LEFT RIGHT FULL} {
# 
# incr n
# incr k
# set q1 ""
# append q1 "SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a\n"
# append q1 "  FROM t1\n"
# append q1 "       $j1 JOIN t2 USING(a)\n"
# append q1 "       $j2 JOIN t3 USING(a)\n"
# append q1 "       $j3 JOIN t4 USING(a)\n"
# append q1 "       $j4 JOIN t5 USING(a)\n"
# append q1 " ORDER BY 1 NULLS FIRST;"
# 
# echo "\\qecho " "do_execsql_test joinB-$n \{"
# echo "\\qecho X  " $q1
# echo "\\qecho " "\} \{"
# puts $q1
# echo "\\qecho " "\}"
# 
# switch [expr {$k%4}] {
#   0 {
#     set q2 ""
#     append q2 "SELECT b, c, d, e, f, g\n"
#     append q2 "  FROM t1\n"
#     append q2 "       NATURAL $j1 JOIN t2\n"
#     append q2 "       NATURAL $j2 JOIN t3\n"
#     append q2 "       NATURAL $j3 JOIN t4\n"
#     append q2 "       NATURAL $j4 JOIN t5\n"
#     append q2 " WHERE b BETWEEN 12 AND 17\n"
#     append q2 " ORDER BY 1 NULLS FIRST;"
#     incr n
#     echo "\\qecho " "do_execsql_test joinB-$n \{"
#     echo "\\qecho X  " $q2
#     echo "\\qecho " "\} \{"
#     puts $q2
#     echo "\\qecho " "\}"
#   }
#   1 {
#     set q2 ""
#     append q2 "SELECT a, c, d, e, f, g\n"
#     append q2 "  FROM t1\n"
#     append q2 "       $j1 JOIN t2 USING(a,b)\n"
#     append q2 "       $j2 JOIN t3 USING(a,b)\n"
#     append q2 "       $j3 JOIN t4 USING(a,b)\n"
#     append q2 "       $j4 JOIN t5 USING(a,b)\n"
#     append q2 " WHERE a<>13\n"
#     append q2 " ORDER BY 1 NULLS FIRST;"
#     incr n
#     echo "\\qecho " "do_execsql_test joinB-$n \{"
#     echo "\\qecho X  " $q2
#     echo "\\qecho " "\} \{"
#     puts $q2
#     echo "\\qecho " "\}"
#   }
#   2 {
#     set q2 ""
#     append q2 "SELECT a, c, d, e, f, g\n"
#     append q2 "  FROM t1\n"
#     append q2 "       $j1 JOIN (t2 $j2 JOIN t3 USING(a)) USING(a)\n"
#     append q2 "       $j3 JOIN (t4 $j4 JOIN t5 USING(a)) USING(a)\n"
#     append q2 " WHERE a<=18\n"
#     append q2 " ORDER BY 1 NULLS FIRST;"
#     incr n
#     echo "\\qecho " "do_execsql_test joinB-$n \{"
#     echo "\\qecho X  " $q2
#     echo "\\qecho " "\} \{"
#     puts $q2
#     echo "\\qecho " "\}"
#   }
#   3 {
#     set q2 ""
#     append q2 "SELECT a, b, c, d, e, f, g\n"
#     append q2 "  FROM t1\n"
#     append q2 "       $j1 JOIN t2 USING(a,b)\n"
#     append q2 "       $j2 JOIN t3 USING(a,b)\n"
#     append q2 "       $j3 JOIN t4 USING(a,b)\n"
#     append q2 "       $j4 JOIN t5 USING(a,b)\n"
#     append q2 " WHERE d<>33 OR d IS NULL\n"
#     append q2 " ORDER BY 1 NULLS FIRST;"
#     incr n
#     echo "\\qecho " "do_execsql_test joinB-$n \{"
#     echo "\\qecho X  " $q2
#     echo "\\qecho " "\} \{"
#     puts $q2
#     echo "\\qecho " "\}"
#   }
# }
# 
#       }
#     }
#   }
# }
##############################################################################