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

changefeedccl: json feed double escapes null byte in string #123490

Open
asg0451 opened this issue May 2, 2024 · 1 comment
Open

changefeedccl: json feed double escapes null byte in string #123490

asg0451 opened this issue May 2, 2024 · 1 comment
Labels
A-cdc Change Data Capture C-bug Code not up to spec/doc, specs & docs deemed correct. Solution expected to change code/behavior. T-cdc

Comments

@asg0451
Copy link
Contributor

asg0451 commented May 2, 2024

Describe the problem

Please describe the issue you observed, and any steps we can take to reproduce it:

a json changefeed will double escape a null byte in a string as "\\x00" instead of "\u0000"

To Reproduce

create table stuff ( id string PRIMARY KEY,  data jsonb);
CREATE CHANGEFEED FOR TABLE stuff INTO '...'    WITH updated, resolved, format = json;
insert into stuff (id, data) values ('\000'::bytea::string, '{"a": 42}'::jsonb);

# observe the output in your sink of choice

Jira issue: CRDB-38376

@asg0451 asg0451 added C-bug Code not up to spec/doc, specs & docs deemed correct. Solution expected to change code/behavior. A-cdc Change Data Capture T-cdc labels May 2, 2024
Copy link

blathers-crl bot commented May 2, 2024

cc @cockroachdb/cdc

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
A-cdc Change Data Capture C-bug Code not up to spec/doc, specs & docs deemed correct. Solution expected to change code/behavior. T-cdc
Projects
None yet
Development

No branches or pull requests

1 participant