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

SQL: support transactions

    XMLWordPrintableJSON

Details

    • New Feature
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • None
    • 2.7
    • mvcc, sql
    • None
    • Docs Required

    Description

      Presently there is no any way to execute data modification statements and SELECT queries in a transactional fashion using our JDBC/ODBC drivers and DML API.

      This can be fully supported once MVCC is ready and released.

      Attachments

        Issue Links

          contains

          Bug - A problem which impairs or prevents the functions of the product. IGNITE-7306 Incorrect force key request processing when MVCC is enabled

          • Major - Major loss of function.
          • Resolved

          Bug - A problem which impairs or prevents the functions of the product. IGNITE-7314 Iterators could return multiple values of the same key when MVCC is enabled

          • Major - Major loss of function.
          • Resolved

          Bug - A problem which impairs or prevents the functions of the product. IGNITE-7321 DML operation hangs in case exception is thrown from DHT enlist future

          • Major - Major loss of function.
          • Resolved

          Bug - A problem which impairs or prevents the functions of the product. IGNITE-7342 SQL TX: Fix checking whether currently updating row was updated after it pass query filter

          • Major - Major loss of function.
          • Resolved

          Bug - A problem which impairs or prevents the functions of the product. IGNITE-8031 MVCC TX: TxLog does not support partitions rebalance at the moment. We need to implement it.

          • Major - Major loss of function.
          • Resolved

          Bug - A problem which impairs or prevents the functions of the product. IGNITE-8164 SQL TX: JDBC driver meta data update.

          • Major - Major loss of function.
          • Resolved

          Bug - A problem which impairs or prevents the functions of the product. IGNITE-8371 MVCC TX: Force key request during rebalance may cause error on backups.

          • Major - Major loss of function.
          • Resolved

          Bug - A problem which impairs or prevents the functions of the product. IGNITE-8581 MVCC TX: data streamer support

          • Major - Major loss of function.
          • Resolved

          Bug - A problem which impairs or prevents the functions of the product. IGNITE-8914 SQL TX: Partition update counter fix.

          • Major - Major loss of function.
          • Resolved

          Bug - A problem which impairs or prevents the functions of the product. IGNITE-9233 MVCC SQL: False write conflicts on fast updates

          • Major - Major loss of function.
          • Resolved

          Bug - A problem which impairs or prevents the functions of the product. IGNITE-7267 Fix transactional inserts.

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. IGNITE-7271 UPDATE and DELETE statements do not work through thin JDBC work in MVCC mode

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. IGNITE-7280 SQL TX: improve JDBC test coverage

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. IGNITE-7302 SQL TX: Failed to query INFORMATIONAL_SCHEMA

          • Major - Major loss of function.
          • Closed

          New Feature - A new feature of the product, which has yet to be developed. IGNITE-3478 Multi-version concurrency control

          • Major - Major loss of function.
          • Closed

          Improvement - An improvement or enhancement to an existing feature or task. IGNITE-6888 Cache involved tables set for statement

          • Major - Major loss of function.
          • Resolved

          Improvement - An improvement or enhancement to an existing feature or task. IGNITE-8906 SQL TX: Immediate rollback for Near transactions during topology changing.

          • Major - Major loss of function.
          • Resolved

          Improvement - An improvement or enhancement to an existing feature or task. IGNITE-8982 SQL TX: reuse H2 connections

          • Major - Major loss of function.
          • Resolved

          Improvement - An improvement or enhancement to an existing feature or task. IGNITE-9125 MVCC SQL: Streaming SQL data load operations support

          • Major - Major loss of function.
          • Resolved

          Test - A new unit, integration or system test. IGNITE-7249 SQL TX: Commit/rollback active TX before DDL statement processing

          • Major - Major loss of function.
          • Closed

          Task - A task that needs to be done. IGNITE-7973 TX SQL: plain INSERT should not be broadcasted to all data nodes

          • Critical - Crashes, loss of data, severe memory leak.
          • Resolved

          Task - A task that needs to be done. IGNITE-4193 SQL TX: ODBC driver support

          • Major - Major loss of function.
          • Resolved

          Task - A task that needs to be done. IGNITE-5936 Cleanup of not needed and committed versions

          • Major - Major loss of function.
          • Resolved

          Task - A task that needs to be done. IGNITE-6353 Integrate mvcc support in scan query protocol

          • Major - Major loss of function.
          • Resolved

          Task - A task that needs to be done. IGNITE-6754 Support coordinator change while sql/tx is in progress

          • Major - Major loss of function.
          • Resolved

          Task - A task that needs to be done. IGNITE-6937 SQL TX: Support SELECT FOR UPDATE

          • Major - Major loss of function.
          • Resolved

          Task - A task that needs to be done. IGNITE-6938 SQL TX: Reads should see own's previous writes

          • Major - Major loss of function.
          • Resolved

          Task - A task that needs to be done. IGNITE-7185 SQL TX: Updates during rebalancing.

          • Major - Major loss of function.
          • Resolved

          Task - A task that needs to be done. IGNITE-7186 SQL TX: Replicated caches support

          • Major - Major loss of function.
          • Resolved

          Task - A task that needs to be done. IGNITE-7266 SQL TX: Joins return duplicated result when MVCC is disabled

          • Major - Major loss of function.
          • Resolved

          Task - A task that needs to be done. IGNITE-7300 Allow expressions in SQL INSERTs within transactions

          • Major - Major loss of function.
          • Resolved

          Task - A task that needs to be done. IGNITE-7313 Recovery process doesn't propagate MVCC version

          • Major - Major loss of function.
          • Resolved

          Task - A task that needs to be done. IGNITE-7583 SQL TX: Change secondary indexes structure

          • Major - Major loss of function.
          • Resolved

          Task - A task that needs to be done. IGNITE-7604 SQL TX: Allow DML operations with reducer

          • Major - Major loss of function.
          • Resolved

          Task - A task that needs to be done. IGNITE-7748 MVCC TX Implement TxLog related stuctures

          • Major - Major loss of function.
          • Resolved

          Task - A task that needs to be done. IGNITE-7806 SQL TX: Backup update protocol

          • Major - Major loss of function.
          • Resolved

          Task - A task that needs to be done. IGNITE-7807 SQL TX: Store lock info inside tuples

          • Major - Major loss of function.
          • Resolved

          Task - A task that needs to be done. IGNITE-7911 TX SQL: restrict usages of unsupported APIs and configuration parameters

          • Major - Major loss of function.
          • Resolved

          Task - A task that needs to be done. IGNITE-7975 SQL TX: allow batch inserts

          • Major - Major loss of function.
          • Resolved

          Task - A task that needs to be done. IGNITE-8032 Fix issues within TX DML reducer.

          • Major - Major loss of function.
          • Resolved

          Task - A task that needs to be done. IGNITE-8050 Throw a meaningful exception when user issues TX SQL keyword with MVCC turned off

          • Major - Major loss of function.
          • Resolved

          Task - A task that needs to be done. IGNITE-8206 SQL TX: Rewrite MvccCursor

          • Major - Major loss of function.
          • Resolved

          Task - A task that needs to be done. IGNITE-8207 SQL TX: Cleanup own previous changes on update

          • Major - Major loss of function.
          • Resolved

          Task - A task that needs to be done. IGNITE-8208 SQL TX: Do not check with TxLog rows having the same insert and update versions

          • Major - Major loss of function.
          • Resolved

          Task - A task that needs to be done. IGNITE-8239 SQL TX: Do not use skipReducer flag for MVCC DML requests

          • Major - Major loss of function.
          • Resolved

          Task - A task that needs to be done. IGNITE-4192 SQL TX: JDBC driver support

          • Major - Major loss of function.
          • Closed

          Task - A task that needs to be done. IGNITE-5937 Mvcc data structure for SQL queries

          • Major - Major loss of function.
          • Closed

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

          • Major - Major loss of function.
          • Closed

          Task - A task that needs to be done. IGNITE-6936 SQL TX: Implement commit protocol

          • Major - Major loss of function.
          • Closed

          Task - A task that needs to be done. IGNITE-7183 SQL TX: Implicit transactions

          • Major - Major loss of function.
          • Closed

          Task - A task that needs to be done. IGNITE-7184 SQL TX: Support optimistic transactions

          • Major - Major loss of function.
          • Closed

          Task - A task that needs to be done. IGNITE-7261 SQL TX: SELECT and DML operations must share the same MVCC version

          • Major - Major loss of function.
          • Closed

          Task - A task that needs to be done. IGNITE-7272 SQL TX: incorrect row MVCC version override during CREATE INDEX

          • Major - Major loss of function.
          • Closed
          is related to

          Task - A task that needs to be done. IGNITE-7259 GridIndexRebuildSelfTest hangs

          • Major - Major loss of function.
          • Closed
          relates to

          Bug - A problem which impairs or prevents the functions of the product. IGNITE-8318 MVCC TX: Scan query call throws an exception when it is mixed with Key-Value API in the same transaction.

          • Major - Major loss of function.
          • Closed

          Task - A task that needs to be done. IGNITE-9435 Document MVCC

          • Major - Major loss of function.
          • Resolved
          links to

          Web Link GitHub Pull Request #3220

          Web Link TC

          Wiki Page

          Wiki Page Loading...

          Activity

            People

              Unassigned Unassigned
              dmagda Denis A. Magda
              Votes:
              14 Vote for this issue
              Watchers:
              12 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: