[MDEV-17965] Allow instant VARCHAR increase of indexed fields Created: 2018-12-10  Updated: 2018-12-19  Resolved: 2018-12-19

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

Type: Task Priority: Major
Reporter: Eugene Kosov (Inactive) Assignee: Marko Mäkelä
Resolution: Duplicate Votes: 0
Labels: None

Issue Links:
Blocks
blocks MDEV-15564 Avoid table rebuild in ALTER TABLE on... Closed
Duplicate
duplicates MDEV-16849 Extending indexed VARCHAR column shou... Closed

 Description   

Index data is not changed in ALGORITHM=INSTANT so it's safe to perform such operation on indexes field.

Similar case is in MDEV-15564 where charset can be changed for indexes field from f.ex utf8mb3 to utf8mb4. And this issue is primary needed for MDEV-15564 to solve a problem on SQL level.

Every storage engine which supports INPLACE ALTER can benefit from it. But right now only InnoDB supports IS_EQUAL_PACK_LENGTH so this change is for InnoDB.

 Comments   
Comment by Eugene Kosov (Inactive) [ 2018-12-19 ]

Closing as a duplicate.

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