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

Regression: TIME(0)=TIME('z') returns NULL vs 1

    Details

      Description

      10.4

      SELECT TIMESTAMP(0)=TIMESTAMP('z') AS ts, DATE(0)=DATE('z') AS d, TIME(0)=TIME('z') AS t;
      

      +------+------+------+
      | ts   | d    | t    |
      +------+------+------+
      |    1 |    1 | NULL |
      +------+------+------+
      

      10.3

      SELECT TIMESTAMP(0)=TIMESTAMP('z') AS ts, DATE(0)=DATE('z') AS d, TIME(0)=TIME('z') AS t;
      

      +------+------+------+
      | ts   | d    | t    |
      +------+------+------+
      |    1 |    1 |    1 |
      +------+------+------+
      

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                bar Alexander Barkov
                Reporter:
                bar Alexander Barkov
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: