Hongze Zhang created CALCITE-2785: ------------------------------------- Summary: In EnumerableAggregate, wrong result produced If there are sorted aggregates and non-sorted aggregates at the same time. Key: CALCITE-2785 URL: https://issues.apache.org/jira/browse/CALCITE-2785 Project: Calcite Issue Type: Bug Components: core Affects Versions: 1.18.0 Reporter: Hongze Zhang Assignee: Hongze Zhang
SQL: {code:sql} WITH tab(X) AS (values 1, 2, 1) SELECT COLLECT(x), COLLECT(x) WITHIN GROUP (ORDER BY 1) FROM tab {code} Result: {code} EXPR$0 |EXPR$1 | -------|--------| |[1,2,1] | {code} Correct result: {code} EXPR$0 |EXPR$1 | -------|--------| [1,2,1]|[1,2,1] | {code} The problem is introduced by [CALCITE-2224|https://issues.apache.org/jira/browse/CALCITE-2224]. -- This message was sent by Atlassian JIRA (v7.6.3#76005)