Bug 1279494

Summary: DDL for UDF in exported dynamic VDB contains RETURN parameter
Product: [JBoss] JBoss Data Virtualization 6 Reporter: Andrej Smigala <asmigala>
Component: ToolingAssignee: Barry LaFond <blafond>
Status: CLOSED NOTABUG QA Contact: Andrej Smigala <asmigala>
Severity: high Docs Contact:
Priority: unspecified    
Version: 6.2.0CC: vhalbert
Target Milestone: ---   
Target Release: ---   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2015-12-07 13:30:30 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:

Description Andrej Smigala 2015-11-09 15:05:22 UTC
When exporting VDB with a UDF, the resulting DDL contains the RETURN parameter in the parameters list. According to the Teiid docs, the return parameter should not be specified.

Generated DDL:

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')

Expected DDL:

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')

(note that the generated DDL also contains an unrelated syntax error due to TEIIDDES-2697)

Comment 2 JBoss JIRA Server 2015-11-30 21:07:54 UTC
Barry LaFond <blafond> updated the status of jira TEIIDDES-2719 to Resolved

Comment 3 Barry LaFond 2015-12-07 13:30:30 UTC
Using only JIRA now.  Marking as closed

Comment 4 JBoss JIRA Server 2016-02-19 09:15:31 UTC
Matus Makovy <mmakovy> updated the status of jira TEIIDDES-2719 to Closed

Comment 5 JBoss JIRA Server 2016-04-14 18:38:50 UTC
Barry LaFond <blafond> updated the status of jira TEIIDDES-2719 to Reopened

Comment 6 JBoss JIRA Server 2016-04-14 18:49:09 UTC
Barry LaFond <blafond> updated the status of jira TEIIDDES-2719 to Closed