MySQL Bugs: #66308: Confusing UI behaviour in query result displays

Bug #66308	Confusing UI behaviour in query result displays
Submitted:	10 Aug 2012 12:19	Modified:	15 Jan 2013 8:10
Reporter:	Craig Fowler	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Workbench: SQL Editor	Severity:	S3 (Non-critical)
Version:	5.2.41	OS:	Linux (Debian testing)
Assigned to:		CPU Architecture:	Any
Tags:	UI

Description:
When viewing results from a SQL query in tabular format (opening in a new UI pane), the right-click behaviour seems to have changed a little since v5.2.40 and is now a little confusing:

If you right-click a cell within the results pane where the row is currently in a 'selected' state, then the context menu differs and any options that relate to a specific cell are disabled/no not function.  For example "open value in viewer" is enabled but will not work, wheras the 'copy field content' options are both in a disabled state.

How to repeat:
Perform any query that returns multiple rows/columns of results.  Open a right-click context menu on the results by first left-clicking the cell and then right-clicking it.  It would seem that the context menu which appears is in "row" mode and is behaving as if the row was right-clicked and not a cell.

If you instead clear the row-selection (it seems that right-clicking does this, albeit the selection is cleared after the context menu is displayed) and then right-click a cell without first selecting it the context menu appears and behaves normally.

It would seem that this is not intentional functionality?  Right-clicking a cell clears the row-selection (because the context is a cell and not a row) but the context menu seems to be generated after the selection is cleared and not beforehand, so the wrong context is used for that menu?

As a workaround for now, users must make sure they don't select-then-open-the-context menu (as I for one am used to doing) and just right-click from the outset with no selection.

Thanks for the report Craig.
Reproduced as stated by he reporter.
Thanks.

Fixed as of the upcoming MySQL Workbench 5.2.46, and here's the changelog entry:

On Linux, the right-click context menu would differentiate between
unselected and selected rows, when called from within the SQL editor
results view panel. This menu is now consistent.

Thank you for the bug report.