/ History for test/where9.test
Login

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