Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Not a Bug
-
10.9(EOL)
-
None
Description
There is a compatibility issue between MySQL 5.7 and MariaDB when using the DATE_ADD function.
Create the table and insert the values:
CREATE TABLE t0 (c_0 TEXT, c_1 INT); |
INSERT INTO t0 VALUES ('6389-08-27 07:05:39.000000', 10894); |
SELECT (DATE_ADD(t0.c_0, INTERVAL t0.c_1 DAY)) FROM t0; |
MySQL 5.7 returns:
6419-06-25 07:05:39
MariaDB returns:
6419-06-25 07:05:39.000000
This doesn't look like a MariaDB bug. MySQL forgets the temporal precision information, feel free to report this to MySQL