[
https://issues.jboss.org/browse/TEIID-3018?page=com.atlassian.jira.plugin...
]
Steven Hawkins resolved TEIID-3018.
-----------------------------------
Fix Version/s: 8.8
Resolution: Done
Added VIEWS and STOREDPROCEDURES tables -
https://docs.jboss.org/author/display/TEIID/System+Tables
This information was not yet added to the SYS TABLE/PROCEDURE since we already established
a precedent with TRIGGERS and non-public information, and it would require api changes for
us to better calculate the permissions to see the definition body (since we don't
minimize projection down to the system tables, we'd currently have to compute all
columns).
We also left the informational column as "body" rather than
"definition" since it will only contain the statement/query expression/etc.
rather than the full DDL declaration - this is largely due to how we store the information
on the metadata object and don't want to incur the overhead of the DDL generation. It
may be necessary at some point though to provide the entire statement.
Reflect view transformation sql into SYSTEM schema
--------------------------------------------------
Key: TEIID-3018
URL:
https://issues.jboss.org/browse/TEIID-3018
Project: Teiid
Issue Type: Feature Request
Security Level: Public(Everyone can see)
Reporter: Mark Addleman
Assignee: Steven Hawkins
Fix For: 8.8
It would nice to reflect view transformation SQL in the SYSTEM schema
See
https://community.jboss.org/message/879519?et=watches.email.thread#879519 for more
detail
--
This message was sent by Atlassian JIRA
(v6.2.6#6264)