[
https://issues.apache.org/jira/browse/CALCITE-822?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14648300#comment-14648300
]
Julian Hyde commented on CALCITE-822:
-------------------------------------
[~maryannxue] noticed the issue with SUM and $SUM0. They are similar aggregate
functions that may both be viable and have the same cost; thus plans will
oscillate between SUM and $SUM0. Her patch to CALCITE-793 fixes the issue by
making $SUM0 slightly more expensive.
> Incorrect LogicalAggregate collation inferring logic was introduced with the
> patch for CALCITE-783
> --------------------------------------------------------------------------------------------------
>
> Key: CALCITE-822
> URL: https://issues.apache.org/jira/browse/CALCITE-822
> Project: Calcite
> Issue Type: Bug
> Components: core
> Reporter: Milinda Lakmal Pathirage
> Assignee: Milinda Lakmal Pathirage
> Attachments: CALCITE-822-0.patch
>
>
> Please refer
> https://issues.apache.org/jira/browse/CALCITE-783?focusedCommentId=14641378&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-14641378
> for more information.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
