Hello folks,
I have just realized that an old bug is back:
in some cases SQLyog executes wrong SQL statement, namely not the one where the corsor is placed, but some of the queries above.
I had maybe 7 or 8 SQL statements in the SQLyog query editor tab and executed them when and then by pressing on F5.
At same point I have started to wonder why my SELECT statement returns “0 Row(s) affected” and not an expected result set. After few experiments I have realized that SQLyog executes UPDATE statement which was placed two lines above my SELECT. I was just lucky enough that ist wasn't some unwanted DELETE or DROP and that even this UPDATE wasn't successful.
Uploaded (attached) is a SQL file which should be useful to debug and to fix this dangerous issue.
Copy & paste everything from this file into the query editor tab.
Place cursor in the “SELECT 9;” line, press F5 and it will return “6”, so SQLyog actually executes “SELECT 6;”.
Try to execute “SELECT 1” and you will be updating the rainbow.pcdrs table.
Hope it helps,
Vygi
