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

Comparison between TIME and DATETIME does not use CURRENT_DATE

Details

    • Bug
    • Status: Closed (View Workflow)
    • Critical
    • Resolution: Fixed
    • 10.0.10
    • 10.0.12
    • None

    Description

      This SQL script:

      SET timestamp=UNIX_TIMESTAMP('2014-04-14 10:20:30');
      		 
      SELECT CAST(TIME'10:20:30' AS DATETIME), TIME'10:20:30'=TIMESTAMP'2014-04-14 10:20:30' AS cmp;

      demonstrates that conversion between TIME and DATETIME
      does not add CURRENT_DATE to TIME.

      +----------------------------------+-----+
      		 
      | CAST(TIME'10:20:30' AS DATETIME) | cmp |
      		 
      +----------------------------------+-----+
      		 
      | 2014-04-14 10:20:30              |   0 |
      		 
      +----------------------------------+-----+

      MySQL-5.6 returns "1" in the "cmp" field in the same scenario.

      Attachments

        Issue Links

          blocks

          Task - A task that needs to be done. MDEV-6001 Merge tests for MySQL WL#946 TIME/DATETIME/TIMESTAMP with fractional precision

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Stalled
          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-16532 Equality checks between now() and time columns behaves unexpectedly

          • Major - Major loss of function.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            bar Alexander Barkov created issue -
            bar Alexander Barkov made changes -
            Field Original Value New Value
            serg Sergei Golubchik made changes -
            Fix Version/s 10.0.11 [ 15200 ]
            bar Alexander Barkov made changes -
            Status Open [ 1 ] In Progress [ 3 ]
            serg Sergei Golubchik made changes -
            Fix Version/s 10.0.12 [ 15201 ]
            Fix Version/s 10.0.11 [ 15200 ]
            serg Sergei Golubchik made changes -
            Priority Major [ 3 ] Critical [ 2 ]
            bar Alexander Barkov made changes -
            Resolution Fixed [ 1 ]
            Status In Progress [ 3 ] Closed [ 6 ]
            serg Sergei Golubchik made changes -
            Workflow defaullt [ 38917 ] MariaDB v2 [ 43989 ]
            ratzpo Rasmus Johansson (Inactive) made changes -
            Workflow MariaDB v2 [ 43989 ] MariaDB v3 [ 63235 ]
            bar Alexander Barkov made changes -
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 63235 ] MariaDB v4 [ 147795 ]

            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.