Skip to content

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

Open
@spring-projects-issues

Description

@spring-projects-issues

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:

Metadata

Metadata

Assignees

Labels

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions