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

From: tgl(at)svr1(dot)postgresql(dot)org (Tom Lane)
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Fix an oversight I introduced on 2003-12-28: find_nots/push_nots
Date: 2005-07-29 21:40:04
Message-ID: 20050729214004.1706152AAC@svr1.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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)

Browse pgsql-committers by date

  From Date Subject
Next Message Tom Lane 2005-07-29 21:40:28 pgsql: Back-patch fix for NOT-below-a-NOT case.
Previous Message User Bklawans 2005-07-29 21:22:14 bizgres - bizgres: Changed the default image url from "/images" to