| Summary: | Database table content not read or displayed in UI with an existing connection to ODB file | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | Alex Thurgood <iplaw67> |
| Component: | Base | Assignee: | Not Assigned <libreoffice-bugs> |
| Status: | VERIFIED FIXED | ||
| Severity: | major | CC: | robert, serval2412 |
| Priority: | high | Keywords: | bibisectRequest, regression |
| Version: | 7.5.0.0 beta1+ | ||
| Hardware: | All | ||
| OS: | All | ||
| See Also: | https://bugs.documentfoundation.org/show_bug.cgi?id=152538 | ||
| Whiteboard: | |||
| Crash report or crash signature: | Regression By: | ||
| Attachments: | Screenshot of table grid display with ODBC connector | ||
|
Description
Alex Thurgood
2022-12-14 14:36:32 UTC
For comparison, this works correctly in Version: 7.4.1.2 / LibreOffice Community aarch64 Ventura macOS 13.0.1 Build ID: 3c58a8f3a960df8bc8fd77b461821e42c061c5f0 CPU threads: 8; OS: Mac OS X 13.0.1; UI render: default; VCL: osx Locale: fr-FR (fr_FR.UTF-8); UI: fr-FR Calc: threaded Further testing shows that if I create a new ODB in my "Downloads" folder and connecting to the same database instance, with the exact same connection parameters, the tables and data are displayed correctly, so there must be something wrong with the file permissions granted to the LibreOfficeDev.app that causes the ODB file to be set to read-only. Hopefully, this is a problem only with the current LibreOfficeDev 7.5 beta. Hmm, well, sorry, guess there's more to it. If I create a new mysql/ODB file in LO 7.5 beta, none of the tables will display any data. If I Not sure how to test this further. The problem manifests itself independently of the connector type. I have now tried: direct connector JDBC connector ODBC connector. All three lead to the same result, cf attached screenshot (ODBC connector). Created attachment 184155 [details]
Screenshot of table grid display with ODBC connector
That's not a special MySQL-bug. Opened a HSQLDB embedded and a Firebird embedded. No grid is shown, no field. Will report a new bug for this. Did you really doesn't get this behavior with ODBC? Comment on attachment 184155 [details]
Screenshot of table grid display with ODBC connector
Can I ask an admin to remove this image ?
Not sure what happened here.
(In reply to Robert Großkopf from comment #8) > That's not a special MySQL-bug. Opened a HSQLDB embedded and a Firebird > embedded. No grid is shown, no field. Will report a new bug for this. > > Did you really doesn't get this behavior with ODBC? Hi Robert, the behaviour was also reproducible with ODBC, cf. comment 6. Robert has confirmed that the display problem is applicable, irrespective of the type of database. Chnaging title to reflect that. Could reproduce it on OpenSUSE 15.3 64bit rpm Linux. Might be it is a duplicate of https://bugs.documentfoundation.org/show_bug.cgi?id=152538 which might be a duplicate of https://bugs.documentfoundation.org/show_bug.cgi?id=152381 Couldn't test it, because there are no daily builds available for LO 7.5 on https://dev-builds.libreoffice.org/daily/ Could you give a try with a build which includes this commit: https://cgit.freedesktop.org/libreoffice/core/commit/?id=0390479ccf454cd87997fe97d640caf9f8c45a13 ? (In reply to Julien Nabet from comment #13) > Could you give a try with a build which includes this commit: > https://cgit.freedesktop.org/libreoffice/core/commit/ > ?id=0390479ccf454cd87997fe97d640caf9f8c45a13 > ? Hi Julien, Seems to be working OK in Version: 7.6.0.0.alpha0+ (AARCH64) / LibreOffice Community Build ID: ad387d5b984c6666906505d25685065f710ed55d CPU threads: 8; OS: Mac OS X 13.0.1; UI render: default; VCL: osx Locale: fr-FR (fr_FR.UTF-8); UI: en-US Calc: threaded do we need to wait for the next 7.5 rc ? (In reply to Alex Thurgood from comment #14) > ... > do we need to wait for the next 7.5 rc ? Yes, it seems there's no beta 2 according to https://wiki.documentfoundation.org/ReleasePlan/7.5. 7.5.0 RC1 should be released between 19/12 and 25/12 (still according to the quoted link). Seems to be working OK now in 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 |