Where expression on nullable enum with value conversion generates invalid query
Posted: Thu 06 Jun 2019 08:01
Similar to the issue in this post: viewtopic.php?f=30&t=38205&p=134188#p134188 but for nullable enums.
When using EFCore value conversions for nullable enum properties and performing a comparison in a where clause, Devart ignores the value expression and generates a query using the numeric value of the enum.
When using a non-nullable enum value, it works. E.g.:
However, when using making the enum property nullable, it generates an incompatible query (ORA-01722: invalid number):
will generate the following SQL statement
Database Provider: Devart.Data.Oracle.EFCore version 9.7.734
A repository reproducing the issue can be found here: https://github.com/LBRitsSES/devart-efc ... -bug-repro
When using EFCore value conversions for nullable enum properties and performing a comparison in a where clause, Devart ignores the value expression and generates a query using the numeric value of the enum.
When using a non-nullable enum value, it works. E.g.:
Code: Select all
dbContext
.Set<Rider>()
.Where(_ => _.Mount == EquineBeast.Mule)
.ToList();
Code: Select all
dbContext
.Set<Rider>()
.Where(_ => _.Mount != null && _.Mount.Value == EquineBeast.Mule)
.ToList();
Code: Select all
SELECT "_".ID,
"_".MOUNT
FROM RIDER "_"
WHERE ("_".MOUNT IS NOT NULL)
AND ("_".MOUNT = 1) /* This should be "_".MOUNT = 'Mule' */
A repository reproducing the issue can be found here: https://github.com/LBRitsSES/devart-efc ... -bug-repro