Bug #33603 Table comment generates incorrect SQL
Submitted: 31 Dec 2007 18:05 Modified: 2 Jan 2008 17:39
Reporter: Daniel Thonon Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench Severity:S1 (Critical)
Version:5.0.11 SE Beta OS:Windows
Assigned to: Johannes Taxacher CPU Architecture:Any

[31 Dec 2007 18:05] Daniel Thonon
Description:
The SQL generated to create a table with a comment is incorrect: the ending ' is missing in the COMMENT statement. See below for the error log.

Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')
COMMENT = 'Comment;

SET SQL_MODE=@OLD_SQL_MODE;
SET FOREIGN_KEY_CHECKS=@OLD' at line 5

-- -----------------------------------------------------
-- Table `mydb`.`table1`
-- -----------------------------------------------------
CREATE  TABLE IF NOT EXISTS `mydb`.`table1` (
)
COMMENT = 'Comment;

SET SQL_MODE=@OLD_SQL_MODE;
SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;

SQL script execution finished: statements: 5 succeeded, 1 failed

How to repeat:
Create a table
Add a comment
Forward engineer
[2 Jan 2008 17:39] Johannes Taxacher
fixed in SVN Rev 2364