[CALCITE-5288] Expression '(a > 5 and a < 15) or (a > 10 and a < 20)' should be simplified to 'SEARCH(a, Sarg[(5..20)])'

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.33.0
• Labels: pull-request-available
• Assignee: Aleksey Plekhanov
• Reporter: Aleksey Plekhanov
• Created: 19/Sep/22 09:14
• Updated: 07/Feb/23 22:33
• Resolved: 29/Sep/22 03:47

Description

If there is only one range in search/sarg after simplification, the result of sarg collector is ignored (SargCollector#needToFix() method).

Expression  (a > 5 and a < 15) or (a > 10 and a < 20) is simplified to OR(SEARCH(a, Sarg[(5..15)]), SEARCH(a, Sarg[(10..20)])) but expected SEARCH(a, Sarg[(5..20)]).

If there are more the one intervals or if open interval exists, expressions simplified as expected.

 

Issue Links

• links to: GitHub Pull Request #2912
• links to: Pull request