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

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