Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
History for test/whereD.test
2020-02-22
| ||
13:01 | [c1c335e914] part of check-in [f02030b340] In the OP_Column opcode, if the cursor is marked NullRow (due to being the right table of a LEFT JOIN that does not match) and the cursor is the table cursor for an OR-optimization with a covering index, then do not substitute the covering index cursor, since the covering index cursor does not have the NullRow flag set. Ticket [aa4378693018aa99] (check-in: [f02030b340] user: drh branch: trunk, size: 12638) | |
2017-07-05
| ||
16:20 | [ac6926e3f5] part of check-in [fcbd6abdb1] Make use of covering indexes in the OR optimization. (check-in: [fcbd6abdb1] user: drh branch: branch-3.8.9, size: 10458) | |
2016-10-26
| ||
15:46 | [711d4df58d] part of check-in [e7b9bc678e] If all branches of an OR optimize scan that is the rhs of a LEFT JOIN use the same index, set the index cursor to return NULL values if there are no matches for a row on the lhs. (check-in: [e7b9bc678e] user: dan branch: leftjoin-or-fix, size: 12067) | |
2016-01-29
| ||
21:16 | [51366b07cb] part of check-in [7cb697f829] Add tests for the change on this branch. (check-in: [7cb697f829] user: dan branch: covering-or, size: 10228) | |
19:29 | [4b648b4a75] part of check-in [a323ac3a9d] Experimental attempt to make better use of covering indexes within OR queries. (check-in: [a323ac3a9d] user: dan branch: covering-or, size: 9147) | |
2015-04-11
| ||
11:53 | [9eba1f9b18] part of check-in [da49700ca1] Update tests in whereD.test to account for the change in the previous commit. (check-in: [da49700ca1] user: dan branch: trunk, size: 8322) | |
2014-04-10
| ||
02:24 | [fd9120e262] part of check-in [a67b5312f6] Modify the OR-clause handling so that it can safely deal with OR-clause with 17 or more terms. Fix for ticket [10fb063b1179be53ea0b53bb]. (check-in: [a67b5312f6] user: drh branch: trunk, size: 8322) | |
2013-06-03
| ||
14:15 | [6c2feb79ef] part of check-in [9b97af94ae] Add test cases to verify that ticket [bc1aea7b725f2761] has been fixed in the NGQP. (check-in: [9b97af94ae] user: drh branch: nextgen-query-plan-exp, size: 6620) | |
2012-10-10
| ||
13:59 | [3f3ee93825] part of check-in [1182b54af0] Fix duplicate test name in whereD.test. (check-in: [1182b54af0] user: mistachkin branch: trunk, size: 5787) | |
2012-10-04
| ||
16:00 | [11945e7989] part of check-in [81fd941da6] Candidate fix for ticket [d02e1406a58ea02]. (check-in: [81fd941da6] user: drh branch: branch-3.7.14, size: 5787) | |
2012-08-25
| ||
00:49 | Added: [6b62704804] part of check-in [865dfcbaa5] Backport check-in [62678be3df35cd]: When the same index is used for all OR-terms in a WHERE clause, then try to use that index as a covering index. (check-in: [865dfcbaa5] user: drh branch: branch-3.7.2, size: 5077) | |
2012-08-24
| ||
19:58 | [304ccbe3c7] part of check-in [29d586178d] Another test for whereD.test. (check-in: [29d586178d] user: dan branch: multi-or-covering-index, size: 5071) | |
19:52 | [85b8aa3294] part of check-in [7e961eef6b] Add extra tests to whereD.test. (check-in: [7e961eef6b] user: dan branch: multi-or-covering-index, size: 4854) | |
17:52 | [1322fdcfbc] part of check-in [e5c3190c27] More test cases for OR-optimization covering indices. (check-in: [e5c3190c27] user: drh branch: multi-or-covering-index, size: 3080) | |
15:29 | [1aee8a7b3a] part of check-in [d8b7ab3712] Additional test cases for OR-optimization with covering indices, including one test case that currently fails. (check-in: [d8b7ab3712] user: drh branch: multi-or-covering-index, size: 2234) | |
10:52 | Added: [54e11307e8] part of check-in [1dc8c7c741] Experimental change to support the covering index optimization for queries with OR terms in the WHERE clause that search a single index more than once. (check-in: [1dc8c7c741] user: dan branch: multi-or-covering-index, size: 982) | |