ORA-01036 and ORA-00920 with bitwise AND operator

[kakone]

Hello,

I'm evaluating dotConnect for Oracle with EF Core 3.1. When I use a bitwise AND operator in my queries, I get the ORA-01036 or ORA-00920 exceptions.

This is my query :

Code: Select all

var kind = 1;
var thirdParties = dbContext.ThirdParties.Where(tp => (tp.Kind & kind) > 0).ToList();

I get the Devart.Data.Oracle.OracleException: 'ORA-01036: illegal variable name/number'

When I remove the variable :

Code: Select all

var thirdParties = dbContext.ThirdParties.Where(tp => (tp.Kind & 1) > 0).ToList();

I get the Devart.Data.Oracle.OracleException: 'ORA-00920: invalid relational operator'

What am I doing wrong?

[Shalex]

We have reproduced the issue and will notify you when it is fixed.

[kakone]

Any news on this?

[Shalex]

The bug with using binary operators AND, OR in EF Core 3 is fixed. We will notify you when the new public build of dotConnect for Oracle is available for download.

[Shalex]

dotConnect for Oracle v9.11.951 is released: viewtopic.php?f=1&t=39884.