From: Tom Lane <tgl@sss.pgh.pa.us>
To: Richard Guo <guofenglinux@gmail.com>
cc: Martijn van Oosterhout <kleptog@gmail.com>,
        PostgreSQL mailing lists <pgsql-bugs@lists.postgresql.org>
Subject: Re: BUG #17564: Planner bug in combination of generate_series(),
 unnest() and ORDER BY
In-reply-to: 
 <CAMbWs4_W70RK77_j+_QzYAey2oQoxa8pwb0rp8KCeeH4bt5Jzg@mail.gmail.com>
References: <17564-c7472c2f90ef2da3@postgresql.org>
 <2184335.1659392231@sss.pgh.pa.us>
 <CADWG95s03YZsRy3+q0bQFXW_v_f-9vMvcFOo6KUL08DvqbXhqg@mail.gmail.com>
 <CAMbWs49AgGUophtyThqHhSUyDTu3h6oATg-7GgowCtvHWCh9qQ@mail.gmail.com>
 <3002973.1659538573@sss.pgh.pa.us>
 <CAMbWs4_W70RK77_j+_QzYAey2oQoxa8pwb0rp8KCeeH4bt5Jzg@mail.gmail.com>
Comments: In-reply-to Richard Guo <guofenglinux@gmail.com>
	message dated "Thu, 04 Aug 2022 09:05:13 +0800"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <3297010.1659578134.1@sss.pgh.pa.us>
Date: Wed, 03 Aug 2022 21:55:34 -0400
Message-ID: <3297011.1659578134@sss.pgh.pa.us>
Archived-At: 
 <https://www.postgresql.org/message-id/3297011.1659578134%40sss.pgh.pa.us>
Precedence: bulk

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 ...

			regards, tom lane