Package: libreoffice-sdbc-firebird Version: 4:25.8.1-1~bpo13+1 Severity: grave Justification: renders package unusable 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. IOW, Trixie's LibreOffice Base package is unusable at least for all non-trivial Firebird-based odb's. 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?). -- Package-specific info: Experimental features enabled: <item oor:path="/org.openoffice.Office.Common/Misc"><prop oor:name="ExperimentalMode" oor:op="fuse"><value>true</value></prop></item> -- System Information: Debian Release: 13.1 APT prefers stable-updates APT policy: (500, 'stable-updates'), (500, 'stable-security'), (500, 'stable') Architecture: amd64 (x86_64) Foreign Architectures: i386 Kernel: Linux 6.12.48+deb13-amd64 (SMP w/2 CPU threads; PREEMPT) Kernel taint flags: TAINT_OOT_MODULE, TAINT_UNSIGNED_MODULE Locale: LANG=de_DE.UTF-8, LC_CTYPE=de_DE.UTF-8 (charmap=UTF-8), LANGUAGE not set Shell: /bin/sh linked to /usr/bin/dash Init: systemd (via /run/systemd/system) LSM: AppArmor: enabled Versions of packages libreoffice-sdbc-firebird depends on: ii firebird4.0-server-core 4.0.5.3140.ds6-17+deb13u1 ii libc6 2.41-12 ii libfbclient2 4.0.5.3140.ds6-17+deb13u1 ii libgcc-s1 14.2.0-19 ii libreoffice-core 4:25.8.1-1~bpo13+1 ii libstdc++6 14.2.0-19 ii libuno-cppu3t64 4:25.8.1-1~bpo13+1 ii libuno-cppuhelpergcc3-3t64 4:25.8.1-1~bpo13+1 ii libuno-sal3t64 4:25.8.1-1~bpo13+1 ii libuno-salhelpergcc3-3t64 4:25.8.1-1~bpo13+1 ii uno-libs-private 4:25.8.1-1~bpo13+1 libreoffice-sdbc-firebird recommends no packages. libreoffice-sdbc-firebird suggests no packages. -- no debconf information
Attachment:
Sample_created_on_W10.odb
Description: application/vnd.oasis.opendocument.base