Bug #10715 Primary key being violated by duplicate key entries
Submitted: 18 May 2005 15:32 Modified: 11 Jul 2005 15:12
Reporter: Ken Senior Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Server: MyISAM storage engine Severity:S1 (Critical)
Version:4.1 OS:Linux (Linux)
Assigned to: CPU Architecture:Any

[18 May 2005 15:32] Ken Senior 
Description:
I have noticed several instances now where MySQL is allowing duplicate key entries on my primary key.  I have several tables which have a primary key consisting of two fields, a char(4) field and a double precision field.  The scripts which insert the data (using mysqlimport) produce a truncated decimal value for the double precision field (6 decimals) and I'm certain the duplicate values inserted are numerically equivalent.  This clearly isn't supposed to happen.

How to repeat:
Since I'm not sure exactly how this is happening, I'm not sure how to repeat it.  However, I can send a copy of the tables involved which have the duplicate entries and the primary keys defined.
[18 May 2005 16:29] MySQL Verification Team 
Yes please provide the tables for test, you can make not public
if you want.

Thanks in advance.
[25 May 2005 14:43] Ken Senior 
I'll upload the table, but take note that it is very large.
[11 Jun 2005 10:57] Ken Senior 
Ok, so the file upload clearly failed.  I wonder if the test you intend would still be useful if I extracted into another table a smaller segment of the data containing some of the duplicates?
[11 Jun 2005 15:12] Sergei Golubchik 
Absolutely. The smaller the test case the better.
[11 Jul 2005 23:00] Bugs System 
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".