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: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.

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.051 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.