Multiple sum query cause ad incorrect SQLDA structure error
-----------------------------------------------------------
Key: CORE-6480
URL: http://tracker.firebirdsql.org/browse/CORE-6480
Project: Firebird Core
Issue Type: Bug
Components: Engine
Affects Versions: 4.0 Beta 2
Environment: WINDOWS 10, INTEL CORE I9 9900, 64GB RAM
Client sofdtware : DLEPHI, IBEXPERT (same error)
Reporter: William Pristia
This query
SELECT
SUM(QUANTITA_NETTA) QUANTITA_MATURATA_COMPENSATA,
SUM(QUANTITA_SOTTO_MINIMO) QUANTITA_SOTTO_MINIMO,
SUM(QUANTITA_SOPRA_MASSIMO) QUANTITA_SOPRA_MASSIMO,
SUM(QUANTITA_VALUTATA) QUANTITA_VALUTATA,
SUM(QUANTITA_SVOLTA) QUANTITA_SVOLTA,
SUM(QUANTITA_SVOLTA_FESTIVO) QUANTITA_SVOLTA_FESTIVO,
SUM(QUANTITA_SVOLTA_NOTTURNO) QUANTITA_SVOLTA_NOTTURNO
FROM APP_SORVEGLIANTI_DATI_S SDG
INNER JOIN APP_CONTRATTI_DATI CD ON
(CD.ID_CONTRATTO_DATO=SDG.ID_CONTRATTO_DATO)
INNER JOIN APP_SYS_TP_CONTRATTO_DATO TCD ON
(TCD.ID_TP_CONTRATTO_DATO=SDG.ID_TP_CONTRATTO_DATO_MISURA)
WHERE SDG.ID_PAGA=53 AND SDG.ID_SORVEGLIANTE=260 AND SDG.ID_ASSUNZIONE=501 AND
CD.ID_CONTRATTO_DATO=1566 AND
((SDG.DATA_INIZIO BETWEEN '01.01.2021' AND '31.01.2021') OR (SDG.DATA_FINE
BETWEEN '01.01.2021' AND '31.01.2021'))
and all queries of this kind generate this error :
An error was found in the application program input parameters for the SQL
statement.
Incorrect values within SQLDA structure.
--
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
