Bug #66686 Case - Insensitive Table Listings in 5.2.42
Submitted: 4 Sep 2012 14:42 Modified: 17 Jan 2013 16:16
Reporter: Steven White Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench Severity:S3 (Non-critical)
Version:5.2.42 OS:MacOS
Assigned to: CPU Architecture:Any
Tags: sorting, table listing

[4 Sep 2012 14:42] Steven White
Description:
Prior to 5.2.42 the table listing in the SCHEMAS pane was case-sensitive with precedents of UPPER CASE to lower case per ASCII standard.  In 5.2.42 this is no longer the case I can find no entry for this change in the change list for 5.2.42, so I am classifying it as a bug for the release.

I can only think of a few times when a user would want a case-insensitive sorting method, so I do believe case sensitivity should be the default behavior for future releases, however, I believe a easily found toggle is likely the best route as preference is very likely to be debated. 

How to repeat:
Install 5.2.39 (Sort order is case-sensitive)
Install 5.2.42 (Sort order is case-insensitive)
[4 Sep 2012 15:06] Steven White
Addendum - Column Sort Order

It appears that column sort order is also been changed in 5.2.42 and is now listed in alphabetical order instead of column order which I believe should most differently be a toggle or reversed to its original behavior.  Schema's are normally arranged in away that the column order is important to those familiar with it. 

I'm torn on this because, I do want the object info to be sortable by alpha and by type to make exploring unknown schema's easier, but it is a serious work flow adjustment to get used to the current change which was not listed in the change list for the release and should either be reverted or left up to the user to decide.
[4 Sep 2012 15:14] Steven White
MySQL Workbench CE for Mac OS X version 5.2.42  revision 9752
Configuration Directory: /Users/swhit30/Library/Application Support/MySQL/Workbench
Data Directory: /Applications/MySQLWorkbench.app/Contents/Resources
Cairo Version: 1.9.1
OS: Darwin 12.1.0
CPU: 8x Intel(R) Core(TM) i7-2720QM CPU @ 2.20GHz, 8.0 GB RAM
[5 Sep 2012 13:07] Alfredo Kojima
Case insensitive sorting is intentional. The column sorting issue is a bug and will be fixed.
[6 Sep 2012 1:32] Steven White
This intentional behavior is contradictory to MySQL behavior and a user toggle should be considered if it is going to stay in place. Case-Sensitivity can be used for organization structure. As in the example below and causes needless work flow interruption when list placement changes.ed to 

This is more important in a graphical application where you are encouraged to use more mouse and drag operations then one would normally do in a command line interface.

mysql> show tables;
+-----------------------------+
| Tables_in_data_sql          |
+-----------------------------+
| ACSDAT                      |
| BOLDET                      |
| BOLJOB                      |
| BRDCOM                      |
| BRDCOR                      |
| BRDTYP                      |
| BRDUPG                      |
| COLOUR                      |
| COMTRN                      |
| CORSCH                      |
| CSCNTR                      |
| CSDATA                      |
| CURNCY                      |
| DBFRWD                      |
| DBGHST                      |
| DBPHST                      |
| DBTHRU                      |
| DBWAST                      |
| DBWBIN                      |
| DLISTS                      |
| DLOADS                      |
| DWNCDE                      |
| DWNDES                      |
| DWNTIM                      |
| FACTRY                      |
| FCITEM                      |
| FCJOBS                      |
| FCSTEP                      |
| FMLYID                      |
| GRCODE                      |
| INVCOM                      |
| INVHST                      |
| INVISS                      |
| INVLOC                      |
| INVSUP                      |
| JBSPEC                      |
| LABELS                      |
| LBFLDS                      |
| LBFORM                      |
| LBKDGD                      |
| LBMISC                      |
| LOCATN                      |
| MASPEC                      |
| NZLANG                      |
| PAPALL                      |
| PAPDAT                      |
| PAPERS                      |
| PAPROL                      |
| PAPTOT                      |
| PARDFN                      |
| PARSET                      |
| PARSUB                      |
| PARSYS                      |
| PARVAL                      |
| PDETLC                      |
| PDETLH                      |
| PHEADC                      |
| PHEADH                      |
| PLNAUD                      |
| PLOCAT                      |
| PLOCHS                      |
| RESCAL                      |
| RSSDLV                      |
| RSSHST                      |
| RSSORD                      |
| RSSSTK                      |
| RSSSUP                      |
| SBCREA                      |
| SBHIST                      |
| SBMAST                      |
| SBPRCS                      |
| SBSHST                      |
| SBSISS                      |
| SBSJOB                      |
| SBSORD                      |
| SBSRCT                      |
| SBSSIF                      |
| SBSSTK                      |
| SBTRNS                      |
| SCHBRD                      |
| SCHCOM                      |
| SCHGNG                      |
| SCHORD                      |
| SCHPAP                      |
| SCHRES                      |
| SCHROL                      |
| SCHSUM                      |
| SCHUNT                      |
| SDSRCE                      |
| SHDDAT                      |
| SIPERM                      |
| SITEMP                      |
| SKUDAY                      |
| STEDIE                      |
| STKTAC                      |
| STORES                      |
| STSPEC                      |
| SUPPLR                      |
| SUPWID                      |
| TATEMP                      |
| TATHIS                      |
| TOLSET                      |
| ULOADC                      |
| ULOADH                      |
| ULTRTN                      |
| WASDES                      |
| WASTGE                      |
| WASWGT                      |
| WCDEFN                      |
| WORKIP                      |
| XDATA                       |
| XDATA2                      |
| XDATA3                      |
| XDATA4                      |
| XDATA5                      |
| XDATA6                      |
| XDATA7                      |
| XDATA8                      |
| XDATA9                      |
| XHEAD                       |
| XHEAD2                      |
| XHEAD3                      |
| XHEAD4                      |
| XHEAD5                      |
| XHEAD6                      |
| XHEAD7                      |
| XHEAD8                      |
| XHEAD9                      |
| XLATEP                      |
| XLDEFN                      |
| XNLANG                      |
| drules                      |
| ip_configuration            |
| ip_consumption              |
| ip_receipts                 |
| krules                      |
| master                      |
| master_index                |
| plant_info                  |
| tblCorrugatorData1          |
| tblCorrugatorDowntimeCodes  |
| tblCorrugatorDowntimeEvents |
| tblCorrugatorShifts         |
| tblCorrugatorShifts1        |
| tblDowntimeClass            |
| tbl_IP_CPT                  |
| tbl_temp_MachOpt_30day      |
| tbl_temp_MachOpt_Final      |
| tbl_temp_RunLossCodes       |
| tbl_temp_SetupLossCodes     |
| tbl_temp_downtimes          |
| tbl_temp_rateloss           |
| tbl_temp_true_run           |
| tbl_temp_true_setup         |
| v_Boards_Receipt            |
| v_ButtRolls                 |
| v_Consumption_Daily_dwf     |
| v_Consumption_Monthly_dwf   |
| v_Consumption_dwf           |
| v_InTransit                 |
| v_Inv_Consum_Data_dwf       |
| v_Inventory_Monthly_dwf     |
| v_Inventory_dwf             |
| v_Receipt_dwf               |
| v_RollCount_Location        |
| v_RollCount_Status          |
| v_Sell_Roll                 |
| v_boards_consumption        |
| v_boards_inventory          |
| v_consumption_load_dwf      |
+-----------------------------+
170 rows in set (0.01 sec)
[17 Jan 2013 16:16] Ruben Dario Morquecho Valdez
Could you please try with last WorkBench release? 
If you find same behavior please feel free to open it up again.

Thanks for interesting in Mysql Workbench!