Import SQLite 3.10.2.

third_party/sqlite/src/test/where2.test

 # 2005 July 28
 #
 # 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 304 matching lines @@
   }
 } [list 6 2 49 51 99 6 10000 10006 100 6 10201 10207 sort t1 $::idx]
 
 do_test where2-6.3 {
   queryplan {
     SELECT * FROM t1 WHERE w=99 OR w=100 OR 6=+w ORDER BY +w
   }
 } {6 2 49 51 99 6 10000 10006 100 6 10201 10207 sort t1 *}
 do_test where2-6.4 {
   queryplan {
-    SELECT * FROM t1 WHERE w=99 OR +w=100 OR 6=w ORDER BY +w
+    SELECT *, '|' FROM t1 WHERE w=99 OR +w=100 OR 6=w ORDER BY +w
   }
-} {6 2 49 51 99 6 10000 10006 100 6 10201 10207 sort t1 *}
+} {6 2 49 51 | 99 6 10000 10006 | 100 6 10201 10207 | sort t1 *}
+do_test where2-6.5 {
+  queryplan {
+    SELECT *, '|' FROM t1 WHERE w=99 OR y=10201 OR 6=w ORDER BY +w
+  }
+} {6 2 49 51 | 99 6 10000 10006 | 100 6 10201 10207 | sort t1 *}
 
 set ::idx {}
 ifcapable subquery {set ::idx i1zyx}
 do_test where2-6.5 {
   queryplan {
     SELECT b.* FROM t1 a, t1 b
      WHERE a.w=1 AND (a.y=b.z OR b.z=10)
      ORDER BY +b.w
   }
 } [list 1 0 4 4 2 1 9 10 sort a i1w b $::idx]
@@ skipping 416 matching lines @@
 # Verify that all necessary OP_OpenRead opcodes occur in the OR optimization.
 #
 do_execsql_test where2-13.1 {
   CREATE TABLE t13(a,b);
   CREATE INDEX t13a ON t13(a);
   INSERT INTO t13 VALUES(4,5);
   SELECT * FROM t13 WHERE (1=2 AND a=3) OR a=4;
 } {4 5}
 
 finish_test