AW: BUG #17030: ERROR: cannot decompile join alias var in plan tree introduced in pg14beta1

Hans Buschmann <buschmann@nidsa.net>

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>

Date: 2021-05-24T08:52:43Z

Lists: pgsql-bugs

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

Fix setrefs.c code for Result Cache nodes
- cba5c70b9568 14.0 landed

>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?

Thanks David for investigating.

I managed to manually patch setrefs.c according to your patchset on a Linux test installation.

The query/explain query (without the unneeded XML-stuff) runs fine now, no more error!

I will try to reactivate my Windows development environment, but the error seems not to be related to operating system version.

Many thanks for your quick reaction!

Hans Buschmann