Itiel Sadeh created CALCITE-5863:
------------------------------------
Summary: Calcite rejects valid query with multiple ORDER BY
columns and constant RANGE bounds in window functions
Key: CALCITE-5863
URL: https://issues.apache.org/jira/browse/CALCITE-5863
Project: Calcite
Issue Type: Bug
Affects Versions: 1.34.0
Reporter: Itiel Sadeh
Usually, it is not valid to specify multiple ORDER BY columns with RANGE bounds
in window functions:
{code:java}
SELECT sum(x) OVER (ORDER BY x,y RANGE BETWEEN 3 preceding and 4 following)
from t;{code}
However, it is valid if both bounds are "constant" bound (CURRENT ROW,
UNBOUNDED PRECEDING and UNBOUNDED FOLLOWING), i.e:
{code:java}
SELECT sum(x) OVER (ORDER BY x,y RANGE BETWEEN UNBOUNDED PRECEDING and CURRENT
ROW) from t;{code}
(tested on PostgreSQL and SQL Server)
Calcite will incorrectly reject it.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
