findBy with more than 2100 parameters generates an error in SQL Server

[bsauvajon26]

Bug Report

Q	A
BC Break	yes
Version	2.11

Summary

findBy with more than 2100 parameters generates an error in SQL Server due to its limitation on the number of parameters in an IN clause.

Current behavior

Error:
An exception occurred while executing a query: SQLSTATE[IMSSP]: Tried to bind parameter number 2101. SQL Server supports a maximum of 2100 parameters.

How to reproduce

On MSSQL

private EntityRepository $doctrineRepository;
$ids = [1,2,... ,2101];
$this->doctrineRepository->findBy(['id' => $ids ])

Expected behavior

Doctrine should handle cases where the number of parameters exceeds 2100.

[derrabus]

How should the ORM work around this limitation?

[bsauvajon26]

In our case: Split the query into multiple smaller queries, each with a maximum of 2100 parameters, and then aggregate the results.

But it may be complicated if there are more than one condition

[derrabus]

… and close to impossible if you want to sort the result.

[derrabus]

tbh, my favorite solution would be to close this as a won't fix. Maybe we can document the limitation and possible workarounds.

[greg0ire]

| Q | A
|------------ | ------
| BC Break | yes
| Version | 2.11

Is this accurate? Did you just upgrade from 2.10 (or lower?) to 2.11 and hit this bug?