Missing boolean/bit data type about wwwsqldesigner HOT 4 CLOSED

From ondrej.zara on November 22, 2009 03:34:21

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

from wwwsqldesigner.

From [email protected] on December 26, 2009 14:37:25

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

from wwwsqldesigner.

From [email protected] on December 27, 2009 12:01:08

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 ;)

Attachment: mysql_add_bit.patch

from wwwsqldesigner.

From ondrej.zara on January 03, 2010 11:21:21

Fixed in r73 , thanks!

Status: Fixed

from wwwsqldesigner.