The figure below shows results of predicates on which logical operations are performed.
The result of a predicate (other than the NULL predicate) that contains the null value is undefined.
A predicate that produces the null value is ineligible for retrieval.
Figure 2-4 Results of predicates on which logical operations are performed