FB3 - crash (consistency check) when creating view on table which has column with character set none, database default charset is utf8, and utf8 default collation is 'unicode'. --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Key: CORE-5448 URL: http://tracker.firebirdsql.org/browse/CORE-5448 Project: Firebird Core Issue Type: Bug Components: Engine Affects Versions: 3.0.1 Environment: Linux mint 18.1, 64 bit, but tested also on Windows 7 32 bit, and it seems to be there too. Reporter: Zoran Vučenović Please do the following for steps in FB 3.0.1: /* 1. Create new database and set utf8 to be the default char set (change db path to whatever you want, in my example "test1" is an alias defined in database.conf) */ create database 'inet://localhost/test1' default character set utf8; /* 2. set default collation of utf8 to be unicode */ alter character set utf8 set default collation unicode; /* 3. create table with a field which has character set none */ create table table1 ( fld1 char(1) character set none ); /* 4. Now, try to create view which reads this field */ create view view1 as select fld1 from table1 ; After this, you get: Statement failed, SQLSTATE = XX000 internal Firebird consistency check (pointer page lost from DPM_delete_relation (246), file: dpm.cpp line: 1159) And database seems to be corrupted afterwards. There is no such problem with FB 2.5. I am prepairing to migrate my databases to FB 3, but because of this bug, I'm still remaining on 2.5.6. -- 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 ------------------------------------------------------------------------------ Developer Access Program for Intel Xeon Phi Processors Access to Intel Xeon Phi processor-based developer platforms. With one year of Intel Parallel Studio XE. Training and support from Colfax. Order your platform today. http://sdm.link/xeonphi Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel