[MDEV-28262] When alter modify column, INSTANT algorithm cannot be used Created: 2022-04-08  Updated: 2022-04-08

Status: Open
Project: MariaDB Server
Component/s: Documentation
Fix Version/s: None

Type: Task Priority: Major
Reporter: sangwoo kim Assignee: Ian Gilfillan
Resolution: Unresolved Votes: 0
Labels: None

Attachments: Text File test.txt    

 Description   

https://mariadb.com/kb/en/innodb-online-ddl-operations-with-the-instant-alter-algorithm/#alter-table-modify-column

When alter modify column, INSTANT algorithm cannot be used

When alter table modify, there is no change in column type and size, but it seems that INSTANT algorithm cannot be used in case of temporal format change.
I attach the sample test file as test.txt.
And in the link above, such as the changes case of mariadb53 to mysql56, wouldn't it be better to add a mention where the INSTANT algorithm cannot be used to prevent issues that may occur when changing the temporal format of a column?


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