Bug #49538 Model Validation flags Boolean as invalid
Submitted: 8 Dec 2009 16:55 Modified: 29 Jun 2010 12:43
Reporter: Mark Grabowski Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench: Modeling Severity:S3 (Non-critical)
Version:5.1.18 SE OS:Windows
Assigned to: Maksym Yehorov CPU Architecture:Any
Tags: bit, boolean, Validation

[8 Dec 2009 16:55] Mark Grabowski 
Description:
Seems to me that when creating tables and BOOLEAN is a listed choice in the drop-down for a column data type, that this alias to BIT should not be flagged as having "no valid type defined" when doing the model validation.

How to repeat:
create a table, create a column and choose datatype of boolean.
choose model | validation | Validate ALL

Suggested fix:
Either allow BOOLEAN to be valid in validation, or do not offer it as a drop down choice in datatypes.
[9 Dec 2009 14:41] MySQL Verification Team 
Thank you for the bug report.
[23 Jun 2010 18:43] Maksym Yehorov 
Fixed.
[24 Jun 2010 7:50] Mike Lischke 
Fix confirmed in repository.
[29 Jun 2010 12:43] Tony Bedford 
An entry has been added to the 5.2.25 changelog:

When creating a table containing columns with a BOOLEAN data type, the model then failed to validate, even though BOOLEAN is a type offered on the drop down list of types available for columns.