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(at)earthling(dot)net
Programmers don't die, they just GOSUB without RETURN.