Re: [HACKERS] query crashes backend - cvs

> 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.

Never mind. I have a reproducable example now.

--
Bruce Momjian | 830 Blythe Avenue
maillist(at)candle(dot)pha(dot)pa(dot)us | Drexel Hill, Pennsylvania 19026
http://www.op.net/~candle | (610) 353-9879(w)
+ If your life is a hard drive, | (610) 853-3000(h)
+ Christ can be your backup. |