Index: third_party/sqlite/src/test/where7.test |
diff --git a/third_party/sqlite/src/test/where7.test b/third_party/sqlite/src/test/where7.test |
index e34778c76311f076a8f54da088090125c7b7a8a6..5032c698b217f691e018cad152fc032a7aee0fc2 100644 |
--- a/third_party/sqlite/src/test/where7.test |
+++ b/third_party/sqlite/src/test/where7.test |
@@ -10,8 +10,6 @@ |
#*********************************************************************** |
# 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 |
@@ -23305,7 +23303,7 @@ do_test where7-2.1001.2 { |
# |
# 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 ( |
@@ -23334,16 +23332,16 @@ do_execsql_test where7-3.1 { |
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} |
} |