MySQL Bugs: #66201: Boolean data type is converted to tinyint when you export the data model to sql.

Bug #66201	Boolean data type is converted to tinyint when you export the data model to sql.
Submitted:	4 Aug 2012 17:57	Modified:	4 Aug 2012 18:32
Reporter:	Jeff Lee	Email Updates:
Status:	Not a Bug	Impact on me:	None
Category:	MySQL Workbench: Modeling	Severity:	S2 (Serious)
Version:	5.2.41	OS:	Windows (Microsoft Windows 7 Home Premium Edition (build 7600), 64-bit)
Assigned to:		CPU Architecture:	Any
Tags:	WBBugReporter

Description:
When I export my Data model to SQL, the boolean data type is changed to tinyint.

----- Developer Notes -----

MySQL Workbench CE for Windows version 5.2.41  revision 9727
Configuration Directory: C:\Users\jeff\AppData\Roaming\MySQL\Workbench
Data Directory: C:\Program Files (x86)\MySQL\MySQL Workbench 5.2 CE
Cairo Version: 1.8.8
OS: Microsoft Windows 7 Home Premium Edition (build 7600), 64-bit
CPU: 2x AMD Athlon(tm) II Dual-Core M300, 3.8 GiB RAM
Active video adapter (0): AMD M880G with ATI Mobility Radeon HD 4200  
Installed video RAM: 256 MB
Current video mode: 1366 x 768 x 4294967296 colors
Used bit depth: 32
Driver version: 8.632.0.0
Installed display drivers: atiumd64.dll,atidxx64.dll,atiumdag,atidxx32,atiumdva,atiumd6a.cap,atitmm64.dll
Current user language: English (United States)

How to repeat:
Create a table with with a column of boolean data type and export to sql.

That's probably because:

"BOOL, BOOLEAN

These types are synonyms for TINYINT(1). A value of zero is considered false. Nonzero values are considered true"

Read http://dev.mysql.com/doc/refman/5.5/en/integer-types.html or just look:

mysql> create table tboo(c1 boolean);
Query OK, 0 rows affected (0.34 sec)

mysql> show create table tboo\G
*************************** 1. row ***************************
       Table: tboo
Create Table: CREATE TABLE `tboo` (
  `c1` tinyint(1) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1
1 row in set (0.10 sec)