[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 resolved TEIID-4413.
-----------------------------------
    Resolution: Rejected


Sorry about the delay in commenting on this.

TEIID-3777 introduced this restriction because the old logic wasn't always sorting correctly and this is a common restriction/simplification that other datasources, such as postgresql, require.

> 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.2.3#72005)