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

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: BUG #17564: Planner bug in combination of generate_series(), unnest() and ORDER BY
Дата
Msg-id 3503395.1659626002@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: BUG #17564: Planner bug in combination of generate_series(), unnest() and ORDER BY  (Richard Guo <guofenglinux@gmail.com>)
Список pgsql-bugs
Дерево обсуждения 
Richard Guo <guofenglinux@gmail.com> writes:
> 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.

Nice!  I found we could simplify it even further: we don't seem to
need the generate_subscripts() to provoke the error in this query.
And it fails in v13-v14, too.  Pushed.

            regards, tom lane

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

Предыдущее
От: Japin Li
Дата:
Сообщение: Re: BUG #17570: Unrecognized node type for query with statistics on expressions
Следующее
От: Tom Lane
Дата:
Сообщение: Re: BUG #17564: Planner bug in combination of generate_series(), unnest() and ORDER BY