Description
During UNNEST index selection, the WHEN clause of the array index key should be considered. If the WHEN clause is more restrictive than the query predicate, the index should not be used.
Attachments
Issue Links
- blocks
-
MB-22188 4.6.2 Minor Release
- Closed
For Gerrit Dashboard: MB-22578 | ||||||
---|---|---|---|---|---|---|
# | Subject | Branch | Project | Status | CR | V |
72990,2 | MB-22578. UNNEST index selection considers WHEN clause. | master | query | Status: MERGED | +2 | +1 |
73406,2 | MB-22578. UNNEST index selection considers WHEN clause. | watson++ | query | Status: MERGED | +2 | +1 |
76923,7 | CBQE-4094 Update test_push_limit_intersect_unionscan and test_push_limit_intersect_unionscan CBQE-4088 Add test case for MB-22578 CBQE-4087 Add test cases for test_new_contains_functions CBQE-4072 Add test cases for MB-22577 and MB-22645 | watson | testrunner | Status: MERGED | +2 | +1 |
76988,2 | CBQE-4094 Update test_push_limit_intersect_unionscan and test_push_limit_intersect_unionscan CBQE-4088 Add test case for MB-22578 CBQE-4087 Add test cases for test_new_contains_functions CBQE-4072 Add test cases for MB-22577 and MB-22645 | master | testrunner | Status: MERGED | +2 | +1 |