Re: ERROR: XX000: variable not found in subplan target list - Mailing list pgsql-bugs

From Andrey Borodin
Subject Re: ERROR: XX000: variable not found in subplan target list
Date
Msg-id A53E35AF-5E03-4B5F-A649-3B6F821B6763@yandex-team.ru
Whole thread Raw
In response to Re: ERROR: XX000: variable not found in subplan target list  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: ERROR: XX000: variable not found in subplan target list  (Andrey Borodin <x4mmm@yandex-team.ru>)
Re: ERROR: XX000: variable not found in subplan target list  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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.


pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: replace() using NULL
Next
From: Andrey Borodin
Date:
Subject: Re: ERROR: XX000: variable not found in subplan target list