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

[Steven Hawkins (JIRA)]

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

Steven Hawkins closed TEIID-4413.
---------------------------------


> 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
(v7.5.0#75005)