Bug #43786 validation should catch empty tables
Submitted: 22 Mar 2009 10:11 Modified: 20 Aug 2010 10:56
Reporter: Peter Laursen (Basic Quality Contributor) Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench: Modeling Severity:S3 (Non-critical)
Version:5.1.9 OS:Windows
Assigned to: Maksym Yehorov CPU Architecture:Any
Tags: qc

[22 Mar 2009 10:11] Peter Laursen 
Description:
Start new model
Add a table object to canvas - *do not* define any columns in that table
Database >> forward engineer >> validation returns 'validation finishd succesfully'

.. but executing the script fails with syntax error of course as a table needs at least one column to be valid.

How to repeat:
SQL generated is 

-- -----------------------------------------------------
-- Table `mydb`.`table1`
-- -----------------------------------------------------

CREATE  TABLE IF NOT EXISTS `mydb`.`table1` (
)
ENGINE = InnoDB;

Suggested fix:
Validation should catch it.
[22 Mar 2009 13:25] Peter Laursen 
correcting version. 5.1.8 was wrong - correct is 5.1.9
[22 Mar 2009 15:06] MySQL Verification Team 
Thank you for the bug report.
[29 Jun 2010 19:32] Maksym Yehorov 
Fixed.
[20 Aug 2010 10:56] Johannes Taxacher 
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/