Details
-
Bug
-
Status: Closed
-
Major
-
Resolution: Fixed
-
1.18.0
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.
Attachments
Issue Links
- links to