Less results than expected on each page

[clem983]

Hi,

I installed PagerFanta on my Symfony 3.3 project.

I have a query with 8 leftJoin, which is supposed to return 380 results on my test. The table contains bookings. After migrating my controller to work with pager fanta and 100 max results per page, I have less than 100 results on each page (79, 56, 57 and 71 respectively). I tried to simplify the query and, when deleting a leftJoin about the payments, it works.

The pagerfanta nbResults function returns always 380. It's only a problem with currentPageResults.

I don't understand how this leftJoin can generate a problem: can there be something missing in the entity? What to check? What can I send you to give more details?

Thank you very much :)