[teiid-issues] [JBoss JIRA] (TEIID-4730) Problem with Import VDB with Materialized View (external)
[
https://issues.jboss.org/browse/TEIID-4730?page=com.atlassian.jira.plugin...
]
Ramesh Reddy commented on TEIID-4730:
-------------------------------------
To redo above table, if user query is going against the VDBs listed it will be
||Scope||X.1||Y.1||X.2||
|NONE|A-own|C-own|A-own,B-own,C-own|
|SHARED|A-own|C-Shared w/Y.1|A-own,B-own,C-Shared from Y.1|
|FULLY_SHARED|A-Shared with/X.*|C-Shared w/Y.1|A-Shared with/ X.*,B-Shared w/X.*,C-Shared
from/Y.1|
Since we agree that NONE is corner case we can ignore that for now. The default will be
SHARED. Do you want to re-purpose old names (VDB-shared, SCHEMA-fullyshared) or make a
breaking change as we are removing the NONE anyway?
Problem with Import VDB with Materialized View (external)
---------------------------------------------------------
Key: TEIID-4730
URL: https://issues.jboss.org/browse/TEIID-4730
Project: Teiid
Issue Type: Bug
Components: Common
Affects Versions: 9.1.2
Environment: * Teiid 9.1.2
* CentOs 7
* WildFly 10
Reporter: Pedro Inácio
Assignee: Ramesh Reddy
Labels: CR1
Fix For: 9.2
Attachments: externalMaterializationOrderProblem-vdb.xml, numberingPlan-vdb.xml
Having defined a VDB which contains a Model that has External Materialization, when
importing this VDB into another that also uses External Materialization, Teiid Server is
searching in the wrong place for the view status.
Example:
..
<import-vdb name="CountryServiceListVDB" version="1"
import-data-policies="true"/>
...
<model name="MyView" type="VIRTUAL">
...
SELECT cns,
country_code
FROM NumberingPlan.numbering_plan;
....
</metadata>
</model>
*NumberingPlan.numbering_plan is defined in the imported VDB, and is also Materialized.*
*Warning in Logs: *
17:51:45,161 WARN [org.teiid.MATVIEWS] (Worker8_QueryProcessorQueue10653) n9M6de3y5xHM
org.teiid.jdbc.TeiidSQLException: TEIID30328 Unable to evaluate (SELECT
mvstatus('NumberingPlan', 'numbering_plan', Valid, LoadState,
'THROW_EXCEPTION') FROM (SELECT 1) AS x LEFT OUTER JOIN
NumberingPlanMaterialized.status ON VDBName =
'ExternalMaterializationOrderProblem' AND VDBVersion = '1' AND SchemaName
= 'NumberingPlan' AND Name = 'numbering_plan' LIMIT 2): TEIID30328 Unable
to evaluate mvstatus('NumberingPlan', 'numbering_plan', Valid, LoadState,
'THROW_EXCEPTION'): TEIID30384 Error while evaluating function mvstatus
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)