| From: | Richard Guo <guofenglinux(at)gmail(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| 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 03:16:42 |
| Message-ID: | CAMbWs49AAq1V18=n37qOmAdWOd0-Y=_Z6Wy1gWM2=FeqJWbrCQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
On Thu, Aug 4, 2022 at 9:55 AM Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> 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 ...
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
| Attachment | Content-Type | Size |
|---|---|---|
| v1-0001-Test-we-disallow-pushing-down-SRF-pathkeys.patch | application/octet-stream | 2.7 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ravulapati, Gautham | 2022-08-04 03:58:02 | ERROR: unterminated dollar-quoted string at or near "$$" |
| Previous Message | Tom Lane | 2022-08-04 01:55:34 | Re: BUG #17564: Planner bug in combination of generate_series(), unnest() and ORDER BY |