/ File History
Login

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