pgsql: Fix incorrect pruning of NULL partition for boolean IS NOT claus

2024-02-19 Thread David Rowley
Fix incorrect pruning of NULL partition for boolean IS NOT clauses Partition pruning wrongly assumed that, for a table partitioned on a boolean column, a clause in the form "boolcol IS NOT false" and "boolcol IS NOT true" could be inverted to correspondingly become "boolcol IS true" and "boolcol I

pgsql: Fix incorrect pruning of NULL partition for boolean IS NOT claus

2024-02-19 Thread David Rowley
Fix incorrect pruning of NULL partition for boolean IS NOT clauses Partition pruning wrongly assumed that, for a table partitioned on a boolean column, a clause in the form "boolcol IS NOT false" and "boolcol IS NOT true" could be inverted to correspondingly become "boolcol IS true" and "boolcol I

pgsql: Fix incorrect pruning of NULL partition for boolean IS NOT claus

2024-02-19 Thread David Rowley
Fix incorrect pruning of NULL partition for boolean IS NOT clauses Partition pruning wrongly assumed that, for a table partitioned on a boolean column, a clause in the form "boolcol IS NOT false" and "boolcol IS NOT true" could be inverted to correspondingly become "boolcol IS true" and "boolcol I

pgsql: Fix incorrect pruning of NULL partition for boolean IS NOT claus

2024-02-19 Thread David Rowley
Fix incorrect pruning of NULL partition for boolean IS NOT clauses Partition pruning wrongly assumed that, for a table partitioned on a boolean column, a clause in the form "boolcol IS NOT false" and "boolcol IS NOT true" could be inverted to correspondingly become "boolcol IS true" and "boolcol I

pgsql: Fix incorrect pruning of NULL partition for boolean IS NOT claus

2024-02-19 Thread David Rowley
Fix incorrect pruning of NULL partition for boolean IS NOT clauses Partition pruning wrongly assumed that, for a table partitioned on a boolean column, a clause in the form "boolcol IS NOT false" and "boolcol IS NOT true" could be inverted to correspondingly become "boolcol IS true" and "boolcol I

pgsql: Fix incorrect pruning of NULL partition for boolean IS NOT claus

2024-02-19 Thread David Rowley
Fix incorrect pruning of NULL partition for boolean IS NOT clauses Partition pruning wrongly assumed that, for a table partitioned on a boolean column, a clause in the form "boolcol IS NOT false" and "boolcol IS NOT true" could be inverted to correspondingly become "boolcol IS true" and "boolcol I