You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
recreate table tns(f int); -- drop dependencies if any
commit;
set term ^;
execute block as
begin
execute statement 'drop collation ns_coll;';
when any do begin end
end^
set term ;^
commit;
create collation ns_coll for utf8 from unicode 'NUMERIC-SORT=1';
recreate table tns(s varchar(50) character set utf8 collate ns_coll);
commit;
recreate table tns(f int); -- drop dependencies if any
commit;
set term ^;
execute block as
begin
execute statement 'drop collation ns_coll;';
when any do begin end
end^
set term ;^
commit;
create collation ns_coll for utf8 from unicode 'NUMERIC-SORT=1';
rollback; -- !!NB!!
set term ^;
execute block as
begin
execute statement 'drop collation ns_coll;';
when any do begin end
end^
set term ;^
commit; -- this commit kills FB service
The following messages apear in ISQL:
-------------------------------------------------------
Statement failed, SQLSTATE = 08006
Unable to complete network request to host "localhost".
-Error reading data from the connection.
The following messages appear in firebird.log:
--------------------------------------------------------------
BALAHA Fri Nov 04 07:38:05 2011
Fatal lock manager error: invalid lock id (0), errno: 0
Submitted by: @pavel-zotov
Is related to QA603
recreate table tns(f int); -- drop dependencies if any
commit;
set term ^;
execute block as
begin
execute statement 'drop collation ns_coll;';
when any do begin end
end^
set term ;^
commit;
create collation ns_coll for utf8 from unicode 'NUMERIC-SORT=1';
recreate table tns(s varchar(50) character set utf8 collate ns_coll);
commit;
recreate table tns(f int); -- drop dependencies if any
commit;
set term ^;
execute block as
begin
execute statement 'drop collation ns_coll;';
when any do begin end
end^
set term ;^
commit;
create collation ns_coll for utf8 from unicode 'NUMERIC-SORT=1';
rollback; -- !!NB!!
set term ^;
execute block as
begin
execute statement 'drop collation ns_coll;';
when any do begin end
end^
set term ;^
commit; -- this commit kills FB service
The following messages apear in ISQL:
-------------------------------------------------------
Statement failed, SQLSTATE = 08006
Unable to complete network request to host "localhost".
-Error reading data from the connection.
The following messages appear in firebird.log:
--------------------------------------------------------------
BALAHA Fri Nov 04 07:38:05 2011
Fatal lock manager error: invalid lock id (0), errno: 0
BALAHA (Client) Fri Nov 04 07:38:05 2011
INET/inet_error: read errno = 10054
BALAHA Fri Nov 04 07:38:05 2011
INET/inet_error: select in packet_receive errno = 10093
BALAHA (Client) Fri Nov 04 07:38:16 2011
REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
Uncommitted work may have been lost
Commits: a460334 8ffb3f5
The text was updated successfully, but these errors were encountered: