From: | David Rowley <david(dot)rowley(at)2ndquadrant(dot)com> |
---|---|
To: | Amit Langote <amitlangote09(at)gmail(dot)com> |
Cc: | Rares Salcudean <rares(dot)salcudean(at)takeofflabs(dot)com>, PostgreSQL mailing lists <pgsql-bugs(at)lists(dot)postgresql(dot)org> |
Subject: | Re: PG11 - Multiple Key Range Partition |
Date: | 2019-07-10 10:06:39 |
Message-ID: | CAKJS1f-nSS5qghw0WaokHchyjwmV6grE6qg02Ve0RuHOjCUHmw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
On Wed, 10 Jul 2019 at 21:02, Amit Langote <amitlangote09(at)gmail(dot)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 | Content-Type | Size |
---|---|---|
fix_boolean_partition_pruning.patch | application/octet-stream | 7.8 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Rares Salcudean | 2019-07-10 11:14:32 | Re: PG11 - Multiple Key Range Partition |
Previous Message | Haribabu Kommi | 2019-07-10 09:53:51 | Re: BUG #15889: PostgreSQL failed to build due to error MSB8020 with MSVC on windows |