Re: BUG #17030: ERROR: cannot decompile join alias var in plan tree introduced in pg14beta1 - Mailing list pgsql-bugs

From David Rowley
Subject Re: BUG #17030: ERROR: cannot decompile join alias var in plan tree introduced in pg14beta1
Date
Msg-id CAApHDvrTaSE2c1y0C2wmxhFCUK2wu6LXB9prW4s=M0syDGpqQw@mail.gmail.com
Whole thread Raw
In response to Re: BUG #17030: ERROR: cannot decompile join alias var in plan tree introduced in pg14beta1  (David Rowley <dgrowleyml@gmail.com>)
Responses AW: BUG #17030: ERROR: cannot decompile join alias var in plan tree introduced in pg14beta1  (Hans Buschmann <buschmann@nidsa.net>)
List pgsql-bugs
On Mon, 24 May 2021 at 00:58, David Rowley <dgrowleyml@gmail.com> wrote:
>
> On Mon, 24 May 2021 at 00:47, David Rowley <dgrowleyml@gmail.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

pgsql-bugs by date:

Previous
From: David Rowley
Date:
Subject: Re: BUG #17030: ERROR: cannot decompile join alias var in plan tree introduced in pg14beta1
Next
From: Hans Buschmann
Date:
Subject: AW: BUG #17030: ERROR: cannot decompile join alias var in plan tree introduced in pg14beta1