aboutsummaryrefslogtreecommitdiff
path: root/test/autoindex4.test
Commit message (Collapse)AuthorAge
* Fix the LEFT JOIN strength reduction for IN operators in the WHERE clause.drh2023-06-01
| | | | | Further simplifications and refinement of the algorithm. FossilOrigin-Name: 96c72dde79d4069f6c2f81467a35b617633f86f7a7dcafbda991affdaa1f8537
* New test cases added.drh2022-04-11
| | | FossilOrigin-Name: bdd1499c0fa4f8aadf4857a0ccc0d839c250369f29766ebef80330964905e63b
* In the automatic index generator logic, be more precise about when adrh2021-11-30
| | | | | | partial automatic index is allowed in order to capture more cases where it is legal to use a partial automatic index. FossilOrigin-Name: 664b461bb5063d98047fc2e51a3827235cd9f55ca2e23cb66e719eac53fb5437
* This additional fix prevents a partial index from being qualified for use drh2015-02-24
| | | | | | if the constraint that qualifies the partial index is part of the ON clause of a LEFT JOIN. FossilOrigin-Name: 1a1516e4da26dcee35e6fbb6604ce252faf3d116
* Make sure partial automatic indexes are not based on terms in the ON clausedrh2015-02-24
| | | | | of a LEFT JOIN. Fix for ticket [2326c258d02ead3]. FossilOrigin-Name: c0f4e308a508183b72ceda447dc3ac778cb85b9f
* Enhance the automatic index logic so that it creates a partial index whendrh2014-10-24
doing so gives the same answer for less work. FossilOrigin-Name: d95d0313c447f5baeabdb17284d8606331ab7d49
generated by cgit v1.2.3 (git 2.25.1) at 2025-05-19 08:37:07 +0000