Bug #69178 Tables not sorted alphabetically in Schemata Explorer
Submitted: 9 May 2013 0:54 Modified: 20 Jul 2013 3:10
Reporter: Bryan Blakey Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench: SQL Editor Severity:S3 (Non-critical)
Version:5.2.47 OS:Any
Assigned to: CPU Architecture:Any
Tags: sidebar, sort, table

[9 May 2013 0:54] Bryan Blakey
Description:
The tables dropdown isn't sorted alphabetically in the schema sidebar/schemata explorer if SELECT query is run on schema before viewing tables.

Assuming a schema named "test_schema" with tables "alpha", "bravo", "charlie", "delta" and "echo", running the following query:

SELECT * FROM test_schema.charlie;

before opening up the Tables list in the schemata explorer would result in the following listing:

v test_schema
   v Tables
        > echo
        > alpha
        > delta
        > bravo
        > charlie

I would expect the output to be sorted alphabetically regardless of when I view Tables in the explorer, such as this:

v test_schema
   v Tables
        > alpha
        > bravo
        > charlie
        > delta
        > echo

How to repeat:
1. Run SELECT query against a table in a schema that has not been opened in the sidebar.
2. Open above schema in schemata explorer.
3. Open Tables dropdown, note that tables are no longer listed alphabetically
[9 May 2013 0:59] Bryan Blakey
simple script to reproduce issue

Attachment: test-case.sql (application/octet-stream, text), 489 bytes.

[9 May 2013 0:59] Bryan Blakey
screenshot of issue

Attachment: example.png (image/png, text), 9.81 KiB.

[9 May 2013 5:13] MySQL Verification Team
Hello Bryan,

Thank you for the report.
Verified as described.

Workaround: On windows/Linux, if you refresh the schema then the table listing would be ordering as expected.

Thanks,
Umesh
[9 May 2013 5:17] MySQL Verification Team
Linux - screenshot

Attachment: 69178_OL6.png (image/png, text), 208.21 KiB.

[9 May 2013 5:19] MySQL Verification Team
Win7 screenshot

Attachment: 69178_windows7.png (image/png, text), 175.97 KiB.

[18 Jun 2013 18:05] Alfredo Kojima
Bug #69502 is a duplicate
[20 Jul 2013 3:10] Philip Olson
Fixed as of the upcoming MySQL Workbench 6.0.4 release, and here's the changelog entry:

The tables drop down was not sorted alphabetically in the schema explorer
if a "SELECT" query was executed on a schema before viewing the tables.

Thank you for the bug report.