Details
-
Enhancement
-
Resolution: Done
-
Major
-
8.12.11.6_4
-
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
- causes
-
TEIID-5517 Validation error with procedure call that has no result set
- Resolved