Bug #59391 Sorting User Accounts causes selected/displayed accounts mismatch

• Submitted: 10 Jan 2011 8:54
• Modified: 6 Jun 2011 22:19
• Reporter: Dave Kelly
• Status: Closed
• Category: MySQL Workbench: Administration
• Severity: S2 (Serious)
• Version: 5.2.31 CE GA, 5.2.33b CE GA
• OS: Windows (7 Pro x64, XP)
• Assigned to: Mike Lischke
• CPU Architecture: Any
• Tags: Manage security, server access management, sort, sorting, user accounts, workbench

[10 Jan 2011 8:54] Dave Kelly

Description:
If you use the column headers of the User Accounts list box to sort the accounts by User or From Host, then select various accounts in turn, the selected accounts often do not match the account being diplayed in the corresponding Login/Administrative Roles/Account Limits tabs.

How to repeat:
1. On the Home screen, click Manage Security under Server Administration.
2. When the Admin screen opens, select the Accounts tab.
3. In the User Accounts list box on the Server Access Management tab, click either of the column headers (User or From Host) to sort the accounts by that column.
4. Select an account in the listbox and compare what is displayed in the adjacent Login tab.  Scroll down to the next account, and so on; you'll soon see that one or more selected account(s) does not match the account displayed in the adjacent Login tab.

Suggested fix:
Take a look at the listbox handlers.

[10 Jan 2011 9:07] Valeriy Kravchuk

Thank you for the bug report. Verified on Windows XP.

[21 Mar 2011 19:22] Maksym Yehorov

Can you verify with latest Workbench version? I can not repeat the bug.

[22 Mar 2011 8:16] Dave Kelly

Maksym, I just tried Workbench 5.2.33b CE GA (Revision 7508):  the problem is still there (on Win 7 Pro x64).

Not sure what you're looking at.  Are you testing this on Windows?

[28 Mar 2011 11:26] Santo Leto

I can confirm that this problem is verified also with WB version 5.2.33b.

[10 Apr 2011 10:20] Valeriy Kravchuk

Bug #60821 was marked as a duplicate of this one.

[15 Apr 2011 10:23] Valeriy Kravchuk

Bug #60880 was marked as a duplicate of this one.

[6 Jun 2011 22:20] Paul DuBois

Noted in 5.2.34 changelog.

After using the column headers of the User Accounts list box to sort 
the accounts by User or From Host, then selecting various accounts in
turn, the selected accounts often did not match the account being
diplayed in the corresponding Login, Administrative Roles, or Account
Limits tabs.