Details
-
New Feature
-
Status: Open (View Workflow)
-
Minor
-
Resolution: Unresolved
-
23.02
-
None
-
None
-
None
Description
At the Columnstore, we don't seem like having syntax to change an existing table collation or character set.
Can we implement this feature:
Reproduction:
create database if not exists test; use test; |
drop table if exists t; |
CREATE TABLE if not exists `t` ( `c` char(3) DEFAULT NULL ) ENGINE=Columnstore DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci ; |
alter table t collate=utf8mb3_bin;
|
alter table t CONVERT TO CHARACTER SET utf8mb3 collate utf8mb3_bin;
|
Errors:
|
|
MariaDB [test]> alter table t collate=utf8mb3_bin;
|
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.
|
|
|
MariaDB [test]> alter table t CONVERT TO CHARACTER SET utf8mb3 collate utf8mb3_bin;
|
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.
|
|