Re: Recovery mode with partitioned tables and ANY(NULL) in WHERE clause

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Piotr Włodarczyk <piotrwlodarczyk89(at)gmail(dot)com>
Cc: pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: Recovery mode with partitioned tables and ANY(NULL) in WHERE clause
Date: 2019-08-09 16:45:42
Message-ID: 9726.1565369142@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

=?UTF-8?Q?Piotr_W=C5=82odarczyk?= <piotrwlodarczyk89(at)gmail(dot)com> writes:
> I think we found BUG in version from 11.4 to 11.5 (maybe and previous).

Yeah, looks like the ScalarArrayOpExpr path in
match_clause_to_partition_key forgot to consider the possibility
of a constant-null array. Will fix, thanks for the report!

regards, tom lane

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Piotr Włodarczyk 2019-08-09 16:50:31 Re: Recovery mode with partitioned tables and ANY(NULL) in WHERE clause
Previous Message Piotr Włodarczyk 2019-08-09 16:28:37 Recovery mode with partitioned tables and ANY(NULL) in WHERE clause