Details
-
New Feature
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
None
-
None
Description
Upstream FR #115958
Description:
Currently, a table copy is required to toggle AUTO_INCREMENT on or off:
Reason: Cannot change column type INPLACE. Try ALGORITHM=COPY.
How to repeat:
DROP TABLE IF EXISTS `t`;
CREATE TABLE `t` (`id` bigint unsigned NOT NULL, PRIMARY KEY (`id`));
INSERT INTO `t` (id) VALUES (1), (100), (1000);
INSERT INTO `t` (id) VALUES (300);
SELECT `id` FROM `t`;
ALTER TABLE `t` MODIFY `id` bigint unsigned NOT NULL AUTO_INCREMENT, ALGORITHM=INPLACE;
Suggested fix:
Allow this change INPLACE
Attachments
Issue Links
- blocks
-
MDEV-16291 Allow ALGORITHM=NOCOPY for most ALTER TABLE in InnoDB
- Open
- relates to
-
MDEV-33188 Enhance mariadb-dump and mariadb-import capabilities similar to MyDumper
- Stalled
-
MDEV-34703 Innodb bulk load : high IO, crashes on Linux, OOM on Linux, as tested with LOAD DATA INFILE
- Open
- links to