ignite-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Vladimir Ozerov (JIRA)" <j...@apache.org>
Subject [jira] [Created] (IGNITE-6937) SQL TX: Support SELECT FOR UPDATE
Date Thu, 16 Nov 2017 14:48:00 GMT
Vladimir Ozerov created IGNITE-6937:

             Summary: SQL TX: Support SELECT FOR UPDATE
                 Key: IGNITE-6937
                 URL: https://issues.apache.org/jira/browse/IGNITE-6937
             Project: Ignite
          Issue Type: Task
      Security Level: Public (Viewable by anyone)
            Reporter: Vladimir Ozerov
             Fix For: 2.4

Normally in SQL world readers do not block writers. This is how our SELECT operations should
work by default. But we need to add a support for {{SELECT ... FOR UPDATE}} read mode, when
reader obtains exclusive lock on read. 

In this mode we lock entries as usual, but then send data back to the caller. First page can
be returned directly in our {{LockResponse}}. Next pages should be requested in separate requests.
With this approach {{SELECT ,,, FOR UPDATE}} will require only single round-trip to both lock
and read data in case of small updates.

This message was sent by Atlassian JIRA

View raw message