| Summary: | Unable to create function from the reconciler | ||
|---|---|---|---|
| Product: | [JBoss] JBoss Data Virtualization 6 | Reporter: | Van Halbert <vhalbert> |
| Component: | Tooling | Assignee: | Van Halbert <vhalbert> |
| Status: | CLOSED NEXTRELEASE | QA Contact: | |
| Severity: | unspecified | Docs Contact: | |
| Priority: | unspecified | ||
| Version: | 6.0.0 | CC: | atangrin, vhalbert |
| Target Milestone: | --- | ||
| Target Release: | --- | ||
| Hardware: | Unspecified | ||
| OS: | Unspecified | ||
| Whiteboard: | |||
| Fixed In Version: | Doc Type: | Bug Fix | |
| Doc Text: |
When building functions in Teiid Designer, users are not able to create recursive functions. The workaround is:
1) Cancel out of the reconciler dialog
2) Place your cursor in the SQL near the columns that need reconciling
3) Select the "Expression Builder" action on the Transformation Editor toolbar
4) Create/edit your complex/nested function definition
|
Story Points: | --- |
| Clone Of: | Environment: | ||
| Last Closed: | 2013-12-05 14:49:23 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: | |
|
Comment 2
JBoss JIRA Server
2013-11-26 23:55:20 UTC
Barry LaFond <blafond> made a comment on jira TEIIDDES-1949 Van, can you clarify? 1) Did you add a custom function for your use-case? 2) Did you just try and use the simple string concat() functions? Van Halbert <vhalbert> made a comment on jira TEIIDDES-1949 No, I was using concat(string, string). Example: concat( LastName, concat(', ', FirstName)) I even tried just comma without single quotes. Barry LaFond <blafond> made a comment on jira TEIIDDES-1949 Looks like our ReconcilerPanel has limited support for function definition which does not correctly recurse through nested functions as in: concat( LastName, concat(', ', FirstName)) Launching from T-Editor, Teiid's ResolverVisitor correctly does this. Workaround is to use the Function Builder from the T-Editor for complex function building. Barry LaFond <blafond> made a comment on jira TEIIDDES-1949 Maybe put a hack in to check for this use-case (arg.getType() == NULL) and throw up a warning dialog stating: "Attempting to create complex, nested function definition. Please launch function builder from Transformation Editor toolbar" This is being pushed to next update because there is a workaround: 1) Cancel out of the reconciler dialog 2) Place your cursor in the SQL near the columns that need reconciling 3) Select the "Expression Builder" action the the Transformation Editor toolbar 4) Create/edit your complex/nested function definition This is not flagged as a known issue in Release Notes, because it has been closed. It is flagged as an ongoing issue. Setting to requires_doc_text- accordingly. Barry LaFond <blafond> updated the status of jira TEIIDDES-1949 to Resolved Matus Makovy <mmakovy> updated the status of jira TEIIDDES-1949 to Closed |