Bug #52578 Cannot edit table columns
Submitted: 4 Apr 2010 0:12 Modified: 11 Jun 2010 12:48
Reporter: Cluesome McClue Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench: Modeling Severity:S1 (Critical)
Version:5.2.22 OS:MacOS (10.6.2, 10.5.x)
Assigned to: Mike Lischke CPU Architecture:Any
Tags: regression

[4 Apr 2010 0:12] Cluesome McClue
Description:
What I did:
I started WB and it opened and loaded my current EER Diagram for editing, which I then closed.
On the home/front page I selected the Create a new EER Diagram option from the Data Modelling options.
In the MySQL Model tab I double clicked the Add Diagram icon.
In the EER Diagram tab I typed T for the new table tool and clicked to create one.
I double clicked on the new table created to open the attributes editor.
In the editor tab I double clicked in the Name field and typed 'person' to replace the default 'table1' text and pressed the return key.

What I expected to happen:
The table and the main (top) editor tab would show the new name 'person'; the lower Table tab would remain selected.

What actually happened:
The table in the diagram showed the new name 'person'. The editor changed to the lower Columns tab with a default column already inserted showing the default primary key I have set in Preferences. The checkboxes for PK, NN, UQ, etc. are not selectable, i.e. the PK is not set although it is supposedly the default and cannot be set. No further columns can be created with the mouse.
If I change the type of the primary key column it sometimes lets me then create another column but the behaviour is confused and typed names are lost.

How to repeat:
Follow the instructions under 'What I did' above.

Suggested fix:
None. I cannot continue development of my model until this is fixed. I may go back to 5.2.16, assuming its possible since I saved my work in 5.2.17.
[4 Apr 2010 8:54] Valeriy Kravchuk
Thank for the regression bug report. Verified just as described.
[20 Apr 2010 16:22] Johannes Taxacher
as workaround, change the default-PK-name and hit enter. this way the column-entry is created properly (indicated by the icon to the left of the column name)
[21 Apr 2010 15:00] Alfredo Kojima
I can repeat it in 5.2.17, but cannot in current release, neither in 5.2.18
[23 Apr 2010 12:58] Mike Lischke
Fixed in repository
[5 May 2010 2:25] Alfredo Kojima
Marked bug #50740 as duplicate
[7 Jun 2010 13:59] Mike Lischke
Now really fixed in repository.
[7 Jun 2010 16:07] Johannes Taxacher
fix confirmed in repository
[11 Jun 2010 12:48] Tony Bedford
An entry has been added to the 5.2.23 changelog:

After a default primary key name was set in the Workbench Preferences dialog, in the Table Editor the PK flag was not selected as expected, and the column flags could not be selected.