https://bugs.documentfoundation.org/show_bug.cgi?id=146673
--- Comment #7 from Evgenij Ryazanov <[email protected]> --- Hello! This issue doesn't look like being related with schema name or something like it. Tables from INFORMATION_SCHEMA are also missing, as you can see on screenshot here: https://github.com/h2database/h2database/issues/3351 LibreOffice can see only views, but this schema also contains various tables, the complete list of tables and views in this schema is here: https://h2database.com/html/systemtables.html#information_schema_tables DatabaseMetaData.getTables() in H2 returns the same type of tables as listed in INFORMATION_SCHEMA.TABLES.TABLE_TYPE. H2 1.4 (incorrectly) returns TABLE, TABLE LINK, SYSTEM TABLE, or EXTERNAL for tables and VIEW for views in this table. H2 2.0 by default returns BASE TABLE, GLOBAL TEMPORARY, or LOCAL TEMPORARY for tables and VIEW for views as required by SQL/Schemata part of the SQL Standard (Standard also has SYSTEM VERSIONED, but H2 2.0 doesn't support these tables). DatabaseMetaData.getTableTypes() in both H2 1.4 and H2 2.0 correctly reports available table types. JDBC (unlike the SQL Standard) doesn't require any specific table types, it only provides some possible examples and they look like being collected from few database systems with their vendor-specific extensions like SYNONYM. I think LibreOffice should support tables of any types reported by getTableTypes(). Currently it somehow filters out tables with BASE TABLE type and possibly other valid types, but accepts TABLE and VIEW types. Such implementation doesn't look like being correct, because there are various possible compliant with JDBC types. -- You are receiving this mail because: You are the assignee for the bug.
