Re: Teaching planner to short-circuit empty UNION/EXCEPT/INTERSECT inputs

Поиск
Список
Период
Сортировка
От David Rowley
Тема Re: Teaching planner to short-circuit empty UNION/EXCEPT/INTERSECT inputs
Дата
Msg-id CAApHDvpM7uggy7o1aj+iiMHdfFa17ufnWyZGK25aK6p1Kp0B7w@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Teaching planner to short-circuit empty UNION/EXCEPT/INTERSECT inputs  (David Rowley <dgrowleyml@gmail.com>)
Список pgsql-hackers
On Tue, 4 Nov 2025 at 22:54, David Rowley <dgrowleyml@gmail.com> wrote:
> The reason we end up with the same result_rel is that we're not
> passing all the relids in fetch_upper_rel(root, UPPERREL_SETOP,
> relids) due to having removed dummy rels. I guess the fix might be
> something like record the relids even when skipping dummy relations.
> I'll go and explore that as an option.

This seems to fix it. I'll study it more in the morning (it's late in
my time zone).

David

Вложения

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