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

From: Andrey Borodin <x4mmm(at)yandex-team(dot)ru>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Ryan Kelly <rpkelly22(at)gmail(dot)com>, pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: ERROR: XX000: variable not found in subplan target list
Date: 2022-04-14 10:24:36
Message-ID: A53E35AF-5E03-4B5F-A649-3B6F821B6763@yandex-team.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

> 12 февр. 2022 г., в 00:28, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)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.

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Andrey Borodin 2022-04-14 10:31:00 Re: ERROR: XX000: variable not found in subplan target list
Previous Message Tom Lane 2022-04-13 13:43:04 Re: replace() using NULL