Bug #14089 FROM list subquery always fails when information_schema is current database

• Submitted: 18 Oct 2005 0:37
• Modified: 27 Oct 2005 4:33
• Reporter: Roland Bouman
• Status: Closed
• Category: Server
• Severity: S3 (Non-critical)
• Version: 5.0.13-rc-nt/BK source
• OS: Microsoft Windows (WinXP/Linux)
• Assigned to: Sergey Gluhov

[18 Oct 2005 0: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

[18 Oct 2005 1:14] Miguel Solorzano

Thank you for the bug report.

[21 Oct 2005 12:21] Sergey Gluhov

Fixed in 5.0.16

[27 Oct 2005 4:33] Paul DuBois

Noted in 5.0.16 changelog.