Bug #26695 "Unsigned" flag should not appear for BIT(1) field
Submitted: 27 Feb 2007 19:50 Modified: 15 Oct 2009 8:00
Reporter: Marc Hodgins (Candidate Quality Contributor) Email Updates:
Status: Won't fix Impact on me:
None 
Category:MySQL Administrator Severity:S3 (Non-critical)
Version:1.2.9 OS:Windows (Windows XP)
Assigned to: CPU Architecture:Any
Tags: CHECKED, qc

[27 Feb 2007 19:50] Marc Hodgins 
Description:
When changing datatype to BIT(1), the "UNSIGNED" flag (checkbox) appears.  Clicking that checkbox and then selecting "Apply Changes" causes Mysql Error Number 1064 (Sql Syntax error) for "UNSIGNED NOT NULL".

How to repeat:
Click Catalogs
Select a Schemata
Create/edit a table
Create/edit a column, set it to datatype BIT(1)
Check "UNSIGNED"
Click Apply

Suggested fix:
Do not display "UNSIGNED" flag for BIT fields
[27 Feb 2007 20:22] Valeriy Kravchuk 
Thank you for a bug report. Verified just as described.
[15 Oct 2009 8:00] Susanne Ebrecht 
Many thanks for writing a bug report. We are on the way to implement full functionality of MySQL Administrator into MySQL Workbench. We won't fix this anymore.

More informations about MySQL Workbench you will find here:

http://dev.mysql.com/workbench/