Uploaded image for project: 'Ignite'
  1. Ignite
  2. IGNITE-6937

SQL TX: Support SELECT FOR UPDATE

    XMLWordPrintableJSON

Details

    • Task
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • None
    • 2.7
    • cache, mvcc, sql
    • None

    Description

      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.

      Update SELECT statement syntax once this feature is supported:
      https://apacheignite-sql.readme.io/docs/select

      Attachments

        Issue Links

          is blocked by

          Task - A task that needs to be done. IGNITE-6935 SQL TX: Locking protocol for simple queries

          • Major - Major loss of function.
          • Closed
          Is contained by

          New Feature - A new feature of the product, which has yet to be developed. IGNITE-4191 SQL: support transactions

          • Major - Major loss of function.
          • Resolved

          Activity

            People

              al.psc Alexander Paschenko
              vozerov Vladimir Ozerov
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: