Details
-
Bug
-
Resolution: Done
-
Major
-
7.1
-
None
Description
The refreshMatView works as expected in a single node environment with 'teiid-cache-manager-jboss-beans-rename-me.xml'. Still in a single node environment, that function no longer refreshes the data with "teiid-cache-manager-jboss-beans.xml" enabled.
To recreate:
1. Start up an EDS instance with a vdb deployed which has an internal materialized view (IMV).
2. Query SYSADMIN.MATVIEWS and verify LoadState = "NEEDS_LOADING"
3. Query the IMV to populate the cache.
4. Query SYSADMIN.MATVIEWS and verify LoadState = "LOADED". Note the value of the 'Updated' column
5. run "CALL SYSADMIN.refreshMatView('view name',false)"
6. Query SYSADMIN.MATVIEWS and verify LoadState = "LOADED". Note the value of the 'Updated' column
7. Query the IMV to see if it pulls from the source or cache
Expected results: Steps 3 and 5 should trigger queries to the source. Step 7 should pull from the cache without going back to the source.