[MDEV-12081] Table aliases not functioning correctly in OUTER JOIN ON condition Created: 2017-02-19  Updated: 2017-03-24  Resolved: 2017-03-24

Status: Closed
Project: MariaDB Server
Component/s: OTHER
Affects Version/s: 10.0.25, 10.0.29
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: John Ellin Assignee: Unassigned
Resolution: Incomplete Votes: 0
Labels: need_feedback
Environment:

OpenSUSE 13.2, RH ES6


 Description   

Once an alias is created for a table, the table should only be referred to by its alias.

in 10.0.14, the following statement works fine:

SELECT [...]
FROM Table1
LEFT OUTER JOIN Table2 Alias2 ON Table1.ColumnN = Alias2.ColumnN

However, on 10.0.25 and 10.0.29, the statement does not work and has to be changed to:

SELECT [...]
FROM Table1
LEFT OUTER JOIN Table2 Alias2 ON Table1.ColumnN = Table2.ColumnN

I can find nothing in the change log between 10.0.14 and 10.0.25 to indicate that this is intentional.

The database on OpenSUSE is using InnoDB and I believe that the database on ES6 is MyISAM.

 Comments   
Comment by Elena Stepanova [ 2017-02-21 ]

Please paste the exact quote from your client, showing how the statement does not work.

Comment by Elena Stepanova [ 2017-03-24 ]

If you have more information, please comment and the issue will be re-opened.

Generated at Thu Feb 08 07:54:58 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.