weird problem with latest cvs

From: Oleg Bartunov <oleg(at)sai(dot)msu(dot)su>
To: hackers(at)postgreSQL(dot)org
Subject: weird problem with latest cvs
Date: 1998-08-18 19:27:57
Message-ID: Pine.GSO.3.96.SK.980818232054.19096C-100000@ra
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

just updated development version from cvs and got strange problem :

select * from WORK_FLATS where DISTRICT_ID in (4,101);
select * from WORK_FLATS where DISTRICT_ID in (101,4);

Does anyone understand what's the difference between this two selects ?

explain produces the same plans:
Index Scan using wfidx_district_id on work_flats (cost=6.90 size=29 width=132)
but first select works fine while second fails with message:
flats=> select * from WORK_FLATS where DISTRICT_ID in (101,4);
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.

6.3.2+patches works ok !!!

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 Oleg Bartunov 1998-08-18 19:56:31 Re: [HACKERS] weird problem with latest cvs
Previous Message Tom Lane 1998-08-18 19:09:06 Re: [HACKERS] int8 type -- call for porting results!