Bug 1279494 - DDL for UDF in exported dynamic VDB contains RETURN parameter
Summary: DDL for UDF in exported dynamic VDB contains RETURN parameter
Keywords:
Status: CLOSED NOTABUG
Alias: None
Product: JBoss Data Virtualization 6
Classification: JBoss
Component: Tooling
Version: 6.2.0
Hardware: Unspecified
OS: Unspecified
unspecified
high
Target Milestone: ---
: ---
Assignee: Barry LaFond
QA Contact: Andrej Smigala
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2015-11-09 15:05 UTC by Andrej Smigala
Modified: 2016-04-14 18:49 UTC (History)
1 user (show)

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed: 2015-12-07 13:30:30 UTC
Type: Bug
Embargoed:


Attachments (Terms of Use)


Links
System ID Private Priority Status Summary Last Updated
Red Hat Issue Tracker TEIIDDES-2719 0 Major Closed DDL for UDF in exported dynamic VDB contains RETURN parameter 2016-04-14 18:49:09 UTC

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


Note You need to log in before you can comment on or make changes to this bug.