Bug#941409: libreoffice-sdbc-mysql: wrong TIME values saving with native connection over a MariaDB database
Package: libreoffice-sdbc-mysql
Version: 1:6.3.2-1
Severity: normal
Dear Maintainer,
we create a new table with a TIME field in a new Base file with native
connection over a MariaDB database.
If we input in Base some values like 01:00:00, 02:00:00, 03:00:00 they are
sometimes saved in the database as -01:00:00, -02:00:00, -03:00:00 but
displayed in Base as 01:00:00, 02:00:00, 03:00:00, sometimes saved and
displayed as 00:00:00 and sometimes correctly saved and displayed.
Using the incorporated database (Firebird) or the LibreOffice buster version
(with libreoffice-mysql-connector) values are correctly saved.
Regards!
Guido
-- System Information:
Debian Release: bullseye/sid
APT prefers testing
APT policy: (500, 'testing')
Architecture: amd64 (x86_64)
Kernel: Linux 5.2.0-2-amd64 (SMP w/4 CPU cores)
Locale: LANG=it_IT.UTF-8, LC_CTYPE=it_IT.UTF-8 (charmap=UTF-8), LANGUAGE=it (charmap=UTF-8)
Shell: /bin/sh linked to /bin/dash
Init: systemd (via /run/systemd/system)
LSM: AppArmor: enabled
Versions of packages libreoffice-sdbc-mysql depends on:
ii libc6 2.29-1
ii libgcc1 1:9.2.1-8
ii libmariadb3 1:10.3.18-1
ii libreoffice-core 1:6.3.2-1
ii libstdc++6 9.2.1-8
ii uno-libs3 6.3.1-1
ii ure 6.3.1-1
libreoffice-sdbc-mysql recommends no packages.
Versions of packages libreoffice-sdbc-mysql suggests:
pn default-mysql-server | virtual-mysql-server <none>
-- no debconf information
Reply to: