Hi,
When you use simultaneorder "order" + " projection " that create a SQL error :
{code}
Criteria criteria = session.createCriteria(A.class, "a");
criteria.createAlias("a.b", "b", JoinType.LEFT_OUTER_JOIN);
criteria.addOrder(Order.asc("b.code"));
criteria.setProjection(Projections.distinct(Projections.property("b")));
criteria.list();
{code}
{quote}
Caused by: org.h2.jdbc.JdbcSQLException: Order by expression "B1_.CODE" must be in the result list in this case; SQL statement:
select distinct this_.b_id as y0_ from A this_ left outer join B b1_ on this_.b_id=b1_.id order by b1_.code asc [90068-190]
{quote}
Note that works with mysql.
Regards,
Alexis GAYTE |
|