Selvaganesan Govindarajan created TRAFODION-3311:
----------------------------------------------------
Summary: Trafodion to start transactions for select statements
with FOR UPDATE
Key: TRAFODION-3311
URL: https://issues.apache.org/jira/browse/TRAFODION-3311
Project: Apache Trafodion
Issue Type: Improvement
Components: sql-general
Reporter: Selvaganesan Govindarajan
Assignee: Selvaganesan Govindarajan
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
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
