5.7 mtr failure INSERT failed: 1292: Incorrect datetime value: '00-00-00' for column ...

Description

Happens in tests:
tokudb.type_timestamp_explicit

tokudb.type_timestamp

tokudb.type_datetime : At line 12: query 'insert into t1 values (101),(691231),(700101),(991231),(10000101),(99991231),(101000000),(691231000000),(700101000000),(991231235959),(10000101000000),(99991231235959),(20030100000000),(20030000000000)' failed: 1292: Incorrect datetime value: '20030100000000' for column 't' at row 13

tokudb.type_temporal_upgrade : At line 23: query 'INSERT INTO t1 (f_time, f_datetime, f_timestamp)
VALUES (9999999, 999999999999999, 999999999999999)' failed: 1292: Incorrect time value: '9999999' for column 'f_time' at row 1

tokudb.type_time : At line 16: query 'insert into t1 values("10.22.22"),(1234567),(123456789),(123456789.10),("10 22:22"),("12.45a")' failed: 1292: Incorrect time value: '10.22.22' for column 't' at row 1

Environment

None

Activity

Show:
George Lorch
January 4, 2016, 8:54 PM

Assignee

George Lorch

Reporter

George Lorch

Labels

External issue ID

None

Freshdesk Tickets

None

Fix versions

Affects versions

Priority

Major
Configure