Bug #69178 Tables not sorted alphabetically in Schemata Explorer

• Submitted: 9 May 2013 0:54
• Modified: 20 Jul 2013 3:10
• Reporter: Bryan Blakey
• Status: Closed
• Category: MySQL Workbench: SQL Editor
• Severity: S3 (Non-critical)
• Version: 5.2.47
• OS: Any
• 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.