Bug 697313

Summary:	Collation order can't be used for any character (UTF8,ISO8859_1) others not tested
Product:	[Fedora] Fedora	Reporter:	Oscar Kuchuk <oscar>
Component:	firebird	Assignee:	Philippe Makowski <makowski.fedora>
Status:	CLOSED ERRATA	QA Contact:	Fedora Extras Quality Assurance <extras-qa>
Severity:	urgent	Docs Contact:
Priority:	unspecified
Version:	14	CC:	dmn, makowski.fedora, srl
Target Milestone:	---
Target Release:	---
Hardware:	x86_64
OS:	Linux
Whiteboard:
Fixed In Version:	firebird-2.1.4.18393.0-3.fc14	Doc Type:	Bug Fix
Doc Text:		Story Points:	---
Clone Of:		Environment:
Last Closed:	2011-04-24 14:13:55 UTC	Type:	---
Regression:	---	Mount Type:	---
Documentation:	---	CRM:
Verified Versions:		Category:	---
oVirt Team:	---	RHEL 7.3 requirements from Atomic Host:
Cloudforms Team:	---	Target Upstream Version:
Embargoed:

Description Oscar Kuchuk 2011-04-17 17:38:27 UTC

Description of problem:
Collation order for columns don't work at all, can't restore database using collation for columns, cant even create a new table using collation orders, nor can execute select statemnts on those columns.


Version-Release number of selected component (if applicable):
firebird.x86_64,firebird-superserver.x86_64
Version:2.1.4.18393.0
Release:1.fc14

How reproducible:
1.-Open isql-fb
2.-Type:
create table xxx (name varchar(32) character set UTF8 collate UNICODE);

 
Actual results:
Error: COLLATION UNICODE for CHARACTER SET UTF8 is not defined


Expected results:
No error.

Additional info:
rpm from firebirdsql.org works ok.

Problem seems to be in version of icu libraries, original firebird rpm use version 3.0
fedora package uses 4
These are from FirebirdSS:
ldd /opt/firebird/bin/fbserver |grep icu
	libicuuc.so.30 => /opt/firebird/lib/libicuuc.so.30 (0x00007fe5e7b24000)
	libicudata.so.30 => /opt/firebird/lib/libicudata.so.30 (0x00007fe5e78a5000)
	libicui18n.so.30 => /opt/firebird/lib/libicui18n.so.30 (0x00007fe5e7720000)

Comment 1 Philippe Makowski 2011-04-18 18:48:42 UTC

The problem is icu > 4.2 (Fedora 14 have icu 4.4)
Fedora 13 package with icu 4.2 work without problem
I'll check with upstream to find a solution

Comment 2 Damyan Ivanov 2011-04-19 06:01:22 UTC

Same problem exists in Debian, which also uses ICU 4.4

Comment 3 Philippe Makowski 2011-04-19 06:02:35 UTC

reported upstream http://tracker.firebirdsql.org/browse/CORE-3447

Comment 4 Fedora Update System 2011-04-22 06:37:57 UTC

firebird-2.1.4.18393.0-3.fc14 has been submitted as an update for Fedora 14.
https://admin.fedoraproject.org/updates/firebird-2.1.4.18393.0-3.fc14

Comment 5 Fedora Update System 2011-04-22 07:42:53 UTC

firebird-2.5.0.26074.0-7.fc15 has been submitted as an update for Fedora 15.
https://admin.fedoraproject.org/updates/firebird-2.5.0.26074.0-7.fc15

Comment 6 Fedora Update System 2011-04-22 21:20:57 UTC

Package firebird-2.1.4.18393.0-3.fc14:
* should fix your issue,
* was pushed to the Fedora 14 testing repository,
* should be available at your local mirror within two days.
Update it with:
# su -c 'yum update --enablerepo=updates-testing firebird-2.1.4.18393.0-3.fc14'
as soon as you are able to.
Please go to the following url:
https://admin.fedoraproject.org/updates/firebird-2.1.4.18393.0-3.fc14
then log in and leave karma (feedback).

Comment 7 Oscar Kuchuk 2011-04-24 14:13:55 UTC

Databases need backup/restore to work properly with this fix.

Comment 8 Fedora Update System 2011-04-27 02:38:10 UTC

firebird-2.5.0.26074.0-7.fc15 has been pushed to the Fedora 15 stable repository.  If problems still persist, please make note of it in this bug report.

Comment 9 Fedora Update System 2011-04-30 23:22:06 UTC

firebird-2.1.4.18393.0-3.fc14 has been pushed to the Fedora 14 stable repository.  If problems still persist, please make note of it in this bug report.