Bug #6316 Table short names/aliases no longer working in boolean join expressions
Submitted: 29 Oct 2004 9:15 Modified: 29 Nov 2004 12:12
Reporter: Andreas Lund Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Server Severity:S2 (Serious)
Version:4.1.7-standard OS:Linux (Linux)
Assigned to: CPU Architecture:Any

[29 Oct 2004 9:15] Andreas Lund 
Description:
Both of these expressions would work in previous versions of MySQL:

LEFT JOIN full_table_name stn ON (stn.f1=foo.bar)
LEFT JOIN full_table_name stn ON (stn.f1=foo.bar OR stn.f2=foo.bar)

Note the use of the short table name "stn".

After upgrading from 4.0.20 to 4.1.7 the second expression must be rewritten as

LEFT JOIN full_table_name ON (full_table_name.f1=foo.bar OR full_table_name.f2=foo.bar)

How to repeat:
Try all three expressions on MySQL 4.0.x and then 4.1.7.
No.1 and 3 will work on both versions, no.2 will fail on 4.1.7.

Suggested fix:
-
[29 Oct 2004 10:33] MySQL Verification Team 
Hi,

Thank you for the report, but it works fine for me. Could you provide a repeatable test case?
[29 Oct 2004 12:12] Andreas Lund 
The problem appears with Invision Power Board v1.1.1 © 2003  IPS, Inc. (http://www.invisionboard.com/)

I will try to isolate the problem further.
[14 Feb 2005 22:54] Bugs System 
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".