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:
[email protected]


With regards,
Apache Git Services

Reply via email to