Description: Loaded an ODB file into LO that connects to a mysql instance over JDBC using the Mysql official JDBC connector (8.0.27) If I double-click on a table to display the data contained in it, the view of the data, in normal alphabetical sort (default ASC) is truncated before the last entry in the actual mysql table. If I reverse the sort to display in DESC order, the latest entry in the table appears correctly as the first in the displayed resultset. If I then switch back to the default sort, all of the data in the resultset is displayed. Steps to Reproduce: 1. Load an ODB file into Base that is configured to connect to a mysql instance over the mysql JDBC connector 2. Open a table for viewing the data contained in it. 3. Notice how the last record in the resultset is missing. 4. Switch the sort option to descending. Notice how the last record is displayed correctly in first position. 5. Switch back to default sort (ascending). Notice how all of the records are now displayed. Actual Results: The default display of the resultset truncates the last record of the table. Expected Results: The last record should be displayed correctly as part of the resultset. MySQL server version : 8.0.27 (MySQL Community Server - GPL) JDBC connector (mysql official version 8.0.27) Java : Oracle JDK 17 Reproducible: Always User Profile Reset: Yes Additional Info: Version: 7.3.4.2 / LibreOffice Community Build ID: 728fec16bd5f605073805c3c9e7c4212a0120dc5 CPU threads: 8; OS: Mac OS X 12.4; UI render: default; VCL: osx Locale: fr-FR (fr_FR.UTF-8); UI: fr-FR Calc: threaded
On pc Debian x86-64 with master sources updated today, I don't reproduce this. But I use MariaDB server and MariaDB JDBC connector + openjdk 11.0.14.1 2022-02-08 Mysql only?
Could only test with MariaDB on localhost: JDBC connector (mysql official version 8.0.27) Java OpenJDK 11.0.15 Couldn't reproduce the problem. All rows will be shown …
@Julien, Robert, thanks for testing - when I wrote this report, I thought somebody else had already reported it, but couldn't find anything. It may well indeed be specific to mysql, rather than mariadb.
(In reply to Alex Thurgood from comment #3) > It may well indeed be specific to mysql, rather than mariadb. Or specific to macOS ?
No longer reproducible with Version: 7.5.1.2 (AARCH64) / LibreOffice Community Build ID: fcbaee479e84c6cd81291587d2ee68cba099e129 CPU threads: 8; OS: Mac OS X 13.2.1; UI render: Skia/Raster; VCL: osx Locale: fr-FR (fr_FR.UTF-8); UI: fr-FR Calc: threaded