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

Window functions: interplay between window function and other constructs

    XMLWordPrintable

Details

    • 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

              psergei Sergei Petrunia
              psergei Sergei Petrunia
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.