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

Need to add support for parsing OPTIONS in procedure statements

    XMLWordPrintable

    Details

      Description

      The procedure DDL syntax supports OPTIONS() clause for procedure, parameter, result set, result set columns and datatype (RETURNS) clause.

      CreateProcedureParser.parseReturnsClause() is not processing any OPTIONS() for procedure when RETURNS is just a datatype. See: https://docs.jboss.org/author/display/TEIID/BNF+for+SQL+Grammar#BNFforSQLGrammar-usagecreateDDLProcedure

      Should be able to parse the following and set the EMF Description (Annotation) value when imported into Designer

      CREATE FOREIGN PROCEDURE ProcedureWithRS (
         newParameter_1 string(4000) OPTIONS(ANNOTATION 'parameter 1 description'), 
         newParameter_2 string(4000)
      ) RETURNS string(255) OPTIONS(ANNOTATION 'Example')
      

        Attachments

        1. 1.png
          1.png
          70 kB
        2. 2.png
          2.png
          87 kB
        3. procedureProject.zip
          19 kB
        4. screenshot1.png
          screenshot1.png
          172 kB

          Issue Links

            Activity

              People

              Assignee:
              elvisisking Daniel Florian (Inactive)
              Reporter:
              blafond Barry LaFond
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: