Subject Re: Database corruption after alter table
Author Alexander V.Nevsky
--- In, "Thomas Steinmaurer" <ts@i...>
> 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.