MySQL Bugs: #20092: Access Coversion, Table did not replicate all 5100 plus records

Bug #20092	Access Coversion, Table did not replicate all 5100 plus records
Submitted:	26 May 2006 16:15	Modified:	30 Jun 2006 19:48
Reporter:	Oran Gough	Email Updates:
Status:	No Feedback	Impact on me:	None
Category:	MySQL Migration Toolkit	Severity:	S2 (Serious)
Version:	current	OS:	Windows (XP)
Assigned to:	Assigned Account	CPU Architecture:	Any

Description:
Converting MS Access to MySql.  Some tables did not have all the data converted.  One table with 5100 plus records only copied 1516 records to MySQL Dbase.  Yet another table with 88000 plus records completely converted.  There were no errors reported in the conversion.  
Reacomplished entire conversion with Duplicate Result: 

The query went through the third time in self identified resticted conversion of individual table.  I followed the conversion of this table and it seemed to convert the table multiple times-counting the records stopping and then counting again.
My Primary Key was converted as a unique index and a RecNo was used as the primary Key.  The Record number is not a unique number set and so it would not copy all of the records.  Changing the Primary Key to the MS Access Primary Key enabled me to copy accross the lost tables.

How to repeat:
Without my Database I think it might be hard to duplicate.  The Premise though is as follows:
Multiple series set of numbers in an number field.  Name it RecNo as first Field and put the primary key in the middle of the table.  My primary Key is a variable character (our Partnumbers).  I have a Hundred plus fields in this table

Suggested fix:
Recomend in the conversion Process that when its count of the rows does not equal the count of the converted table that an error be presented to the Data Converter.

Hi!

I was unable to reproduce this bug with MSAccess and SQL2005.  I think without your db structure, it will be very hard to reproduce.  Can you please send me your MDB file without data so that I can test it out ?  I will add my own data to the tables and hopefully this will be enough.  In case it doesn't work, do you think you can make a test-case using your MDB file and some bogus data ?

Thanks a lot

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".