Bug 1035356

Summary: Designer Create User Defined Function Dialog Result Set Tab Add Column Button Does Not Enable
Product: [JBoss] JBoss Data Virtualization 6 Reporter: Dan Florian <dflorian>
Component: ToolingAssignee: Van Halbert <vhalbert>
Status: CLOSED CURRENTRELEASE QA Contact:
Severity: unspecified Docs Contact:
Priority: unspecified    
Version: 6.0.0CC: lfabriko, vhalbert
Target Milestone: ER6   
Target Release: 6.0   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
When attempting to create a user defined function (UDF) in Teiid Designer, the GUI does not intuitively indicate where to enter the return parameter. Some users are trying to add the return parameter under the "Result Set" tab. Under this tab, users will find that the "Add" button is not enabled. The correct place to enter the return parameter is under the "Parameters" tab. It is proposed that this will be fixed by removing the "Result Set" tab to avoid confusion.
 Story Points: ---
Clone Of: Environment:
Last Closed: 2014-02-06 15:37:15 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:

Description Dan Florian 2013-11-27 15:49:26 UTC 
Description of problem:

Following the E2E Yahoo UDF Test Script, I tried to create the UDF. When I got to the part to create the return parameter for the function the "Add" column button could not be enabled.  

Version-Release number of selected component (if applicable):

DV 6.0.0 ER4
JBDS 7.1.0 CR1
JBIS 4.1.3 Beta5
Teiid Designer 8.3.0 CR1
OS X 10.9

How reproducible:

Happens every time.

Steps to Reproduce:

Using Designer:

1. Create a new relational model
2. New Child > Procedure > User Defined Function > OK
3. Enter a function "Name" and a "Java Class" (to get rid of error message) 
4. Click the "Result Set" tab
5. There is no way to add a result set column

Actual results:

Unable to create a return parameter for relational UDF model. But the model can be created and the return parameter can be added later using the New Child menu option.

Expected results:

The "Add" button in the wizard should enable so that a return parameter can be entered.

Additional info:

None
Comment 2 Dan Florian 2013-11-27 16:53:34 UTC 
Well this seems to be a bit of a user and usability issue. I was thinking that I would go to the "Result Set" tab and create the function return value there. But the return value is entered on the "Parameters" tab and has a direction of "RETURN".

So, maybe we could just not display the "Result Set" tab when a UDF is being created.

Or maybe the issue should just closed because it was just a user procedure issue.
Comment 3 JBoss JIRA Server 2013-12-02 16:48:57 UTC 
Barry LaFond <blafond> updated the status of jira TEIIDDES-1963 to Resolved
Comment 4 JBoss JIRA Server 2013-12-02 16:48:57 UTC 
Barry LaFond <blafond> made a comment on jira TEIIDDES-1963

Done
Comment 6 Lucie Fabrikova 2014-02-03 15:50:06 UTC 
Verified in JBDSIS-7.0.0.GA-GA + DV 6.0.0.GA.
Comment 7 JBoss JIRA Server 2014-05-07 21:04:43 UTC 
Barry LaFond <blafond> updated the status of jira TEIIDDES-1963 to Closed