Archives of the TeradataForum

Message Posted: Fri, 21 Apr 2006 @ 12:13:36 GMT

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

For what it's worth, I can reproduce this on releases different from yours. I have tried both TD and ANSI semantics and also different syntax forms, such as UPDATE ... FROM.

If you don't have control over how updates will be done by processes / users then this basically means a no-go for the trigger. The results it produces are unreliable.

Thanks for the warning. I think the problem is serious enough for everyone using such triggers to re-test them immediately.

Regards,

Victor

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