Postgres Pro
Downloads
Home   >   mailing lists

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

From tgl@postgresql.org (Tom Lane)
Subject pgsql: Fix predicate-proving logic to cope with binary-compatibility
Date
Msg-id 20070724172213.CADB09FB9CA@postgresql.org
Whole thread Raw
List pgsql-committers
Tree view 
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:

Previous
From: tgl@postgresql.org (Tom Lane)
Date:
Subject: pgsql: Fix predicate-proving logic to cope with binary-compatibility
Next
From: neilc@postgresql.org (Neil Conway)
Date:
Subject: pgsql: Implement RETURN QUERY for PL/PgSQL.