[teiid-issues] [JBoss JIRA] (TEIID-4192) If a column is blank the TEXTAGG function excludes it from the output

[Debbie Steigner (JIRA)]

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)