[CONJ-218] MariaDbDatabaseMetaData wrong TABLE_TYPE values in getTables() method Created: 2015-11-18  Updated: 2016-11-24  Resolved: 2016-05-05

Status: Closed
Project: MariaDB Connector/J
Component/s: Other
Affects Version/s: 1.3.0, 1.2.3
Fix Version/s: 1.4.5

Type: Bug Priority: Major
Reporter: Andrea Boriero Assignee: Diego Dupin
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Problem/Incident
causes CONJ-140 mariadb-java-client-1.1.8 shows no ta... Closed
causes CONJ-390 getTableTypes() should be consistent ... Closed

 Description   

the value of the ResultSet rowTABLE_TYPE is "BASE TABLE" instead of "TABLE".

 Comments   
Comment by Diego Dupin [ 2015-11-20 ]

According to my reading of JDBC , possible table type values are listed by DatabaseMetaData.getTableTypes().
The connector return the values

  • VIEW
  • SYSTEM VIEW
  • BASE TABLE

so DatabaseMetaData.getTables()
seems ok.
I am missreading something ?

Comment by Andrea Boriero [ 2015-11-20 ]

by the Jdbc documentation
TABLE_TYPE String => table type. Typical types are "TABLE", "VIEW", "SYSTEM TABLE", "GLOBAL TEMPORARY", "LOCAL TEMPORARY", "ALIAS", "SYNONYM".

but not "BASE TABLE" as the connector returns.

Comment by Diego Dupin [ 2016-05-05 ]

Will be release in version 1.4.5 thanks to leonardlin.
Commit: https://github.com/MariaDB/mariadb-connector-j/commit/747d265a55a92f2cc1124a8dfe5f94f830d6719b

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