Bug #52998 Improve navigation to multiple result sets
Submitted: 20 Apr 2010 17:49 Modified: 14 Jun 2010 14:04
Reporter: James Grobowski Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench: SQL Editor Severity:S3 (Non-critical)
Version:5.2.19 OSS Beta OS:Windows (XP Professional)
Assigned to: Mike Lischke CPU Architecture:Any
Tags: multiple result sets, stored procedures

[20 Apr 2010 17:49] James Grobowski 
Description:
When a stored procedure that produces more than 5 result sets is called, only 5 result set tabs appear along the top of the lower right pane.  Result sets 6 and above can be viewed by clicking on the tab for result set 5 and pressing the right arrow key, but the tabs for result sets 6 and above do not scroll into view, thus making it difficult to identify which of the result sets is being displayed.

How to repeat:
Call a stored procedure that produces more than 5 result sets.

Suggested fix:
When more tabs are produced than will fit along the top of the lower right pane, display a spin button with left and right arrows at the top of the pane on the right.  Program the spin button to scroll the tabs onto and off of the screen.  When the button is used to navigate to a tab, the corresponding result set should be displayed and the focus should shift to it.
[20 Apr 2010 18:13] Valeriy Kravchuk 
What exact OS do you use? On Mac OS X, for example, I see left and right arrows at sides, and they allow me to move to any of the results tab.
[21 Apr 2010 6:32] Valeriy Kravchuk 
This is, indeed, a problem on XP. As a partial workaround you can use keyboard left and right arrow keys to see the results, but proper tab caption does not appear and it is still hard to navigate efficiently.
[12 May 2010 10:08] Mike Lischke 
Implemented in repository.
[14 Jun 2010 9:38] Mike Lischke 
Fixed in repository.
[14 Jun 2010 12:36] Johannes Taxacher 
fix confirmed in repository
[14 Jun 2010 14:04] Tony Bedford 
An entry has been added to the 5.2.23 changelog:

In the SQL Editor, when more result tabs that could fit into the current panel were generated, it was not obvious how to navigate to those result sets that could not currently be displayed. This could be achieved using the left and right arrow keys, but MySQL Workbench has now been changed to include a spin control to navigate the available tabs.