MySQL Bugs: #58964: Bug #55399 not able to create foreign key relationships STILL PRESENT

Bug #58964	Bug #55399 not able to create foreign key relationships STILL PRESENT
Submitted:	16 Dec 2010 6:30	Modified:	17 Jan 2011 9:48
Reporter:	Joel Ramírez Butrón	Email Updates:
Status:	No Feedback	Impact on me:	None
Category:	MySQL Workbench: Modeling	Severity:	S2 (Serious)
Version:	5.2.31CE Revision 7115	OS:	Windows (Windows 7 UE)
Assigned to:		CPU Architecture:	Any
Tags:	bug, Bug #55399, export, fk, foreign keys, forward engineer

Description:
Bug #55399 not able to create foreign key relationships

Bug is STILL PRESENT, and does not allow to create forward engineering correctly. 

How to repeat:
Create a table and a 1:n non identifying relationship with other table. Try to forward engineer that DB and it will create only de Tables but not any relationship between them.

Please, upload .mwb file to demonstrate this problem.

I tried to forward engineer your .mwb file uploaded, and I see foreign keys defined in SQL statements generated, like this:

-- -----------------------------------------------------
-- Table `db_municipalidad_ilo_mp`.`T_FasePro`
-- -----------------------------------------------------
CREATE  TABLE IF NOT EXISTS `db_municipalidad_ilo_mp`.`T_FasePro` (
  `codigoFasePro` INT NOT NULL ,
  `T_Proceso_codigoProc` INT(11) NOT NULL ,
  PRIMARY KEY (`codigoFasePro`, `T_Proceso_codigoProc`) ,
  INDEX `fk_T_FasePro_T_Proceso1` (`T_Proceso_codigoProc` ASC) ,
  CONSTRAINT `fk_T_FasePro_T_Proceso1`
    FOREIGN KEY (`T_Proceso_codigoProc` )
    REFERENCES `db_municipalidad_ilo_mp`.`T_Proceso` (`codigoProc` )
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB;

So, I wonder, what exactly the problem is?

Certainly, I have tried it in the latest version of mySQL 5.2.31 and in the 5.2.10, and none of them can do the export properly. Anyway, either the file is corrupted, or mySQL WB still persists with this bug. There is a much high probability that the file is corrupted, though. However, I think maybe developers can have a look on this in a more profound way.

CONFIRMED, .mwb file is some way corrupted. This file should be examinated properly by developers since some kind of relationship is shown with the forward engineering feature.

I don't understand, I can create foreign keys and forward engineering the uploaded model generates foreign keys. Can you detail exactly what you are expecting to happens, what you do to accomplish that and what you are getting instead of the expected result?

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".