Steven Hawkins <shawkins> made a comment on jira TEIIDDES-1949 There is a designer customization to FunctionLibrary here correct? From FunctionTree it implies that a function has been added to the with some null type information.
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