Import SQLite 3.7.6.3.

third_party/sqlite/src/test/where8.test

 # 2008 December 23
 #
 # 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 268 matching lines @@
   execsql_status {
     SELECT c FROM t1 WHERE a > (SELECT d FROM t2 WHERE e = b) OR a = 5
   }
 } {IV V 9 0}
 
 do_test where8-3.15 {
   execsql_status {
     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 
 # indexes does not change the results returned by various queries.
 #
 do_test where8-4.1 {
   execsql {
     BEGIN;
     CREATE TABLE t3(a INTEGER, b REAL, c TEXT);
     CREATE TABLE t4(f INTEGER, g REAL, h TEXT);
@@ skipping 90 matching lines @@
     INSERT INTO t4 VALUES(5028841971, 6939937510, 'light');
     INSERT INTO t4 VALUES('sometimes', 'peak', 'peak');
     INSERT INTO t4 VALUES(378678316.5, 5028841971, 'an');
     INSERT INTO t4 VALUES(378678316.5, 'his', 'Alpine');
     INSERT INTO t4 VALUES('from', 'of', 'all');
     INSERT INTO t4 VALUES(0938446095, 'same', NULL);
     INSERT INTO t4 VALUES(0938446095, 'Alpine', NULL);
     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;
   }
 } {}
 
 catch {unset results}
 catch {unset A}
 catch {unset B}
 
 set A 2
 foreach idxsql {
@@ skipping 221 matching lines @@
 190  { SELECT * FROM t3, t4 WHERE c >= f OR c = 'and' }
 191  { SELECT * FROM t3, t4 WHERE f >= 'peak' AND g > f AND h > g }
 192  { SELECT * FROM t3, t4 WHERE a >= 8979323846 AND 'same' > b OR c = 'and' }
 193  { SELECT * FROM t3, t4 WHERE c >= g OR 'writings' >= c AND b = 'all' }
 194  { SELECT * FROM t3, t4 WHERE 'remarkably' < g }
 195  { SELECT * FROM t3, t4 WHERE a BETWEEN 'or' AND 'paintings' AND g <= f }
 196  { SELECT * FROM t3, t4 WHERE 0938446095 > b OR g <= a OR h > b }
 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
       }
       list
     } {}
 
     do_test where8-4.$A.$B.2 { lsort $R } [lsort $results($B)]
   }
   incr A
@@ skipping 41 matching lines @@
   execsql {
     SELECT a, x FROM tA LEFT JOIN tB ON (
       a=1 AND b=2 AND c=3 AND d=4 AND e=5 AND f=6 AND g=7 AND h=8 AND
       i=1 AND j=2 AND k=3 AND l=4 AND m=5 AND n=6 AND o=7 AND
       (p = 1 OR p = 2 OR p = 3)
     )
   }
 } {1 {}}
 
 finish_test