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:
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

[13 Jan 2009 15:01] Piotr Peterek
== 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
[13 Jan 2009 15:07] Piotr Peterek
Plugins->Objects->Copy SQL to Clipboard also crashes the WB
[13 Jan 2009 15:37] Piotr Peterek
Wrong category, update.
[13 Jan 2009 16:03] Valeriy Kravchuk
Thank you for a problem report. Can you, please, upload an .mwb file with a simplest model that demonstrates the behaviour described.
[13 Jan 2009 18:31] Piotr Peterek
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.
[13 Jan 2009 21:32] MySQL Verification Team
Thank you for the feedback. Just doing "Copy SQL to clipboard" crashes the application.
[14 Jan 2009 10:52] Piotr Peterek
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!
[12 Feb 2009 23:00] Johannes Taxacher
this was fixed. Fix will be included in 5.0.30
[20 Feb 2009 15:28] Tony Bedford
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.