Bug #68019 | Table is lost during 'ALTER TABLE' command | ||
---|---|---|---|
Submitted: | 3 Jan 2013 7:23 | Modified: | 18 Feb 2013 18:50 |
Reporter: | Yuri Koba | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | MySQL Server: InnoDB storage engine | Severity: | S2 (Serious) |
Version: | 5.6.9-rc | OS: | Windows (Windows 7) |
Assigned to: | Marko Mäkelä | CPU Architecture: | Any |
Tags: | 1030, 38 |
[3 Jan 2013 7:23]
Yuri Koba
[3 Jan 2013 7:40]
MySQL Verification Team
This is repeatable on 5.6.9, but not repeatable on current sources. So it's been fixed already, please wait for 5.6.10 to be released..
[3 Jan 2013 8:32]
MySQL Verification Team
still repeatable with 5.6.10 too. so we should wait for 5.6.11...
[18 Feb 2013 18:50]
John Russell
Added to changelog for 5.6.10: In online DDL operations, a DROP FOREIGN KEY clause was not allowed in an ALTER TABLE statement that also performed any of the following: Adding or dropping a column. Adding or dropping a primary key index. Making a column NULL or NOT NULL. Reordering columns. Changing the ROW_FORMAT or KEY_BLOCK_SIZE properties.