Subject Re: [firebird-support] default value
Author Ann W. Harrison
Paul Vinkenoog wrote:
> Yes, on a not null column with default it does.
> On a not null column without default it does not, but shows 0 on a
> select.
> On a nullable column it also doesn't, but shows <null> on a select.

When doing tests on nullable and not nullable and default, use
a default other than zero to avoid seeing artifacts of tool
implementations. If the buffers are cleared, it's very hard
to tell the difference between a zero meaning that the default
value was correctly applied and a zero meaning that the buffer
was cleared and no value was set.