[teiid-issues] [JBoss JIRA] (TEIID-5570) xmlagg should return null rather than empty over no values

Steven Hawkins (Jira) issues at jboss.org
Tue Dec 11 13:55:00 EST 2018


     [ https://issues.jboss.org/browse/TEIID-5570?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Steven Hawkins updated TEIID-5570:
----------------------------------
    Description: 
For example the query:

{code}
select xmlagg(col) from (select cast('<a></a>' as xml) as col) x
{code}

Should return null rather than an empty document.

  was:
For example the query:

select string_agg(col, ',') from (select cast(null as string) as col) x

Should return null rather than an empty string.



> xmlagg should return null rather than empty over no values
> ----------------------------------------------------------
>
>                 Key: TEIID-5570
>                 URL: https://issues.jboss.org/browse/TEIID-5570
>             Project: Teiid
>          Issue Type: Bug
>          Components: Query Engine
>            Reporter: Steven Hawkins
>            Assignee: Steven Hawkins
>            Priority: Major
>             Fix For: 11.1.2, 12.0, 11.2.2
>
>
> For example the query:
> {code}
> select xmlagg(col) from (select cast('<a></a>' as xml) as col) x
> {code}
> Should return null rather than an empty document.



--
This message was sent by Atlassian Jira
(v7.12.1#712002)


More information about the teiid-issues mailing list