SQLite

All files named ”test/whereD.test”
Login

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)