[teiid-designer-issues] [JBoss JIRA] (TEIIDDES-2719) DDL for UDF in exported dynamic VDB contains RETURN parameter

DDL for UDF in exported dynamic VDB contains RETURN parameter ------------------------------------------------------------- Key: TEIIDDES-2719 URL: https://issues.jboss.org/browse/TEIIDDES-2719 Project: Teiid Designer Issue Type: Bug Components: Dynamic VDBs, Import/Export, Patch Release Affects Versions: 9.2 Reporter: Andrej Šmigala Assignee: Barry LaFond Fix For: 9.2.1 Attachments: UdfProject.zip When exporting VDB with a UDF, the resulting DDL contains the RETURN parameter in the parameters list. According to the [Teiid docs|https://docs.jboss.org/author/display/teiid87final/Support+for+User-...], the return parameter should not be specified. Generated DDL: {code:sql} CREATE VIRTUAL FUNCTION concatNull (stringLeft string(4000), stringRight string(4000), result string(4000)) RETURNS string ) OPTIONS("FUNCTION-CATEGORY" 'MY_TESTING_FUNCTION_CATEGORY', JAVA_CLASS 'userdefinedfunctions.MyConcatNull', JAVA_METHOD 'myConcatNull') {code} Expected DDL: {code:sql} CREATE VIRTUAL FUNCTION concatNull (stringLeft string(4000), stringRight string(4000)) RETURNS string OPTIONS("FUNCTION-CATEGORY" 'MY_TESTING_FUNCTION_CATEGORY', JAVA_CLASS 'userdefinedfunctions.MyConcatNull', JAVA_METHOD 'myConcatNull') {code} (note that the generated DDL also contains an unrelated syntax error due to TEIIDDES-2697)