Re: Hashed IN only applied to first encountered IN

Поиск
Список
Период
Сортировка
От David Rowley
Тема Re: Hashed IN only applied to first encountered IN
Дата
Msg-id CAApHDvqSFcGvyYVJZAk7BW544cd4KY3B9KofnjkCdpV49hwVGg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Hashed IN only applied to first encountered IN  (David Rowley <dgrowleyml@gmail.com>)
Ответы Re: Hashed IN only applied to first encountered IN
Список pgsql-hackers
On Wed, 2 Apr 2025 at 01:31, David Rowley <dgrowleyml@gmail.com> wrote:
>
> On Wed, 2 Apr 2025 at 00:51, David Geier <geidav.pg@gmail.com> wrote:
> > The hashed IN optimization is only applied to the first encountered
> > ScalarArrayOpExpr during the expression tree traversal in
> > convert_saop_to_hashed_saop_walker(). Reason being that the walker
> > returns true which aborts the traversal.
>
> > I've also attached a patch with a fix.
>
> Thanks for the report and fix.  On first inspection your patch looks
> fine.  I'll have a closer look tomorrow.

I've now pushed and backpatched the relevant portion of this back to v14.

Thanks again.

David



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