(Check the attached project. JPAUnitTestCase.class)

This query works:

SELECT i, SUM(is.total)
FROM ItemSale is
JOIN is.item i
GROUP BY i

This query however fails:

SELECT NEW Sumary(i, SUM(is.total))
FROM ItemSale is
JOIN is.item i
GROUP BY i

with “expression not in aggregate or GROUP BY columns: I2_0.ID in statement [select i2_0.id,i2_0.name,sum(i1_0.total) from ItemSale i1_0 join Item i2_0 on i2_0.id=i1_0.item_id group by i1_0.item_id]“. Also fails with others databases servers like Postgresql and Oracle (which is SQL standards). This used to work with 5.6.x branches.