MySQL Bugs: #79580: The "selected" (highlighted) query set doesn't stay selected after execution.

Bug #79580	The "selected" (highlighted) query set doesn't stay selected after execution.
Submitted:	9 Dec 2015 17:57	Modified:	20 Jan 2017 20:41
Reporter:	M Croucher	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Workbench: SQL Editor	Severity:	S3 (Non-critical)
Version:	6.3.5, 6.3.7	OS:	Windows (Microsoft Windows 7 Professional Service Pack 1)
Assigned to:		CPU Architecture:	Any
Tags:	highlightedtext, WBBugReporter

Description:
In the older version of MySQL workbench, when you executed a highlighted query set (using Ctrl-Shift-Enter), the query set would stay highlighted for the ability of rapid execution. For some reason, since the 6.0 version of Workbench, the query set is un-highlighted after execution, so you have to highlight the queries you just executed to run them again (using Ctrl-Shift-Enter).

This is extremely painful, as I repeatedly execute the same queries over again, and it is inefficient to have to highlight a set of queries (especially if you are running multiple queries in a set) over and over again. I have been using the GA version 5.2.47 because of this issue; but I was hoping by now in version 6.3.5 it had been fixed. Since this was a feature in 5.2.47 and earlier, I would imagine it would not be difficult to add back in.

I will continue to use 5.2.47 until this is fixed, but I really do want to be on the latest version of Workbench. But the lack of this simple thing really slows me down.

Thanks!

How to repeat:
Highlight a set of queries in the SQL Editor Query window. For example, highlight..

select * from mysql.proc;
select * from mysql.user;
select * from mysql.db;

Highlight all three and then press "Ctrl-Shift-Enter" or click the lightening bolt.

Once execution happens and results return, the three queries are no longer highlighted, preventing easy re-execution by pressing "Ctrl-Shift-Enter" again.

Suggested fix:
Leave the queries highlighted (just as in the earlier versions of Workbench (like 5.2.47).

THANK YOU!

Hello M Croucher,

Thank you for the report and feedback!
Observed this with 6.3.7 on Win7.

Thanks,
Umesh

Posted by developer:
 
Fixed as of the upcoming MySQL Workbench 6.3.9 release, and here's the changelog entry:

Query statements executed from the SQL Editor did not remain selected when
the focus returned to the query area.

Thank you for the bug report.