Bug: Wrong Statement Is Being Executed

[peterlaursen]

I did experience something similar.

But I thought it only occurred when a delimiter was used.

[vygi]

I have installed 4.2 RC1 and the bug is still here!

Actually I have 3 SQL statements in the query tab:

1st one is quite long (44 lines),

and following two are simple ones:

SELECT MAX(date_id) FROM calls;

UPDATE OLAP.calls, tinb.zones00 SET dest_id=code WHERE dest_id=100 AND date_id=1759 AND …

SQLyog 4.2 RC1 still executes 2nd (select max) query when cursor is placed on the left from the blank between “dest_id=100” and “AND” in the 3rd statement. (“…dest_id=100| AND date_id…”)

Full query tab content attached.

Vygi

[vygi]

I have installed 4.2 RC2 and the bug is still here, although it now “works” in reverse order: next query can be executed insted of actual.

Actually I have 3 SQL statements in the query tab:

1st one is quite long (44 lines),

and following two are very simple:

SELECT 2+2;

and

SELECT 3+3;

SQLyog 4.2 RC2 now executes 3rd (select 3+3) query when cursor is placed on the right from “+” in the 2nd query, eg. in that way:

SELECT 2+|2;

SELECT 3+3;

Result is “6” and not “4”.

Queries are attached.

[Author]

Posts