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

Aliased blob variable with less restrictions makes text blob accept malformed string through BLOB_APPEND #7380

Closed
asfernandes opened this issue Nov 6, 2022 · 0 comments

Comments

@asfernandes
Copy link
Member

-- Wrong: no "Malformed string" error
execute block
as
    declare b blob sub_type text character set utf8;
    declare bb blob sub_type binary;
begin
    b = blob_append(b, 'a');
    bb = b;
    -- No error
    b = blob_append(bb, x'FF');
    -- Malformed blob is saved to table
    insert into t (b_utf8) values (:b);
end!
@asfernandes asfernandes changed the title Aliased blob variable with less restrictions makes text blob accept malformed string Aliased blob variable with less restrictions makes text blob accept malformed string through BLOB_APPEND Nov 6, 2022
@hvlad hvlad self-assigned this Nov 11, 2022
hvlad added a commit that referenced this issue Nov 11, 2022
#7379: BLOB_APPEND with existing blob accepts malformed string, and
#7380: Aliased blob variable with less restrictions makes text blob accept malformed string through BLOB_APPEND
hvlad added a commit that referenced this issue Nov 22, 2022
#7379: BLOB_APPEND with existing blob accepts malformed string, and
#7380: Aliased blob variable with less restrictions makes text blob accept malformed string through BLOB_APPEND
@hvlad hvlad closed this as completed Nov 22, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment