[teiid-issues] [JBoss JIRA] Updated: (TEIID-942) Make ad hoc temp tables transactional

[Steven Hawkins (JIRA)]

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

Steven Hawkins updated TEIID-942:
---------------------------------

    Fix Version/s: 7.6
                       (was: 9.0)


Bumping up to 7.6.

The transactional behavior prior in 7.5 and older would be:
internal materialized views - READ_COMMITTED
session level temp tables - non-transactional

For 7.6 I would propose supporting:
internal materialized views - READ_COMMITTED/SERIALIZABLE
session level temp tables - READ_UNCOMMITTED
procedure blocks - SERIALIZABLE (since the are guaranteed to be accessed by a single thread/session and have serial transaction usage)

session level temp tables if accessed by non-concurrent transactions would effectively be SERIALIZABLE as well.






> Make ad hoc temp tables transactional
> -------------------------------------
>
>                 Key: TEIID-942
>                 URL: https://issues.jboss.org/browse/TEIID-942
>             Project: Teiid
>          Issue Type: Feature Request
>          Components: Query Engine
>    Affects Versions: 7.1
>            Reporter: Steven Hawkins
>            Assignee: Steven Hawkins
>             Fix For: 7.6
>
>
> Ad hoc temp tables are scoped to the session and should be transactional.

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