Can't select from table with ICU column when database (.FDB) is created on
LINUX with icu 4.2.1 and then copied to WINDOWS
--------------------------------------------------------------------------------------------------------------------------
Key: CORE-4571
URL: http://tracker.firebirdsql.org/browse/CORE-4571
Project: Firebird Core
Issue Type: Bug
Affects Versions: 3.0 Alpha 2
Reporter: Pavel Zotov
On Linux, empty database:
create collation nums_coll for utf8 from unicode case insensitive
'NUMERIC-SORT=1';
commit;
create domain dm_nums as varchar(20) character set utf8 collate nums_coll;
commit;
create table wares(
id bigint generated by default as identity constraint pk_wares primary key
using index pk_wares
,numb dm_nums
,constraint wares_numb_unq unique(numb) using index wares_numb_unq
);
commit;
exit;
Then make copy .FDB (not .FBK) to Windows machine and run there ISQL with
attach to this database - no problem, it is opened OK.
Then: select * from wares;
Result:
SQL> select * from wares;
Statement failed, SQLSTATE = 22021
COLLATION NUMS_COLL for CHARACTER SET UTF8 is not installed
PS.
On linux:
1) $ rpm -qa | grep icu
icu4j-eclipse-4.2.1-5.el6.x86_64
libicu-4.2.1-9.1.el6_2.x86_64
2) ISQL Version: LI-T3.0.0.31353 Firebird 3.0 Alpha 2
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-T3.0.0.31353 Firebird
3.0 Alpha 2"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-T3.0.0.31353 Firebird
3.0 Alpha 2/tcp (oel64)/P13"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-T3.0.0.31353
Firebird 3.0 Alpha 2/tcp (oel64)/P13"
on disk structure version 12.0
On windows:
1) ICU is supplied in FB snaphot, 5.2
2) ISQL Version: WI-T3.0.0.31353 Firebird 3.0 Alpha 2
Server version:
Firebird/Windows/Intel/i386 (access method), version "WI-T3.0.0.31353 Firebird
3.0 Alpha 2"
Firebird/Windows/Intel/i386 (remote server), version "WI-T3.0.0.31353 Firebird
3.0 Alpha 2/tcp (IT_test)/P13"
Firebird/Windows/Intel/i386 (remote interface), version "WI-T3.0.0.31353
Firebird 3.0 Alpha 2/tcp (IT_test)/P13"
on disk structure version 12.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
------------------------------------------------------------------------------
Meet PCI DSS 3.0 Compliance Requirements with EventLog Analyzer
Achieve PCI DSS 3.0 Compliant Status with Out-of-the-box PCI DSS Reports
Are you Audit-Ready for PCI DSS 3.0 Compliance? Download White paper
Comply to PCI DSS 3.0 Requirement 10 and 11.5 with EventLog Analyzer
http://pubads.g.doubleclick.net/gampad/clk?id=154622311&iu=/4140/ostg.clktrk
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
