Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
History for test/where9.test
|
2020-06-03
| ||
| 03:00 | [8e3e0ff4] part of check-in [d901837f] Improve the query planner so that it is better able to find full index scan plan when there is an INDEXED BY clause. (check-in: [d901837f] user: drh branch: trunk, size: 31443) | |
|
2019-08-08
| ||
| 15:24 | [2c554b97] part of check-in [1e17ea2f] Remove support for STAT3. The sqlite_stat3 tables are ignored, if they exist. STAT4 continues to work as it always has, and as it is a superset of STAT3 is the recommended replacement. (check-in: [1e17ea2f] user: drh branch: omit-stat3, size: 31538) | |
|
2018-12-24
| ||
| 20:21 | [4fb43ad4] 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: 31658) | |
|
2018-05-04
| ||
| 00:39 | [ad2ddb33] 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: 31536) | |
|
2018-05-02
| ||
| 18:00 | [74f9dfdd] 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: 31454) | |
|
2014-08-12
| ||
| 20:13 | [729c3ba9] part of check-in [d46adf9d] Fix where9.test so that it works with the "no_optimization" permutation. (check-in: [d46adf9d] user: dan branch: trunk, size: 31623) | |
|
2013-10-08
| ||
| 18:40 | [06c5f1e1] part of check-in [18bd6ba9] Further refinement of the idea of multiplying run-time cost estimates by the estimated row size. (check-in: [18bd6ba9] user: drh branch: row-size-est, size: 30726) | |
|
2013-08-29
| ||
| 13:21 | [167a8949] part of check-in [cb667449] 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]. (check-in: [cb667449] user: drh branch: branch-3.8.0, size: 31382) | |
|
2013-08-28
| ||
| 16:27 | [4f3eab95] part of check-in [caab361e] 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]. (check-in: [caab361e] user: drh branch: trunk, size: 31502) | |
|
2013-08-12
| ||
| 20:14 | [74245dea] part of check-in [cca8bf43] If ENABLE_STAT3 is defined but ENABLE_STAT4 is not, have ANALYZE create and populate the sqlite_stat3 table instead of sqlite_stat4. (check-in: [cca8bf43] user: dan branch: sqlite_stat4, size: 30781) | |
|
2013-08-03
| ||
| 20:24 | [71aa15cc] part of check-in [2beea303] Begin adding experimental sqlite_stat4 table. This commit is buggy. (check-in: [2beea303] user: dan branch: sqlite_stat4, size: 30661) | |
|
2013-06-19
| ||
| 18:01 | [9a7fda4a] part of check-in [d97898e8] Add in the cost of doing a table lookup on OR searches. Make test case changes to deal with difference in STAT3 behavior. (check-in: [d97898e8] user: drh branch: nextgen-query-plan-exp, size: 30661) | |
|
2013-06-12
| ||
| 14:52 | [f5752185] part of check-in [25e2cde1] Add the "queryplanner" test permutation. Continuing refinements to NGQP. (check-in: [25e2cde1] user: drh branch: nextgen-query-plan-exp, size: 29812) | |
|
2013-06-10
| ||
| 23:30 | [4094299a] 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: 29343) | |
|
2013-05-09
| ||
| 14:20 | [1b4387c6] part of check-in [1128575d] Do not move WHERE clause terms inside OR expressions that are contained within an ON clause of a LEFT JOIN. Fix for ticket [f2369304e47167e3e]. (check-in: [1128575d] user: drh branch: trunk, size: 29450) | |
|
2012-12-18
| ||
| 19:36 | [0157862c] part of check-in [7fecced4] 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. (check-in: [7fecced4] user: drh branch: trunk, size: 28504) | |
|
2012-09-15
| ||
| 18:45 | [bcab47ef] part of check-in [cfaa7bc1] 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. (check-in: [cfaa7bc1] user: drh branch: fullscan-covering-index, size: 28137) | |
|
2012-03-09
| ||
| 22:02 | [ae98dc22] 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: 28122) | |
|
2012-02-13
| ||
| 10:00 | [cd4ee5e4] part of check-in [76bb649e] Changes to various test scripts so that veryquick.test runs with OMIT_COMPOUND_SELECT defined. (check-in: [76bb649e] user: dan branch: trunk, size: 27516) | |
|
2011-10-07
| ||
| 16:08 | [bed66dcf] part of check-in [4997d8b8] More test cases for the OR optimization. (check-in: [4997d8b8] user: drh branch: or-opt, size: 27505) | |
|
2011-01-28
| ||
| 01:57 | [24f19ad1] part of check-in [4847c6cb] 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. (check-in: [4847c6cb] user: drh branch: stat2-enhancement, size: 25469) | |
|
2010-11-13
| ||
| 16:42 | [7ee38c3f] 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: 25469) | |
|
2010-11-11
| ||
| 11:43 | [576ce5bf] part of check-in [7ae06895] Fix a bug in the EXPLAIN QUERY PLAN code. (check-in: [7ae06895] user: dan branch: experimental, size: 25419) | |
| 10:36 | [2fa750f5] 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: 25419) | |
|
2009-06-05
| ||
| 17:09 | [be19e1a9] part of check-in [1fef16ec] Remove leftover "breakpoint" commands from test scripts. Also remove blank lines at the end of scripts. (CVS 6721) (check-in: [1fef16ec] user: drh branch: trunk, size: 25996) | |
|
2009-04-21
| ||
| 09:02 | [e1756a1c] 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: 26015) | |
|
2009-02-24
| ||
| 10:01 | [12c1e463] part of check-in [d4aa6593] Optimize queries of the form "SELECT count(*) FROM <tbl>" by adding a sqlite3BtreeCount() interface to the btree layer. (CVS 6316) (check-in: [d4aa6593] user: danielk1977 branch: trunk, size: 25617) | |
|
2009-02-23
| ||
| 17:33 | [0e44fd96] part of check-in [294ba6f7] 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) (check-in: [294ba6f7] user: danielk1977 branch: trunk, size: 26231) | |
|
2009-01-08
| ||
| 21:00 | [a46d3940] part of check-in [1e5725c5] Increased test coverage in where.c. (CVS 6146) (check-in: [1e5725c5] user: drh branch: trunk, size: 25609) | |
| 03:11 | [45c2984c] part of check-in [4b2c08e8] 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) (check-in: [4b2c08e8] user: drh branch: trunk, size: 21990) | |
|
2008-12-30
| ||
| 17:55 | [57c444e9] 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: 16574) | |
| 16:35 | [3115a2f7] part of check-in [96f3b629] Add LEFT JOIN test cases for multi-index OR in where9.test. (CVS 6085) (check-in: [96f3b629] user: drh branch: trunk, size: 13889) | |
| 16:18 | [99b2da7f] part of check-in [4b646022] Get EXPLAIN QUERY PLAN working with the multi-index OR optimization. Added new test script "where9.test". (CVS 6084) (check-in: [4b646022] user: drh branch: trunk, size: 12606) Added | |