pgsql: Fix incorrect partition pruning logic for boolean partitioned ta

2023-04-13 Thread David Rowley
Fix incorrect partition pruning logic for boolean partitioned tables The partition pruning logic assumed that "b IS NOT true" was exactly the same as "b IS FALSE". This is not the case when considering NULL values. Fix this so we correctly include any partition which could hold NULL values for th

pgsql: Fix incorrect partition pruning logic for boolean partitioned ta

2023-04-13 Thread David Rowley
Fix incorrect partition pruning logic for boolean partitioned tables The partition pruning logic assumed that "b IS NOT true" was exactly the same as "b IS FALSE". This is not the case when considering NULL values. Fix this so we correctly include any partition which could hold NULL values for th

pgsql: Fix incorrect partition pruning logic for boolean partitioned ta

2023-04-13 Thread David Rowley
Fix incorrect partition pruning logic for boolean partitioned tables The partition pruning logic assumed that "b IS NOT true" was exactly the same as "b IS FALSE". This is not the case when considering NULL values. Fix this so we correctly include any partition which could hold NULL values for th

pgsql: Fix incorrect partition pruning logic for boolean partitioned ta

2023-04-13 Thread David Rowley
Fix incorrect partition pruning logic for boolean partitioned tables The partition pruning logic assumed that "b IS NOT true" was exactly the same as "b IS FALSE". This is not the case when considering NULL values. Fix this so we correctly include any partition which could hold NULL values for th

pgsql: Fix incorrect partition pruning logic for boolean partitioned ta

2023-04-13 Thread David Rowley
Fix incorrect partition pruning logic for boolean partitioned tables The partition pruning logic assumed that "b IS NOT true" was exactly the same as "b IS FALSE". This is not the case when considering NULL values. Fix this so we correctly include any partition which could hold NULL values for th

pgsql: Fix incorrect partition pruning logic for boolean partitioned ta

2023-04-13 Thread David Rowley
Fix incorrect partition pruning logic for boolean partitioned tables The partition pruning logic assumed that "b IS NOT true" was exactly the same as "b IS FALSE". This is not the case when considering NULL values. Fix this so we correctly include any partition which could hold NULL values for th