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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Richard Guo <guofenglinux(at)gmail(dot)com>
Cc: Martijn van Oosterhout <kleptog(at)gmail(dot)com>, PostgreSQL mailing lists <pgsql-bugs(at)lists(dot)postgresql(dot)org>
Subject: Re: BUG #17564: Planner bug in combination of generate_series(), unnest() and ORDER BY
Date: 2022-08-04 01:55:34
Message-ID: 3297011.1659578134@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Richard Guo <guofenglinux(at)gmail(dot)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 ...

regards, tom lane

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Richard Guo 2022-08-04 03:16:42 Re: BUG #17564: Planner bug in combination of generate_series(), unnest() and ORDER BY
Previous Message Richard Guo 2022-08-04 01:05:13 Re: BUG #17564: Planner bug in combination of generate_series(), unnest() and ORDER BY