MySQL Bugs: #23453: Losing connection to selected database when I'm running script in the script tab

Bug #23453	Losing connection to selected database when I'm running script in the script tab
Submitted:	19 Oct 2006 7:37	Modified:	7 Feb 2007 13:39
Reporter:	Anders Rydqvist	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Query Browser	Severity:	S3 (Non-critical)
Version:	1.2.4 rc	OS:	Windows (Windows)
Assigned to:	Mike Lischke	CPU Architecture:	Any
Tags:	Lost connection, Mysql Query Browser, script

Description:
After I have executed a script, in the script tab, I loose the connection to the selected  database. 

How to repeat:
* Select a database in the Mysql Query browser.
* Go to File -> Open script, select a script file.
* Execute the script by pressing the Execute button.
* You loose the connection to the database you have executed the script against.

Suggested fix:
Shouldn't loose the connection to the database after you have executed a script against a database.

Thank you for the bug report. I was unable to repeat the behavior reported,
could you please provide more information regarding your environment: server
version, a script and dump file if needed, my.ini file; to test on my side.
Thanks in advance.

I'm using Windows XP SP2.

MySQL Server version	5.0.22-community-max-nt

Please check the file tab. I have added my.ini and a test script file.

I have the same problem with:
MySQL Query Browser 1.2.4 beta
Windows XP SP2
MySQL Server 5.0.26

The lost connection is NOT showed in the script tab (after the script has run), but if you open a query tab and execute there a SELECT-statement, you get
"No database selected".

My script:
DROP TABLE if exists table1;
CREATE TABLE table1
   select vendor AS name # type = varchar(100)
   from table2;

In MySQL Query Browser 1.1.20 the same script runs without problems!

This problem seems to be solved in ver 1.2.8 beta
Thanks!

Excellent. Thanks for letting us know.