-
Type:
Bug
-
Status: Closed (View Workflow)
-
Priority:
Major
-
Resolution: Done
-
Affects Version/s: 9.0.4
-
Fix Version/s: 9.2, 10.0, 9.2.1 - Released via 10.0 Mars platform
-
Component/s: VDB & Execution
-
Labels:
-
Steps to Reproduce:
- import the attached project
- generate a dynamic VDB from DynamicProcedureVdb
- deploy and execute both VDBs
- run the following query against each VDB: exec testProc('x')
-
Bugzilla Update:Perform
When a VDB containing view model with a virtual procedure is exported as a dynamic VDB, the virtual procedure does not return any results. This is because the generated DDL does not contain the RETURNS clause.
Generated DDL:
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; |
Expected DDL:
CREATE VIRTUAL PROCEDURE testProc (p1 string(4000)) RETURNS TABLE ( xml_out xml) |
AS |
BEGIN |
SELECT XMLELEMENT(NAME test, XMLFOREST(ProcedureModel.testProc.p1 AS elem1, 'elem2' AS elem2)) AS xml_out; |
END; |
- is incorporated by
-
TEIIDDES-2699 Issues with Dynamic VDB import/export
-
- Resolved
-
