MariaDB columnstore Some limitations and bug summaries

Limit
1. Character set syntax is not supported
MariaDB [test]> CREATE TABLE t1 (ID int,name varchar (ten) CHARACTER SET UTF8)
Engine=columnstore;
ERROR 1178 (42000): The storage engine for the table doesn ' t support the syntax or the data type (s) are not supported by Co Lumnstore. Please check the Columnstore Syntax guide for supported syntax or data types.

MariaDB [test]> CREATE TABLE t1 (id int)
-engine= Columnstore Collate=utf8_bin;
ERROR 1178 (42000): The storage engine for the table doesn ' t support the syntax or the data type (s) are not supported B Y Columnstore. Please check the Columnstore Syntax guide for supported syntax or data types.

MARIADB [test]> CREATE TABLE t1 (ID int,name varchar (TEN) COLLATE utf8_bin)
, Engine=columnstore;
ERROR 1178 (42000): The storage engine for the table doesn ' t support the syntax or the data type (s) are not supported by Co Lumnstore. Please check the Columnstore Syntax guide for supported syntax or data types.

3, Text/blob
MariaDB [test]> CREATE TABLE t1 (ID int,info text)
- > Engine=columnstore;
ERROR 1178 (42000): The storage engine for the table doesn ' t support the syntax or the data type (s) are not supported B Y Columnstore. Please check the Columnstore Syntax guide for supported syntax or data types.
MariaDB [Test]>

MARIADB [test]> CREATE TABLE t1 (ID int,info blob)
, Engine=columnstore;
ERROR 1178 (42000): The storage engine for the table doesn ' t support the syntax or the data type (s) are not supported by Co Lumnstore. Please check the Columnstore Syntax guide for supported syntax or data types.

4, TIMESTAMP not supported, the default Current_timestamp on UPDATE current_timestamp all delete
MariaDB [test]> CREATE table T1 (update_time timestamp) Engine=columnstore;
ERROR 1178 (42000): The storage engine for the table doesn ' t support the syntax or the data type (s) are not supported B Y Columnstore. Please check the Columnstore Syntax guide for supported syntax or data types.

MARIADB [test]> CREATE table T1 (update_time timestamp not NULL DEFAULT current_timestamp on update current_timestamp) Br>-> Engine=columnstore;
ERROR 1178 (42000): The storage engine for the table doesn ' t support the syntax or the data type (s) are not supported B Y Columnstore. Please check the Columnstore Syntax guide for supported syntax or data types.

5, decimal cannot be greater than
MariaDB [test]> CREATE table T1 (Money Decimal (19,2)) Engine=columnstore;
ERROR 1815 (HY000): Internal error:cal0009: (3) Create table failed due to  Syntax error:the maximum precision ( Total number of digits) so can be specified are.

6, row_format=compact
MariaDB [test]> CREATE TABLE t1 (id int) engine= Columnstore row_format=compact;
ERROR 1178 (42000): The storage engine for the table doesn ' t support the syntax or the data type (s) are not supported B Y Columnstore. Please check the Columnstore Syntax guide for supported syntax or data types.

7, varchar max 8000
MariaDB [test]> CREATE table T1 (name varchar (8001)) Engine=columnstore;
ERROR 1815 (HY000): Internal error:cal0009: (3) Create table failed due to char, varchar and varbinary length could not Exceed 8000

bug

https://jira.mariadb.org/browse/MCOL-1022
mariadb [test]> CREATE TABLE user (id int) engine= Columnstore;
ERROR 1178 (42000): The storage engine for the table doesn ' t support the syntax or the data type (s) are not supported B Y Columnstore. Please check the Columnstore Syntax guide for supported syntax or data types.

MariaDB [test]> CREATE table t1 (comment varchar) engine=columnstore;
ERROR 1178 (42000): The storage engine for the table doesn ' t support the syntax or the data type (s) are not supported by Co Lumnstore. Please check the Columnstore Syntax guide for supported syntax or data types.

MariaDB columnstore Some limitations and bug summaries