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

Incorrect window functions results for empty frames

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • 11.4
    • 11.4
    • Server
    • None
    • Unexpected results

    Description

      COUNT/SUM/AVG over an empty RANGE frame (start bound after end bound) return non-empty results. Every frame below is empty, so the expected result is COUNT = 0 and SUM/AVG/MAX = NULL on every row. MAX is included as a control: it returns the correct NULL.

      See the SQL script attached.

      Attachments

        Issue Links

          relates to

          Task - A task that needs to be done. MDEV-10838 Avoiding computation when window frame is always empty

          • Critical - Crashes, loss of data, severe memory leak.
          • In Review

          Activity

            People

              oleg.smirnov Oleg Smirnov
              oleg.smirnov Oleg Smirnov
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:

                Time Tracking

                  Estimated:
                  Original Estimate - 0d
                  0d
                  Remaining:
                  Remaining Estimate - 4.5d
                  4.5d
                  Logged:
                  Time Spent - Not Specified
                  Not Specified

                  Git Integration

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