[MCOL-4526] ALTER TABLE doesn't allow altering CHARSET or COLLATE Created: 2021-02-01  Updated: 2023-12-16  Resolved: 2023-12-15

Status: Closed
Project: MariaDB ColumnStore
Component/s: DDLProc
Affects Version/s: 5.5.1
Fix Version/s: Icebox

Type: Bug Priority: Major
Reporter: David Hall (Inactive) Assignee: Gregory Dorman (Inactive)
Resolution: Won't Fix Votes: 0
Labels: None

Issue Links:
Blocks
is blocked by MCOL-130 ALTER TABLE does not support changing... Closed
Epic Link: ColumnStore Compatibility Improvements

 Description   

ALTER TABLE region MODIFY COLUMN r_comment varchar(152) CHARACTER SET utf8;
ERROR 1815 (HY000): Internal error: CAL0001: Alter table Failed: Altertable: Error in the action type

ALTER TABLE region MODIFY COLUMN r_comment varchar(152) COLLATE latin1_bin;
ERROR 1815 (HY000): Internal error: CAL0001: Alter table Failed: Altertable: Error in the action type

Realize that changing character set my change the max length of the column, since various character sets use different byte counts.

This should be done after or in conjunction with MCOL-130 ALTER TABLE does not support changing data type


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