You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@calcite.apache.org by "Julian Hyde (Jira)" <ji...@apache.org> on 2020/07/25 21:49:00 UTC

[jira] [Commented] (CALCITE-2569) UDFs that are table functions must implement SqlTableFunction and have CURSOR as their return type

    [ https://issues.apache.org/jira/browse/CALCITE-2569?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17165126#comment-17165126 ] 

Julian Hyde commented on CALCITE-2569:
--------------------------------------

[~amaliujia], [~mmior], Could you please review [https://github.com/julianhyde/calcite/tree/2160-spatial-grid] (contains fixes for 2159 and 2160, and significant changes to the table function API) in the next day or two.

> 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)