/ File History
Login

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

History of test/whereD.test

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