is there any limitation for `notIn` operator? for...
# orm-help
y
is there any limitation for
notIn
operator? for example we have 5 users, 3 is in the condition and 2 is not. if we execute
prisma.user.findMany({where: {notIn: [...]}})
will return 7 result. the above is to clarify the problem and the real count may be 5000 items in
notIn
clause which returns wrong result. But
prisma.user.count(...)
and
prisma.user.findMany({where: {NOT: {in: []}}})
are ok