Description
I ran into an issue with the Paginator which I think could be handled to prevent it.
I am using the Paginator to paginate a table.
The user can choose the number of items by page (10 ,20, ... but also All items).
In the case the user choose to display All items, the LIMIT clause will NOT be added to the query.
Even if the Paginator is not required in this scenario, the same part of code handle this case so we also give the query to the Paginator.
This is working property unless the query return too many results.
Because the Paginator will use a WHERE IN query and it could reach the limit of allowed number of parameters by the database engine.
See: https://www.doctrine-project.org/projects/doctrine-orm/en/2.6/tutorials/pagination.html
This is what we are encountering on tables with thousands of items on SQL Server.