Bug #10723 Accessing table in other database fails
Submitted: 19 May 2005 0:47 Modified: 19 Jun 2005 14:01
Reporter: Peter Zaitsev (Basic Quality Contributor) Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Server Severity:S1 (Critical)
Version:4.1.12 OS:Linux (Linux (RPM))
Assigned to: CPU Architecture:Any

[19 May 2005 0:47] Peter Zaitsev 
Description:
Running SuSE 9.1 x86 

Upgraded to 4.1.12 standard RPM today:

mysql> select * from test.test4test;
ERROR 1146 (42S02): Table 'mysql.test4test' doesn't exist

MySQL 4.1.10 works for  same test case. 

This suppose to break any application  which accesses tables in non-current database,
it also can lead to data loss, ie  drop table test.important_table may drop such table from current database instead.

How to repeat:
use test;
create table test4test(i int);
use mysql;
select   * from test.test4test;
[19 May 2005 1:12] Peter Zaitsev 
Clarification: 

The problem is  table is looked up in wrong location, not  just error message is incorrect. 

use test;
create table test4test(i int);
use mysql;
create table test4test(i int);
drop table test.test4test;

mysql.test4test will be removed.
[19 Jun 2005 23:00] Bugs System 
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".