Bug #35200 Validator fails on orphaned foreign key

• Submitted: 10 Mar 2008 23:47
• Modified: 17 Apr 2008 15:57
• Reporter: Xavier Irias
• Status: No Feedback
• Category: MySQL Workbench
• Severity: S3 (Non-critical)
• Version: 5.0.14 SE
• OS: Windows (xp sp2)
• Assigned to: Assigned Account
• CPU Architecture: Any
• Tags: validator foreign key

[10 Mar 2008 23:47] Xavier Irias

Description:
I deleted a relationship while in the diagram view.  This apparently left the foreign key "orphaned" -- it showed in the table editor as a foreign key but with no line in the diagram.

Then, when I ran the validator, the validator failed saying it could not load its plugin.  I guessed as to the cause and manually deleted the orphaned column.  The validator was then able to run normally.

How to repeat:
Create a diagram with logical errors as noted.  Then run the validator.

Suggested fix:
unknown.

[11 Mar 2008 5:06] Valeriy Kravchuk

Thank you for a problem report. Had you answered "Yes" in the dialog box asking for column(s) delete confirmation?

[11 Mar 2008 14:39] Xavier Irias

Yes, I had answered Yes to delete the foreign key column.  In fact the reason I was running the Validator is that I was concerned the file might be corrupted after the error I got with the relationship delete.

[17 Mar 2008 15:57] Valeriy Kravchuk

Please, try to repeat with a newer version, 5.0.15-rc, and inform about the results.

[17 Apr 2008 23:00] Bugs System

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".