[CALCITE-5083] In RelBuilder.project_, do not unwrap SARGs

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.30.0
• Fix Version/s: 1.31.0
• Component/s: core
• Labels: pull-request-available
• Assignee: Vladimir Ozerov
• Reporter: Vladimir Ozerov
• Created: 04/Apr/22 19:36
• Updated: 03/Aug/22 16:21
• Resolved: 12/Apr/22 09:35

Description

The RelBuilder.project_ method forcefully unwraps SARG expressions. This way, we may lose SARG-related optimization opportunities and even get an infinite loop when some rules are applied heuristically. For example, the ProjectReduceExpressionsRule may simplify an expression to a SARG which would be unwrapped back to the original form in the RelBuilder, leading to an infinite execution of the rule.

The aim of this ticket is to remove the unconditional SARG unwrap from the RelBuilder.

Issue Links

• links to: GitHub Pull Request #2762