]
Barry LaFond resolved TEIIDDES-2783.
------------------------------------
Resolution: Done
Tested again with master (11.0) and import/export works. Description for virtual procedure
is correctly loaded, modeled and exported.
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.1
Attachments: 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}