[teiid-issues] [JBoss JIRA] (TEIID-4413) With DISTINCT an aggregate order by is required to reference the aggregate arguments

[Bram Gadeyne (JIRA)]

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

Bram Gadeyne updated TEIID-4413:
--------------------------------
        Fix Version/s:     (was: 9.0.2)
    Affects Version/s: 9.0.2


> With DISTINCT an aggregate order by is required to reference the aggregate arguments
> ------------------------------------------------------------------------------------
>
>                 Key: TEIID-4413
>                 URL: https://issues.jboss.org/browse/TEIID-4413
>             Project: Teiid
>          Issue Type: Bug
>    Affects Versions: 9.0.2
>            Reporter: Bram Gadeyne
>            Assignee: Steven Hawkins
>
> Hi,
> I'm using the function STRING_AGG(distinct FORMATTIMESTAMP(somedate,'dd-MM-yyyy'),',' ORDER BY somedate) in a script that was made using 8.11.3. This used to work.
> In 9.0.2 I get an error with the following message: With DISTINCT an aggregate order by is required to reference the aggregate arguments



--
This message was sent by Atlassian JIRA
(v6.4.11#64026)