Re: [jira] Commented: (DERBY-1603) ERROR 54038: "Maximum depth of nested triggers was exceeded" occurs when trigger fires after upating 10.1.2.5 jars to 10.1.3.1

[Kathey Marsden]

Kathey Marsden wrote:


A few questions/concerns  on this issue:
1)  CORRECT TRIGGER DEFINITION:

To get the semantics the user seems to want, which is  to update  the 
timestamp when TESTID changes, is this how the trigger should be defined?

[snip wrong syntax]
Answer is no.  Not sure why I thought I saw this work before.  Playing 
with it now, it does not. 

Kathey