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

Wrong result for WHERE datetime_column > TIME('00:00:00')

    XMLWordPrintable

Details

    Description

      In this script:

      DROP TABLE IF EXISTS t1;
      		 
      CREATE TABLE t1 (a DATETIME);
      		 
      INSERT INTO t1 VALUES ('2000-09-12 00:00:00'), ('2007-04-25 05:08:49');
      		 
      SELECT * FROM t1 WHERE a>TIME'00:00:00';
      		 
      SELECT * FROM t1 WHERE a>TIME('00:00:00');

      the first SELECT query correctly returns empty set, and the second SELECT query erroneously returns two rows:

      +---------------------+
      		 
      | a                   |
      		 
      +---------------------+
      		 
      | 2000-09-12 00:00:00 |
      		 
      | 2007-04-25 05:08:49 |
      		 
      +--------------------

      Attachments

        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.