Hibernate criterion Projection alias not being used
- by sbzoom
Do Hibernate Projection aliases even work? I could swear it just doesn't. At least, it doesn't do what I would expect it to do.
Here is the java:
return sessionFactory.getCurrentSession().createCriteria( PersonProgramActivity.class ).setProjection(
Projections.projectionList().add(
Projections.alias( Projections.sum( "numberOfPoints" ), "number_of_points" ) ).add(
Projections.groupProperty( "person.id" ) ) ).setFirstResult( start ).setFetchSize(
size ).addOrder( Order.desc( "numberOfPoints" ) ).list();
Here is the SQL that it generates:
select sum(this_.number_of_points) as y0_, this_.person_id as y1_ from PERSON_PROGRAM_ACTIVITY this_ group by this_.person_id order by this_.number_of_points desc
It doesn't seem to use the alias at all. I would think setting the alias would mean that "sum(this_.number_of_points)" would be aliased as "number_of_points" and not "y0_". Is there some trick I am missing?
Thanks.
