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-dhMrCaomXREVk--xRdhEkjE1CT-CWt4074Ez4zp1zJc_N+A@mail.gmail.com
Whole thread Raw
In response to Re: 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  (David Rowley <david.rowley@2ndquadrant.com>)
List pgsql-bugs
Hi,

In V12 this bug exists too. Is your commit going to be part of V12? 

pt., 9 sie 2019, 19:44 użytkownik Piotr Włodarczyk <piotrwlodarczyk89@gmail.com> napisał:
Hi,

I've checked your commit and let me ensue it's fulfill all cases. For example what with query like that: select * from coercepart where a = any(null); ? there is no casting to array of specified type. I'm not master in C but looking in source I believe that "if (array->const snull)" is enough. But for better check you can add that query (and similar) to tests/regress



On Fri, Aug 9, 2019 at 7:23 PM Piotr Włodarczyk <piotrwlodarczyk89@gmail.com> wrote:
Cool, thanks! 

pt., 9 sie 2019, 19:21 użytkownik Tom Lane <tgl@sss.pgh.pa.us> napisał:
Piotr Włodarczyk <piotrwlodarczyk89@gmail.com> writes:
> 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.

Unfortunately this just missed this week's releases, so it'll be the
next quarterly releases in November.

If you're sufficiently worried about it you could apply the patch locally.
It's pretty trivial:

https://git.postgresql.org/pg/commitdiff/2f729d83226705d1149419a2aef7c1678fe641ec

                        regards, tom lane


--

Pozdrawiam
Piotr Włodarczyk

pgsql-bugs by date:

Previous
From: Michael Paquier
Date:
Subject: Re: 回复: BUG #15949: pg_basebackupfailed(PG-12-Beta3)
Next
From: David Rowley
Date:
Subject: Re: Recovery mode with partitioned tables and ANY(NULL) in WHERE clause