[jira] [Created] (CALCITE-3897) Windowed aggregate with bracket (ROWS or RANGE) without ORDER BY is invalid

["Julian Hyde (Jira)" <ji...@apache.org>]

Julian Hyde created CALCITE-3897:
------------------------------------

             Summary: Windowed aggregate with bracket (ROWS or RANGE) without ORDER BY is invalid
                 Key: CALCITE-3897
                 URL: https://issues.apache.org/jira/browse/CALCITE-3897
             Project: Calcite
          Issue Type: Bug
            Reporter: Julian Hyde


I believe that windowed aggregate with bracket (ROWS or RANGE) without ORDER BY is invalid. If so, we should throw.

[~danny0405] [reports|https://github.com/apache/calcite/pull/1896#discussion_r403420946] that the syntax is invalid on MSSQL 2017.

Someone should check the SQL standard. If it is invalid in the SQL standard (but only if) the validator should give an error.

I am a little ambivalent. A missing {{ORDER BY}} is basically sorting by zero columns, an of course it's not deterministic, but even with {{ORDER BY}}, the ordering may not be deterministic (e.g. apply {{ORDER BY deptno}} to the {{Emp}} table). So we should go with the SQL standard.




--
This message was sent by Atlassian Jira
(v8.3.4#803005)