Bug #47143 Tables not sorted in physical schemata view
Submitted: 4 Sep 2009 17:29 Modified: 29 Jan 2010 15:36
Reporter: Brad Koch Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench Severity:S3 (Non-critical)
Version:5.1.18 OS:Linux
Assigned to: Alfredo Kojima CPU Architecture:Any

[4 Sep 2009 17:29] Brad Koch 
Description:
The tables are not sorting themselves alphabetically when you view them in the Physical Schemata section, unlike the Windows version which has no issues doing this.

How to repeat:
Make a series of tables with random names.  Look at the physical schemata view.  They will not be listed alphabetically.

Suggested fix:
Sort them alphabetically when displaying the list.
[4 Sep 2009 23:35] MySQL Verification Team 
Thank you for the bug report. Could you please provide a screen-shot showing the behavior reported. Thanks in advance.
[5 Sep 2009 3:07] Brad Koch 
Screenshot of table list.

Attachment: Screenshot.png (image/png, text), 89.86 KiB.
[5 Sep 2009 3:14] Brad Koch 
Note that the tables are not sorted alphabetically, but instead were sorted in the order I created them.  This behavior persists when the file is saved, Workbench is closed, and the file is reopened.  It will sort them properly when opened in Windows, but will revert to this behavior once again when opened in Linux.
[5 Sep 2009 4:39] Valeriy Kravchuk 
This is a duplicate of bug #43993.
[5 Sep 2009 4:57] Brad Koch 
No, this is similar to but not a duplicate of bug 43993.  Bug 43993 requests that an interface for specifying a sorting order for the tables be added.  From the bug:

"Suggested Fix:
1.) header lines in list viewing mode are clickable for sorting by field (asc/desc)
2.) right-click-menu should have a entry for sorting
3.) configurable in options dialog"

This bug simply requests that the tables be sorted in a logical order by default, like they are in Windows.
[6 Jan 2010 13:06] Alfredo Kojima 
Added backend sorting of model overview objects.
[26 Jan 2010 3:29] Alfredo Kojima 
This seems to be fixed, renaming a table in overview resorts the list
[26 Jan 2010 22:09] Johannes Taxacher 
fixed in 5.2.14
[29 Jan 2010 15:36] Tony Bedford 
An entry has been added to the 5.2.14 changelog:

In the Physical Schemata section of the MySQL Model tab, the tables were not displayed in alphabetical order.