MySQL Bugs: #67235: Ghost columns in the EER Diagram (model designer)

Bug #67235	Ghost columns in the EER Diagram (model designer)
Submitted:	15 Oct 2012 13:19	Modified:	29 Nov 2012 6:15
Reporter:	Fotis Kokkoras	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Workbench: Modeling	Severity:	S1 (Critical)
Version:	5.2.44	OS:	Windows (Microsoft Windows 7 Service Pack 1 (build 7601), 64-bit)
Assigned to:		CPU Architecture:	Any
Tags:	WBBugReporter

Description:
While working on an EER diagram fine-tuning tables, Workbench sometimes adds column entries to the working table.

----- Developer Notes -----

MySQL Workbench CE for Windows version 5.2.44  revision 9933
Configuration Directory: C:\Users\Fotis\AppData\Roaming\MySQL\Workbench
Data Directory: C:\Program Files (x86)\MySQL\MySQL Workbench
Cairo Version: 1.8.8
OS: Microsoft Windows 7  Service Pack 1 (build 7601), 64-bit
CPU: 4x Intel(R) Core(TM) i5-2500K CPU @ 3.30GHz, 8.0 GiB RAM
Active video adapter (0): NVIDIA GeForce 210 
Installed video RAM: 1024 MB
Current video mode: 1920 x 1080 x 4294967296 colors
Used bit depth: 32
Driver version: 8.17.13.142
Installed display drivers: nvd3dumx.dll,nvwgf2umx.dll,nvwgf2umx.dll,nvd3dum,nvwgf2um,nvwgf2um
Current user language: Greek (Greece)

How to repeat:
I failed to reproduce the bug with exact steps but it definitely happens. I was working with 2 tables and it happened more than 3 times crashing the application. Sometimes the columns tab displays a ghost column automatically added. When I am trying to delete it, Workbench always crashes.

You can reproduce the bug as following: 

1. Create a table and add a couple of columns. 
2. Then head on to another tab (say, indexes). Do some cliks there.
3. Go back to the columns tab. You will find yourself inside the name of a new column added mysteriously at the end of your column list. The new column is named <tablename>col. 
4. If you press ESC the column disapears but anything else will add this column to the table.

This modeling or with alive server?. Thanks.

Sorry I noticed is modeling.

Thank you for the bug report.

In 5.2.43 this bug does not exist. Each time you move between tabs, the garet is placed in an empty field/textbox, ready for the user to type something. In 5.2.44 the textbox is filled in advance with some automated text to help the user but this adds columns unless you press ESC just after you move to the columns tab.

Fixed as of the upcoming MySQL Workbench 5.2.45, and here's the changelog entry:

Modeling: Switching from a table column tab to a different tab, and then back 
to the column tab, would add an empty column named #tablename#col. This empty
column would be added to the table unless "Escape" was pressed.

Thank you for the bug report.