[jira] [Created] (CALCITE-5876) Calcite rejects valid query without ORDER BY and constant RANGE bounds in window functions

[Itiel Sadeh (Jira)]

Itiel Sadeh created CALCITE-5876:
------------------------------------

             Summary: Calcite rejects valid query without ORDER BY and constant 
RANGE bounds in window functions
                 Key: CALCITE-5876
                 URL: https://issues.apache.org/jira/browse/CALCITE-5876
             Project: Calcite
          Issue Type: Bug
    Affects Versions: 1.34.0
            Reporter: Itiel Sadeh
            Assignee: Itiel Sadeh


A similar case to 
[CALCITE-5863|https://issues.apache.org/jira/browse/CALCITE-5863], where we 
have a RANGE window frame, without ORDER BY, and only constant bounds. e.g: 
{code:sql}
SELECT sum(x) OVER(RANGE between CURRENT ROW and UNBOUNDED FOLLOWING) from t
{code}

Calcite incorrectly rejects that query. 




--
This message was sent by Atlassian Jira
(v8.20.10#820010)