[teiid-issues] [JBoss JIRA] Closed: (TEIID-1504) Internal Materialization does not honor the cache hint

Thu Mar 24 00:40:52 EDT 2011

     [ https://issues.jboss.org/browse/TEIID-1504?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Steven Hawkins closed TEIID-1504.
---------------------------------


> Internal Materialization does not honor the cache hint
> ------------------------------------------------------
>
>                 Key: TEIID-1504
>                 URL: https://issues.jboss.org/browse/TEIID-1504
>             Project: Teiid
>          Issue Type: Bug
>          Components: Query Engine
>    Affects Versions: 7.2
>            Reporter: Ramesh Reddy
>            Assignee: Steven Hawkins
>             Fix For: 7.4
>
>
> When a internal materialization is loaded with /*+ cache(pref_mem ttl:120000)*/ select * from view.g1, to does not refresh/flush the matview contents from memory after two minutes (120000). Upon inspecting the code, it looks like the Cache Hint is being on searched on the created temp table rather than the original query.

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira