EF Core 3.1 - Except - ORA-00907 exception

kakone · Post by **kakone** » Tue 18 Feb 2020 16:27

Hello,

When I use the Except method, I get an ORA-00933 or ORA-00907 exception :

var test = dbContext.ThirdParties.Except(dbContext.ThirdParties.Skip(5).Take(10)).FirstOrDefault();

The generated SQL contains the EXCEPT keyword (instead of MINUS in Oracle).

Shalex · Post by **Shalex** » Tue 25 Feb 2020 16:05

Thank you for your report. We have reproduced the bug and will notify you when it is fixed.

Shalex · Post by **Shalex** » Sat 04 Apr 2020 12:27

The bug with generating EXCEPT instead of MINUS in SQL produced by EF Core 3.1 is fixed in v9.11.980: viewtopic.php?f=1&t=40466.

Devart Forums