[ https://issues.jboss.org/browse/TEIID-2584?page=com.atlassian.jira.plugin... ] Ramesh Reddy commented on TEIID-2584: ------------------------------------- Per SteveH suggestion, added a "status" check such that when a materialization view is being accessed, it will issue a query like below to fetch the results of the materialized view {code} SELECT * FROM MAT_VIEW WHERE EXISTS (SELECT MVSTATUS(Valid, LoadState, OnErrorAction) FROM {statusTbl} WHERE VDBName=? AND VDBVersion=? AND SchemaName=? AND viewName = ?) {code} Where "MVSTATUS" is a system function, which based on the validity and LoadStatus carries out the "action" defined by OnErrorAction. Currently it code allows THROW_EXCEPTION, IGNORE actions. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira