Bug #67759 | ALTER TABLE breaks REPEATABLE READ when Query Cache is enabled | ||
---|---|---|---|
Submitted: | 29 Nov 2012 15:10 | Modified: | 29 Jan 2013 6:28 |
Reporter: | Dmitry Lenev | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | MySQL Server: Locking | Severity: | S3 (Non-critical) |
Version: | 5.5.29-bzr, 5.5.30, 5.0.97 | OS: | Any |
Assigned to: | CPU Architecture: | Any |
[29 Nov 2012 15:10]
Dmitry Lenev
[29 Nov 2012 15:13]
Dmitry Lenev
This is actually a re-incarnation of bug #11981 which might make it technically not a bug but a documented limitation...
[29 Nov 2012 16:26]
Sveta Smirnova
Thank you for the report. Verified as described. Bug does not exist in version 5.7.1 In this version ALTER is blocked.
[29 Jan 2013 6:28]
Dmitry Lenev
This issue has been fixed in 5.6.6 version of MySQL Server. The fix is a side-effect of online/in-place index addition changes for InnoDB which were done in this version. These changes fixed bug both for case when ALTER TABLE is executed using ALGORITHM=INPLACE and using ALGORITHM=COPY.