Re: subquery column error causes data destroying equality

On Sat, Jul 25, 2020 at 3:32 AM Cy <frompostgres(at)cy1(dot)allowed(dot)org> wrote:

> update comic.panels set medium = x'2a958'::int where page = (
> select page from comic.pages where comic = x'1db'::int and which = 0);
>
> Unfortunately, I forgot that the column in the "pages" table was named
> "id" not "page".
> This would have been the correct query:
>
> update comic.panels set medium = x'2a958'::int where page = (
> select id from comic.pages where comic = x'1db'::int and which = 0);
>

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

> So... please have errors in subqueries cause the surrounding query to fail.

Won't happen.

I'm using version 13devel, git commit
> 9f87ae38eaffcc7f72c45bfeb79e09dd6e8c2f48 so if the
> bug has been fixed since then, feel free to ignore me.
>

This isn't a bug.

David J.