Sqlyog 5.23 Rc3 (again) Runs Wrong Query

[vygi]

Hello friends,

sorry but I have to report that latest RC3 still – or again – executes wrong queries!

Put following in the query tab (incl. empty lines):

—begin—

SELECT 1;

SELECT 2;

SELECT 3;

SELECT 1;

SELECT 2;

SELECT 3;

SELECT 1;

SELECT 2;

SELECT 3;

SELECT 1;

SELECT 2;

SELECT 3;

—end—

Now SQLyog executes 1st line (“SELECT 1;”) when you place cursor in the 2nd one, before or after 1st character:

|SELECT 2;

or

S|ELECT 2;

(“|” indicates cursor position)

returns “1” and not “2”!

Same when you place the cursor after first “;”….

Please take another look at it because it's quite dangerous bug!

Vygi

[peterlaursen]

We fixed such issue in between RC3 and FINAL.

And it works for me now with your example.

Now you please try 5.23 FINAL.

this tokenizer is very complicated!  But still it should not happen of course!  

The reason why this reoccurred is that with a single query only in the Editor 'execute' (single query) will execute the query even if the cursor is positioned after a semicolon.  That was a user request.

[Author]

Posts