Bug #36889 Forward Engineer SQL ALTER script generates script with syntax error
Submitted: 22 May 2008 15:48 Modified: 10 Jul 2008 10:14
Reporter: Klim Mad Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench Severity:S3 (Non-critical)
Version:5.0.21 OSS OS:Windows (SP2)
Assigned to: Vladimir Kolesnikov CPU Architecture:Any
Tags: alter, export, foreign keys, syntax, workbench

[22 May 2008 15:48] Klim Mad 
Description:
Workbench generates alter script with syntax errors.

How to repeat:
Open attached file, export create script, export alter script.
Created script contains syntax error in this line

ON UPDATE >>>CASCADEDROP<<< PRIMARY KEY , ADD PRIMARY KEY (`id`) , DROP INDEX `fk_player_session` , ADD INDEX 

I dont know how to repeat this bug from clear schemata.

Suggested fix:
Correct the mechanism that produces incorrect SQL ALTER syntax.
[22 May 2008 15:48] Klim Mad 
Sample file

Attachment: test.mwb (application/octet-stream, text), 4.66 KiB.
[22 May 2008 17:45] Valeriy Kravchuk 
Thank you for a bug report. Verified just as described.
[5 Jun 2008 14:36] Vladimir Kolesnikov 
the fix addressed some related problems with false diffs
[6 Jun 2008 14:19] Johannes Taxacher 
this has been fixed (the invalid code generation and unneeded re-creation of indices). fix will be included in 5.0.23.
[10 Jul 2008 10:14] Tony Bedford 
An entry has been added to the 5.0.23 changelog:

The script generated by the File, Export, Forward Engineer SQL ALTER Script menu item contains syntax errors.