Bug #53290 wrong duplicate key error when adding a unique index via fast alter table
Submitted: 29 Apr 2010 15:31 Modified: 11 Jan 2011 0:49
Reporter: Shane Bester (Platinum Quality Contributor) Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: InnoDB Plugin storage engine Severity:S3 (Non-critical)
Version:5.1.46, plugin 1.0.7 OS:Any
Assigned to: John Russell CPU Architecture:Any
Tags: Contribution, duplicate key, fast alter table

File: Maximum allowed size is 50MB.
Description:
Privacy:

If the data you need to attach is more than 50MB, you should create a compressed archive of the data, split it to 50MB chunks, and upload each of them as a separate attachment.

To split a large file:

[29 Apr 2010 15:34] Shane Bester
testcase. import using innodb plugin and see duplicate key error

Attachment: bug53290.sql.gz (application/x-gzip, text), 189.00 KiB.

[1 May 2010 1:54] Ryan Mack
Possible fix.  Makes my test case pass.

Attachment: bug53290.patch (application/octet-stream, text), 3.18 KiB.

[1 May 2010 15:35] Ryan Mack
Short MTR repro case.

Attachment: innodb_bug53290.test (application/octet-stream, text), 713 bytes.