Wrong error message - "string right truncation. expected length 30, actual 30."

[EPluribusUnum]

Hi!

"Arithmetic overflow or division by zero has occurred.
arithmetic exception, numeric overflow, or string truncation.
string right truncation.
expected length 30, actual 30.

SQLCODE: -802
SQLSTATE: 22001
GDSCODE: 335544321"

I don't have a simple test case, but I can send the database on request.
I want to insert logger value than 30 via complex insert-select.
Firebird 3.0.9

[asfernandes]

Did you also tested v4?

[EPluribusUnum]

@asfernandes , yes its also an issue on v4.

[asfernandes]

Please send the database (link) and the way to test it for me: adrianosf at gmail.com

[EPluribusUnum]

@asfernandes , the mail was send with the details.

Thank You!

[asfernandes]

Simple test case:

select cast(_win1252 '12345' collate win_ptbr as varchar(4) character set win1252) from rdb$database;

[asfernandes]

Here is more problematic cases:

select cast(_utf8 '1234ç' as varchar(4) character set win1252) from rdb$database;

select cast(_win1252 '12345678901234567890' as varchar(4) character set utf8) from rdb$database;

select cast(_utf8 '1234 ' as varchar(4) character set win1252) from rdb$database;

select cast(_utf8 '1234                ' as varchar(4) character set win1252) from rdb$database;

select cast(_win1252 '1234 ' as varchar(4) character set utf8) from rdb$database;

select cast(_win1252 '1234                ' as varchar(4) character set utf8) from rdb$database;

select cast(_none '12345678ç' as varchar(2) character set utf8) from rdb$database;

select cast(_none '1234567ç8' as varchar(2) character set utf8) from rdb$database;

select cast(_none '1234ç' as varchar(4) character set utf8) from rdb$database;

select cast(_none '1234ç' as char(4) character set utf8) from rdb$database;

select cast(_none '1234ç' as varchar(4) character set win1252) from rdb$database;

select cast(_none '1234ç' as char(4) character set win1252) from rdb$database;