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

NULLIF returns unexpected result with a YEAR field

    XMLWordPrintable

    Details

      Description

      DROP TABLE IF EXISTS t1;
      		 
      CREATE TABLE t1 (a YEAR(2));
      		 
      INSERT INTO t1 VALUES (0);
      		 
      SELECT a,NULLIF(a,2000),NULLIF(2001,a) FROM t1;

      returns

      +------+----------------+----------------+
      		 
      | a    | NULLIF(a,2000) | NULLIF(2001,a) |
      		 
      +------+----------------+----------------+
      		 
      |   00 |           NULL |              1 |
      		 
      +------+----------------+----------------+

      This is Ok that YEAR=00 is compared as equal to 2000, but the return value for NULLIF(2001,a) does not look Ok. The expected values is 2001, not 1.

        Attachments

          Activity

            People

            Assignee:
            bar Alexander Barkov
            Reporter:
            bar Alexander Barkov
            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.