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

JSON/Query: optimize casts to nvarchar(max) in json queries where possible #29267

Closed
maumar opened this issue Oct 5, 2022 · 1 comment
Closed

JSON/Query: optimize casts to nvarchar(max) in json queries where possible #29267

maumar opened this issue Oct 5, 2022 · 1 comment
Labels
closed-duplicate

Comments

@maumar
Copy link
Contributor

maumar commented Oct 5, 2022

We always cast to a type when we extract value from json column using JSON_VALUE, we possibly could skip the cast for stuff like strings
@ajcvickers ajcvickers added this to the Backlog milestone Oct 5, 2022
@maumar
Copy link
Contributor Author

maumar commented Oct 7, 2022

closing in favor of #28881

@maumar maumar closed this as completed Oct 7, 2022
@maumar maumar removed this from the Backlog milestone Oct 7, 2022
@ajcvickers ajcvickers closed this as not planned Won't fix, can't repro, duplicate, stale Oct 7, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
closed-duplicate
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@ajcvickers @maumar