Logical operators
Logical operators
Effect of NULL
on logical operators
NULL
on logical operatorsAND
AND
The result of an AND
comparison may be NULL
if one or both sides of the expression are NULL
.
If, however, at least one side of an AND
operator is FALSE
, then the expression evaluates to FALSE
.
Transformation job example
SQL:
Note that the example above casts null
as a boolean
since using an untyped null is not currently supported and logical operators expect boolean
inputs.
Query result:
OR
OR
The result of an OR
comparison may be NULL
if one or both sides of the expression are NULL
.
If, however, at least one side of an OR
operator is TRUE
the expression evaluates to TRUE
.
Transformation job example
SQL:
Query result:
AND
and OR
truth table
AND
and OR
truth tableThe following truth table demonstrates the handling of NULL
in AND
and OR
:
NOT
NOT
The logical complement of NULL
is NULL
as shown in the following example with a transformation job.
SQL:
Query result:
NOT
truth table
NOT
truth tableThe following truth table demonstrates the handling of NULL
in NOT
:
Last updated