[teiid-issues] [JBoss JIRA] (TEIID-3831) For results set caching there should scope metadata for source tables/procedures
[
https://issues.jboss.org/browse/TEIID-3831?page=com.atlassian.jira.plugin...
]
Steven Hawkins commented on TEIID-3831:
---------------------------------------
The approach here will be to look for a DETERMINISM relational property on the schema /
model properties and on the non-temporary tables / procedures in the source queries (We
will already assume session scoping for temporary tables). We'll also allow the cache
directive scope to influence the determinism level. I'll see if it makes sense to add
a another way to set the scope programtically - it seems like we'll need that for
TEIID-3738
For results set caching there should scope metadata for source
tables/procedures
--------------------------------------------------------------------------------
Key: TEIID-3831
URL: https://issues.jboss.org/browse/TEIID-3831
Project: Teiid
Issue Type: Feature Request
Components: Query Engine
Reporter: Steven Hawkins
Assignee: Steven Hawkins
Fix For: 8.12.x
Functions have optional metadata to convey their determinism, which affects the caching
scope. However we don't have extension metadata or per execution metadata around
source queries (there is a scope field on a cache directive, but that only applies to
source level caching). We should provide a general mechanism so that users aren't
required to manually override the result set cache scope.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)