[teiid-designer-issues] [JBoss JIRA] (TEIIDDES-2698) REST procedure in generated dynamic VDB does not work

REST procedure in generated dynamic VDB does not work ----------------------------------------------------- Key: TEIIDDES-2698 URL: https://issues.jboss.org/browse/TEIIDDES-2698 Project: Teiid Designer Issue Type: Bug Components: Dynamic VDBs, Extension Framework, VDB & Execution Affects Versions: 9.0.4 Reporter: Andrej Šmigala Assignee: Mark Drilling Labels: release_notes, verified_jbdsis-9.0.1 Fix For: 10.0, 9.2.1 Attachments: DynamicProcedureProject.zip When a VDB containing view model with a REST procedure is exported as a dynamic VDB, the resulting autogenrated WAR does not work. This is because the generated DDL does not contain the OPTIONS clause with REST properties, nor does it contain the required SET NAMESPACE statement Generated DDL: {code:sql} CREATE VIRTUAL PROCEDURE testProc (p1 string(4000)) AS BEGIN SELECT XMLELEMENT(NAME test, XMLFOREST(ProcedureModel.testProc.p1 AS elem1, 'elem2' AS elem2)) AS xml_out; END; {code} Expected DDL (note that this also incorporates TEIIDDES-2697): {code:sql} SET NAMESPACE 'http://teiid.org/rest' AS REST; CREATE VIRTUAL PROCEDURE testProc (p1 string(4000)) RETURNS TABLE (xml_out xml) OPTIONS ("REST:METHOD" 'GET', "REST:URI" 'test/{p1}') AS BEGIN SELECT XMLELEMENT(NAME test, XMLFOREST(ProcedureModel.testProc.p1 AS elem1, 'elem2' AS elem2)) AS xml_out; END; {code}