Re: libreoffice-sdbc-firebird: Firebird error calling SUM() SQL aggregate function

Albrecht Dreß <[email protected]> Sat, 18 Oct 2025 10:46:14 +0000

Newsgroups	gmane.linux.debian.backports.general
Message-ID	<[email protected]>

Hi,

thanks a lot for your reply!

Am 18.10.25 12:05 schrieb(en) Rene Engelhard:
> FWIW, you are *not* using trixies package. If you would this would have ended up in the BTS directly.
> Because you used the backport it just ended up on [email protected] as per backports' policy.

Ah, yes, sorry, forgot about the policy. 🙈️  But its's the same behaviour on vanilla Trixie (and derived distos, like LMDE Gigi beta, etc.), too…

> and thus the bug (if it was reported against the BTS) would be important only, IMHO.

So you suggest I roll back my test VM to the standard packages, and report the bug again, to ensure it is in the database?  (And the bug *is* a blocker in my case, btw.!)

Am 18.10.25 12:12 schrieb(en) Rene Engelhard:
> Unfortunately in neither trixie nor trixie-backports nor even in untable it is
> really fixable now - only when upstream finally upgrades to 4.0 or 5.0 (which
> isn't even in Debian, so no system-one possible either) - because of exactly
> the "downgrade" issue you mentioned in your report...

I think we have two issues here:
(1) Calling a legitimate SQL function must not result in an error and
(2) the lack of platform interoperability.

Whilst (2) isn't nice, it is *not* a blocker for me.  But (1) IMHO probably *can* be fixed unless Firebird 4 is completely broken (or not ISO/IEC 9075 compatible any more, which is rather unlikely) or the glue layer is beyond your control.

The issue occurred on a friend's (roofer, no computer expert) box who used “XRechnung” (<https://www.familiegrosskopf.de/robert/index.php?&Inhalt=xrechnung>, building upon the experimental embedded FB feature, but that's beyond our control) for his business for some time happily on a Win 10 box.  Due to the expired support of the latter, I migrated his machine to Debian.

So I guess unless (1) is fixed, the only option is to throw away the broken (from the user's pov) Debian packages, and to install those from libreoffice.org, right?  I must admit that this is really disappointing for a disto which aims at being the most “stable”, to be honest.

Thanks anyway,
Albrecht.

openpgp-digital-signature.asc (application/pgp-signature, 488 B)