MySQL Bugs: #42085: Workbench .29 crashes afer File->Export->Forward Engineer SQL CREATE script

Bug #42085	Workbench .29 crashes afer File->Export->Forward Engineer SQL CREATE script
Submitted:	13 Jan 2009 15:01	Modified:	20 Feb 2009 15:28
Reporter:	Piotr Peterek	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Workbench	Severity:	S1 (Critical)
Version:	.5.0.29	OS:	Windows (XP, version 2002, SP3, )
Assigned to:	Alexander Musienko	CPU Architecture:	Any
Tags:	crash, export, SQL Create

Description:
== System Info ===
Looking for user plugins in D:\Documents and Settings\PTo\Application Data\MySQL\Workbench\modules
Looking for user plugins in D:\Documents and Settings\PTo\Application Data\MySQL\Workbench\plugins
MySQL Workbench OSS for Windows version 5.0.29
Cairo Version: 1.5.12
Rendering Mode: GDI Rendering
OpenGL Driver Version: Not Detected
OS: Windows XP
CPU: 2x Intel(R) Core(TM)2 Duo CPU     T7500  @ 2.20GHz, 2.0 GB RAM
Video adapter info:
Adapter type: Mobile Intel(R) 965 Express Chipset Family
Chip Type: Mobile Intel(R) 965 Express Chipset Family
BIOS String: Intel Video BIOS
Video Memory: 393216 KB

=== Problem Description ===
I've created data model (38 tables, lot of foregin keys). I exported it several times to SQL CREATE, worked on it several days, without problem.
Then I added User Type for several "ID" fields.
In some tables I changed type of those field to user types (ex.: "INT(20)" to "IDUSER" - as it's defined as "INT(20)").
Now each try of SQL CREATE export crashes the Workbench (the message: "MySQL Workbench has encountered a problem and needs to close.  We are sorry for the inconvenience.")

Is it misuse of "User Type" or a bug?

How to repeat:
Not sure but guessing:
1. Define user type (example: "IDUSER", INT(10))
2. Create Data Model with foregin key definition, where the field type is "IDUSER")
3. File->Export->Forward Engineer SQL CREATE script

Plugins->Objects->Copy SQL to Clipboard also crashes the WB

Wrong category, update.

Thank you for a problem report. Can you, please, upload an .mwb file with a simplest model that demonstrates the behaviour described.

I managed to simplify the model ;) One table, one user type.
What i did not mentioned before, is that at the very begining the model was imported from DBD4 file.
Also "Copy SQL to clipboard" after right click on the table crashes the app.

Thank you for the feedback. Just doing "Copy SQL to clipboard" crashes the application.

Crashing parts (summary):
1. File->Export->Forward Engineer SQL CREATE script
2.1 Plugins->Objects->Copy SQL to Clipboard
2.2 Right click on table, "Copy SQL to clipboard"

Thank you for fast response!

this was fixed. Fix will be included in 5.0.30

An entry was added to the 5.0.30 changelog:

Introducing a UserType into a model caused the File, Export, Forward Engineer SQL CREATE Script wizard to crash. Further, peforming a Plugins, Objects, Copy SQL to Clipboard operation also caused MySQL Workbench to crash.