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

[Andrej Šmigala (JIRA)]

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

Andrej Šmigala commented on TEIID-3270:
---------------------------------------

[~rareddy] yes, does not work either.

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:

{code:sql}
CREATE VIRTUAL FUNCTION f1(p1 integer) RETURNS integer AS RETURN p1;
CREATE VIRTUAL PROCEDURE testProc (p integer) RETURNS TABLE ( result integer ) AS
BEGIN
    DECLARE integer VARIABLES.v1 = ( EXEC f1(p));
    SELECT VARIABLES.v1 AS result;
END;
{code}

> 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)