Details
-
Type:
Bug
-
Status: Closed (View Workflow)
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: 5.5.42, 10.0.17, 10.1.3
-
Fix Version/s: 10.1.4
-
Component/s: Temporal Types
-
Labels:None
Description
This script:
DROP TABLE IF EXISTS t1;
|
CREATE TABLE t1 (a TIMESTAMP);
|
INSERT INTO t1 VALUES ('0000-00-00 00:00:00');
|
SELECT DATE_ADD(a, INTERVAL 10 SECOND) FROM t1;
|
SHOW WARNINGS;
|
returns:
+---------+------+----------------------------------------+
|
| Level | Code | Message |
|
+---------+------+----------------------------------------+
|
| Warning | 1292 | Incorrect datetime value: '0000-00-00' |
|
+---------+------+----------------------------------------+
|
The expected warning would be:
Incorrect datetime value: '0000-00-00 00:00:00'
|
Attachments
Issue Links
- blocks
-
MDEV-3929 Add system variable explicit_defaults_for_timestamp for compatibility with MySQL
-
- Closed
-