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

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

              Dates

                Created:
                Updated:
                Resolved: