[teiid-designer-issues] [JBoss JIRA] (TEIIDDES-3208) Support virtual / foreign procedure with VARIADIC parameter
[
https://issues.jboss.org/browse/TEIIDDES-3208?page=com.atlassian.jira.plu...
]
Barry LaFond commented on TEIIDDES-3208:
----------------------------------------
[~cshong] Note that the documentation for VARARGS procedure property is:
{code}
Indicates that the last argument of the function can be repeated 0 to any number of times.
default false. It is more proper to use a VARIADIC parameter.
{code}
So you should be able to set the VARARGS = true property, deploy our VDB and the last
parameter will be treated as VARIADIC
Support virtual / foreign procedure with VARIADIC parameter
-----------------------------------------------------------
Key: TEIIDDES-3208
URL: https://issues.jboss.org/browse/TEIIDDES-3208
Project: Teiid Designer
Issue Type: Enhancement
Affects Versions: 11.1
Environment: Operating system: Windows 10.
Reporter: SHI HONG CHIN
Assignee: Barry LaFond
Fix For: 11.2
I wanted to create a native query procedure which support unlimited number of object type
parameters.
According to the documentation titled "DDL Metadata for Schema Objects" at
http://teiid.github.io/teiid-documents/10.2.x/content/reference/DDL_Metad..., the
following SQL statement define a procedure with VARIADIC parameter by adding the word
"VARIADIC" before the parameter name:
{code:java}
CREATE FOREIGN PROCEDURE proc (x integer, VARIADIC z integer)
RETURNS (x string);
{code}
In Teiid Designer, I cannot find any way to define a VARIADIC parameter in a procedure.
Please add this feature to Teiid Designer.
--
This message was sent by Atlassian JIRA
(v7.5.0#75005)