Uploaded image for project: 'Teiid Designer'
  1. Teiid Designer
  2. TEIIDDES-3208

Support virtual / foreign procedure with VARIADIC parameter

    XMLWordPrintable

Details

    • Enhancement
    • Resolution: Won't Do
    • Major
    • Future
    • 11.1
    • None
    • None

    Description

      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_Metadata.html, the following SQL statement define a procedure with VARIADIC parameter by adding the word "VARIADIC" before the parameter name:

      CREATE FOREIGN PROCEDURE proc (x integer, VARIADIC z integer)
          RETURNS (x string);
      

      In Teiid Designer, I cannot find any way to define a VARIADIC parameter in a procedure.

      Please add this feature to Teiid Designer.

      Attachments

        Activity

          People

            blafond Barry LaFond
            cshong SHI HONG CHIN (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: