Itiel Sadeh created CALCITE-5883: ------------------------------------ Summary: Calcite ignores window frames when there is no ORDER BY clause Key: CALCITE-5883 URL: https://issues.apache.org/jira/browse/CALCITE-5883 Project: Calcite Issue Type: Bug Reporter: Itiel Sadeh
When specifying window frame without an ORDER BY clause, Calcite will ignore it and will generate the frame UNBOUNDED PRECEDING to UNBOUNDED FOLLOWING. e.g, calcite will translate {code:java} SELECT sum(x) over(partition by y ROWS between CURRENT ROW and UNBOUNDED FOLLOWING) from t {code} into {code:java} SELECT sum(x) over(partition by y RANGE between UNBOUNDED FOLLOWING and UNBOUNDED FOLLOWING) from t {code} There is a comment in the offending code (SqlToRelConverter.java:2207) which states that ??"without ORDER BY, there must be no bracketing"?? . I've tried to find a specification like that in the SQL 2003 standard, but didn't find anything to that effect. -- This message was sent by Atlassian Jira (v8.20.10#820010)