Subject Re: [firebird-support] default value
Author Markus Ostenried
On 12/20/06, Nick Upson <nick.upson@...> wrote:
> that's what I thought but :
> SQL> ALTER TABLE tblsystemstatus add test Integer DEFAULT 0 NOT NULL;
> SQL> commit;
> SQL> select * from tblsystemstatus;
> ==================================== ============
> ABCD 0
> hence my confusion

I think a few days ago I read on the same subject that ISQL (and maybe
one other tool?) will display zero/empty string for a newly added
not-null-field with a default value.
AFAIK your field value is indeed NULL.

Try reading the value using another tool or by writing a small test application.