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

pgsql: Fix predicate-proving logic to cope with binary-compatibility

From: tgl(at)postgresql(dot)org (Tom Lane)
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Fix predicate-proving logic to cope with binary-compatibility
Date: 2007-07-24 17:22:13
Message-ID: 20070724172213.CADB09FB9CA@postgresql.org (view raw, whole thread or download thread mbox)
Thread:
Lists: pgsql-committers
Log Message:
-----------
Fix predicate-proving logic to cope with binary-compatibility cases when
checking whether an IS NULL/IS NOT NULL clause is implied or refuted by
a strict function.  Per example from Dawid Kuroczko.
Backpatch to 8.2 since this is arguably a performance bug.

Tags:
----
REL8_2_STABLE

Modified Files:
--------------
    pgsql/src/backend/optimizer/util:
        predtest.c (r1.10.2.1 -> r1.10.2.2)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/optimizer/util/predtest.c.diff?r1=1.10.2.1&r2=1.10.2.2)

pgsql-committers by date

Next:From: Neil ConwayDate: 2007-07-25 04:19:09
Subject: pgsql: Implement RETURN QUERY for PL/PgSQL.
Previous:From: Tom LaneDate: 2007-07-24 17:22:07
Subject: pgsql: Fix predicate-proving logic to cope with binary-compatibility

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