Bug #47446 Export syntax error

• Submitted: 19 Sep 2009 0:48
• Modified: 19 Sep 2009 7:13
• Reporter: will farrell
• Status: Duplicate
• Category: MySQL Workbench
• Severity: S3 (Non-critical)
• Version: 5.2.3 Alpha
• OS: MacOS (Snow Lepard)
• CPU Architecture: Any

[19 Sep 2009 0:48] will farrell

Description:
When you go File -> Export -> Forward SQL CREATE Script ...
Click Continue, Continue.

Viewing the generated script you can see that a ")" is missing before "ENGINE = MyISAM". Example output found below.

CREATE TABLE IF NOT EXISTS `rfqsbeta`.`geo_cities` (
`city_ID` INT NOT NULL AUTO_INCREMENT ,
`city_name` TEXT NOT NULL ,
PRIMARY KEY (`city_ID`) 
ENGINE = MyISAM;

How to repeat:
Add a table

Go File -> Export -> Forward SQL CREATE Script ...
Click Continue, Continue.

Suggested fix:
I would assume it's an easy fix.

[19 Sep 2009 7:13] Valeriy Kravchuk

This is a duplicate of Bug #47407.