Uploaded image for project: 'MariaDB ColumnStore'
  1. MariaDB ColumnStore
  2. MCOL-736

transaction gets autocommitted if non columnstore query executed

    XMLWordPrintable

Details

    • 2017-12

    Description

      It looks like ColumnStore is not respecting a transaction ROLLBACK if, inside the transaction, we issue a SELECT statement.

      This happens regardless of the table engine (we tested with InnoDB and ColumStore).

      Test case:

      CREATE TABLE `countries_innodb` (
      `code` varchar(255) NOT NULL
      ) ENGINE=InnoDB;

      INSERT INTO countries_innodb (code) VALUES ('BR');

      BEGIN;
      INSERT INTO countries_innodb (code) VALUES ('UK');
      SELECT 'INSIDE TRANSACTION' AS '';
      ROLLBACK;

      – Result: two countries.
      – Expected: one country.
      SELECT * FROM countries_innodb;

      It looks like only the SELECT generates this behavior. If we INSERT or UPDATE multiple times, the transaction is still ROLL'd back fine.

      Current version: 1.0.9.

      Attachments

        Activity

          People

            dleeyh Daniel Lee (Inactive)
            dthompson David Thompson (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.