[ 
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)

Reply via email to