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

            Activity

              People

              Assignee:
              Unassigned
              Reporter:
              dthompson David Thompson (Inactive)
              Votes:
              3 Vote for this issue
              Watchers:
              5 Start watching this issue

                Dates

                Created:
                Updated:

                  Git Integration