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

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

        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 |
+--------------------

            Gliffy Diagrams

              Attachments

                Activity

                Hide
                Permalink
                bar Alexander Barkov added a comment -

                Not repeatable in MySQL-5.7.8

                Show
                bar Alexander Barkov added a comment - Not repeatable in MySQL-5.7.8

                  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: