[
https://issues.apache.org/jira/browse/CALCITE-4864?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Jing Zhang updated CALCITE-4864:
--------------------------------
Description:
A Polymorphic Table Function (abbreviated PTF) is a function that returns a
table whose row type is not declared when the function is created. It is
introduced in SQL 2017 standard.
PTF is the evolution of the table function. It has the following features
compare with normal table function:
# may have generic table parameters (i.e., no row type of table parameters
declared when the PTF is created)
# returns a table whose row type is not declared when the function is created,
it may depend on the function arguments.
There are many interesting examples of PTF in SQL standard. Here I only give
one
[^SQL_2017_part7_polymorphic_table_functions.zip]
was:
Being the part of ANSI SQL 2016 Polymorphic Table Functions are the evolution
of the table functions. They can be invoked in the FROM clause. They have the
following features compare with normal table function:
# may have generic table parameters (i.e., no row type of table parameters
declared when the PTF is created)
# returns a table whose row type is not declared when the function is created,
it may depend on the function arguments.
> Supports Polymorphic Table function
> -----------------------------------
>
> Key: CALCITE-4864
> URL: https://issues.apache.org/jira/browse/CALCITE-4864
> Project: Calcite
> Issue Type: New Feature
> Components: core
> Reporter: Jing Zhang
> Priority: Major
> Attachments: SQL_2017_part7_polymorphic_table_functions.zip
>
>
> A Polymorphic Table Function (abbreviated PTF) is a function that returns a
> table whose row type is not declared when the function is created. It is
> introduced in SQL 2017 standard.
> PTF is the evolution of the table function. It has the following features
> compare with normal table function:
> # may have generic table parameters (i.e., no row type of table parameters
> declared when the PTF is created)
> # returns a table whose row type is not declared when the function is
> created, it may depend on the function arguments.
> There are many interesting examples of PTF in SQL standard. Here I only give
> one
> [^SQL_2017_part7_polymorphic_table_functions.zip]
--
This message was sent by Atlassian Jira
(v8.20.7#820007)
