[
https://issues.apache.org/jira/browse/CALCITE-2317?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17183067#comment-17183067
]
Malte Bellmann commented on CALCITE-2317:
-----------------------------------------
{quote}Just curious, the {{Calcite.getFunctions}} only return the registered
UDFs, is this the standard behavior, or what should we expect to return for
{{DatabaseMetadata.getFunction()}} ?
{quote}
Thanks [~danny0405], good point!
According to the specification
[https://docs.oracle.com/en/java/javase/14/docs/api/java.sql/java/sql/DatabaseMetaData.html#getFunctions(java.lang.String,java.lang.String,java.lang.String)]
"system and user functions available in the given catalog" should be returned.
Therefore, in theory, all build-in functions must be returned as well.
Postgres for example has a schema "pg_catalog" where all these functions
reside.
We could add all build-in functions to the "metadata" schema.
1) Does this schema always exist?
2) Where would I find all build-in functions?
> getFunctions() showing empty
> ----------------------------
>
> Key: CALCITE-2317
> URL: https://issues.apache.org/jira/browse/CALCITE-2317
> Project: Calcite
> Issue Type: Bug
> Reporter: Subbarao
> Assignee: Malte Bellmann
> Priority: Major
> Labels: pull-requests-available
> Attachments: CalciteWithOracle.java
>
> Time Spent: 10m
> Remaining Estimate: 0h
>
> how to get all function names and procedure names in oracle database using
> calcite connection and schema.
> schema.getFunctionNames() return result is:[ ]
> Then i am try to retrieving DatabaseMetadata.getFunction().Here also it will
> be showing empty.
> Iam using calciResultSet ,AvaticaResultSet and ResultSet for getting
> functions and procedures but will be showing empty.
> Is it possible get all function names and procedure names from any database.
> But normal jdbc connection using DatabseMetaData properties it retrive alll
> function names and procedure names.Why it will not retrive in calcite
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
