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.

Sign up for GitHub

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

Jump to bottom

JDBC driver DatabaseMetadata.getTables method returns views as type TABLE #9

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

JDBC driver DatabaseMetadata.getTables method returns views as type TABLE #9

mainstreet439 opened this issue Jan 6, 2018 · 1 comment

Comments

@mainstreet439
Copy link

originally noted as https://community.mapd.com/t/jdbc-driver-databasemetadata-gettables-method-returns-views-as-type-table/924

When you call DatabaseMetadata.getTables it will return a TABLE_TYPE of TABLE for views created in MAPD.

null,null,TABLE1,TABLE,null,null,null,null,null,null
null,null,VIEW1,TABLE,null,null,null,null,null,null

Similarly, DatabaseMetadata.getTableTypes only returns TABLE as a type.

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-

https://docs.oracle.com/javase/8/docs/api/java/sql/DatabaseMetaData.html#getTableTypes--
@billmaimone
Copy link

Note heavyai/heavydb@f3de0a6, differentiating between tables & views without inefficient call to get table details, so possible fix path.

cdessanti referenced this issue in cdessanti/mapd-core Feb 25, 2019
@cdessanti
Correction of issues #311, #310, #164, #163
7783490 
Correction of various issues and a little enanchement on getTables method, that, if schemaPattern is specified and there is a match with current connected user, returns only the tables and the views of current user.
cdessanti referenced this issue in cdessanti/mapd-core Feb 25, 2019
@cdessanti
Revert "Correction of issues #311, #310, #164, #163"
e819507 
This reverts commit 7783490.
cdessanti referenced this issue in cdessanti/mapd-core Feb 25, 2019
@cdessanti
Revert "Revert "Correction of issues #311, #310, #164, #163""
93b3409 
This reverts commit e819507.
cdessanti referenced this issue in cdessanti/mapd-core Feb 25, 2019
@cdessanti
Correction of issues #311, #310, #164, #163
d8307c8 
Correction of various issues and a little enanchement on getTables method, that, if schemaPattern is specified and there is a match with current connected user, returns only the tables and the views of current user.
cdessanti referenced this issue in cdessanti/mapd-core Feb 25, 2019
@cdessanti
Correction of issues #311, #310, #164, #163
5e12b30 
Correction of various issues and a little enanchement on getTables method, that, if schemaPattern is specified and there is a match with current connected user, returns only the tables and the views of current user.
cdessanti referenced this issue in cdessanti/mapd-core Feb 25, 2019
@cdessanti
Correction of issues #311, #310, #164, #163
75d86ec 
Correction of various issues and a little enanchement on getTables method, that, if schemaPattern is specified and there is a match with current connected user, returns only the tables and the views of current user.
cdessanti referenced this issue in cdessanti/mapd-core Feb 25, 2019
@cdessanti
Correction of issues #311, #310, #164, #163
62abe99 
Correction of various issues and a little enanchement on getTables method, that, if schemaPattern is specified and there is a match with current connected user, returns only the tables and the views of current user.
cdessanti referenced this issue in cdessanti/mapd-core Feb 25, 2019
@cdessanti
Correction of issues #311, #310, #164, #163
14387d8 
Correction of various issues and a little enanchement on getTables method, that, if schemaPattern is specified and there is a match with current connected user, returns only the tables and the views of current user.
cdessanti referenced this issue in cdessanti/mapd-core Feb 25, 2019
@cdessanti
correction of issues #163 #164 #310 #311
95c3e12 
This patch correct the issues #163 #164 #310 #311

The new implementation of getPrimaryKey method makes the driver compatible with Tableau 2019.1

Now the GetTables method return a list of table and views of currenct database if the schemaPattern is null or it matches the current database name
cdessanti referenced this issue in cdessanti/mapd-core Feb 25, 2019
@cdessanti
correction of issues #163 #164 #310 #311
4798c69 
This patch correct the issues #163 #164 #310 #311

The new implementation of getPrimaryKey method makes the driver compatible with Tableau 2019.1

Now the GetTables method return a list of table and views of currenct database if the schemaPattern is null or it matches the current database name
cdessanti referenced this issue in cdessanti/mapd-core Feb 28, 2019
@cdessanti
fix for issues #163 #310 #311
1c03493 
Fixes and enanchements for getTables, getImportedKeys, getExportedKeys. getPrimaryKeys.

Added the helper method getEmptyResultSetWithDesc
dwayneberry referenced this issue in heavyai/heavydb Apr 1, 2019
@cdessanti @dwayneberry
fix for issues #163 #310 #311
c54635f 
Fixes and enanchements for getTables, getImportedKeys, getExportedKeys. getPrimaryKeys.

Added the helper method getEmptyResultSetWithDesc
@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
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@billmaimone @mainstreet439