[teiid-issues] [JBoss JIRA] (TEIID-2754) DatabaseMetaData reports views as tables

[Steven Hawkins (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-2754?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13116452#comment-13116452 ] 

Steven Hawkins commented on TEIID-2754:
---------------------------------------

9.0 will change the default for reportAsViews to true.

> 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.



--
This message was sent by Atlassian JIRA
(v6.4.11#64026)