Community
Participate
Working Groups
The following example query gets wrongly translated by the query engine. SELECT p FROM Program p, Channel c WHERE p.channel = c GROUP BY c ORDER BY MAX(p.start) ASC The translated query is missing the GROUP BY clause. The same query in regular sql syntax produces correct results. SELECT p.id FROM PROGRAM p, CHANNEL c WHERE p.channel_id = c.id GROUP BY c.id ORDER BY MAX(p.start) ASC If I add MAX(p.start) to the SELECT clause it works as expected. p.start is of type java.util.Date.
Is there a mapping between Program and Channel. If so, does a query like this help? SELECT p FROM Program p join p.channel c GROUP BY c ORDER BY MAX(p.start) ASC
Setting target and priority. See the following page for the meanings of these fields: http://wiki.eclipse.org/EclipseLink/Development/Bugs/Guidelines Community: Please vote for this bug if it is important to you. Votes are one of the main criteria we use to determine which bugs to fix next.
The Eclipselink project has moved to Github: https://github.com/eclipse-ee4j/eclipselink
