You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
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
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.
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.
Submitted by: Pablo León (palevi)
Is related to QA614
Test done with flamerobin, though also fails from jaybird:
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)
Commits: 63dfdc5 0638fee e6941ec FirebirdSQL/fbt-repository@9884641 FirebirdSQL/fbt-repository@c1800f2
====== 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: CORE4739.
The text was updated successfully, but these errors were encountered: