Horton

Re: [HACKERS] Bug on complex join

Oleg Broytmann <phd@sun.med.ru>

View thread
From: Oleg Broytmann <phd@sun.med.ru>
To: Hannu Krosing <hannu@trust.ee>
Cc: PostgreSQL-development <pgsql-hackers@postgreSQL.org>
Date: 1999-03-09T15:47:24Z
Lists: pgsql-hackers 
Hi!

On Tue, 9 Mar 1999, Hannu Krosing wrote:
> > 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
> 
> this should return
>    3156 * count(shops) * count(districts) * count(positions)
> 
> which is probably too much for the backend ;(

   Bad news. Thanks for pointing this.

> -----------------------
> Hannu
> 

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