Bug #17523 natural join abd information_schema
Submitted: 17 Feb 2006 11:32 Modified: 2 Mar 2006 15:16
Reporter: Sergei Golubchik Email Updates:
Status: Closed Impact on me:
Category:MySQL Server Severity:S3 (Non-critical)
Version:5.0 OS:
Assigned to: Timour Katchaounov CPU Architecture:Any

[17 Feb 2006 11:32] Sergei Golubchik
assert fails

How to repeat:
select * from information_schema.statistics join information_schema.columns using(table_name,column_name) where table_name='user';
[22 Feb 2006 8:04] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

[1 Mar 2006 16:40] Timour Katchaounov
Fixed in 5.0.19
[1 Mar 2006 19:20] Magnus BlÄudd
"join" fails in the Windows build.
[2 Mar 2006 9:26] Timour Katchaounov
The problem with 'join.test' is due to an unrelated bug that was discovered
by this test's query. The new bug has been submitted as:
BUG#17852: Incorrect query result on Information Schema tables
[2 Mar 2006 15:16] Paul Dubois
Noted in 5.0.19 changelog.

A natural join between <literal>INFORMATION_SCHEMA</literal>
tables failed. (Bug #17523)