Details
-
Type:
Bug
-
Status: Closed (View Workflow)
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: 5.5, 10.0, 10.1
-
Fix Version/s: 10.1.8
-
Component/s: Temporal Types
-
Labels:
-
Sprint:10.1.8-3
Description
DROP TABLE IF EXISTS t1;
|
CREATE TABLE t1 (a INT(6) ZEROFILL);
|
INSERT INTO t1 VALUES (1);
|
SELECT DATE(a), DATE(COALESCE(a)) FROM t1;
|
returns
+------------+-------------------+
|
| DATE(a) | DATE(COALESCE(a)) |
|
+------------+-------------------+
|
| 2000-00-01 | NULL |
|
+------------+-------------------+
|
1 row in set, 1 warning (0.00 sec)
|
Attachments
Issue Links
- relates to
-
MDEV-8660 TIME(int_zerofill_column) returns a wrong result
-
- Closed
-