Figure 2-4 shows the results of predicates when 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