Re: BUG #18187: Unexpected error: "variable not found in subplan target lists" triggered by JOIN

Поиск
Список
Период
Сортировка
От Richard Guo
Тема Re: BUG #18187: Unexpected error: "variable not found in subplan target lists" triggered by JOIN
Дата
Msg-id CAMbWs48zG6q=AK2k4hGgj64FG30iBPe5WPyu9rumtmqBOWDZfA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: BUG #18187: Unexpected error: "variable not found in subplan target lists" triggered by JOIN  (Richard Guo <guofenglinux@gmail.com>)
Ответы Re: BUG #18187: Unexpected error: "variable not found in subplan target lists" triggered by JOIN  (Andrei Lepikhov <a.lepikhov@postgrespro.ru>)
Список pgsql-bugs
Дерево обсуждения

On Tue, Nov 28, 2023 at 3:03 PM Richard Guo <guofenglinux@gmail.com> wrote:
On Tue, Nov 28, 2023 at 1:42 AM Tom Lane <tgl@sss.pgh.pa.us> wrote:
BTW, why is it that it seems to prefer to remove the first of
the two self-joined rels, rather than the second?  That seems
jarringly bizarre.

Hmm, I'm not sure either.  Alexander and Andrei, could you please share
your insights?

BTW, while reading the codes, I noticed this commit of
remove_self_joins_recurse.

* ... To avoid complexity, limit the max power of this set by a GUC.

But where is the GUC?   I guess that it refers to
self_join_search_limit, which has been removed during development.

So we should revise this commit to at least remove any mention of the
GUC.  Maybe it'd better to add a new commit explaining why we are not
concerned about cases where the number of self joins is too large.

Thanks
Richard

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

Предыдущее
От: PG Bug reporting form
Дата:
Сообщение: BUG #18216: Unaccent function is unable to remove accents (diacritic signs) from Japanese character 'ド'
Следующее
От: Andrei Lepikhov
Дата:
Сообщение: Re: BUG #18187: Unexpected error: "variable not found in subplan target lists" triggered by JOIN