Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
History for test/autoindex4.test
2023-06-01
| ||
00:01 | [3c2105e917] part of check-in [96c72dde79] Fix the LEFT JOIN strength reduction for IN operators in the WHERE clause. Further simplifications and refinement of the algorithm. (check-in: [96c72dde79] user: drh branch: trunk, size: 5844) | |
2022-04-11
| ||
18:54 | [5df3931352] part of check-in [bdd1499c0f] New test cases added. (check-in: [bdd1499c0f] user: drh branch: right-join, size: 5409) | |
2021-11-30
| ||
14:07 | [75cb1191a5] part of check-in [664b461bb5] In the automatic index generator logic, be more precise about when a partial automatic index is allowed in order to capture more cases where it is legal to use a partial automatic index. (check-in: [664b461bb5] user: drh branch: trunk, size: 4438) | |
2015-02-24
| ||
16:48 | [49d3cd791a] part of check-in [1a1516e4da] This additional fix prevents a partial index from being qualified for use if the constraint that qualifies the partial index is part of the ON clause of a LEFT JOIN. (check-in: [1a1516e4da] user: drh branch: tkt-2326c258, size: 2733) | |
16:05 | [364be4c165] part of check-in [c0f4e308a5] Make sure partial automatic indexes are not based on terms in the ON clause of a LEFT JOIN. Fix for ticket [2326c258d02ead3]. UPDATE: This fix does not work where the partial index is a named index. (check-in: [c0f4e308a5] user: drh branch: tkt-2326c258, size: 2384) | |
2014-10-24
| ||
19:28 | Added: [fc807f9efd] part of check-in [d95d0313c4] Enhance the automatic index logic so that it creates a partial index when doing so gives the same answer for less work. UPDATE: This change introduced a bug described by ticket [2326c258d02ead33]. (check-in: [d95d0313c4] user: drh branch: trunk, size: 1706) | |