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

Need to add support for parsing OPTIONS in procedure statements

XMLWordPrintable

      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')
      

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

            dflorian@redhat.com Daniel Florian (Inactive)
            blafond Barry LaFond
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated:
              Resolved: