Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
|
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) | |