You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@calcite.apache.org by "Ryan Fu (Jira)" <ji...@apache.org> on 2019/09/19 17:40:00 UTC

[jira] [Updated] (CALCITE-3323) Handle arbitrary/unknown functions that have ordinary syntax

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

Ryan Fu updated CALCITE-3323:
-----------------------------
    Description: 
Add a strategy where if a function has ordinary function syntax and we don't recognize it we assume that it can take any argument types and returns a result of unknown type.

We will still need to change the parser to handle functions with non-standard syntax (e.g. DATEADD). And it's a good idea to explicitly add commonly used non-standard functions (e.g. MD5, CONCAT).”


[19/Sept/2019] Functions have to have ordinary function syntax [e.g. foo(arg0, ...)]. Current implementation idea is to:
 * Create a known/unknown flag for use within the validator
 * Create a more permissive SqlUnresolvedFunction to be passed through validator
 ** Allow OperandTypes to be variadic

  was:
Add a strategy where if a function has ordinary function syntax and we don't recognize it we assume that it can take any argument types and returns a result of unknown type.

We will still need to change the parser to handle functions with non-standard syntax (e.g. DATEADD). And it's a good idea to explicitly add commonly used non-standard functions (e.g. MD5, CONCAT).”


> Handle arbitrary/unknown functions that have ordinary syntax
> ------------------------------------------------------------
>
>                 Key: CALCITE-3323
>                 URL: https://issues.apache.org/jira/browse/CALCITE-3323
>             Project: Calcite
>          Issue Type: New Feature
>            Reporter: Ryan Fu
>            Priority: Major
>
> Add a strategy where if a function has ordinary function syntax and we don't recognize it we assume that it can take any argument types and returns a result of unknown type.
> We will still need to change the parser to handle functions with non-standard syntax (e.g. DATEADD). And it's a good idea to explicitly add commonly used non-standard functions (e.g. MD5, CONCAT).”
> [19/Sept/2019] Functions have to have ordinary function syntax [e.g. foo(arg0, ...)]. Current implementation idea is to:
>  * Create a known/unknown flag for use within the validator
>  * Create a more permissive SqlUnresolvedFunction to be passed through validator
>  ** Allow OperandTypes to be variadic



--
This message was sent by Atlassian Jira
(v8.3.4#803005)