Details
-
Improvement
-
Status: Closed
-
Minor
-
Resolution: Abandoned
-
None
-
None
-
None
Description
FilterList.filterKeyValue does not always return the most optimal ReturnCode in both the AND and OR conditions.
For example, if you have F1 AND F2, F1 returns SKIP. It immediately returns the SKIP. However, if F2 would have returned NEXT_COL or NEXT_ROW or SEEK_NEXT_USING_HINT, we would actually be able to return the more optimal ReturnCode from F2.
For AND conditions, we can always pick the most restrictive return code.
For OR conditions, we must always pick the least restrictive return code.
This JIRA is to review the FilterList.filterKeyValue() method to try and make it more optimal and to add a new unit test which verifies the correct behavior.