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

[Bram Gadeyne (JIRA)]

Bram Gadeyne created TEIID-4413:
-----------------------------------

             Summary: 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
            Reporter: Bram Gadeyne
            Assignee: Steven Hawkins
             Fix For: 9.0.2


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)