Bug 149669

Summary:	Resultset from MySQL Query Missing Latest Record (JDBC) in table display
Product:	LibreOffice	Reporter:	Alex Thurgood <iplaw67>
Component:	Base	Assignee:	Not Assigned <libreoffice-bugs>
Status:	RESOLVED WORKSFORME
Severity:	normal	CC:	robert, serval2412
Priority:	medium	Keywords:	regression
Version:	7.3.4.2 release
Hardware:	ARM
OS:	macOS (All)
Whiteboard:
Crash report or crash signature:		Regression By:

Description Alex Thurgood 2022-06-22 08:30:28 UTC

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

Comment 1 Julien Nabet 2022-06-22 18:50:50 UTC

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?

Comment 2 Robert Großkopf 2022-06-23 07:50:18 UTC

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 …

Comment 3 Alex Thurgood 2022-06-23 09:23:12 UTC

@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.

Comment 4 Alex Thurgood 2022-06-23 09:23:43 UTC

(In reply to Alex Thurgood from comment #3)


> It may well indeed be specific to mysql, rather than mariadb.

Or specific to macOS ?

Comment 5 Alex Thurgood 2023-03-24 13:56:44 UTC

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