Bug with EFCore 2 - ORA-00920

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
seb1487
Posts: 23
Joined: Fri 24 Jun 2016 10:27

Bug with EFCore 2 - ORA-00920

Post by seb1487 » Mon 05 Feb 2018 14:45

Hi,
dotConnect throws an error on an boolean Query like this (Oracle 10):

Code: Select all

dbContext.Class1.Any(o => o.MyBoolProp);
Error:
'ORA-00920: invalid relational operator'

Generated SQL:

Code: Select all

SELECT CASE
    WHEN EXISTS (
        SELECT 1
        FROM "Class1" "o"
        WHERE "o"."MyBoolProp")
    THEN 1 ELSE 0
END
FROM DUAL

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Re: Bug with EFCore 2 - ORA-00920

Post by Shalex » Wed 07 Feb 2018 17:56

Thank you for your report. We will notify you when the issue is fixed.

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Re: Bug with EFCore 2 - ORA-00920

Post by Shalex » Thu 08 Feb 2018 15:05

The bug with using bool properties in the .Any() clause of LINQ query in EF Core 2 is fixed. We have sent the internal build with the fix to your email.

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Re: Bug with EFCore 2 - ORA-00920

Post by Shalex » Thu 15 Feb 2018 18:43

New build of dotConnect for Oracle 9.5.454 is available for download now: viewtopic.php?f=1&t=36602.

Post Reply