A where-clause tree on one row, with SQL's three-valued logic: unknown (null) stays unknown through not, and and / or decide on it only when another child settles the result.
not
and
or
not unknown
false and unknown
true and unknown
true or unknown
false or unknown
A where-clause tree on one row, with SQL's three-valued logic: unknown (null) stays unknown through
not, andand/ordecide on it only when another child settles the result.not unknownfalse and unknowntrue and unknowntrue or unknownfalse or unknown