Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
3.1.4
-
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.
Attachments
Issue Links
- is caused by
-
MDEV-33910 Tables residing in catalogs mysql, performance_schema and sys are not SYSTEM TABLE
- Open
- is duplicated by
-
CONJ-1172 Tables residing in catalogs mysql, performance_schema and sys are not SYSTEM TABLE
- Closed