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: libreoffice-bugs@lists.freedesktop.org Reporter: morc...@gmail.com 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.