MySQL Bugs: #53710: Datatype doesn't autofill when lowercase entered

Bug #53710	Datatype doesn't autofill when lowercase entered
Submitted:	17 May 2010 15:53	Modified:	26 May 2010 11:01
Reporter:	Justin Noel	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Workbench: Modeling	Severity:	S3 (Non-critical)
Version:	5.2.21	OS:	MacOS
Assigned to:	Alfredo Kojima	CPU Architecture:	Any
Tags:	workbench datatype diagram modeling

Description:
When creating a table via the EER Diagram, the datatype field will not autofill when typing in lowercase.  When typing in uppercase, the datatype field will automatically start filling the datatype with types that matched the entered letters.

How to repeat:
Create new EER diagram. 
Add a new table.
Double click the table to open the editor.
Click on the "Columns" tab.
In the column field, enter a name for the column.
Ensure CAPS Lock is NOT on.
Tab to the "Datatype" field.  
In lower case, start typing a valid datatype (ex. timestamp).  
Note that the datatype does NOT automatically start filling in with valid datatypes that begin with the first few letters typed.
Press the Caps Lock key.  Start typing TIMESTAMP in the dataype field.
Note that the datatype automatically fills in for any valid datatypes that match the characters being type.

Suggested fix:
Make the datatype field automatically enter matching datatypes even when lowercase letters are typed.

Thank you for the problem report. Verified just as described.

This was a feature request, but is now implemented

fix confirmed in repository

An entry has been added to the 5.2.22 changelog:

In the Columns tab of the Table Editor, if typing in lower case the data type of the column was not automatically completed.

MySQL Workbench has been changed so that it now automatically completes the data type regardless of whether the user types upper or lower case letters.