Re: Incorrect Primary Keys... Fixed

[ Follow Ups ] [ Post Followup ] [ SQL Script Builder Forum ]

Posted by Dave on March 27 2008 20:42:04

In Reply to: Re: Incorrect Primary Keys identified when converting from Access to MySQL posted by Dan Wilson on March 27 2008 19:32:05

Dan Wilson,

We believe the bug has been correctly identified and fixed in the new version (1.6.1.20)
available now for download.

Thanks for helping us finding this bug.

(Time to fix the bug and release new version : one hour and 20 minutes !)

David Birebent.

> Ok I think I found something else interesting. The software seems to accumulate the primary key strings throughout the batch generation. Notice how the list keeps getting larger?
>
> PRIMARY KEY(AssignmentID)
> PRIMARY KEY(AssignmentID,submittalID)
> PRIMARY KEY(AssignmentID,submittalID,BUID)
> PRIMARY KEY(AssignmentID,submittalID,BUID,peopleID)
> PRIMARY KEY(AssignmentID,submittalID,BUID,peopleID,peopleAssignedToID)
> .....
> PRIMARY KEY(AssignmentID,submittalID,BUID,peopleID,peopleAssignedToID,projectID,ID,projectOwnerID,ID,projectTypeID,reportLineID,resourceTypeID,RoleID,SubBUID)
>
>
> I hope this information was helpful...
>
>

Follow Ups:

Post a Followup

* : (Required)

* Name:
E-Mail:

* Subject:

* Comments:
> Dan Wilson, > > We believe the bug has been correctly identified and fixed in the new version (1.6.1.20) > available now for download. > > Thanks for helping us finding this bug. > > (Time to fix the bug and release new version : one hour and 20 minutes !) > > David Birebent. > > > Ok I think I found something else interesting. The software seems to accumulate the primary key strings throughout the batch generation. Notice how the list keeps getting larger? > > > > PRIMARY KEY(AssignmentID) > > PRIMARY KEY(AssignmentID,submittalID) > > PRIMARY KEY(AssignmentID,submittalID,BUID) > > PRIMARY KEY(AssignmentID,submittalID,BUID,peopleID) > > PRIMARY KEY(AssignmentID,submittalID,BUID,peopleID,peopleAssignedToID) > > ..... > > PRIMARY KEY(AssignmentID,submittalID,BUID,peopleID,peopleAssignedToID,projectID,ID,projectOwnerID,ID,projectTypeID,reportLineID,resourceTypeID,RoleID,SubBUID) > > > > > > I hope this information was helpful... > > > > >

Optional Link URL:
Link Title:
Optional Image URL:

Enter the code shown :

[ Follow Ups ] [ Post Followup ] [ SQL Script Builder Forum ]