Subject Re: [firebird-support] Duplicate Trigger Positions
Author Ann W. Harrison
Thomas Steinmaurer wrote:
>
> Might this affect the firing order of system triggers at the same
> position per event/type on system tables negatively?
>
There was a problem in InterBase 6 with the relative order of user and
system triggers, but it was resolved before Firebird 1 was released.
When a table is being compiled, the triggers are integrated with a query
like
select rdb$trigger_blr from rdb$triggers
where .....<a variety of checks for system triggers>
order by rdb$trigger_sequence


Nobody cares whether the sequence values are unique, but the order of
duplicates is ill-defined.


Regards


Ann