Import SQLite 3.7.6.3.

third_party/sqlite/src/test/where8.test

Index: third_party/sqlite/src/test/where8.test
diff --git a/third_party/sqlite/src/test/where8.test b/third_party/sqlite/src/test/where8.test
index a8dd5ed059e6c2f0eb921b980cdb9d9fd3d5ec05..a7d5edb3fd4ddea0fd2b490b3babfba0a7c4b7d0 100644
--- a/third_party/sqlite/src/test/where8.test
+++ b/third_party/sqlite/src/test/where8.test
@@ -286,8 +286,9 @@ do_test where8-3.15 {
     SELECT c FROM t1, t2 WHERE a BETWEEN 1 AND 2 OR a = (
       SELECT sum(e IS NULL) FROM t2 AS inner WHERE t2.d>inner.d
     )
+    ORDER BY c
   }
-} {I II I II I II I II I II I II III I II III I II III I II III I II III 9 0}
+} {I I I I I I I I I I II II II II II II II II II II III III III III III 9 1}
 
 #-----------------------------------------------------------------------
 # The following tests - where8-4.* - verify that adding or removing 
@@ -398,6 +399,10 @@ do_test where8-4.1 {
     INSERT INTO t4 VALUES('his', 'of', 378678316.5);
     INSERT INTO t4 VALUES(271.2019091, 'viewed', 3282306647);
     INSERT INTO t4 VALUES('hills', 'all', 'peak');
+    CREATE TABLE t5(s);
+    INSERT INTO t5 VALUES('tab-t5');
+    CREATE TABLE t6(t);
+    INSERT INTO t6 VALUES(123456);
     COMMIT;
   }
 } {}
@@ -639,9 +644,18 @@ foreach idxsql {
 197  { SELECT * FROM t3, t4 WHERE g = 2643383279 AND f = g }
 198  { SELECT * FROM t3, t4 WHERE g < 8979323846 }
 199  { SELECT * FROM t3, t4 WHERE 'are' <= b }
+200  { SELECT * FROM t3, t4 WHERE (a=1415926535 AND f=8628034825)
+                               OR (a=6939937510 AND f=2643383279) }
+201  { SELECT * FROM t3, t4, t5, t6
+        WHERE (a=1415926535 AND f=8628034825 AND s!='hello' AND t!=5)
+           OR (a=6939937510 AND f=2643383279 AND s='tab-t5' AND t=123456) }
+202  { SELECT * FROM t3, t4, t5, t6
+        WHERE (a=1415926535 AND f=8628034825 AND s!='hello' AND t==5)
+           OR (a=6939937510 AND f=2643383279 AND s='tab-t5' AND t!=123456) }
 
   } {
     do_test where8-4.$A.$B.1 {
+      unset -nocomplain R
       set R [execsql $sql]
       if {![info exists results($B)]} {
         set results($B) $R