Rene Nielsen
11/02/2021, 10:33 PMgte
on a number.
I have some test documents, they contain a rating (number).
When i do a query that looks like this:
rating: {
gte: 3.5
}
I only get 5
results. Whereas im expecting 8
(Look at the list in the images).
If i do on the other hand make a small "hack" and subtract -00000.1 it works and i get 8. The 0.00001 was for testing, but confirmed my expectations.
rating: {
gte: 3.5-0.00001
}
If i do the query in mongodb shell i get 8
so its somewhere in the prisma client something is not doing as expected.
Im using prisma 3.3.0
with mongodbRyan
11/03/2021, 6:15 AMRene Nielsen
11/04/2021, 7:33 AM