Details
Description
There's the ORA-01795 error in Oracle. It's description is:
ORA-01795 maximum number of expressions in a list is 1000 error
We should review the RDBBlobStore and RDBDocumentStoreJDBC and split lists longer than 1000 elements to chunks.
For instance, if the limit would be 3, then our lists can be split as follows:
... XYZ in (?,?,?,?,?,?,?,?) // initial version ... (XYZ in (?,?,?) or XYZ in (?,?,?) or XYZ in (?,?)) // fixed version
In the patch for OAK-3637 there's RDBDocumentStoreJDBC#appendInCondition method that appends appropriate expression to the query. It should be used every time we have an in operator with variable number of placeholders.