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

Posted to issues@calcite.apache.org by "Claude Brisson (Jira)" <ji...@apache.org> on 2024/11/08 08:32:00 UTC

[jira] [Created] (CALCITE-6682) Framing unupported error message lacks LAG/LEAD functions

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)