/ History for test/whereD.test
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

History for test/whereD.test

2020-02-22
13:01
[c1c335e9] part of check-in [f02030b3] 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: [f02030b3] user: drh branch: trunk, size: 12638)
2017-07-05
16:20
[ac6926e3] part of check-in [fcbd6abd] Make use of covering indexes in the OR optimization. (check-in: [fcbd6abd] user: drh branch: branch-3.8.9, size: 10458)
2016-10-26
15:46
[711d4df5] part of check-in [e7b9bc67] 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: [e7b9bc67] user: dan branch: leftjoin-or-fix, size: 12067)
2016-01-29
21:16
[51366b07] part of check-in [7cb697f8] Add tests for the change on this branch. (check-in: [7cb697f8] user: dan branch: covering-or, size: 10228)
19:29
[4b648b4a] part of check-in [a323ac3a] Experimental attempt to make better use of covering indexes within OR queries. (check-in: [a323ac3a] user: dan branch: covering-or, size: 9147)
2015-04-11
11:53
[9eba1f9b] part of check-in [da49700c] Update tests in whereD.test to account for the change in the previous commit. (check-in: [da49700c] user: dan branch: trunk, size: 8322)
2014-04-10
02:24
[fd9120e2] part of check-in [a67b5312] 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: [a67b5312] user: drh branch: trunk, size: 8322)
2013-06-03
14:15
[6c2feb79] part of check-in [9b97af94] Add test cases to verify that ticket [bc1aea7b725f2761] has been fixed in the NGQP. (check-in: [9b97af94] user: drh branch: nextgen-query-plan-exp, size: 6620)
2012-10-10
13:59
[3f3ee938] part of check-in [1182b54a] Fix duplicate test name in whereD.test. (check-in: [1182b54a] user: mistachkin branch: trunk, size: 5787)
2012-10-04
16:00
[11945e79] part of check-in [81fd941d] Candidate fix for ticket [d02e1406a58ea02]. (check-in: [81fd941d] user: drh branch: branch-3.7.14, size: 5787)
2012-08-25
00:49
[6b627048] part of check-in [865dfcba] 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: [865dfcba] user: drh branch: branch-3.7.2, size: 5077) Added
2012-08-24
19:58
[304ccbe3] part of check-in [29d58617] Another test for whereD.test. (check-in: [29d58617] user: dan branch: multi-or-covering-index, size: 5071)
19:52
[85b8aa32] part of check-in [7e961eef] Add extra tests to whereD.test. (check-in: [7e961eef] user: dan branch: multi-or-covering-index, size: 4854)
17:52
[1322fdcf] part of check-in [e5c3190c] More test cases for OR-optimization covering indices. (check-in: [e5c3190c] user: drh branch: multi-or-covering-index, size: 3080)
15:29
[1aee8a7b] part of check-in [d8b7ab37] Additional test cases for OR-optimization with covering indices, including one test case that currently fails. (check-in: [d8b7ab37] user: drh branch: multi-or-covering-index, size: 2234)
10:52
[54e11307] part of check-in [1dc8c7c7] 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: [1dc8c7c7] user: dan branch: multi-or-covering-index, size: 982) Added