Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Not a Bug
-
5.5.46
-
Linux 3.11.10-32-desktop x86_64 (OpenSUSE 13.1), Intel Core i5
Description
Unable to insert some valid values to TIMESTAMP column.
Steps to reproduce the bug:
- Create new database: `create database SANDBOX;`
- Create new table: `create table test (id int primary key auto_increment, time timestamp not null);`
- Insert new row: `insert into test (time) values ('1984-04-01 00:59:37');`
Expected result:
`Query OK, 1 row affected (X.XX sec)`
Actual result:
`ERROR 1292 (22007): Incorrect datetime value: '1984-04-01 00:59:37' for column 'time' at row 1`
Additional info:
Another one value that causes the error: '2000-03-26 02:15:36'.
But, if I try to insert, say, '1974-04-01 00:59:37' or '1994-04-01 00:59:37' or '2001-03-26 02:15:36', it inserts without any error.
The error also happens if I try to update columns to set these values.