[MDEV-13640] ALTER TABLE CHANGE and ADD INDEX on auto_increment column fails with "Incorrect key file for table..." - Jira

XML

Word

Printable

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Fixed
Affects Version/s: 10.3.0, 10.1.26, 10.0.32, 10.2.8, 10.0(EOL), 10.1(EOL), 10.2(EOL)
Fix Version/s: 10.0.33, 10.1.30, 10.2.12, 10.3.3
Component/s: Data Definition - Alter Table, Storage Engine - InnoDB, Storage Engine - XtraDB
Labels:
None

An ALTER TABLE CHANGE and ADD INDEX on auto_increment column fails with "Incorrect key file for table...".

CREATE TABLE t (

a bigint(20) unsigned NOT NULL AUTO_INCREMENT,

c bigint(20) unsigned NOT NULL,

PRIMARY KEY (a)

) ENGINE=InnoDB ;

ALTER TABLE t CHANGE a b BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, ADD KEY uk (c);

ERROR 1034 (HY000): Index for table 't' is corrupt; try to repair it

relates to

MDEV-9469 'Incorrect key file' on ALTER TABLE

MDEV-9548 Alter table (renaming and adding index) fails with "Incorrect key file for table"

MDEV-13625 Merge InnoDB test cases from MySQL 5.6

MDEV-13626 Merge InnoDB test cases from MySQL 5.7

MDEV-13668 InnoDB unnecessarily rebuilds table when renaming a column and adding index

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.