Bug #47969 Forward Eng SQL CREATE Script ignores Skip Creation of FOREIGN KEYS

Submitted: 10 Oct 2009 15:32 Modified: 9 Feb 2010 16:59
Reporter: Carl Downing Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench: Modeling Severity:S3 (Non-critical)
Version:5.2.4 OS:Any
Assigned to: Alexander Musienko CPU Architecture:Any

[10 Oct 2009 15:32] Carl Downing
Description:
Selecting "Skip Creation of FOREIGN KEYS" while exporting create script seems to have no impact on the output.  Here is SQL generated with "Skip Creation" selected:

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

CREATE  TABLE IF NOT EXISTS `testdb`.`tdb_keyword_tb` (
  `id` INT NOT NULL ,
  `test_id` INT NULL ,
  `keyword` VARCHAR(45) NULL ,
  PRIMARY KEY (`id`) ,
  INDEX `bdb_test_id_fk` (`test_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;

How to repeat:
Create two tables with appropriate FK, export Forward Engineer SQL CREATE Script, select "Skip Creation of FOREIGN KEYS"
[8 Feb 2010 18:03] Johannes Taxacher
fixed in repository
[9 Feb 2010 16:59] Tony Bedford
An entry has been added to the 5.2.16 changelog:

In the Forward Engineer SQL Script wizard, selection of the Skip Creation of FOREIGN KEYS checkbox was not reflected in the generated script.

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.041 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.