Archives of the TeradataForum
Message Posted: Thu, 06 May 2004 @ 15:03:55 GMT
I think it is not a bug. For the reason Error 5565(complex update) is returned in the following cases:
- When you try to update a primary index
- Update that have a subquery
- Update's from another table
Basically if you see an UPSERT is targetted at a Single AMP operation and anything apart from that which would require more than one AMP would be termed as a Complex update - as are the cases above.
In your case too, I guess since you have a secondary index defined on the primary index any update or insert would require an update or insert into the secondary index subtable - more than ONE amp come into picture.
Thereby removing the USI boils down the equation to a SINGLE AMP operation and thus the query goes through.
I think logically this should be the reason, perhaps someone can correct me if it is not so.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 15 Jun 2023|