[teiid-issues] [JBoss JIRA] (TEIID-4565) Add objects table to system schema

[Tom Johnston (JIRA)]

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

Tom Johnston edited comment on TEIID-4565 at 11/14/16 2:23 PM:
---------------------------------------------------------------

I would see that the objects system table would likely NOT include properties but their associated properties would be joinable to this new table... similar to my original use case query.

Searching for objects by name (and/or/ their potential descriptions) is the driving force.




was (Author: virtualdatabase):
I would see that the objects system table would like include properties but their associated properties would be joinable to this new table... similar to my original use case query.

Searching for objects by name (and/or/ their potential descriptions) is the driving force.



> Add objects table to system schema
> ----------------------------------
>
>                 Key: TEIID-4565
>                 URL: https://issues.jboss.org/browse/TEIID-4565
>             Project: Teiid
>          Issue Type: Feature Request
>            Reporter: Tom Johnston
>            Assignee: Steven Hawkins
>
> The addition of a objects table  would make it simpler to join to when extensions are implemented.
> An example might be something similar to this query:
> select sysObjects.*
> from (
> select t.schemaName as Parent,t.name, t.uid ,'Table' as ObjectType
> from sys.tables t
> where schemaName not in (select distinct(schemaName) from "SYS"."Tables" where isSystem = true)
> UNION
> select c.tableName as Parent,c.name, c.uid,'Column' as ObjectType
> from sys.columns c
> where schemaName not in (select distinct(schemaName) from "SYS"."Tables" where isSystem = true)
> UNION
> select null as Parent,e.Value as Name,e.uid,'Property' as ObjectType
> from sys.properties as e) as SysObjects



--
This message was sent by Atlassian JIRA
(v7.2.3#72005)