Subject Re: [firebird-support] Identity vs Before Insert Trigger
Author Mark Rotteveel
On 2019-10-31 15:32, Dimitry Sibiryakov sd@...
[firebird-support] wrote:
> 31.10.2019 15:15, Daniel Miller dmiller@... [firebird-support]
> wrote:
>> My question - is this intended behavior?
> For "generated *by default*" it is intended behavior. Your trigger
> obviously emulated
> identity with "generated always" option.

That isn't necessarily the case: "generated always" (which will be
introduced in Firebird 4), will always(*) generate an id, while it is
possible that Daniels trigger only generates it if the column is `null`
(either because it wasn't populated or because it was explicitly
populated with null).

*: Ignoring the override options