Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.2, 10.3, 10.4
-
None
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).