aboutsummaryrefslogtreecommitdiff
path: root/test/where9.test
Commit message (Expand)AuthorAge
* Show LEFT and RIGHT JOIN processing in the EXPLAIN QUERY PLAN output.drh2022-04-11
* In the MULTI-INDEX OR query plan, code for sub-expressions can sometimes bedrh2021-05-18
* Revise tests cases to align with the new EXPLAIN QUERY PLAN output.drh2021-03-20
* Improve the query planner so that it is better able to find fulldrh2020-06-03
* Remove support for STAT3. The sqlite_stat3 tables are ignored, if theydrh2019-08-08
* Improvements to EXPLAIN QUERY PLAN formatting. The MULTI-INDEX OR now showsdrh2018-12-24
* Make a separate limb in the EXPLAIN QUERY PLAN output for the various linesdrh2018-05-04
* Fix test cases so that they work with the new EXPLAIN QUERY PLAN outputdrh2018-05-02
* Fix where9.test so that it works with the "no_optimization" permutation.dan2014-08-12
* In the query optimizer, when converting BETWEEN and LIKE/GLOB expressionsdrh2013-08-28
* If ENABLE_STAT3 is defined but ENABLE_STAT4 is not, have ANALYZE create and p...dan2013-08-12
* Begin adding experimental sqlite_stat4 table. This commit is buggy.dan2013-08-03
* Add in the cost of doing a table lookup on OR searches. Make test casedrh2013-06-19
* Add the "queryplanner" test permutation. Continuing refinements to NGQP.drh2013-06-12
* Fix test cases for the new EXPLAIN QUERY PLAN format. Add thedrh2013-06-10
* Do not move WHERE clause terms inside OR expressions that are containeddrh2013-05-09
* Optimize the degenerate case of a FROM clause table name enclosed all bydrh2012-12-18
* Attempt to use a covering index even on a full table scan, under the theorydrh2012-09-15
* Candidate fix for the optimizer problem described in ticket drh2012-03-09
* Changes to various test scripts so that veryquick.test runs with OMIT_COMPOUN...dan2012-02-13
* More test cases for the OR optimization.drh2011-10-07
* Change the weighting of binary searches on tables to 1/10th the cost of adrh2011-01-28
* Change the EXPLAIN QUERY PLAN output to use "USING INDEX" instead of "BY INDE...dan2010-11-13
* Fix a bug in the EXPLAIN QUERY PLAN code.dan2010-11-11
* Modifications to test cases to account for new EXPLAIN QUERY PLAN output.dan2010-11-11
* Remove leftover "breakpoint" commands from test scripts. Also remove blankdrh2009-06-05
* Attempt to optimize virtual table queries with 'OR' expressions in the WHERE ...danielk19772009-04-21
* Optimize queries of the form "SELECT count(*) FROM <tbl>" by adding a sqlite3...danielk19772009-02-24
* Scan an index instead of a table for "SELECT count(*) FROM <tbl>" queries. Be...danielk19772009-02-23
* Increased test coverage in where.c. (CVS 6146)drh2009-01-08
* Increase test coverage of where.c. Make sure OR-optimization works ondrh2009-01-08
* Fix a bug in the multi-index OR cost estimator. Remove leftover "breakpoint"drh2008-12-30
* Add LEFT JOIN test cases for multi-index OR in where9.test. (CVS 6085)drh2008-12-30
* Get EXPLAIN QUERY PLAN working with the multi-index OR optimization.drh2008-12-30
generated by cgit v1.2.3 (git 2.25.1) at 2025-05-19 00:14:46 +0000