| Bug #48119 | Unable to input FK details | ||
|---|---|---|---|
| Submitted: | 16 Oct 2009 15:07 | Modified: | 10 Nov 2009 11:47 |
| Reporter: | Carl Downing | Email Updates: | |
| Status: | Not a Bug | Impact on me: | |
| Category: | MySQL Workbench | Severity: | S3 (Non-critical) |
| Version: | 5.2.4 | OS: | MacOS (10.6.1) |
| Assigned to: | CPU Architecture: | Any | |
[28 Oct 2009 21:01]
Johannes Taxacher
hi carl, in the document supplied you have set slightly different datatypes and WB refuses to wire columns whose datatypes dont match exactly. Of course, we need to improve user feedback on that point, thats already on our list.
[10 Nov 2009 11:48]
Susanne Ebrecht
Many thanks for writing a bug report. Unfortunately, this is not a bug. The columns you link always should have same data type.
Description: I have found my model to be in a weird state where, on certain tables, when I attempt to create a FK, I am able to create and name the FK, and update the Referenced Table, but when I try to set the column info, the values are immediately cleared. The FK is saved, however, and will output code such as: CONSTRAINT `user_access_tb_fk` FOREIGN KEY () REFERENCES `test`.`user_role_tb` () How to repeat: Quite frankly, no idea how I managed to get my file into this state. I will attach the MWB file.