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 (v6.4.14#64029)