not: true query with null values does not work

[cesarve77]

Bug description

if a boolean field has true, false and nulls values, the query for not true values does not take in count nulls values.

const countNotTrue = await prisma.test.count({where: {bol: {not: true}}})

How to reproduce

git clone https://github.com/cesarve77/prisma-not-true-query
npm i
npx jest

Expected behavior

a query

{where: {bol: {not: true}}

should return false + null values

Prisma information

in the repo

Environment & setup

• OS: macOS 14.4.1 (23E224)
• Database: SQLite
• Node.js version: v20.13.1

Prisma Version

prisma                  : 5.14.0
@prisma/client          : 5.14.0
Computed binaryTarget   : darwin-arm64
Operating System        : darwin
Architecture            : arm64
Node.js                 : v20.13.1
Query Engine (Node-API) : libquery-engine e9771e62de70f79a5e1c604a2d7c8e2a0a874b48 (at node_modules/@prisma/engines/libquery_engine-darwin-arm64.dylib.node)
Schema Engine           : schema-engine-cli e9771e62de70f79a5e1c604a2d7c8e2a0a874b48 (at node_modules/@prisma/engines/schema-engine-darwin-arm64)
Schema Wasm             : @prisma/prisma-schema-wasm 5.14.0-25.e9771e62de70f79a5e1c604a2d7c8e2a0a874b48
Default Engines Hash    : e9771e62de70f79a5e1c604a2d7c8e2a0a874b48
Studio                  : 0.500.0

[janpio]

@cesarve77 The reproduction repository is unfortunately private right now, I can not access it.

Without having looked at the actual code and trying it out, this might very well be expected behavior as Prisma treats nulls the same way as databases (as it just translates the Prisma Client query into SQL, and then the database does its usual thing) and treats them as "not real values" - so not: true does not apply to null and only filters to false values. A solution might be to also filter for null values by using OR. But we'll know more when I can try your code.

[cesarve77]

The repo now is public.

Maybe what I am looking for is the why to so this:

SELECT count(*) FROM public."Test" Where bol is not true;

Which will return my expected result.