Bug #66279 Tables in different order in foreign key referenced table list than obj. browser
Submitted: 9 Aug 2012 13:49 Modified: 13 Jun 2013 6:26
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:Windows (W7 64)
Assigned to: CPU Architecture:Any
Tags: foreign key, order, referenced table

[9 Aug 2012 13:49] Bob Dankert
Description:
Tables listed in the referenced table list for foreign keys are in a different order than in the object browser.  For example, if you have two tables called "test" and "test_table", they will appear in this order:

Object Browser:  test (first), test_table (second)

Foreign Key Referenced Table List:  test_table (first), test(second)

<phrase>_ comes before <phrase> in the referenced table list, which can be confusing if you are used to seeing the tables in a specific order.

How to repeat:
Create two tables, <phrase> and <phrase>_<anything>.  Look at the order in the object browser and then alter a third table, go to the foreign key list, and look at the order of those 2 tables.

Note - after creating the tables you need to close out of the connection and go back in, due to a different bug putting the tables in the wrong order.

Suggested fix:
Display the tables in the same order in all interfaces.
[21 Aug 2012 18:54] Armando Lopez Valencia
Evidence

Attachment: 66279.JPG (image/jpeg, text), 139.43 KiB.

[21 Aug 2012 18:56] Armando Lopez Valencia
Thanks for he report Bob.
Verified in:
Windows 7x64
WB 5.2.42 rev9750
Se attachment for details.
[13 Jun 2013 6:26] Philip Olson
Fixed as of the upcoming MySQL Workbench 6.0.2 public beta release, and here's the changelog entry:

The "Object Browser" and "Foreign Key Referenced Table List" would
sometimes list tables in a different order, but they now use the same
sorting mechanism.

Thank you for the bug report.