Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Fixed
-
1.0.8
-
None
-
None
-
2017-10, 2017-11
Description
select least(min(action_date),cast('2000-01-01' as datetime)) from test; |
results in 0000-00-00 00:00:00 when it should be '1999-01-01'.
CREATE TABLE `test` ( |
`action_date` date NOT NULL |
) ENGINE=InfiniDB;
|
insert into test (action_date) values ('1999-01-01'); |
insert into test (action_date) values ('2020-01-01'); |
select least(min(action_date),cast('2000-01-01' as datetime)) from test; |
This did not happen on InfiniDB.