Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-9780

Window functions: interplay between window function and other constructs

    Details

    • Sprint:
      10.2.0-9, 10.2.0-10, 10.2.0-11

      Description

      Study (and fix) the interplay between window functions and other SQL constructs, like ORDER BY ... LIMIT, DISTINCT, etc.

      Known things:

      • LIMIT should be applied AFTER the window functions are computed (that is, window function computation should see rows that are cut off by LIMIT)
      • DISTINCT must not be converted into GROUP BY when window functions are present
      • need to check window functions inside derived table and/or union. Item_window_func::update_field() is not implemented, is this ok?

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                psergey Sergei Petrunia
                Reporter:
                psergey Sergei Petrunia
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: