Missing boolean/bit data type

[GoogleCodeExporter]

The type drop down list doesn't contain a data type for boolean (aka bit) 
data types.

Original issue reported on code.google.com by atrop...@gmail.com on 22 Nov 2009 at 4:58

[GoogleCodeExporter]

For which DB? Can you please adjust the datatypes.xml and send me the patch?

Original comment by ondrej.zara on 22 Nov 2009 at 11:34

[GoogleCodeExporter]

atrophic: feel free to let me know what database it is, and I can make a patch 
if you can't.

Original comment by ober.14@osu.edu on 26 Dec 2009 at 10:37

[GoogleCodeExporter]

Part of this bug was me not reading directions.  I had changed the database I 
was 
designing against after I started the design, which did not work (as designed). 

However, after starting from scratch, MySQL was still missing the BIT data 
type, 
which was an alias for tinyint(1) prior to version 5.0.3, but is now an 
official data 
type (albeit with some confusing implementation).

I added it to the Miscellaneous section, where it is found in most other 
database 
engines' datatypes.xml.  Attached is my attempt at a patch.

kuba, thanks for reminding me about this ;)

Original comment by atrop...@gmail.com on 27 Dec 2009 at 8:01

Attachments:

• mysql_add_bit.patch

[GoogleCodeExporter]

Fixed in r73, thanks!

Original comment by ondrej.zara on 3 Jan 2010 at 7:21

• Changed state: Fixed