Horton

Re: ERROR: XX000: variable not found in subplan target list

x4mmm@yandex-team.ru

View thread View on postgr.es
From: Andrey Borodin <x4mmm@yandex-team.ru>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Ryan Kelly <rpkelly22@gmail.com>, pgsql-bugs@lists.postgresql.org
Date: 2022-04-14T10:24:36Z
Lists: pgsql-bugs 

> 12 февр. 2022 г., в 00:28, Tom Lane <tgl@sss.pgh.pa.us> написал(а):
> 
> Anyway, the attached seems to be enough to fix it in HEAD.
> It should apply more or less easily to v11 as well.

FWIW I've just observed reproduction on 10.10. Applied the patch and tested that query works correctly afterwards.

Do we need to check something else for this fix to be in next minor release?

Thanks!

Best regards, Andrey Borodin.

Commits

  1. Don't use_physical_tlist for an IOS with non-returnable columns.