Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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)

pgsql-committers by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group