Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Cannot Reproduce
-
1.5.2
-
None
Description
Build:
1.5.2-1
The following syntaxes throws an error with engine=Columnstore-
table level:
CREATE TABLE t1 (id INT, name VARCHAR(40)) CHARACTER SET utf8 ENGINE=Columnstore;
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.
CREATE TABLE t1 (id INT, name VARCHAR(40)) CHARSET 'utf8' ENGINE=Columnstore;
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.
CREATE TABLE t1 (id INT, name VARCHAR(40)) CHAR SET utf8 ENGINE=Columnstore;
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.
column level:
CREATE TABLE t1 (id INT, name VARCHAR(40) CHARSET 'utf8')ENGINE=Columnstore;
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.
The same syntaxes work fine with engine=Innodb.
These are the syntaxes that work with engine=Columnstore-
table level:
CREATE TABLE t1 (id INT, name VARCHAR(40)) CHARSET utf8 ENGINE=Columnstore;
column level
CREATE TABLE t2 (id INT, name VARCHAR(40)CHARACTER SET utf8) ENGINE=Columnstore;
CREATE TABLE t2 (id INT, name VARCHAR(40)CHARACTER SET 'utf8') ENGINE=Columnstore;
CREATE TABLE t2 (id INT, name VARCHAR(40)CHAR SET utf8) ENGINE=Columnstore;