Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 19 Feb 2003 @ 13:04:02 GMT


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


Subj:   Re: Info on and migration to V2R5
 
From:   Claybourne L. Barrineau

Here a simpliefied example. This code runs in V2R4.0.3 and not V2R5.0.0.3;

I agree with Glen, it was sloppy code. The 'fix' was to explicitly name all columns from the derived tables. I cannot fault Teradata for this issue, it was ours.


Thanks,

Clay

--


Create volatile table T_ORG (Org_ID Integer Not Null, Org_Nm Char(30)) ;

select dt_x.*
      ,t_org.Org_ID as Third_Org_ID
      ,t_org.Org_Nm as Third_Org_Nm
From  t_Org,
      (
      select      dt_x.*
      ,           t_org.Org_ID as Second_Org_ID
      ,           t_org.Org_Nm as Second_Org_Nm
      from  t_org,
            (
            select *
            from t_org
            ) as dt_x
      Where dt_x.Org_ID =     t_org.Org_ID
      ) as dt_x
Where dt_x.Second_Org_ID      =     t_org.Org_ID;


     
  <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: 27 Dec 2016