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.

Sign up for GitHub

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

Jump to bottom

Fix json_array_get() function #2573

Closed
oneonestar opened this issue Jan 22, 2020 · 1 comment
Closed

Fix json_array_get() function #2573

oneonestar opened this issue Jan 22, 2020 · 1 comment

Comments

@oneonestar
Copy link
Member

According to the documentation, json_array_get() is broken:

The semantics of this function are broken. If the extracted element is a string, it will be converted into an invalid JSON value that is not properly quoted (the value will not be surrounded by quotes and any interior quotes will not be escaped).
We recommend against using this function. It cannot be fixed without impacting existing usages and may be removed in a future release.

We could fix the behavior of the existing functions, or create better functions to replace them.

Related to: #2446 (comment)
@oneonestar oneonestar mentioned this issue Jan 22, 2020
Merged
@hashhar
Copy link
Member

hashhar commented Sep 3, 2024

Now with SQL 2023 JSON functions we have better alternatives which are unaffected. Closing.

Feel free to reopen if still relevant.

@hashhar hashhar closed this as completed Sep 3, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@oneonestar @hashhar