FB 3.0 crashes when trying to RE_create two tables and define master-detail 
link between them using text fields with different character sets
---------------------------------------------------------------------------------------------------------------------------------------------

                 Key: CORE-5680
                 URL: http://tracker.firebirdsql.org/browse/CORE-5680
             Project: Firebird Core
          Issue Type: Bug
          Components: Charsets/Collation, Engine
    Affects Versions: 4.0 Alpha 1, 3.0.2, 2.5.7
            Reporter: Pavel Zotov


Create following script:
==================

shell del C:\MIX\firebird\QA\fbt-repo\tmp\c2284.fdb 2>nul;
create database 'localhost:C:\MIX\firebird\QA\fbt-repo\tmp\c2284.fdb' user 
'SYSDBA' password 'masterkey';
 
recreate table test_cs__detail(x int);
recreate table test_cs__master(x int);
commit;

set autoddl off;
recreate table test_cs__master (
    str_pk varchar(32) character set UTF8 not null, --------------------- [ 1 ]
    primary key (str_pk) using index test_s_master_pk
);
 
recreate table test_cs__detail (
    str_pk varchar(32) character set WIN1251 not null, ------------------ [ 2 ]
    foreign key (str_pk) references test_cs__master (str_pk)
);

set echo on;
 
commit;
rollback;

Console output:
=============

ISQL Version: WI-V3.0.3.32854 Firebird 3.0
Server version:
WI-V3.0.3.32854 Firebird 3.0
WI-V3.0.3.32854 Firebird 3.0/tcp (csprog)/P15:C
WI-V3.0.3.32854 Firebird 3.0/tcp (csprog)/P15:C

commit;
Statement failed, SQLSTATE = 08001
I/O error during "WriteFile" operation for file 
"C:\MIX\FIREBIRD\QA\FBT-REPO\TMP\C2284.FDB"
-Error while trying to write to file
-invalid descriptor // in national codepage
After line 19 in file crash-on-pk-fk-with-diff-cset.sql
rollback;
Statement failed, SQLSTATE = XX000
internal Firebird consistency check (can't continue after bugcheck)
After line 21 in file crash-on-pk-fk-with-diff-cset.sql
Statement failed, SQLSTATE = XX000
internal Firebird consistency check (can't continue after bugcheck)
After line 21 in file crash-on-pk-fk-with-diff-cset.sql
===


Note:
1. Both tables have to be created BEFORE 'recreate table' statement, i.e. they 
must already exist;
2. Charsets in PK and FK fields differ.
 
PS.

I thought that this bug is related to CORE-5677 or CORE-2284,  but after 
discussion with Vlal it was decided to create new ticket.
The same result on WI-V2.5.8.27083 and WI-T4.0.0.832 -- i.e. this bug is old 
enough.

firebird.log
=========
CSPROG  Thu Dec 14 20:49:31 2017
        Database: C:\MIX\FIREBIRD\QA\FBT-REPO\TMP\C2284.FDB
        internal Firebird consistency check (partner index description not 
found (175), file: idx.cpp line: 209)


CSPROG  Thu Dec 14 20:49:31 2017
        I/O error during "WriteFile" operation for file 
"C:\MIX\FIREBIRD\QA\FBT-REPO\TMP\C2284.FDB"
        Error while trying to write to file
        Неверный дескриптор. 


CSPROG  Thu Dec 14 20:49:31 2017
        Database: C:\MIX\FIREBIRD\QA\FBT-REPO\TMP\C2284.FDB
        I/O error during "WriteFile" operation for file 
"C:\MIX\FIREBIRD\QA\FBT-REPO\TMP\C2284.FDB"
        Error while trying to write to file
        Неверный дескриптор. 


CSPROG  Thu Dec 14 20:49:31 2017
        Database: C:\MIX\FIREBIRD\QA\FBT-REPO\TMP\C2284.FDB
        I/O error during "WriteFile" operation for file 
"C:\MIX\FIREBIRD\QA\FBT-REPO\TMP\C2284.FDB"
        Error while trying to write to file
        Неверный дескриптор. 


CSPROG  Thu Dec 14 20:49:31 2017
        INET/inet_error: read errno = 10054, server host = localhost, address = 
127.0.0.1/3400


CSPROG  Thu Dec 14 20:49:31 2017
        REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
        Uncommitted work may have been lost.
        Error writing data to the connection.
        send_packet/send


CSPROG  Thu Dec 14 20:49:31 2017
        setsockopt: error setting IPV6_V6ONLY to 0


-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: 
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

       

------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Reply via email to