Escaped double quotes don't work in json_to_xml

[jfneis]

SQL: select common_schema.json_to_xml('{"key":"ab"cd"}') Expected result: ab\cd Current result: NULL

The problem is in _get_json_token line 166, as substr won't find the "" char as it expects.

Don't know how to solve it yet.

[shlomi-noach]

FWIW I wrote these json_to_xml functions at a time when MySQL had no JSON support, but did have XML/Xpath support.

These days MySQL has good JSON function library. If possible, I'd advise using them.

[jfneis]

@shlomi-noach yeap, new mysql JSON features are in our backlog, but right now we have some legacy sheets that depend on XML, unfortunately. :(

thanks for pointing out!

[RaymondNijland]

@jfneis

Also {"key":"ab"cd"} isn't valid JSON format https://jsonlint.com/?json={%22key%22:%22ab%22cd%22}

{"key":"ab\"cd"} is valid JSON format and escaping. https://jsonlint.com/?json={%22key%22:%22ab%22cd%22}