[
https://issues.apache.org/jira/browse/CALCITE-7935?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18143904#comment-18143904
]
Julian Hyde edited comment on CALCITE-7935 at 11/12/26, 4:45 PM:
-----------------------------------------------------------------
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 some nilary
functions like {{SYSDATE}} to be called without an argument list. In fact it
does not allow an argument list. But other Oracle nilary functions, for example
{{{}SYS_GUID(){}}}, and I believe nilary user-defined functions, require
parentheses.
Can you link to other cases that discuss whether arguments should be required?
Discuss whether this functionality should depend on a conformance property.
was (Author: julianhyde):
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)
