[Firebird-devel] RC2 Aggregate doesn't work inside UDF (new case)

[Christian P. <c_p...@ya...>]

I find a new case that works fine in previews versions (338 and older).

the following query works fine:

SELECT H.ACOUNT, H.TOTAL-SUM(I.AMOUNT)
FROM HEADER H
LEFT OUTER JOIN ITEMS I ON I.NUMBER=H.NUMBER
GROUP BY H.ACOUNT, H.TOTAL

but if you add the ABS function:

SELECT H.ACOUNT, ABS(H.TOTAL-SUM(I.AMOUNT))
FROM HEADER H
LEFT OUTER JOIN ITEMS I ON I.NUMBER=H.NUMBER
GROUP BY H.ACOUNT, H.TOTAL

error: "invalid column reference"


Christian