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