Claude Brisson created CALCITE-6682:
---------------------------------------
Summary: Framing unupported error message lacks LAG/LEAD functions
Key: CALCITE-6682
URL: https://issues.apache.org/jira/browse/CALCITE-6682
Project: Calcite
Issue Type: Bug
Components: core
Affects Versions: 1.38.0
Reporter: Claude Brisson
The query
{code}
select lead(n_nationkey) over (partition by n_regionkey order by n_nationkey
rows between current row and 1 following) from nation
{code}
fails with the error message
{code}
ROW/RANGE not allowed with RANK, DENSE_RANK, ROW_NUMBER or
PERCENTILE_CONT/DISC function
{code}
whereas it should also reference the LAG/LEAD functions.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
