[MDEV-14016] Allow instant ADD COLUMN, ADD INDEX, LOCK=NONE Created: 2017-10-06  Updated: 2023-03-30  Resolved: 2017-11-02

Status: Closed
Project: MariaDB Server
Component/s: Storage Engine - InnoDB
Affects Version/s: 10.3.2
Fix Version/s: 10.3.3

Type: Bug Priority: Major
Reporter: Marko Mäkelä Assignee: Marko Mäkelä
Resolution: Fixed Votes: 0
Labels: alter, ddl, online-ddl

Issue Links:
Problem/Incident
causes MDEV-14396 Assertion `(ha_alter_info->handler_fl... Closed
causes MDEV-15828 Server crash or assertion `num_fts_in... Closed
Relates
relates to MDEV-14219 Allow online table rebuild when encry... Closed
relates to MDEV-14246 Skip the ha_innobase::prepare_inplace... Closed
relates to MDEV-28912 Assertion `ha_alter_info->key_count +... Closed
relates to MDEV-11369 Instant add column for InnoDB Closed
relates to MDEV-30969 Some ALGORITHM=INSTANT checks are mis... Open
Sprint: 10.3.3-1

 Description   

Currently, InnoDB allows instant ADD COLUMN together with DROP INDEX, but not with ADD INDEX, even if the index is to be added on some other column than the instantly added column.

Also, if the table contains SPATIAL or FULLTEXT index, LOCK=NONE is wrongly refused for ADD COLUMN.
Generated at Thu Feb 08 08:10:15 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.