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

support IGNORE/RESPECT NULLS for window functions

Details

    Description

      The lead and lag window functions support an extra clause IGNORE / RESPECT NULLS at the end. IGNORE NULLS means to exclude window entries that evaluate to null while the default behavior RESPECT NULLS would include them.

      Syntax is i believe for example NTH_VALUE(col1) IGNORE NULLS OVER (..)

      Attachments

        Issue Links

          blocks

          New Feature - A new feature of the product, which has yet to be developed. MCOL-625 MariaDB 10.2 WF Implement IGNORE/RESPECT NULLS in front end

          • Major - Major loss of function.
          • Closed
          is part of

          Epic - Created by Jira Software - do not edit or delete. Issue type for a big user story that needs to be broken down. MDEV-12987 complete window function support for columnstore parity

          • Major - Major loss of function.
          • Open

          Activity

            Ascending order - Click to sort in descending order
            naschoff nathan aschoff added a comment -

            It would be great to have this supported as it is impeding upgrades from 1.0 to 1.1.

            naschoff nathan aschoff added a comment - It would be great to have this supported as it is impeding upgrades from 1.0 to 1.1.
            ysth Yitzchak added a comment -

            Note that mysql has chosen to successfully parse both "IGNORE NULLS" and "RESPECT NULLS", but throw an error if "IGNORE NULLS" is specified.

            ysth Yitzchak added a comment - Note that mysql has chosen to successfully parse both "IGNORE NULLS" and "RESPECT NULLS", but throw an error if "IGNORE NULLS" is specified.

            People

              Unassigned Unassigned
              dthompson David Thompson (Inactive)
              Votes:
              3 Vote for this issue
              Watchers:
              5 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.