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.


Regards,


Ann