[MDEV-32287] JSON_EXTRACT not returning multiple values for same path Created: 2023-09-29  Updated: 2023-11-28

Status: Open
Project: MariaDB Server
Component/s: JSON
Affects Version/s: 10.4, 10.5, 10.6, 10.9, 10.10, 10.11, 11.0, 11.1, 11.2
Fix Version/s: 10.4, 10.5, 10.6, 10.11, 11.0, 11.1

Type: Bug Priority: Major
Reporter: Vicențiu Ciorbaru Assignee: Rucha Deodhar
Resolution: Unresolved Votes: 0
Labels: None


 Description    

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.
Generated at Thu Feb 08 10:30:14 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.