Bug #14089 FROM list subquery always fails when information_schema is current database
Submitted: 17 Oct 2005 22:37 Modified: 27 Oct 2005 2:33
Reporter: Roland Bouman Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:5.0.13-rc-nt/BK source OS:Microsoft Windows (WinXP/Linux)
Assigned to: Sergei Glukhov CPU Architecture:Any

[17 Oct 2005 22:37] Roland Bouman
Description:
A query with a FROM list subquery (a.k.a inline view or subselect) on an arbitrary table from an arbitrary database fails when the information_schema database is the current database. The error returned is:

ERROR 1109 (42S02): Unknown table '*' in information_schema

This is clearly a bug. It should not matter that the information_schema is the current database, and the FROM list subquery should be allowed in every context where it is normally allowed.

How to repeat:
use test

drop table if exists test;

create table test(
    id int
);

insert 
into test (
    id
) values (
    1
);

select 1
from  (
    select 1
    from   test.test
) a;

+---+
| 1 |
+---+
| 1 |
+---+

use information_schema

select 1
from  (
    select 1
    from   test.test
) a;

ERROR 1109 (42S02): Unknown table '*' in information_schema

Suggested fix:
Fix the bug, allow FROM list subqueries even though the information_schema is the current database
[17 Oct 2005 23:14] Miguel Solorzano
Thank you for the bug report.
[21 Oct 2005 10:21] Sergei Glukhov
Fixed in 5.0.16
[27 Oct 2005 2:33] Paul Dubois
Noted in 5.0.16 changelog.