On the second thought, i decided to do it like MySQL does.
There is a value of "124" and it's patch fits the specification, so we
return it.
No need to do it twice.
Are you ok with that?
HF/
On Fri, Nov 20, 2020 at 12:18 AM Sergey Petrunia wrote:
> Hi Alexey,
>
> I've found this discrepancy i
Hi, Sergey.
To me the XPath version seems correct here. So both we and MySQL are wrong.
Though the JSON_Extract function is the MySQL-s invention so it's tempting
to
make it working like they do.
So i'm in doubt how to fix this.
A.
On Fri, Nov 20, 2020 at 12:18 AM Sergey Petrunia wrote:
> Hi A
Hi Alexey,
I've found this discrepancy in JSONPath evaluation:
set @json_doc3 =
'
{
"root": {
"child1" : {
"child2" : {
"child1" : {
"x":124
}
}
}
}
}
';
select json_extract(@json_doc3, '$**.child1**.x');
MariaDB [test]> select json_
3 matches
Mail list logo
