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
Category:	MySQL Query Browser	Severity:	S2 (Serious)
Version:	1.2.12	OS:	Microsoft Windows (XP SP2 (all Patches))
Assigned to:	Mike Lischke	Target Version:
Triage:	D2 (Serious)

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