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
When I compile such procedure (below) exception is thrown:
"Arithmetic overflow or division by zero has occurred.
arithmetic exception, numeric overflow, or string truncation.
Cannot transliterate character between character sets.
"
I tested:
2.0.7: OK
2.1.5: exception
2.5.2: exception
If I remove (comment): str=str||char_one_byte; procedure is created/altered, so problem is with operation || for DOS864 charset. Other DOS charsets: OK.
CREATE OR ALTER PROCEDURE tmp_SYS_CONV_UTF8_D864_1000
AS
declare variable char_one_byte char(1) character set DOS864;
declare variable STR VARCHAR(1000) CHARACTER SET DOS864;
begin
Confirmed for 2.1.7:
Statement failed, SQLCODE = -802
arithmetic exception, numeric overflow, or string truncation
-Cannot transliterate character between character sets
The text was updated successfully, but these errors were encountered:
Test Details: Confirmed for 2.1.7:
Statement failed, SQLCODE = -802
arithmetic exception, numeric overflow, or string truncation
-Cannot transliterate character between character sets
Submitted by: Tomasz Kujalow (tkujalow)
Is related to QA531
When I compile such procedure (below) exception is thrown:
"Arithmetic overflow or division by zero has occurred.
arithmetic exception, numeric overflow, or string truncation.
Cannot transliterate character between character sets.
"
I tested:
2.0.7: OK
2.1.5: exception
2.5.2: exception
If I remove (comment): str=str||char_one_byte; procedure is created/altered, so problem is with operation || for DOS864 charset. Other DOS charsets: OK.
CREATE OR ALTER PROCEDURE tmp_SYS_CONV_UTF8_D864_1000
AS
declare variable char_one_byte char(1) character set DOS864;
declare variable STR VARCHAR(1000) CHARACTER SET DOS864;
begin
char_one_byte='A';
str='B';
str=str||char_one_byte;
--
end;
Commits: 51b0d1a d699c7c FirebirdSQL/fbt-repository@cdf2d4c FirebirdSQL/fbt-repository@c2f4978
====== Test Details ======
Confirmed for 2.1.7:
Statement failed, SQLCODE = -802
arithmetic exception, numeric overflow, or string truncation
-Cannot transliterate character between character sets
The text was updated successfully, but these errors were encountered: