Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Sqlyog Executes Wrong Statement

forums forums SQLyog SQLyog: Bugs / Feature Requests Sqlyog Executes Wrong Statement

  • This topic is empty.
Viewing 2 reply threads
  • Author
    Posts
    • #10096
      vygi
      Member

      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

    • #23127
      ronjeremy_69
      Participant

      This wasnt exactly like the old bug, but was close, and is fixed with the latest release.

      See this post from last week:

      http://www.webyog.com/forums/index.php?showtopic=2760

    • #23128
      vygi
      Member
      ronjeremy_69 wrote on Dec 21 2006, 06:39 PM:
      This wasnt exactly like the old bug, but was close, and is fixed with the latest release.

      See this post from last week:

      http://www.webyog.com/forums/index.php?showtopic=2760

      oops… sorry!! :ph34r:

Viewing 2 reply threads
  • You must be logged in to reply to this topic.