Skip to content

Incorrect JSON_KEYS result on string constant #56788

@winoros

Description

@winoros

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

SELECT JSON_KEYS('[{"A": 1, "B": 2, "C": {"D": 3}},{"A": 1, "B": 2, "C": {"D": 3}}]', '$[last].C');

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

The result should be ["D"].

3. What did you see instead (Required)

NULL returned.

4. What is your TiDB version? (Required)

current master.

Metadata

Metadata

Assignees

Labels

affects-6.5This bug affects the 6.5.x(LTS) versions.affects-7.1This bug affects the 7.1.x(LTS) versions.affects-7.5This bug affects the 7.5.x(LTS) versions.affects-8.1This bug affects the 8.1.x(LTS) versions.affects-8.5This bug affects the 8.5.x(LTS) versions.impact/wrong-resultseverity/majorsig/executionSIG executiontype/bugThe issue is confirmed as a bug.type/regression

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions