query crashes backend - cvs

From: Oleg Bartunov <oleg(at)sai(dot)msu(dot)su>
To: pgsql-hackers(at)postgreSQL(dot)org
Subject: query crashes backend - cvs
Date: 1998-09-15 19:52:50
Message-ID: Pine.GSO.3.96.SK.980915234738.15587A-100000@ra
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)sai(dot)msu(dot)su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message The Hermit Hacker 1998-09-15 22:12:16 Re: [HACKERS] Regress results on FreeBSD 2.2.6-RELEASE - RESEND
Previous Message Frank Ridderbusch 1998-09-15 19:12:41 Re: [HACKERS] Found it. Also on SVR4 (Compiling 6.4 on NetBSD...