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)