query crashes backend - cvs

Поиск
Список
Период
Сортировка
От Oleg Bartunov
Тема query crashes backend - cvs
Дата
Msg-id Pine.GSO.3.96.SK.980915234738.15587A-100000@ra
обсуждение исходный текст
Ответы Re: [HACKERS] query crashes backend - cvs  (Tatsuo Ishii <t-ishii@sra.co.jp>)
Re: [HACKERS] query crashes backend - cvs  (Bruce Momjian <maillist@candle.pha.pa.us>)
Re: [HACKERS] query crashes backend - cvs  (Bruce Momjian <maillist@candle.pha.pa.us>)
Список pgsql-hackers
interesting that
select * from work_flats where (METRO_ID = 81 or METRO_ID = 82) and  DISTRICT_ID < 11;
crashes backend
pqReadData() -- backend closed the channel unexpectedly.
        This probably means the backend terminated abnormally before or while processing the request.
We have lost the connection to the backend, so further processing is impossible.  Terminating.
while
select * from work_flats where METRO_ID = 81 or METRO_ID = 82 and  DISTRICT_ID < 11;
works ok.

This happens with latest cvs, 6.3.2 has no problem.

    Regards,
        Oleg
_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83


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

Предыдущее
От: Frank Ridderbusch
Дата:
Сообщение: Re: [HACKERS] Found it. Also on SVR4 (Compiling 6.4 on NetBSD...
Следующее
От: The Hermit Hacker
Дата:
Сообщение: Re: [HACKERS] Regress results on FreeBSD 2.2.6-RELEASE - RESEND