MySQL Bugs: #60966: Terminating MySQL Workbench 5.2 while creating a new table on SQL Editor window

Bug #60966	Terminating MySQL Workbench 5.2 while creating a new table on SQL Editor window
Submitted:	24 Apr 2011 14:09	Modified:	1 Jun 2011 7:14
Reporter:	- -	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Workbench: SQL Editor	Severity:	S2 (Serious)
Version:	5.2.33 CE Revision 7508	OS:	Windows (XP SP3 version 2002)
Assigned to:		CPU Architecture:	Any
Tags:	CREATE TABLE, sql editor, synchronizing data

Description:
MySQL Workbench freezes and termanates itself immediatelly with error message.

How to repeat:
Setup and additional info:
1. MySQL Workbench 5.2.33 CE and MySQL Server 5.0.67 installed.
2. MySQL Server is running.
3. Manual = manual for the the MySQL Workbench SE version 5.2 and the MySQL Workbench OSS version 5.2 (generated on: 2011-04-17, revision: 25908);
instruction 1: Chapter 4.1;
instruction 2: steps 1, 2 from Chapter 4.2.
instruction 3: steps 9-21 from Chapter 4.2.
instruction 4: steps 9-21 from Chapter 6.7.
4. SQL1: CREATE  TABLE <schema name>.`new_table` (`idnew_table` INT NOT NULL ,  PRIMARY KEY (`idnew_table`) );
5. Error signature:
AppName: mysqlworkbench.exe
AppVer: 5.2.33.7508
AppStamp:4d820632
ModName: wbprivate.be.dll
ModVer: 0.0.0.0
ModStamp:4d8204b5
fDebug: 0
Offset: 002412d7

Steps to reproduce the problem:
1. Run MySQL Workbench.
2. Create new locally installed server instance with default settings (please, follow instruction 1).
3. Create a new model with default settings and new clear schema (please, follow instruction 2).
4. Save model and create a new connection (please, follow instruction 3).
5. Open the SQL Editor (instruction 4).
6. Select the model you created at step 3.
7. Select item "Add table" in Object Browser.
8. Select the "Column" tab in New Table window to create a default row.
9. Click "apply" button in "New Table" window.
10. Check that generated SQL statement = SQL1, where <schema name>=empty (``).
11. Click "apply" button in "Apply SQL script to database" window.
12. Check that error message 1102 "Incorrect database name" appeared.
13. Click "Back" button in "Apply SQL script to database" window.
14. Modify SQL statement to make it like SQL1, where <schema name>= schema name from step 3.
15. Click "apply" button in "Apply SQL script to database" window.

BUG: MySQL Workbench freezes and termanates immediatelly with error message (see item 5 of Setup and additional info).
Expected result: creation a new table.

Thank you for the bug report. In step 3 what you meant with 'new clear schema'?. Thanks.

> Thank you for the bug report. In step 3 what you meant with 'new clear
schema'?. Thanks.
< I meant you needn't add any tokens in the schema (tables, views, etc). You can simple use default "mydb" schema. Please, contact me once again if something is still incomprehensible.

I couldn't repeat on Vista 64-bit.

This is why the error occured on <b>32 bit</b> Microsoft Windows (XP SP3 version 2002).
Couldn't you emulate the same condititions?

Thanks a lot for report.

Hello.
The new Workbench 5.2.34 is out, can you please download it and give a try? (I'm very sure that your problem is solved in this version).
http://dev.mysql.com/downloads/workbench/5.2.html
Thanks.

I have downloaded and tried the new Workbench 5.2.34 on my XP SP3 version 2002 (32bit). The bug didn't occur, moreover, I see, some minor features in Object Browser window were fixed. Thereby, Bug #60966 can be closed. Thank you for diligence.

I have downloaded and tried the new Workbench 5.2.34 on my XP SP3 version 2002 (32bit). The bug didn't occur, moreover, I see, some minor features in Object Browser window were fixed. Thereby, Bug #60966 can be closed. Thank you for diligence.

Noted in 5.2.34 changelog.

Workbench could crash while applying an SQL script to a database.