Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
History of test/where9.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: [4fb43ad4] check-in: [7153552b] user: drh branch: reuse-subqueries, size: 31658 | |
|
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: [ad2ddb33] check-in: [75ac7b4e] user: drh branch: trunk, size: 31536 | |
|
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: [74f9dfdd] check-in: [5f0e803e] user: drh branch: rework-EQP, size: 31454 | |
|
2014-08-12
| ||
| 20:13 | Fix where9.test so that it works with the "no_optimization" permutation. file: [729c3ba9] check-in: [d46adf9d] user: dan branch: trunk, size: 31623 | |
|
2013-10-08
| ||
| 18:40 | Further refinement of the idea of multiplying run-time cost estimates by the estimated row size. file: [06c5f1e1] check-in: [18bd6ba9] user: drh branch: row-size-est, size: 30726 | |
|
2013-08-29
| ||
| 13:21 | In the query optimizer, when converting BETWEEN and LIKE/GLOB expressions into simpler forms for processing, be sure to transfer the LEFT JOIN markings. Fix for ticket [bc878246eafe0f52c]. Cherrypick of [caab361ebe]. file: [167a8949] check-in: [cb667449] user: drh branch: branch-3.8.0, size: 31382 | |
|
2013-08-28
| ||
| 16:27 | In the query optimizer, when converting BETWEEN and LIKE/GLOB expressions into simpler forms for processing, be sure to transfer the LEFT JOIN markings. Fix for ticket [bc878246eafe0f52c]. file: [4f3eab95] check-in: [caab361e] user: drh branch: trunk, size: 31502 | |
|
2013-08-12
| ||
| 20:14 | If ENABLE_STAT3 is defined but ENABLE_STAT4 is not, have ANALYZE create and populate the sqlite_stat3 table instead of sqlite_stat4. file: [74245dea] check-in: [cca8bf43] user: dan branch: sqlite_stat4, size: 30781 | |
|
2013-08-03
| ||
| 20:24 | Begin adding experimental sqlite_stat4 table. This commit is buggy. file: [71aa15cc] check-in: [2beea303] user: dan branch: sqlite_stat4, size: 30661 | |
|
2013-06-19
| ||
| 18:01 | Add in the cost of doing a table lookup on OR searches. Make test case changes to deal with difference in STAT3 behavior. file: [9a7fda4a] check-in: [d97898e8] user: drh branch: nextgen-query-plan-exp, size: 30661 | |
|
2013-06-12
| ||
| 14:52 | Add the "queryplanner" test permutation. Continuing refinements to NGQP. file: [f5752185] check-in: [25e2cde1] user: drh branch: nextgen-query-plan-exp, size: 29812 | |
|
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: [4094299a] check-in: [aa580e36] user: drh branch: nextgen-query-plan-logcost, size: 29343 | |
|
2013-05-09
| ||
| 14:20 | Do not move WHERE clause terms inside OR expressions that are contained within an ON clause of a LEFT JOIN. Fix for ticket [f2369304e47167e3e]. file: [1b4387c6] check-in: [1128575d] user: drh branch: trunk, size: 29450 | |
|
2012-12-18
| ||
| 19:36 | Optimize the degenerate case of a FROM clause table name enclosed all by itself inside parentheses. Generate code as if the parentheses did not exist, rather than the old behavior of manifesting the parenthesized table into a transient table. Also, tag every FROM-clause SELECT subquery that is generated by a parenthesized FROM-clause expression using the SF_NestedFrom flag. The new SF_NestedFrom flag is not yet used for anything. file: [0157862c] check-in: [7fecced4] user: drh branch: trunk, size: 28504 | |
|
2012-09-15
| ||
| 18:45 | Attempt to use a covering index even on a full table scan, under the theory that the index will be smaller and require less disk I/O and thus be faster. file: [bcab47ef] check-in: [cfaa7bc1] user: drh branch: fullscan-covering-index, size: 28137 | |
|
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: [ae98dc22] check-in: [0dc4cb93] user: drh branch: trunk, size: 28122 | |
|
2012-02-13
| ||
| 10:00 | Changes to various test scripts so that veryquick.test runs with OMIT_COMPOUND_SELECT defined. file: [cd4ee5e4] check-in: [76bb649e] user: dan branch: trunk, size: 27516 | |
|
2011-10-07
| ||
| 16:08 | More test cases for the OR optimization. file: [bed66dcf] check-in: [4997d8b8] user: drh branch: or-opt, size: 27505 | |
|
2011-01-28
| ||
| 01:57 | Change the weighting of binary searches on tables to 1/10th the cost of a search on an index. Change the assumed reduction in search space from a indexed range constraint from 1/3rd to 1/4th. Do not let the estimated number of rows drop below 1. file: [24f19ad1] check-in: [4847c6cb] user: drh branch: stat2-enhancement, size: 25469 | |
|
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: [7ee38c3f] check-in: [6611b76b] user: dan branch: experimental, size: 25469 | |
|
2010-11-11
| ||
| 11:43 | Fix a bug in the EXPLAIN QUERY PLAN code. file: [576ce5bf] check-in: [7ae06895] user: dan branch: experimental, size: 25419 | |
| 10:36 | Modifications to test cases to account for new EXPLAIN QUERY PLAN output. file: [2fa750f5] check-in: [30904ef8] user: dan branch: experimental, size: 25419 | |
|
2009-06-05
| ||
| 17:09 | Remove leftover "breakpoint" commands from test scripts. Also remove blank lines at the end of scripts. (CVS 6721) file: [be19e1a9] check-in: [1fef16ec] user: drh branch: trunk, size: 25996 | |
|
2009-04-21
| ||
| 09:02 | Attempt to optimize virtual table queries with 'OR' expressions in the WHERE clause. (CVS 6527) file: [e1756a1c] check-in: [f61e4cd9] user: danielk1977 branch: trunk, size: 26015 | |
|
2009-02-24
| ||
| 10:01 | Optimize queries of the form "SELECT count(*) FROM <tbl>" by adding a sqlite3BtreeCount() interface to the btree layer. (CVS 6316) file: [12c1e463] check-in: [d4aa6593] user: danielk1977 branch: trunk, size: 25617 | |
|
2009-02-23
| ||
| 17:33 | Scan an index instead of a table for "SELECT count(*) FROM <tbl>" queries. Because an index is usually smaller than a table on disk, this saves some IO. (CVS 6315) file: [0e44fd96] check-in: [294ba6f7] user: danielk1977 branch: trunk, size: 26231 | |
|
2009-01-08
| ||
| 21:00 | Increased test coverage in where.c. (CVS 6146) file: [a46d3940] check-in: [1e5725c5] user: drh branch: trunk, size: 25609 | |
| 03:11 | Increase test coverage of where.c. Make sure OR-optimization works on UPDATE and DELETE in addition to SELECT. (Bug found by coverage tests.) (CVS 6139) file: [45c2984c] check-in: [4b2c08e8] user: drh branch: trunk, size: 21990 | |
|
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: [57c444e9] check-in: [b090d573] user: drh branch: trunk, size: 16574 | |
| 16:35 | Add LEFT JOIN test cases for multi-index OR in where9.test. (CVS 6085) file: [3115a2f7] check-in: [96f3b629] user: drh branch: trunk, size: 13889 | |
| 16:18 | Get EXPLAIN QUERY PLAN working with the multi-index OR optimization. Added new test script "where9.test". (CVS 6084) file: [99b2da7f] check-in: [4b646022] user: drh branch: trunk, size: 12606 Added | |