[
https://issues.jboss.org/browse/TEIID-5256?page=com.atlassian.jira.plugin...
]
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)