[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)]

    [ http://opensource.atlassian.com/projects/hibernate/browse/HHH-2893?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_28452 ] 

Antony Stubbs commented on HHH-2893:
------------------------------------

Forgot to say,

I suppose this isn't really the "correct" to do it as the 'projections' which don't have SELECT entries aren't really 'projections' any more...

Also, I'm new at this, so my changes will of course need a look at. I've put a comment in where my replacement code is quite slower than the original - I just wanted to get something that worked first.

This is all against TRUNK btw.

> 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: Bug
>          Components: core
>    Affects Versions: 3.2.5
>         Environment: n/a
>            Reporter: Antony Stubbs
>         Attachments: 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