Andrey Zhidenkov <pensnarik@gmail.com> writes:
>> Can you create a self-contained SQL script to reproduce this, and post it
>> on this thread with reply-all, please?
> Unfortunately, I cannot reproduce the issue even on an existing 15.7
> node (one that hasn't upgraded) (don't know if it matters, but now it's a
> hot standby node) but there are core dumps and debug info packages
> installed so I can provide more data from core dump.
Could you at least provide a not-mangled-to-the-point-of-incorrectness
version of the query? The posted one fails with
ERROR: table name "tablename_v2" specified more than once
and there are other visible bugs in it. Some clarity about the column
data types would be helpful as well.
regards, tom lane