Bug #32535 Validating ignores table columns not having datatype.
Submitted: 20 Nov 2007 16:22 Modified: 28 Jan 2008 19:58
Reporter: marc castrovinci (Basic Quality Contributor) Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench Severity:S2 (Serious)
Version:5.09 SE/OSS BETA OS:Microsoft Windows (XP SP2)
Assigned to:
Tags: data, IGNORE, no datatype, qc, type, validate, validate mysql

[20 Nov 2007 16:22] marc castrovinci
Description:
Both types of validation (Validation MySQL and Validation) ignore that a column has no data type.

How to repeat:
1. Create a new table.
2. Add columns, by clicking column name (not tabbing to the next field)
   You should see column names with NO column Data types.
   Here is an image>> http://i2.tinypic.com/6s6y4is.jpg
3. Run Model>Validation>Validate All
4. Run Model>Validation (MySQL)>Validate All
   You should get no errors about the column not having a data type
   Screen shot>> http://i11.tinypic.com/6pf4rr8.jpg

As you can see nothing about the column not having a data type.

Suggested fix:
Throw an error, or like before after a column gets added automatically add a data type so this doesn't happen.
[21 Nov 2007 22:29] Miguel Solorzano
Thank you for the bug report.
[28 Jan 2008 19:58] Alfredo Kojima
Thank you for your bug report. This issue has already been fixed in the latest released version of that product, which you can download at

  http://www.mysql.com/downloads/