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

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(at)gmail(dot)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(at)gmail(dot)com> wrote:
>
>> Cool, thanks!
>>
>> pt., 9 sie 2019, 19:21 użytkownik Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> napisał:
>>
>>> =?UTF-8?Q?Piotr_W=C5=82odarczyk?= <piotrwlodarczyk89(at)gmail(dot)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
>