Page 1 of 1

EF Core 3.1 - Except - ORA-00907 exception

Posted: Tue 18 Feb 2020 16:27
by kakone
Hello,

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

Code: Select all

var test = dbContext.ThirdParties.Except(dbContext.ThirdParties.Skip(5).Take(10)).FirstOrDefault();
The generated SQL contains the EXCEPT keyword (instead of MINUS in Oracle).

Re: EF Core 3.1 - Except - ORA-00907 exception

Posted: Tue 25 Feb 2020 16:05
by Shalex
Thank you for your report. We have reproduced the bug and will notify you when it is fixed.

Re: EF Core 3.1 - Except - ORA-00907 exception

Posted: Sat 04 Apr 2020 12:27
by Shalex
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.