[ https://issues.apache.org/jira/browse/CALCITE-2116?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16385589#comment-16385589 ]
LeoWangLZ commented on CALCITE-2116: ------------------------------------ [~julianhyde] ok, it like Spool that it has one producer and multiple consumers. Thanks > The digests are not same for the common sub-expressions in HepPlanner > --------------------------------------------------------------------- > > Key: CALCITE-2116 > URL: https://issues.apache.org/jira/browse/CALCITE-2116 > Project: Calcite > Issue Type: Bug > Affects Versions: 1.15.0 > Reporter: LeoWangLZ > Assignee: Julian Hyde > Priority: Major > Fix For: 1.16.0 > > > The digests are not same for the same sub-query. > like query > {code:java} > select * from (select * from dept union all select * from dept)a; > {code} > 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. -- This message was sent by Atlassian JIRA (v7.6.3#76005)