[CALCITE-2785] In EnumerableAggregate, wrong result produced If there are sorted aggregates and non-sorted aggregates at the same time - ASF JIRA

XML

Word

Printable

JSON

SQL:

WITH tab(X) AS  (values 1, 2, 1)
SELECT COLLECT(x), COLLECT(x) WITHIN GROUP (ORDER BY 1) FROM tab

Result:

EXPR$0 |EXPR$1  |
-------|--------|
       |[1,2,1] |

Correct result:

EXPR$0 |EXPR$1  |
-------|--------|
[1,2,1]|[1,2,1] |

The problem is introduced by CALCITE-2224.

links to

PR #1003