[
https://issues.apache.org/jira/browse/CALCITE-7935?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Kirill Tkalenko updated CALCITE-7935:
-------------------------------------
Description:
Allow invoking parameterless table functions without parentheses after the
function name:
{code:java}
SELECT * FROM TABLE(my_func)
{code}
Currently, Calcite requires {{{}TABLE(my_func()){}}}.
Oracle allows omitting parentheses when calling functions without arguments:
[Oracle SQL
Reference|https://docs.oracle.com/cd/B13789_01/server.101/b10759/statements_5009.htm].
was:
Allow invoking parameterless table functions without parentheses after the
function name:
{{SELECT * FROM TABLE(my_func)}}
Currently, Calcite requires {{{}TABLE(my_func()){}}}.
Oracle allows omitting parentheses when calling functions without arguments:
[Oracle SQL
Reference|https://docs.oracle.com/cd/B13789_01/server.101/b10759/statements_5009.htm].
> Support table function calls without parentheses
> ------------------------------------------------
>
> Key: CALCITE-7935
> URL: https://issues.apache.org/jira/browse/CALCITE-7935
> Project: Calcite
> Issue Type: Improvement
> Reporter: Kirill Tkalenko
> Assignee: Kirill Tkalenko
> Priority: Major
>
> Allow invoking parameterless table functions without parentheses after the
> function name:
>
> {code:java}
> SELECT * FROM TABLE(my_func)
> {code}
> Currently, Calcite requires {{{}TABLE(my_func()){}}}.
> Oracle allows omitting parentheses when calling functions without arguments:
> [Oracle SQL
> Reference|https://docs.oracle.com/cd/B13789_01/server.101/b10759/statements_5009.htm].
--
This message was sent by Atlassian Jira
(v10.3.26#10030026)
