Bug#941409: libreoffice-sdbc-mysql: wrong TIME values saving with native connection over a MariaDB database

[MAG4 Piemonte <mag4@aruba.it>]

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