You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@calcite.apache.org by "Itiel Sadeh (Jira)" <ji...@apache.org> on 2023/07/27 16:05:00 UTC

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

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)