Re: [HACKERS] Bug on complex join

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
justGOSUB without RETURN.