Archives of the TeradataForum

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

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

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>>