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

Sysadmin Usage table doesn't track column-level usage by a virtual procedure

    XMLWordPrintable

Details

    • Enhancement
    • Resolution: Done
    • Major
    • 11.0
    • 8.12.11.6_4
    • Query Engine
    • None

    Description

      There are not column-level dependencies in relation 'Virtual procedure column -> View/table column'.
      For this vdb:

      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>
      

      Following query:

      SYSADMIN.Usage query
      SELECT * FROM SYSADMIN.Usage WHERE VDBName='vdbname' AND SchemaName='insideVirtualModel' AND Name='p1' AND object_type='Column' AND Uses_object_type='Column'
      

      Attachments

        Issue Links

          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: