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

Need to add support for parsing OPTIONS in procedure statements

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

        Gliffy Diagrams

          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
                  Reporter:
                  blafond Barry LaFond
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  3 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved: