[CALCITE-1653] Pass an expression executor to RexUtil.simplify for constant reduction

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.12.0
• Assignee: Remus Rusanu
• Reporter: Remus Rusanu
• Created: 22/Feb/17 15:04
• Updated: 27/Feb/24 22:23
• Resolved: 23/Feb/17 23:00

Description

Allow for custom RelOptPlanner.Executor in RexUtil.simplify. RexUtil.simplify (and derivatives) use a default EXECUTOR for evaluating literals and expression in simplifyCast. This causes value differences from Hive, triggering issues like CALCITE-1650, CALCITE-1651.

Issue Links

• duplicates: CALCITE-1650 Difference in BOOLEAN cast between Hive and Calcite
• duplicates: CALCITE-1651 Difference in DATE cast between Hive and Calcite
• is related to: CALCITE-1536 Initialize cluster before planner
• relates to: CALCITE-1439 Handle errors during constant reduction
• relates to: CALCITE-1620 CAST('<string>' AS BINARY) is supported by Hive, but not by Calcite
• relates to: CALCITE-1650 Difference in BOOLEAN cast between Hive and Calcite
• relates to: CALCITE-1651 Difference in DATE cast between Hive and Calcite
• relates to: CALCITE-1695 Not all RexUtil.simplifyXxx code paths carry the provided executor