MySQL Bugs: #41783: selecting schema does not work

Bug #41783	selecting schema does not work
Submitted:	29 Dec 2008 15:39	Modified:	30 Dec 2008 10:45
Reporter:	Yoav Naveh	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	MySQL Query Browser	Severity:	S3 (Non-critical)
Version:	1.2.15	OS:	Windows (Vista)
Assigned to:		CPU Architecture:	Any
Tags:	query browser, schema

Description:
Working with MySQL 5.1.30

I have 2 schemas (say we call them schema1 and schema2) both having a table with the same name (say we call it my_table)
when I start the GUI browser I select a default schema.
Now, executing select * from my_table returns results from schema1 as expected,

However - when I right click on schema2 and select it as the defaults schema, select * from my_table still returns the result from schema1 !

Note: Selecting select * from schema2.my_table works properly

Another note: not sure if this is relevant but whenever i start the query browser Vista's UAC asks me to Allow the application to run (permission issue?)
Again - this seems irrelevant but I thought it is worth mentioning.

How to repeat:
create 2 schemas. put a table with the same name under both.
put differnet data under each table.

start the query browser and select one of the schemas and connect.
Now once the GUI had come up, right click on the other schema and select it as default.

Now, run a select from the table and don't specify the table name:
select * from my_table 

results are from the first schema and not the second one as expected.

Suggested fix:
Selecting default schema should cause commands with no schema specification to work on the new default schemacr

Thank you for the bug report. Looks the same behavior reported of bug: http://bugs.mysql.com/bug.php?id=41428. Do you agree?. Thanks in advance.

Duplicate:

http://bugs.mysql.com/bug.php?id=41428&thanks=sub

http://bugs.mysql.com/bug.php?id=41428&thanks=sub