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