Cannot get model with null condition #228
Description
Current behavior
It is not possible to get a model for which a specific property is null.
const db = factory({
user: {
id: primaryKey(Number),
deletedAt: nullable(Number),
},
});
db.user.create({
id: 1,
deletedAt: null
});
db.user.create({
id: 2,
deletedAt: new Date().getTime()
});
const deletedUsers = db.user.findMany({ where: { deletedAt: { equals: null } } });
console.log(deletedUsers);
// -> []Minimum reproduction code
https://codesandbox.io/s/inspiring-fog-wesv28?file=/index.js
Expected behavior
It seems that the compileQuery function is returning false if the property value is null.
I think it needs to flow to subsequent processing even if the property value is null.
data/src/query/compileQuery.ts
Lines 35 to 39 in c7fef7b