Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.2.6
-
None
-
Windows 10
Description
It seems that JSON functions fail to get returned result from another function:
select json_extract(json_object('truc',json_array('machin',4,json_object('chose','XML'))),'$.truc[2].chose') as result;
|
+--------+
|
| result |
|
+--------+
|
| "XML" |
|
+--------+
|
|
|
select json_search(json_object('truc',json_array('machin',4,json_object('chose','XML'))),'one','XML') as Path;
|
+-------------------+
|
| Path |
|
+-------------------+
|
| "$.truc[2].chose" |
|
+-------------------+
|
|
|
select json_extract(json_object('truc',json_array('machin',4,json_object('chose','XML'))),json_search(json_object('truc',json_array('machin',4,json_object('chose','XML'))),'one','XML')) as Result;
|
+--------+
|
| Result |
|
+--------+
|
| NULL |
|
+--------+
|
Sould not the last query return "XML"?
Attachments
Issue Links
- relates to
-
-
- Closed
-