> 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@candle.pha.pa.us | (610)
853-3000+ If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill,
Pennsylvania19026