[CALCITE-2116] The digests are not same for the common sub-expressions in HepPlanner

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.15.0
• Fix Version/s: 1.16.0
• Assignee: Julian Hyde
• Reporter: LeoWangLZ
• Created: 31/Dec/17 00:34
• Updated: 27/Feb/24 22:23
• Resolved: 10/Jan/18 19:57

Description

The digests are not same for the same sub-query.
like query

select * from (select * from dept union all select * from dept)a;

When run the query, The union relNode has two inputs, and it's same expectly and it's the same object instead of the print of plan, but Now they are not same.
And for Test testReplaceCommonSubexpression, the rule is only firing once, but now it's two.

Issue Links

• is related to: CALCITE-481 Add "Spool" operator, to allow re-use of relational expressions