Title continued: …Editor tab if earlier query invalid
The behavior of “Execute selected query” (Ctrl-F9) differs depending on whether the current tab is a “special” one (e.g. stored procedure definition) to SQLyog or just a plain-old blank query tab. In the first type it behaves as “Execute current query” (F9) would.
To reproduce:
Right-click on Views in the object browser. Create View. Enter any name.
Replace the new tab's contents with the following (excluding the lines):
—-
DELIMITER $$
CREATE PROCEDURE test()
BEGIN
SELECT
END$$
DELIMITER ;
SELECT 2;
SELECT 3;
—-
Select “SELECT 2;” with the cursor.
Right-click. Execute Query > Execute selected query.
Notice that the results of three statements are shown.
Behavior is the same for Create Function, Create Stored Procedure, Create Trigger, etc.
In contrast, only the selected query is executed, as expected, if you do the above in a tab opened via File > New Query Editor.
