Bug 144506 - LO Base PUBLIC schema table data window shows no records
Summary: LO Base PUBLIC schema table data window shows no records
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
(earliest affected) release
Hardware: All Windows (All)
: medium normal
Assignee: Not Assigned
Depends on:
Reported: 2021-09-14 23:59 UTC by Andrew Richardson
Modified: 2021-09-19 19:02 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

HSQLDB *.script file (redacted) (45.21 KB, text/plain)
2021-09-15 15:38 UTC, Andrew Richardson

Note You need to log in before you can comment on or make changes to this bug.
Description Andrew Richardson 2021-09-14 23:59:50 UTC
Our application uses HSQLDB database with external server process.  Using LO v7.2.0.4, clicking on a database table owned by PUBLIC shows no records.  Using a table owned by non-PUBLIC user shows all records as expected. 

Steps to Reproduce:
1. Open BASE app with tables owned by PUBLIC and non-PUBLIC users.
2. Open table owned by non-PUBLIC user, verify records displayed
3. Open table owned by PUBLIC user

Actual Results:
No records displayed

Expected Results:
All records displayed

Reproducible: Always

User Profile Reset: No

Additional Info:
Version: (x64) / LibreOffice Community
Build ID: 9a9c6381e3f7a62afc1329bd359cc48accb6435b
CPU threads: 12; OS: Windows 10.0 Build 19043; UI render: Skia/Raster; VCL: win
Locale: en-US (en_US); UI: en-US
Calc: CL
Comment 1 Alex Thurgood 2021-09-15 14:59:29 UTC
@Andrew : did this work correctly in a previous version of LibreOffice ?

How do you manage the difference between PUBLIC and non-PUBLIC users with regard to schema access ?

Can you give us an example of the connection string entered in the ODB JDBC driver configuration (obviously anonymizing any credentials or IP addresses, if any) ?
Can't test on macOS, unfortunately, changing the JAR for server access hoses the access to my existing embedded hsqldb files.
Comment 2 Andrew Richardson 2021-09-15 15:38:01 UTC
Created attachment 175035 [details]
HSQLDB *.script file (redacted)

The *.script for for the external database.
Note all persistent database objects are created under schema "PUBLIC". Temporary tables are under non-"PUBLIC" schemas.
Comment 3 Andrew Richardson 2021-09-15 15:45:44 UTC
@Alex, this bad behavior seems to have been introduced in the LO 7.x releases.  I cannot say exactly when it first appeared.   I developed our application using LO 6.x, and used the table record viewer extensively at this time.  Only on doming recent maintenance did I discover the bad behavior.

I have uploaded the HSQLDB *.script file so you can clearly see how the database objects are defined.  I suspect this my be related to object ownership/privilege's as the viewer works fine for objects owned by the current user.

Here is the JDBC connection string (using localhost instead of true IP address).

I see this problem on both Windows and MacOS environments.
Comment 4 Andrew Richardson 2021-09-17 21:45:49 UTC
I verified the following LO version does NOT have this issue, "PUBLIC" tables content is displayed as expected.  So something changed in the LO 7.x timeframe.

Version: (x64)
Build ID: 639b8ac485750d5696d7590a72ef1b496725cfb5
CPU threads: 12; OS: Windows 10.0 Build 19043; UI render: GL; VCL: win; 
Locale: en-US (en_US); UI-Language: en-US
Calc: threaded
Comment 5 patrick rall 2021-09-19 19:02:49 UTC
Quieres comprar Cama nido 135x190? ¡Encuentralos aquí! ✓ Todo en stock y envío rápido. Si buscas comprar muebles online al mejor precio, esta es tu tienda.