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

Wed Nov 27 07:00:06 EST 2013

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

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

I should add though that we may need a backwards compatibility switch on the client in case someone would be relying on the reporting of views as tables.

> 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
>
>
> 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 is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira