[
https://issues.apache.org/jira/browse/CALCITE-7935?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18143904#comment-18143904
]
Julian Hyde commented on CALCITE-7935:
--------------------------------------
The link you provide to Oracle doc is broken. I don't see any evidence in the
Oracle doc that Oracle allows table function calls without parentheses.
When we're talking about scalar functions, Oracle does allow zero-parameter
scalar functions like {{SYSDATE}} to be called without an argument list. In
fact it does not allow an argument list.
Can you link to other cases that discuss whether arguments should be required?
Discuss whether this functionality should depend on a conformance property.
> 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
> Labels: pull-request-available
>
> 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)
