[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 ]

Steven Hawkins resolved TEIID-5256.
-----------------------------------
    Fix Version/s: 10.1.1
                   10.0.4
                   10.2
       Resolution: Done


The collection logic was using the wrong instanceof check to locate the metadata id of procedures.  This has been corrected.

> 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
>             Fix For: 10.1.1, 10.0.4, 10.2
>
>
> 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)