BUG #4220: delete statement deleted too many rows

Поиск
Список
Период
Сортировка
От Lon Varscsak
Тема BUG #4220: delete statement deleted too many rows
Дата
Msg-id 200806041846.m54IkgAl075173@wwwmaster.postgresql.org
обсуждение исходный текст
Ответы Re: BUG #4220: delete statement deleted too many rows
Список pgsql-bugs
The following bug has been logged online:

Bug reference:      4220
Logged by:          Lon Varscsak
Email address:      varscsak@smarthealth.com
PostgreSQL version: 8.3.1
Operating system:   Linux (RHEL 5)
Description:        delete statement deleted too many rows
Details:

I executed this query:

delete from customer_transactions_detail where transaction_id in (select
transaction_id from test);

The transaction_id column does NOT exist in the temporary table named
'test').  I would think this would just result in an error, instead it
delete all rows in the customer_transactions_detail table.

Yikes!

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: BUG #4219: fseeko test failure in configure script
Следующее
От: hubert depesz lubaczewski
Дата:
Сообщение: Re: BUG #4220: delete statement deleted too many rows