| Subject | Re: [firebird-support] Identity vs Before Insert Trigger |
|---|---|
| Author | Mark Rotteveel |
| Post date | 2019-10-31T14:51:02Z |
On 2019-10-31 15:32, Dimitry Sibiryakov sd@...
[firebird-support] wrote:
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
Mark
[firebird-support] wrote:
> 31.10.2019 15:15, Daniel Miller dmiller@... [firebird-support]That isn't necessarily the case: "generated always" (which will be
> wrote:
>> My question - is this intended behavior?
>
> For "generated *by default*" it is intended behavior. Your trigger
> obviously emulated
> identity with "generated always" option.
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
Mark