Bug #35644 Database synchronisation
Submitted: 28 Mar 2008 13:37 Modified: 11 Jul 2008 8:14
Reporter: Chris Crossley Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench Severity:S3 (Non-critical)
Version:5.0.16 OS:Any
Assigned to: Vladimir Kolesnikov CPU Architecture:Any

[28 Mar 2008 13:37] Chris Crossley 
Description:
When you syn a database and add an FK with index the generated script is fine apart from a , or space char after the Fk but before the index.

I am working on 5.0.45 database so syntax may not be supported

How to repeat:
Create a new FK between two tables. The sync script should generate a FK statment and also an "ADD" for the INDEX. There is now space or ',' between them.
[31 Mar 2008 2:31] Robert Cesaric 
I was just about to report the same bug when I found it has already been done by Crhis.  Here's another snippet from my Workbench to display the syntax error:

...ON UPDATE NO ACTIONDROP PRIMARY KEY ...

As you can see "ACTIONDROP" should have a comma+space in it "ACTION, DROP".
[6 Jun 2008 11:21] Johannes Taxacher 
the fix for this issue is included in recent version 5.0.22 (revno 3118)
[11 Jul 2008 8:14] Tony Bedford 
An entry has been added to the 5.0.22 changelog:

The script generated by database synchronize contains errors.