[MCOL-5616] alter table ... collation is not work on columnstore Created: 2023-11-20  Updated: 2023-12-06

Status: Open
Project: MariaDB ColumnStore
Component/s: None
Affects Version/s: 23.02
Fix Version/s: None

Type: New Feature Priority: Minor
Reporter: suresh ramagiri Assignee: Max Mether
Resolution: Unresolved Votes: 0
Labels: 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.


Generated at Thu Feb 08 02:59:11 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.