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)
