Archives of the TeradataForum

Message Posted: Thu, 06 May 2004 @ 15:03:55 GMT

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

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.

Narayan

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