Skip to content

Bug Report: JSON SQL marshaling does not escape keys properly #14065

@dbussink

Description

@dbussink

Overview of the Issue

Marshalling the following JSON document to SQL doesn't escape the key properly:

{"key with ' in it": []}

Leads to:

JSON_OBJECT(_utf8mb4'key with ' in it', JSON_ARRAY())

instead of:

JSON_OBJECT(_utf8mb4'key with \' in it', JSON_ARRAY())

Reproduction Steps

Binary Version

-

Operating System and Environment details

-

Log Fragments

No response

Metadata

Metadata

Assignees

No one assigned

    Type

    No type
    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions