[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:all-tabpanel ]

Andrej Šmigala reopened TEIID-3270:
-----------------------------------


It is now possible to define a virtual function using Teiid SQL, but using such a function in a query results in the following error:
{{org.teiid.api.exception.query.QueryResolverException: TEIID30068 The function 'f1(42)' is an unknown form.  Check that the function name and number of arguments is correct.}}

This is the VDB I'm using:
{code:xml}
<vdb name="ddlfunctions" version="1">
	<model visible="true" type="VIRTUAL" name="FunctionModel">
		<metadata type="DDL"><![CDATA[   	  
 	   CREATE VIRTUAL FUNCTION f1(p1 integer) RETURNS integer AS RETURN p1;
      ]]>
		</metadata>
	</model>
</vdb>
{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)