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

[Steven Hawkins (JIRA)]

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

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)