Re: PG11 - Multiple Key Range Partition - Mailing list pgsql-bugs

From David Rowley
Subject Re: PG11 - Multiple Key Range Partition
Date
Msg-id CAKJS1f-nSS5qghw0WaokHchyjwmV6grE6qg02Ve0RuHOjCUHmw@mail.gmail.com
Whole thread Raw
In response to Re: PG11 - Multiple Key Range Partition  (Amit Langote <amitlangote09@gmail.com>)
Responses Re: PG11 - Multiple Key Range Partition  (Rares Salcudean <rares.salcudean@takeofflabs.com>)
List pgsql-bugs
On Wed, 10 Jul 2019 at 21:02, Amit Langote <amitlangote09@gmail.com> wrote:
>
> On Wed, Jul 10, 2019 at 5:37 PM David Rowley
> > Thanks for making the test case. It is a bug.  There's a problem in
> > match_clause_to_partition_key() where because
> > match_boolean_partition_clause() returns false for the "NOT b"
> > condition when comparing to the first partition key this causes the
> > function to return PARTCLAUSE_UNSUPPORTED which causes the calling
> > function to not bother trying to match that qual up to any other
> > partition key.
>
> Oops, indeed a bug.  Should've returned PARTCLAUSE_NOMATCH there.

Here's a first draft fix for this, based on master.

-- 
 David Rowley                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services

Attachment

pgsql-bugs by date:

Previous
From: Haribabu Kommi
Date:
Subject: Re: BUG #15889: PostgreSQL failed to build due to error MSB8020 withMSVC on windows
Next
From: Rares Salcudean
Date:
Subject: Re: PG11 - Multiple Key Range Partition