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

Support NULL safe equals (<=>)

    XMLWordPrintable

Details

    • 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

              dleeyh Daniel Lee (Inactive)
              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.