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

Avoiding computation when window frame is always empty

    XMLWordPrintable

Details

    Description

      Currently we allow constructs such as:

      [ROWS | RANGE] between N FOLLOWING and M FOLLOWING
      where N > M
      

      These constructs always lead to an empty frame. We correctly return results of NULL or 0 values for sum/window functions, however we perform a lot of unneeded IO operations. We can optimise this away by looking at frame definitions before starting computation.

      Attachments

        Issue Links

          Activity

            People

              psergei Sergei Petrunia
              cvicentiu Vicențiu Ciorbaru
              Sergei Petrunia Sergei Petrunia
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

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