Description Patrice Lachance 2010-06-11 11:44:27 EDT

Build Identifier: 

The having clause of a CriteriaQuery is ignored in this simple query. The generated JPQL/SQL query does not contain the having clause.

CriteriaQuery<Ecole> c = cb.createQuery(Ecole.class);
Root<Ecole> ec = c.from(Ecole.class);
Join<Ecole, Journee> j = ec.join("journeeCollection", JoinType.LEFT);
Expression<Number> expDateLimiteInscrMax = cb.max(j.get("dateLimiteInscription").as(Number.class));
c.having(cb.ge(expDateLimiteInscrMax, 1234567890);

The workaround is to use a multiselect query like this :

CriteriaQuery<Object[]> c = cb.createQuery(Object[].class);
Root<Ecole> ec = c.from(Ecole.class);
Join<Ecole, Journee> j = ec.join("journeeCollection", JoinType.LEFT);
Expression<Number> expDateLimiteInscrMax = cb.max(j.get("dateLimiteInscription").as(Number.class));
c.having(cb.ge(expDateLimiteInscrMax, 1234567890);
c.multiselect(ec, cb.literal(1)).groupBy(ec);

Reproducible: Always