Thread: AW: [HACKERS] 6.4 Aggregate Bug

>
>    select func(x), aggfunc(y) group by func
>        CRASHES
>

I think this should be disallowed syntax. Note that func is a system generated label
in this case, that's probably why the parser does not complain. The syntax has to be:

select func(x), aggfunc(y) group by func(x);  -- or

select func(x) as func, aggfunc(y) group by func;

Andreas

Andreas Zeugswetter wrote:

> >
> >    select func(x), aggfunc(y) group by func
> >        CRASHES
> >
>
> I think this should be disallowed syntax. Note that func is a system generated label
> in this case, that's probably why the parser does not complain. The syntax has to be:
>
> select func(x), aggfunc(y) group by func(x);  -- or
>
> select func(x) as func, aggfunc(y) group by func;
>

To my knowledge postgres has always allowed this syntax.  IMO is seems harmless to
continue.  In any case, all of these syntax permutations will crash the backend in using
6.4.