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:
Category:MySQL Workbench: SQL Editor Severity:S3 (Non-critical)
Version:5.2.25 SE OS:Any
Assigned to: Alfredo Kojima CPU Architecture:Any

[29 Jul 2010 4:05] Susanne Ebrecht
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
[29 Jul 2010 4:05] Susanne Ebrecht
movie to show the behaviour

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

[29 Jul 2010 10:21] Johannes Taxacher
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.
[9 Nov 2010 10:44] Johannes Taxacher
now synonym datatypes are not listed/pre-filled in SQL-Editors table editors.
fix confirmed in repository
[11 Nov 2010 15:22] Tony Bedford
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.