[CALCITE-5264] HintStrategy rule exclusion does not match innermost rels

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.33.0
• Component/s: core
• Labels: pull-request-available
• Assignee: WenJun Min
• Reporter: WenJun Min
• Created: 04/Sep/22 07:33
• Updated: 07/Feb/23 22:33
• Resolved: 21/Oct/22 15:48

Description

In CALCITE-3781, calcite can specify a hint for a relNode to let the planner exclude some rule when optimze. But as julianhyde said, it's strange to only check for the rels[0]. If we have a rule to push a common project to the source scan, we want to prevent the common project optimized from the ProjectMerge Rule, it can not work, as the preserved one is at the bottom.
So I proposal to check all the rels for the rule.

Issue Links

• relates to: CALCITE-3781 HintStrategy can specify excluded rules for planner
• links to: GitHub Pull Request #2901