Import SQLite 3.10.2.

third_party/sqlite/src/test/join.test

 # 2002 May 24
 #
 # 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.
 #
 #***********************************************************************
@@ skipping 669 matching lines @@
 # a problem.
 ifcapable pragma&&compileoption_diags {
   if {[lsearch [db eval {PRAGMA compile_options}] MEMDEBUG]<0} {
     jointest join-12.10 65534 {1 {at most 64 tables in a join}}
     jointest join-12.11 65535 {1 {too many references to "t14": max 65535}}
     jointest join-12.12 65536 {1 {too many references to "t14": max 65535}}
     jointest join-12.13 65537 {1 {too many references to "t14": max 65535}}
   }
 }
 
+
+#-------------------------------------------------------------------------
+# Test a problem with reordering tables following a LEFT JOIN.
+#
+do_execsql_test join-13.0 {
+  CREATE TABLE aa(a);
+  CREATE TABLE bb(b);
+  CREATE TABLE cc(c);
+
+  INSERT INTO aa VALUES(45);
+  INSERT INTO cc VALUES(45);
+  INSERT INTO cc VALUES(45);
+}
+
+do_execsql_test join-13.1 {
+  SELECT * FROM aa LEFT JOIN bb, cc WHERE cc.c=aa.a;
+} {45 {} 45 45 {} 45}
+
+# In the following, the order of [cc] and [bb] must not be exchanged, even
+# though this would be helpful if the query used an inner join.
+do_execsql_test join-13.2 {
+  CREATE INDEX ccc ON cc(c);
+  SELECT * FROM aa LEFT JOIN bb, cc WHERE cc.c=aa.a;
+} {45 {} 45 45 {} 45}
+
+
 finish_test