[
https://issues.apache.org/jira/browse/TRAFODION-3311?focusedWorklogId=248157&page=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-248157
]
ASF GitHub Bot logged work on TRAFODION-3311:
---------------------------------------------
Author: ASF GitHub Bot
Created on: 24/May/19 17:23
Start Date: 24/May/19 17:23
Worklog Time Spent: 10m
Work Description: svarnau commented on issue #1843: [TRAFODION-3311]
Trafodion to start transactions for select statements with FOR UPDATE
URL: https://github.com/apache/trafodion/pull/1843#issuecomment-495718896
jenkins, retest -- trying new improved jenkins
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
[email protected]
Issue Time Tracking
-------------------
Worklog Id: (was: 248157)
Time Spent: 50m (was: 40m)
> 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
> Priority: Major
> Time Spent: 50m
> Remaining Estimate: 0h
>
> 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)
