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

Поиск
Список
Период
Сортировка
От Kostya M
Тема Delete from table where id in (bugged query) - fully remove all data without any notice.
Дата
Msg-id CACAwW2jDOAjQVMPcNJ00qEhhYao7HEiOrw+UDXO6rz0LXB43Tg@mail.gmail.com
обсуждение исходный текст
Ответы Re: Delete from table where id in (bugged query) - fully remove all data without any notice.  (Pantelis Theodosiou <ypercube@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: PG Bug reporting form
Дата:
Сообщение: BUG #17659: error in rpmbuild when compiling psql
Следующее
От: Pantelis Theodosiou
Дата:
Сообщение: Re: Delete from table where id in (bugged query) - fully remove all data without any notice.