Details
Description
set @json_doc3 =
|
'
|
{
|
"root": {
|
"child1" : {
|
"child2" : {
|
"child1" : {
|
"x":124
|
}
|
}
|
}
|
}
|
}
|
';
|
MariaDB [test]> select json_extract(@json_doc3, '$**.child1**.x');
|
+--------------------------------------------+
|
| json_extract(@json_doc3, '$**.child1**.x') |
|
+--------------------------------------------+
|
| NULL |
|
+--------------------------------------------+
|
This should not return NULL.
One can debate whether this should return the value of x once (because the document has just one x node) or twice (because there are two ways to match the pattern).
Attachments
Issue Links
- duplicates
-
MDEV-15322 JSON_VALUE and JSON_QUERY don't handle wildcards in path
-
- Confirmed
-
-
-
- Open
-