ORA-00913: too many values
Posted: Tue 24 Mar 2020 11:11
We are using Devart.Data.Oracle.EFCore - v9.10.909 in our EF Core 3.1.1 project.
We've found a new regression, which wasn't there when we were using EF Core 2.2.
We have some lists which may contain more than 1,000 elements, on which we make '.Contains()' queries.
In the past it has worked just fine, the SQL generated had the list split into multiple IN clauses.
In the new version we're getting the ORA-00913 error, and in the generated SQL we can see that there is no separation into multiple IN clauses.
In the mean time, our solution was to create our own implementation of splitting the query into multiple IN clauses. But we would appreciate a fix for this, as this has been working perfectly in the past.
*Edit:* Apologies, I think I should have posted in the Entity Framework section, not dotConnect. Please move this topic if I made a mistake.
We've found a new regression, which wasn't there when we were using EF Core 2.2.
We have some lists which may contain more than 1,000 elements, on which we make '.Contains()' queries.
In the past it has worked just fine, the SQL generated had the list split into multiple IN clauses.
In the new version we're getting the ORA-00913 error, and in the generated SQL we can see that there is no separation into multiple IN clauses.
In the mean time, our solution was to create our own implementation of splitting the query into multiple IN clauses. But we would appreciate a fix for this, as this has been working perfectly in the past.
*Edit:* Apologies, I think I should have posted in the Entity Framework section, not dotConnect. Please move this topic if I made a mistake.