[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-2893) Criteria api does not allow a groupProperty to _NOT_ be included in the selected columns

Criteria api does not allow a groupProperty to _NOT_ be included in the selected columns ---------------------------------------------------------------------------------------- Key: HHH-2893 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2893 Project: Hibernate3 Issue Type: Patch Components: query-criteria Affects Versions: 3.2.5 Environment: n/a Reporter: Antony Stubbs Attachments: HHH2893-test.patch, hibernate criterion patch.patch Original Estimate: 2 hours Remaining Estimate: 2 hours When adding a Projections.groupProperty("prop") to a criteria, the property is added to both the GROUP BY and SELECT parts of the generated SQL query. This is a major problem for using the criteria API for complex subselects that require aggregating by a column while grouping by another column. There is presently no way in the criteria API to group by a column and have it _ONLY_ in the GROUP BY clause. i.e. currently Projections.groupProperty("propOne") causes: SELECT propOne, MAX(propTwo) FROM table GROUP BY prop desired option is to have SELECT MAX(propTwo) FROM table GROUP BY prop There have been several people talking about this, but there appears to have been 'no comment'. http://forum.hibernate.org/viewtopic.php?t=939071&highlight=values+gr... http://forum.hibernate.org/viewtopic.php?t=950803&highlight=groupprop... http://forum.hibernate.org/viewtopic.php?t=964512&highlight=groupprop... http://forum.hibernate.org/viewtopic.php?t=957671&highlight=groupprop... http://forum.hibernate.org/viewtopic.php?p=2317841#2317841 http://forum.hibernate.org/viewtopic.php?t=961617&highlight=groupprop... Find a 1st cut patch on it's way - I'm just itching my scratch now... Great work on Hibernate guys!