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 | |