Return parameter not created when importing UDF from dynamic VDB ---------------------------------------------------------------- Key: TEIIDDES-2743 URL: https://issues.jboss.org/browse/TEIIDDES-2743 Project: Teiid Designer Issue Type: Bug Components: Dynamic VDBs, Patch Release Affects Versions: 9.0.4 Reporter: Andrej Šmigala Fix For: 9.2.1 When importing a dynamic VDB containing a UDF, the imported UDF is missing the RETURN parameter. This parameter is not specified as parameter in the DDL, but rather in the RETURNS clause. {code:xml} <?xml version="1.0" encoding="UTF-8" standalone="no"?> <vdb name="UdfProcedureVdb" version="1"> <description /> <property name="validationDateTime" value="Tue Nov 10 13:18:14 CET 2015" /> <property name="validationVersion" value="8.7.1" /> <model name="ProcedureModel" type="VIRTUAL"> <metadata type="DDL"><![CDATA[ CREATE VIRTUAL FUNCTION udfConcatNull (stringLeft string(4000), stringRight string(4000)) RETURNS string OPTIONS("FUNCTION-CATEGORY" 'MY_TESTING_FUNCTION_CATEGORY', JAVA_CLASS 'userdefinedfunctions.MyConcatNull', JAVA_METHOD 'myConcatNull') ]]></metadata> </model> </vdb> {code}