| From: | Oleg Broytmann <phd(at)sun(dot)med(dot)ru> |
|---|---|
| To: | Hannu Krosing <hannu(at)trust(dot)ee> |
| Cc: | PostgreSQL-development <pgsql-hackers(at)postgreSQL(dot)org> |
| Subject: | Re: [HACKERS] Bug on complex join |
| Date: | 1999-03-09 15:47:24 |
| Message-ID: | Pine.SOL2.3.96.SK.990309184423.4381A-100000@sun.med.ru |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| 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(at)earthling(dot)net
Programmers don't die, they just GOSUB without RETURN.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Vince Vielhaber | 1999-03-09 15:50:51 | Re: [HACKERS] Developers globe |
| Previous Message | D'Arcy J.M. Cain | 1999-03-09 15:42:50 | Re: [HACKERS] Niladic functions |