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

Поиск
Список
Период
Сортировка
От Piotr Włodarczyk
Тема Re: Recovery mode with partitioned tables and ANY(NULL) in WHERE clause
Дата
Msg-id CAP-dhMp8BPRK_Vt-=sni+Uek8hO+boXgUEHRvbOkgOYvoKdKRw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Recovery mode with partitioned tables and ANY(NULL) in WHERE clause  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Recovery mode with partitioned tables and ANY(NULL) in WHERE clause  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
Дерево обсуждения
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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Recovery mode with partitioned tables and ANY(NULL) in WHERE clause
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Recovery mode with partitioned tables and ANY(NULL) in WHERE clause