[jira] [Created] (CALCITE-5883) Calcite ignores window frames when there is no ORDER BY clause

["Itiel Sadeh (Jira)" <ji...@apache.org>]

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)