[ 
https://issues.apache.org/jira/browse/CALCITE-6037?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Ran Tao updated CALCITE-6037:
-----------------------------
    Description: 
In SqlLibraryOperators, we defined some SqlFunctions like below:

 
{code:java}
@LibraryOperator(libraries = {SPARK})
public static final SqlFunction ARRAY =
    SqlBasicFunction.create("ARRAY",
        SqlLibraryOperators::arrayReturnType,
        OperandTypes.SAME_VARIADIC);
{code}
{code:java}
public static final SqlFunction EXTRACT_VALUE =
    SqlBasicFunction.create("EXTRACTVALUE",
        ReturnTypes.VARCHAR_2000.andThen(SqlTypeTransforms.FORCE_NULLABLE),
        OperandTypes.STRING_STRING); {code}
{code:java}
public static final SqlFunction XML_TRANSFORM =
    SqlBasicFunction.create("XMLTRANSFORM",
        ReturnTypes.VARCHAR.andThen(SqlTypeTransforms.FORCE_NULLABLE),
        OperandTypes.STRING_STRING); {code}

however, they used a SqlBasicFunction

 

  was:
In SqlLibraryOperators, we defined some SqlFunction with constructor

 
{code:java}
@LibraryOperator(libraries = {SPARK})
public static final SqlFunction ARRAY =
    SqlBasicFunction.create("ARRAY",
        SqlLibraryOperators::arrayReturnType,
        OperandTypes.SAME_VARIADIC);
{code}
{code:java}
public static final SqlFunction EXTRACT_VALUE =
    SqlBasicFunction.create("EXTRACTVALUE",
        ReturnTypes.VARCHAR_2000.andThen(SqlTypeTransforms.FORCE_NULLABLE),
        OperandTypes.STRING_STRING); {code}
 

 


> 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
>             Fix For: 1.36.0
>
>
> In SqlLibraryOperators, we defined some SqlFunctions like below:
>  
> {code:java}
> @LibraryOperator(libraries = {SPARK})
> public static final SqlFunction ARRAY =
>     SqlBasicFunction.create("ARRAY",
>         SqlLibraryOperators::arrayReturnType,
>         OperandTypes.SAME_VARIADIC);
> {code}
> {code:java}
> public static final SqlFunction EXTRACT_VALUE =
>     SqlBasicFunction.create("EXTRACTVALUE",
>         ReturnTypes.VARCHAR_2000.andThen(SqlTypeTransforms.FORCE_NULLABLE),
>         OperandTypes.STRING_STRING); {code}
> {code:java}
> public static final SqlFunction XML_TRANSFORM =
>     SqlBasicFunction.create("XMLTRANSFORM",
>         ReturnTypes.VARCHAR.andThen(SqlTypeTransforms.FORCE_NULLABLE),
>         OperandTypes.STRING_STRING); {code}
> however, they used a SqlBasicFunction
>  



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

Reply via email to