Hi,
Calling the SUM() SQL aggregate function (and possibly others too?) in an embedded Firebird database triggers a SQL error message. To reproduce either open the attached sample and try the queries, or - launch LibreOffice Base and create a new embedded Firebase db - create a trivial table (e.g. “testtab”), including a column “testval decimal” - add some values to the table - run the SQL query “select testval from testtab” -> works - run the SQL query “select sum(testval) from testtab” -> results in | The data content could not be loaded. | firebird_sdbc error: | *Incorrect values within SQLDA structure | *empty pointer to data | *at SQLVAR index 0 | caused by | ‘isc_dsql_fetch’ Note that this operation does *not* fail - with the stable LibreOffice package on Windows and macOS and - with the stable LibreOffice DEB package loaded from https://www.libreoffice.org/download/download-libreoffice/. I opened the LibreOffice bug report <https://bugs.documentfoundation.org/show_bug.cgi?id=168908>, and according to the discussion there the aforementioned working packages all use Firebird v. 3, whilst the Trixie packages are built against Firebird 4. Apart from (presumably?) triggering this bug, it also breaks interoperability between platforms – it is possible to open a odb file created on Win or macOS with the Trixie package, but after saving it on Trixie it is unusable on Win, macOS and with the one from libreoffice.org.
Yes, this is https://bugs.documentfoundation.org/show_bug.cgi?id=168143. This was forced upon me quite late in the trixie release cycle.
because the firebird maintainer updated to 4 without providing a possibility to use 3 still.
(Unless one reverted to internal firebird, which in hindsight I should have done..)
See https://lists.debian.org/debian-release/2025/01/thrd2.html (Re: Accepted firebird4.0 4.0.5.3140.ds6-11 (source) into unstable and the thread)
IOW, Trixie's LibreOffice Base package is unusable at least for all non-trivial Firebird-based odb's.
Honestly, any non-trivial DB is not in a .odb anyways but in a MySQL/PostgreSQL.
I guess rolling back the Trixie packages to Firebird 3 (i.e. as “official” package) is not an option, as this might break odb's relying in Firebird 4 (unless there is a way to “downgrade” them?).
Yes :/
Regards,
Rene