Bug #44130 Omit schemata qualifiers flag works incorrectly
Submitted: 7 Apr 2009 9:36 Modified: 7 Apr 2009 12:14
Reporter: Michael Skulsky Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Workbench Severity:S2 (Serious)
Version:5.0.30 OS:Any
Assigned to: CPU Architecture:Any

[7 Apr 2009 9:36] Michael Skulsky 
Description:
Forward engineer to SQL with flag "Omit schemata qualifiers" does not remove database name from REFERENCES clause. For example:

CREATE  TABLE IF NOT EXISTS `oam_sessions` (
  `session_id` INT NOT NULL AUTO_INCREMENT ,
  `user_id` INT UNSIGNED NOT NULL ,
  `ip_address` VARCHAR(40) NOT NULL ,
  `login_time` DATETIME NOT NULL ,
  `logout_time` DATETIME NULL ,
  `last_activity` DATETIME NULL ,
  `hash` VARCHAR(40) NOT NULL ,
  `user_agent` VARCHAR(255) NOT NULL ,
  PRIMARY KEY (`session_id`) ,
  INDEX `fk_oamsessions_synusers` (`user_id` ASC) ,
  CONSTRAINT `fk_oamsessions_synusers`
    FOREIGN KEY (`user_id` )
    REFERENCES `syndb`.`syn_users` (`user_id` )
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB

How to repeat:
See above

Suggested fix:
The output should not contain database name anywhere
[7 Apr 2009 9:50] Valeriy Kravchuk 
Thank you for the bug report.
[7 Apr 2009 12:14] Axel Schwenke 
duplicate of bug #42328