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

support IGNORE/RESPECT NULLS for window functions

    XMLWordPrintable

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

          Task - A task that needs to be done. MDEV-28906 MySQL 8.0 desired compatibility

          • Major - Major loss of function.
          • Open
          relates to

          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

          Activity

            People

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