pgsql: Support partition pruning on boolcol IS [NOT] UNKNOWN

From: David Rowley <drowley(at)postgresql(dot)org>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: Support partition pruning on boolcol IS [NOT] UNKNOWN
Date: 2024-03-04 01:45:10
Message-ID: E1rgxOA-001xRk-2R@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Support partition pruning on boolcol IS [NOT] UNKNOWN

While working on 4c2369ac5, I noticed we went out of our way not to
support clauses on boolean partitioned tables in the form of "IS
UNKNOWN" and "IS NOT UNKNOWN". It's almost as much code to disallow
this as it is to allow it, so let's allow it.

Discussion: https://postgr.es/m/CAApHDvobKtcN6+xOuOfcutfp6T7jP=JPA9y3=MAEqnuKdDsQrw@mail.gmail.com

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/07c36c1333e00df5a4baf6b04ba2f3f300f57d69

Modified Files
--------------
src/backend/partitioning/partprune.c | 71 +++++++++++++++------------
src/test/regress/expected/partition_prune.out | 56 +++++++++++++++++----
src/test/regress/sql/partition_prune.sql | 7 +++
3 files changed, 93 insertions(+), 41 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message David Rowley 2024-03-04 04:42:31 pgsql: Optimize GenerationAlloc() and SlabAlloc()
Previous Message Michael Paquier 2024-03-04 01:37:58 pgsql: Add PostgreSQL::Test::Cluster::wait_for_event()