[
https://issues.apache.org/jira/browse/CALCITE-3323?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16955683#comment-16955683
]
Julian Hyde commented on CALCITE-3323:
--------------------------------------
I have removed the link to PR #1522; this issue is fixed, and that PR needs a
new issue to be logged. It is only somewhat related to this case.
> 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
> Fix For: 1.22.0
>
> Time Spent: 1h
> Remaining Estimate: 0h
>
> 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)
