Insert null into non-null default column FIREBIRD

Question

Inserting a null column with a null default value gives me a validation error instead of the default value. I do not want to include all triggers in all tables. Is there any other way to do this?

Firebird 2.1.3

Answer 1

The default value is used when you omit the field in the insert, and not when you include the field with a null value.

Example:
Used by default for Name:

insert into SomeTable (Id) values (42)

Tries to paste nullinto Name:

insert into SomeTable (Id, Name) values (42, null)