Page has an incorrect total since 3.4.3

[Roberto-Mol]

We are using spring-data-jpa to perform a query using a JpaRepository that returns a Page object. I am seeing different behaviour with spring-data-jpa 3.4.2 compared to spring-data-jpa 3.4.3.

Use-case

• There are 44 records in my database table that should be found when running the query.
• I am asking paged results, with a page size of 20 and page number 1 (the second).

3.4.2

• The resulting page has a total of 44, independent of the page number I requested.

3.4.3

• The resulting page has a varying total, depending on the page number I requested:
  • page number 0 --> total = 20
  • page number 1 --> total = 40
  • page number 2 --> total = 44

I could not find anything in the release notes, and in my (not-so-informed) opinion the behaviour in 3.4.2 makes more sense. This feels like a bug to me.

I would appreciate any response, whether it's an explanation why this new result is better or whether it's a confirmation that I've indeed found a bug.

If this issue is not according to your standards, please let me know.

Edit
SimpleJpaRepository.readPage() returns a total of 44 independent of the specified page number (i.e. is correct).
JpaQueryExecution.doExecute() returns a total of 20/40/44 depending on the page number (i.e. is incorrect).

One of our endpoints does the search via a .findAll() call on a JpaRepository, which will trigger the SimpleJpaRepository.readPage() call, while another endpoint of us does the search via a custom method annotated with @query on a JpaRepository, which will trigger the JpaQueryExecution.doExecute().

Hopefully this helps. It helped me see that we have a possible work-around, though I still think there is a bug that should be resolved.

[mp911de]

If you would like us to spend some time helping you to diagnose the problem, please spend some time describing it and, ideally, providing a minimal yet complete sample that reproduces the problem.
You can share it with us by pushing it to a separate repository on GitHub or by zipping it up and attaching it to this issue.

[spring-projects-issues]

If you would like us to look at this issue, please provide the requested information. If the information is not provided within the next 7 days this issue will be closed.

[Roberto-Mol]

Thank you for your response. I have attached a minimal yet complete sample.
Simply run mvn clean install or execute the tests in SpringBootErrorTest.java.

You will see that the repository query tests fails, because the total elements are 3 (equal to page size) instead of 10. You will see that the specification test succeeds. This is with spring-boot-starter-parent version 3.4.3. using spring-data-jpa version 3.4.3.

If you change the version of spring-boot-starter-parent to 3.4.2 (using spring-data-jpa version 3.4.2), then you will see that both tests succeed.

I hereby conclude that there is a bug in spring-data-jpa version 3.4.3.

If you need any more information, please let me know.

Spring-Data-JPA-Page-Bug.zip

[mp911de]

This is a variant of #3784. Upgrading to Spring Data JPA 3.4.4 (in Spring Boot, setting <spring-data-bom.version>2024.1.4</spring-data-bom.version>) fixes the broken test for me.

[Roberto-Mol]

Thanks for your time and your suggestion. It worked like you said :).