| 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: | Whole Thread | Raw Message | 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 |