 |
 |
Archives of the TeradataForum
Message Posted: Thu, 13 Sep 2012 @ 13:06:48 GMT
| Subj: | | Re: Problem with Alias in Teradata 14 |
| |
| From: | | SUMAN M |
SUMAN M previously wrote:
| | Can someone explain how is Table & Cloumn alias resolved in Teradata 14? | |
| | Does it take reference to the table id and column id stored in system tables to resolve the alias? | |
| | There was an upgrade done from Teradata 12 to Teradata 14 recently and all the database objects were migrated from V12 to V14 along with
replicating the access & user rights at database level. We are seeing problem with column alias when trying to reference from the subqueries and
the joins | |
| | Scenario: If the Alias name in the main SQL is the same as those used in subquery and the joins, the query is not giving any
result. | |
| | However, if the alias name in main SQL is changed to some other name, then the result works fine. | |
Hi Experts,
How is alias resolved by the Teradata optimizer?
Any insight on this will be very useful.Please share your thoughts
Thanks
Suman
| |
