pgsql: Fix partition pruning with IS [NOT] NULL clauses
pgsql: Fix partition pruning with IS [NOT] NULL clauses
От:
Alvaro Herrera <alvherre@alvh.no-ip.org>
Дата:
Fix partition pruning with IS [NOT] NULL clauses The original code was unable to prune partitions that could not possibly contain NULL values, when the query specified less than all columns in a multicolumn partition key. Reorder the if-tests so that it is, and add more commentary and regression tests. Reported-by: Ashutosh Bapat Co-authored-by: Dilip Kumar Co-authored-by: Amit Langote Co-authored-by: Álvaro Herrera Reviewed-by: Ashutosh Bapat Reviewed-by: amul sul Discussion: https://postgr.es/m/CAFjFpRc7qjLUfXLVBBC_HAnx644sjTYM=qVoT3TJ840HPbsTXw@mail.gmail.com Branch ------ master Details ------- https://git.postgresql.org/pg/commitdiff/e353389d24da48c708f72379f87e9b518baac521 Modified Files -------------- src/backend/partitioning/partprune.c | 78 ++++++++++++++------------- src/test/regress/expected/partition_prune.out | 41 ++++++++++++++ src/test/regress/sql/partition_prune.sql | 7 +++ 3 files changed, 90 insertions(+), 36 deletions(-)