[teiid-issues] [JBoss JIRA] (TEIID-3270) Allow UDFs to call Teiid functions

[Steven Hawkins (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-3270?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13144618#comment-13144618 ] 

Steven Hawkins commented on TEIID-3270:
---------------------------------------

> Right, but to fully define a UDF, the JAVA_CLASS and JAVA_METHODS properties need to be defined so that the Teiid engine knows what to execute when the function is called in a SQL statement.

No, the intent of this feature is to allow a virtual function that can be defined using the teiid procedure language.

> Interestingly, EXECing the function works, but does not return a result set, but a scalar, so the only way I found to get to the result is something like this:

Under the covers it is defined first as a procedure and then special handling is added to allow calling as a function.  We are not specifically shutting off the procedural aspect for calling the function.

> Allow UDFs to call Teiid functions
> ----------------------------------
>
>                 Key: TEIID-3270
>                 URL: https://issues.jboss.org/browse/TEIID-3270
>             Project: Teiid
>          Issue Type: Feature Request
>          Components: Query Engine
>            Reporter: Sanjeev Gour
>            Assignee: Steven Hawkins
>             Fix For: 8.11
>
>
> Currently custom functions require the implementation on be in Java, there could be an alternative way to allow using Teiid expressions inside the custom functions. The related thread is here-
> https://developer.jboss.org/thread/251179



--
This message was sent by Atlassian JIRA
(v6.4.11#64026)