Hi,
There is a bug with Hibernate 5.4.5 and higher. New spring boot 2.2.0 and hibernate 5.4.6 paging is not working properly for repositories. For this part of code in spring boot:
----
*protected <S extends T> TypedQuery<Long> getCountQuery(@Nullable Specification<S> spec, Class<S> domainClass) \{*
*CriteriaBuilder builder = this.em.getCriteriaBuilder();*
*CriteriaQuery<Long> query = builder.createQuery(Long.class);*
*Root<S> root = this.applySpecificationToCriteria(spec, domainClass, query);*
*if (query.isDistinct()) \{*
*query.select(builder.countDistinct(root));*
*} else \{*
*query.select(builder.count(root));*
*}*
*query.orderBy(Collections.emptyList());*
*return this.em.createQuery(query);*
*}*
----
the count query is not taking into account inherited entities and the query look like below:
----
*select count(keycloakfe0_.id) as col_0_0_*
*from keycloak_fed_mapper_ldap keycloakfe0_*
*inner join keycloak_federation keycloakfe1_ on keycloakfe0_1_.id_federation=keycloakfe1_.id*
*where keycloakfe1_.environment=?*
----
I've verified all versions since 5.4.0 to 5.4.8. Before version 5.4.5 query was ok. Query for version 5.4.4 is:
----
*select count(keycloakfe0_.id) as col_0_0_*
*from keycloak_fed_mapper_ldap keycloakfe0_*
*inner join keycloak_fed_mapper keycloakfe0_1_ on keycloakfe0_.id=keycloakfe0_1_.id*
*inner join keycloak_federation keycloakfe1_ on keycloakfe0_1_.id_federation=keycloakfe1_.id*
*where keycloakfe1_.environment=?*
----
The issue it that this bug ha has a big impact on spring repositories abstraction with paging mechanism.
I assue it may be related with this feature in 5.4.5 release
[https://hibernate.atlassian.net/browse/HHH-12993|https://hibernate.atlassian.net/browse/HHH-12993]
If more details required please let me know.
{noformat}{noformat}
|
|
