Re: [Firebird-devel] possible bug in FB1.5.0.4306

[Helen B. <he...@tp...>]

At 03:39 PM 27/04/2004 +0400, you wrote:
>Not confirmed for 1.5 (both WinNT SS and Linux CS) with isql.
>Alex.
>
>gary wrote:
>
>>This was tested in dbworkbench 2.4.2 using sql script editor as well as
>>IBOscript on 15 different servers using FB1.5.0.4306 on winXP or WINNT
>>
>>create table testcorrupt
>>(
>>link varchar(10) not null,
>>misc1 varchar(3),
>>misc2 varchar(3),
>>CONSTRAINT  testcorrupt_PRIMARY PRIMARY KEY (LINK)
>>);
>>
>>commit;
>>
>>insert into testcorrupt( link, misc1, misc2) values(
>>'SVR0000001','GB1','MI1');
>>insert into testcorrupt( link, misc1, misc2) values(
>>'SVR0000002','GB2','MI2');
>>insert into testcorrupt( link, misc1, misc2) values(
>>'SVR0000003','GB3','MI3');
>>
>>commit;
>>
>>alter table TESTCORRUPT add miscnew1 char(1);
>>update TESTCORRUPT set miscnew1 = 'Y'; << this gives a unique constraint
>>error
>>
>>commit;
>>
>>alter table TESTCORRUPT add miscnew2 char(1);
>>update TESTCORRUPT set miscnew1 = miscnew2; << this gives an arithmetic
>>overflow error

Just created it ^^^ almost ^^^ as above, using TIB_Script, no problems at all.

One difference - I added commits after the two alter table statements.
FB1.5.0.4306 on Win2K.

Helen