Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

objectAlias behavior not consistent

Description

I would like to bring up the issue in HQL with 'GROUP BY object'

Refering to those forums:
http://forum.hibernate.org/viewtopic.php?t=953716
http://forum.hibernate.org/viewtopic.php?t=950514

And this issue:
https://nhibernate.jira.com/browse/NH-528

I believe that current behavior is a bug. Or at least non-consistency.
The alias of object should have consistent behavior. So if I include it after SELECT it should act the same way as if I put it after GROUP BY. If I want to work with primary I would simply use alias.id

Environment

None

Activity

Show:

Alex Zaytsev 
August 30, 2020 at 8:20 PM

Moved here.

Fabio Maulo 
July 6, 2008 at 11:14 AM

Changed issue type since it is a know limitation

From docs.
Chapter 11.10 The group by clause
Also note that NHibernate currently does not expand a grouped entity, so you can't write group by cat if all properties of cat are non-aggregated. You have to list all non-aggregated properties explicitly.

Scheduled for when we'll have another parser.

Fabio Maulo 
June 19, 2008 at 3:49 PM

Do you can send a little test case ?

Karl Chu 
April 25, 2008 at 4:08 PM

This possibly involves the parser... we will have to take a closer look. Putting it in 2.0.0.Alpha2 for now.

Duplicate

Details

Assignee

Reporter

Labels

Components

Affects versions

Priority

Who's Looking?

Open Who's Looking?
Created April 24, 2008 at 5:55 AM
Updated August 30, 2020 at 8:20 PM
Resolved August 30, 2020 at 8:20 PM
Who's Looking?