Bug #52842 I get a bug notice when I change the FK of a relationship.

• Submitted: 15 Apr 2010 0:16
• Modified: 18 Apr 2010 17:37
• Reporter: Steven Berkson
• Status: Can't repeat
• Category: MySQL Workbench
• Severity: S3 (Non-critical)
• Version: 5.2.18 5625
• OS: Windows (Vista Ultimate x64)
• CPU Architecture: Any
• Tags: foreign keys

[15 Apr 2010 0:16] Steven Berkson

Description:
I have already defined tables. When I use the GUI in EER Diagram to define a table relationship, it creates a new key (suggest it asks each time if one exists or for the name to create).

When I edit the table, I go to each FK that was generated, click on the referenced table, and change the key to the one I already had. It asks me for the referenced column which I set as the same as the generated key.

It pops up the bug report at that point. I close the bug report, uncheck the generated key. go to columns and delete the generated key. No apparent problems.

How to repeat:
See above.

Suggested fix:
Ask each time I define a relationship for the existing key or the name for a new key column.

[15 Apr 2010 5:21] Sveta Smirnova

I assume you are using MySQL Workbench, so changing category accordingly.

[15 Apr 2010 6:01] Steven Berkson

I was transported by a bug report for the program, so I assumed it was all workbench (e.g.
General issue with Workbench). Sorry. I will take note of it in the future.

[16 Apr 2010 14:01] MySQL Verification Team

Could you please provide a model file project which presents the issue reported?. Thanks in advance.

[16 Apr 2010 14:08] Steven Berkson

Can you get the file from report #52843. Same file.

[18 Apr 2010 17:37] MySQL Verification Team

Thank you for the feedback. I couldn't repeat with version 5.2.19 please try this version. Thanks in advance.