[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-2893) Criteria api does not allow a groupProperty to _NOT_ be included in the selected columns
Antony Stubbs (JIRA)
noreply at atlassian.com
Tue Aug 12 19:28:09 EDT 2008
[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-2893?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_30846 ]
Antony Stubbs commented on HHH-2893:
------------------------------------
I usppose it's more _related_ than dependant...
The javadoc comments in the other patch helped me to understand how to implement this patch you see.
> 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+groupproperty
> http://forum.hibernate.org/viewtopic.php?t=950803&highlight=groupproperty+subquery
> http://forum.hibernate.org/viewtopic.php?t=964512&highlight=groupproperty+subquery
> http://forum.hibernate.org/viewtopic.php?t=957671&highlight=groupproperty+subquery
> http://forum.hibernate.org/viewtopic.php?p=2317841#2317841
> http://forum.hibernate.org/viewtopic.php?t=961617&highlight=groupproperty+subquery
> Find a 1st cut patch on it's way - I'm just itching my scratch now...
> Great work on Hibernate guys!
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
More information about the hibernate-issues
mailing list