Small difference in stored record using escape characters option

[Hooghof]

On identical input, the stored SQL record differs in the case the option escape characters is used.

Differences

Next

{"body":"abc\ndef"}

Development

{"body":"abc\ndef"}

Besides this the XML declaration of the retrieved record differs as well
Next:
Development:

Test flows
Instance: development and next
Tenant: Regression Tests
Flow: SQL_insert_mysql8_escaped

The expectation is that on identical input the stored data and the retrieved output are the same.

Next

Input

INSERT into transactions (timestamp,breadcrumb_id,server,tenant,environment,flow_id,flow_name,name,value) VALUES ('2026-08-05T15:11:30','24B409E44E68CD3-0000000000008F61','https://next.dovetail.world','Regression Tests','test','69b2d886dd4df80017000085','SQL_insert_mysql8_escaped','body','{"body":"abc\ndef"}')

Record

1 5 2026-08-05 15:11:30 24B409E44E68CD3-0000000000008F61 https:\/\/next.dovetail.world Regression Tests test 69b2d886dd4df80017000085 SQL_insert_mysql8_escaped body {\"body\":\"abc\\ndef\"}

Development

Input

INSERT into transactions (timestamp,breadcrumb_id,server,tenant,environment,flow_id,flow_name,name,value) VALUES ('2026-08-05T15:12:49','084B8E262FAC379-0000000000001C1E','https://development.dovetail.world','Regression Tests','test','693c493e0f32380007000866','SQL_insert_mysql8_escaped','body','{"body":"abc\ndef"}')

1 6 2026-08-05 15:12:49 084B8E262FAC379-0000000000001C1E https:\/\/development.dovetail.world Regression Tests test 693c493e0f32380007000866 SQL_insert_mysql8_escaped body {\"body\":\"abc\ndef\"}