Stanilovsky Evgeny created IGNITE-14777:
-------------------------------------------
Summary: 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
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)