MySQL Bugs: #9782: SQL datatype BOOL and BOOLEAN not recognized by Query Browser

Bug #9782	SQL datatype BOOL and BOOLEAN not recognized by Query Browser
Submitted:	9 Apr 2005 11:23	Modified:	22 Sep 2005 13:49
Reporter:	Paul van Rossem	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Query Browser	Severity:	S3 (Non-critical)
Version:	1.1.6	OS:	Windows (Windows)
Assigned to:	Mike Lischke	CPU Architecture:	Any

Description:
The predefined datatypes BOOL and BOOLEAN are not recognized by the query browser.

How to repeat:
Start Query Browser. Select any schema. Right click and select create new table. Enter any valid table name. Click column name and enter any valid name. Enter Data type BOOL or BOOLEAN. The icon changes to a user-defined datatype, which is wrong. Click column details tab and remove "primary key" check. Enter default value 0 or FALSE. Click Apply Changes and then EXECUTE. This results in SQL errornumber 1064. 

Suggested fix:
Make Query browser recognize BOOL / BOOLEAN data type and make it accept   FALSE and TRUE (and 0 and 1) as valid defaults.

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