在group by之后，Spring Data JPA返回错误的totalElement计数

// 自定义分页查询方法
public Page<YourEntity> customGroupByQuery(Pageable pageable) {
    // 执行分组查询
    List<YourEntity> resultList = entityManager.createQuery("your group by query", YourEntity.class)
            .setFirstResult((int) pageable.getOffset())
            .setMaxResults(pageable.getPageSize())
            .getResultList();

    // 手动计算总记录数
    CriteriaBuilder criteriaBuilder = entityManager.getCriteriaBuilder();
    CriteriaQuery<Long> countQuery = criteriaBuilder.createQuery(Long.class);
    Root<YourEntity> root = countQuery.from(YourEntity.class);
    countQuery.select(criteriaBuilder.count(root));
    // 添加group by条件
    countQuery.groupBy(/* your group by conditions */);
    Long totalElements = entityManager.createQuery(countQuery).getSingleResult();

    return new PageImpl<>(resultList, pageable, totalElements);
}