Uploaded image for project: 'MariaDB ColumnStore'
  1. MariaDB ColumnStore
  2. MCOL-3714

Window frame RANGE is not optimized

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Won't Fix
    • 1.4.2
    • Icebox
    • ExeMgr
    • None

    Description

      For Window Functions, if a ROWS frame is used, then optimizations are made such that the row falling out of the frame is subtracted (whatever that means for the particular function) and the row coming into the frame is added.

      If RANGE frame is used, then the intermediate results from the previous row are ignored and the entire frame is iterated and recalculated.

      RANGE is the default for most Window Functions.

      This MCOL is to look for ways to optimize RANGE in a similar fashion as ROWS.

      Attachments

        Activity

          People

            Unassigned Unassigned
            David.Hall David Hall (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            1 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.