Обсуждение: pgsql: Fix partition pruning with IS [NOT] NULL clauses
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 <ashutosh.bapat@enterprisedb.com> Co-authored-by: Dilip Kumar <dilipbalaut@gmail.com> Co-authored-by: Amit Langote <Langote_Amit_f8@lab.ntt.co.jp> Co-authored-by: Álvaro Herrera <alvherre@alvh.no-ip.org> Reviewed-by: Ashutosh Bapat <ashutosh.bapat@enterprisedb.com> Reviewed-by: amul sul <sulamul@gmail.com> 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(-)