MySQL Bugs: #34802: Foreign key redraw issue

Bug #34802	Foreign key redraw issue
Submitted:	25 Feb 2008 10:47	Modified:	26 Feb 2009 19:01
Reporter:	Māris Vilks	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Workbench	Severity:	S3 (Non-critical)
Version:	5.0.13, 5.0.14, 5.0.29	OS:	Windows
Assigned to:		CPU Architecture:	Any

Description:
When removing primary key flag (by double clicking on "key" icon in front of column name) from column referencing other table, ERR diagram does not redraw column icon from key to red dot. It does after restarting Workbench.

How to repeat:
1. Place 1:n identifying relationship from one table to another
2. Double click table with referencing column to edit
3. In column list double click "key" sign in front of referencing column to remove it from primary key and turn it to red dot
4. ERR Diagram should redraw table showing red dot in fron of edited column

Thank you for the bug report.

Hello Māris,

could you please verify this issue with our latest release (5.0.14a) - this should have been fixed since 5.0.13.

thx

Partly.

Changing [for existing column] "red dot" to "key" symbol does redraw, but "key" to "red dot" does not. New columns created with "key" symbol also do not update to "red dot".

The bug with removing referencing column from PRIMARY KEY is still present in 5.0.14.

I can still reproduce this issue with 5.0.15-rc1

its related to this bug but an addition as we've added new column indicator for NULL/NOT NULL

once you manually add a FK column to PK and remove it the column icons aren't correctly restored. t even messes p the column indicators in table editor

Please try version 5.0.30

Seems to be fixed in 5.0.30 OSS (don't know about SE, don't have one). Column icons redraw nicely.

Closed as fixed in 5.0.30.