[teiid-issues] [JBoss JIRA] (TEIID-3018) Reflect view transformation sql into SYSTEM schema

[ 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. -- This message was sent by Atlassian JIRA (v6.2.6#6264)