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

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.18.0
• Fix Version/s: 1.19.0
• Component/s: core
• Labels: pull-request-available
• Assignee: Hongze Zhang
• Reporter: Hongze Zhang
• Created: 16/Jan/19 05:45
• Updated: 25/Mar/19 00:11
• Resolved: 07/Mar/19 03:33

Description

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.

Issue Links

• links to: PR #1003