Bug #47898 Forward Engineer SQL Create Script creates wrong SQL

• Submitted: 7 Oct 2009 15:46
• Modified: 8 Oct 2009 9:44
• Reporter: Vincent Courcelle
• Status: Duplicate
• Category: MySQL Workbench
• Severity: S1 (Critical)
• Version: 5.2.3 OSS Alpha
• OS: Any
• CPU Architecture: Any

[7 Oct 2009 15:46] Vincent Courcelle

Description:
Export to Forward Engineer SQL Create Script creates wrong SQL, for example I've, for every table:

CREATE  TABLE IF NOT EXISTS `DB`.`A` (
                                                                                                  `A` VARCHAR(5) NOT NULL ,
                                                                               
                                                                                                  PRIMARY KEY (`A`) ,
                                                                                                  INDEX `A` (`A` ASC) 
ENGINE = InnoDB;

(there is a missing ")" right before "ENGINE = InnoDB").

I also have some lines like this:
DELIMITER //
//
USE DB//
DB//
CREATE PROCEDURE AAA()

(line "DB//" is invalid)

How to repeat:
Create a new schema, add tables and procedures in it, and try to import the result to MySQL...

It fails for EVERY table.

[8 Oct 2009 9:44] Johannes Taxacher

this is a duplicate of #47407