Bug #14740 Self relation
Submitted: 8 Nov 2005 11:27 Modified: 12 Apr 2006 8:15
Reporter: Jochem Blok Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench Preview Severity:S3 (Non-critical)
Version:1.0.2 alpha OS:Windows (Windows XP SP2)
Assigned to: Mike Lischke CPU Architecture:Any

[8 Nov 2005 11:27] Jochem Blok 
Description:
When reverse enginering a database which has a self relation (parent/child in the same table) the relation arrow isn't drawn properly. It dissapears outside the grid.

How to repeat:
CREATE TABLE `organisation` (
  `id` int(11) NOT NULL default '0',
  `parent` int(11) default NULL,
  `name` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`),
  KEY `parent` (`parent`,`organisationtype_id`),
) ENGINE=InnoDB

ALTER TABLE `organisation`
  ADD CONSTRAINT `organisation_ibfk_1` FOREIGN KEY (`parent`) REFERENCES `organisation` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

Suggested fix:
A arrow which is drawn to the same table.
[17 Nov 2005 9:19] Vasily Kishkin 
Thanks for bug report. I was able to reproduce the bug. A screen copy of the bug is attached.
[17 Nov 2005 9:19] Vasily Kishkin 
screen copy

Attachment: 14740.GIF (image/gif, text), 87.58 KiB.
[12 Apr 2006 8:15] Mike Lischke 
Thank you for your bug report. This issue has already been fixed
in the latest released version of that product, which you can download at 
http://www.mysql.com/downloads/