[ https://issues.apache.org/jira/browse/TRAFODION-2772?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16352142#comment-16352142 ]
ASF GitHub Bot commented on TRAFODION-2772: ------------------------------------------- GitHub user andyyangcn opened a pull request: https://github.com/apache/trafodion/pull/1439 [TRAFODION-2772] - retrieve a value from Json string got an error You can merge this pull request into a Git repository by running: $ git pull https://github.com/andyyangcn/incubator-trafodion fix3 Alternatively you can review and apply these changes as the patch at: https://github.com/apache/trafodion/pull/1439.patch To close this pull request, make a commit to your master/trunk branch with (at least) the following in the commit message: This closes #1439 ---- commit b2984e1ff96423d82ebd86d4e9a7e2beb6fb40d1 Author: Andy Yang <yongfeng.yang@...> Date: 2018-02-05T08:32:19Z [TRAFODION-2772] - retrieve a value from Json string got an error ---- > 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 > Priority: Major > > >>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 (v7.6.3#76005)