OS WinXP Home Ru + sp2
Firebird 2.0 rc5 (WI-T2.0.0.12745)
icudt30.dll от rc4 [3.0.0.0]

Выполнение этого скрипта в IBExpert убивает сервер на последнем комите.

FBKill.sql:
set SQL DIALECT 3;
set names WIN1251;

create database 'localhost:D:\lang\test\TEST.FDB'
user 'SYSDBA' password 'masterkey'
page_size 16384
default character set WIN1251;

create table T (
    ID    integer not null,
    N1    blob sub_type 1 segment size 80,
    N2    varchar(10)
);

insert into T (ID, N1, N2) values (1, 'www', 'qwer');

commit work;

alter table T add constraint PK_T primary key (ID);
create index T_IDX on T computed by (substring(N1 from 1 for 100));

commit;
update T set T.N2 = 'asdf' where T.ID = 1;
commit;

Вот лог:
firebird.log:

HALA (Client)   Tue Oct 17 01:29:50 2006
        INET/inet_error: read errno = 10054


HALA (Client)   Tue Oct 17 01:29:50 2006
        INET/inet_error: send errno = 10054


HALA (Client)   Tue Oct 17 01:29:50 2006
        REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
        Uncommitted work may have been lost


HALA (Client)   Tue Oct 17 01:29:50 2006
        INET/inet_error: send errno = 10054

Ответить