[
https://issues.apache.org/jira/browse/CALCITE-3139?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Forward Xu updated CALCITE-3139:
--------------------------------
Issue Type: Sub-task (was: New Feature)
Parent: CALCITE-2867
> Implement JSON_EXTRACT function
> -------------------------------
>
> Key: CALCITE-3139
> URL: https://issues.apache.org/jira/browse/CALCITE-3139
> Project: Calcite
> Issue Type: Sub-task
> Reporter: Forward Xu
> Assignee: Forward Xu
> Priority: Major
>
> [{{JSON_EXTRACT(_{{json_doc}}_, _{{path}}_[, _{{path}}_]
> ...)}}|https://dev.mysql.com/doc/refman/8.0/en/json-search-functions.html#function_json-extract]
> Returns data from a JSON document, selected from the parts of the document
> matched by the _{{path}}_ arguments. Returns {{NULL}} if any argument is
> {{NULL}} or no paths locate a value in the document. An error occurs if the
> _{{json_doc}}_ argument is not a valid JSON document or any _{{path}}_
> argument is not a valid path expression.
> The return value consists of all values matched by the _{{path}}_ arguments.
> If it is possible that those arguments could return multiple values, the
> matched values are autowrapped as an array, in the order corresponding to the
> paths that produced them. Otherwise, the return value is the single matched
> value.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
