Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

JDBC driver DatabaseMetadata.getTables returns all tables irrespective of tablename parameter it is passed #11

Open
mainstreet439 opened this issue Jan 6, 2018 · 1 comment

Comments

@mainstreet439
Copy link

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);

https://docs.oracle.com/javase/8/docs/api/java/sql/DatabaseMetaData.html#getTables-java.lang.String-java.lang.String-java.lang.String-java.lang.String:A-

@billmaimone
Copy link

Note related enhancement heavyai/heavydb#138

@randyzwitch randyzwitch transferred this issue from heavyai/heavydb Jun 21, 2019
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants