Re: Recovery mode with partitioned tables and ANY(NULL) in WHERE clause - Mailing list pgsql-bugs

From Tom Lane
Subject Re: Recovery mode with partitioned tables and ANY(NULL) in WHERE clause
Date
Msg-id 9726.1565369142@sss.pgh.pa.us
Whole thread Raw
In response to Recovery mode with partitioned tables and ANY(NULL) in WHERE clause  (Piotr Włodarczyk <piotrwlodarczyk89@gmail.com>)
Responses Re: Recovery mode with partitioned tables and ANY(NULL) in WHERE clause  (Piotr Włodarczyk <piotrwlodarczyk89@gmail.com>)
List pgsql-bugs
=?UTF-8?Q?Piotr_W=C5=82odarczyk?= <piotrwlodarczyk89@gmail.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



pgsql-bugs by date:

Previous
From: Piotr Włodarczyk
Date:
Subject: Recovery mode with partitioned tables and ANY(NULL) in WHERE clause
Next
From: Piotr Włodarczyk
Date:
Subject: Re: Recovery mode with partitioned tables and ANY(NULL) in WHERE clause