We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see our documentation.
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
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.
The text was updated successfully, but these errors were encountered:
FWIW I wrote these json_to_xml functions at a time when MySQL had no JSON support, but did have XML/Xpath support.
json_to_xml
JSON
These days MySQL has good JSON function library. If possible, I'd advise using them.
Sorry, something went wrong.
@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!
@jfneis
Also {"key":"ab"cd"} isn't valid JSON format https://jsonlint.com/?json={%22key%22:%22ab%22cd%22}
{"key":"ab"cd"}
{"key":"ab\"cd"} is valid JSON format and escaping. https://jsonlint.com/?json={%22key%22:%22ab\%22cd%22}
{"key":"ab\"cd"}
No branches or pull requests
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.
The text was updated successfully, but these errors were encountered: