[TRAFODION-2772] retrieve a value from Json string got an error: Json value is invalid

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Assignee: Yang, Yongfeng
• Reporter: Yang, Yongfeng
• Created: 12/Oct/17 03:13
• Updated: 07/Feb/18 17:31
• Resolved: 02/Feb/18 07:10

Description

>>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.
>>

Issue Links

• links to: GitHub Pull Request #1264
• links to: GitHub Pull Request #1264
• links to: GitHub Pull Request #1439