[teiid-issues] [JBoss JIRA] Resolved: (TEIID-1253) Allow for cache scope to be set in the cache hint
[
https://jira.jboss.org/browse/TEIID-1253?page=com.atlassian.jira.plugin.s...
]
Ramesh Reddy resolved TEIID-1253.
---------------------------------
Resolution: Done
Added the "scope" flag to the Cache Hint. The BNF looks as
/* cache( ... [scope:(user|vdb|session)]?) */ select * from T1;
so user can define VDB scoped cache hint as
/* cache(scope:vdb) */ select * from T1;
Note that when a scope flag specified in the cache hint, then it will override the
computed scope flag based on query by the query engine. The results will be then cached
using the provided scope.
Allow for cache scope to be set in the cache hint
-------------------------------------------------
Key: TEIID-1253
URL: https://jira.jboss.org/browse/TEIID-1253
Project: Teiid
Issue Type: Feature Request
Affects Versions: 7.1
Reporter: Steven Hawkins
Assignee: Ramesh Reddy
Fix For: 7.3
In some circumstances the cache scope may need to be set in the cache hint to override
the detected scope. The cache hint would need something like scope:{session|user|global}
and we would need to ensure that the analysis log / debug log includes sufficient
information to see what scope is in use.
--
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira