Import SQLite 3.10.2.

third_party/sqlite/src/test/join.test

Index: third_party/sqlite/src/test/join.test
diff --git a/third_party/sqlite/src/test/join.test b/third_party/sqlite/src/test/join.test
index 4c83fa6b3b47692100c0a3babca5b971c14d7e3f..2b6951213fe58e2938f37447101441bf2141e24d 100644
--- a/third_party/sqlite/src/test/join.test
+++ b/third_party/sqlite/src/test/join.test
@@ -687,4 +687,30 @@ ifcapable pragma&&compileoption_diags {
   }
 }
 
+
+#-------------------------------------------------------------------------
+# 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