Hello,

I'm observing that once a projection has an alias my where clause (restrictions) break the query:

Would you please help me get passed this issue...

here is how to produce it.
Criteria c = ...CreateCriteria(demo.Cat.class);
c.setProjection(Projections.projectionList()
.add(Projections.groupProperty("color")));
c.add(Restrictions.eq("color", keyColor));
c.list()

produces:

select this_.color as y0_ from cats this_ where this_.color=? group by this_.color

Now if I add an alias to my projection it will fail...

c.setProjection(Projections.projectionList()
.add(Projections.groupProperty("color"),"color")); //ALIAS
c.add(Restrictions.eq("color", keyColor));
c.list()

produces:
select this_.color as y0_ from cats this_ where y0_=? group by this_.color

Note that it is doing y0_=? instead of this_.color=?

I need the alias so that I can do result transformation...is there a way I can get the alias to work with the resitriction?

Thanks

it is realted to this issue:
http://opensource.atlassian.com/project ... se/HHH-817

It is not clear is this issue fixed now?

it is realted to this issue:
http://opensource.atlassian.com/project ... se/HHH-817

It is not clear is this issue fixed now?