[teiid-issues] [JBoss JIRA] (TEIID-5256) Sysadmin Usage table doesn't track usage of procedures

[Steven Hawkins (JIRA)]

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

Work on TEIID-5256 started by Steven Hawkins.
---------------------------------------------
> Sysadmin Usage table doesn't track usage of procedures
> ------------------------------------------------------
>
>                 Key: TEIID-5256
>                 URL: https://issues.jboss.org/browse/TEIID-5256
>             Project: Teiid
>          Issue Type: Bug
>          Components: Server
>    Affects Versions: 8.12.x-6.4
>            Reporter: Jan Stastny
>            Assignee: Steven Hawkins
>
> I can't see a dependency of a view on either foreign or virtual procedures.
> {code:xml|title=vdb}
>     <model name="insideVirtualModel" type="VIRTUAL">
>         <metadata type="DDL">
>             <![CDATA[
>                 CREATE VIEW v1 (v1col string) AS SELECT 'a' UNION ALL SELECT 'b';
>                 CREATE VIEW v2 (v2col string) AS SELECT v1col||'b' FROM v1;
>                 CREATE VIRTUAL PROCEDURE p1() RETURNS (p1col string) AS
>                 BEGIN
>                     SELECT v2col FROM v2;
>                 END
>                 CREATE VIEW v7 (v7col string) AS SELECT p1.p1col FROM (CALL p1())AS p1;
>                 ]]>
>         </metadata>
>     </model>
>     <model name="dependentOnPhysicalModel" type="VIRTUAL">
>         <metadata type="DDL">
>             <![CDATA[
>                 CREATE VIEW v3 (v3col string) AS SELECT t1col||'b' FROM t1;
>                 CREATE VIEW v4 (v4col string) AS SELECT p.p2col FROM (CALL p2(1)) AS p;
>             ]]>
>         </metadata>
>     </model>
> {code}
> I don't get any entries in SYSADMIN.Usage for both v4 and v7 views.



--
This message was sent by Atlassian JIRA
(v7.5.0#75005)