Hi Evgenij,
All databases use a different type in order to be able to filter system
tables, well all those that I manage in Base (HsqlDB, SQLite xerial, Derby,
PostgreSQL pgJDBC, Firebird Jaybird).
MariaDB connector/J gives system tables only for those located in the
information_schema.
It seems to me that if this is used by so many databases it is because it
is the simplest solution to provide such functionality.
I already have specific code for H2 which returns TABLE BASE instead of
TABLE and I had to set up mock ResultSet on the
DatabaseMetaData.getTypeInfos() and DatabaseMetaData.getTablePrivileges()
methods for databases returning non-compliant resultsets.
Unfortunately for this specific problem I can't do much since we are unable
to filter the tables due to lack of differentiation of types... For this
specific functionality I only depend on the underlying implementation.
Le mardi 9 avril 2024 à 16:57:51 UTC+2, Evgenij Ryazanov a écrit :
> Hi!
>
> > Why H2 does not use SYSTEM TABLE in the table types returned by the
> DatabaseMetaData.getTableTypes() method
>
> Because there is no such thing as system table in the SQL Standard. JDBC
> metadata is an entirely unreliable thing, you can't construct anything
> serious on top of it.
>
> There is a difference between type of a table (base table, view, local
> temporary table, global temporary table and so on) and its actual
> implementation.
>
> In modern versions of H2 you can use a query like that to distinguish
> user-defined tables and views from system tables and views:
>
> SELECT *, DB_OBJECT_ID('TABLE', TABLE_SCHEMA, TABLE_NAME) < 0 IS_SYSTEM
> FROM INFORMATION_SCHEMA.TABLES;
>
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to h2-database+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/h2-database/ba2b72d8-afdd-4515-bee8-b7f050bfd0b0n%40googlegroups.com.
