MySQL Bugs: #35822: Split result sets re-execute SQL just by clicking on a row

Bug #35822	Split result sets re-execute SQL just by clicking on a row
Submitted:	4 Apr 2008 4:15	Modified:	7 Oct 2008 12:27
Reporter:	Steve Jennette	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Query Browser	Severity:	S2 (Serious)
Version:	1.2.12	OS:	Windows (XP SP2 (all Patches))
Assigned to:	Mike Lischke	CPU Architecture:	Any

Description:
When using a horizontal split tab, after executing both statements, anytime you simply click in the first result set, the second statement is executed. If you click on any row or column, the second statement is executed each time.

I was updating a production table to multiply a column by 100 and then redisplayed the results. After clicking and scrolling a few times, the value ended up to be all 9's. 

Bug 28670 is somewhat similar in that the SQL is executed when it should not be.

How to repeat:
In a horizontal split tab, with the first result set SQL:
    >> SELECT * FROM tbl limit 100;
and second one SQL:
    >> UPDATE tbl set lname = concat(lname, 'X') ;

Execute the select first. Then execute the update. Click on a row in the first tab and the udpate SQL is executed again. Everytime you click in the first result set, the update is executed again. 

If you re-execute the select, you would see one to many X's on the lname column.

Suggested fix:
Clearly, no SQL should be executed without the user doing it. It is unclear why this would be occuring. But certainly needs to be turned off.

Thank you for the bug report.

Thank you for your bug report. This issue has been committed to our source repository of that product and will be incorporated into the next release.

If necessary, you can access the source repository and build the latest available version, including the bug fix. More information about accessing the source trees is available at

    http://dev.mysql.com/doc/en/installing-source.html