[ https://issues.apache.org/jira/browse/TRAFODION-2227?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
liu ming reassigned TRAFODION-2227: ----------------------------------- Assignee: liu ming > support JSON handling functions > ------------------------------- > > Key: TRAFODION-2227 > URL: https://issues.apache.org/jira/browse/TRAFODION-2227 > Project: Apache Trafodion > Issue Type: Sub-task > Reporter: liu ming > Assignee: liu ming > > A lot of database provide built-in function to manipulate with JSON string. > MySQL provide good template, this JIRA is created to track the supporting of > all following MySQL functions: > JSON_APPEND() Append data to JSON document > JSON_ARRAY() Create JSON array > JSON_ARRAY_APPEND() Append data to JSON document > JSON_ARRAY_INSERT() Insert into JSON array > JSON_CONTAINS() Whether JSON document contains specific > object at path > JSON_CONTAINS_PATH() Whether JSON document contains any data at path > JSON_DEPTH() Maximum depth of JSON document > JSON_EXTRACT() Return data from JSON document > JSON_INSERT() Insert data into JSON document > JSON_KEYS() Array of keys from JSON document > JSON_LENGTH() Number of elements in JSON document > JSON_MERGE() Merge JSON documents > JSON_OBJECT() Create JSON object > JSON_QUOTE() Quote JSON document > JSON_REMOVE() Remove data from JSON document > JSON_REPLACE() Replace values in JSON document > JSON_SEARCH() Path to value within JSON document > JSON_SET() Insert data into JSON document > JSON_TYPE() Type of JSON value > JSON_UNQUOTE() Unquote JSON value > JSON_VALID() Whether JSON value is valid > Not all of them must be implemented -- This message was sent by Atlassian JIRA (v6.3.4#6332)