Import SQLite 3.10.2.

third_party/sqlite/src/test/whereD.test

 # 2012 August 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 111 matching lines @@
   INSERT INTO t3 VALUES(4, 'four', 'iv');
   INSERT INTO t3 VALUES(5, 'five', 'v');
 
   CREATE TABLE t4(x PRIMARY KEY, y);
   INSERT INTO t4 VALUES('a', 'one');
   INSERT INTO t4 VALUES('b', 'two');
 }
 
 do_searchcount_test 3.1 {
   SELECT a, b FROM t3 WHERE (a=1 AND b='one') OR (a=2 AND b='two')
-} {1 one 2 two search 2}
+} {1 one 2 two search 4}
 
 do_searchcount_test 3.2 {
   SELECT a, c FROM t3 WHERE (a=1 AND b='one') OR (a=2 AND b='two')
-} {1 i 2 ii search 4}
+} {1 i 2 ii search 6}
 
 do_searchcount_test 3.4.1 {
   SELECT y FROM t4 WHERE x='a'
 } {one search 2}
 do_searchcount_test 3.4.2 {
   SELECT a, b FROM t3 WHERE 
         (a=1 AND b=(SELECT y FROM t4 WHERE x='a')) 
      OR (a=2 AND b='two')
-} {1 one 2 two search 4}
+} {1 one 2 two search 6}
 do_searchcount_test 3.4.3 {
   SELECT a, b FROM t3 WHERE 
         (a=2 AND b='two')
      OR (a=1 AND b=(SELECT y FROM t4 WHERE x='a')) 
-} {2 two 1 one search 4}
+} {2 two 1 one search 6}
 do_searchcount_test 3.4.4 {
   SELECT a, b FROM t3 WHERE 
         (a=2 AND b=(SELECT y FROM t4 WHERE x='b')) 
      OR (a=1 AND b=(SELECT y FROM t4 WHERE x='a')) 
-} {2 two 1 one search 6}
+} {2 two 1 one search 8}
 
 do_searchcount_test 3.5.1 {
   SELECT a, b FROM t3 WHERE (a=1 AND b='one') OR rowid=4
-} {1 one 2 two search 2}
+} {1 one 2 two search 3}
 do_searchcount_test 3.5.2 {
   SELECT a, c FROM t3 WHERE (a=1 AND b='one') OR rowid=4
-} {1 i 2 ii search 2}
+} {1 i 2 ii search 3}
 
 # Ticket [d02e1406a58ea02d] (2012-10-04)
 # LEFT JOIN with an OR in the ON clause causes segfault 
 #
 do_test 4.1 {
   db eval {
     CREATE TABLE t41(a,b,c);
     INSERT INTO t41 VALUES(1,2,3), (4,5,6);
     CREATE TABLE t42(d,e,f);
     INSERT INTO t42 VALUES(3,6,9), (4,8,12);
@@ skipping 93 matching lines @@
   SELECT * FROM t WHERE
     c0=1 or  c1=1 or  c2=1 or  c3=1 or
     c4=1 or  c5=1 or  c6=1 or  c7=1 or
     c8=1 or  c9=1 or c10=1 or c11=1 or
     c12=1 or c13=1 or c14=1 or c15=1 or
     c16=1 or c17=1;
 } {1 {} {} {} {} {} {} {} {} {} {} {} {} {} {} 1 {} {}}
 
 
 finish_test