MySQL Bugs: #55620: data type will get blank and ignored

Bug #55620	data type will get blank and ignored
Submitted:	29 Jul 2010 4:05	Modified:	11 Nov 2010 15:22
Reporter:	Susanne Ebrecht	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Workbench: SQL Editor	Severity:	S3 (Non-critical)
Version:	5.2.25 SE	OS:	Any
Assigned to:	Alfredo Kojima	CPU Architecture:	Any

Description:
1. Open connection to start querying
2. Select a schema
3. Right click on "Tables"
4. Create Table ...
5. goto tab columns
6. column i integer pk nn => enter
=> you will see that the data type will get blank ... you can't change data type here
7. column col integer => enter
=> same as with first column ... data type is disappearing
8. Press Apply
9. Look at the SQL .. you will see that data type is missing
10. Press Apply SQL Script
=> ERROR 1064: You have an error in your SQL syntax; ...

How to repeat:
See above or watch my movie

Suggested fix:
data type fields should not get blank after finishing creating the column

movie to show the behaviour

Attachment: datatype.ogv (video/ogg, text), 408.52 KiB.

this actually applies to all platforms (changed the OS setting in report accordingly) and happens if the default datatype for the PK column is set to some synonym type like 'INTEGER' instead of 'INT' (default setting for a fresh install of WB is 'INT').

as workaround, set your default PK datatype to 'INT' in preferences.

now synonym datatypes are not listed/pre-filled in SQL-Editors table editors.
fix confirmed in repository

An entry has been added to the 5.2.30 changelog:

In the Create Table dialog of the SQL Editor, if a new column was created with a synonym data type such as INTEGER, then the datatype would appear blank, both in the interface and in the generated SQL. This resulted in an error when clicking the Apply SQL button.