Bug #52302 Extend Execute Current Command in SQL Editor
Submitted: 23 Mar 2010 12:51 Modified: 16 Apr 2010 15:44
Reporter: Michael G. Zinner Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench: SQL Editor Severity:S3 (Non-critical)
Version:WB52 OS:Any
Assigned to: Sergei Tkachenko CPU Architecture:Any

[23 Mar 2010 12:51] Michael G. Zinner
Description:
The Execute Current command should be extended to the following behaviour.

1) the statement below the cursor is executed;
2) in case the cursor is not within a statement, the last statement before the cursor is executed

In these cases SELECT 1; is executed:

SEL|ECT 1; SELECT 2;

SELECT 1|; SELECT 2;

SELECT 1;| SELECT 2;

SELECT 1;
|
SELECT 2;

In those cases SELECT 2; is executed:

SELECT 1; SELECT 2;|

SELECT 1; SEL|ECT 2;

SELECT 1; SELECT 2;

|

Linebreaks are skipped.

How to repeat:
Use SQL Editor.

Suggested fix:
Implement as suggested.
[30 Mar 2010 19:46] Johannes Taxacher
fixed in repository
[16 Apr 2010 15:44] Tony Bedford
A 'change' entry has been added to the 5.2.17 changelog:

The Execute Current Statement command in the SQL Editor has been improved. The statement that contains the cursor will be executed. Further, if the cursor is outside of a statement, the last statement before the cursor is executed.