[Firebird-devel] Error with Aggregate and UDF (another one).

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

Today I've found another issue with UDF and GROUP BY:
The problem occurs when I use subselects inside an UDF and there is a GROUP
BY clause in the query.

Example:

the followig works fine:

select c.fcuenta, count(c.fcuenta), (select sum(fmonto1) from con_movi where
fcuenta=c.fcodint)
from con_cuen c
group by c.fcuenta

but the following doesn't work:

select c.fcuenta, count(c.fcuenta), abs((select sum(fmonto1) from con_movi
where fcuenta=c.fcodint))
from con_cuen c
group by c.fcuenta


with best regards
Christian.