Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.0(EOL), 10.1(EOL)
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 |
|
+--------------------
|