You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@trafodion.apache.org by "Selvaganesan Govindarajan (JIRA)" <ji...@apache.org> on 2019/05/22 18:55:00 UTC

[jira] [Created] (TRAFODION-3311) Trafodion to start transactions for select statements with FOR UPDATE

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)