Hongze Zhang created CALCITE-2648: ------------------------------------- Summary: Implementation of EnumerableWindow does not preserve input collation Key: CALCITE-2648 URL: https://issues.apache.org/jira/browse/CALCITE-2648 Project: Calcite Issue Type: Bug Reporter: Hongze Zhang Assignee: Julian Hyde
Here is a case: {code:sql} select x, COUNT(*) OVER (PARTITION BY x) from (values (20), (35)) as t(x) ORDER BY x {code} Final plan: {code:java} EnumerableWindow(window#0=[window(partition {0} order by [] range between UNBOUNDED PRECEDING and UNBOUNDED FOLLOWING aggs [COUNT()])]) EnumerableValues(tuples=[[{ 20 }, { 35 }]]) {code} Output rows: {code:java} X |EXPR$1 | ---|-------| 35 |1 | 20 |1 | {code} EnumerableWindow is supposed to preserve input collations, as a result EnumerableSort is ignored. However the implementation of EnumerableWindow generates non-ordered output (when PARTITION BY clause is used). -- This message was sent by Atlassian JIRA (v7.6.3#76005)