Re: [HACKERS] query crashes backend - cvs - Mailing list pgsql-hackers

From Thomas G. Lockhart
Subject Re: [HACKERS] query crashes backend - cvs
Date
Msg-id 35FF4925.B7A024A2@alumni.caltech.edu
Whole thread Raw
In response to query crashes backend - cvs  (Oleg Bartunov <oleg@sai.msu.su>)
Responses Re: [HACKERS] query crashes backend - cvs  (Oleg Bartunov <oleg@sai.msu.su>)
List pgsql-hackers
> select * from work_flats where (METRO_ID = 81 or METRO_ID = 82) and
>  DISTRICT_ID < 11;
> crashes backend
> pqReadData() -- backend closed the channel unexpectedly.
> 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.

postgres=> select * from t where (METRO_ID = 81 or METRO_ID = 82) and
postgres->  DISTRICT_ID < 11;
metro_id|district_id
--------+-----------
      81|          1
      82|          2
(2 rows)

More details please...

                    - Tom

pgsql-hackers by date:

Previous
From: "Taral"
Date:
Subject: 'select @1' problem
Next
From: "Thomas G. Lockhart"
Date:
Subject: Re: [HACKERS] Serial syntax