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

pgsql: Improve predicate_refuted_by_simple_clause() to handle IS NULL

From: tgl(at)postgresql(dot)org (Tom Lane)
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Improve predicate_refuted_by_simple_clause() to handle IS NULL
Date: 2007-05-12 19:22:35
Message-ID: 20070512192235.9FF039FB326@postgresql.org (view raw or flat)
Thread:
Lists: pgsql-committers
Log Message:
-----------
Improve predicate_refuted_by_simple_clause() to handle IS NULL and IS NOT NULL
more completely.  The motivation for having it understand IS NULL at all was
to allow use of "foo IS NULL" as one of the subsets of a partitioning on
"foo", but as reported by Aleksander Kmetec, it wasn't really getting the job
done.  Backpatch to 8.2 since this is arguably a performance bug.

Modified Files:
--------------
    pgsql/src/backend/optimizer/util:
        predtest.c (r1.14 -> r1.15)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/optimizer/util/predtest.c.diff?r1=1.14&r2=1.15)

pgsql-committers by date

Next:From: Tom LaneDate: 2007-05-12 19:22:43
Subject: pgsql: Improve predicate_refuted_by_simple_clause() to handle IS NULL
Previous:From: User PgunittestDate: 2007-05-12 19:02:36
Subject: pgunittest - pgUnitTest:

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