Uploaded image for project: 'Ignite'
  1. Ignite
  2. IGNITE-14777

row_number() with window functions unsupported.

    XMLWordPrintableJSON

    Details

      Description

      subclass of window queries with row_number functionality are not supported for now.
      examples:

      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;
      

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                zstan Stanilovsky Evgeny
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated: