]
Steven Hawkins reopened TEIID-2754:
-----------------------------------
Reopening to update docs.
DatabaseMetaData reports views as tables
----------------------------------------
Key: TEIID-2754
URL:
https://issues.jboss.org/browse/TEIID-2754
Project: Teiid
Issue Type: Bug
Components: JDBC Driver, Query Engine
Affects Versions: 8.4
Reporter: Steven Hawkins
Assignee: Steven Hawkins
Fix For: 8.6, 9.0
The client already has a check for isVirtual & system table type to report a
"system view".
We have a "View" type in our metadata, but we generally do not use it in our
metadata code.
So we either could set the view type on the server (although this seems like a broad
change) or add another DatabaseMetaData check for isVirtual & table.