Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.0(EOL), 10.1(EOL)
-
10.1.8-3
Description
DROP TABLE IF EXISTS t1;
|
CREATE TABLE t1 (a TIME);
|
INSERT INTO t1 VALUES ('10:20:30'),('10:20:30');
|
SELECT MAX(a), MAX(COALESCE(a)) FROM t1;
|
returns
+----------+------------------+
|
| MAX(a) | MAX(COALESCE(a)) |
|
+----------+------------------+
|
| 10:20:30 | 7594:20:30 |
|
+----------+------------------+
|
The expected result is to return 10:20:30 for both columns.
Attachments
Issue Links
- relates to
-
MDEV-8862 Wrong field type for MAX(COALESCE(datetime_column))
- Closed