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: 10.0.1 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...