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
-
Activity
| Transition | Time In Source Status | Execution Times |
|---|
|
10d 1h 49m | 1 |
|
101d 20h 29m | 1 |
|
6h 55m | 1 |