Need to add support for parsing OPTIONS in procedure statements --------------------------------------------------------------- Key: TEIIDDES-2783 URL: https://issues.jboss.org/browse/TEIIDDES-2783 Project: Teiid Designer Issue Type: Bug Components: Import/Export, ModeShape Integration, Patch Release Reporter: Barry LaFond Assignee: Dan Florian Fix For: 11.0.1 Attachments: 1.png, 2.png, procedureProject.zip, screenshot1.png 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#BNFforSQL... Should be able to parse the following and set the EMF *Description* (Annotation) value when imported into Designer {code} CREATE FOREIGN PROCEDURE ProcedureWithRS ( newParameter_1 string(4000) OPTIONS(ANNOTATION 'parameter 1 description'), newParameter_2 string(4000) ) RETURNS string(255) OPTIONS(ANNOTATION 'Example') {code}