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