Issue Details (XML | Word | Printable)

Key: CORE-4599
Type: Bug Bug
Status: Resolved Resolved
Resolution: Fixed
Priority: Major Major
Assignee: Adriano dos Santos Fernandes
Reporter: Pablo León
Votes: 0
Watchers: 4
Operations

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

REPLACE function works incorrectly with multibyte charsets

Created: 07/Nov/14 01:39 PM   Updated: 25/Sep/15 01:15 PM
Component/s: Charsets/Collation
Affects Version/s: 2.5.3
Fix Version/s: 2.5.4, 3.0 Beta 2

Environment:
windows7 and linux centos 6.5. Database creation script is:

create database "localhost:alias"
user "username"
password "*****"
page_size 16384
default character set utf8
collation unicode_ci_ai;
Issue Links:
Relate
 

QA Status: Done with caveats
Test Details:
Integral test for comparison latin-1 characters with diacritical marks and their ascii-equivalents, all kinds of string matchin.
NOTE: following are letters which currently do NOT pass comparison using accent insensitive collation:
Ø = U+00D8 // LATIN CAPITAL LETTER O WITH STROKE' (U+00D8), used in danish & iceland alphabets;
Ð = U+00D0 // LATIN CAPITAL LETTER ETH' (U+00D0), iceland
Ŀ = U+013F // LATIN CAPITAL LETTER L WITH MIDDLE DOT' (U+013F), catalone (valencian)
Ł = U+0141 // LATIN CAPITAL LETTER L WITH STROKE' (U+0141), polish.

See also: CORE-4739.


 Description  « Hide
Test done with flamerobin, though also fails from jaybird:

    recreate table test1 (field1 varchar(50));

    insert into test1 values ('PABLO NUÑEZ SANCHEZ');

    update test1 set field1=replace(field1,'Ñ','N');

    select * from test1;

and you obtain "PABLO NÑN SANCNZ" instead of expected "PABLO NUNEZ SANCHEZ". I other situations we obtain an OOM error from firebird or even get a server crash, here is server log:

PALEVI-XPS (Server) Fri Nov 07 13:10:53 2014
Access violation.
The code attempted to access a virtual
address without privilege to do so.
This exception will cause the Firebird server
to terminate abnormally.


PALEVI-XPS (Server) Fri Nov 07 13:10:53 2014
Shutting down the server with 1 active connection(s) to 1 database(s), 0 active service(s)


PALEVI-XPS (Server) Fri Nov 07 13:10:58 2014
Firebird shutdown is still in progress after the specified timeout


PALEVI-XPS (Server) Fri Nov 07 13:10:58 2014
Operating system call ReleaseSemaphore failed. Error code 6


PALEVI-XPS (Server) Fri Nov 07 13:10:58 2014
Operating system call ReleaseSemaphore failed. Error code 6


PALEVI-XPS (Client) Fri Nov 07 13:10:58 2014
"C:\Program Files\Firebird\Firebird_2_5\bin\fbserver.exe": terminated abnormally (4294967295)



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