/ File History
Login

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

History of test/where7.test

2018-12-24
20:21
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. file: [75722434] check-in: [7153552b] user: drh branch: reuse-subqueries, size: 654863
2018-05-04
00:39
Make a separate limb in the EXPLAIN QUERY PLAN output for the various lines associated with the OR-optimization. file: [e579da97] check-in: [75ac7b4e] user: drh branch: trunk, size: 654825
2018-05-02
18:00
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. file: [9bfbfdf0] check-in: [5f0e803e] user: drh branch: rework-EQP, size: 654799
2015-12-08
04:18
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. file: [f520bcec] check-in: [177862c1] user: drh branch: trunk, size: 654806
2013-06-12
17:08
"make test" now passing. file: [5a4b0abc] check-in: [addd7f46] user: drh branch: nextgen-query-plan-exp, size: 654478
2013-06-10
23:30
Fix test cases for the new EXPLAIN QUERY PLAN format. Add the wherecosttest tool. Other fixes to logarithm cost. file: [e0741d85] check-in: [aa580e36] user: drh branch: nextgen-query-plan-logcost, size: 654476
2012-03-09
22:02
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. file: [5c566388] check-in: [0dc4cb93] user: drh branch: trunk, size: 654507
2011-10-07
16:08
More test cases for the OR optimization. file: [814d7373] check-in: [4997d8b8] user: drh branch: or-opt, size: 654506
2010-11-13
16:42
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. file: [aa4cfcd6] check-in: [6611b76b] user: dan branch: experimental, size: 654564
2010-11-11
11:43
Fix a bug in the EXPLAIN QUERY PLAN code. file: [2707b476] check-in: [7ae06895] user: dan branch: experimental, size: 654549
10:36
Modifications to test cases to account for new EXPLAIN QUERY PLAN output. file: [23ad8b8b] check-in: [30904ef8] user: dan branch: experimental, size: 654549
2010-10-21
03:13
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. file: [221fd05b] check-in: [1e0db997] user: drh branch: trunk, size: 654515
2010-04-15
01:04
Further refinements to table order selection on join query planning. file: [a0a92b8c] check-in: [defaf0d9] user: drh branch: trunk, size: 653223
2009-08-20
18:14
Continuing refinements of the range-scan optimizations in where.c. The range scores are changed from an integer 1..9 to 0..100. file: [fdd58ab9] check-in: [f0c24b5f] user: drh branch: trunk, size: 653407
2009-06-07
23:45
Disable the LIKE optimization if the affinity of the LHS column is not TEXT. Ticket #3901. (CVS 6727) file: [b6e84b47] check-in: [a255c645] user: drh branch: trunk, size: 653389
2009-04-21
09:02
Attempt to optimize virtual table queries with 'OR' expressions in the WHERE clause. (CVS 6527) file: [42d5e19c] check-in: [f61e4cd9] user: danielk1977 branch: trunk, size: 653387
2009-01-14
00:55
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) file: [2487cda6] check-in: [d28b5820] user: drh branch: trunk, size: 665398
2008-12-30
17:55
Fix a bug in the multi-index OR cost estimator. Remove leftover "breakpoint" commands from test scripts. (CVS 6086) file: [88eb7c53] check-in: [b090d573] user: drh branch: trunk, size: 665235
14:40
Still more test cases in where7.test. (CVS 6080) file: [c56c34e8] check-in: [eb9ba5fe] user: drh branch: trunk, size: 664997
14:14
Add many new test cases to where7.test. (CVS 6079) file: [696b4849] check-in: [17498583] user: drh branch: trunk, size: 663671
2008-12-28
20:47
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) file: [3ed6a8cb] check-in: [3464d369] user: drh branch: trunk, size: 2823
18:35
Optimize WHERE clauses that constain AND, BETWEEN, and LIKE terms as operands of an OR. (CVS 6068) file: [c27e4865] check-in: [67cf24b3] user: drh branch: trunk, size: 2430
2008-12-23
23:56
Continuing improvements to the multi-index OR-clause optimizer. Added a few simple test cases. (CVS 6062) file: [b04da5ce] check-in: [55d4f493] user: drh branch: trunk, size: 2193 Added