[jira] [Updated] (IGNITE-14777) row_number() with window functions unsupported.

["Yury Gerzhedovich (Jira)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/IGNITE-14777?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Yury Gerzhedovich updated IGNITE-14777:
---------------------------------------
    Labels: calcite calcite2-required calcite3-required  (was: calcite)

> row_number() with window functions unsupported.
> -----------------------------------------------
>
>                 Key: IGNITE-14777
>                 URL: https://issues.apache.org/jira/browse/IGNITE-14777
>             Project: Ignite
>          Issue Type: Improvement
>          Components: sql
>            Reporter: Stanilovsky Evgeny
>            Priority: Major
>              Labels: calcite, calcite2-required, calcite3-required
>
> subclass of window queries with _row_number_ functionality are not supported for now.
> examples:
> {noformat}
> SELECT i, j, row_number() OVER (PARTITION BY i ORDER BY j NULLS FIRST) FROM test ORDER BY i NULLS FIRST, j NULLS FIRST;
> ---
> SELECT i, (SELECT row_number() OVER (ORDER BY i) FROM integers WHERE i1.i=i) FROM integers i1 ORDER BY i;
> {noformat}



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