Affects Version/s: 2.4.2
Fix Version/s: None
Security Level: All
I have a DQL query with a ORDER BY clause.
When I paginate the result with new Paginator($query, $fetchJoinCollection = true); the orderind isn't correct.
The order is lost in the second request (Perform a Limit Subquery with DISTINCT to find all ids of the entity in from on the current page)
It creates a SQL query like that :
d0_.id AS id0,
d0_.name AS name1,
d0_.note AS note2,
20 OFFSET 0
The external SELECT don't keep the order so it just fetch the 20 first elements from the whole table.