[MDEV-18961] Converting charset to BINARY should be instantaneous Created: 2019-03-18  Updated: 2019-09-23  Resolved: 2019-04-01

Status: Closed
Project: MariaDB Server
Component/s: Data Definition - Alter Table, Storage Engine - InnoDB
Fix Version/s: 10.4.4

Type: Task Priority: Major
Reporter: Eugene Kosov (Inactive) Assignee: Eugene Kosov (Inactive)
Resolution: Won't Do Votes: 0
Labels: None

Issue Links:
Blocks
blocks MDEV-17301 Change of COLLATE unnecessarily requi... Closed

 Description   

This is a missing feature.

 Comments   
Comment by Eugene Kosov (Inactive) [ 2019-03-19 ] 

create table t (a char(1) charset utf8mb4) engine=innodb;
 
insert into t values ('ы');
 
--error ER_DATA_TOO_LONG
 
alter table t modify a char(1) charset binary, algorithm=copy;

Here actual data is checked so this can't be instant.

Same for varchar.

Comment by Eugene Kosov (Inactive) [ 2019-04-01 ]

Probably INSTANT CHARSET ALTER would be possible for TEXT field but the scope of this ticket is pretty narrow. I'm closing it now because, IMO, it's not worth been implemented.

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