Re: BUG #17233: Incorrect behavior of DELETE command with bad subquery in WHERE clause

On Saturday, October 16, 2021, PG Bug reporting form <noreply(at)postgresql(dot)org>
wrote:

> The following bug has been logged on the website:
>
> Bug reference: 17233
> Logged by: Alexander Korolev
> Email address: lxndrkrlv(at)gmail(dot)com
> PostgreSQL version: 14.0
> Operating system: Windows
> Description:
>
> This SELECT command fails as expected:
> SELECT CTID FROM tmp1 INNER JOIN tmp2 ON tmp1.id = tmp2.id FOR UPDATE;
> -- ERROR: column "ctid" does not exist.
>
> But if I use same SELECT in WHERE clause of DELETE command
> DELETE FROM tmp1 WHERE CTID in (
> SELECT CTID FROM tmp1 INNER JOIN tmp2 ON tmp1.id = tmp2.id FOR
> UPDATE);
> this command is executed without errors.
>

This is not a bug:

https://wiki.postgresql.org/wiki/FAQ#Why_doesn.27t_PostgreSQL_report_a_column_not_found_error_when_using_the_wrong_name_in_a_subquery.3F

The virtual join table doesn’t have a ctid, only physical tables do, and
the ctid of physical tables apparently aren’t propogated when they are
joined.

David J.