[MDEV-16354] Allow ALGORITHM=INPLACE for ADD COLUMN…PERSISTENT AS Created: 2018-05-31  Updated: 2024-01-18

Status: Open
Project: MariaDB Server
Component/s: Storage Engine - InnoDB
Fix Version/s: None

Type: Task Priority: Major
Reporter: Marko Mäkelä Assignee: Marko Mäkelä
Resolution: Unresolved Votes: 1
Labels: ddl, online-ddl

Issue Links:
Blocks
is blocked by MDEV-16356 Allow ALGORITHM=NOCOPY for ADD CONSTR... Open
Relates
relates to MDEV-11424 Instant ALTER TABLE of failure-free r... Closed
relates to MDEV-16329 Engine-independent online ALTER TABLE Closed

 Description   

Adding a stored generated column is only implemented by the inefficient ALGORITHM=COPY. InnoDB should allow it with ALGORITHM=INPLACE, possibly even with ALGORITHM=NOCOPY (instantly add the column, then update the rows with the computed values). This might even be possible with LOCK=NONE.

MDEV-16329 would allow any ALTER TABLE with ALGORITHM=COPY and LOCK=NONE. The added value of an InnoDB-specific implementation would be that the table does not have to be copied.
Generated at Thu Feb 08 08:28:16 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.