Re: [HACKERS] Bug on complex join

Hello!

   Another symptom. The query

SELECT cn.date_i, cn.pos_id                                                      
   FROM central cn                                                               
      WHERE cn.date_i >= current_date - '300 days'::timespan                     

returns 3156 rows. But this:

SELECT cn.date_i, p.subsec_id, cn.pos_id, p.pos_id
   FROM central cn, shops sh, districts d, positions p
      WHERE cn.date_i >= current_date - '300 days'::timespan

failed:

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.

   Tables attached (ZIP file with script to recreate tables and SQL
commands).

Oleg.
---- 
    Oleg Broytmann     http://members.xoom.com/phd2/     phd2@earthling.net
           Programmers don't die, they just GOSUB without RETURN.