From: Hans Buschmann <buschmann@nidsa.net>
To: David Rowley <dgrowleyml@gmail.com>, Tom Lane <tgl@sss.pgh.pa.us>
CC: PostgreSQL mailing lists <pgsql-bugs@lists.postgresql.org>
Subject: AW: BUG #17030: ERROR: cannot decompile join alias var in plan tree
 introduced in pg14beta1
Thread-Topic: BUG #17030: ERROR: cannot decompile join alias var in plan tree
 introduced in pg14beta1
Thread-Index: AQHXT06/aurXHNFpmUaoNarAvF3Bjqrw45OAgAAC2ACAAPhygIAAdASt
Date: Mon, 24 May 2021 08:52:43 +0000
Message-ID: <1621846369482.30164@nidsa.net>
References: <17030-5844aecae42fe223@postgresql.org>
 <283092.1621717755@sss.pgh.pa.us>
 <CAApHDvoPLEivigj9mFGJsodP6jSxgoX6+bzinX8rSGRw_tv5Rw@mail.gmail.com>
 <CAApHDvps2VmHUve67qtg9F9nepbgGnybnSbvopRtp8crngc2cg@mail.gmail.com>,<CAApHDvrTaSE2c1y0C2wmxhFCUK2wu6LXB9prW4s=M0syDGpqQw@mail.gmail.com>
In-Reply-To: 
 <CAApHDvrTaSE2c1y0C2wmxhFCUK2wu6LXB9prW4s=M0syDGpqQw@mail.gmail.com>
Accept-Language: de-DE, en-US
Content-Language: de-DE
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
MIME-Version: 1.0
Archived-At: 
 <https://www.postgresql.org/message-id/1621846369482.30164%40nidsa.net>
Precedence: bulk

>Hans, I see you're on Windows, but wondering if you have a build=0A=
>environment around to test to see if this patch fixes the error for=0A=
>your case?=0A=
=0A=
Thanks David for investigating.=0A=
=0A=
I managed to manually patch setrefs.c according to your patchset on a Linux=
 test installation.=0A=
=0A=
The query/explain query (without the unneeded XML-stuff) runs fine now, no =
more error!=0A=
=0A=
I will try to reactivate my Windows development environment, but the error =
seems not to be related to operating system version.=0A=
=0A=
Many thanks for your quick reaction!=0A=
=0A=
Hans Buschmann=0A=
=0A=