weird problem with latest cvs

Поиск
Список
Период
Сортировка
От Oleg Bartunov
Тема weird problem with latest cvs
Дата
Msg-id Pine.GSO.3.96.SK.980818232054.19096C-100000@ra
обсуждение исходный текст
Ответы Re: [HACKERS] weird problem with latest cvs
Список 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@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: [HACKERS] int8 type -- call for porting results!
Следующее
От: Oleg Bartunov
Дата:
Сообщение: Re: [HACKERS] weird problem with latest cvs