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

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

    XMLWordPrintable

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

          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-17563 Different results using table or view when comparing values of time type

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-17625 Different warnings when comparing a garbage to DATETIME vs TIME

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-17632 Inconsistent behavior of conversion to DATETIME for comparison

          • Major - Major loss of function.
          • Open

          Activity

            People

              bar Alexander Barkov
              bar Alexander Barkov
              Votes:
              0 Vote for this issue
              Watchers:
              1 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.