Postgres Pro
Downloads
Home   >   mailing lists

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

From Piotr Włodarczyk
Subject Re: Recovery mode with partitioned tables and ANY(NULL) in WHERE clause
Date
Msg-id CAP-dhMp8BPRK_Vt-=sni+Uek8hO+boXgUEHRvbOkgOYvoKdKRw@mail.gmail.com
Whole thread Raw
In response to Re: Recovery mode with partitioned tables and ANY(NULL) in WHERE clause  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Recovery mode with partitioned tables and ANY(NULL) in WHERE clause  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
Tree view
Thanks for replay Tom,

Can you tell me in which versions it'll be fixed? For me it's critical situation because we can have some potentially dangerous places in application. 

On Fri, Aug 9, 2019 at 6:45 PM Tom Lane <tgl@sss.pgh.pa.us> wrote:
Piotr Włodarczyk <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


--

Pozdrawiam
Piotr Włodarczyk

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: Recovery mode with partitioned tables and ANY(NULL) in WHERE clause
Next
From: Tom Lane
Date:
Subject: Re: Recovery mode with partitioned tables and ANY(NULL) in WHERE clause