|Subject||[firebird-support] Identity vs Before Insert Trigger|
As i understand your question - yes. BI trigger fired before column constraints check. To allow you process and correct row to store without errors.
Execution sequence: BI trigger -> default values -> not null -, FK-, check- constraints ->
storing -> AI triggers.
However, the same query works without issue with a before-insert trigger
using a generator. My question - is this intended behavior? Or a bug in
the identity implementation?