Fix an oversight I introduced on 2003-12-28: find_nots/push_nots should

Tom Lane <tgl@sss.pgh.pa.us>

Commit: 284e4739ef898807202337f830eee38ad7de18fc
Author: Tom Lane <tgl@sss.pgh.pa.us>
Date: 2005-07-29T21:40:02Z
Releases: 8.1.0
Fix an oversight I introduced on 2003-12-28: find_nots/push_nots should
continue to recurse after eliminating a NOT-below-a-NOT, since the
contained subexpression will now be part of the top-level AND/OR structure
and so deserves to be simplified.  The real-world impact of this is
probably minimal, since it'd require at least three levels of NOT to make
a difference, but it's still a bug.
Also remove some redundant tests for NULL subexpressions.

Files

PathChange+/−
src/backend/optimizer/prep/prepqual.c modified +10 −19