Infinite looping when trigger updates same table

166 views
Skip to first unread message

Gaus Lostre

unread,
Jan 4, 2024, 2:02:48 AM1/4/24
to H2 Database
I create a trigger for automating the update timestamp column. That trigger fires when a table is updated. Unfortunately, the trigger behaves as an infinite loop when I use the sql command UPDATE.
Can someone please help me? Is there a way for triggering once?

Andrei Tokar

unread,
Jan 4, 2024, 6:27:45 PM1/4/24
to H2 Database
From what you said, it sounds like a bug, but in order for someone to look at it, you need to provide a complete self-contained (without dependencies on any third party libraries) test case.

Evgenij Ryazanov

unread,
Jan 4, 2024, 10:16:40 PM1/4/24
to H2 Database
Hi!

Is it your question? Anyway, take a look on answers:

Paulo Destro

unread,
Feb 2, 2024, 3:20:17 PM2/2/24
to H2 Database
My git repository 
Reply all
Reply to author
Forward
0 new messages