https://bugs.documentfoundation.org/show_bug.cgi?id=149669
Bug ID: 149669
Summary: Resultset from MySQL Query Missing Latest Record
(JDBC)
Product: LibreOffice
Version: 7.3.4.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Base
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: ipla...@tuta.io
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
--
You are receiving this mail because:
You are the assignee for the bug.
