/ All files named "test/where7.test"
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

History for test/where7.test

2018-12-24
20:21
[75722434] part of check-in [7153552b] Improvements to EXPLAIN QUERY PLAN formatting. The MULTI-INDEX OR now shows a separate "INDEX" subtree for each index. SCALAR SUBQUERY entries provide a subquery number that is related back to the .selecttrace output. (check-in: [7153552b] user: drh branch: reuse-subqueries, size: 654863)
2018-05-04
00:39
[e579da97] part of check-in [75ac7b4e] Make a separate limb in the EXPLAIN QUERY PLAN output for the various lines associated with the OR-optimization. (check-in: [75ac7b4e] user: drh branch: trunk, size: 654825)
2018-05-02
18:00
[9bfbfdf0] part of check-in [5f0e803e] Fix test cases so that they work with the new EXPLAIN QUERY PLAN output format. Only some of the cases have been fixed. This is an incremental check-in. (check-in: [5f0e803e] user: drh branch: rework-EQP, size: 654799)
2015-12-08
04:18
[f520bcec] part of check-in [177862c1] Add a test case of the form "WHERE a<2 OR a<3" using PRAGMA count_changes. This test case was failing before the 3.9.0 release. (check-in: [177862c1] user: drh branch: trunk, size: 654806)
2013-06-12
17:08
[5a4b0abc] part of check-in [addd7f46] "make test" now passing. (check-in: [addd7f46] user: drh branch: nextgen-query-plan-exp, size: 654478)
2013-06-10
23:30
[e0741d85] part of check-in [aa580e36] Fix test cases for the new EXPLAIN QUERY PLAN format. Add the wherecosttest tool. Other fixes to logarithm cost. (check-in: [aa580e36] user: drh branch: nextgen-query-plan-logcost, size: 654476)
2012-03-09
22:02
[5c566388] part of check-in [0dc4cb93] Candidate fix for the optimizer problem described in ticket [b7c8682cc17f3] which can causes a LEFT JOIN to be changed into a INNER JOIN if there are OR terms in the WHERE clause. (check-in: [0dc4cb93] user: drh branch: trunk, size: 654507)
2011-10-07
16:08
[814d7373] part of check-in [4997d8b8] More test cases for the OR optimization. (check-in: [4997d8b8] user: drh branch: or-opt, size: 654506)
2010-11-13
16:42
[aa4cfcd6] part of check-in [6611b76b] Change the EXPLAIN QUERY PLAN output to use "USING INDEX" instead of "BY INDEX", and to use "SEARCH" instead of "SCAN" for loops that are not full-table scans. (check-in: [6611b76b] user: dan branch: experimental, size: 654564)
2010-11-11
11:43
[2707b476] part of check-in [7ae06895] Fix a bug in the EXPLAIN QUERY PLAN code. (check-in: [7ae06895] user: dan branch: experimental, size: 654549)
10:36
[23ad8b8b] part of check-in [30904ef8] Modifications to test cases to account for new EXPLAIN QUERY PLAN output. (check-in: [30904ef8] user: dan branch: experimental, size: 654549)
2010-10-21
03:13
[221fd05b] part of check-in [1e0db997] Add new WHERETRACE macros for better diagnostics of the query planner. Added a new test case for the performance regression fixed by the previous check-in. (check-in: [1e0db997] user: drh branch: trunk, size: 654515)
2010-04-15
01:04
[a0a92b8c] part of check-in [defaf0d9] Further refinements to table order selection on join query planning. (check-in: [defaf0d9] user: drh branch: trunk, size: 653223)
2009-08-20
18:14
[fdd58ab9] part of check-in [f0c24b5f] Continuing refinements of the range-scan optimizations in where.c. The range scores are changed from an integer 1..9 to 0..100. (check-in: [f0c24b5f] user: drh branch: trunk, size: 653407)
2009-06-07
23:45
[b6e84b47] part of check-in [a255c645] Disable the LIKE optimization if the affinity of the LHS column is not TEXT. Ticket #3901. (CVS 6727) (check-in: [a255c645] user: drh branch: trunk, size: 653389)
2009-04-21
09:02
[42d5e19c] part of check-in [f61e4cd9] Attempt to optimize virtual table queries with 'OR' expressions in the WHERE clause. (CVS 6527) (check-in: [f61e4cd9] user: danielk1977 branch: trunk, size: 653387)
2009-01-14
00:55
[2487cda6] part of check-in [d28b5820] Make sure the OR-clause optimizer takes the cost of sorting into account. Reset the rowid cache on the OP_Rewind and OP_Last opcodes. Bump the version number so that we can do an emergency release. Ticket #3581. (CVS 6173) (check-in: [d28b5820] user: drh branch: trunk, size: 665398)
2008-12-30
17:55
[88eb7c53] part of check-in [b090d573] Fix a bug in the multi-index OR cost estimator. Remove leftover "breakpoint" commands from test scripts. (CVS 6086) (check-in: [b090d573] user: drh branch: trunk, size: 665235)
14:40
[c56c34e8] part of check-in [eb9ba5fe] Still more test cases in where7.test. (CVS 6080) (check-in: [eb9ba5fe] user: drh branch: trunk, size: 664997)
14:14
[696b4849] part of check-in [17498583] Add many new test cases to where7.test. (CVS 6079) (check-in: [17498583] user: drh branch: trunk, size: 663671)
2008-12-28
20:47
[3ed6a8cb] part of check-in [3464d369] Multi-index OR optimizer response to ORDER BY rowid. But fix in sqlite3_stmt_status(): report a full table scan when "ORDER BY rowid" is used without constraints. (CVS 6069) (check-in: [3464d369] user: drh branch: trunk, size: 2823)
18:35
[c27e4865] part of check-in [67cf24b3] Optimize WHERE clauses that constain AND, BETWEEN, and LIKE terms as operands of an OR. (CVS 6068) (check-in: [67cf24b3] user: drh branch: trunk, size: 2430)
2008-12-23
23:56
Added: [b04da5ce] part of check-in [55d4f493] Continuing improvements to the multi-index OR-clause optimizer. Added a few simple test cases. (CVS 6062) (check-in: [55d4f493] user: drh branch: trunk, size: 2193)