Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Incomplete
-
10.0.25, 10.0.29
-
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.