Import SQLite 3.10.2.

third_party/sqlite/src/test/where7.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 29 matching lines @@
     INSERT INTO t1 VALUES(1,2,3,4);
     INSERT INTO t1 VALUES(2,3,4,5);
     INSERT INTO t1 VALUES(3,4,6,8);
     INSERT INTO t1 VALUES(4,5,10,15);
     INSERT INTO t1 VALUES(5,10,100,1000);
     CREATE INDEX t1b ON t1(b);
     CREATE INDEX t1c ON t1(c);
     SELECT * FROM t1;
   }
 } {1 2 3 4 2 3 4 5 3 4 6 8 4 5 10 15 5 10 100 1000}
+do_execsql_test where7-1.1.1 {
+  CREATE TABLE t(a);
+  CREATE INDEX ta ON t(a);
+  INSERT INTO t(a) VALUES(1),(2);
+  SELECT * FROM t ORDER BY a;
+  SELECT * FROM t WHERE a<2 OR a<3 ORDER BY a;
+  PRAGMA count_changes=ON;
+  DELETE FROM t WHERE a<2 OR a<3;
+  SELECT * FROM t;
+  PRAGMA count_changes=OFF;
+  DROP TABLE t;
+} {1 2 1 2 2}
 do_test where7-1.2 {
   count_steps {
     SELECT a FROM t1 WHERE b=3 OR c=6 ORDER BY a
   }
 } {2 3 scan 0 sort 1}
 do_test where7-1.3 {
   count_steps {
     SELECT a FROM t1 WHERE b=3 OR +c=6 ORDER BY a
   }
 } {2 3 scan 4 sort 0}
@@ skipping 23279 matching lines @@
            OR t301.c8 = 1407424651264000)
    ORDER BY t302.c5 LIMIT 200;
 } {
   0 0 1 {SEARCH TABLE t301 USING COVERING INDEX t301_c4 (c4=?)} 
   0 0 1 {SEARCH TABLE t301 USING INTEGER PRIMARY KEY (rowid=?)} 
   0 1 0 {SEARCH TABLE t302 USING INDEX t302_c8_c3 (c8=? AND c3>?)} 
   0 0 0 {USE TEMP B-TREE FOR ORDER BY}
 }
 
 finish_test