[MDEV-32287] JSON_EXTRACT not returning multiple values for same path - Jira

XML

Word

Printable

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Fixed
Affects Version/s: 10.4(EOL), 10.5, 10.6, 10.9(EOL), 10.10(EOL), 10.11, 11.0(EOL), 11.1(EOL), 11.2(EOL)
Fix Version/s: 10.5.25, 10.6.18, 10.11.8, 11.0.6, 11.1.5, 11.2.4, 11.4.2
Component/s: JSON
Labels:
None

MariaDB [(none)]> select JSON_EXTRACT("[1, 2, [30, 40]]", '$[2][1]', '$[2][1]');

+--------------------------------------------------------+

| JSON_EXTRACT("[1, 2, [30, 40]]", '$[2][1]', '$[2][1]') |

+--------------------------------------------------------+

| [40]                                                   |

+--------------------------------------------------------+

While MySQL:

+--------------------------------------------------------+

| JSON_EXTRACT("[1, 2, [30, 40]]", '$[2][1]', '$[2][1]') |

+--------------------------------------------------------+

| [40, 40]                                               |

+--------------------------------------------------------+

Documentation in our case says it should so I consider this a bug.

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.