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: | |
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
[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!