[teiid-issues] [JBoss JIRA] (TEIID-5220) Add support for information_schema namespace
Salvatore R. (Jira)
issues at jboss.org
Mon Aug 19 05:31:00 EDT 2019
[ https://issues.jboss.org/browse/TEIID-5220?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13772285#comment-13772285 ]
Salvatore R. edited comment on TEIID-5220 at 8/19/19 5:30 AM:
--------------------------------------------------------------
[~shawkins] I have another question about the current implementation, please.
Accordingly to the PostgreSQL docs mentioned in the description, VIEWS and TABLES should return respectively:
- TABLES: all tables and views
- VIEWS: only views
but it seems that the current implementation in Teiid returns both tables and views for information_schema.TABLES but only tables (and not views) in information_schema.VIEWS. Looking at the code, the view transformation is indeed defined as:
{code:sql}select vdbname, schemaName, name, 'NONE', case when SupportsUpdates then 'YES' else 'NO' end from sys.tables where IsPhysical{code}
Is there any reason why it is implemented this way or is it maybe a bug? :)
was (Author: fox123):
[~shawkins] I have another question about the current implementation, please.
Accordingly to the PostgreSQL docs mentioned in the description, VIEWS and TABLES should return respectively:
- TABLES: all tables and views
- VIEWS: only views
but it seems that the current implementation in Teiid returns both tables and views for information_schema.TABLES but only tables (and not views) in information_schema.VIEWS. Looking at the code, the view transformation is indeed defined as:
{code:sql}select vdbname, schemaName, name, 'NONE', case when SupportsUpdates then 'YES' else 'NO' end from sys.tables where IsPhysical{code}.
Is there any reason why it is implemented or is it maybe a bug? :)
> Add support for information_schema namespace
> --------------------------------------------
>
> Key: TEIID-5220
> URL: https://issues.jboss.org/browse/TEIID-5220
> Project: Teiid
> Issue Type: Bug
> Components: ODBC, Query Engine
> Reporter: Divyesh Vallabh
> Assignee: Steven Hawkins
> Priority: Major
> Fix For: 10.3, 10.2.1
>
>
> The npgsql provider uses the the infomation_schema namespace to query meta information for tables and views.
> Add support for information_schema.tables (
> https://www.postgresql.org/docs/10/static/infoschema-tables.html) to teiid
> Add support for information_schema.views (
> https://www.postgresql.org/docs/10/static/infoschema-views.html) to teiid
> Add support for information_schema.columns (
> https://www.postgresql.org/docs/10/static/infoschema-columns.html) to teiid
--
This message was sent by Atlassian Jira
(v7.12.1#712002)
More information about the teiid-issues
mailing list