Re: [HACKERS] BUG ON HAVING CLAUSE

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