[teiid-issues] [JBoss JIRA] (TEIID-4192) If a column is blank the TEXTAGG function excludes it from the output
Debbie Steigner created TEIID-4192:
--------------------------------------
Summary: 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
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
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)