PG crashes on query

Поиск
Список
Период
Сортировка
От Louis-David Mitterrand
Тема PG crashes on query
Дата
Msg-id 20000920155951.A4137@styx
обсуждение исходный текст
Список pgsql-hackers
This (invalid) query crashes the 7.0.2 backend:

auction=# SELECT (select max(b.lot)) as last_lot,auction_status(a.id) > 0 AS current, a.lot, a.person_id,
next_price(a.id),seller.mail AS seller_mail, buyer.mail AS buyer_mail, seller.locale AS seller_locale, buyer.login AS
buyer_login,num_bid(a.id), seller.login AS seller_login, t.name AS auction_type FROM auction* a, person seller, person
buyer,auction_type t,bid b WHERE a.id = 84 AND seller.id = a.person_id AND COALESCE(a.type,1) = t.id AND buyer.id = 2
ANDb.person_id = buyer.id ;
 
pqReadData() -- backend closed the channel unexpectedly.       This probably means the backend terminated abnormally
  before or while processing the request.
 
The connection to the server was lost. Attempting reset: Failed.

Let me know if you need the DB schema for debugging.

-- 
Louis-David Mitterrand - ldm@apartia.org - http://www.apartia.org

Lord, protect me from your followers.


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

Предыдущее
От: "Oliver Elphick"
Дата:
Сообщение: Debian Bug#72084: Broken permissions required with foreign keys (fwd)
Следующее
От: Alfred Perlstein
Дата:
Сообщение: Re: 7.0.2 crash, backtrace with debug available