[MDEV-18444] ROW_FORMAT=COMPRESSED unnecessarily requires NOCOPY for INSTANT operation Created: 2019-02-01  Updated: 2019-02-07  Resolved: 2019-02-07

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

Type: Bug Priority: Major
Reporter: Eugene Kosov (Inactive) Assignee: Eugene Kosov (Inactive)
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Relates
relates to MDEV-18326 Refactor some ALTER column operations... Stalled

 Description    

create table t1(c varchar(9)) engine=innodb row_format=compressed;
 
insert into t1 values (repeat('a', 9));
 
alter table t1 modify c varchar(10), algorithm=nocopy;

In this ALTER TABLE only data dictionary and cache are updated. So, in fact it's an INSTANT operation.

 Comments   
Comment by Eugene Kosov (Inactive) [ 2019-02-05 ]

It was closed by accident.

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