Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Not a Bug
-
None
-
None
-
windows x64
Description
Very surprising issue, reproduced in both mariadb 10.2 and mysql. Different ENGINE doesn't affect the result.
Reproduce:
CREATE TABLE `ttt` (`ii` int, `dd` TIMESTAMP, `d2` TIMESTAMP);
insert into ttt (dd, d2) values ('2017-01-01 00:00:00', '2017-08-02 20:45:10');
SELECT * FROM ttt; ## OK, returns null 2017-01-01 00:00:00 2017-08-02 20:45:10
update ttt set ii=1;
SELECT * FROM ttt; ## Returns 1 2017-09-04 14:14:28 2017-08-02 20:45:10