sql disaster - subquery error but delete continues

Поиск
Список
Период
Сортировка
От Greg Caulton
Тема sql disaster - subquery error but delete continues
Дата
Msg-id AANLkTi=KP2hDszZDeaYNROKfJx0N85Tbe5iwK9q+w+j1@mail.gmail.com
обсуждение исходный текст
Ответы Re: sql disaster - subquery error but delete continues
Список pgsql-sql
delete from form_record_details where form_record_id in (select form_record_id from forms where form_id= 40003656)<br
/><br/>Seems fine at 1am.<br /><br />However the subquery has a typo in it - there is no form_record_id in the forms
table<br/><br />But rather than psql throwing an error...<br /><br />it deletes every row in the form_record_details
table<br/><br />please tell me this is fixed since 8.3<br /><br />Greg<br /> 

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Controlling join order with parenthesis
Следующее
От: Thomas Kellerer
Дата:
Сообщение: Re: sql disaster - subquery error but delete continues