Archives of the TeradataForum
Message Posted: Wed, 19 Feb 2003 @ 13:04:02 GMT
Here a simpliefied example. This code runs in V2R4.0.3 and not V2R22.214.171.124;
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;
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|