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

The JSON_SET returns wrong result for empty object #59619

Closed
Tracked by #59410
YangKeao opened this issue Feb 18, 2025 · 0 comments · Fixed by #59687
Closed
Tracked by #59410

The JSON_SET returns wrong result for empty object #59619

YangKeao opened this issue Feb 18, 2025 · 0 comments · Fixed by #59687
Assignees
@YangKeao
Labels
affects-6.5 This bug affects the 6.5.x(LTS) versions. affects-7.1 This bug affects the 7.1.x(LTS) versions. affects-7.5 This bug affects the 7.5.x(LTS) versions. affects-8.1 This bug affects the 8.1.x(LTS) versions. affects-8.5 This bug affects the 8.5.x(LTS) versions. component/json severity/moderate sig/sql-infra SIG: SQL Infra type/bug The issue is confirmed as a bug.

Comments

@YangKeao
Copy link
Member

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

SELECT JSON_SET('{}', '$[last]', 'end')

2. What did you expect to see? (Required)

["\"end\""]

3. What did you see instead (Required)

["[{}, \"end\"]"]

4. What is your TiDB version? (Required)
@YangKeao YangKeao added component/json severity/major sig/sql-infra SIG: SQL Infra type/bug The issue is confirmed as a bug. labels Feb 18, 2025
@YangKeao YangKeao self-assigned this Feb 18, 2025
This was referenced Feb 18, 2025
Open
Merged
@YangKeao YangKeao added severity/moderate affects-6.5 This bug affects the 6.5.x(LTS) versions. affects-7.1 This bug affects the 7.1.x(LTS) versions. affects-7.5 This bug affects the 7.5.x(LTS) versions. affects-8.1 This bug affects the 8.1.x(LTS) versions. affects-8.5 This bug affects the 8.5.x(LTS) versions. and removed may-affects-5.4 This bug maybe affects 5.4.x versions. may-affects-6.1 may-affects-6.5 may-affects-7.1 may-affects-7.5 may-affects-8.1 may-affects-8.5 severity/major labels Feb 21, 2025
@ti-chi-bot ti-chi-bot bot closed this as completed in d93c233 Feb 24, 2025
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@YangKeao YangKeao

Labels
affects-6.5 This bug affects the 6.5.x(LTS) versions. affects-7.1 This bug affects the 7.1.x(LTS) versions. affects-7.5 This bug affects the 7.5.x(LTS) versions. affects-8.1 This bug affects the 8.1.x(LTS) versions. affects-8.5 This bug affects the 8.5.x(LTS) versions. component/json severity/moderate sig/sql-infra SIG: SQL Infra type/bug The issue is confirmed as a bug.
Projects
None yet
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

json: extract the $[last] entry from json object should also return itself YangKeao/tidb
1 participant
@YangKeao