Details
-
Bug
-
Status: Closed (View Workflow)
-
Blocker
-
Resolution: Fixed
-
10.11, 11.4, 11.8, 12.2.2
-
built from source on linux.
-
Can result in unexpected behaviour
-
JSON_VALUE should not allow wildcard in the path since it is not supposed to return multiple values as per json standards.
-
Q1/2026 Server Development
Description
MariaDB 12.2.2-MariaDB> SELECT JSON_VALUE('{"a": 1}', '$.*');
|
+-------------------------------+
|
| JSON_VALUE('{"a": 1}', '$.*') |
|
+-------------------------------+
|
| NULL |
|
+-------------------------------+
|
1 row in set (0,01 sec)
|
Used to be fine on 12.1.2:
MariaDB 12.1.2-MariaDB> SELECT JSON_VALUE('{"a": 1}', '$.*');
|
+-------------------------------+
|
| JSON_VALUE('{"a": 1}', '$.*') |
|
+-------------------------------+
|
| 1 |
|
+-------------------------------+
|
1 row in set (0,01 sec)
|
I think there might be some more related JSON path incompatibilities.
Attachments
Issue Links
- is caused by
-
-
- Closed
-