Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Won't Do
-
1.2.0
-
None
-
CentOS Linux 7.4
Description
Cerate a table with a datetime column.
create table `date_columnstore`( |
recDate datetime DEFAULT NULL |
)ENGINE=columnstore DEFAULT CHARSET=utf8; |
|
Insert a record with '0000-00-00' as date.
insert into date_columnstore values ('0000-00-00'); |
Run the query:
select last_day(CONCAT(year(recdate),'-0',(month(recdate),'-01'))) from date_columnstore; |
This causes PrimProc to restart.
The same query in InnoDB or on dual returns null.
The current workaround for us is to replace '0000-00-00' with null.