MySQL Bugs: #15833: Need case insensitive match in 'data type' field in table editor

Bug #15833	Need case insensitive match in 'data type' field in table editor
Submitted:	17 Dec 2005 22:57	Modified:	2 May 2006 15:44
Reporter:	Daniel Kasak (Candidate Quality Contributor)	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Administrator	Severity:	S3 (Non-critical)
Version:	1.1.5	OS:	Linux (Linux)
Assigned to:	Alfredo Kojima	CPU Architecture:	Any

Description:
In the table editor, the 'data type' field *used* to do a case-insensitive match on entries, and then use this match to fill in the list of options in the 'flags' list in column details.

Now the match is case sensitive, and I have to type the data type in UPPER CASE. I HATE upper case :)

How to repeat:
In the table editor, add a new field, of type smallint. Move the focus out of the field's row, then back in, and note that the 'flags' list is not populated.

Now edit the data type to read SMALLINT, and move the focus out / in of the field's row. Note that the 'flags' list is now populated with relevent options ( unsigned, zerofill ).

Suggested fix:
Revert match to case-insensitive.

Thank you for a problem report. Sorry, but I was not able to repeat the problem you describe on Windows XP with 1.1.5. If I simply edit a new row in the list of columns of "Columns and Indices" tab, then smallint is uppercased automatically. If I use "Column Details" tab below, I can type "smallint" and case remains, but flags are all available.

So, please, try to describe all the steps to repeat the problem in more details.

I think the instructions above pretty much sum things up.
How about a picture instead?
http://entropy.homelinux.org/MySQL/mysql-administrator_case_sensitive.jpg
You can see from the picture that I have typed 'smallint' as the data type, and it has NOT been forced to upper case. The screenshot was taken AFTER I clicked outside the 'SomeField' row. I actually clicked in the 'ID' row, and then back into the 'SomeField' row.

Note, most importantly, that the flags 'unsigned' and 'zerofill', which are valid options for a smallint column, are NOT available.

Screenshot from Linux that demonstrates the problem

Attachment: mysql-administrator_case_sensitive.jpg (image/jpeg, text), 80.01 KiB.

Linux-specific bug only. Not repeatable on Windows. See a screenshot uploaded.

Thank you for your bug report. This issue has been committed to our
source repository of that product and will be incorporated into the
next release.

If necessary, you can access the source repository and build the latest
available version, including the bugfix, yourself. More information 
about accessing the source trees is available at
    http://www.mysql.com/doc/en/Installing_source_tree.html