https://bugs.documentfoundation.org/show_bug.cgi?id=146673
Bug ID: 146673
Summary: H2 database can no longer be used with LibreOffice
Base facilities
Product: LibreOffice
Version: 6.4.7.2 release
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Base
Assignee: [email protected]
Reporter: [email protected]
Created attachment 177421
--> https://bugs.documentfoundation.org/attachment.cgi?id=177421&action=edit
UI showing only INFORMATION_SCHEMA tables but not others
After upgrading H2 from Ver.1.4.200 to Ver.2.0.206, I found that when
connecting to an H2 database, LibreOffice only displays INFORMATION_SCHEMA, and
does not show tables in the PUBLIC schema at all. As a result, I can only use
SELECT * FROM PUBLIC.PERSON either manually or in a query, but PUBLIC tables do
not appear anywhere in the GUI. It turns out that all tables of the BASE TABLE
type are being ignored by Libreoffice.
I reported it at https://github.com/h2database/h2database/issues/3351, and
heard back that it is a KNOWN ISSUE. @katzyn commented that "In the SQL
Standard there are various table types: BASE TABLE, VIEW, GLOBAL TEMPORARY,
LOCAL TEMPORARY, SYSTEM VERSIONED and database systems can also report other
types due to their own reasons."
Best,
M
--
You are receiving this mail because:
You are the assignee for the bug.
