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

Steven Hawkins (JIRA) issues at jboss.org
Tue Sep 11 17:36:00 EDT 2018


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

Steven Hawkins resolved TEIID-5471.
-----------------------------------
    Resolution: Done


Updated the output to be null.

> string_agg should return null rather than empty over no values
> --------------------------------------------------------------
>
>                 Key: TEIID-5471
>                 URL: https://issues.jboss.org/browse/TEIID-5471
>             Project: Teiid
>          Issue Type: Bug
>          Components: Query Engine
>            Reporter: Steven Hawkins
>            Assignee: Steven Hawkins
>             Fix For: 11.2
>
>
> 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.



--
This message was sent by Atlassian JIRA
(v7.5.0#75005)


More information about the teiid-issues mailing list