Bug #47881 Forward Engineer SQL CREATE Script generates code missing parentheses

• Submitted: 7 Oct 2009 0:17
• Modified: 7 Oct 2009 3:30
• Reporter: Carl Downing
• Status: Duplicate
• Category: MySQL Workbench
• Severity: S3 (Non-critical)
• Version: 5.2.3
• OS: MacOS (10.6.1)
• CPU Architecture: Any

[7 Oct 2009 0:17] Carl Downing

Description:
When exporting, this is the code that is generated:

-- -----------------------------------------------------
-- Table `testdb`.`bdb_test_tb`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `testdb`.`bdb_test_tb` ;

CREATE  TABLE IF NOT EXISTS `brandloc`.`bdb_test_tb` (
      `id` INT NOT NULL ,
      `test_id` INT NULL ,
      `keyword` VARCHAR(45) NULL ,
      PRIMARY KEY (`id`) ,
      INDEX `bdb_test_id_fk` (`brand_id` ASC) ,
      CONSTRAINT `bdb_test_id_fk`
        FOREIGN KEY (`test_id` )
        REFERENCES `testdb`.`bdb_test_tb` (`id` )
        ON DELETE NO ACTION
        ON UPDATE NO ACTION
ENGINE = InnoDB;

The above code is missing a closing parentheses before the ENGINE = InnoDB bit

How to repeat:
Create a new diagram, put some tables in there that are not the default engine, and export using Forward Engineer SQL CREATE Script

[7 Oct 2009 3:30] Valeriy Kravchuk

This is a duplicate of bug #47407.