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

Support NULL safe equals (<=>)

    XMLWordPrintable

    Details

    • Sprint:
      2017-9, 2017-10

      Description

      The NULL safe equals operator (<=>) gives a not supported error "Error Code: 122. IDB-1001: Function '<=>' can only be used in the outermost select or order by clause and cannot be used in conjunction with an aggregate function.".

      This should be implemented. We could implement it by expanding it to:

      a = b OR (a IS NULL AND b IS NULL)
      

      As outlined in: https://mariadb.com/kb/en/mariadb/null-safe-equal/

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              dleeyh Daniel Lee
              Reporter:
              LinuxJedi Andrew Hutchings (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              3 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.