[TRAFODION-3311] Trafodion to start transactions for select statements with FOR UPDATE

• Type: Improvement
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Component/s: sql-general
• Assignee: Selvaganesan Govindarajan
• Reporter: Selvaganesan Govindarajan
• Created: 22/May/19 18:54
• Updated: 29/May/19 02:36

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 

Issue Links

• links to: GitHub Pull Request #1843