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

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

All the unit tests pass except for:
ConfigurationPerformanceTest.testLoadingAndSerializationOfConfiguration
ConfigurationPerformanceTest.testSessionFactoryCreationTime
but I imagine they're unrelated. (i haven't checked to see if they also fail on vanilla trunk)

> 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