Re: BUG #19834: eager aggregation still evaluates volatile join clauses when the volatile function is inside a SubPl

Hi Tom,

> For example, these clauses behave quite differently:

If I understand correctly, you mean the following case,

A table t with 100 rows,

SELECT count(*) FROM t WHERE (SELECT random()) < 0.5;

returns either 100 or 0, because the sub-select runs only once.

I think technically that is one of the correct answers....It is just a
result the caller would almost never see otherwise.

I am okay to revert the patch..

Thanks,
Shihao