Skip to content
New issue

Have a question about this project? # for a free GitHub account to open an issue and contact its maintainers and the community.

#

By clicking “#”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? # to your account

Jump to bottom

JSON/Sqlite: use -> and ->> where possible when traversing JSON, rather than json_extract #30334

Closed
maumar opened this issue Feb 24, 2023 · 2 comments · Fixed by #30745
Closed

JSON/Sqlite: use -> and ->> where possible when traversing JSON, rather than json_extract #30334

maumar opened this issue Feb 24, 2023 · 2 comments · Fixed by #30745
Assignees
@roji
Labels
area-json area-sqlite closed-fixed The issue has been fixed and is/will be included in the release indicated by the issue milestone. type-enhancement
Milestone
8.0.0

Comments

@maumar
Copy link
Contributor

maumar commented Feb 24, 2023

We use json_extract function to access parts of JSON, but we could/should use -> and ->>
@ajcvickers ajcvickers added this to the Backlog milestone Mar 2, 2023
@AndriySvyryd
Copy link
Member

Related to #30724

@roji
Copy link
Member

roji commented Apr 22, 2023

@maumar looked at this while working on #30724, so poaching... Hope that's ok.

@roji roji assigned roji and unassigned maumar Apr 22, 2023
roji added a commit to roji/efcore that referenced this issue Apr 23, 2023
@roji
Use -> operator for SQLite JsonScalarExpression
f88abe0 
Closes dotnet#30334
@roji roji mentioned this issue Apr 23, 2023
Merged
@roji roji added the closed-fixed The issue has been fixed and is/will be included in the release indicated by the issue milestone. label Apr 23, 2023
@roji roji modified the milestones: Backlog, 8.0.0 Apr 23, 2023
roji added a commit to roji/efcore that referenced this issue Apr 23, 2023
@roji
Use -> operator for SQLite JsonScalarExpression
9e11acc 
Closes dotnet#30334
roji added a commit to roji/efcore that referenced this issue Apr 25, 2023
@roji
Use -> operator for SQLite JsonScalarExpression
df4b06c 
Closes dotnet#30334
@ajcvickers ajcvickers modified the milestones: 8.0.0, 8.0.0-preview4 Apr 25, 2023
@ajcvickers ajcvickers mentioned this issue Apr 27, 2023
Closed
@roji roji mentioned this issue May 14, 2023
Closed
@ajcvickers ajcvickers modified the milestones: 8.0.0-preview4, 8.0.0 Nov 14, 2023
# for free to join this conversation on GitHub. Already have an account? # to comment
Assignees

@roji roji

Labels
area-json area-sqlite closed-fixed The issue has been fixed and is/will be included in the release indicated by the issue milestone. type-enhancement
Projects
None yet
Milestone
8.0.0
Development

Successfully merging a pull request may close this issue.

Use -> operator for SQLite JsonScalarExpression roji/efcore
4 participants
@ajcvickers @maumar @roji @AndriySvyryd