Re: [HACKERS] BUG ON HAVING CLAUSE

Added to TODO:

* subqueries containing HAVING return incorrect results

> Sferacarta Software wrote:
> >
> > >> Seems that I found a bug on HAVING clause, see attached file.
> > >>
> >
> > VM> Could you post me data for 8342 rows ?
> >
> > I think this bug is not on HAVING but on IN/ANY/ALL, I tried all these
>
> This is bug on handling HAVING in subqueries.
> There was no HAVING when I was implementing subqueries and
> so I didn't care... The bug is in optimizer:
>
> vac=> explain select * from test where x in (select * from test group by x having 1 < count(x));
> NOTICE: QUERY PLAN:
>
> Seq Scan on test (cost=0.00 size=0 width=4)
> SubPlan
> -> Aggregate (cost=0.00 size=0 width=0)
> ! InitPlan
> ! -> Aggregate (cost=0.00 size=0 width=0)
> ! -> Seq Scan on test (cost=0.00 size=0 width=4)
>
> There must be no InitPlan here...
>
> -> Group (cost=0.00 size=0 width=0)
> -> Sort (cost=0.00 size=0 width=0)
> -> Seq Scan on test (cost=0.00 size=0 width=4)
>
> Currently, my local copy of dev-tree is broken and so I can't
> fix this. I'll return to this bug latter if no one else...
>
> Vadim
>
>

--
Bruce Momjian | http://www.op.net/~candle
maillist(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026