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.
ORA-00913: too many values
Re: ORA-00913: too many values
The bug with using collections with more than 1000 items in a .Contains() method in EF Core 3 is fixed. We will notify you when the new public build of dotConnect for Oracle is available for download.
-
- Posts: 22
- Joined: Tue 24 Mar 2020 11:02
Re: ORA-00913: too many values
Great to hear! Thanks for the quick handling of this problem.
Re: ORA-00913: too many values
New build of dotConnect for Oracle 9.11.980 is available for download now: viewtopic.php?f=1&t=40466.
-
- Posts: 22
- Joined: Tue 24 Mar 2020 11:02
Re: ORA-00913: too many values
Great! Thank you for the heads up.