Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Done
-
1.4.2, 1.5.3
-
None
Description
The problem is caused by a combination of fixed MCOL-265 (support for TIMESTAMP) and unfixed MCOL-1039 (support for CURRENT_TIMESTAMP).
drop table if exists t1; |
create table t1 (a timestamp) engine=Columnstore; |
show create table t1; |
By default, TIMESTAMP column in MariaDB server has CURRENT_TIMESTAMP as default/on update value. So, the resulting table is
CREATE TABLE `t1` ( |
`a` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() |
) ENGINE=Columnstore DEFAULT CHARSET=latin1 |
However, since current_timestamp is not supported for Columnstore, this statement cannot be run:
MariaDB [db]> CREATE TABLE `t1` ( |
-> `a` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() |
-> ) ENGINE=Columnstore DEFAULT CHARSET=latin1 |
-> ;
|
ERROR 1178 (42000): The storage engine for the table doesn't support The syntax or the data type(s) is not supported by Columnstore. Please check the Columnstore syntax guide for supported syntax or data types. |
It means that tools which rely on the output of SHOW CREATE TABLE – importantly, mysqldump, but there might be others – will fail as long as there is at least one such table.
