Horton

Support partition pruning on boolcol IS [NOT] UNKNOWN

David Rowley <drowley@postgresql.org>

View on postgr.es
Commit: 07c36c1333e00df5a4baf6b04ba2f3f300f57d69
Author: David Rowley <drowley@postgresql.org>
Date: 2024-03-04T01:40:22Z
Releases: 17.0 
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

Files

PathChange+/−
src/backend/partitioning/partprune.c modified +40 −31
src/test/regress/expected/partition_prune.out modified +46 −10
src/test/regress/sql/partition_prune.sql modified +7 −0

Discussion