Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
History for test/where9.test
|
2022-04-11
| ||
| 14:26 | [2db942671a] part of check-in [d91faeffea] Show LEFT and RIGHT JOIN processing in the EXPLAIN QUERY PLAN output. (check-in: [d91faeffea] user: drh branch: right-join, size: 32298) | |
|
2021-05-18
| ||
| 19:10 | [1ffb75edc5] part of check-in [4a55f72542] In the MULTI-INDEX OR query plan, code for sub-expressions can sometimes be generated twice. But for some subqueries, generating code off of the same tree twice causes problems. So now MULTI-INDEX OR makes a copy of the sub-expressions it uses to avoid code-generating them more than once. dbsqlfuzz 9ebd2140e7206ff724e665f172faea28af801635. (check-in: [4a55f72542] user: drh branch: trunk, size: 32278) | |
|
2021-03-20
| ||
| 15:11 | [b1942ed1d4] part of check-in [50fbd53260] Revise tests cases to align with the new EXPLAIN QUERY PLAN output. (check-in: [50fbd53260] user: drh branch: eqp-improvements, size: 31383) | |
|
2020-06-03
| ||
| 03:00 | [8e3e0ff42c] part of check-in [d901837fea] 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: [d901837fea] user: drh branch: trunk, size: 31443) | |
|
2019-08-08
| ||
| 15:24 | [2c554b97bb] part of check-in [1e17ea2fd1] 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: [1e17ea2fd1] user: drh branch: omit-stat3, size: 31538) | |
|
2018-12-24
| ||
| 20:21 | [4fb43ad451] part of check-in [7153552bac] 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: [7153552bac] user: drh branch: reuse-subqueries, size: 31658) | |
|
2018-05-04
| ||
| 00:39 | [ad2ddb339d] part of check-in [75ac7b4e4f] Make a separate limb in the EXPLAIN QUERY PLAN output for the various lines associated with the OR-optimization. (check-in: [75ac7b4e4f] user: drh branch: trunk, size: 31536) | |
|
2018-05-02
| ||
| 18:00 | [74f9dfddb4] part of check-in [5f0e803e33] 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: [5f0e803e33] user: drh branch: rework-EQP, size: 31454) | |
|
2014-08-12
| ||
| 20:13 | [729c3ba9b4] part of check-in [d46adf9d8f] Fix where9.test so that it works with the "no_optimization" permutation. (check-in: [d46adf9d8f] user: dan branch: trunk, size: 31623) | |
|
2013-10-08
| ||
| 18:40 | [06c5f1e131] part of check-in [18bd6ba96d] Further refinement of the idea of multiplying run-time cost estimates by the estimated row size. (check-in: [18bd6ba96d] user: drh branch: row-size-est, size: 30726) | |
|
2013-08-29
| ||
| 13:21 | [167a894957] part of check-in [cb667449d0] 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: [cb667449d0] user: drh branch: branch-3.8.0, size: 31382) | |
|
2013-08-28
| ||
| 16:27 | [4f3eab9513] part of check-in [caab361ebe] 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: [caab361ebe] user: drh branch: trunk, size: 31502) | |
|
2013-08-12
| ||
| 20:14 | [74245dea86] part of check-in [cca8bf4372] 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: [cca8bf4372] user: dan branch: sqlite_stat4, size: 30781) | |
|
2013-08-03
| ||
| 20:24 | [71aa15cc17] part of check-in [2beea303a1] Begin adding experimental sqlite_stat4 table. This commit is buggy. (check-in: [2beea303a1] user: dan branch: sqlite_stat4, size: 30661) | |
|
2013-06-19
| ||
| 18:01 | [9a7fda4a45] part of check-in [d97898e8e3] 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: [d97898e8e3] user: drh branch: nextgen-query-plan-exp, size: 30661) | |
|
2013-06-12
| ||
| 14:52 | [f5752185fc] part of check-in [25e2cde105] Add the "queryplanner" test permutation. Continuing refinements to NGQP. (check-in: [25e2cde105] user: drh branch: nextgen-query-plan-exp, size: 29812) | |
|
2013-06-10
| ||
| 23:30 | [4094299aea] part of check-in [aa580e368e] Fix test cases for the new EXPLAIN QUERY PLAN format. Add the wherecosttest tool. Other fixes to logarithm cost. (check-in: [aa580e368e] user: drh branch: nextgen-query-plan-logcost, size: 29343) | |
|
2013-05-09
| ||
| 14:20 | [1b4387c6ea] part of check-in [1128575d0a] 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: [1128575d0a] user: drh branch: trunk, size: 29450) | |
|
2012-12-18
| ||
| 19:36 | [0157862ccf] part of check-in [7fecced466] 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: [7fecced466] user: drh branch: trunk, size: 28504) | |
|
2012-09-15
| ||
| 18:45 | [bcab47eff7] part of check-in [cfaa7bc128] 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: [cfaa7bc128] user: drh branch: fullscan-covering-index, size: 28137) | |
|
2012-03-09
| ||
| 22:02 | [ae98dc22ef] part of check-in [0dc4cb9355] 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: [0dc4cb9355] user: drh branch: trunk, size: 28122) | |
|
2012-02-13
| ||
| 10:00 | [cd4ee5e455] part of check-in [76bb649ee2] Changes to various test scripts so that veryquick.test runs with OMIT_COMPOUND_SELECT defined. (check-in: [76bb649ee2] user: dan branch: trunk, size: 27516) | |
|
2011-10-07
| ||
| 16:08 | [bed66dcfc6] part of check-in [4997d8b81c] More test cases for the OR optimization. (check-in: [4997d8b81c] user: drh branch: or-opt, size: 27505) | |
|
2011-01-28
| ||
| 01:57 | [24f19ad14b] part of check-in [4847c6cb71] 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: [4847c6cb71] user: drh branch: stat2-enhancement, size: 25469) | |
|
2010-11-13
| ||
| 16:42 | [7ee38c3fd6] part of check-in [6611b76b02] 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: [6611b76b02] user: dan branch: experimental, size: 25469) | |
|
2010-11-11
| ||
| 11:43 | [576ce5bf3b] part of check-in [7ae068952f] Fix a bug in the EXPLAIN QUERY PLAN code. (check-in: [7ae068952f] user: dan branch: experimental, size: 25419) | |
| 10:36 | [2fa750f5f3] part of check-in [30904ef841] Modifications to test cases to account for new EXPLAIN QUERY PLAN output. (check-in: [30904ef841] user: dan branch: experimental, size: 25419) | |
|
2009-06-05
| ||
| 17:09 | [be19e1a92f] part of check-in [1fef16ec2b] Remove leftover "breakpoint" commands from test scripts. Also remove blank lines at the end of scripts. (CVS 6721) (check-in: [1fef16ec2b] user: drh branch: trunk, size: 25996) | |
|
2009-04-21
| ||
| 09:02 | [e1756a1c8a] part of check-in [f61e4cd936] Attempt to optimize virtual table queries with 'OR' expressions in the WHERE clause. (CVS 6527) (check-in: [f61e4cd936] user: danielk1977 branch: trunk, size: 26015) | |
|
2009-02-24
| ||
| 10:01 | [12c1e46364] part of check-in [d4aa659318] Optimize queries of the form "SELECT count(*) FROM <tbl>" by adding a sqlite3BtreeCount() interface to the btree layer. (CVS 6316) (check-in: [d4aa659318] user: danielk1977 branch: trunk, size: 25617) | |
|
2009-02-23
| ||
| 17:33 | [0e44fd96a8] part of check-in [294ba6f743] 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: [294ba6f743] user: danielk1977 branch: trunk, size: 26231) | |
|
2009-01-08
| ||
| 21:00 | [a46d394037] part of check-in [1e5725c517] Increased test coverage in where.c. (CVS 6146) (check-in: [1e5725c517] user: drh branch: trunk, size: 25609) | |
| 03:11 | [45c2984ccb] part of check-in [4b2c08e898] 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: [4b2c08e898] user: drh branch: trunk, size: 21990) | |
|
2008-12-30
| ||
| 17:55 | [57c444e957] part of check-in [b090d5736d] Fix a bug in the multi-index OR cost estimator. Remove leftover "breakpoint" commands from test scripts. (CVS 6086) (check-in: [b090d5736d] user: drh branch: trunk, size: 16574) | |
| 16:35 | [3115a2f703] part of check-in [96f3b62914] Add LEFT JOIN test cases for multi-index OR in where9.test. (CVS 6085) (check-in: [96f3b62914] user: drh branch: trunk, size: 13889) | |
| 16:18 | Added: [99b2da7fe4] part of check-in [4b64602210] Get EXPLAIN QUERY PLAN working with the multi-index OR optimization. Added new test script "where9.test". (CVS 6084) (check-in: [4b64602210] user: drh branch: trunk, size: 12606) | |