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
• Status: Closed
• Category: MySQL Server
• Severity: S3 (Non-critical)
• Version: 5.0.13-rc-nt/BK source
• OS: 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] MySQL Verification Team

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.