Thanks for working on this.
On Sun, 7 May 2023 at 15:37, Jonathan S. Katz <jkatz@postgresql.org> wrote:
> Please provide any suggestions, corrections, or notable omissions no
> later than 2023-05-11 0:00 AoE.
For this one:
> * Fix partition pruning logic for partitioning on boolean columns when using a
> `IS NOT TRUE` condition.
Just to explain this a little further: Effectively the code thought
"IS NOT TRUE" meant "IS FALSE", and "IS NOT FALSE" meant "IS TRUE".
That was wrong because each of the NOT cases should have allowed
NULLs.
Maybe the wording can be adjusted to mention NULLs. Maybe something
along the lines of:
* Fix partition pruning bug with the boolean "IS NOT TRUE" and "IS NOT
FALSE" conditions. NULL partitions were accidentally pruned when they
shouldn't have been.
David