From: | Piotr Włodarczyk <piotrwlodarczyk89(at)gmail(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
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 17:44:00 |
Message-ID: | CAP-dhMoGEhY9-WWbqCa2XC-RMRPDX-Xypu8kxo-HomeHLA1dPg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
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
From | Date | Subject | |
---|---|---|---|
Next Message | WrongFeiHung | 2019-08-09 22:02:17 | BUG IN PGAdmin 4 using AVG function |
Previous Message | Piotr Włodarczyk | 2019-08-09 17:23:10 | Re: Recovery mode with partitioned tables and ANY(NULL) in WHERE clause |