]
Steven Hawkins resolved TEIID-4192.
-----------------------------------
Fix Version/s: 9.0
8.12.5
8.13.5
Resolution: Done
Simply omitting the value, but not the separator.
If a column is blank the TEXTAGG function excludes it from the output
----------------------------------------------------------------------
Key: TEIID-4192
URL:
https://issues.jboss.org/browse/TEIID-4192
Project: Teiid
Issue Type: Bug
Affects Versions: 8.7.5.6_2
Reporter: Debbie Steigner
Assignee: Steven Hawkins
Fix For: 9.0, 8.12.5, 8.13.5
If a column value is blank, it is excluding it in the result, causing incorrect output.
TEXTAGG(FOR Last_Name,
First_Name,
Middle_initial,
Currency_Code
DELIMITER '|' QUOTE '"'
)
In the above example, if middle name is blank, then it should still show one empty
column with "|" delimiter as shown below.
Steigner|Debbie||USD
But it returns output as excluding middle name since it is blank.
Steigner|Debbie|USD