count method in JpaSpecificationExecutor ignores GROUP BY and returns wrong result. [DATAJPA-1573]

Dimitri opened DATAJPA-1573 and commented

I have this code:

public Predicate toPredicate(Root<User> root, CriteriaQuery<?> query, CriteriaBuilder builder){ 
... 
query.groupBy(root.get("id")); 
... 
}

Method

Repository.count(specification)

ignores GROUP BY and returns wrong result, while

Repository.findAll(specification).size()

returns right result.

This issue looks similiar to this problem: https://jira.spring.io/browse/DATAJPA-656

Affects: 2.1.9 (Lovelace SR9)

Attachments:

• datajpa-1573.zip (89.10 kB)