Scope of AllowUpdateOverwrite

[Mark Rotteveel]

The documentation of AllowUpdateOverwrite in firebird.conf repeatedly
mentions UPDATE (which I take to mean the statement), and not update
(i.e., any modifying action). Does this really mean it only affects the
UPDATE statement, and not for example changes through MERGE, or a DELETE
operation?

Mark
--
Mark Rotteveel

[Vlad Khorsun]

07.06.2026 12:15, 'Mark Rotteveel' via firebird-devel:

> The documentation of AllowUpdateOverwrite in firebird.conf repeatedly mentions UPDATE (which I take to mean the statement), and not
> update (i.e., any modifying action). Does this really mean it only affects the UPDATE statement, and not for example changes through
> MERGE, or a DELETE operation?

Of course is affects any kind of UPDATE - including MERGE and UPDATE OR INSERT.
Is doesn't affect DELETE, as it is about single fields values.

Honestly, I will be happy to remove this hack and reimplement triggers properly,
but this is much more complex task (and we already have a lot of new features).

Regards,
Vlad

[Mark Rotteveel]

That is what I thought, but typography matters, and to me all uppercase
"UPDATE" refers specifically to the statement, while normal-case
"update" to any modifying operation.

OK, deletes (DELETE) are not affected. Though I wonder if there aren't
any similar effects needed for a trigger that deletes a record, and a
later update (or vice versa).

Mark
--
Mark Rotteveel