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