Bug #66226 Foreign Keys do not show up in object browser

Submitted: 6 Aug 2012 19:08 Modified: 7 Sep 2012 7:13
Reporter: Bob Dankert Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench: SQL Editor Severity:S3 (Non-critical)
Version:5.2.41 OS:Any (W7 32, Mac OS X)
Assigned to: CPU Architecture:Any
Tags: foreign keys, Object Browser

[6 Aug 2012 19:08] Bob Dankert
Description:
The list of foreign keys for a table do not show up in the object browser.  You have to go into the alter table interface to get this information.

How to repeat:
Expand the Foreign Keys section under Object Browser on a table with foreign keys, notice that nothing shows up.

Suggested fix:
Populate the foreign keys.  Also, when a foreign key is selected, it should display all of the information regarding that foreign key in the information pane.
[6 Aug 2012 19:48] Valeriy Kravchuk
Thank you for the bug report. Verified with 5.2.41 on Mac OS X also.
[7 Sep 2012 7:13] Philip Olson
Fixed as of the upcoming Workbench 5.2.43, and here's the changelog entry:

 The object browser did not display foreign keys. A workaround
 was to view them via the "Alter Table" interface. 

Thank you for the report.
[26 Sep 2012 6:22] Mikko Torniainen
This bug still exists in 5.2.43 for foreign keys that include more than one column. 
FOREIGN KEY (`foreign_apple`, `foreign_orange`) REFERENCES `fruit` (`apple`, `orange`)

The constraints are still visible via alter table.

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.050 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.