Re: Assert failure on bms_equal(child_joinrel->relids, child_joinrelids)

Поиск
Список
Период
Сортировка
От Richard Guo
Тема Re: Assert failure on bms_equal(child_joinrel->relids, child_joinrelids)
Дата
Msg-id CAMbWs49A8H+=hPzrnYO-zwNxJBfHpdOaNYe+Q+-mjzKaq=P_uQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Assert failure on bms_equal(child_joinrel->relids, child_joinrelids)  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Assert failure on bms_equal(child_joinrel->relids, child_joinrelids)  (Ashutosh Bapat <ashutosh.bapat.oss@gmail.com>)
Список pgsql-hackers

On Sat, Jul 22, 2023 at 12:02 AM Tom Lane <tgl@sss.pgh.pa.us> wrote:
Richard Guo <guofenglinux@gmail.com> writes:
> Instead of fixing add_outer_joins_to_relids() to cope with child joins,
> I'm wondering if we can build join relids for a child join from its
> parent by adjust_child_relids, something like attached.

That looks like a good solid solution.  Pushed with a bit of
editorialization --- mostly, that I put the test case into
partition_join.sql where there's already suitable test tables.

Thanks for pushing it!

Thanks
Richard 

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Amit Kapila
Дата:
Сообщение: Re: pgsql: Allow tailoring of ICU locales with custom rules
Следующее
От: Bharath Rupireddy
Дата:
Сообщение: Re: Support worker_spi to execute the function dynamically.