[teiid-issues] [JBoss JIRA] (TEIID-3042) expose dependency information in system tables

[Steven Hawkins (JIRA)]

     [ https://issues.jboss.org/browse/TEIID-3042?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Steven Hawkins resolved TEIID-3042.
-----------------------------------
    Resolution: Done


Added SYSADMIN.Usage.  Added a release note and a doc entry in the reference.  With 8.10 and recursive common table expressions you can see all dependencies to an object:

with u as (select uid, uses_uid from sysadmin.usage union select u.uid, sysadmin.usage.uses_uid from u, sysadmin.usage where u.uses_uid = sysadmin.usage.uid) select * from u

> expose dependency information in system tables
> ----------------------------------------------
>
>                 Key: TEIID-3042
>                 URL: https://issues.jboss.org/browse/TEIID-3042
>             Project: Teiid
>          Issue Type: Enhancement
>          Components: Query Engine
>            Reporter: Steven Hawkins
>            Assignee: Steven Hawkins
>             Fix For: 8.9
>
>
> We should expose additional view/procedure and even column information in terms of their dependencies.



--
This message was sent by Atlassian JIRA
(v6.3.8#6338)