[jira] (CALCITE-6037) The function category of ARRAY/EXTRACT_VALUE/XML_TRANSFORM/EXTRACT/EXISTSNODE is incorrect

["Ran Tao (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/CALCITE-6037 ]


    Ran Tao deleted comment on CALCITE-6037:
    ----------------------------------

was (Author: lemonjing):
By checking the code, only these functions have been found so far.

> 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|Numeric|System|
> |EXTRACT_VALUE|Numeric|String|
> |XML_TRANSFORM|Numeric|String|
> |EXTRACT|Numeric|String|
> |EXISTSNODE|Numeric|String|
>  
> 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)