Uploaded image for project: 'MariaDB ColumnStore'
  1. MariaDB ColumnStore
  2. MCOL-625

MariaDB 10.2 WF Implement IGNORE/RESPECT NULLS in front end

Details

    Description

      Some Windows Functions such as LEAD and LAG have an optional Parameter for IGNORE or RESPECT NULLS. Columnstore 1.0 supports this parameter.

      Attachments

        Issue Links

          Activity

            It appears that the columnstore backend is coded to support this, but as far as I can tell, it's never been tested. The 10.1 frontend also appears to have support, but it syntaxes when this parameter is added. There are no tests in the regression suite for IGNORE or RESPECT NULLS.

            David.Hall David Hall (Inactive) added a comment - It appears that the columnstore backend is coded to support this, but as far as I can tell, it's never been tested. The 10.1 frontend also appears to have support, but it syntaxes when this parameter is added. There are no tests in the regression suite for IGNORE or RESPECT NULLS.

            dleeyh Do you have test for IGNORE/RESPECT NULLS ?

            dshjoshi Dipti Joshi (Inactive) added a comment - dleeyh Do you have test for IGNORE/RESPECT NULLS ?

            No, I don't.

            dleeyh Daniel Lee (Inactive) added a comment - No, I don't.

            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.

            This item is being closed because it was well passed the expiration date with no activity. If you suspect this was done in error please create a new ticket.

            toddstoffel Todd Stoffel (Inactive) added a comment - This item is being closed because it was well passed the expiration date with no activity. If you suspect this was done in error please create a new ticket.

            People

              toddstoffel Todd Stoffel (Inactive)
              David.Hall David Hall (Inactive)
              Votes:
              1 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.