Delete from table where id in (bugged query) - fully remove all data without any notice. - Mailing list pgsql-bugs

From Kostya M
Subject Delete from table where id in (bugged query) - fully remove all data without any notice.
Date
Msg-id CACAwW2jDOAjQVMPcNJ00qEhhYao7HEiOrw+UDXO6rz0LXB43Tg@mail.gmail.com
Whole thread Raw
Responses Re: Delete from table where id in (bugged query) - fully remove all data without any notice.
List pgsql-bugs
`PostgreSQL 14.5 (Ubuntu 14.5-0ubuntu0.22.04.1) on
x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 11.2.0-19ubuntu1) 11.2.0,
64-bit`

I write little bugged query and fully remove my data. Which was unexpected.

`select min(id) into tmp_table from table1 group by some_field;`
`delete from table2 where id in (select id from tmp_table);`

Problem that `tmp_table` have no `id` column (accidentally column
called `min`). So subquery was with error. But delete just fully
remove data without crashing or noticing.

What i expected that delete just write that subquery crashed, and not
delete anything.



pgsql-bugs by date:

Previous
From: PG Bug reporting form
Date:
Subject: BUG #17659: error in rpmbuild when compiling psql
Next
From: Pantelis Theodosiou
Date:
Subject: Re: Delete from table where id in (bugged query) - fully remove all data without any notice.