Closed
Description
Affects v5.3.0+
How to Reproduce
var result = session.Query<Entity>().Where(e => e.DecimalValue != null && (offset + e.DecimalValue) == test).ToList();
var result = session.Query<Entity>().Where(e => e.IntValue != null && (offset + (decimal?)e.IntValue) == test).ToList();
Where offset
and test
are decimal
or decimal?
types.
Expected Result
result
contains a list of entities where the equality condition matches.
This works fine for PostgreSQL and MS SQL Server.
Actual Result
SQLite gives no errors and always produces 0 results.