| Subject | Re: [firebird-support] Query a table within its trigger |
|---|---|
| Author | Helen Borrie |
| Post date | 2012-07-05T18:43:44Z |
At 01:21 AM 6/07/2012, you wrote:
./heLen
>Hi,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.
>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.
./heLen