[
https://issues.apache.org/jira/browse/CALCITE-6037?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Ran Tao updated CALCITE-6037:
-----------------------------
Description:
Currently some functions do not specify a category name.
It will cause the error function category:
||function name||current category||desired category||
|ARRAY (Spark)|Numeric|System|
|EXTRACT_VALUE (MySQL)|Numeric|String|
|XML_TRANSFORM (Oracle)|Numeric|String|
|EXTRACT_XML (Oracle)|Numeric|String|
|EXISTSNODE (Oracle)|Numeric|String|
the definition of function category in ANSI-SQL can be found at:
http://users.atw.hu/sqlnut/sqlnut2-chp-4-sect-4.html#sqlnut2-CHP-4-SECT-4.1
Because they use a simplified constructor of SqlBasicFunction, the function
category is always set to Numeric. We need to set the desired function category.
was:
Currently some functions do not specify a category name.
It will cause the error function category:
||function name||current category||desired category||
|ARRAY (Spark)|Numeric|System|
|EXTRACT_VALUE (MySQL)|Numeric|String|
|XML_TRANSFORM (Oracle)|Numeric|String|
|EXTRACT_XML (Oracle)|Numeric|String|
|EXISTSNODE (Oracle)|Numeric|String|
the definition of function category in ANSI-SQL can be found at:
[https://www.oreilly.com/library/view/sql-in-a/9780596155322/ch04s04.html.|http://users.atw.hu/sqlnut/sqlnut2-chp-4-sect-4.html#sqlnut2-CHP-4-SECT-4.1]
Because they use a simplified constructor of SqlBasicFunction, the function
category is always set to Numeric. We need to set the desired function category.
> The function category of ARRAY/EXTRACT_VALUE/XML_TRANSFORM/EXTRACT/EXISTSNODE
> is incorrect
> ------------------------------------------------------------------------------------------
>
> Key: CALCITE-6037
> URL: https://issues.apache.org/jira/browse/CALCITE-6037
> Project: Calcite
> Issue Type: Bug
> Components: core
> Affects Versions: 1.35.0
> Reporter: Ran Tao
> Assignee: Ran Tao
> Priority: Major
> Labels: pull-request-available
> Fix For: 1.36.0
>
>
> Currently some functions do not specify a category name.
> It will cause the error function category:
>
> ||function name||current category||desired category||
> |ARRAY (Spark)|Numeric|System|
> |EXTRACT_VALUE (MySQL)|Numeric|String|
> |XML_TRANSFORM (Oracle)|Numeric|String|
> |EXTRACT_XML (Oracle)|Numeric|String|
> |EXISTSNODE (Oracle)|Numeric|String|
> the definition of function category in ANSI-SQL can be found at:
> http://users.atw.hu/sqlnut/sqlnut2-chp-4-sect-4.html#sqlnut2-CHP-4-SECT-4.1
> Because they use a simplified constructor of SqlBasicFunction, the function
> category is always set to Numeric. We need to set the desired function
> category.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
