Bug #50740 Type field is blank after changing type from INT to FLOAT
Submitted: 29 Jan 2010 16:44 Modified: 5 May 2010 2:25
Reporter: Cluesome McClue Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Workbench: Modeling Severity:S3 (Non-critical)
Version:5.2.15a beta OS:MacOS (10.6.2)
Assigned to: Mike Lischke CPU Architecture:Any
Tags: decimal, disappear, FLOAT, modelling, type

[29 Jan 2010 16:44] Cluesome McClue
Description:
1. what I did:

I created a table with a FLOAT field. I changed the type of the field to VARCHAR(). 

2. what I expected to happen:

the field would have the VARCHAR() type

3. what happened:

The field was blank.

How to repeat:
1. In the Data Modelling section of Workbench open an existing EER model.
2. In the MySQL Model tab expand the Physical Schemata section.
3. Double click the Add Table icon.
4. In the Columns tab of the table editor double click under Column, type 'id' and press the return key.
5. Double click under 'id' and type 'name' and press the return key.
6. Use the mouse to select the INT datatype for 'name'.
7. Use the mouse to select the VARCHAR() datatype for 'name'.
7. The field is blank.

Suggested fix:
Workaround:

Select the field again and the type shows.
[29 Jan 2010 16:56] Valeriy Kravchuk
Please, upload some .mwb file to demonstrate the problem. Was it created by some previous version, 5.0.x or 5.1.x?
[2 Feb 2010 19:55] Cluesome McClue
I have been unable to recreate this bug. My model has moved on since I reported it and somehow it seems that the behaviour is no longer present.
I will come back to you when/if I see it again.
[3 Feb 2010 11:41] Johannes Taxacher
not able to repeat on osx, though i can repeat a behavior like this on windows like this:
- create a new table
- hit enter in the name-field to move to column tab automatically
- create first column with default values by just hitting enter twice
- now in the second (empty) row click directly into the dropdown (_not_ the name field!) and select VARCHAR() from the dropdownlist.
(notice, a default name for the column is generated, but theres no diamond icon next to the name)
- now hit enter in the column-type-field without filling a field-length between the brackets
now the diamond icon appears in front of the automatically generated column name but datatype is empty
[12 Feb 2010 19:04] Cluesome McClue
I have seen this behaviour again and have managed to cut my model down to one table with two attributes that demos the problem. The table was created in either 5.2.10, 5.2.11 or 5.2.14, sorry I can't remember exactly which.

Please reference the attached file and follow the instructions carefully:

1. save the file to a Mac running OS X 10.6.2,
2. using the mouse, double click on the saved file to open it in MySQL Workbench 5.2.15 beta revision 5053
3. using the mouse, select the EER Diagram tab to display the table called 'nutrition'
4. using the mouse, double click the nutrition table to open the table editor
5. using the mouse, select the Columns tab to display the table's column definitions. You will see that the column called 'energykJ' currently has datatype VARCHAR(8) selected
6. using the mouse, drop down the Datatype Menu for the 'energykJ' column and from the menu select the type DECIMAL()
7. The Datatype has disappeared.

Best.
[12 Feb 2010 19:06] Cluesome McClue
this shows the problem if the instructions given in my post of 12 Feb 20:04 are followed precisely.

Attachment: datatype cutdown.mwb (application/octet-stream, text), 9.65 KiB.

[4 May 2010 18:12] Alfredo Kojima
Works in osx 10.5, apparently 10.6 specific
[5 May 2010 2:25] Alfredo Kojima
Actually I can repeat this in 5.2.20 but not in current repository. It was a duplicate of bug #52578