Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #17564: Planner bug in combination of generate_series(), unnest() and ORDER BY - Mailing list pgsql-bugs

From Martijn van Oosterhout
Subject Re: BUG #17564: Planner bug in combination of generate_series(), unnest() and ORDER BY
Date
Msg-id CADWG95sFE1RS34RLPjGdcud_zDnJO686fNh8Yd=XWOShukHmNg@mail.gmail.com
Whole thread Raw
In response to Re: BUG #17564: Planner bug in combination of generate_series(), unnest() and ORDER BY  (Richard Guo <guofenglinux@gmail.com>)
Responses Re: BUG #17564: Planner bug in combination of generate_series(), unnest() and ORDER BY
List pgsql-bugs
Tree view
Hoi Richard, Tom,

On Thu, 4 Aug 2022 at 05:16, Richard Guo <guofenglinux@gmail.com> wrote:

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.


It looks like the issue has been found, nice! So I'm wondering: which release will this fix be included (so we can mark the workaround with an end date).

Thanks in advance.
--
Martijn van Oosterhout <kleptog@gmail.com> http://svana.org/kleptog/

pgsql-bugs by date:

Previous
From: Amit Kapila
Date:
Subject: Re: Excessive number of replication slots for 12->14 logical replication
Next
From: PG Bug reporting form
Date:
Subject: BUG #17571: PostgreSQL 15b2 ICU collation defined at db level sorts differently in collate clause vs implicit