When inserting double.NaN, Entity State is always Modified

[NepPure]

Version:
https://www.nuget.org/packages/Oracle.EntityFrameworkCore/2.19.80

After calling dbcontext.SaveChanges, the state of the entity becomes Modified.

This may be a problem in implementing the double type comparison.

[NepPure]

Nullable double, insert NaN

public double? TestNumber {get; set;}

[alexkeh]

I've been able to reproduce the issue with EF Core 2.x and 3.1. I've filed bug 31785728 so that my dev team can investigate.

[NepPure]

I've been able to reproduce the issue with Postgresql, may be a problem in ef core.

[alexkeh]

@roji

[roji]

Thanks for pinging me, there indeed seem to be some EF-side issues around NaN. Will post back soon.

[roji]

I've submitted a fix to EF Core, please take a look at npgsql/efcore.pg#1472 and dotnet/efcore#22168. The code in the PR can be used as-is inside a provider's mapping, so you shouldn't need to block on the PR getting merged.

See also npgsql/efcore.pg#1472 which adds some functionality to the PostgreSQL provider (literal SQL generation and method translation for the testing methods on double).

[alexkeh]

Thanks, @roji! I'll ask my team to review the npgsql changes when they address this bug.