[CONJ-1100] Be able to filter system tables and views Created: 2023-08-06  Updated: 2023-08-07

Status: Open
Project: MariaDB Connector/J
Component/s: metadata
Affects Version/s: 3.1.4
Fix Version/s: None

Type: New Feature Priority: Major
Reporter: prrvchr Assignee: Diego Dupin
Resolution: Unresolved Votes: 0
Labels: Compatibility
Environment:

LibreOffice / OpenOffice Base with jdbcDriverOOo[1] extension.

[1] https://prrvchr.github.io/jdbcDriverOOo/


 Description   

To list the tables and views offered by a connection, LibreOffice and / or OpenOffice Base uses the method DatabaseMetaData.getTables().

This method offers a fourth parameter that allows you to filter the tables according to their type.
The documentation says about it: a list of table types, which must be from the list of table types returned from getTableTypes(),to include; null returns all types.

The values returned by the getTableTypes() method are not precise enough (or numerous) to be able to filter the system tables and views (tables and views contained in information_schema, mysql, performance_schema and sys) from the tables and views of the user.

This does not allow to list or not the system tables and views to the user, according to his choice, in the graphic interface of LibreOffice / OpenOffice Base.

 Comments   
Comment by prrvchr [ 2023-08-07 ]

It turns out that all the views contained in the information_schema catalog are easily filterable since they are all of the type: SYSTEM VIEW
So I well able to display or not the information_schema catalog. I updated the extension jdbcDriverOOo to fix this error.

So I'm not sure that the sys, mysql and performance_schema catalogs should be considered as system tables or views?

Generated at Thu Feb 08 03:20:37 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.