pgsql: Fix an oversight I introduced on 2003-12-28: find_nots/push_nots - Mailing list pgsql-committers

From tgl@svr1.postgresql.org (Tom Lane)
Subject pgsql: Fix an oversight I introduced on 2003-12-28: find_nots/push_nots
Date
Msg-id 20050729214004.1706152AAC@svr1.postgresql.org
Whole thread Raw
List pgsql-committers
Log Message:
-----------
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.

Modified Files:
--------------
    pgsql/src/backend/optimizer/prep:
        prepqual.c (r1.49 -> r1.50)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/optimizer/prep/prepqual.c.diff?r1=1.49&r2=1.50)

pgsql-committers by date:

Previous
From: bklawans@pgfoundry.org (User Bklawans)
Date:
Subject: bizgres - bizgres: Changed the default image url from "/images" to
Next
From: tgl@svr1.postgresql.org (Tom Lane)
Date:
Subject: pgsql: Back-patch fix for NOT-below-a-NOT case.