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.




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: 28 Jun 2020