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

Add Distinct capability to specific UDAnF Window Functions

    XMLWordPrintable

Details

    • New Feature
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 1.1.5
    • 1.1.7
    • ExeMgr
    • None
    • 2018-17, 2018-18, 2018-19, 2018-20, 2018-21

    Description

      Currently, there's no way to create a UDAnF that creates a DISTINCT result. The parser won't pass DISTINCT when an aggregate is used as an analytic function.

      This ticket is to add a DISTINCT flag to the UDAnF context so that a UDAnF can be created that is always DISTINCT. It's also possible to create a multi-parm aggregate that could use one of the parameters to indicate distinctness.

      This ticket does not cover the case of UDAF – the use of a function as an aggregate, not a Window Function.

      UDAnF created with this feature should have the UDAF_OVER_REQUIRED flag set in the runflags, as the distinctness would be ignored by aggregate use and would definitely confuse a user.

      Attachments

        Issue Links

          Activity

            People

              David.Hall David Hall (Inactive)
              David.Hall David Hall (Inactive)
              Votes:
              1 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.