[teiid-issues] [JBoss JIRA] (TEIID-3831) For results set caching there should scope metadata for source tables/procedures

[Steven Hawkins (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-3831?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13132937#comment-13132937 ] 

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)