Import SQLite 3.8.7.4.

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.
 #
 #***********************************************************************
 # This file implements regression tests for SQLite library.  The
 # focus of this file is testing the multi-index OR clause optimizer.
-#
-# $Id: where7.test,v 1.9 2009/06/07 23:45:11 drh Exp $
 
 set testdir [file dirname $argv0]
 source $testdir/tester.tcl
 
 ifcapable !or_opt {
   finish_test
   return
 }
 
 # Evaluate SQL.  Return the result set followed by the
@@ skipping 23273 matching lines @@
          OR (d>=22.0 AND d<23.0 AND d NOT NULL)
          OR a=91
   }
 } {2 22 23 28 54 80 91 scan 0 sort 0}
 
 # test case for the performance regression fixed by
 # check-in 28ba6255282b on 2010-10-21 02:05:06
 #
 # The test case that follows is code from an actual
 # application with identifiers change and unused columns
-# remove.
+# removed.
 #
 do_execsql_test where7-3.1 {
   CREATE TABLE t301 (
       c8 INTEGER PRIMARY KEY,
       c6 INTEGER,
       c4 INTEGER,
       c7 INTEGER,
       FOREIGN KEY (c4) REFERENCES series(c4)
   );
   CREATE INDEX t301_c6 on t301(c6);
   CREATE INDEX t301_c4 on t301(c4);
   CREATE INDEX t301_c7 on t301(c7);
   
   CREATE TABLE t302 (
       c1 INTEGER PRIMARY KEY,
       c8 INTEGER,
       c5 INTEGER,
       c3 INTEGER,
       c2 INTEGER,
       c4 INTEGER,
       FOREIGN KEY (c8) REFERENCES t301(c8)
   );
   CREATE INDEX t302_c3 on t302(c3);
   CREATE INDEX t302_c8_c3 on t302(c8, c3);
   CREATE INDEX t302_c5 on t302(c5);
   
   EXPLAIN QUERY PLAN
   SELECT t302.c1 
-    FROM t302 JOIN t301 ON t302.c8 = t301.c8
+    FROM t302 JOIN t301 ON t302.c8 = +t301.c8
     WHERE t302.c2 = 19571
       AND t302.c3 > 1287603136
       AND (t301.c4 = 1407449685622784
            OR t301.c8 = 1407424651264000)
    ORDER BY t302.c5 LIMIT 200;
 } {
-  0 0 1 {SEARCH TABLE t301 USING COVERING INDEX t301_c4 (c4=?) (~10 rows)} 
-  0 0 1 {SEARCH TABLE t301 USING INTEGER PRIMARY KEY (rowid=?) (~1 rows)} 
-  0 1 0 {SEARCH TABLE t302 USING INDEX t302_c8_c3 (c8=? AND c3>?) (~2 rows)} 
+  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