You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "Yang, Yongfeng (JIRA)" <ji...@apache.org> on 2017/10/12 03:14:00 UTC
[jira] [Created] (TRAFODION-2772) retrieve a value from Json string
got an error: Json value is invalid
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)