Bug #20890 Cannot switch database
Submitted: 6 Jul 2006 15:41 Modified: 6 Oct 2006 15:38
Reporter: Joerg Bruehe Email Updates:
Status: Unsupported Impact on me:
None 
Category:MySQL Query Browser Severity:S3 (Non-critical)
Version:1.1.17 OS:Windows (Windows 2003)
Assigned to: Vladimir Kolesnikov CPU Architecture:Any
Tags: Generic

[6 Jul 2006 15:41] Joerg Bruehe
Description:
Using the QueryBrowser to smoke-test the 5.0.23 server (community, pro, pro-gpl),
MySQL user "root", password-protected, local.

The database can be selected by the login mask ("test" or "mysql", no other created).
However, it cannot be switched using "use ....":
When I try that, I get a message in the bottom line saying:

   The default schema cannot be changed to mysql  The following error occurred:

(but nothing follows).
When I try to switch from "mysql" (from login mask) to "test", I get a "L" following the line, so I suspect the message simply got truncated 

How to repeat:
See above - try "use" to switch between "mysql" and "test" in a default instalaltion.

Suggested fix:
1) Avoid message truncation, or provide a means to access the other parts.
2) Make "use ..." work.
[6 Oct 2006 15:38] Vladimir Kolesnikov
Thank you for taking the time to report a problem.  Unfortunately you are not using a current version of the product you reported a problem with -- the problem might already be fixed. Please download a new version from http://www.mysql.com/downloads/

If you are able to reproduce the bug with one of the latest versions, please change the version on this bug report to the version you tested and change the status back to "Open".  Again, thank you for your continued support of MySQL.

Hi Joerg, 

please re-check it with the latest release. It probably has a duplicate which should have been fixed. (Btw: you can dbl-click on a schema in the schema tree to make it default).