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

Sysadmin Usage table doesn't track usage of procedures

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Major
    • 10.1.1, 10.0.4, 10.2
    • 8.12.11.6_4
    • Server
    • None
      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.

      Attachments

        Activity

          People

            rhn-engineering-shawkins Steven Hawkins
            jstastny@redhat.com Jan Stastny
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: