[CAY-1367] EJBQL: Implement support for relationship-ending paths in GROUP BY clause

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.0RC2
• Fix Version/s: 3.0RC2
• Component/s: Core Library
• Assignee: Andrus Adamchik
• Reporter: Dave Dombrosky
• Created: 18/Jan/10 06:07
• Updated: 26/Jan/10 10:16
• Resolved: 25/Jan/10 18:46

Description

Test case to cause the error:

ObjectContext context = createDataContext();

Expression exp = ExpressionFactory.matchExp(Painting.TO_GALLERY_PROPERTY, null);
EJBQLQuery query = new EJBQLQuery("select count(p), p.toArtist from Painting p where " + exp.toEJBQL("p") + " group by p.toArtist");

context.performQuery(query);

From the test I get this message:
java.sql.SQLException: Not in aggregate function or group by clause: org.hsqldb.Expression@83b18f in statement [SELECT COUNT(*) AS sc0, t1.ARTIST_ID AS ec1_2, t1.ARTIST_NAME AS ec1_1, t1.DATE_OF_BIRTH AS ec1_0 FROM PAINTING t0 LEFT OUTER JOIN ARTIST t1 ON (t0.ARTIST_ID = t1.ARTIST_ID) GROUP BY t0.ARTIST_ID]