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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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)

Browse pgsql-committers by date

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