Issue Details (XML | Word | Printable)

Key: CORE-4571
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Major Major
Assignee: Alexander Peshkov
Reporter: Pavel Zotov
Votes: 0
Watchers: 3
Operations

If you were logged in you would be able to see more operations.
Firebird Core

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

Created: 07/Oct/14 06:00 PM   Updated: 21/Dec/15 07:39 PM
Component/s: None
Affects Version/s: 3.0 Alpha 2
Fix Version/s: 3.0 Beta 2

QA Status: Done successfully
Test Specifics: Platform (Windows/Linux) specific


 Description  « Hide
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



 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
There are no subversion log entries for this issue yet.