Subject Firebird BUG
Author deschenes_jacques

I run HU-T1.0.0.697 Firebird Release Candidate 2 on an HP-UX 11i

Here is my problem: When I create a new trigger, it doesn't want to
fire. After some verifications, I found out that the RDB$TRIGGERS
system table contains the value 1024 in the RDB$SYSTEM_FLAG for my
newly created trigger. All the other triggers in my database have
the value 0.

I suspect this is a bug with that version. Can anyone confirm it?

As a workaround solution, I changed the RDB$SYSTEM_FLAG value to 0
and the trigger works fine afterwards.

Will that problem be adressed in a future release of Firebird ?