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

complete window function support for columnstore parity

Details

    • columnstore window function parity

    Description

      Previously ColumnStore 1.0 had a custom fork of the mariadb server code to support window functions. Migrating CS to 10.2 has identified that there is a gap in functionality provided by CS not in 10.2. This epic covers the individual feature requests to close this gap. All of these are ANSI specified or de-facto specified by other databases so not a one off.

      Attachments

        Issue Links

          includes

          Task - A task that needs to be done. MDEV-4835 Add Median Function

          • Major - Major loss of function.
          • Closed

          Task - A task that needs to be done. MDEV-9525 Window functions: Support for aggregate_func(DISTINCT ...) OVER (...)

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

          Task - A task that needs to be done. MDEV-9727 Window functions: datetime arithmetic for RANGE-type frames

          • Major - Major loss of function.
          • Open

          Task - A task that needs to be done. MDEV-12981 lead and lag don't support defaults

          • Major - Major loss of function.
          • Open

          Task - A task that needs to be done. MDEV-12983 support from last / first first with nth_value window function

          • Major - Major loss of function.
          • Open

          Task - A task that needs to be done. MDEV-12984 support IGNORE/RESPECT NULLS for window functions

          • Major - Major loss of function.
          • Open

          Task - A task that needs to be done. MDEV-12985 support percentile and median window functions

          • Major - Major loss of function.
          • Closed

          Task - A task that needs to be done. MDEV-12986 support nulls first / last for window function clauses

          • Major - Major loss of function.
          • Open

          Activity

            Ascending order - Click to sort in descending order
            dthompson David Thompson (Inactive) created issue -
            dthompson David Thompson (Inactive) made changes -
            Field Original Value New Value
            dthompson David Thompson (Inactive) made changes -
            dthompson David Thompson (Inactive) made changes -
            dthompson David Thompson (Inactive) made changes -
            dthompson David Thompson (Inactive) made changes -
            dthompson David Thompson (Inactive) made changes -
            dthompson David Thompson (Inactive) made changes -
            dthompson David Thompson (Inactive) made changes -
            dthompson David Thompson (Inactive) made changes -
            Epic Name window function parity for columnstore / ansi columnstore window function parity
            Summary complete window function support complete window function support for columnstore parity
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 81074 ] MariaDB v4 [ 140333 ]

            People

              ralf.gebhardt Ralf Gebhardt
              dthompson David Thompson (Inactive)
              Votes:
              3 Vote for this issue
              Watchers:
              4 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.