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

Inconsistent results for NULLIF function

    XMLWordPrintable

Details

    • Unexpected results

    Description

      Run the following statements, which return NULL. However, for the BIGINT UNSIGNED case,

      {0000-00-00 00:00:00}

      is returned.

      CREATE TABLE t1 (c1 TINYINT UNSIGNED);
      		 
      INSERT INTO t1 VALUES (18);
      		 
      SELECT (nullif((CAST(0 AS DATETIME)), c1)) FROM t1; -- {NULL}

      Attachments

        Activity

          People

            serg Sergei Golubchik
            John Jove John Jove
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.