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

Posted to codereview@trafodion.apache.org by GitBox <gi...@apache.org> on 2019/05/23 18:11:49 UTC

[GitHub] [trafodion] selvaganesang opened a new pull request #1843: [TRAFODION-3311] Trafodion to start transactions for select statements with FOR UPDATE

selvaganesang opened a new pull request #1843: [TRAFODION-3311] Trafodion to start transactions for select statements with FOR UPDATE
URL: https://github.com/apache/trafodion/pull/1843
 
 
   A CQD BEGIN_TRANSACTION_FOR_SELECT is introduced. This CQD can take a value 1,2 or any numeric value. Default is 1.
   
   1 - means mark the statement as transaction required if it is SELECT ... FOR UPDATE
   2 - means mark the statement as transaction required if it is SELECT statement with
       isolation other than SKIP CONFLICT ACCESS or READ UNCOMMITTED ACCESS.
   Any other value - SELECT statement is not marked to begin transaction.
   
   Trafodion always change the isolation level to READ COMMITTED ACCESS when it is
   READ UNCOMMITTED ACCESS.

----------------------------------------------------------------
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:
users@infra.apache.org


With regards,
Apache Git Services