[
https://issues.jboss.org/browse/TEIID-3042?page=com.atlassian.jira.plugin...
]
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)