[
https://issues.apache.org/jira/browse/CALCITE-2569?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17165313#comment-17165313
]
Rui Wang edited comment on CALCITE-2569 at 7/26/20, 7:45 PM:
-------------------------------------------------------------
+1 on the SqlTableFunction interface. I might be able to migrate window table
functions to this new interface.
was (Author: amaliujia):
+1 on SqlTableFunction interface. I might be able to migrate window table
functions to this new interface.
> UDFs that are table functions must implement SqlTableFunction and have CURSOR
> as their return type
> --------------------------------------------------------------------------------------------------
>
> Key: CALCITE-2569
> URL: https://issues.apache.org/jira/browse/CALCITE-2569
> Project: Calcite
> Issue Type: Bug
> Reporter: Julian Hyde
> Assignee: Julian Hyde
> Priority: Major
>
> UDFs that are table functions must implement SqlTableFunction and have CURSOR
> as their return type,
> Validate that table functions are not used in contexts that require scalar
> functions, such as the SELECT clause.
> Change operand type ANY to mean 'scalar expression of any type (but not a
> cursor)', and add operand type IGNORE to mean skip validation - for an
> operand that is not an expression. TABLE is one of the few operators that
> accepts a CURSOR operand.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
