JDBC driver DatabaseMetadata.getTables returns all tables irrespective of tablename parameter it is passed
mainstreet439 opened this issue · 1 comments
mainstreet439 commented
as originally noted at https://community.mapd.com/t/jdbc-driver-databasemetadata-gettables-returns-all-tables-irrespective-of-tablename-parameter-it-is-passed/926
MAPD version 3.3.1-20171108-32e7bcc
The following method call should return 0 rows because the specified tablename parameter does not correspond to a valid table/view. The method will return a Resultset of all objects because it fails to filter the response to specified tablename.
DatabaseMetadata dbMeta = dbConnection.getMetaData();
String [] tableTypes = { “SYNONYM”, “TABLE”, “VIEW” };
ResultSet tables = dbMeta.getTables( null, null, “NOSUCHTABLE”, tableTypes);
billmaimone commented
Note related enhancement heavyai/heavydb#138