[teiid-issues] [JBoss JIRA] (TEIID-2111) Teiid Stored Procedure should support variable length arguments

Fri Aug 31 15:37:32 EDT 2012

     [ https://issues.jboss.org/browse/TEIID-2111?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Steven Hawkins resolved TEIID-2111.
-----------------------------------

    Resolution: Done

Marking as resolved on the teiid side.  There is still additional cleanup work that can be done under general array support.

Since arrays are not formally supported the docs don't mention that you can pass an array value as the VARIADIC argument, such as shown in the unit tests:

create foreign procedure proc (x integer, VARIADIC z integer); 

create virtual procedure vproc (x integer, VARIADIC z integer) returns integer as begin "return" = z[2] + array_length(z); call proc(x, z); end;

note that z is being passed directly to proc in the procedure definition.

> Teiid Stored Procedure should support variable length arguments
> ---------------------------------------------------------------
>
>                 Key: TEIID-2111
>                 URL: https://issues.jboss.org/browse/TEIID-2111
>             Project: Teiid
>          Issue Type: Enhancement
>          Components: Query Engine
>    Affects Versions: 7.7, 8.0
>         Environment: Windows 7, Jboss 5.x + Teiid7.x
>            Reporter: Rajasekhar Kota
>            Assignee: Steven Hawkins
>              Labels: Stored, argument, procedure, varargs, variable
>             Fix For: 8.2
>
>
> We need extended support of Stored procedures with providing support of variable length arguments(vararg). It saves our efforts a lot in our current product.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira