You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@calcite.apache.org by "LeoWangLZ (JIRA)" <ji...@apache.org> on 2018/03/05 04:26:00 UTC

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

    [ 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)