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

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

              Dates

              Created:
              Updated:
              Resolved: