Bug #42246 Default Schema doesn't change in Query Browswer 1.2.15
Submitted: 21 Jan 2009 17:56 Modified: 28 Jan 2009 13:24
Reporter: George Mrvos Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Query Browser Severity:S1 (Critical)
Version:1.2.15 OS:Windows (Windows 7 Ultimate Beta)
Assigned to: CPU Architecture:Any

[21 Jan 2009 17:56] George Mrvos
Description:
If you select a new default schema then run a query you will get an error 1146 that the table does not exist. If you open a new connection then the query against the new default schema works. Also if you click to add a new result set window the query against the new default schema will run.  

How to repeat:
1)Open Query Brower and point it to any database.
2)Run a query against that database and it will run fine.
3)Change the default schema either by right clicking and choosing new default schema or by going to the file menu and selecting new default schema there and select a different database. At this point the new database will be in bold and listed in the window as the default schema
4)Try and run a query against the new schema. It fails with an error 1146 table not found but if you try and run a query against the original schema even though the gui reports it as not being active it runs fine

Suggested fix:
When you select a new Default Schema when you run a query against that schema it should work.
[21 Jan 2009 20:41] MySQL Verification Team
Thank you for the bug report.
[22 Jan 2009 16:21] MySQL Verification Team
Bug: http://bugs.mysql.com/bug.php?id=42255 marked as duplicate of this one.
[28 Jan 2009 13:24] Mike Lischke
... end is in turn a duplicate of Bug #41428. *Please* search before submitting new bugs!