Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.3.2, 10.4.0
Description
The scope of MDEV-11369 was reduced by introducing an artificial limitation: ADD COLUMN together with any ADD INDEX operation will require the table to be rebuilt. While ALGORITHM=INSTANT cannot support index creation, we could certainly support ALGORITHM=NOCOPY and create the requested indexes without rebuilding the entire table. This should be possible with LOCK=NONE or ALTER ONLINE TABLE as well.
Attachments
Issue Links
- blocks
-
MDEV-16291 Allow ALGORITHM=NOCOPY for most ALTER TABLE in InnoDB
- Open
- relates to
-
MDEV-11369 Instant add column for InnoDB
- Closed