Re: Re[2]: [HACKERS] BUG ON HAVING CLAUSE

> Well, I tried IN-ANY-ALL on a subselect containing an HAVING clause
> like:
>
> select * from emp where ename in (
> select ename from emp group by ename having 1 < count(ename)
> );
>
> and I was thought that IN-ANY-ALL were buggy, then I tried this:
>
> select * from emp where ename IN (
> select ename from emp where deptno=20);
>
> and now I know the bug is only in the HAVING clause.

OK, that's good. We now have TODO item:

* subqueries containing HAVING return incorrect results

--
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