Bug #62013 Forward Engineer SQL Alter does not produce output
Submitted: 28 Jul 2011 9:42 Modified: 11 Aug 2011 6:38
Reporter: Carlos Fernin Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Workbench: Modeling Severity:S2 (Serious)
Version:5.2.34 rev. 7780 OS:Any (Windows 7 (x64), Mac OS X 10.5.x)
Assigned to: CPU Architecture:Any
Tags: forward engineer sql alter, regression

[28 Jul 2011 9:42] Carlos Fernin 
Description:
After selecting the source SQL script and selecting the output file in the "file/export/Forward Engineer SQL Alter" menu item the output is blank.

The window looks like it's refreshing constantly since you see blinks every 3 seconds approximately, so this might be an error with the refresing of the text.

Also the "back", "next" and "cancel" buttons are disabled so you cannot click them but you can close this window clicking on the top/right x.

2 or 3 versions ago this worked perfectly.
I upgraded to the 5.2.34 version and it stopped working.

Thanks

How to repeat:
1.Create a new model and a new associated EER diagram

2.Add a table (you don't need to change the name or anything)

3.Save and export as SQL

4.Add another table

5.Save and export alter SQL file (now you will see the blank text window)

Suggested fix:
This worked before so checking out sources 2 or 3 versions before could help
[28 Jul 2011 9:46] Carlos Fernin 
Forgot to add x64 to the OS (Windows 7 x64)
[28 Jul 2011 10:56] MySQL Verification Team 
Could you please provide a screen-shot and the output of Help->System Info. Thanks.
[28 Jul 2011 11:10] Carlos Fernin 
blank text from calling forward engineer sql alter

Attachment: bug-screenshot.jpg (image/jpeg, text), 45.29 KiB.
[28 Jul 2011 11:15] Carlos Fernin 
Sytem info included as requested:

Info:	Time: 13:05:16	Message: wb.file.newDocument finished in 0.05s	Details: n/a
Info:	Time: 13:05:37	Message: wb.file.saveModel finished in 11.96s	Details: n/a
Info:	Time: 13:05:59	Message: Wrote CREATE Script to 'C:\Users\Antonio\Desktop\deleteme.sql'	Details: n/a
Info:	Time: 13:05:59	Message: db.mysql.plugin.export.sql finished in 16.63s	Details: n/a
Info:	Time: 13:06:02	Message: wb.file.saveModel finished in 0.05s	Details: n/a
Info:	Time: 13:07:26	Message: db.mysql.plugin.export.alter finished in 80.06s	Details: n/a
Info:	Time: 13:12:35	Message: db.mysql.plugin.export.alter finished in 206.86s	Details: n/a

As you can see I left the window open for 80 seconds and I tried again leaving it open for 206 seconds. 

Still I get nothing

Thanks!
[28 Jul 2011 11:19] Carlos Fernin 
The frame of the text window (just the black line surrounding the text) blinks every time I move the cursor in or out of the text part (which is blank)

When I first said it blinked every few seconds, I was wrong, it is every time I move the cursor in or out of the area
[28 Jul 2011 12:00] Carlos Fernin 
Added rev. 7780 to the version (5.2.34 rev. 7780)
[29 Jul 2011 13:14] Valeriy Kravchuk 
Verified just as described on Mac OS X. When I clicked on Continue button to generate and view SQL ALTER script, Workbench hanged for a while and then just crashed. 

So, we have repeatable problem on different OSes here.
[3 Aug 2011 16:34] Dave Power 
Appears to be a duplicate of bug http://bugs.mysql.com/bug.php?id=61730
[5 Aug 2011 0:06] Alfredo Kojima 
Duplicate of bug #61730
[11 Aug 2011 6:38] Carlos Fernin 
I doesn't crash for me, so is it the same bug?