Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 13 Sep 2012 @ 13:06:48 GMT


     
  <Prev Next>   <<First <Prev
Next>
Last>>
 


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



     
  <Prev Next>   <<First <Prev
Next>
Last>>
 
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023