"Nested aggregate functions are not allowed" error on FB30
----------------------------------------------------------
Key: CORE-6256
URL: http://tracker.firebirdsql.org/browse/CORE-6256
Project: Firebird Core
Issue Type: Bug
Components: Engine
Affects Versions: 3.0.5
Reporter: Attila Molnár
Hi!
This works for FB25 (Dialect1), but not for FB30 (Dialect3).
SELECT
SUM(
kf.keszlet_db +
(SELECT
SUM((
CASE WHEN rt.vdb IS NULL THEN rt.db ELSE rt.vdb END -
COALESCE(rt.ktdb, 0)) *
(SELECT kv.szorzo
FROM ktfj_valtoszam(kf.ktfj_id, rt.mert_id, kf.mert_id) kv))
FROM ktrt rt)) szabad_db
FROM ktkf kf
Our workaround : extract the subselect into CTE and then FB30 accepts it.
WITH
sub AS
(SELECT
(CASE WHEN rt.vdb IS NULL THEN rt.db ELSE rt.vdb END -
COALESCE(rt.ktdb, 0)) *
(SELECT kv.szorzo
FROM ktfj_valtoszam(kf.ktfj_id, rt.mert_id, kf.mert_id) kv) db
FROM ktrt rt)
SELECT
SUM(
kf.keszlet_db +
(SELECT
SUM(db)
FROM sub)) szabad_db
FROM ktkf kf
(I can send the database on request)
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
