Skip to content
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

Incorrect error "Invalid token. Malformed string." with union + blob + non utf8 varchar #7176

Closed
EPluribusUnum opened this issue May 4, 2022 · 3 comments

Comments

@EPluribusUnum
Copy link

Hello!

CREATE TABLE test (TXT VARCHAR(10) CHARACTER SET WIN1250 COLLATE PXW_HUNDC)
INSERT INTO test(txt) VALUES ('öüóőúéáűí')

Run this select on a client with UTF8 charset

SELECT CAST(NULL AS BLOB SUB_TYPE 1) x
FROM rdb$database
UNION ALL
SELECT txt
FROM test

Invalid token.
Malformed string.
SQLCODE: -104
SQLSTATE: 22000
GDSCODE: 335544849

Server : FB 3.0.9
Client : Jaybird with charSet=UTF-8 in connstring, or IBExpert with UTF8

This works on FB25 as expected.

@asfernandes asfernandes self-assigned this May 4, 2022
@asfernandes asfernandes changed the title FB3 : Invalid token. Malformed string. (union + blob + non utf8 varchar) Incorrect error "Invalid token. Malformed string." with union + blob + non utf8 varchar May 5, 2022
@EPluribusUnum
Copy link
Author

This was fast, thank you! :)

@asfernandes , will it be backported to 3.0.10?

asfernandes added a commit that referenced this issue May 5, 2022
@asfernandes
Copy link
Member

This was fast, thank you! :)

@asfernandes , will it be backported to 3.0.10?

Must ask @dyemanov

asfernandes added a commit that referenced this issue May 5, 2022
@dyemanov
Copy link
Member

dyemanov commented May 6, 2022

The patch looks trivial, so I think it can be backported.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment