replace funcion with utf-8 extrange behaviour
---------------------------------------------
Key: CORE-4599
URL: http://tracker.firebirdsql.org/browse/CORE-4599
Project: Firebird Core
Issue Type: Bug
Components: Charsets/Collation
Affects Versions: 2.5.3
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;
Reporter: Pablo León
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)
--
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
------------------------------------------------------------------------------
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
