projects / users / rhaas / postgres.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: eca2c1e) | patch
Support partition pruning on boolcol IS [NOT] UNKNOWN
authorDavid Rowley <drowley@postgresql.org>
Mon, 4 Mar 2024 01:40:03 +0000 (14:40 +1300)
committerDavid Rowley <drowley@postgresql.org>
Mon, 4 Mar 2024 01:40:22 +0000 (14:40 +1300)
commit07c36c1333e00df5a4baf6b04ba2f3f300f57d69
tree4fb527508736e7e5e96ddaa6404ba15cc6f05605tree
parenteca2c1ea85eb22716f93339f4e7cec3145c25723commit | diff
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
src/backend/partitioning/partprune.c diff | blob | blame | history
src/test/regress/expected/partition_prune.out diff | blob | blame | history
src/test/regress/sql/partition_prune.sql diff | blob | blame | history
Robert Haas's development tree.