Anoop Sharma created TRAFODION-2834:
---------------------------------------
Summary: Streamline supported xn access modes
Key: TRAFODION-2834
URL: https://issues.apache.org/jira/browse/TRAFODION-2834
Project: Apache Trafodion
Issue Type: Improvement
Reporter: Anoop Sharma
Assignee: Anoop Sharma
Current traf code allows for the following xn modes in select queries:
1. for browse access
2. for stable access
3. for repeatable access
4. repeatable read access
5. for repeatable read access
6. serializable access
7. for serializable access
8. read uncommitted access
9. for read uncommitted access
10. read committed access
11. for read committed access
Internally, the only supported mode is ‘read committed+’ (slightly more than
true read committed).
In addition, ‘set transaction isolation level <mode>’ currently allows for #4,
#6, #8, #10.
Proposal:
Remove #1, #2, #3 as these are leftover options from previous product.
Return syntax error.
Return unsupported option error if #4, #5, #6, #7 are specified
as traf currently does not support repeatable or serialization
functionality
treat ‘read uncommitted’ as ‘read committed’
If no mode is specified, then treat it as ‘read committed’
With this change, only those modes that are internally supported will be
allowed.
If we do support some modes in future (repeatable, serializable), then those
restrictions will be lifted.
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
