[teiid-designer-issues] [JBoss JIRA] (TEIIDDES-3208) Support virtual / foreign procedure with VARIADIC parameter

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: Future Attachments: nativeprocparams.png, procedure extra param error.png, procedures with no VARARGS.png 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.