Bug #11881 BOOL and BOOLEAN col types to be synonyms of BIT(1) not TINYINT(1)
Submitted: 12 Jul 2005 11:58 Modified: 5 Dec 2008 18:27
Reporter: James Harvard Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server Severity:S4 (Feature request)
Version:5 OS:Any
Assigned to: CPU Architecture:Any

[12 Jul 2005 11:58] James Harvard 
Description:
Currently BOOL and BOOLEAN in a CREATE TABLE statement are synonyms for TINYINT(1).

Now that the BIT column type has been implemented (versions >= 5.0.5) would it not make sense to change BOOL and BOOLEAN to being synonyms for BIT(1)?

How to repeat:
n/a
[7 Nov 2006 5:02] Siu Ching Pong (Asuka Kenji) 
In "http://dev.mysql.com/doc/refman/5.1/en/numeric-type-overview.htm", it says:

BOOL, BOOLEAN
-------------
These types are synonyms for TINYINT(1). A value of zero is considered false. Non-zero values are considered true.

/* Examples skipped */

We intend to implement full boolean type handling, in accordance with standard SQL, in a future MySQL release.

I think they will implement this feature after 5.1 ...
[5 Dec 2008 18:27] Valeriy Kravchuk 
I'd consider this a duplicate of Bug #24531 and/or Bug #41257.