Uploaded image for project: 'Apache Trafodion'
  1. Apache Trafodion
  2. TRAFODION-3311

Trafodion to start transactions for select statements with FOR UPDATE

    XMLWordPrintableJSON

    Details

    • Type: Improvement
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: sql-general
    • Labels:
      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

            Activity

              People

              • Assignee:
                selvag Selvaganesan Govindarajan
                Reporter:
                selvag Selvaganesan Govindarajan
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:

                  Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 1h 20m
                  1h 20m