[
https://issues.apache.org/jira/browse/TRAFODION-3311?focusedWorklogId=247601&page=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-247601
]
ASF GitHub Bot logged work on TRAFODION-3311:
---------------------------------------------
Author: ASF GitHub Bot
Created on: 23/May/19 18:15
Start Date: 23/May/19 18:15
Worklog Time Spent: 10m
Work Description: selvaganesang 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-495327750
@anoopsharma00 Can you please review this change
----------------------------------------------------------------
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:
us...@infra.apache.org
Issue Time Tracking
-------------------
Worklog Id: (was: 247601)
Time Spent: 20m (was: 10m)
> 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: 20m
> 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)
