Details
-
Improvement
-
Status: Open
-
Major
-
Resolution: Unresolved
-
None
-
None
-
None
Description
Currently, Trafodion doesn't start transactions for any select statement. However the standard seem to imply the transaction needs to be started for select. See Ansi SQL 92 spec at http://www.contrib.andrew.cmu.edu/~shadow/sql/sql1992.txt
Trafodion uses MVCC for concurrency control and uses 2 phase commit to rollback conflicting transactions. To avoid many conflicting access, the transaction will be started with FOR UPDATE select statements
Attachments
Issue Links
- links to