You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "liu ming (JIRA)" <ji...@apache.org> on 2016/10/14 06:44:20 UTC
[jira] [Updated] (TRAFODION-2227) support JSON handling functions
[ https://issues.apache.org/jira/browse/TRAFODION-2227?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
liu ming updated TRAFODION-2227:
--------------------------------
Assignee: Yang, Yongfeng (was: 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: Yang, Yongfeng
>
> 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)