Re: BUG #17564: Planner bug in combination of generate_series(), unnest() and ORDER BY

Поиск
Список
Период
Сортировка
От Richard Guo
Тема Re: BUG #17564: Planner bug in combination of generate_series(), unnest() and ORDER BY
Дата
Msg-id CAMbWs49AAq1V18=n37qOmAdWOd0-Y=_Z6Wy1gWM2=FeqJWbrCQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: BUG #17564: Planner bug in combination of generate_series(), unnest() and ORDER BY  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: BUG #17564: Planner bug in combination of generate_series(), unnest() and ORDER BY  (Martijn van Oosterhout <kleptog@gmail.com>)
Re: BUG #17564: Planner bug in combination of generate_series(), unnest() and ORDER BY  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
Дерево обсуждения

On Thu, Aug 4, 2022 at 9:55 AM Tom Lane <tgl@sss.pgh.pa.us> wrote:
Richard Guo <guofenglinux@gmail.com> writes:
> I'm reproducing this bug in HEAD with the repro given by Martijn, but
> with some additional GUC sets:

> set enable_hashjoin to off;
> set enable_mergejoin to off;
> set enable_indexscan to off;
> set enable_bitmapscan to off;

Hm, does not work for me ... although I assume you mean bc76f5ac4
or before?  It should definitely not happen after 1aa8dad41,
unless there's an additional bug ...

Yeah, I tested in bc76f5ac4. Attached is a regression test I composed.
I tested it locally and it can catch this bug before 1aa8dad41 and give
the expected answer after 1aa8dad41.

Thanks
Richard
Вложения

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: BUG #17564: Planner bug in combination of generate_series(), unnest() and ORDER BY
Следующее
От: "Ravulapati, Gautham"
Дата:
Сообщение: ERROR: unterminated dollar-quoted string at or near "$$"