Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.4.7
-
None
Description
In SQL/JSON Path lax mode (default), the array accessor [...] as well as the wildcard array accessor [*] wrap non-array values (SQL-2:2016 9.39 General Rule 11 g 3 A and 4 A).
MariaDB only wraps for the regular array accessor:
MariaDB 5.5.5-10.4.7-MariaDB> select json_value('{"a": 1}', '$.a[0]');
|
+----------------------------------+
|
| json_value('{"a": 1}', '$.a[0]') |
|
+----------------------------------+
|
| 1 |
|
+----------------------------------+
|
1 row in set (0.00 sec)
|
 |
MariaDB 5.5.5-10.4.7-MariaDB> select json_value('{"a": 1}', '$.a[*]');
|
+----------------------------------+
|
| json_value('{"a": 1}', '$.a[*]') |
|
+----------------------------------+
|
| NULL |
|
+----------------------------------+
|
1 row in set (0.00 sec)
|