MySQL Bugs: #60813: Old relationships stored in model

Bug #60813	Old relationships stored in model
Submitted:	9 Apr 2011 6:45	Modified:	29 Jun 2011 15:37
Reporter:	Roman Yazemov	Email Updates:
Status:	Not a Bug	Impact on me:	None
Category:	MySQL Workbench: Modeling	Severity:	S3 (Non-critical)
Version:	5.2.33 rev. 7508	OS:	Any (XP SP3, Mac OS X)
Assigned to:		CPU Architecture:	Any
Tags:	relationship

Description:
The relationships are somehow stored in a model even after one of the referenced tables is removed: the relationship is NOT displayed as a line, but it IS displayed on table hover in "Referenced by" section.

It isn't a problem at a first glance, still this may be a sign of some more severe problem.

I thought it might be a feature to restore relationship after table recreation, but it doesn't seem to function like that.

How to repeat:
1. Create table1.
2. Create table2.
3. Create a relationship.
4. Remove one of tables _keeping_ the corresponding objects.
5. Now hover the table remained and you should see a reference to a table removed.
6. Recreate table removed with the same name. Now you should still get a reference tip on a hover, but a relationship won't restore visually.

Suggested fix:
Don't know. There's a relationship, but there's no relationship. :)

here's a model itself

Attachment: tablesNoHover.png (image/x-png, text), 12.42 KiB.

here's a tip

Attachment: tablesHover.png (image/x-png, text), 14.67 KiB.

Don't know if there's a way to remove this relationships from a model. :(

After removing all tables named 'table2' from 'physical schemata' and added a new one

Attachment: tablesHover2.png (image/x-png, text), 12.59 KiB.

Thank you for the bug report. Verified on Mac OS X also.

Deleting a table figure while keeping the object, will do just that. The removed table will continue to exist in the model even if you don't see it in the diagram. You will still be able to see it in the Catalog tree or in the Physical Schemata list.

Unless I misunderstood something, this is not a bug.

Alfredo, my last picture concerns a removal from a physical schemata.

Thank you for taking the time to write to us, but this is not a bug. Please double-check the documentation available at http://dev.mysql.com/doc/ and the instructions on
how to report a bug at http://bugs.mysql.com/how-to-report.php