Uploaded image for project: 'Teiid'
  1. Teiid
  2. TEIID-5256

Sysadmin Usage table doesn't track usage of procedures

    Details

    • Type: Bug
    • Status: Resolved (View Workflow)
    • Priority: Major
    • Resolution: Done
    • Affects Version/s: 8.12.11.6_4
    • Fix Version/s: 10.1.1, 10.0.4, 10.2
    • Component/s: Server
    • Labels:
      None
    • Steps to Reproduce:
      1. define a procedure in metadata
      2. define a view that calls the procedure
      3. check SYSADMIN.Usage table for contents

      Description

      I can't see a dependency of a view on either foreign or virtual procedures.

      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>
      

      I don't get any entries in SYSADMIN.Usage for both v4 and v7 views.

        Gliffy Diagrams

          Attachments

            Activity

              People

              • Assignee:
                shawkins Steven Hawkins
                Reporter:
                jstastny Jan Stastny
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: