New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Exception when upper casing string with lowercase y trema (code 0xFF in ISO8859_1 ) [CORE2912] #3296
Comments
Modified by: @asfernandesassignee: Adriano dos Santos Fernandes [ asfernandes ] |
Commented by: @asfernandes ISO8859_1 does not contains the LATIN CAPITAL LETTER Y WITH DIAERESIS (U+0178). So how could it work? This is needed for UPPER, and indirectly for CONTAINING too. |
Commented by: Mathias MOLLON (mmollon) You are right, but the functions (UPPER and CONTAINING) should not crash. |
Commented by: @asfernandes What is a "crash"? |
Commented by: @asfernandes v2.1 is not correct. Try this: upper('aÿb') -> Aÿb The function stops on ÿ and do not uppercase b. |
Commented by: Mathias MOLLON (mmollon) Q :What is a "crash" R : |
Commented by: Karsten Rolfs (solizell) This error also affect computed keys and version 2.5 (Build 26074). If a field contains a 'ÿ' and an index for a case-independent search should be created by: the error 'key size exceeds implementation restriction for index ... ' was thrown. |
Commented by: Siva Ramanathan (s2ramana) This problem is present in Firebird 2.5 as well. This seems to be important to fix. |
Modified by: @asfernandes |
Modified by: @asfernandes |
Modified by: @asfernandessummary: New in 2.1.3 : crash of upper with y trema (code 0xFF in ISO8859_1 ) => Exception when upper casing string with lowercase y trema (code 0xFF in ISO8859_1 ) |
Modified by: @asfernandesstatus: Open [ 1 ] => Resolved [ 5 ] resolution: Fixed [ 1 ] Fix Version: 3.0 Alpha 1 [ 10331 ] Fix Version: 2.5.3 [ 10461 ] Fix Version: 2.1.6 [ 10460 ] |
Submitted by: Mathias MOLLON (mmollon)
Relate to CORE4123
Is related to CORE1431
Is related to QA599
Votes: 1
Database open with FlameRobin with :
DIALECT=3
ISO8859_1
Database create with DEFAULTCHARSET=ISO8859_1
with Firebird 2.1.1 et 2.1.2
SELECT UPPER('ÿ') FROM TABLE --> OK
SELECT a.lib FROM TGROUPES a where lib containing 'Faÿ' ---> OK
with Firebird 2.1.3 and 2.1.4
SELECT UPPER('ÿ') FROM TABLE--> arithmetic exception, numeric overflow, or string truncation
SELECT a.lib FROM TGROUPES a where lib containing 'Faÿ' --> arithmetic exception, numeric overflow, or string truncation
by cons it works well with :
SELECT a.lib FROM TGROUPES a where lib STARTING With 'Faÿ' ---> OK
SELECT a.lib FROM TGROUPES a where lib LIKE 'Faÿ%' ---> OK
Commits: bf70f3f 3cc2513 91b8169 7232eff FirebirdSQL/fbt-repository@bc89d36 FirebirdSQL/fbt-repository@a0f16eb FirebirdSQL/fbt-repository@758d9b5
The text was updated successfully, but these errors were encountered: