Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
11.2.2
-
None
-
None
-
None
-
Centos 7
Description
I have wrong results when I use JSON_EXTRACT with "to last":
JSON_EXTRACT(`tree_idPath`, '$[3 to last]')
with a single row result it works, but if I have multiple rows something works something things go terribly wrong
in json_extract_example1.png you can see the problem with the records with tree_parentId = 11956
in json_extract_example2.png you can cry
in json_extract_example2-single-row.png you can see that everything seems to work fine if there is a single output row
if I use JSON_EXTRACT(`tree_idPath`, '$[3 to 123]') it works fine
bye!