--- In ib-support@yahoogroups.com, "Thomas Steinmaurer" <ts@i...>
wrote:

> To be sure, I used isql.exe and not a third-party tool and
> after altering a table with:
>
> SQL> alter table mytable2 add myint2 integer not null;
> SQL> commit;
>
> A select
>
> SQL> select myint2 from mytable2;
>
> shows the value 0 for myint2 for old records, so the database
> *should* be in a restoreable state.

Thomas, now try

select * from mytable2 where myint2 is null;

;)) You see client-side null-interpretation of Not Null column. IIRC I
even registered it in bug tracker once.

Best regards, Alexander V.Nevsky.