| From: | David Rowley <dgrowleyml(at)gmail(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, buschmann(at)nidsa(dot)net |
| Cc: | PostgreSQL mailing lists <pgsql-bugs(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: BUG #17030: ERROR: cannot decompile join alias var in plan tree introduced in pg14beta1 |
| Date: | 2021-05-24 03:47:23 |
| Message-ID: | CAApHDvrTaSE2c1y0C2wmxhFCUK2wu6LXB9prW4s=M0syDGpqQw@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
On Mon, 24 May 2021 at 00:58, David Rowley <dgrowleyml(at)gmail(dot)com> wrote:
>
> On Mon, 24 May 2021 at 00:47, David Rowley <dgrowleyml(at)gmail(dot)com> wrote:
> > I can look into this a bit more in the morning. It's not a good time
> > of day right now to debug setrefs.c
>
> It *may* just be a missing call to set_upper_references() for Result
> Cache. i.e. the attached. But I will need to look harder in the
> morning. Following setrefs.c gives me a headache at the best of times.
I've had a look at this today and I think the patch attached is what
needs to be done to fix the issue.
Hans, I see you're on Windows, but wondering if you have a build
environment around to test to see if this patch fixes the error for
your case?
David
| Attachment | Content-Type | Size |
|---|---|---|
| resultcache_setrefs_fix.patch | application/octet-stream | 3.3 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Hans Buschmann | 2021-05-24 08:52:43 | AW: BUG #17030: ERROR: cannot decompile join alias var in plan tree introduced in pg14beta1 |
| Previous Message | David Rowley | 2021-05-23 12:58:10 | Re: BUG #17030: ERROR: cannot decompile join alias var in plan tree introduced in pg14beta1 |