Yang, Yongfeng created TRAFODION-2772:
-----------------------------------------
Summary: retrieve a value from Json string got an error: Json
value is invalid
Key: TRAFODION-2772
URL: https://issues.apache.org/jira/browse/TRAFODION-2772
Project: Apache Trafodion
Issue Type: Bug
Reporter: Yang, Yongfeng
Assignee: Yang, Yongfeng
>>create table json(str varchar(200));
>>select json_object_field_text('{"f2":1}', 'f2') from json;
*** ERROR[8971] JSON value is invalid.
--- 0 row(s) selected.
>>
the expected result should like below.
>>select json_object_field_text('{"f2":1}', 'f2') from (values(1)) T;
(EXPR)
--------
1
--- 1 row(s) selected.
>>
>>select json_object_field_text('{"f2":1}', 'f2') from (values(1)) T;
(EXPR)
--------
1
--- 1 row(s) selected.
>>
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
