Bug #16005 Dragging a table to the results area executes the previous query.
Submitted: 27 Dec 2005 8:47 Modified: 13 Feb 2006 10:26
Reporter: Andreas Papadimitriou Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Query Browser Severity:S3 (Non-critical)
Version:1.1.18 OS:Windows (Windows XP Professional)
Assigned to: Mike Lischke CPU Architecture:Any

[27 Dec 2005 8:47] Andreas Papadimitriou
Description:
When we drag a table from database browser to the results area, it first tries to executes the query that already exists in the query area, and afterwards puts the expected query ("select * from <draggedtablename>") in the query area.

So we end up with the correct query in the query area, but with wrong data in the result area.

How to repeat:
Start the query browser.

Drag a table from database browser to the results area.

Although the expected query is correctly put in the query area, you don't get result, instead you get the message "You tried to execute an empty string. Please type an SQL command into the SQL edit field and execute again" because the query area is empty when you first start the application.

Drag another table from database browser to the results area.

The expected query is correctly put in the query area, but this time you get the results of the previous query, that is you get the data of the previous dragged table.

Suggested fix:
First put the query in the query area, and the execute it.
[28 Dec 2005 15:34] Aleksey Kishkin
verified according to users description
[19 Jan 2006 12:52] Andreas Papadimitriou
It seems that it has been fixed in version 1.1.19 .
[13 Feb 2006 10:26] Andreas Papadimitriou
Fixed: 1.1.19.