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

lead and lag don't support defaults

Details

    Description

      ColumnStore and other database vendor implementations support a default parameter for the lead and lag window functions. The standard syntax is:
      LAG (value_expression [,offset] [,default])
      LEAD (value_expression [,offset] [,default])

      where the optional default is the value returned should the offset be outside of the window frame. If unspecified then NULL is used.

      Attachments

        Issue Links

          blocks

          New Feature - A new feature of the product, which has yet to be developed. MCOL-646 MariaDB 10.2 WF Add the default option to LEAD/LAG

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • 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
            dthompson David Thompson (Inactive) created issue -
            dthompson David Thompson (Inactive) made changes -
            Field Original Value New Value
            dthompson David Thompson (Inactive) made changes -
            Affects Version/s 10.2.6 [ 22527 ]
            Issue Type Bug [ 1 ] Task [ 3 ]
            dthompson David Thompson (Inactive) made changes -
            dbart Daniel Bartholomew added a comment - - edited

            MySQL 8.0.2 DMR supports the default option to LEAD/LAG window functions, so this is needed to maintain syntax compatibility.

            dbart Daniel Bartholomew added a comment - - edited MySQL 8.0.2 DMR supports the default option to LEAD/LAG window functions, so this is needed to maintain syntax compatibility.
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 81068 ] MariaDB v4 [ 130650 ]

            People

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