Subject Re: [firebird-support] Query a table within its trigger
Author Helen Borrie
At 01:21 AM 6/07/2012, you wrote:
>I am wondering if there are any known issues with queries within a trigger, when that query accesses the table on which the trigger fires (before insert, so no race condition).
>I am experiencing unpredictable and even wrong results in such a case, at least when using FB 2.0 and 2.5. With 2.1 I have not experienced this, so far.
>Thanks for any help.

If you have a row in a table that depends on values in other rows in the same table then you have a serious flaw in your relational design. Move that column or set into another table.