`@QueryHints` not applied for count queries during pagination using Hibernate

[arunlakra7]

Example JPA query:

@query("""
SELECT document
FROM DocumentDto document
WHERE (:ids is null OR document.id IN :ids)
""")
@QueryHints(@QueryHint(name = "jakarta.persistence.query.timeout", value = "2000"))
Page findAllBy(
@param("ids") List ids,
Pageable pageable
);

After migrating to Spring 4.0.0 timeout query hint is not applied on the count query even though it is true by default. The count query lasted for 20 seconds

[mp911de]

This is a new behavior introduced by Spring Data JPA leveraging Hibernate's SelectionQuery.getResultCount() instead of Spring Data deriving and running an count query on its own. The underlying query is configured with hints but these are not applied (see SqmSelectionQueryImpl.getResultCount() that uses QueryOptions.NONE to run the count query).

You might want to reach out to the Hibernate team to get more details why this is and whether there's an intent to pass on query options.